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

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 corveg-cv: <http://linked.data.gov.au/def/corveg-cv/> .
@prefix corveg-dist: <http://linked.data.gov.au/dataset/corveg/disturbance/> .
@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-dist:d-42500 a ssn-ext:ObservationCollection ;
    rdfs:label "Site 13864 disturbance 42500 observation collection" ;
    plot:wasSubActivityOf corveg-site:sitev-13864 ;
    dct:type corveg-cv:2fdf7bc1-c16b-4fa9-8089-613a019df089,
        corveg-cv:5775903a-6660-4061-9f97-96c14953f47e ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    ssn-ext:hasMember corveg-dist:d-42500-1,
        corveg-dist:d-42500-2,
        corveg-dist:d-42500-3,
        corveg-dist:d-42500-4,
        corveg-dist:d-42500-5,
        corveg-dist:d-42500-6 .

corveg-dist:d-42501 a ssn-ext:ObservationCollection ;
    rdfs:label "Site 13864 disturbance 42501 observation collection" ;
    plot:wasSubActivityOf corveg-site:sitev-13864 ;
    dct:type corveg-cv:5775903a-6660-4061-9f97-96c14953f47e,
        corveg-cv:a5716c16-e982-47c6-911b-82e8f9ec655e ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    ssn-ext:hasMember corveg-dist:d-42501-1,
        corveg-dist:d-42501-2,
        corveg-dist:d-42501-3,
        corveg-dist:d-42501-4,
        corveg-dist:d-42501-5,
        corveg-dist:d-42501-6,
        corveg-dist:d-42501-7 .

corveg-dist:d-42502 a ssn-ext:ObservationCollection ;
    rdfs:label "Site 13864 disturbance 42502 observation collection" ;
    plot:wasSubActivityOf corveg-site:sitev-13864 ;
    dct:type corveg-cv:54e32ec7-a845-4c00-a65c-630600cc7cbf,
        corveg-cv:5775903a-6660-4061-9f97-96c14953f47e ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    ssn-ext:hasMember corveg-dist:d-42502-1,
        corveg-dist:d-42502-2,
        corveg-dist:d-42502-3,
        corveg-dist:d-42502-4,
        corveg-dist:d-42502-5,
        corveg-dist:d-42502-6 .

corveg-dist:d-42500-1 a sosa:Observation ;
    rdfs:label "Disturbance 42500 proportion observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:208b787a-0beb-4a60-84cb-c5109634140f ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:fc91bf1b-d4c6-474d-a2e3-9fd246fb6187 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:a7be444d-a3b0-443a-83da-b4d2f7fafd0a ] .

corveg-dist:d-42500-2 a sosa:Observation ;
    rdfs:label "Disturbance 42500 age observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:5ec9e7e9-7f14-4529-824f-54e621b36f2e ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:6d5026c8-2299-42e3-8676-c3c1e1fca237 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:a7be444d-a3b0-443a-83da-b4d2f7fafd0a ] .

corveg-dist:d-42500-3 a sosa:Observation ;
    rdfs:label "Disturbance 42500 height observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:4b01bcd3-c1ce-442f-8730-4356574272fb ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:190abe24-8b80-46da-a66d-389429c2f538 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:a7be444d-a3b0-443a-83da-b4d2f7fafd0a ] .

corveg-dist:d-42500-4 a sosa:Observation ;
    rdfs:label "Disturbance 42500 grazing level observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:84335100-f7e6-436b-a629-55059253ef8d ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:a7be444d-a3b0-443a-83da-b4d2f7fafd0a ] .

corveg-dist:d-42500-5 a sosa:Observation ;
    rdfs:label "Disturbance 42500 erosion observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:421a7d05-7b2e-4a92-bbd5-fa29da25842b ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:a7be444d-a3b0-443a-83da-b4d2f7fafd0a ] .

