You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 3
Next »
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 |
|---|
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:
An ssn-ext:ObservationCollection with the observation group encoded with dct:type as Soil.
RDF Example
Mapping Table
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
| 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
| 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
| 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
| |
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
Add Comment