Formatting Guidelines
We standardize every record to Darwin Core (DwC), the international standard for biodiversity data. Your file doesn't need to already be in that format. It can have any number of columns; just make sure the ones below are included, using these exact header names. Any other columns you upload are kept too, not discarded.
Required on every row:
scientificName(e.g. Cardinalis cardinalis) orvernacularName(e.g. "Northern Cardinal") if you don't know the scientific nameeventDate— when it was observed, e.g.2024-06-28(a year alone, e.g.2024, is fine for older records)recordedBy— who observed itdecimalLatitude+decimalLongitude, orlocationRemarks— a text description confirming the record is on or near WashU's Danforth Campus (e.g. "near Brookings Hall")
Note: the upload form doesn't yet support setting a date, observer, or location once for the whole file. Please repeat these as their own column on every row, even if the value is the same throughout.
Optional, but useful if you have them:
organismQuantity— count of individuals (defaults to 1)organismID— only for individually marked or tracked organisms (a tag, band, collar, or accession number). Use the same value every time you record that same individual, so repeat observations can be linked. Leave blank for one-off sightings, and put a per-row record number insourceRecordIDinstead.occurrenceRemarks— free-text notes (e.g. "heard only", "flyover")vitality—alive,dead, orcannot be determinedlifeStage—adult,juvenile,larva,egg, etc.associatedMedia— photo or audio URLssourceRecordID/sourceURL— your own record ID or a link to the original list
This is one example of a well-formatted upload. Your file doesn't need to match it exactly:
| scientificName | vernacularName | eventDate | recordedBy | decimalLatitude | decimalLongitude | locationRemarks | organismQuantity | occurrenceRemarks | vitality | lifeStage | associatedMedia | sourceRecordID | sourceURL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cardinalis cardinalis | Northern Cardinal | 2024-06-28 | Jane Smith | 38.6491 | -90.3098 | 1 | Singing from the canopy; heard only | adult | JS-2024-001 | ||||
| Quercus rubra | Northern Red Oak | 2024-06-28 | Jane Smith | 38.6487 | -90.3105 | 1 | alive | JS-2024-002 | |||||
| American Robin | 2024-06-15 | Jane Smith | Near Brookings Hall, WashU Danforth Campus | 3 | Foraging on the lawn | adult | https://example.com/photo1.jpg | JS-2024-003 | |||||
| Acer saccharum | Sugar Maple | 1998 | Campus Ecology Survey | Danforth Campus, near the quad | 1 | Historical record; exact location approximate | dead | CES-1998-014 |