Species Distinct Per Site

Owned by Edmond Chuc (Unlicensed)
Last updated: 12 Nov 2019 by Javier Sanchez
1 min read

Input

Source: AUSPLOTS_RANGELANDS.SPECIES_DISTINCT_PER_SITE

Missing table and relationship in AusPlots Rangelands' SchemaSpy - no generated schema image.

Interpretation in TERN Plot Ontology

Encoding each row in RDF requires:

  • …

Mapping Table

Source Column

Destination RDF Predicate

Comments

Source Column

Destination RDF Predicate

Comments

site_location_visit_id

sosa:isResultOf, sosa:isSampleOf

Domain: plot:SiteTaxon

Use sosa:isResultOf to link to a plot:SiteVisit.

Use sosa:isSampleOf to link directly to a plot:Site.

herbarium_determination

plot:taxon

Domain: plot:SiteTaxon

Range: dwct:Taxon - match herbarium_determination value with the dwct:scientificName of the dwct:Taxon.

id

dct:identifier

 

Example Row

SITE_LOCATION_VISIT_ID

HERBARIUM_DETERMINATION

ID

SITE_LOCATION_VISIT_ID

HERBARIUM_DETERMINATION

ID

53471

Aristida jerichoensis var. subspinulifera

865

Example RDF

@prefix ausplots: <http://linked.data.gov.au/dataset/ausplots/> . @prefix ausplots-cv: <http://linked.data.gov.au/def/ausplots-cv/> . @prefix biod: <http://linked.data.gov.au/def/biodiversity/> . @prefix bioreg: <http://linked.data.gov.au/dataset/bioregion/> . @prefix data: <http://linked.data.gov.au/def/datatype/> . @prefix dct: <http://purl.org/dc/terms/> . @prefix dwct: <http://rs.tdwg.org/dwc/terms/> . @prefix epsg-crs: <http://www.opengis.net/def/crs/epsg/0/> . @prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> . @prefix geosparql: <http://www.opengis.net/ont/geosparql#> . @prefix geosparql-ext: <http://linked.data.gov.au/def/geox#> . @prefix ldp: <http://www.w3.org/ns/ldp#> . @prefix locn: <http://www.w3.org/ns/locn#> . @prefix owl: <http://www.w3.org/2002/07/owl#> . @prefix plot: <http://linked.data.gov.au/def/plot/> . @prefix plot-x: <http://linked.data.gov.au/def/plot/x/> . @prefix prov: <http://www.w3.org/ns/prov#> . @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> . @prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> . @prefix reg: <http://purl.org/linked-data/registry/> . @prefix sdo: <http://schema.org/> . @prefix skos: <http://www.w3.org/2004/02/skos/core#> . @prefix sosa: <http://www.w3.org/ns/sosa/> . @prefix ssn: <http://www.w3.org/ns/ssn/> . @prefix ssn-ext: <http://www.w3.org/ns/ssn/ext/> . @prefix time: <http://www.w3.org/2006/time#> . @prefix ui: <http://purl.org/linked-data/registry-ui#> . @prefix unit: <http://qudt.org/vocab/unit/> . @prefix void: <http://rdfs.org/ns/void#> . @prefix xml: <http://www.w3.org/XML/1998/namespace> . @prefix xsd: <http://www.w3.org/2001/XMLSchema#> . <http://linked.data.gov.au/dataset/ausplots/sv-53471-specie-Aristida+jerichoensis+var.+subspinulifera> a plot:SiteTaxon ; plot:taxon <http://linked.data.gov.au/def/biodiversity/Aristida+jerichoensis+var.+subspinulifera> ; sosa:isResultOf ausplots:sv-53471 ; sosa:isSampleOf ausplots:site-59890 .