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/5775903a-6660-4061-9f97-96c14953f47e> ;
    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:hasResult <http://linked.data.gov.au/def/corveg-cv/208b787a-0beb-4a60-84cb-c5109634140f> ;
    sosa:observedProperty corveg-cv:fc91bf1b-d4c6-474d-a2e3-9fd246fb6187 ;
    sosa:phenomenonTime corveg-site:t1999-08-18-h0-m0-s0 ;
    sosa:usedProcedure corveg-cv:a7be444d-a3b0-443a-83da-b4d2f7fafd0a .

corveg-dist:d-11595-2 a sosa:Observation ;
    rdfs:label "Disturbance 11595 age observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-23362 ;
    sosa:hasResult <http://linked.data.gov.au/def/corveg-cv/5ec9e7e9-7f14-4529-824f-54e621b36f2e> ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/6d5026c8-2299-42e3-8676-c3c1e1fca237> ;
    sosa:phenomenonTime corveg-site:t1999-08-18-h0-m0-s0 ;
    sosa:usedProcedure corveg-cv:a7be444d-a3b0-443a-83da-b4d2f7fafd0a .

corveg-dist:d-11595-3 a sosa:Observation ;
    rdfs:label "Disturbance 11595 height observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-23362 ;
    sosa:hasResult <http://linked.data.gov.au/def/corveg-cv/3831486d-3406-4974-948f-44e9241d47b2> ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/190abe24-8b80-46da-a66d-389429c2f538> ;
    sosa:phenomenonTime corveg-site:t1999-08-18-h0-m0-s0 ;
    sosa:usedProcedure corveg-cv:a7be444d-a3b0-443a-83da-b4d2f7fafd0a .

corveg-dist:d-11595-4 a sosa:Observation ;
    rdfs:label "Disturbance 11595 grazing level observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-23362 ;
    sosa:hasResult corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/84335100-f7e6-436b-a629-55059253ef8d> ;
    sosa:phenomenonTime corveg-site:t1999-08-18-h0-m0-s0 ;
    sosa:usedProcedure corveg-cv:a7be444d-a3b0-443a-83da-b4d2f7fafd0a .

corveg-dist:d-11595-5 a sosa:Observation ;
    rdfs:label "Disturbance 11595 erosion observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-23362 ;
    sosa:hasResult corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/421a7d05-7b2e-4a92-bbd5-fa29da25842b> ;
    sosa:phenomenonTime corveg-site:t1999-08-18-h0-m0-s0 ;
    sosa:usedProcedure corveg-cv:a7be444d-a3b0-443a-83da-b4d2f7fafd0a .

corveg-dist:d-11595-6 a sosa:Observation ;
    rdfs:label "Disturbance 11595 erosion severity observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-23362 ;
    sosa:hasResult corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/366de8d3-1888-4d60-b29f-ebf5d39e43b3> ;
    sosa:phenomenonTime corveg-site:t1999-08-18-h0-m0-s0 ;
    sosa:usedProcedure corveg-cv:a7be444d-a3b0-443a-83da-b4d2f7fafd0a .

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`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Disturbance `sosa:observedProperty`: Disturbance - Proportion `sosa:usedProcedure`: Based on the value of `TYPE_ID` (Disturbance Type), use a narrower value of Disturbance Assessment Methods. `sosa:hasResult`: narrower value of Disturbance Proportion Values matched on `skos:hiddenLabel`.
`AGE_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Disturbance `sosa:observedProperty`: Disturbance Age `sosa:usedProcedure`: Based on the value of `TYPE_ID` (Disturbance Type), use a narrower value of Disturbance Assessment Methods. `sosa:hasResult`: narrower value of Disturbance Age Values matched on `skos:hiddenLabel`.
`HEIGHT_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Disturbance `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. `sosa:hasResult`: narrower value of Disturbance Height of Fire Impact Values matched on `skos:hiddenLabel`.
`GRAZINGLEVEL_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Disturbance `sosa:observedProperty`: Grazing Level `sosa:usedProcedure`: Based on the value of `TYPE_ID` (Disturbance Type), use a narrower value of Disturbance Assessment Methods. `sosa:hasResult`: narrower value of Grazing Severity Values matched on `skos:hiddenLabel`.
`EROSION_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Disturbance `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`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Disturbance `sosa:observedProperty`: Erosion Severity `sosa:usedProcedure`: Based on the value of `TYPE_ID` (Disturbance Type), use a narrower value of Disturbance Assessment Methods. `sosa:hasResult`: narrower value of Erosion Severity Values matched on `skos:hiddenLabel`.
`COUNT`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Disturbance `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 `sosa:hasResult`: Class type: `data:Count`
`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`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Disturbance `sosa:observedProperty`: Ground Cover - Weed `sosa:usedProcedure`: Weed Disturbance Method `sosa:hasResult`: Class type: `data:Percent`

Action Items

Edmond Chuc (Unlicensed) Update new vocabulary URIs in ETL.
Edmond Chuc (Unlicensed) Update RDF example with new vocabulary URIs.
TERN Data Edmond Chuc (Unlicensed) Determine if observations with the value 999 should still create a sosa:Observation or treat the value as null and not create it. See the Example RDF above for the Erosion Observation with a sosa:hasResult value of Unrecorded.