geocoded
Data license: Creative Commons V4.0 · Data source: Zoo Arch Project OSF
8 rows where ITIStaxonID = 89609 and preparations = "mollusc tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | mollusc shell OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0008270"
This data as json, CSV (advanced)
Suggested facets: occurrenceRemarksOriginal, verbatimEventDate, locality, verbatimLocality, measurementRemarks, measurementType, measurementUnit, measurementValue, weight, catalogueYearYy, catalogueYearYyyy, geocoderDecimalLatitude, geocoderDecimalLongitude, DistanceInKMBetweenTwoCoordinates, georeferencePrecision, georeferenceRemarksFromGeocoder
occurrenceID 8
bibliographicCitation 8
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-18.89 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-18.90 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-87.74 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-87.76 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-87.78 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-90.149 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-90.150 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-90.151 1
occurrenceRemarks 6
- 1 individual from McKenzie Bight, high intertidal, collected June 14/90 C. Cripps, processed July 16/90 2
- Donor: Ian Sumpter, Parks Canada 2
- 5 individuals (A, B, C, D, E) cemented together in specimen, from McKenzie Bight, high intertidal, collected June 14/90, processed July 16/90 1
- Collected by diver off Ten Mile Point, Victoria at approx 10:40am, June 22, 1987, This barnacle was located at mid-tide and was removed from a rocky surface near the ground. Several other individuals like it were also present, unprocessed weight unavailable, fresh shell weight .45g 1
- Collected from Cattle Point, Victoria at approx 9:25am, June 22, 1987, Barnacle was located at high tide and was removed from low lying rock. Several more individuals like it were available nearby, unprocessed weight unavailable, fresh shell weight .59g 1
- Recovered from Ten Mile Point, Victoria June 22, 1987 during mid-morning, Barnacle was removed from a rocky surface and was selected from a large number of similar barnacles, unprocessed weight 1.35g, fresh shell weight 1.05g 1
decimalLongitude 4
- -123.50774 3
- -125.7275 2
- -123.2766 2
- -123.29284 1
nativeLandLanguage 3
recordedBy 2
eventRemarks 2
waterBody 1
- - 8
vernacularName 1
- Barnacle 8
taxonRank 1
- species 8
taxonID 1
subgenus 1
- - 8
stateProvince 1
- BC 8
specificEpithet 1
- glandula 8
sex 1
- - 8
scientificName 1
preparations 1
- mollusc tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | mollusc shell OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0008270 · 8 ✖
phylum 1
order 1
- Sessilia 8
lifeStage 1
- - 8
kingdom 1
- Animalia 8
islandGroup 1
- - 8
island 1
infraspecificEpithet 1
- - 8
georeferencedBy 1
georeferenceSources 1
georeferenceRemarks 1
- - 8
genus 1
- Balanus 8
fishbaseIDURL 1
- - 8
family 1
dynamicProperties 1
- - 8
datasetName 1
countryCode 1
- CA 8
country 1
- Canada 8
coordinatePrecision 1
- - 8
continent 1
associatedReferences 1
- - 8
associatedMedia 1
- - 8
NCBIIDrefURL 1
IndigenousName 1
- - 8
ITIStaxonID 1
- 89609 · 8 ✖
GBIFtaxonID 1
- 2115706 8
Link | rowid ▼ | Index | type | language | license | rightsHolder | accessRights | bibliographicCitation | collectionID | institutionCode | institutionID | collectionCode | datasetName | basisOfRecord | dynamicProperties | occurenceIDURL | occurrenceID | catalogNumber | recordedBy | sexOriginal | sex | lifeStageOriginal | lifeStage | preparationsOriginal | preparations | disposition | associatedMedia | associatedReferences | NCBIIDrefURL | NCBIIDref | NCBIID | NCBIIDURL | otherCatalogNumbers | occurrenceRemarksOriginal | occurrenceRemarks | eventRemarks | eventDate | verbatimEventDate | year | month | day | continent | waterBody | islandGroup | island | country | countryCode | stateProvince | municipality | locality | verbatimLocality | locationRemarks | verbatimCoordinates | geodeticDatum | decimalLatitude | decimalLongitude | coordinateUncertaintyInMeters | coordinatePrecision | georeferencedBy | georeferenceSources | georeferenceRemarks | identifiedBy | identificationRemarks | GBIFtaxonIDURL | GBIFtaxonID | allTaxonIDs | ITIStaxonID | taxonID | fishbaseIDURL | fishbaseID | canonicalName | scientificName | kingdom | phylum | _73 | order | family | genus | subgenus | specificEpithet | infraspecificEpithet | taxonRank | scientificNameAuthorship | taxonomicStatus | acceptedNameUsage | vernacularName | IndigenousName | _86 | taxonRemarks | previousIdentifications | measurementRemarks | measurementType | measurementUnit | measurementValue | weight | length | width | totalLength | forkLength | standardLength | wing | tarsus | culmen | diameter | catalogueYearYy | catalogueNumberNn | catalogueYearYyyy | geocoderDecimalLatitude | geocoderDecimalLongitude | DistanceInKMBetweenTwoCoordinates | nativeLandLanguage | georeferencePrecision | georeferenceRemarksFromGeocoder | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2229 | 2229 | 2228 | 2575 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-87.74 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Other | PreservedSpecimen | UVICZL-87.74 | 87.74 | shell | mollusc tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | mollusc shell OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0008270 | NCBI:txid110520 | 87/74 | Collected by diver off Ten Mile Point, Victoria at approx 10:40am, June 22, 1987, This barnacle was located at mid-tide and was removed from a rocky surface near the ground. Several other individuals like it were also present, unprocessed weight unavailable, fresh shell weight .45g | Collected by diver off Ten Mile Point, Victoria at approx 10:40am, June 22, 1987, This barnacle was located at mid-tide and was removed from a rocky surface near the ground. Several other individuals like it were also present, unprocessed weight unavailable, fresh shell weight .45g | Date entered collection | 1987-6-22 | 1987-6-22 | 1987 | 6 | 22 | North America | Vancouver Island | Canada | CA | BC | Victoria | Ten Mile Point | Ten Mile Point, Victoria, BC | unknown | 48.45744 | -123.2766 | 0.106 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2115706 | 2115706 | https://www.gbif.org/species/2115706|NCBI:txid110520 | 89609 | ITIS TSN: 89609 | Balanus glandula | Balanus glandula Darwin, 1854 | Animalia | Arthropoda | Maxillopoda | Sessilia | Balanidae | Balanus | glandula | species | Darwin, 1854 | accepted | Balanus glandula Darwin, 1854 | Barnacle | fresh shell weight | Weight | g | 0.45 | 0.45 | 87 | 74 | 1987 | 48.450234 | -123.343529 | 5.000432343907296 | SENĆOŦEN / Malchosen / Lkwungen / Semiahmoo / T’Sou-ke | 5000.0 | Victoria, BC | |||||||||||||||||||||||||||||||||||||||
2231 | 2231 | 2230 | 2577 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-87.76 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Other | PreservedSpecimen | UVICZL-87.76 | 87.76 | shell | mollusc tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | mollusc shell OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0008270 | NCBI:txid110520 | 87/76 | Collected from Cattle Point, Victoria at approx 9:25am, June 22, 1987, Barnacle was located at high tide and was removed from low lying rock. Several more individuals like it were available nearby, unprocessed weight unavailable, fresh shell weight .59g | Collected from Cattle Point, Victoria at approx 9:25am, June 22, 1987, Barnacle was located at high tide and was removed from low lying rock. Several more individuals like it were available nearby, unprocessed weight unavailable, fresh shell weight .59g | Date entered collection | 1987-6-22 | 1987-6-22 | 1987 | 6 | 22 | North America | Vancouver Island | Canada | CA | BC | Victoria | Cattle Point | Cattle Point, Victoria | unknown | 48.43792 | -123.29284 | 0.0789 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2115706 | 2115706 | https://www.gbif.org/species/2115706|NCBI:txid110520 | 89609 | ITIS TSN: 89609 | Balanus glandula | Balanus glandula Darwin, 1854 | Animalia | Arthropoda | Maxillopoda | Sessilia | Balanidae | Balanus | glandula | species | Darwin, 1854 | accepted | Balanus glandula Darwin, 1854 | Barnacle | fresh shell weight | Weight | g | 0.59 | 0.59 | 87 | 76 | 1987 | 49.75152 | -126.48958 | 274.75879502576714 | SENĆOŦEN / Malchosen / Lkwungen / Semiahmoo / T’Sou-ke | 50000.0 | BC | |||||||||||||||||||||||||||||||||||||||
2233 | 2233 | 2232 | 2579 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-87.78 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Other | PreservedSpecimen | UVICZL-87.78 | 87.78 | shell | mollusc tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | mollusc shell OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0008270 | NCBI:txid110520 | 87/78 | Recovered from Ten Mile Point, Victoria June 22, 1987 during mid-morning, Barnacle was removed from a rocky surface and was selected from a large number of similar barnacles, unprocessed weight 1.35g, fresh shell weight 1.05g | Recovered from Ten Mile Point, Victoria June 22, 1987 during mid-morning, Barnacle was removed from a rocky surface and was selected from a large number of similar barnacles, unprocessed weight 1.35g, fresh shell weight 1.05g | Date entered collection | 1987-6-22 | 1987-6-22 | 1987 | 6 | 22 | North America | Vancouver Island | Canada | CA | BC | Victoria | Ten Mile Point | Ten Mile Point, Victoria, BC | unknown | 48.45744 | -123.2766 | 0.106 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2115706 | 2115706 | https://www.gbif.org/species/2115706|NCBI:txid110520 | 89609 | ITIS TSN: 89609 | Balanus glandula | Balanus glandula Darwin, 1854 | Animalia | Arthropoda | Maxillopoda | Sessilia | Balanidae | Balanus | glandula | species | Darwin, 1854 | accepted | Balanus glandula Darwin, 1854 | Barnacle | fresh shell weight | Weight | g | 1.05 | 1.05 | 87 | 78 | 1987 | 48.450234 | -123.343529 | 5.000432343907296 | SENĆOŦEN / Malchosen / Lkwungen / Semiahmoo / T’Sou-ke | 5000.0 | Victoria, BC | |||||||||||||||||||||||||||||||||||||||
2331 | 2331 | 2330 | 2678 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-90.149 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Other | PreservedSpecimen | UVICZL-90.149 | 90.149 | shell | mollusc tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | mollusc shell OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0008270 | NCBI:txid110520 | 90/149 | 5 individuals (A, B, C, D, E) cemented together in specimen, from McKenzie Bight, high intertidal, collected June 14/90, processed July 16/90 | 5 individuals (A, B, C, D, E) cemented together in specimen, from McKenzie Bight, high intertidal, collected June 14/90, processed July 16/90 | Date entered collection | 1990-6-14 | 1990-6-14 | 1990 | 6 | 14 | North America | Vancouver Island | Canada | CA | BC | McKenzie Bight | McKenzie Bight | unknown | 48.55328 | -123.50774 | 0.0894 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2115706 | 2115706 | https://www.gbif.org/species/2115706|NCBI:txid110520 | 89609 | ITIS TSN: 89609 | Balanus glandula | Balanus glandula Darwin, 1854 | Animalia | Arthropoda | Maxillopoda | Sessilia | Balanidae | Balanus | glandula | species | Darwin, 1854 | accepted | Balanus glandula Darwin, 1854 | Barnacle | 90 | 149 | 1990 | 48.55328 | -123.50774 | 0.0 | Coast Salish | 50000.0 | McKenzie Bight | |||||||||||||||||||||||||||||||||||||||||||||
2332 | 2332 | 2331 | 2679 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-90.150 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Other | PreservedSpecimen | UVICZL-90.150 | 90.150 | shell | mollusc tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | mollusc shell OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0008270 | NCBI:txid110520 | 90/150 | 1 individual from McKenzie Bight, high intertidal, collected June 14/90 C. Cripps, processed July 16/90 | 1 individual from McKenzie Bight, high intertidal, collected June 14/90 C. Cripps, processed July 16/90 | Date entered collection | 1990-6-14 | 1990-6-14 | 1990 | 6 | 14 | North America | Vancouver Island | Canada | CA | BC | McKenzie Bight | McKenzie Bight | unknown | 48.55328 | -123.50774 | 0.0894 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2115706 | 2115706 | https://www.gbif.org/species/2115706|NCBI:txid110520 | 89609 | ITIS TSN: 89609 | Balanus glandula | Balanus glandula Darwin, 1854 | Animalia | Arthropoda | Maxillopoda | Sessilia | Balanidae | Balanus | glandula | species | Darwin, 1854 | accepted | Balanus glandula Darwin, 1854 | Barnacle | 90 | 150 | 1990 | 48.55328 | -123.50774 | 0.0 | Coast Salish | 50000.0 | McKenzie Bight | |||||||||||||||||||||||||||||||||||||||||||||
2333 | 2333 | 2332 | 2680 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-90.151 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Other | PreservedSpecimen | UVICZL-90.151 | 90.151 | shell | mollusc tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | mollusc shell OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0008270 | NCBI:txid110520 | 90/151 | 1 individual from McKenzie Bight, high intertidal, collected June 14/90 C. Cripps, processed July 16/90 | 1 individual from McKenzie Bight, high intertidal, collected June 14/90 C. Cripps, processed July 16/90 | Date entered collection | 1990-6-14 | 1990-6-14 | 1990 | 6 | 14 | North America | Vancouver Island | Canada | CA | BC | McKenzie Bight | McKenzie Bight | unknown | 48.55328 | -123.50774 | 0.0894 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2115706 | 2115706 | https://www.gbif.org/species/2115706|NCBI:txid110520 | 89609 | ITIS TSN: 89609 | Balanus glandula | Balanus glandula Darwin, 1854 | Animalia | Arthropoda | Maxillopoda | Sessilia | Balanidae | Balanus | glandula | species | Darwin, 1854 | accepted | Balanus glandula Darwin, 1854 | Barnacle | 90 | 151 | 1990 | 48.55328 | -123.50774 | 0.0 | Coast Salish | 50000.0 | McKenzie Bight | |||||||||||||||||||||||||||||||||||||||||||||
2455 | 2455 | 2454 | 2858 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-18.89 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Other | PreservedSpecimen | UVICZL-18.89 | 18.89 | Ian Sumpter | Parks Canada | shell | mollusc tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | mollusc shell OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0008270 | NCBI:txid110520 | 18/89 | Donor: Ian Sumpter, Parks Canada | -- | -- | North America | Vancouver Island | Canada | CA | BC | unknown | 49.7155 | -125.7275 | 0.0789 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2115706 | 2115706 | https://www.gbif.org/species/2115706|NCBI:txid110520 | 89609 | ITIS TSN: 89609 | Balanus glandula | Balanus glandula Darwin, 1854 | Animalia | Arthropoda | Maxillopoda | Sessilia | Balanidae | Balanus | glandula | species | Darwin, 1854 | accepted | Balanus glandula Darwin, 1854 | Barnacle | 18 | 89 | 2018 | 49.75152 | -126.48958 | 54.916801230269364 | Nuučaan̓uɫ | 50000.0 | BC | |||||||||||||||||||||||||||||||||||||||||||||||||||
2456 | 2456 | 2455 | 2859 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-18.90 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Other | PreservedSpecimen | UVICZL-18.90 | 18.90 | Ian Sumpter | Parks Canada | shell | mollusc tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | mollusc shell OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0008270 | NCBI:txid110520 | 18/90 | Donor: Ian Sumpter, Parks Canada | -- | -- | North America | Vancouver Island | Canada | CA | BC | unknown | 49.7155 | -125.7275 | 0.0789 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2115706 | 2115706 | https://www.gbif.org/species/2115706|NCBI:txid110520 | 89609 | ITIS TSN: 89609 | Balanus glandula | Balanus glandula Darwin, 1854 | Animalia | Arthropoda | Maxillopoda | Sessilia | Balanidae | Balanus | glandula | species | Darwin, 1854 | accepted | Balanus glandula Darwin, 1854 | Barnacle | 18 | 90 | 2018 | 49.75152 | -126.48958 | 54.916801230269364 | Nuučaan̓uɫ | 50000.0 | BC |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "geocoded" ( [] INTEGER, [Index] INTEGER, [type] TEXT, [language] TEXT, [license] TEXT, [rightsHolder] TEXT, [accessRights] INTEGER, [bibliographicCitation] TEXT, [collectionID] TEXT, [institutionCode] TEXT, [institutionID] TEXT, [collectionCode] TEXT, [datasetName] TEXT, [basisOfRecord] TEXT, [dynamicProperties] TEXT, [occurenceIDURL] TEXT, [occurrenceID] TEXT, [catalogNumber] TEXT, [recordedBy] TEXT, [sexOriginal] TEXT, [sex] TEXT, [lifeStageOriginal] TEXT, [lifeStage] TEXT, [preparationsOriginal] TEXT, [preparations] TEXT, [disposition] TEXT, [associatedMedia] TEXT, [associatedReferences] TEXT, [NCBIIDrefURL] TEXT, [NCBIIDref] TEXT, [NCBIID] INTEGER, [NCBIIDURL] TEXT, [otherCatalogNumbers] TEXT, [occurrenceRemarksOriginal] TEXT, [occurrenceRemarks] TEXT, [eventRemarks] TEXT, [eventDate] TEXT, [verbatimEventDate] TEXT, [year] INTEGER, [month] TEXT, [day] INTEGER, [continent] TEXT, [waterBody] TEXT, [islandGroup] TEXT, [island] TEXT, [country] TEXT, [countryCode] TEXT, [stateProvince] TEXT, [municipality] TEXT, [locality] TEXT, [verbatimLocality] TEXT, [locationRemarks] TEXT, [verbatimCoordinates] TEXT, [geodeticDatum] TEXT, [decimalLatitude] FLOAT, [decimalLongitude] FLOAT, [coordinateUncertaintyInMeters] FLOAT, [coordinatePrecision] INTEGER, [georeferencedBy] TEXT, [georeferenceSources] TEXT, [georeferenceRemarks] INTEGER, [identifiedBy] TEXT, [identificationRemarks] TEXT, [GBIFtaxonIDURL] TEXT, [GBIFtaxonID] INTEGER, [allTaxonIDs] TEXT, [ITIStaxonID] INTEGER, [taxonID] TEXT, [fishbaseIDURL] TEXT, [fishbaseID] INTEGER, [canonicalName] TEXT, [scientificName] TEXT, [kingdom] TEXT, [phylum] TEXT, [_73] TEXT, [order] TEXT, [family] TEXT, [genus] TEXT, [subgenus] TEXT, [specificEpithet] TEXT, [infraspecificEpithet] TEXT, [taxonRank] TEXT, [scientificNameAuthorship] TEXT, [taxonomicStatus] TEXT, [acceptedNameUsage] TEXT, [vernacularName] TEXT, [IndigenousName] INTEGER, [_86] INTEGER, [taxonRemarks] TEXT, [previousIdentifications] TEXT, [measurementRemarks] TEXT, [measurementType] TEXT, [measurementUnit] TEXT, [measurementValue] TEXT, [weight] TEXT, [length] FLOAT, [width] INTEGER, [totalLength] FLOAT, [forkLength] FLOAT, [standardLength] FLOAT, [wing] FLOAT, [tarsus] FLOAT, [culmen] FLOAT, [diameter] FLOAT, [catalogueYearYy] INTEGER, [catalogueNumberNn] TEXT, [catalogueYearYyyy] INTEGER, [geocoderDecimalLatitude] FLOAT, [geocoderDecimalLongitude] FLOAT, [DistanceInKMBetweenTwoCoordinates] FLOAT, [nativeLandLanguage] TEXT, [georeferencePrecision] FLOAT, [georeferenceRemarksFromGeocoder] TEXT );