Geology Table

Source: CORVEG.GEOLOGY

Example row:

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 biod: <http://linked.data.gov.au/def/biodiversity/> .
@prefix bioreg: <http://linked.data.gov.au/def/bioregion/> .
@prefix corveg: <http://linked.data.gov.au/dataset/corveg/> .
@prefix corveg-cv: <http://linked.data.gov.au/def/corveg-cv/> .
@prefix corveg-def: <http://linked.data.gov.au/def/corveg/> .
@prefix corveg-dist: <http://linked.data.gov.au/dataset/corveg/disturbance/> .
@prefix corveg-geol: <http://linked.data.gov.au/dataset/corveg/geology/> .
@prefix corveg-location: <http://linked.data.gov.au/dataset/corveg/location/> .
@prefix corveg-rfstruct: <http://linked.data.gov.au/dataset/corveg/rf-structure/> .
@prefix corveg-site: <http://linked.data.gov.au/dataset/corveg/site/> .
@prefix corveg-site-strata: <http://linked.data.gov.au/dataset/corveg/site-strata/> .
@prefix corveg-site-tax-strata: <http://linked.data.gov.au/dataset/corveg/site-tax-strata/> .
@prefix corveg-situation: <http://linked.data.gov.au/dataset/corveg/situation/> .
@prefix corveg-soil: <http://linked.data.gov.au/dataset/corveg/soil/> .
@prefix corveg-soil-text: <http://registry.it.csiro.au/sandbox/soil-data-ie/def/voc/texture/> .
@prefix corveg-struct: <http://linked.data.gov.au/dataset/corveg/structure/> .
@prefix corveg-taxa: <http://linked.data.gov.au/dataset/corveg/taxa/> .
@prefix corveg-v-comm: <http://linked.data.gov.au/dataset/corveg/vege-community/> .
@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 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 sdo: <http://schema.org/> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .
@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 unit: <http://qudt.org/vocab/unit/> .
@prefix xml: <http://www.w3.org/XML/1998/namespace> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .

corveg-geol:g-1904 a ssn-ext:ObservationCollection ;
    rdfs:label "Site 1904 geology observation collection" ;
    plot:hasResultQuality <http://linked.data.gov.au/def/corveg-cv/700d5fd1-bd27-4c3e-ba47-89b874a5933e> ;
    dct:modified "2014-05-30T13:23:12"^^xsd:dateTime ;
    dct:type <http://linked.data.gov.au/def/corveg-cv/039e3010-c8d2-4f09-a584-ed15a1fd7f8a> ;
    rdfs:comment "Quaternary Pleistocene deposits of clay, silt, sand and gravel, floodplain deposits on higher terraces." ;
    sosa:hasFeatureOfInterest corveg-site:site-1904 ;
    ssn-ext:hasMember corveg-geol:g-1904-1,
        corveg-geol:g-1904-2 .

corveg-geol:g-1904-1 a sosa:Observation ;
    rdfs:label "Site 1904 geology lithology observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-1904 ;
    sosa:hasResult <http://linked.data.gov.au/def/corveg-cv/08925fe3-9996-45dd-ac2d-fb1159be033e> ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/03ab0a02-acbe-4634-8b40-c3c4522fd2da> ;
    sosa:phenomenonTime corveg-site:t1998-03-26-h0-m0-s0 ;
    sosa:usedProcedure <http://linked.data.gov.au/def/corveg-cv/74b96f02-14cd-4fef-a573-ba3dc79e8aaa> .

corveg-geol:g-1904-2 a sosa:Observation ;
    rdfs:label "Site 1904 geology stratigraphic unit observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-1904 ;
    sosa:hasResult [ a data:Text ;
            data:value "Qpa" ] ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/35dbec2d-d2a9-401d-9376-a83c204ed97e> ;
    sosa:phenomenonTime corveg-site:t1998-03-26-h0-m0-s0 ;
    sosa:usedProcedure <http://linked.data.gov.au/def/corveg-cv/74b96f02-14cd-4fef-a573-ba3dc79e8aaa> .

corveg-site:t1998-03-26-h0-m0-s0 a time:Instant ;
    time:inXSDDateTime "1998-03-26T00:00:00"^^xsd:dateTime .

Mapping Table

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`	`sosa:hasResult`: narrower value of Geology Type Values matched on `skos:hiddenLabel`. `sosa:observedProperty`: Geology - Lithology `sosa:usedProcedure`: `sosa:Procedure` value of `SOURCE_ID`
`UNIT`	`ssn-ext:hasMember`, `sosa:hasResult`	`sosa:hasResult`: Class type: `data:Text` `sosa:observedProperty`: Geology Stratigraphic Map Unit `sosa:usedProcedure`: `sosa:Procedure` value of `SOURCE_ID` 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.

Geology Table

Interpretation in TERN Plot Ontology

RDF Example

Mapping Table

Action Items