Site Strata Table (Vegetation per Stratum)

Input

Source: CORVEG.SITE_STRATA

Example row:

STRATA_ID

SITE_ID

DESCRIPTION

CROWNCLASS_ID

CROWNDENSITY

SPS

HTAVG

HTMIN

HTMAX

COAVG

COMIN

COMAX

RECORDED

PRESENT

UPDATE_USER

LAST_UPDATE

COVERMETHOD_ID

COVERMEASURE_ID

STRATA_ID

SITE_ID

DESCRIPTION

CROWNCLASS_ID

CROWNDENSITY

SPS

HTAVG

HTMIN

HTMAX

COAVG

COMIN

COMAX

RECORDED

PRESENT

UPDATE_USER

LAST_UPDATE

COVERMETHOD_ID

COVERMEASURE_ID

7

54302

Green panic patch (monoculture) from northern end of plot through to Argusia clump - no green panic in plot

6

null

500

0.75

0.1

0.8

96.4

65

98

0

1

3929

2018-07-23 12:33:42

2

2

Interpretation in TERN Plot Ontology

Encoding each row in RDF requires:

  1. an individual plot:SiteStratum representing the sample of the site composed of a single identified stratum.

  2. an individual ssn-ext:ObservationCollection with dct:type range value to an observation group representing the set of observations of the properties of the FeatureOfInterest.

  3. an individual sosa:Observation for each column containing an observed value.

  4. (optionally) a collection of collections for the strata at the site.

The proximate feature of interest is a single stratum, which is distinct from the site-as-a-whole. Hence, the feature of interest of each row is a plot:SiteStratum which is tagged according to its level using plot:stratum, and is linked to whole actual site using sosa:isSampleOf.

RDF Example

