Geology Table

Source: CORVEG.GEOLOGY

Example row:

SITE_ID	SOURCE_ID	RELIABILITY_ID	TYPECODE_ID	UNIT	ADDITIONAL	NOTES	UPDATE_USER	LAST_UPDATE

SITE_ID	SOURCE_ID	RELIABILITY_ID	TYPECODE_ID	UNIT	ADDITIONAL	NOTES	UPDATE_USER	LAST_UPDATE
1904	1	1	2	Qpa	0	Quaternary Pleistocene deposits of clay, silt, sand and gravel, floodplain deposits on higher terraces.	2289	2014-05-30 13:23:12

Interpretation in TERN Plot Ontology

Encoding each row in RDF requires:

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

RDF Example

@prefix corveg-cv: <http://linked.data.gov.au/def/corveg-cv/> .
@prefix corveg-geol: <http://linked.data.gov.au/dataset/corveg/geology/> .
@prefix corveg-site: <http://linked.data.gov.au/dataset/corveg/site/> .
@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-geol:g-13864 a ssn-ext:ObservationCollection ;
    rdfs:label "Site 13864 geology observation collection" ;
    plot:hasResultQuality corveg-cv:87a53dd4-2ba8-47cc-b00c-a189eeb0c0c6 ;
    plot:wasSubActivityOf corveg-site:sitev-13864 ;
    dct:type corveg-cv:039e3010-c8d2-4f09-a584-ed15a1fd7f8a ;
    rdfs:comment "Soils derived from white to brown, poorly sorted, thick-bedded, fine to coarse-grained pebbly quartzose sandstone of the Early Jurassic Precipice Sandstones." ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    ssn-ext:hasMember corveg-geol:g-13864-1,
        corveg-geol:g-13864-2 .

corveg-geol:g-13864-1 a sosa:Observation ;
    rdfs:label "Site 13864 geology lithology observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:e0a2a0ac-e8f1-4192-a500-7fd3d41736f2 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:03ab0a02-acbe-4634-8b40-c3c4522fd2da ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:74b96f02-14cd-4fef-a573-ba3dc79e8aaa ] .

corveg-geol:g-13864-2 a sosa:Observation ;
    rdfs:label "Site 13864 geology stratigraphic unit observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Text ;
            data:value "Jp" ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:35dbec2d-d2a9-401d-9376-a83c204ed97e ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:74b96f02-14cd-4fef-a573-ba3dc79e8aaa ] .

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`	Domain: `sosa:Observation` Range: A narrower concept in the concept scheme Geology Assessment Methods, matching on the `skos:hiddenLabel` value.
`RELIABILITY_ID`	`plot:hasResultQuality`	Domain: `ssn-ext:ObservationCollection` Range: A narrower concept in the concept scheme Geology Reliability Values, matching on the `skos:hiddenLabel` value.
`TYPECODE_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Substrate/Geology CORVEG: Geology `sosa:observedProperty`: Geology - Lithology `sosa:usedProcedure`: `sosa:Procedure` value of `SOURCE_ID` `sosa:hasResult`: narrower value of Geology Type Values matched on `skos:hiddenLabel`.
`UNIT`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Substrate/Geology CORVEG: Geology `sosa:observedProperty`: Geology Stratigraphic Map Unit `sosa:usedProcedure`: `sosa:Procedure` value of `SOURCE_ID` `sosa:hasResult`: Class type: `data:Text` This is the geology map unit from the ‘Detailed surface geology Queensland’ from the Department of Natural Resources, Mines and Energy
`ADDITIONAL`		Not captured by TERN Plot Ontology. Custodian comment: This is to indicate that there is additional geology information. This is of limited use and value as it is not linked to anything. No use to users.
`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

@Edmond Chuc (Unlicensed) If required, look into creating the values of UNIT into a controlled vocabulary.