Occurrences Format File Definition for Alaskan Arthropods

edit • delete

0. OccurrenceID → to_occurrences_pk

1. TaxonID → to_occurrences_nodes_fk

2. Event ID → to_ignored

3. Institution Code → to_ignored

4. Collection Code → to_ignored

5. Catalog Number → to_ignored

6. Sex → to_occurrences_sex

7. LifeStage → to_occurrences_lifestage

8. Reproductive Condition → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/reproductiveCondition)

9. Behavior → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/behavior)

10. Establishment Means → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/establishmentMeans)

11. Remarks → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/occurrenceRemarks)

12. Count of Individuals → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/individualCount)

13. Preparations → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/preparations)

14. FieldNotes → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/fieldNotes)

15. Sampling Protocol → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/samplingProtocol)

16. Sampling Effort → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/samplingEffort)

17. Recorded By → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/recordedBy)

18. Identified By → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/identifiedBy)

19. Date Identified → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/dateIdentified)

20. Event Date → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/eventDate)

21. Modified Date → to_occurrences_meta (http://purl.org/dc/terms/modified)

22. Locality → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/locality)

23. Decimal Latitude → to_occurrences_lat

24. Decimal Longitude → to_occurrences_long

25. Verbatim Latitude → to_occurrences_lat_literal

26. Verbatim Longitude → to_occurrences_long_literal

27. Verbatim Elevation → to_occurrences_meta (http://rs.tdwg.org/dwc/terms/verbatimElevation)