geocoded
Data license: Creative Commons V4.0 · Data source: Zoo Arch Project OSF
7 rows where fishbaseIDURL = "http://www.fishbase.se/summary/4032"
This data as json, CSV (advanced)
Suggested facets: sexOriginal, preparationsOriginal, occurrenceRemarksOriginal, verbatimEventDate, locality, verbatimLocality, measurementRemarks, measurementType, measurementUnit, totalLength, standardLength, catalogueYearYy, catalogueYearYyyy, geocoderDecimalLatitude, geocoderDecimalLongitude, DistanceInKMBetweenTwoCoordinates, georeferencePrecision, georeferenceRemarksFromGeocoder
occurrenceRemarks 7
- Caught in Victoria area, female, length 15cm, weight 68.4g, collected by b. Vaden Broch (date unknown) 1
- Caught in Victoria area, female, length 22cm, weight 135.6g, collected by B. Vaden Broch (date unknown) 1
- Caught in Victoria area, male, length 18cm, weight 74.5g, collected by R. Vaden Broch (date unknown) 1
- Collected at Neah Bay, Washington. Caught in gillnet in harbor, TL: 35.5cm, SL = 31.8, Weight: 590gm (615.9g according to Hughes), Date of death: 11 Aug 98, Donated by: K.M. Hughes, NMML, Seattle 1
- Collected by Sept.29, 1982 off McKenzie Bight by a diver. Probably female. Length: 39.5, Weight: 966g, collected by R. Vanden Broek 1
- From Rolling/Murdock Bay 20-30 fathoms, 28 April 92?, Bainbridge Island- Puget Sound, Length: 23cm, Weight 11.5g, Trypsin Aug 13/93 1
- Length: 14.2cm, Weight 34.9g, Donated: Uvic Biology 88', Processed: Aug 2/88 1
occurrenceID 7
bibliographicCitation 7
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-82.7 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-83.87 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-83.88 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-83.89 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-88.105 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-93.77 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-99.3 1
waterBody 5
- - 3
- Neah Bay 1
- Puget Sound 1
- Saanich Inlet 1
- Salish Sea 1
recordedBy 5
decimalLongitude 5
- -123.3657 3
- -125.0024 1
- -124.6144 1
- -123.50263 1
- -122.5209 1
sex 4
island 3
eventRemarks 3
preparations 2
nativeLandLanguage 2
vernacularName 1
taxonRank 1
- species 7
taxonID 1
subgenus 1
- - 7
specificEpithet 1
scientificName 1
phylum 1
- Chordata 7
order 1
lifeStage 1
- - 7
kingdom 1
- Animalia 7
islandGroup 1
- - 7
infraspecificEpithet 1
- - 7
georeferencedBy 1
georeferenceSources 1
georeferenceRemarks 1
- - 7
genus 1
fishbaseIDURL 1
- http://www.fishbase.se/summary/4032 · 7 ✖
family 1
dynamicProperties 1
- - 7
datasetName 1
coordinatePrecision 1
- - 7
continent 1
associatedReferences 1
- - 7
associatedMedia 1
- - 7
NCBIIDrefURL 1
IndigenousName 1
- - 7
ITIStaxonID 1
- 167110 7
GBIFtaxonID 1
- 2336472 7
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
945 | 945 | 944 | 1054 | 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-99.3 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-99.3 | 99.3 | National Marine Mammal Lab, Seattle, Washington | Female | Female tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | NCBI:txID274741 | NCBI:txID274741 | 274741 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=274741 | 99/3 | Caught in gillnet in harbor, standard length 31.8 | Collected at Neah Bay, Washington. Caught in gillnet in harbor, TL: 35.5cm, SL = 31.8, Weight: 590gm (615.9g according to Hughes), Date of death: 11 Aug 98, Donated by: K.M. Hughes, NMML, Seattle | Date of death | 1998-8-11 | 1998-8-11 | 1998 | 8 | 11 | North America | Neah Bay | USA | USA | WA | Neah Bay, Washington | unknown | 48.37785 | -124.6144 | 0.1048 | 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/2336472 | 2336472 | https://www.gbif.org/species/2336472|http://www.fishbase.se/summary/4032|NCBI:txID274741 | 167110 | ITIS TSN: 167110 | http://www.fishbase.se/summary/4032 | 4032 | Hexagrammos decagrammus | Hexagrammos decagrammus (Pallas, 1810) | Animalia | Chordata | Actinopterygii | Scorpaeniformes | Hexagrammidae | Hexagrammos | decagrammus | species | (Pallas, 1810) | accepted | Hexagrammos decagrammus (Pallas, 1810) | Kelp Greenling | weight | Weight | Length | g | cm | 35.5 | 615.9 | 35.5 | 31.8 | 99 | 3 | 1999 | 1000.0 | Neah Bay, Washington | |||||||||||||||||||||||||||||||||||||
1166 | 1166 | 1165 | 1302 | 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-82.7 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-82.7 | 82.7 | R. Vanden Brock | Female? | Likely Female tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | scales | scales tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | scales OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0002542 | NCBI:txID274741 | NCBI:txID274741 | 274741 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=274741 | 82/7 | Collected by Sept.29, 1982 off McKenzie Bight by a diver. Probably female. Length: 39.5, Weight: 966g, collected by R. Vanden Broek | Date of death | 1982-9-29 | 1982-9-29 | 1982 | 9 | 29 | North America | Saanich Inlet | Vancouver Island | Canada | CA | BC | McKenzie Bight | McKenzie Bight, Saanich Inlet, Vancouver Island, BC | unknown | 48.61634 | -123.50263 | 0.0779 | 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/2336472 | 2336472 | https://www.gbif.org/species/2336472|http://www.fishbase.se/summary/4032|NCBI:txID274741 | 167110 | ITIS TSN: 167110 | http://www.fishbase.se/summary/4032 | 4032 | Hexagrammos decagrammus | Hexagrammos decagrammus (Pallas, 1810) | Animalia | Chordata | Actinopterygii | Scorpaeniformes | Hexagrammidae | Hexagrammos | decagrammus | species | (Pallas, 1810) | accepted | Hexagrammos decagrammus (Pallas, 1810) | Kelp Greenling | weightlength | 39.5 | 966.6 | 82 | 7 | 49.65064 | -125.44939 | 182.43894195256237 | SENĆOŦEN / Malchosen / Lkwungen / Semiahmoo / T’Sou-ke | 50000.0 | Vancouver Island, BC | |||||||||||||||||||||||||||||||||||
1539 | 1539 | 1538 | 1727 | 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-93.77 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-93.77 | 93.77 | L.S.Smith | scales | scales tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | scales OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0002542 | NCBI:txID274741 | NCBI:txID274741 | 274741 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=274741 | 93/77 | From 20-30 fathoms | From Rolling/Murdock Bay 20-30 fathoms, 28 April 92?, Bainbridge Island- Puget Sound, Length: 23cm, Weight 11.5g, Trypsin Aug 13/93 | Date of death | 1992-4-28 | 1992-4-28 | 1992 | 4 | 28 | North America | Puget Sound | Bainbridge Island | USA | USA | WA | Rolling/Murdock Bay, Bainbridge Island, Puget Sound | unknown | 47.6263 | -122.5209 | 0.0846 | 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/2336472 | 2336472 | https://www.gbif.org/species/2336472|http://www.fishbase.se/summary/4032|NCBI:txID274741 | 167110 | ITIS TSN: 167110 | http://www.fishbase.se/summary/4032 | 4032 | Hexagrammos decagrammus | Hexagrammos decagrammus (Pallas, 1810) | Animalia | Chordata | Actinopterygii | Scorpaeniformes | Hexagrammidae | Hexagrammos | decagrammus | species | (Pallas, 1810) | accepted | Hexagrammos decagrammus (Pallas, 1810) | Kelp Greenling | weightlength | 23 | 115.10000000000001 | 93 | 77 | 50000.0 | Puget Sound | |||||||||||||||||||||||||||||||||||||||||
1583 | 1583 | 1582 | 1778 | 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-83.87 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-83.87 | 83.87 | R. Vanden Brock | Male | Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | scales | scales tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | scales OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0002542 | NCBI:txID274741 | NCBI:txID274741 | 274741 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=274741 | 83/87 | Caught in Victoria area, male, length 18cm, weight 74.5g, collected by R. Vaden Broch (date unknown) | -- | -- | North America | Vancouver Island | Canada | CA | BC | Victoria | Victoria area waters | unknown | 48.4222 | -123.3657 | 0.1119 | 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/2336472 | 2336472 | https://www.gbif.org/species/2336472|http://www.fishbase.se/summary/4032|NCBI:txID274741 | 167110 | ITIS TSN: 167110 | http://www.fishbase.se/summary/4032 | 4032 | Hexagrammos decagrammus | Hexagrammos decagrammus (Pallas, 1810) | Animalia | Chordata | Actinopterygii | Scorpaeniformes | Hexagrammidae | Hexagrammos | decagrammus | species | (Pallas, 1810) | accepted | Hexagrammos decagrammus (Pallas, 1810) | Kelp Greenling | weightlength | 18 | 74.5 | 83 | 87 | 43.77278 | -79.87778 | 3346.6420166738344 | SENĆOŦEN / Malchosen / Lkwungen / Semiahmoo / T’Sou-ke | 5000.0 | Victoria, Victoria | ||||||||||||||||||||||||||||||||||||||||
1587 | 1587 | 1586 | 1783 | 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-83.88 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-83.88 | 83.88 | Female | Female tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | scales | scales tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | scales OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0002542 | NCBI:txID274741 | NCBI:txID274741 | 274741 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=274741 | 83/88 | Caught in Victoria area, female, length 22cm, weight 135.6g, collected by B. Vaden Broch (date unknown) | Caught in Victoria area, female, length 22cm, weight 135.6g, collected by B. Vaden Broch (date unknown) | -- | -- | North America | Salish Sea | Vancouver Island | Canada | CA | BC | Victoria | Victoria area waters | unknown | 48.4222 | -123.3657 | 0.1119 | 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/2336472 | 2336472 | https://www.gbif.org/species/2336472|http://www.fishbase.se/summary/4032|NCBI:txID274741 | 167110 | ITIS TSN: 167110 | http://www.fishbase.se/summary/4032 | 4032 | Hexagrammos decagrammus | Hexagrammos decagrammus (Pallas, 1810) | Animalia | Chordata | Actinopterygii | Scorpaeniformes | Hexagrammidae | Hexagrammos | decagrammus | species | (Pallas, 1810) | accepted | Hexagrammos decagrammus (Pallas, 1810) | Kelp Greenling | weightlength | 22 | 135.6 | 83 | 88 | 43.77278 | -79.87778 | 3346.6420166738344 | SENĆOŦEN / Malchosen / Lkwungen / Semiahmoo / T’Sou-ke | 5000.0 | Victoria, Victoria | |||||||||||||||||||||||||||||||||||||||
1591 | 1591 | 1590 | 1788 | 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-83.89 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-83.89 | 83.89 | R. Vanden Brock | Male | Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | scales | scales tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | scales OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0002542 | NCBI:txID274741 | NCBI:txID274741 | 274741 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=274741 | 83/89 | Caught in Victoria area, female, length 15cm, weight 68.4g, collected by b. Vaden Broch (date unknown) | -- | -- | North America | Vancouver Island | Canada | CA | BC | Victoria | Victoria area waters | unknown | 48.4222 | -123.3657 | 0.1119 | 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/2336472 | 2336472 | https://www.gbif.org/species/2336472|http://www.fishbase.se/summary/4032|NCBI:txID274741 | 167110 | ITIS TSN: 167110 | http://www.fishbase.se/summary/4032 | 4032 | Hexagrammos decagrammus | Hexagrammos decagrammus (Pallas, 1810) | Animalia | Chordata | Actinopterygii | Scorpaeniformes | Hexagrammidae | Hexagrammos | decagrammus | species | (Pallas, 1810) | accepted | Hexagrammos decagrammus (Pallas, 1810) | Kelp Greenling | weightlength | 15 | 68.4 | 83 | 89 | 43.77278 | -79.87778 | 3346.6420166738344 | SENĆOŦEN / Malchosen / Lkwungen / Semiahmoo / T’Sou-ke | 5000.0 | Victoria, Victoria | ||||||||||||||||||||||||||||||||||||||||
1658 | 1658 | 1657 | 1863 | 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-88.105 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-88.105 | 88.105 | UVic Biology Department | scales | scales tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | scales OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0002542 | NCBI:txID274741 | NCBI:txID274741 | 274741 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=274741 | 88/105 | Length: 14.2cm, Weight 34.9g, Donated: Uvic Biology 88', Processed: Aug 2/88 | Date entered collection | 1988-- | 1988-- | 1988 | North America | Canada | CA | BC | unknown | 55.0013 | -125.0024 | 0.0941 | 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/2336472 | 2336472 | https://www.gbif.org/species/2336472|http://www.fishbase.se/summary/4032|NCBI:txID274741 | 167110 | ITIS TSN: 167110 | http://www.fishbase.se/summary/4032 | 4032 | Hexagrammos decagrammus | Hexagrammos decagrammus (Pallas, 1810) | Animalia | Chordata | Actinopterygii | Scorpaeniformes | Hexagrammidae | Hexagrammos | decagrammus | species | (Pallas, 1810) | accepted | Hexagrammos decagrammus (Pallas, 1810) | Kelp Greenling | weightlength | 14.200000000000001 | 34.9 | 88 | 105 | 50000.0 | Canada, 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 );