Soil Subsite Observations

Owned by Edmond Chuc (Unlicensed)
Last updated: 16 Apr 2020 by Javier Sanchez
4 min read

Input

Source: AUSPLOTS_RANGELANDS.SOIL_SUBSITE_OBSERVATIONS

Interpretation in TERN Plot Ontology

Encoding each row in RDF requires:

  • todo

Mapping Table

Source Column

Destination RDF Predicate

Comments

Source Column

Destination RDF Predicate

Comments

id

dct:identifier, rdfs:label

 

site_location_visit_id

plot:wasSubActivityOf

Domain: ssn-ext:ObservationCollection with dct:type SITE AND LOCATION

Range: plot:SiteVisit

subsite_id

dct:hasPart

Domain: plot:Site of the main site

Range: plot:Site of this sub-site

TS- I think these are the sub soil sampling sites, see page 50 of manual and data sheet at end of the manual (page 82 and 84)

(five sub soil sampling sites within a 25 m x 25 m zone in the south west corner of the plot @ 0-10 cm, 10-20 cm and 20-30 cm)

zone

 

review

EC - For all the location data, we can convert it the UTM system to latitude and longitude and capture the data with the plot:Location and geo:Point classes.

TS - see comment above

easting

 

review

TS - see comment above

northing

 

review

TS - see comment above

zero_to_ten_barcode

sosa:hasSample

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

Range: sosa:Sample

  • sosa:hasResult:

    • rdf:type: data:Text

    • data:value: zero_to_ten_barcode

Create sosa:Sampling instance

ten_to_twenty_barcode

sosa:hasSample

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

Range: sosa:Sample

  • sosa:hasResult:

    • rdf:type: data:Text

    • data:value: ten_to_twenty_barcode

Create sosa:Sampling instance

twenty_to_thirty_barcode

sosa:hasSample

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

Range: sosa:Sample

  • sosa:hasResult:

    • rdf:type: data:Text

    • data:value: twenty_to_thirty_barcode

Create sosa:Sampling instance

comments

rdfs:comment

 

metagenomics_are_available

 

Not captured by TERN Plot Ontology.

Can see if it is available by testing to see if a metagenomic_barcode sample is present.

metagenomic_barcode

sosa:hasSample

Domain: ssn-ext:ObservationCollection

Range: sosa:Sample

  • sosa:hasResult:

    • rdf:type: data:Text

    • data:value: metagenomic_barcode

Create sosa:Sampling instance

metagenomic_url

 

Not captured by TERN Plot Ontology.

All values are null.

photo_no

 

Done

TS: should be sample, with sosa:usedProcedure: http://linked.data.gov.au/def/ausplots-cv/b49db586-17e6-4a6b-8a48-167e2ad9c577

Should this be a sample or an observation? The value is not the photo file name. What is it?

photo_url

 

Not captured by TERN Plot Ontology.

All values are either null or “EMPTY”.

observer

 

Value from look-up table lut_observer

  • rdf:type: prov:Person, sdo:Person

  • sdo:givenName: First name

  • sdo:familyName: Last name

  • prov:actedOnBehalfOf:

    • rdf:type: prov:Organization, sdo:Organization

    • sdo:legalName: Name of the organization

Example Row

ID

SITE_LOCATION_VISIT_ID

SUBSITE_ID

ZONE

EASTING

NORTHING

ZERO_TO_TEN_BARCODE

TEN_TO_TWENTY_BARCODE

TWENTY_TO_THIRTY_BARCODE

COMMENTS

METAGENOMICS_ARE_AVAILABLE

METAGENOMIC_BARCODE

METAGENOMIC_URL

PHOTO_NO

PHOTO_URL

OBSERVER

ID

SITE_LOCATION_VISIT_ID

SUBSITE_ID

ZONE

EASTING

NORTHING

ZERO_TO_TEN_BARCODE

TEN_TO_TWENTY_BARCODE

TWENTY_TO_THIRTY_BARCODE

COMMENTS

METAGENOMICS_ARE_AVAILABLE

METAGENOMIC_BARCODE

METAGENOMIC_URL

PHOTO_NO

PHOTO_URL

OBSERVER

329296

53471

1

55

202744

7851382

QDA 050387

QDA 050388

QDA 050389

between grass tussocks

TRUE

QDA 053180

null

null

null

