Occurrences Format File Definition for VERA

File Type: csv
Get From: /app/public/data/VERA/occurrences.txt
Field Seperator: \t (tab)
Line Seperator: \n (newline)
UTF8 characters allowed: No.

Fields (28)

0. OccurrenceID (129275) → to_occurrences_pk
(must be unique) (must not be empty)
1. TaxonID (129276) → to_occurrences_nodes_fk
(must not be empty)
2. Event ID (129277) → to_ignored
3. Institution Code (129278) → to_ignored
4. Collection Code (129279) → to_ignored
5. Catalog Number (129280) → to_ignored
6. Sex (129281) → to_occurrences_sex
7. LifeStage (129282) → to_occurrences_lifestage
8. Reproductive Condition (129283) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/reproductiveCondition)
9. Behavior (129284) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/behavior)
10. Establishment Means (129285) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/establishmentMeans)
11. Remarks (129286) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/occurrenceRemarks)
12. Count of Individuals (129287) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/individualCount)
13. Preparations (129288) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/preparations)
14. FieldNotes (129289) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/fieldNotes)
15. Sampling Protocol (129290) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/samplingProtocol)
16. Sampling Effort (129291) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/samplingEffort)
17. Recorded By (129292) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/recordedBy)
18. Identified By (129293) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/identifiedBy)
19. Date Identified (129294) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/dateIdentified)
20. Event Date (129295) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/eventDate)
21. Modified Date (129296) → to_occurrences_meta (http://purl.org/dc/terms/modified)
22. Locality (129297) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/locality)
23. Decimal Latitude (129298) → to_occurrences_lat
24. Decimal Longitude (129299) → to_occurrences_long
25. Verbatim Latitude (129300) → to_occurrences_lat_literal
26. Verbatim Longitude (129301) → to_occurrences_long_literal
27. Verbatim Elevation (129302) → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/verbatimElevation)