geocoded
Data license: Creative Commons V4.0 · Data source: Zoo Arch Project OSF
2 rows where decimalLongitude = "-125.7275" and month = 4
This data as json, CSV (advanced)
vernacularName 2
taxonID 2
specificEpithet 2
- americana 1
- americanus 1
scientificName 2
recordedBy 2
occurrenceRemarks 2
- Processed 2/7/86 skinned with entrails weight: 512.7. Donated by Graham Smyth. 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 2
lifeStage 2
family 2
- Mustelidae 1
- Ursidae 1
eventRemarks 2
bibliographicCitation 2
NCBIIDrefURL 2
waterBody 1
- - 2
taxonRank 1
- species 2
subgenus 1
- - 2
stateProvince 1
- BC 2
sex 1
- - 2
phylum 1
- Chordata 2
order 1
nativeLandLanguage 1
municipality 1
- - 2
month 1
- 4 · 2 ✖
kingdom 1
- Animalia 2
islandGroup 1
- - 2
island 1
infraspecificEpithet 1
- - 2
georeferencedBy 1
georeferenceSources 1
georeferenceRemarks 1
- - 2
fishbaseIDURL 1
- - 2
dynamicProperties 1
- - 2
decimalLongitude 1
- -125.7275 · 2 ✖
decimalLatitude 1
- 49.7155 2
datasetName 1
countryCode 1
- CA 2
country 1
- Canada 2
coordinatePrecision 1
- - 2
continent 1
associatedReferences 1
- - 2
associatedMedia 1
- - 2
IndigenousName 1
- - 2
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1947 | 1947 | 1946 | 2187 | 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.96 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Mammals | PreservedSpecimen | UVICZL-87.96 | 87.96 | Graham Smyth | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid9660 | 87/96 | processed 2/7/86 skinned with entrails | Processed 2/7/86 skinned with entrails weight: 512.7. Donated by Graham Smyth. | Date entered collection | 1987-4-1 | 1987-4-1 | 1987 | 4 | 1 | 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/5218864 | 5218864 | https://www.gbif.org/species/5218864|NCBI:txid9660 | 180559 | ITIS TSN: 180559 | Martes americana | Martes americana Turton, 1806 | Animalia | Chordata | Mammalia | Carnivora | Mustelidae | Martes | americana | species | Turton, 1806 | accepted | Martes americana (Turton, 1806) | American marten | Martes americana | weight | Weight | g | 512.7 | 512.7 | 87 | 96 | 1987 | 49.75152 | -126.48958 | 54.916801230269364 | Nuučaan̓uɫ | 50000.0 | 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 );