geocoded
Data license: Creative Commons V4.0 · Data source: Zoo Arch Project OSF
5 rows where coordinateUncertaintyInMeters = "0.0808" and decimalLongitude = "-125.7275"
This data as json, CSV (advanced)
Suggested facets: lifeStageOriginal, preparationsOriginal, NCBIIDref, NCBIID, NCBIIDURL, occurrenceRemarksOriginal, verbatimEventDate, verbatimLocality, GBIFtaxonIDURL, allTaxonIDs, fishbaseID, canonicalName, _73, scientificNameAuthorship, acceptedNameUsage, taxonRemarks, measurementRemarks, measurementType, measurementUnit, catalogueYearYy, catalogueYearYyyy
occurrenceRemarks 5
- Length: 16.0cm, Weight 23.1, Processed: July 21/88, Collected: Same as 88/80 1
- Length: 16.4cm, Weight: 22.2g, Collected: Same as 88/80, Processed: July 21, 88. See 88/80 for data 1
- Length: 16.7cm, Weight 19.3g, Processed: July 21/88, Collected: Same as 88/81 1
- Length:16.5cm, Weight: 23.3g, Processed July 21/88, Collected: Vic. Fish market July 17, West Coast fo Van. Island, Becky Wigen 1
- Skull and front paws missing, epiphysis not fused on long bones or vertebrae. died about ~6 mos earlier (ie April), laid out on ground to be cleaned. From Vancouver Island. Donated by Dr. Morgan Oct 1990. Processed May 7, 1991 1
occurrenceID 5
bibliographicCitation 5
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-88.80 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-88.81 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-88.82 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-88.83 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-91.25 1
vernacularName 2
taxonID 2
specificEpithet 2
- mordax 4
- americanus 1
scientificName 2
recordedBy 2
preparations 2
order 2
lifeStage 2
fishbaseIDURL 2
family 2
- Engraulididae 4
- Ursidae 1
eventRemarks 2
datasetName 2
NCBIIDrefURL 2
waterBody 1
- - 5
taxonRank 1
- species 5
subgenus 1
- - 5
stateProvince 1
- BC 5
sex 1
- - 5
phylum 1
- Chordata 5
nativeLandLanguage 1
municipality 1
- - 5
kingdom 1
- Animalia 5
islandGroup 1
- - 5
island 1
infraspecificEpithet 1
- - 5
georeferencedBy 1
georeferenceSources 1
georeferenceRemarks 1
- - 5
dynamicProperties 1
- - 5
decimalLongitude 1
- -125.7275 · 5 ✖
decimalLatitude 1
- 49.7155 5
day 1
- - 5
countryCode 1
- CA 5
country 1
- Canada 5
coordinateUncertaintyInMeters 1
- 0.0808 · 5 ✖
coordinatePrecision 1
- - 5
continent 1
associatedReferences 1
- - 5
associatedMedia 1
- - 5
IndigenousName 1
- - 5
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1554 | 1554 | 1553 | 1746 | 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.80 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-88.80 | 88.80 | Becky Wigen | scales | scales tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | scales OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0002542 | NCBI:txID239368 | NCBI:txID239368 | 239368 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=239368 | 88/80 | Bought at fish market | Length:16.5cm, Weight: 23.3g, Processed July 21/88, Collected: Vic. Fish market July 17, West Coast fo Van. Island, Becky Wigen | Date entered collection | 1988-7- | 1988-7- | 1988 | 7 | North America | Vancouver Island | Canada | CA | BC | West coast of Vancouver Island, BC | unknown | 49.7155 | -125.7275 | 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/2414024 | 2414024 | https://www.gbif.org/species/2414024|http://www.fishbase.se/summary/1664|NCBI:txID239368 | 161828 | ITIS TSN: 161828 | http://www.fishbase.se/summary/1664 | 1664 | Engraulis mordax | Engraulis mordax Girard, 1854 | Animalia | Chordata | Actinopterygii | Clupeiformes | Engraulididae | Engraulis | mordax | species | Girard, 1854 | accepted | Engraulis mordax Girard, 1854 | Northern Anchovy | weightlength | Weight | Length | g | cm | 16.5 | 23.3 | 88 | 80 | 49.75152 | -126.48958 | 54.916801230269364 | Nuučaan̓uɫ | 50000.0 | Vancouver Island, BC | |||||||||||||||||||||||||||||||||||||
1559 | 1559 | 1558 | 1751 | 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.81 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-88.81 | 88.81 | Becky Wigen | scales | scales tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | scales OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0002542 | NCBI:txID239368 | NCBI:txID239368 | 239368 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=239368 | 88/81 | Bought at fish market | Length: 16.0cm, Weight 23.1, Processed: July 21/88, Collected: Same as 88/80 | Date entered collection | 1988-7- | 1988-7- | 1988 | 7 | North America | Vancouver Island | Canada | CA | BC | West coast of Vancouver Island, BC | unknown | 49.7155 | -125.7275 | 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/2414024 | 2414024 | https://www.gbif.org/species/2414024|http://www.fishbase.se/summary/1664|NCBI:txID239368 | 161828 | ITIS TSN: 161828 | http://www.fishbase.se/summary/1664 | 1664 | Engraulis mordax | Engraulis mordax Girard, 1854 | Animalia | Chordata | Actinopterygii | Clupeiformes | Engraulididae | Engraulis | mordax | species | Girard, 1854 | accepted | Engraulis mordax Girard, 1854 | Northern Anchovy | weightlength | Weight | Length | g | cm | 16 | 23.1 | 88 | 81 | 49.75152 | -126.48958 | 54.916801230269364 | Nuučaan̓uɫ | 50000.0 | Vancouver Island, BC | |||||||||||||||||||||||||||||||||||||
1563 | 1563 | 1562 | 1755 | 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.82 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-88.82 | 88.82 | Becky Wigen | scales | scales tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | scales OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0002542 | NCBI:txID239368 | NCBI:txID239368 | 239368 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=239368 | 88/82 | Bought at fish market | Length: 16.7cm, Weight 19.3g, Processed: July 21/88, Collected: Same as 88/81 | Date entered collection | 1988-7- | 1988-7- | 1988 | 7 | North America | Vancouver Island | Canada | CA | BC | West coast of Vancouver Island, BC | unknown | 49.7155 | -125.7275 | 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/2414024 | 2414024 | https://www.gbif.org/species/2414024|http://www.fishbase.se/summary/1664|NCBI:txID239368 | 161828 | ITIS TSN: 161828 | http://www.fishbase.se/summary/1664 | 1664 | Engraulis mordax | Engraulis mordax Girard, 1854 | Animalia | Chordata | Actinopterygii | Clupeiformes | Engraulididae | Engraulis | mordax | species | Girard, 1854 | accepted | Engraulis mordax Girard, 1854 | Northern Anchovy | weightlength | Weight | Length | g | cm | 16.7 | 19.3 | 88 | 82 | 49.75152 | -126.48958 | 54.916801230269364 | Nuučaan̓uɫ | 50000.0 | Vancouver Island, BC | |||||||||||||||||||||||||||||||||||||
1567 | 1567 | 1566 | 1759 | 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.83 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-88.83 | 88.83 | Becky Wigen | scales | scales tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | scales OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0002542 | NCBI:txID239368 | NCBI:txID239368 | 239368 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=239368 | 88/83 | Bought at fish market | Length: 16.4cm, Weight: 22.2g, Collected: Same as 88/80, Processed: July 21, 88. See 88/80 for data | Date entered collection | 1988-7- | 1988-7- | 1988 | 7 | North America | Vancouver Island | Canada | CA | BC | West coast of Vancouver Island, BC | unknown | 49.7155 | -125.7275 | 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/2414024 | 2414024 | https://www.gbif.org/species/2414024|http://www.fishbase.se/summary/1664|NCBI:txID239368 | 161828 | ITIS TSN: 161828 | http://www.fishbase.se/summary/1664 | 1664 | Engraulis mordax | Engraulis mordax Girard, 1854 | Animalia | Chordata | Actinopterygii | Clupeiformes | Engraulididae | Engraulis | mordax | species | Girard, 1854 | accepted | Engraulis mordax Girard, 1854 | Northern Anchovy | weightlength | Weight | Length | g | cm | 16.4 | 22.2 | 88 | 83 | 49.75152 | -126.48958 | 54.916801230269364 | Nuučaan̓uɫ | 50000.0 | Vancouver Island, BC | |||||||||||||||||||||||||||||||||||||
1989 | 1989 | 1988 | 2235 | 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.25 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Mammals | PreservedSpecimen | UVICZL-91.25 | 91.25 | Chris Morgan | 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:txid9643 | 91/25 | Skull and front paws missing, epiphysis not fused on long bones or vertebrae. died about April, 1991, laid out on ground to be cleaned from Vancouver Island. Donated Oct 1990. Processed May 7, 1991 | Skull and front paws missing, epiphysis not fused on long bones or vertebrae. died about ~6 mos earlier (ie April), laid out on ground to be cleaned. From Vancouver Island. Donated by Dr. Morgan Oct 1990. Processed May 7, 1991 | Date of death | 1990-4- | 1990-4- | 1990 | 4 | North America | Vancouver Island | Canada | CA | BC | Vancouver Island, BC | unknown | 49.7155 | -125.7275 | 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/2433407 | 2433407 | https://www.gbif.org/species/2433407|NCBI:txid9643 | 180544 | ITIS TSN: 180544 | Ursus americanus | Ursus americanus Pallas, 1780 | Animalia | Chordata | Mammalia | Carnivora | Ursidae | Ursus | americanus | species | Pallas, 1780 | accepted | Ursus americanus Pallas, 1780 | Black bear | Ursus americanus | 91 | 25 | 1991 | 49.75152 | -126.48958 | 54.916801230269364 | Nuučaan̓uɫ | 50000.0 | Vancouver Island, 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 );