Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

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

53471

Aristida jerichoensis var. subspinulifera

865

Example RDF

Code Block
breakoutModewide
languagepy
@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 .