@prefix corveg-cv: <http://linked.data.gov.au/def/corveg-cv/> . @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 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 plot-x: <http://linked.data.gov.au/def/plot/x/> . @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 unit: <http://qudt.org/vocab/unit/> . @prefix xsd: <http://www.w3.org/2001/XMLSchema#> . corveg-site-strata:st1-13864 a ssn-ext:ObservationCollection ; rdfs:label "CORVEG Site 13864, stratum Emergent Layer, observation collection" ; plot:wasSubActivityOf corveg-site:sitev-13864 ; dct:type corveg-cv:945f955b-f70d-4192-9810-c3685111840e ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:24ed3f10-a0fb-49b8-bc6d-86dcc5251284 ; sosa:isSampleOf corveg-site:site-13864 ] ; ssn-ext:hasMember corveg-site-strata:st1-13864-1, corveg-site-strata:st1-13864-2 . corveg-site-strata:st2-13864 a ssn-ext:ObservationCollection ; rdfs:label "CORVEG Site 13864, stratum Upper Tree Layer, observation collection" ; plot:wasSubActivityOf corveg-site:sitev-13864 ; plot-x:stemDensityArea 500 ; dct:type corveg-cv:945f955b-f70d-4192-9810-c3685111840e ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:d62abac0-a38a-44c6-a8fc-299ed68fbb77 ; sosa:isSampleOf corveg-site:site-13864 ] ; ssn-ext:hasMember corveg-site-strata:st2-13864-1, corveg-site-strata:st2-13864-2, corveg-site-strata:st2-13864-3, corveg-site-strata:st2-13864-4 . corveg-site-strata:st3-13864 a ssn-ext:ObservationCollection ; rdfs:label "CORVEG Site 13864, stratum Secondry Tree Layer, observation collection" ; plot:wasSubActivityOf corveg-site:sitev-13864 ; dct:type corveg-cv:945f955b-f70d-4192-9810-c3685111840e ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:0f9bb4c4-f541-420c-b8f8-9ae2f91c81cb ; sosa:isSampleOf corveg-site:site-13864 ] ; ssn-ext:hasMember corveg-site-strata:st3-13864-1, corveg-site-strata:st3-13864-2 . corveg-site-strata:st4-13864 a ssn-ext:ObservationCollection ; rdfs:label "CORVEG Site 13864, stratum Tertiary Tree Layer, observation collection" ; plot:wasSubActivityOf corveg-site:sitev-13864 ; dct:type corveg-cv:945f955b-f70d-4192-9810-c3685111840e ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:2a773e06-6373-438c-b526-714983dde18f ; sosa:isSampleOf corveg-site:site-13864 ] ; ssn-ext:hasMember corveg-site-strata:st4-13864-1, corveg-site-strata:st4-13864-2 . corveg-site-strata:st5-13864 a ssn-ext:ObservationCollection ; rdfs:label "CORVEG Site 13864, stratum Upper Shrub Layer, observation collection" ; plot:wasSubActivityOf corveg-site:sitev-13864 ; plot-x:stemDensityArea 500 ; dct:type corveg-cv:945f955b-f70d-4192-9810-c3685111840e ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:3d5e4ab8-4cfc-48e1-80d5-18669faba221 ; sosa:isSampleOf corveg-site:site-13864 ] ; ssn-ext:hasMember corveg-site-strata:st5-13864-1, corveg-site-strata:st5-13864-2, corveg-site-strata:st5-13864-3, corveg-site-strata:st5-13864-4, corveg-site-strata:st5-13864-5 . corveg-site-strata:st6-13864 a ssn-ext:ObservationCollection ; rdfs:label "CORVEG Site 13864, stratum Secondary Shrub Layer, observation collection" ; plot:wasSubActivityOf corveg-site:sitev-13864 ; dct:type corveg-cv:945f955b-f70d-4192-9810-c3685111840e ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:2fa44f17-8efb-4e38-a471-9781f20f7f6f ; sosa:isSampleOf corveg-site:site-13864 ] ; ssn-ext:hasMember corveg-site-strata:st6-13864-1, corveg-site-strata:st6-13864-2 . corveg-site-strata:st7-13864 a ssn-ext:ObservationCollection ; rdfs:label "CORVEG Site 13864, stratum Ground Layer, observation collection" ; plot:wasSubActivityOf corveg-site:sitev-13864 ; dct:type corveg-cv:945f955b-f70d-4192-9810-c3685111840e ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:219ba087-4a2d-43d3-a535-f8f45c364a21 ; sosa:isSampleOf corveg-site:site-13864 ] ; ssn-ext:hasMember corveg-site-strata:st7-13864-1, corveg-site-strata:st7-13864-2, corveg-site-strata:st7-13864-3, corveg-site-strata:st7-13864-4 . corveg-site-strata:st1-13864-1 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Emergent Layer, crown cover class observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:24ed3f10-a0fb-49b8-bc6d-86dcc5251284 ; 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:07be3410-7e14-4a06-a44e-23b43d59f379 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:8b826be4-33f5-4453-9e46-d8c463b43f40 ] . corveg-site-strata:st1-13864-2 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Emergent Layer, vegetation stratum observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:24ed3f10-a0fb-49b8-bc6d-86dcc5251284 ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Boolean ; data:value false ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:value corveg-cv:8e1b8694-7bc4-4ce7-90c1-69d68e07a3aa ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:676f9dcd-fdd7-4e5a-948e-40ed5421c572 ] . corveg-site-strata:st2-13864-1 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Upper Tree Layer, crown cover class observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:d62abac0-a38a-44c6-a8fc-299ed68fbb77 ; 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:07be3410-7e14-4a06-a44e-23b43d59f379 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:8b826be4-33f5-4453-9e46-d8c463b43f40 ] . corveg-site-strata:st2-13864-2 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Upper Tree Layer, median vegetation height observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:d62abac0-a38a-44c6-a8fc-299ed68fbb77 ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:QuantitativeMeasure ; data:standard unit:M ; data:value 24.00 ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:qualifier <http://linkeddata.tern.org.au/def/stat/median> ; data:value corveg-cv:7877b58f-efa1-4027-a5d7-e1b019c69634 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:14f5669e-33bd-485f-a71a-cf2b704d6d76 ] . corveg-site-strata:st2-13864-3 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Upper Tree Layer, average crown cover observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:d62abac0-a38a-44c6-a8fc-299ed68fbb77 ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Percent ; data:value 60.00 ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:qualifier <http://linkeddata.tern.org.au/def/stat/average> ; data:value corveg-cv:0f64d34d-6450-4531-b49a-773d437acbc0 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:8b826be4-33f5-4453-9e46-d8c463b43f40 ], [ a sosa:Procedure ; data:value corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232, corveg-cv:f4a4206c-2f16-4ff6-9564-705a051b7146 ] . corveg-site-strata:st2-13864-4 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Upper Tree Layer, vegetation stratum observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:d62abac0-a38a-44c6-a8fc-299ed68fbb77 ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Boolean ; data:value true ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:value corveg-cv:8e1b8694-7bc4-4ce7-90c1-69d68e07a3aa ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:676f9dcd-fdd7-4e5a-948e-40ed5421c572 ] . corveg-site-strata:st3-13864-1 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Secondry Tree Layer, crown cover class observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:0f9bb4c4-f541-420c-b8f8-9ae2f91c81cb ; 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:07be3410-7e14-4a06-a44e-23b43d59f379 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:8b826be4-33f5-4453-9e46-d8c463b43f40 ] . corveg-site-strata:st3-13864-2 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Secondry Tree Layer, vegetation stratum observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:0f9bb4c4-f541-420c-b8f8-9ae2f91c81cb ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Boolean ; data:value false ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:value corveg-cv:8e1b8694-7bc4-4ce7-90c1-69d68e07a3aa ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:676f9dcd-fdd7-4e5a-948e-40ed5421c572 ] . corveg-site-strata:st4-13864-1 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Tertiary Tree Layer, crown cover class observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:2a773e06-6373-438c-b526-714983dde18f ; 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:07be3410-7e14-4a06-a44e-23b43d59f379 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:8b826be4-33f5-4453-9e46-d8c463b43f40 ] . corveg-site-strata:st4-13864-2 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Tertiary Tree Layer, vegetation stratum observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:2a773e06-6373-438c-b526-714983dde18f ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Boolean ; data:value false ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:value corveg-cv:8e1b8694-7bc4-4ce7-90c1-69d68e07a3aa ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:676f9dcd-fdd7-4e5a-948e-40ed5421c572 ] . corveg-site-strata:st5-13864-1 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Upper Shrub Layer, crown cover class observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:3d5e4ab8-4cfc-48e1-80d5-18669faba221 ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Concept ; data:value corveg-cv:4b22f077-4d2e-4c61-ad57-7125aeb14f92 ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:value corveg-cv:07be3410-7e14-4a06-a44e-23b43d59f379 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:8b826be4-33f5-4453-9e46-d8c463b43f40 ] . corveg-site-strata:st5-13864-2 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Upper Shrub Layer, maximum vegetation height observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:3d5e4ab8-4cfc-48e1-80d5-18669faba221 ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:QuantitativeMeasure ; data:standard unit:M ; data:value 5.00 ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:qualifier <http://linkeddata.tern.org.au/def/stat/maximum> ; data:value corveg-cv:7877b58f-efa1-4027-a5d7-e1b019c69634 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:833074a1-a849-482e-b9af-9e6ce3d38772 ] . corveg-site-strata:st5-13864-3 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Upper Shrub Layer, minimum vegetation height observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:3d5e4ab8-4cfc-48e1-80d5-18669faba221 ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:QuantitativeMeasure ; data:standard unit:M ; data:value 2.00 ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:qualifier <http://linkeddata.tern.org.au/def/stat/minimum> ; data:value corveg-cv:7877b58f-efa1-4027-a5d7-e1b019c69634 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:833074a1-a849-482e-b9af-9e6ce3d38772 ] . corveg-site-strata:st5-13864-4 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Upper Shrub Layer, average crown cover observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:3d5e4ab8-4cfc-48e1-80d5-18669faba221 ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Percent ; data:value 15.00 ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:qualifier <http://linkeddata.tern.org.au/def/stat/average> ; data:value corveg-cv:0f64d34d-6450-4531-b49a-773d437acbc0 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:8b826be4-33f5-4453-9e46-d8c463b43f40 ], [ a sosa:Procedure ; data:value corveg-cv:32a0576e-b23c-45e4-8552-cbc8ba094022, corveg-cv:acdd43b7-d277-4d22-8633-8999526c4232 ] . corveg-site-strata:st5-13864-5 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Upper Shrub Layer, vegetation stratum observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:3d5e4ab8-4cfc-48e1-80d5-18669faba221 ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Boolean ; data:value true ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:value corveg-cv:8e1b8694-7bc4-4ce7-90c1-69d68e07a3aa ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:676f9dcd-fdd7-4e5a-948e-40ed5421c572 ] . corveg-site-strata:st6-13864-1 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Secondary Shrub Layer, crown cover class observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:2fa44f17-8efb-4e38-a471-9781f20f7f6f ; 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:07be3410-7e14-4a06-a44e-23b43d59f379 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:8b826be4-33f5-4453-9e46-d8c463b43f40 ] . corveg-site-strata:st6-13864-2 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Secondary Shrub Layer, vegetation stratum observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:2fa44f17-8efb-4e38-a471-9781f20f7f6f ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Boolean ; data:value false ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:value corveg-cv:8e1b8694-7bc4-4ce7-90c1-69d68e07a3aa ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:676f9dcd-fdd7-4e5a-948e-40ed5421c572 ] . corveg-site-strata:st7-13864-1 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Ground Layer, crown cover class observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:219ba087-4a2d-43d3-a535-f8f45c364a21 ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Concept ; data:value corveg-cv:4b22f077-4d2e-4c61-ad57-7125aeb14f92 ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:value corveg-cv:07be3410-7e14-4a06-a44e-23b43d59f379 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:8b826be4-33f5-4453-9e46-d8c463b43f40 ] . corveg-site-strata:st7-13864-2 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Ground Layer, median vegetation height observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:219ba087-4a2d-43d3-a535-f8f45c364a21 ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:QuantitativeMeasure ; data:standard unit:M ; data:value 0.70 ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:qualifier <http://linkeddata.tern.org.au/def/stat/median> ; data:value corveg-cv:7877b58f-efa1-4027-a5d7-e1b019c69634 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:14f5669e-33bd-485f-a71a-cf2b704d6d76 ] . corveg-site-strata:st7-13864-3 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Ground Layer, average crown cover observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:219ba087-4a2d-43d3-a535-f8f45c364a21 ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Percent ; data:value 15.00 ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:qualifier <http://linkeddata.tern.org.au/def/stat/average> ; data:value corveg-cv:0f64d34d-6450-4531-b49a-773d437acbc0 ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:8b826be4-33f5-4453-9e46-d8c463b43f40 ], [ a sosa:Procedure ; data:value corveg-cv:32a0576e-b23c-45e4-8552-cbc8ba094022, corveg-cv:89b70fdd-a03c-43a6-99f3-dfd01b11704a ] . corveg-site-strata:st7-13864-4 a sosa:Observation ; rdfs:label "CORVEG Site 13864, stratum Ground Layer, vegetation stratum observation" ; sosa:hasFeatureOfInterest [ a plot:SiteStratum ; plot:stratum corveg-cv:219ba087-4a2d-43d3-a535-f8f45c364a21 ; sosa:isSampleOf corveg-site:site-13864 ] ; sosa:hasResult [ a data:Boolean ; data:value true ] ; sosa:observedProperty [ a sosa:ObservableProperty ; data:value corveg-cv:8e1b8694-7bc4-4ce7-90c1-69d68e07a3aa ] ; sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ; sosa:usedProcedure [ a sosa:Procedure ; data:value corveg-cv:676f9dcd-fdd7-4e5a-948e-40ed5421c572 ] . 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

