geocoded
Data license: Creative Commons V4.0 · Data source: Zoo Arch Project OSF
17 rows where sex = "Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8"
This data as json, CSV (advanced)
Suggested facets: sexOriginal, lifeStageOriginal, preparationsOriginal, NCBIIDref, NCBIID, NCBIIDURL, locality, fishbaseID, _73, scientificNameAuthorship, taxonomicStatus, taxonRemarks, measurementRemarks, measurementType, measurementUnit, measurementValue, forkLength, standardLength, wing, tarsus, culmen, catalogueYearYy, catalogueYearYyyy, geocoderDecimalLatitude, geocoderDecimalLongitude, DistanceInKMBetweenTwoCoordinates, georeferencePrecision, eventDate (date), verbatimEventDate (date)
vernacularName >10
taxonID >10
specificEpithet >10
- pistilliger 3
- lupus 2
- vacca 2
- asper 1
- buccinator 1
- californianus 1
- hippurus 1
- lutris 1
- perspicillata 1
- platyrhynchos 1
- …
scientificName >10
- Gymnocanthus pistilliger (Pallas, 1814) 3
- Canis lupus subsp. familiaris Linnaeus, 1758 2
- Damalichthys vacca Girard, 1855 2
- Anas platyrhynchos Linnaeus, 1758 1
- Anas strepera Linnaeus, 1758 1
- Coryphaena hippurus Linnaeus, 1758 1
- Cottus asper Richardson, 1836 1
- Cygnus buccinator Richardson, 1831 1
- Enhydra lutris Linnaeus, 1758 1
- Hirundo rustica Linnaeus, 1758 1
- …
recordedBy >10
occurrenceRemarks >10
- Almost all black, post-spawning male?, location: Lower Fraser, date: July/August 1985, standard lg: 18.9, fork lg: (18.4cm), tail fin damaged, weight: 83.8g, (frozen whole), scaleless 1
- Complete skeleton found on edge of Thetis Lake Park, male?. Donor: B. Wigen 1
- Donated by Fish + Wildlife, Nanaimo Br. Found by the edge of Trent River Estuary , Jan 4, 1984. Wing length: 54, tarsus: 11.0, culmen: 10.2. 1
- Donated by Pete Dady, Located from Nettle Island. Partial Skeleton-no skull present, fully fused elements, size fits California better than Nortern-BW. Identified mainly on basis of size. 1
- Donated by Surrey Fish & Wildlife. Nov. 24th, 1985, immature male? Weight: 922.9 1
- Family pet buried on site DjSf13, "Tippy", Possibly male. 1
- Found dead on beach below Chinese Cemetary, Aug 5, 1984, buried to process same day, uncovered May 9, 1988 1
- From Alki beach/Seattle, US Caught with beach seine, Donated Dec 1990, LS Smith, symetrical swellings on anal fin: probably male, musscles + barnacles in stomach, Length: 37.5cm, Weight: 882.01g, Collected: Nov 28, 1991, LS Smith, Processed: June 12, 1991, boiling + Trypsin 1
- From Alki beach/seatltle, US, Caught with beach seine, Donated: December 1990, Probably male (Large symetrical swellings on anal fin). Length: 40.5cm, Weight: 866.71g, Collected: November 28,1990 LS Smith, Processed: May 29, 1991 boiling + Trypsin 1
- From Bering Sea, Vessel 88, cruise #971, haul #4, (Summer, 97), probably male, length: 12.6cm, weight 17.15gm, donor: NMFS, Seattle, processed: 22 Sept 97 1
- …
occurrenceID >10
- UVICZL-13.9 1
- UVICZL-82.3 1
- UVICZL-84.37 1
- UVICZL-84.48 1
- UVICZL-85.53 1
- UVICZL-86.183 1
- UVICZL-86.81 1
- UVICZL-86.9 1
- UVICZL-91.81 1
- UVICZL-91.97 1
- …
genus >10
- Gymnocanthus 3
- Anas 2
- Canis 2
- Rhacochilus 2
- Coryphaena 1
- Cottus 1
- Cygnus 1
- Enhydra 1
- Hirundo 1
- Melanitta 1
- …
eventDate >10
- -- 3
- 1997-- 3
- 1990-11-28 2
- 1982-- 1
- 1984-1-4 1
- 1984-8-5 1
- 1985-11-24 1
- 1985-7- 1
- 1992-11-18 1
- 1992-5-6 1
- …
decimalLongitude >10
- -175.0 3
- -123.3657 3
- -122.40581 2
- -157.999 1
- -148.0 1
- -125.25281 1
- -125.0024 1
- -124.93002 1
- -124.4 1
- -123.46931 1
- …
decimalLatitude >10
coordinateUncertaintyInMeters 10
bibliographicCitation >10
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-13.9 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-82.3 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-84.37 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-84.48 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-85.53 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-86.183 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-86.81 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-86.9 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-91.81 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-91.97 1
- …
NCBIIDrefURL >10
ITIStaxonID >10
GBIFtaxonID >10
family 9
- Anatidae 4
- Cottidae 4
- Canidae 2
- Embiotocidae 2
- Coryphaenidae 1
- Hirundinidae 1
- Mustelidae 1
- Otariidae 1
- Phocidae 1
waterBody 5
- - 11
- Bering Sea 3
- Powell Lake 1
- Thetis Lake 1
- Trent River 1
order 5
nativeLandLanguage 5
fishbaseIDURL 5
preparations 4
- vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 9
- - 5
- scales tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | scales OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0002542 2
- skull tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skull OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0003129 1
eventRemarks 4
lifeStage 3
island 3
- - 10
- Vancouver Island 6
- Nettle Island 1
datasetName 3
taxonRank 2
- species 15
- subspecies 2
islandGroup 2
- - 16
- Broken Group Islands 1
infraspecificEpithet 2
- - 15
- familiaris 2
continent 2
- North America 13
- - 4
subgenus 1
- - 17
sex 1
- Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 · 17 ✖
phylum 1
- Chordata 17
kingdom 1
- Animalia 17
georeferencedBy 1
georeferenceSources 1
georeferenceRemarks 1
- - 17
dynamicProperties 1
- - 17
coordinatePrecision 1
- - 17
associatedReferences 1
- - 17
associatedMedia 1
- - 17
IndigenousName 1
- - 17
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20 | 20 | 19 | 19 | 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-84.37 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Birds | PreservedSpecimen | UVICZL-84.37 | 84.37 | Nanaimo Fish and Wildlife | M? | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | NCBI:txID48397 | NCBI:txID48397 | 48397 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=48397 | Donated by Fish + Wildlife, Nanaimo Br. Found by the edge of Trent River Estuary , Jan 4, 1984. Wing length: 54, tarsus: 11.0, culmen: 10.2. | Date of death | 1984-1-4 | 1984-1-4 | 1984 | 1 | 4 | North America | Trent River | Vancouver Island | Canada | CA | BC | Trent River estuary, Vancouver Island, BC | unknown | 49.64396 | -124.93002 | 0.0808 | 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/2498345 | 2498345 | https://www.gbif.org/species/2498345|NCBI:txID48397 | 174992 | ITIS TSN: 174992 | Cygnus buccinator | Cygnus buccinator Richardson, 1831 | Animalia | Chordata | Aves | Anseriformes | Anatidae | Cygnus | buccinator | species | Richardson, 1831 | accepted | Cygnus buccinator Richardson, 1831 | Trumpeter swan | length | Length | cm | 54 | 54.0 | 11.0 | 10.2 | 84 | 37 | 1984 | 49.75152 | -126.48958 | 112.80211373239011 | Coast Salish | 50000.0 | Vancouver Island, BC | ||||||||||||||||||||||||||||||||||||
110 | 110 | 109 | 115 | 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-86.9 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Birds | PreservedSpecimen | UVICZL-86.9 | 86.9 | Surrey Fish and Wildlife | M? | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | NCBI:txID | NCBI:txID | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id= | immature male? | Donated by Surrey Fish & Wildlife. Nov. 24th, 1985, immature male? Weight: 922.9 | Date entered collection | 1985-11-24 | 1985-11-24 | 1985 | 11 | 24 | North America | Canada | CA | BC | Surrey | unknown | 49.1913 | -122.8491 | 0.0881 | 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/2498151 | 2498151 | https://www.gbif.org/species/2498151|NCBI:txID | 175073 | ITIS TSN: 175073 | Anas strepera | Anas strepera Linnaeus, 1758 | Animalia | Chordata | Aves | Anseriformes | Anatidae | Anas | strepera | species | Linnaeus, 1758 | accepted | Anas strepera Linnaeus, 1758 | Gadwall | weight | Weight | g | 922.9 | 86 | 9 | 1986 | 49.10635 | -122.82509 | 9.6060735175378 | Hul’q’umi’num’ / Halq’eméylem / hən̓q̓əmin̓əm̓ | 5000.0 | Surrey | |||||||||||||||||||||||||||||||||||||||||
129 | 129 | 128 | 135 | 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-86.81 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Birds | PreservedSpecimen | UVICZL-86.81 | 86.81 | SPCA | M? | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | NCBI:txID371863 | NCBI:txID371863 | 371863 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=371863 | SPCA, weight: 526.7 | -- | -- | North America | Vancouver Island | Canada | CA | BC | Victoria | unknown | 48.4222 | -123.3657 | 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/2498246 | 2498246 | https://www.gbif.org/species/2498246|NCBI:txID371863 | 175170 | ITIS TSN: 175170 | Melanitta perspicillata | Melanitta perspicillata (Linnaeus, 1758) | Animalia | Chordata | Aves | Anseriformes | Anatidae | Melanitta | perspicillata | species | (Linnaeus, 1758) | accepted | Melanitta perspicillata (Linnaeus, 1758) | Surf scoter | weight | Weight | g | 526.7 | 86 | 81 | 1986 | 49.75152 | -126.48958 | 271.2599920615793 | SENĆOŦEN / Malchosen / Lkwungen / Semiahmoo / T’Sou-ke | 50000.0 | BC | ||||||||||||||||||||||||||||||||||||||||||||
186 | 186 | 185 | 196 | 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-86.183 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Birds | PreservedSpecimen | UVICZL-86.183 | 86.183 | BCPM | M? | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | juvenile | Juvenile tDAR Faunal Age Ontology doi:10.6067/XCV8PZ574Q | NCBI:txID | NCBI:txID | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id= | juvenile male? | Probably juvenile male? Weight: 700gm. #B86 659 | -- | -- | 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/9761484 | 9761484 | https://www.gbif.org/species/9761484|NCBI:txID | 175063 | ITIS TSN: 175063 | Anas platyrhynchos | Anas platyrhynchos Linnaeus, 1758 | Animalia | Chordata | Aves | Anseriformes | Anatidae | Anas | platyrhynchos | species | Linnaeus, 1758 | accepted | Anas platyrhynchos Linnaeus, 1758 | Mallard | weight | Weight | g | 700 | 86 | 183 | 1986 | 5000.0 | Canada, BC | ||||||||||||||||||||||||||||||||||||||||||||||||
500 | 500 | 499 | 548 | 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-92.47 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Birds | PreservedSpecimen | UVICZL-92.47 | 92.47 | SPCA | M? | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | NCBI:txID43150 | NCBI:txID43150 | 43150 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=43150 | 92/47 | Prob Male colours fairly bright, weight: 15.58g, donated by SPCA,processed: May 6, 1992 | Processed | 1992-5-6 | 1992-5-6 | 1992 | 5 | 6 | North America | Vancouver Island | Canada | CA | BC | Victoria | unknown | 48.4222 | -123.3657 | 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/9515886 | 9515886 | https://www.gbif.org/species/9515886|NCBI:txID43150 | 178448 | ITIS TSN: 178448 | Hirundo rustica | Hirundo rustica Linnaeus, 1758 | Animalia | Chordata | Aves | Passeriformes | Hirundinidae | Hirundo | rustica | species | Linnaeus, 1758 | accepted | Hirundo rustica Linnaeus, 1758 | Barn swallow | weight | Weight | g | 15.58 | 92 | 47 | 1992 | 49.75152 | -126.48958 | 271.2599920615793 | SENĆOŦEN / Malchosen / Lkwungen / Semiahmoo / T’Sou-ke | 50000.0 | BC | |||||||||||||||||||||||||||||||||||||||
816 | 816 | 815 | 898 | 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-85.53 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-85.53 | 85.53 | Male? | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid214916 | 214916 | 85/53 | Almost all black, post-spawning male?, location: Lower Fraser, date: July/August 1985, standard lg: 18.9, fork lg: (18.4cm), tail fin damaged, weight: 83.8g, (frozen whole), scaleless | Almost all black, post-spawning male?, location: Lower Fraser, date: July/August 1985, standard lg: 18.9, fork lg: (18.4cm), tail fin damaged, weight: 83.8g, (frozen whole), scaleless | Date of death | 1985-7- | 1985-7- | 1985 | 7 | North America | Powell Lake | Canada | CA | BC | Lower Fraser River | Powell Lake tributaries, lower Fraser, BC | unknown | 50.1833 | -124.4 | 0.1 | 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/2334177 | 2334177 | https://www.gbif.org/species/2334177|https://www.fishbase.ca/summary/4062|NCBI:txid214916 | 167233 | ITIS TSN: 167233 | https://www.fishbase.ca/summary/4062 | 4062 | Cottus asper | Cottus asper Richardson, 1836 | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Cottus | asper | species | Richardson, 1836 | accepted | Cottus asper Richardson, 1836 | Prickly Sculpin | weight | Weight | Length | g | cm | 18.9 | 83.8 | 18.4 | 18.9 | 85 | 53 | 1985 | 59.716489 | -135.048177 | 1256.0206680760928 | Coast Salish | 5000.0 | Fraser, BC | ||||||||||||||||||||||||||||||||||
1374 | 1374 | 1373 | 1542 | 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-97.36 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-97.36 | 97.36 | National Marine Fisheries Service, Seattle, Washington | ?M | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid1176151 | 1176151 | 97/36 | From Bering Sea, Vessel 88, cruise #971, haul #4, (Summer, 97), probably male, length: 14.1cm, weight 26.68gm, donor: NMFS, Seattle, processed: 22 Sept 97 | From Bering Sea, Vessel 88, cruise #971, haul #4, (Summer, 97), probably male, length: 14.1cm, weight 26.68gm, donor: NMFS, Seattle, processed: 22 Sept 97 | Date of death | 1997-- | 1997-- | 1997 | Bering Sea | Bering Sea | Bering Sea | unknown | 60.0 | -175.0 | 0.0192 | 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/2334010 | 2334010 | https://www.gbif.org/species/2334010|https://www.fishbase.ca/summary/11716|NCBI:txid1176151 | 167274 | ITIS TSN: 167274 | https://www.fishbase.ca/summary/11716 | 11716 | Gymnocanthus pistilliger | Gymnocanthus pistilliger (Pallas, 1814) | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Gymnocanthus | pistilliger | species | (Pallas, 1814) | accepted | Gymnocanthus pistilliger (Pallas, 1814) | Threaded Sculpin | weightlength | Weight | Length | g | cm | 14.1 | 26.68 | 97 | 36 | 5000.0 | Bering Sea | |||||||||||||||||||||||||||||||||||||||||||||
1381 | 1381 | 1380 | 1550 | 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-97.37 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-97.37 | 97.37 | National Marine Fisheries Service, Seattle, Washington | ?M | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid1176151 | 1176151 | 97/37 | From Bering Sea, Vessel 88, cruise #971, haul #4, (Summer, 97), probably male, length: 12.6cm, weight 17.15gm, donor: NMFS, Seattle, processed: 22 Sept 97 | From Bering Sea, Vessel 88, cruise #971, haul #4, (Summer, 97), probably male, length: 12.6cm, weight 17.15gm, donor: NMFS, Seattle, processed: 22 Sept 97 | Date of death | 1997-- | 1997-- | 1997 | Bering Sea | Bering Sea | Bering Sea | unknown | 60.0 | -175.0 | 0.0192 | 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/2334010 | 2334010 | https://www.gbif.org/species/2334010|https://www.fishbase.ca/summary/11716|NCBI:txid1176151 | 167274 | ITIS TSN: 167274 | https://www.fishbase.ca/summary/11716 | 11716 | Gymnocanthus pistilliger | Gymnocanthus pistilliger (Pallas, 1814) | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Gymnocanthus | pistilliger | species | (Pallas, 1814) | accepted | Gymnocanthus pistilliger (Pallas, 1814) | Threaded Sculpin | weightlength | Weight | Length | g | cm | 12.6 | 17.15 | 97 | 37 | 5000.0 | Bering Sea | |||||||||||||||||||||||||||||||||||||||||||||
1387 | 1387 | 1386 | 1557 | 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-97.38 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-97.38 | 97.38 | National Marine Fisheries Service, Seattle, Washington | ?M | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid1176151 | 1176151 | 97/38 | From Bering Sea, Vessel 88, cruise #971, haul #4, (Summer, 97), probably male, length: 9.5cm, weight 7.97gm, donor: NMFS, Seattle, processed: 22 Sept 97 | From Bering Sea, Vessel 88, cruise #971, haul #4, (Summer, 97), probably male, length: 9.5cm, weight 7.97gm, donor: NMFS, Seattle, processed: 22 Sept 97 | Date of death | 1997-- | 1997-- | 1997 | Bering Sea | Bering Sea | Bering Sea | unknown | 60.0 | -175.0 | 0.0192 | 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/2334010 | 2334010 | https://www.gbif.org/species/2334010|https://www.fishbase.ca/summary/11716|NCBI:txid1176151 | 167274 | ITIS TSN: 167274 | https://www.fishbase.ca/summary/11716 | 11716 | Gymnocanthus pistilliger | Gymnocanthus pistilliger (Pallas, 1814) | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Gymnocanthus | pistilliger | species | (Pallas, 1814) | accepted | Gymnocanthus pistilliger (Pallas, 1814) | Threaded Sculpin | weightlength | Weight | Length | g | cm | 9.5 | 7.97 | 97 | 38 | 5000.0 | Bering Sea | |||||||||||||||||||||||||||||||||||||||||||||
1506 | 1506 | 1505 | 1683 | 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-92.70 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-92.70 | 92.70 | From Thrifty's, fresh from Hawaii | M? | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid34814 | 34814 | 92/70 | from Thrifty's Nov 18, fresh from Hawaii, length: 1012cm, (94 Fork length), no weight because dressed, processed June 93 | From Thrifty's Nov 18, fresh from Hawaii, length: 1012cm, (94 Fork length), no weight because dressed, processed June 93 | Date entered collection | 1992-11-18 | 1992-11-18 | 1992 | 11 | 18 | USA | USA | HI | Hawaii | unknown | 21.4919 | -157.999 | 0.0673 | 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/2381939 | 2381939 | https://www.gbif.org/species/2381939|https://www.fishbase.ca/summary/6|NCBI:txid34814 | 168791 | ITIS TSN: 168791 | https://www.fishbase.ca/summary/6 | 6 | Coryphaena hippurus | Coryphaena hippurus Linnaeus, 1758 | Animalia | Chordata | Actinopterygii | Perciformes | Coryphaenidae | Coryphaena | hippurus | species | Linnaeus, 1758 | accepted | Coryphaena hippurus Linnaeus, 1758 | Mahi mahi | weightlength | Length | cm | 1012 | 92 | 70 | 50000.0 | Hawaii | |||||||||||||||||||||||||||||||||||||||||||
1560 | 1560 | 1559 | 1752 | 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-91.81 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-91.81 | 91.81 | L.S.Smith | Male? | Likely 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:txID | NCBI:txID | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id= | 91/81 | Caught with beach seine | From Alki beach/seatltle, US, Caught with beach seine, Donated: December 1990, Probably male (Large symetrical swellings on anal fin). Length: 40.5cm, Weight: 866.71g, Collected: November 28,1990 LS Smith, Processed: May 29, 1991 boiling + Trypsin | Date of death | 1990-11-28 | 1990-11-28 | 1990 | 11 | 28 | North America | USA | USA | WA | Seattle | Alki Beach | Alki Beach, Seattle, Washington | unknown | 47.58175 | -122.40581 | 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/2389316 | 2389316 | https://www.gbif.org/species/2389316|http://www.fishbase.se/summary/|NCBI:txID | 649417 | ITIS TSN: 649417 | http://www.fishbase.se/summary/ | Damalichthys vacca | Damalichthys vacca Girard, 1855 | Animalia | Chordata | Actinopterygii | Perciformes | Embiotocidae | Rhacochilus | vacca | species | Girard, 1855 | synonym | Damalichthys vacca Girard, 1855 | Pile Perch | weightlength | 40.5 | 866.71 | 91 | 81 | 50000.0 | Seattle, Washington | |||||||||||||||||||||||||||||||||||||||||
1628 | 1628 | 1627 | 1831 | 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-91.97 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-91.97 | 91.97 | L.S.Smith | Male? | Likely 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:txID | NCBI:txID | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id= | 91/97 | Caught with beach seine | From Alki beach/Seattle, US Caught with beach seine, Donated Dec 1990, LS Smith, symetrical swellings on anal fin: probably male, musscles + barnacles in stomach, Length: 37.5cm, Weight: 882.01g, Collected: Nov 28, 1991, LS Smith, Processed: June 12, 1991, boiling + Trypsin | Date of death | 1990-11-28 | 1990-11-28 | 1990 | 11 | 28 | North America | USA | USA | WA | Seattle | Alki Beach | Alki Beach, Seattle, Washington | unknown | 47.58175 | -122.40581 | 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/2389316 | 2389316 | https://www.gbif.org/species/2389316|http://www.fishbase.se/summary/|NCBI:txID | 649417 | ITIS TSN: 649417 | http://www.fishbase.se/summary/ | Damalichthys vacca | Damalichthys vacca Girard, 1855 | Animalia | Chordata | Actinopterygii | Perciformes | Embiotocidae | Rhacochilus | vacca | species | Girard, 1855 | synonym | Damalichthys vacca Girard, 1855 | Pile Perch | weightlength | Weight | Length | g | cm | 37.5 | 882.01 | 91 | 97 | 5000.0 | Seattle, Washington | |||||||||||||||||||||||||||||||||||||||
1891 | 1891 | 1890 | 2126 | 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.3 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Mammals | PreservedSpecimen | UVICZL-82.3 | 82.3 | M? | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid9615 | 82/3 | Family pet buried in DjSf13, "Tippy" | Family pet buried on site DjSf13, "Tippy", Possibly male. | Date entered collection | 1982-- | 1982-- | 1982 | North America | Vancouver Island | Canada | CA | BC | Victoria | site DjSf13 | unknown | 48.4222 | -123.3657 | 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/6164210 | 6164210 | https://www.gbif.org/species/6164210|NCBI:txid9615 | 726821 | ITIS TSN: 726821 | Canis lupus subsp. familiaris | Canis lupus subsp. familiaris Linnaeus, 1758 | Animalia | Chordata | Mammalia | Carnivora | Canidae | Canis | lupus | familiaris | subspecies | Linnaeus, 1758 | accepted | Canis lupus subsp. familiaris Linnaeus, 1758 | Domestic dog | Canis familiaris | 82 | 3 | 1982 | 49.75152 | -126.48958 | 271.2599920615793 | SENĆOŦEN / Malchosen / Lkwungen / Semiahmoo / T’Sou-ke | 50000.0 | BC | |||||||||||||||||||||||||||||||||||||||||||
1905 | 1905 | 1904 | 2141 | 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-84.48 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Mammals | PreservedSpecimen | UVICZL-84.48 | 84.48 | M? | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid9720 | 84/48 | Found dead on beach below Chinese Cemetary, buried to process, uncovered May 9, 1988 | Found dead on beach below Chinese Cemetary, Aug 5, 1984, buried to process same day, uncovered May 9, 1988 | Date entered collection | 1984-8-5 | 1984-8-5 | 1984 | 8 | 5 | North America | Vancouver Island | Canada | CA | BC | Victoria | Chinese Cemetary Beach | Chinese Cemetary beach, Victoria, BC | unknown | 48.40694 | -123.32351 | 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/2434793 | 2434793 | https://www.gbif.org/species/2434793|NCBI:txid9720 | 180649 | ITIS TSN: 180649 | Phoca vitulina | Phoca vitulina Linnaeus, 1758 | Animalia | Chordata | Mammalia | Carnivora | Phocidae | Phoca | vitulina | species | Linnaeus, 1758 | accepted | Phoca vitulina Linnaeus, 1758 | Harbour seal | Phoca vitulina | 84 | 48 | 1984 | 48.450234 | -123.343529 | 5.035578892465511 | SENĆOŦEN / Malchosen / Lkwungen / Semiahmoo / T’Sou-ke | 5000.0 | Victoria, BC | |||||||||||||||||||||||||||||||||||||||||
2025 | 2025 | 2024 | 2274 | 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-96.10 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Mammals | PreservedSpecimen | UVICZL-96.10 | 96.10 | Jim Bodkin | Alaska Science Center | M? | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | subadult | Subadult tDAR Faunal Age Ontology doi:10.6067/XCV8PZ574Q | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid34882 | 96/10 | Subadult, beach cast in south central Alaska, early 1990's, Cook Inlet or Prince William Sound, broken jaw, Processed March 7, 1996 | Subadult, beach cast in south central Alaska, early 1990's, Cook Inlet or Prince William Sound, broken jaw, Processed March 7, 1996. Donated by: Jim Bodkin, Alaska Science Centre. | Processed | 1996-3-7 | 1996-3-7 | 1996 | 3 | 7 | North America | USA | USA | AK | Southcentral Alaska | south-central Alaska | unknown | 61.1 | -148.0 | 0.1 | 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/2433670 | 2433670 | https://www.gbif.org/species/2433670|NCBI:txid34882 | 180547 | ITIS TSN: 180547 | Enhydra lutris | Enhydra lutris Linnaeus, 1758 | Animalia | Chordata | Mammalia | Carnivora | Mustelidae | Enhydra | lutris | species | Linnaeus, 1758 | accepted | Enhydra lutris (Linnaeus, 1758) | Sea otter | Enhydra lutris | 96 | 10 | 1996 | 5000.0 | central Alaska | ||||||||||||||||||||||||||||||||||||||||||||
2047 | 2047 | 2046 | 2299 | 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-98.135 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Mammals | PreservedSpecimen | UVICZL-98.135 | 98.135 | Becky Wigen | M? | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | skull | skull tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skull OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0003129 | NCBI:txid9615 | 98/135 | Complete skeleton found on edge of Thetis Lake Park, male? | Complete skeleton found on edge of Thetis Lake Park, male?. Donor: B. Wigen | Date entered collection | 1998-8-20 | 1998-8-20 | 1998 | 8 | 20 | North America | Thetis Lake | Vancouver Island | Canada | CA | BC | Thetis Lake, Vancouver Island | unknown | 48.46633 | -123.46931 | 0.0635 | 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/6164210 | 6164210 | https://www.gbif.org/species/6164210|NCBI:txid9615 | 726821 | ITIS TSN: 726821 | Canis lupus subsp. familiaris | Canis lupus subsp. familiaris Linnaeus, 1758 | Animalia | Chordata | Mammalia | Carnivora | Canidae | Canis | lupus | familiaris | subspecies | Linnaeus, 1758 | accepted | Canis lupus subsp. familiaris Linnaeus, 1758 | Domestic dog | Canis familiaris | 98 | 135 | 1998 | 49.65064 | -125.44939 | 195.32876730933768 | Coast Salish | 50000.0 | Vancouver Island | ||||||||||||||||||||||||||||||||||||||||
2163 | 2163 | 2162 | 2425 | 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-13.9 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Mammals | PreservedSpecimen | UVICZL-13.9 | 13.9 | Pete Dady | M? | Likely Male tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid9704 | 13/9 | Skeleton found on beach Nettle Island, no skull present, fully fused elements, identified mainly on basis of size | Donated by Pete Dady, Located from Nettle Island. Partial Skeleton-no skull present, fully fused elements, size fits California better than Nortern-BW. Identified mainly on basis of size. | -- | -- | North America | Broken Group Islands | Nettle Island | Canada | CA | BC | Nettle Island, Broken Group, BC | unknown | 48.93291 | -125.25281 | 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/2433458 | 2433458 | https://www.gbif.org/species/2433458|NCBI:txid9704 | 180621 | ITIS TSN: 180621 | Zalophus californianus | Zalophus californianus Lesson, 1828 | Animalia | Chordata | Mammalia | Carnivora | Otariidae | Zalophus | californianus | species | Lesson, 1828 | accepted | Zalophus californianus (Lesson, 1828) | California sea lion? | Zalophus californianus? | 13 | 9 | 2013 | 48.89717 | -125.36104 | 8.851212641328516 | Nuučaan̓uɫ | 50000.0 | Broken Group, 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 );