corveg-dist:d-42500-6 a sosa:Observation ;
    rdfs:label "Disturbance 42500 erosion severity observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:366de8d3-1888-4d60-b29f-ebf5d39e43b3 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:a7be444d-a3b0-443a-83da-b4d2f7fafd0a ] .

corveg-dist:d-42501-1 a sosa:Observation ;
    rdfs:label "Disturbance 42501 proportion observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:fc91bf1b-d4c6-474d-a2e3-9fd246fb6187 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:7c524b2d-76e3-4d48-ba09-72849e53bbf2 ] .

corveg-dist:d-42501-2 a sosa:Observation ;
    rdfs:label "Disturbance 42501 age observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:6d5026c8-2299-42e3-8676-c3c1e1fca237 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:7c524b2d-76e3-4d48-ba09-72849e53bbf2 ] .

corveg-dist:d-42501-3 a sosa:Observation ;
    rdfs:label "Disturbance 42501 height observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:190abe24-8b80-46da-a66d-389429c2f538 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:7c524b2d-76e3-4d48-ba09-72849e53bbf2 ] .

corveg-dist:d-42501-4 a sosa:Observation ;
    rdfs:label "Disturbance 42501 grazing level observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:84335100-f7e6-436b-a629-55059253ef8d ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:7c524b2d-76e3-4d48-ba09-72849e53bbf2 ] .

corveg-dist:d-42501-5 a sosa:Observation ;
    rdfs:label "Disturbance 42501 erosion observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:421a7d05-7b2e-4a92-bbd5-fa29da25842b ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:7c524b2d-76e3-4d48-ba09-72849e53bbf2 ] .

corveg-dist:d-42501-6 a sosa:Observation ;
    rdfs:label "Disturbance 42501 erosion severity observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:366de8d3-1888-4d60-b29f-ebf5d39e43b3 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:7c524b2d-76e3-4d48-ba09-72849e53bbf2 ] .

corveg-dist:d-42501-7 a sosa:Observation ;
    rdfs:label "Disturbance 42501 weed cover observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Percent ;
            data:value 1.00 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:37940a95-6ddc-440f-923e-5056f3e2bf8f ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:7c524b2d-76e3-4d48-ba09-72849e53bbf2 ] .

corveg-dist:d-42502-1 a sosa:Observation ;
    rdfs:label "Disturbance 42502 proportion observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:fc91bf1b-d4c6-474d-a2e3-9fd246fb6187 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:1cbfbb5f-226c-4dcf-9ed1-d135569e1084 ] .

corveg-dist:d-42502-2 a sosa:Observation ;
    rdfs:label "Disturbance 42502 age observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:6d5026c8-2299-42e3-8676-c3c1e1fca237 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:1cbfbb5f-226c-4dcf-9ed1-d135569e1084 ] .

corveg-dist:d-42502-3 a sosa:Observation ;
    rdfs:label "Disturbance 42502 height observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:190abe24-8b80-46da-a66d-389429c2f538 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:1cbfbb5f-226c-4dcf-9ed1-d135569e1084 ] .

corveg-dist:d-42502-4 a sosa:Observation ;
    rdfs:label "Disturbance 42502 grazing level observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:4750ac55-f12c-4298-9011-2d1c42216c4f ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:84335100-f7e6-436b-a629-55059253ef8d ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:1cbfbb5f-226c-4dcf-9ed1-d135569e1084 ] .

corveg-dist:d-42502-5 a sosa:Observation ;
    rdfs:label "Disturbance 42502 erosion observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:421a7d05-7b2e-4a92-bbd5-fa29da25842b ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:1cbfbb5f-226c-4dcf-9ed1-d135569e1084 ] .

corveg-dist:d-42502-6 a sosa:Observation ;
    rdfs:label "Disturbance 42502 erosion severity observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:366de8d3-1888-4d60-b29f-ebf5d39e43b3 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:1cbfbb5f-226c-4dcf-9ed1-d135569e1084 ] .

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
`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.