STRATA_ID

sosa:hasFeatureOfInterest, 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, rdfs:label

Encoded in the URIs of the sosa:Observation and ssn-ext:ObservationCollection. Also used in rdfs:label for human readability.

DESCRIPTION

dct:description

 

CROWNCLASS_ID

ssn-ext:hasMember, sosa:hasResult

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Vegetation stratum

CORVEG: Vegetation per stratum

CROWNDENSITY

ssn-ext:hasMember, sosa:hasResult

Not implemented - all values are null.

Custodian comment: If all the values are null or 999 then this is not use or not implemented. No use to users.

SPS

plot-x:stemDensityArea

Domain: ssn-ext:ObservationCollection

Range: Number

HTAVG

ssn-ext:hasMember, sosa:hasResult

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Vegetation stratum

CORVEG: Vegetation per stratum

Despite the column name containing avg in its name, the height values are actually the result of the median.

HTMIN

ssn-ext:hasMember, sosa:hasResult

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Vegetation stratum

CORVEG: Vegetation per stratum

HTMAX

ssn-ext:hasMember, sosa:hasResult

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Vegetation stratum

CORVEG: Vegetation per stratum

COAVG

ssn-ext:hasMember, sosa:hasResult

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Vegetation stratum

CORVEG: Vegetation per stratum

