Soil Table

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

Source: CORVEG.SOIL

Example row:

SITE_ID

SOURCE_ID

RELIABILITY_ID

TYPECODE_ID

TS_COLOUR_ID

TS_TEXTURE_ID

TS_PH

ISBELL_ID

ADDITIONAL

NOTES

UPDATE_USER

LAST_UPDATE

SITE_ID

SOURCE_ID

RELIABILITY_ID

TYPECODE_ID

TS_COLOUR_ID

TS_TEXTURE_ID

TS_PH

ISBELL_ID

ADDITIONAL

NOTES

UPDATE_USER

LAST_UPDATE

3729

4

2

1

2

6

null

999

0

Top soil texture: sand. Top soil colour: grey/brown. Stoniness: absent.

121

2012-02-27 09:19:39

Interpretation in TERN Plot Ontology

Encoding each row in RDF requires:

  1. An ssn-ext:ObservationCollection with the observation group encoded with dct:type as Soil.

RDF Example

@prefix corveg-cv: <http://linked.data.gov.au/def/corveg-cv/> . @prefix corveg-site: <http://linked.data.gov.au/dataset/corveg/site/> . @prefix corveg-soil: <http://linked.data.gov.au/dataset/corveg/soil/> . @prefix data: <http://linked.data.gov.au/def/datatype/> . @prefix dct: <http://purl.org/dc/terms/> . @prefix plot: <http://linked.data.gov.au/def/plot/> . @prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> . @prefix sosa: <http://www.w3.org/ns/sosa/> . @prefix ssn-ext: <http://www.w3.org/ns/ssn/ext/> . @prefix time: <http://www.w3.org/2006/time#> . @prefix xsd: <http://www.w3.org/2001/XMLSchema#> . corveg-soil:soil-13864 a ssn-ext:ObservationCollection ; rdfs:label "Site 13864 soil observation collection" ; plot:hasResultQuality corveg-cv:d561d214-00ed-4a4c-abb7-a54500369675 ; plot:wasSubActivityOf corveg-site:sitev-13864 ; dct:type corveg-cv:f7cf71ef-4847-42e9-bd6f-e6c093f6d1b2 ; sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ; ssn-ext:hasMember corveg-soil:soil-13864-1, corveg-soil:soil-13864-2, corveg-soil:soil-13864-3 . corveg-soil:soil-13864-1 a sosa:Observation ; rdfs:label "Site 13864 soil type observation" ; sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Concept ; data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:value corveg-cv:68fc1a83-a138-400f-80d6-67770fc84306 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:73ba4128-79a7-4f44-8c68-da742154ac8b ] . corveg-soil:soil-13864-2 a sosa:Observation ; rdfs:label "Site 13864 soil colour observation" ; sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Concept ; data:value corveg-cv:e392c2fc-5cff-48bb-aeb9-82d443c4fc21 ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:value corveg-cv:1842b772-72a4-430f-a264-dcfd6c2c23b4 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:73ba4128-79a7-4f44-8c68-da742154ac8b ] . corveg-soil:soil-13864-3 a sosa:Observation ; rdfs:label "Site 13864 soil texture observation" ; sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Concept ; data:value corveg-cv:65399658-892b-441c-827d-83d1f7597d67 ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:value corveg-cv:ec41e342-f218-4e6b-9a73-625b7427f9da ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:73ba4128-79a7-4f44-8c68-da742154ac8b ] . corveg-site:t1996-06-11-h0-m0-s0 a time:Instant ; time:inXSDDateTime "1996-06-11T00:00:00"^^xsd:dateTime .

Mapping Table

Source Column

Destination RDF Predicate

Comments

Source Column

Destination RDF Predicate

Comments

SITE_ID

sosa:hasFeatureOfInterest

Domain: ssn-ext:ObservationCollection

Range: plot:Site

SOURCE_ID

sosa:usedProcedure

The method used for all sosa:Observation within the ssn-ext:ObservationCollection. A narrower concept of Soil Assessment Methods matching on the skos:hiddenLabel.

RELIABILITY_ID

plot:hasResultQuality

Domain: ssn-ext:ObservationCollection

Range: A narrower concept in the concept scheme Soil Reliability Values matching on the skos:hiddenLabel.

TYPECODE_ID

ssn-ext:hasMember, sosa:hasResult

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Soil profile

CORVEG: Soil

  • sosa:observedProperty: Soil Type

  • sosa:usedProcedure: The skos:Concept of SOURCE_ID.

  • sosa:hasResult: A narrower concept of Soil Type Values matching on the skos:hiddenLabel.

TS_COLOUR_ID

ssn-ext:hasMember, sosa:hasResult

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Soil profile

CORVEG: Soil

  • sosa:observedProperty: Soil Colour

  • sosa:usedProcedure: The skos:Concept of SOURCE_ID.

  • sosa:hasResult: A narrower concept of Soil Colour Values matching on the skos:hiddenLabel.

TS_TEXTURE_ID

ssn-ext:hasMember, sosa:hasResult

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Soil profile

CORVEG: Soil

  • sosa:observedProperty: Soil Texture

  • sosa:usedProcedure: The skos:Concept of SOURCE_ID.

  • sosa:hasResult: A narrower concept of Soil Texture Values matching on the skos:hiddenLabel.

TS_PH

ssn-ext:hasMember, sosa:hasResult

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Soil profile

CORVEG: Soil

  • sosa:observedProperty: Soil pH

  • sosa:usedProcedure: The skos:Concept of SOURCE_ID.

  • sosa:hasResult:

    • Class type: data:QuantitativeMeasure

ISBELL_ID

 

Not captured by TERN Plot Ontology.

The database only includes the values 999 and null.

ADDITIONAL

 

Not captured by TERN Plot Ontology.

NOTES

rdfs:comment

Domain: ssn-ext:ObservationCollection

Range: String literal

UPDATE_USER

 

Not captured by TERN Plot Ontology.

LAST_UPDATE`

dct:modified

Database entry or last modified time. Encoded with literal as type xsd:dateTime.

Action Items