geocoded
Data license: Creative Commons V4.0 · Data source: Zoo Arch Project OSF
7 rows where day = 4 and decimalLatitude = "55.0013"
This data as json, CSV (advanced)
Suggested facets: sexOriginal, lifeStageOriginal, otherCatalogNumbers, verbatimEventDate, verbatimLocality, fishbaseID, _73, scientificNameAuthorship, measurementType, measurementUnit, measurementValue, catalogueYearYy, catalogueYearYyyy, geocoderDecimalLatitude, geocoderDecimalLongitude, DistanceInKMBetweenTwoCoordinates, georeferencePrecision, georeferenceRemarksFromGeocoder
vernacularName 7
taxonID 7
specificEpithet 7
- coronata 1
- curvirostra 1
- lucius 1
- ludoviciana 1
- pyrrhonota 1
- rufescens 1
- thalassina 1
scientificName 7
occurrenceRemarks 7
- BCPM #B85-156, weight: 6.6g, donated: BC Prov. Museum, processed: Feb 4/88 1
- BCPM #B86-845, weight: 11.5g, donated: BC Prov Museum, processed: Feb 4/88 1
- BCPM#86-994, weight: 30.6g, donated: BC Prov Museum, Museum # 86-994, processed: Feb 4/88 1
- Juvenile, BCPM# B87-245, Weight: 31.1g, donated: BC Prov. Museum, Museum #b87:245. Processed: Feb 4/88 1
- Location: Victoria Fish Market- Imported from Alberta. Date: July 4, 1985 (bought). Gutted, weight 3632 gm, approx 8lbs evicerated. L: 69+(fins chewed) Prep: Trypsin. Scales kept. 1
- Weight 14.1g, donated: B.C. prov. Museum, BCPM#: 87-58, processed: Feb 4/88 1
- Weight: 10.2g donated: B.C. Prov Museum, BCPM# B86:523, processed: Feb 4/88 1
occurrenceID 7
genus 7
- Esox 1
- Loxia 1
- Petrochelidon 1
- Piranga 1
- Poecile 1
- Setophaga 1
- Tachycineta 1
bibliographicCitation 7
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-85.42 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-88.12 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-88.13 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-88.14 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-88.15 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-88.16 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-88.19 1
NCBIIDrefURL 7
family 6
- Hirundinidae 2
- Cardinalidae 1
- Esocidae 1
- Fringillidae 1
- Paridae 1
- Parulidae 1
order 2
nativeLandLanguage 2
lifeStage 2
fishbaseIDURL 2
eventRemarks 2
datasetName 2
waterBody 1
- - 7
taxonRank 1
- species 7
subgenus 1
- - 7
preparations 1
- - 7
phylum 1
- Chordata 7
municipality 1
- - 7
kingdom 1
- Animalia 7
islandGroup 1
- - 7
island 1
- - 7
infraspecificEpithet 1
- - 7
georeferencedBy 1
georeferenceSources 1
georeferenceRemarks 1
- - 7
dynamicProperties 1
- - 7
decimalLatitude 1
- 55.0013 · 7 ✖
day 1
- 4 · 7 ✖
countryCode 1
- CA 7
country 1
- Canada 7
coordinatePrecision 1
- - 7
continent 1
associatedReferences 1
- - 7
associatedMedia 1
- - 7
IndigenousName 1
- - 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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
300 | 300 | 299 | 333 | 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.12 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Birds | PreservedSpecimen | UVICZL-88.12 | 88.12 | BCPM | NCBI:txID64802 | NCBI:txID64802 | 64802 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=64802 | BCPM#86-994 | BCPM#86-994, weight: 30.6g, donated: BC Prov Museum, Museum # 86-994, processed: Feb 4/88 | Processed | 1988-2-4 | 1988-2-4 | 1988 | 2 | 4 | 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/9629160 | 9629160 | https://www.gbif.org/species/9629160|NCBI:txID64802 | 179259 | ITIS TSN: 179259 | Loxia curvirostra | Loxia curvirostra Linnaeus, 1758 | Animalia | Chordata | Aves | Passeriformes | Fringillidae | Loxia | curvirostra | species | Linnaeus, 1758 | accepted | Loxia curvirostra Linnaeus, 1758 | Red crossbill | weight | Weight | g | 30.6 | 88 | 12 | 1988 | 5000.0 | Canada, BC | |||||||||||||||||||||||||||||||||||||||||||||||
301 | 301 | 300 | 334 | 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.13 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Birds | PreservedSpecimen | UVICZL-88.13 | 88.13 | BCPM | F | Female tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | juvenile | Juvenile tDAR Faunal Age Ontology doi:10.6067/XCV8PZ574Q | NCBI:txID63520 | NCBI:txID63520 | 63520 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=63520 | Juvenile, BCPM# B87-245 | Juvenile, BCPM# B87-245, Weight: 31.1g, donated: BC Prov. Museum, Museum #b87:245. Processed: Feb 4/88 | Processed | 1988-2-4 | 1988-2-4 | 1988 | 2 | 4 | 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/2488484 | 2488484 | https://www.gbif.org/species/2488484|NCBI:txID63520 | 179882 | ITIS TSN: 179882 | Piranga ludoviciana | Piranga ludoviciana (A.Wilson, 1811) | Animalia | Chordata | Aves | Passeriformes | Cardinalidae | Piranga | ludoviciana | species | (A.Wilson, 1811) | accepted | Piranga ludoviciana (A.Wilson, 1811) | Western tanager | weight | Weight | g | 31.1 | 88 | 13 | 1988 | 5000.0 | Canada, BC | |||||||||||||||||||||||||||||||||||||||||||
302 | 302 | 301 | 335 | 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.14 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Birds | PreservedSpecimen | UVICZL-88.14 | 88.14 | BCPM | NCBI:txID72884 | NCBI:txID72884 | 72884 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=72884 | BCPM# B86-523 | Weight: 10.2g donated: B.C. Prov Museum, BCPM# B86:523, processed: Feb 4/88 | Processed | 1988-2-4 | 1988-2-4 | 1988 | 2 | 4 | 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/2489169 | 2489169 | https://www.gbif.org/species/2489169|NCBI:txID72884 | 178455 | ITIS TSN: 178455 | Petrochelidon pyrrhonota | Petrochelidon pyrrhonota (Vieillot, 1817) | Animalia | Chordata | Aves | Passeriformes | Hirundinidae | Petrochelidon | pyrrhonota | species | (Vieillot, 1817) | accepted | Petrochelidon pyrrhonota (Vieillot, 1817) | Cliff swallow | weight | Weight | g | 10.2 | 88 | 14 | 1988 | 5000.0 | Canada, BC | |||||||||||||||||||||||||||||||||||||||||||||||
303 | 303 | 302 | 336 | 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.15 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Birds | PreservedSpecimen | UVICZL-88.15 | 88.15 | BCPM | NCBI:txID173226 | NCBI:txID173226 | 173226 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=173226 | BCPM# 87-58 | Weight 14.1g, donated: B.C. prov. Museum, BCPM#: 87-58, processed: Feb 4/88 | Processed | 1988-2-4 | 1988-2-4 | 1988 | 2 | 4 | 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/5230754 | 5230754 | https://www.gbif.org/species/5230754|NCBI:txID173226 | 178427 | ITIS TSN: 178427 | Tachycineta thalassina | Tachycineta thalassina (Swainson, 1827) | Animalia | Chordata | Aves | Passeriformes | Hirundinidae | Tachycineta | thalassina | species | (Swainson, 1827) | accepted | Tachycineta thalassina (Swainson, 1827) | Violet-green swallow | weight | Weight | g | 14.1 | 88 | 15 | 1988 | 5000.0 | Canada, BC | |||||||||||||||||||||||||||||||||||||||||||||||
304 | 304 | 303 | 337 | 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.16 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Birds | PreservedSpecimen | UVICZL-88.16 | 88.16 | BCPM | NCBI:txID142476 | NCBI:txID142476 | 142476 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=142476 | BCPM #B85-156 | BCPM #B85-156, weight: 6.6g, donated: BC Prov. Museum, processed: Feb 4/88 | Processed | 1988-2-4 | 1988-2-4 | 1988 | 2 | 4 | 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/2487783 | 2487783 | https://www.gbif.org/species/2487783|NCBI:txID142476 | 554387 | ITIS TSN: 554387 | Poecile rufescens | Poecile rufescens (J.K.Townsend, 1837) | Animalia | Chordata | Aves | Passeriformes | Paridae | Poecile | rufescens | species | (J.K.Townsend, 1837) | accepted | Poecile rufescens (J.K.Townsend, 1837) | Chestnut-backed chickadee | weight | Weight | g | 6.6 | 88 | 16 | 1988 | 5000.0 | Canada, BC | |||||||||||||||||||||||||||||||||||||||||||||||
307 | 307 | 306 | 340 | 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.19 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Birds | PreservedSpecimen | UVICZL-88.19 | 88.19 | BCPM | NCBI:txID111975 | NCBI:txID111975 | 111975 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=111975 | BCPM #B86-845 | BCPM #B86-845, weight: 11.5g, donated: BC Prov Museum, processed: Feb 4/88 | Processed | 1988-2-4 | 1988-2-4 | 1988 | 2 | 4 | 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/7341805 | 7341805 | https://www.gbif.org/species/7341805|NCBI:txID111975 | 950046 | ITIS TSN: 950046 | Setophaga coronata | Setophaga coronata (Linnaeus, 1766) | Animalia | Chordata | Aves | Passeriformes | Parulidae | Setophaga | coronata | species | (Linnaeus, 1766) | accepted | Setophaga coronata (Linnaeus, 1766) | Yellow-rumped warbler | weight | Weight | g | 11.5 | 88 | 19 | 1988 | 50000.0 | Canada, BC | |||||||||||||||||||||||||||||||||||||||||||||||
1408 | 1408 | 1407 | 1579 | 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.42 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-85.42 | 85.42 | NCBI:txID8010 | NCBI:txID8010 | 8010 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=8010 | 85/42 | Gutted, weight 3632 gm, purchased at market | Location: Victoria Fish Market- Imported from Alberta. Date: July 4, 1985 (bought). Gutted, weight 3632 gm, approx 8lbs evicerated. L: 69+(fins chewed) Prep: Trypsin. Scales kept. | Date entered collection | 1985-7-4 | 1985-7-4 | 1985 | 7 | 4 | North America | Canada | CA | AB | Alberta | unknown | 55.0013 | -115.0021 | 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/2346633 | 2346633 | https://www.gbif.org/species/2346633|http://www.fishbase.se/summary/258|NCBI:txID8010 | 162139 | ITIS TSN: 162139 | http://www.fishbase.se/summary/258 | 258 | Esox lucius | Esox lucius Linnaeus, 1758 | Animalia | Chordata | Actinopterygii | Esociformes | Esocidae | Esox | lucius | species | Linnaeus, 1758 | accepted | Esox lucius Linnaeus, 1758 | Northern Pike | weight | 69 | 85 | 42 | 55.2816 | -115.0 | 31.168223680648293 | ᓀᐦᐃᔭᐍᐏᐣ Nēhiyawēwin (Plains Cree) | 50000.0 | Alberta |
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 );