4

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#> . ausplots:l-53471-329296 a plot:Location ; rdfs:label "Location l-53471-329296" ; plot-x:isLocationOf ausplots:site-53471-329296 ; dct:description "Location from SubSite: '329296' converted from UTM (zone=55, easting=202744, northing=7851382)" ; dct:identifier "l-53471-329296" ; geosparql:hasGeometry [ a geo:Point ; geo:lat -1.940984e+01 ; geo:long 1.441696e+02 ] . ausplots:s-oc-53471 a ssn-ext:ObservationCollection ; rdfs:label "AUSPLOTS Rangelands 'Soil' Observation Collection for SiteVisit: '53471'" ; plot:wasSubActivityOf ausplots:sv-53471 ; dct:identifier 53471 ; dct:type <http://linked.data.gov.au/def/ausplots-cv/68eec465-a91e-49a8-9265-6da7ef8ad284> ; sosa:hasSample ausplots:s-oc-53471-sso-329296-s-1, ausplots:s-oc-53471-sso-329296-s-2, ausplots:s-oc-53471-sso-329296-s-3, ausplots:s-oc-53471-sso-329296-s-4; ssn-ext:hasMember ausplots:s-oc-53471-sso-329296-o-1 . ausplots:s-oc-53471-sso-329296-o-1 a sosa:Observation ; rdfs:label "SiteVisit: '53471' | Soil Subsite Observations: '329296' | Observation 1 (OBSERVER)" ; sosa:hasFeatureOfInterest ausplots:s-oc-53471-sso-329296-s-1, ausplots:s-oc-53471-sso-329296-s-2, ausplots:s-oc-53471-sso-329296-s-3, ausplots:s-oc-53471-sso-329296-s-4 ; sosa:hasResult <http://linked.data.gov.au/def/ausplots-cv/3c8cb579-ebc1-4b63-90a8-b5c792040225> ; sosa:observedProperty <not_needed> ; sosa:usedProcedure ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 . ausplots:site-53471-329296 a plot:Site ; rdfs:label "SubsiteID: '1' | SiteVisit: '53471' | Site: '59890'" ; dct:identifier "53471-329296" ; dct:isPartOf ausplots:site-59890 ; rdfs:comment "This is a Subsite" ; sosa:hasSample ausplots:s-oc-53471-sso-329296-s-1, ausplots:s-oc-53471-sso-329296-s-2, ausplots:s-oc-53471-sso-329296-s-3, ausplots:s-oc-53471-sso-329296-s-4 . ausplots:s-oc-53471-sso-329296-s-1 a sosa:Sample ; rdfs:label "Sample: QDA 050387" ; dct:identifier "QDA 050387" ; rdfs:comment "Column: ZERO_TO_TEN_BARCODE", "between grass tussocks" ; sosa:hasResult [ a data:Text ; data:value "QDA 050387" ] ; sosa:isResultOf [ a sosa:Sampling ; sosa:usedProcedure <http://linked.data.gov.au/def/ausplots-cv/6d5764b3-6a0c-4937-88f1-11fe280c6524> ] . ausplots:s-oc-53471-sso-329296-s-2 a sosa:Sample ; rdfs:label "Sample: QDA 050388" ; dct:identifier "QDA 050388" ; rdfs:comment "Column: TEN_TO_TWENTY_BARCODE", "between grass tussocks" ; sosa:hasResult [ a data:Text ; data:value "QDA 050388" ] ; sosa:isResultOf [ a sosa:Sampling ; sosa:usedProcedure <http://linked.data.gov.au/def/ausplots-cv/6d5764b3-6a0c-4937-88f1-11fe280c6524> ] . ausplots:s-oc-53471-sso-329296-s-3 a sosa:Sample ; rdfs:label "Sample: QDA 050389" ; dct:identifier "QDA 050389" ; rdfs:comment "Column: TWENTY_TO_THIRTY_BARCODE", "between grass tussocks" ; sosa:hasResult [ a data:Text ; data:value "QDA 050389" ] ; sosa:isResultOf [ a sosa:Sampling ; sosa:usedProcedure <http://linked.data.gov.au/def/ausplots-cv/6d5764b3-6a0c-4937-88f1-11fe280c6524> ] . ausplots:s-oc-53471-sso-329296-s-4 a sosa:Sample ; rdfs:label "Sample: QDA 053180" ; dct:identifier "QDA 053180" ; rdfs:comment "Column: METAGENOMIC_BARCODE", "between grass tussocks" ; sosa:hasResult [ a data:Text ; data:value "QDA 053180" ] ; sosa:isResultOf [ a sosa:Sampling ; sosa:usedProcedure <http://linked.data.gov.au/def/ausplots-cv/6d5764b3-6a0c-4937-88f1-11fe280c6524> ] .