COMIN

ssn-ext:hasMember, sosa:hasResult

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Vegetation stratum

CORVEG: Vegetation per stratum

COMAX

ssn-ext:hasMember, sosa:hasResult

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Vegetation stratum

CORVEG: Vegetation per stratum

RECORDED

 

Not captured by TERN Plot Ontology.

Custodian comment: This field indicates that that particular strata (e.g. T1) has been recorded at the site. Wouldn’t think this is of much use to users given that if there are measurements in that strata then it obviously exists. But could have some value for querying.

PRESENT

ssn-ext:hasMember, sosa:hasResult

Domain: ssn-ext:ObservationCollection with dct:type

TERN: Vegetation stratum

CORVEG: Vegetation per stratum

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.

COVERMETHOD_ID

sosa:usedProcedure

The cover method for COAVG, COMAX, and COMIN.

Use a narrower value from Vegetation Crown Cover Assessment Method match on skos:hiddenLabel.

COVERMEASURE_ID

sosa:usedProcedure

The cover measure procedure used for COAVG, COMAX, and COMIN. Don’t add to data if value of COVERMEASURE_ID is 999 (unrecorded).

Use a narrower value from Cover Measure Method.

Action Tasks

@Edmond Chuc (Unlicensed) Update the URIs to the new UUID ones.
@Edmond Chuc (Unlicensed) Implement the capture of the SPS column.
@Edmond Chuc (Unlicensed) Amend the missing methods - check if they still exist in PoolParty, if not, investigate what happened to them. For Visual Assessment - it has now been changed to Vegetation Layer Assessment Method.
@Edmond Chuc (Unlicensed) Look at modelling the SPS value at the plot:SiteStratum level.