Disturbance Table

Input

Source: CORVEG.DISTURBANCE

Example row:

DISTURBANCE_ID	SITE_ID	TYPE_ID	PROPORTION_ID	AGE_ID	HEIGHT_ID	GRAZINGLEVEL_ID	EROSION_ID	EROSIONSEVERITY_ID	COUNT	UPDATE_USER	LAST_UPDATE	WEED_COVER
11595	23362	3	4	2	2	999	999	999	null	118	2010-07-22 11:30:59	null

Interpretation in TERN Plot Ontology

Encoding each row in RDF requires:

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

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-dist:d-11595 a ssn-ext:ObservationCollection ;
    rdfs:label "Site 23362 disturbance 11595 observation collection" ;
    dct:modified "2010-07-22T11:30:59"^^xsd:dateTime ;
    dct:type <http://linked.data.gov.au/def/corveg-cv/ogroup/1> ;
    sosa:hasFeatureOfInterest corveg-site:site-23362 ;
    sosa:phenomenonTime corveg-site:t1999-08-18-h0-m0-s0 ;
    ssn-ext:hasMember corveg-dist:d-11595-1,
        corveg-dist:d-11595-2,
        corveg-dist:d-11595-3,
        corveg-dist:d-11595-4,
        corveg-dist:d-11595-5,
        corveg-dist:d-11595-6 .

corveg-dist:d-11595-1 a sosa:Observation ;
    rdfs:label "Disturbance 11595 proportion observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-23362 ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/op/26> ;
    sosa:phenomenonTime corveg-site:t1999-08-18-h0-m0-s0 ;
    sosa:usedProcedure <http://linked.data.gov.au/def/corveg-cv/disturbance-assessment/1> .

corveg-dist:d-11595-2 a sosa:Observation ;
    rdfs:label "Disturbance 11595 age observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-23362 ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/op/24> ;
    sosa:phenomenonTime corveg-site:t1999-08-18-h0-m0-s0 ;
    sosa:usedProcedure <http://linked.data.gov.au/def/corveg-cv/disturbance-assessment/1> .

corveg-dist:d-11595-3 a sosa:Observation ;
    rdfs:label "Disturbance 11595 height observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-23362 ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/op/25> ;
    sosa:phenomenonTime corveg-site:t1999-08-18-h0-m0-s0 ;
    sosa:usedProcedure <http://linked.data.gov.au/def/corveg-cv/disturbance-assessment/1> .

corveg-dist:d-11595-4 a sosa:Observation ;
    rdfs:label "Disturbance 11595 grazing level observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-23362 ;
    sosa:hasResult <http://linked.data.gov.au/def/corveg-cv/miscellaneous/87> ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/op/33> ;
    sosa:phenomenonTime corveg-site:t1999-08-18-h0-m0-s0 ;
    sosa:usedProcedure <http://linked.data.gov.au/def/corveg-cv/disturbance-assessment/1> .

corveg-dist:d-11595-5 a sosa:Observation ;
    rdfs:label "Disturbance 11595 erosion observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-23362 ;
    sosa:hasResult <http://linked.data.gov.au/def/corveg-cv/miscellaneous/87> ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/op/30> ;
    sosa:phenomenonTime corveg-site:t1999-08-18-h0-m0-s0 ;
    sosa:usedProcedure <http://linked.data.gov.au/def/corveg-cv/disturbance-assessment/1> .

corveg-dist:d-11595-6 a sosa:Observation ;
    rdfs:label "Disturbance 11595 erosion severity observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-23362 ;
    sosa:hasResult <http://linked.data.gov.au/def/corveg-cv/miscellaneous/87> ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/op/29> ;
    sosa:phenomenonTime corveg-site:t1999-08-18-h0-m0-s0 ;
    sosa:usedProcedure <http://linked.data.gov.au/def/corveg-cv/disturbance-assessment/1> .

corveg-site:t1999-08-18-h0-m0-s0 a time:Instant ;
    time:inXSDDateTime "1999-08-18T00:00:00"^^xsd:dateTime .

Mapping Table

Source Column	Destination RDF Predicate	Comments
`DISTURBANCE_ID`	`rdfs:label`	Encoded in the URIs of the `sosa:Observation` and `ssn-ext:ObservationCollection`. Also used in `rdfs:label` for human readability.
`SITE_ID`	`sosa:hasFeatureOfInterest`	Domain: `ssn-ext:ObservationCollection` Range: `plot:Site`
`TYPE_ID`	`dct:type`	Domain: `ssn-ext:ObservationCollection` Range: a concept in the concept scheme Disturbance Type, matching on the `skos:hiddenLabel` value.
`PROPORTION_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	`sosa:hasResult`: narrower value of Disturbance Proportion Values matched on `skos:hiddenLabel`. `sosa:observedProperty`: Disturbance - Proportion `sosa:usedProcedure`: Based on the value of `TYPE_ID` (Disturbance Type), use a narrower value of Disturbance Assessment Methods.
`AGE_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	`sosa:hasResult`: narrower value of Disturbance Age Values matched on `skos:hiddenLabel`. `sosa:observedProperty`: Disturbance Age `sosa:usedProcedure`: Based on the value of `TYPE_ID` (Disturbance Type), use a narrower value of Disturbance Assessment Methods.
`HEIGHT_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	`sosa:hasResult`: narrower value of Disturbance Height of Fire Impact Values matched on `skos:hiddenLabel`. `sosa:observedProperty`: Height of Fire Impact `sosa:usedProcedure`: Based on the value of `TYPE_ID` (Disturbance Type), use a narrower value of Disturbance Assessment Methods.
`GRAZINGLEVEL_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	`sosa:hasResult`: narrower value of Grazing Severity Values matched on `skos:hiddenLabel`. `sosa:observedProperty`: Grazing Level `sosa:usedProcedure`: Based on the value of `TYPE_ID` (Disturbance Type), use a narrower value of Disturbance Assessment Methods.
`EROSION_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	`sosa:hasResult`: narrower value of Erosion Type Values matched on `skos:hiddenLabel`. `sosa:observedProperty`: Erosion Type `sosa:usedProcedure`: Based on the value of `TYPE_ID` (Disturbance Type), use a narrower value of Disturbance Assessment Methods.
`EROSIONSEVERITY_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	`sosa:hasResult`: narrower value of Erosion Severity Values matched on `skos:hiddenLabel`. `sosa:observedProperty`: Erosion Severity `sosa:usedProcedure`: Based on the value of `TYPE_ID` (Disturbance Type), use a narrower value of Disturbance Assessment Methods.
`COUNT`	`ssn-ext:hasMember`, `sosa:hasResult`	`sosa:hasResult`: Class type: `data:Count` `sosa:observedProperty`: if `TYPE_ID` is 5: then, Stumps Count else if `TYPE_ID` is 6: then, Ringbarked Stem Count `sosa:usedProcedure`: if Stumps Count, then Logging Disturbance Method else if Ringbarked Stem Count, then Ringbarking Disturbance Method
`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`.
`WEED_COVER`	`ssn-ext:hasMember`, `sosa:hasResult`	`sosa:hasResult`: Class type: `data:Percent` `sosa:observedProperty`: Ground Cover - Weed `sosa:usedProcedure`: Weed Disturbance Method

Action Items

Edmond Chuc (Unlicensed) Update new vocabulary URIs in ETL.
Edmond Chuc (Unlicensed) Update RDF example with new vocabulary URIs.