Site Table

Input

Source: CORVEG.SITE

Example row:

SITE_ID	PROJECT_ID	LOCATION_ID	DESCRIPTION	SITE_NUMBER	SITE_DATE	ENTRY_DATE	LITTER_PERCENT	ROCK_PERCENT	BARE_PERCENT	CRYPTO_PERCENT	SAMPLELEVEL_ID	SAMPLETYPE_ID	SAMPLEFLORISTICS_ID	SAMPLE_AREA	HAS_PHOTO	HAS_BASAL_BYSTRATA	HAS_COVER_BYSTRATA	HAS_STEM_BYSTRATA	HAS_BASAL_BYTAXA	HAS_COVER_BYTAXA	HAS_STEM_BYTAXA	CHECKED	UPDATE_USER	LAST_UPDATE

SITE_ID	PROJECT_ID	LOCATION_ID	DESCRIPTION	SITE_NUMBER	SITE_DATE	ENTRY_DATE	LITTER_PERCENT	ROCK_PERCENT	BARE_PERCENT	CRYPTO_PERCENT	SAMPLELEVEL_ID	SAMPLETYPE_ID	SAMPLEFLORISTICS_ID	SAMPLE_AREA	HAS_PHOTO	HAS_BASAL_BYSTRATA	HAS_COVER_BYSTRATA	HAS_STEM_BYSTRATA	HAS_BASAL_BYTAXA	HAS_COVER_BYTAXA	HAS_STEM_BYTAXA	CHECKED	UPDATE_USER	LAST_UPDATE
3723	265	3608	Recently burned. No covers for taxa or layers. 179 now RE 3.2.21. This site fits NA derived 3.2.21.	FLAT 8	1990-05-06 00:00:00	2018-01-18 00:00:00	4	0	75	0	4	3	1	20	0	null	null	null	null	null	null	1	121	2018-01-18 15:22:57

Interpretation in TERN Plot Ontology

Encoding each row in RDF requires:

an individual plot:Site representing the site and a plot:SiteVisit representing the row instance.
an ssn-ext:ObservationCollection with dct:type range value to an observation group representing the set of observations of the properties of the FeatureOfInterest.
a related plot:Location describing the location details.

RDF Example

@prefix bioreg: <http://linked.data.gov.au/dataset/bioregion/> .
@prefix corveg-cv: <http://linked.data.gov.au/def/corveg-cv/> .
@prefix corveg-ground-cover: <http://linked.data.gov.au/dataset/corveg/ground-cover/> .
@prefix corveg-location: <http://linked.data.gov.au/dataset/corveg/location/> .
@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 plot-x: <http://linked.data.gov.au/def/plot/x/> .
@prefix prov: <http://www.w3.org/ns/prov#> .
@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-ground-cover:gc-13864-1 a ssn-ext:ObservationCollection ;
    rdfs:label "CORVEG Site 13864 observation collection." ;
    plot:wasSubActivityOf corveg-site:sitev-13864 ;
    dct:type corveg-cv:490d5d57-e24e-435f-877f-93e8833f1282 ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    ssn-ext:hasMember corveg-ground-cover:gc-13864-1-1,
        corveg-ground-cover:gc-13864-1-2,
        corveg-ground-cover:gc-13864-1-3,
        corveg-ground-cover:gc-13864-1-4 .

corveg-location:l-13727 plot-x:isLocationOf corveg-site:site-13864 .

corveg-site:d-13864-1 a ssn-ext:ObservationCollection ;
    rdfs:label "CORVEG Site 13864 observation collection." ;
    plot:wasSubActivityOf corveg-site:sitev-13864 ;
    dct:type corveg-cv:7d236cb2-6fb3-41e6-b126-866e28ac4195 ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    ssn-ext:hasMember corveg-site:d-13864-1-1 .

corveg-ground-cover:gc-13864-1-1 a sosa:Observation ;
    rdfs:label "CORVEG Site 13864 ground cover litter observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site: ] ;
    sosa:hasResult [ a data:Percent ;
            data:value 50.00 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:b89743a5-282e-4164-b060-fce8f59cdbd7 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:resultTime "2016-12-01T00:00:00"^^xsd:dateTime ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:c0a56d07-905d-4cc5-b5e2-d0ffd720a27b ] .

corveg-ground-cover:gc-13864-1-2 a sosa:Observation ;
    rdfs:label "CORVEG Site 13864 ground cover rock observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site: ] ;
    sosa:hasResult [ a data:Percent ;
            data:value 0.00 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:69c4b769-fa84-4217-a8d8-f0d4c894d303 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:resultTime "2016-12-01T00:00:00"^^xsd:dateTime ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:c0a56d07-905d-4cc5-b5e2-d0ffd720a27b ] .

corveg-ground-cover:gc-13864-1-3 a sosa:Observation ;
    rdfs:label "CORVEG Site 13864 ground cover bare observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site: ] ;
    sosa:hasResult [ a data:Percent ;
            data:value 50.00 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:47cd586d-182d-4d97-8135-badf2d7d8e95 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:resultTime "2016-12-01T00:00:00"^^xsd:dateTime ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:c0a56d07-905d-4cc5-b5e2-d0ffd720a27b ] .

corveg-ground-cover:gc-13864-1-4 a sosa:Observation ;
    rdfs:label "CORVEG Site 13864 ground cover cryptogram observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site: ] ;
    sosa:hasResult [ a data:Percent ;
            data:value 0.00 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:c728d11c-421a-4ac3-a45d-76bfa8534b88 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:resultTime "2016-12-01T00:00:00"^^xsd:dateTime ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:c0a56d07-905d-4cc5-b5e2-d0ffd720a27b ] .

corveg-site:d-13864-1-1 a sosa:Observation ;
    rdfs:label "CORVEG Site 13864 area measurement observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site: ] ;
    sosa:hasResult [ a data:QuantitativeMeasure ;
            data:standard unit:M2 ;
            data:value 1000 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:547596af-c2c5-4dff-aa4c-d636f11bdcb4 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:resultTime "2016-12-01T00:00:00"^^xsd:dateTime ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:16155eb3-4e83-49c1-9c2d-ec9f679fddc3 ] .

corveg-site:sitev-13864 a plot:SiteVisit ;
    rdfs:label "CORVEG Site_Visit_Id 13864" ;
    dct:identifier 13864 ;
    prov:endedAtTime "1996-06-11T00:00:00"^^xsd:dateTime ;
    prov:startedAtTime "1996-06-11T00:00:00"^^xsd:dateTime ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] .

corveg-site:site-13864 a plot:Site ;
    rdfs:label "CORVEG Site_Id '13864', Site_Number 'S101_609101(BBS)'" ;
    plot-x:floristics corveg-cv:d271d917-eafd-4f1e-a24a-6c5246067138 ;
    plot-x:sampleLevel corveg-cv:77318ce7-e0cf-4f0a-bbe3-8b80463eee25 ;
    plot-x:sampleType corveg-cv:7e7988af-98a6-4b7a-8f9b-8c92c2703c2c ;
    dct:description "Site located on the Coominglah Range, north of the Burnett Highway." ;
    dct:identifier 13864 ;
    sosa:hasUltimateFeatureOfInterest <http://linked.data.gov.au/dataset/asgs2016/stateorterritory/3>,
        bioreg:BBS,
        bioreg:BBS13,
        <http://linked.data.gov.au/dataset/local-gov-areas-2011/35760>,
        <http://linked.data.gov.au/dataset/nrm-2017/3010>,
        <http://linked.data.gov.au/dataset/wwf-terr-ecoregions/14080> .

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
`SITE_ID`	`dct:identifier`	Added as a literal of type `corveg-def:site-id` for traceability.
`PROJECT_ID`	`prov:wasGeneratedBy`	Not captured by TERN Plot Ontology. Custodian comment: Projects are an internal way of organising our sites for our benefit. No use to users
`LOCATION_ID`	`plot-x:isLocationOf`	Link to another object of type `plot:Location` containing the location details of the site/site visit. Location `plot-x:isLocationOf` Site
`SITE_NUMBER`	`rdfs:label`	The official externally-visible ID captured as part of the site label.
`DESCRIPTION`	`dct:description`	The site’s description as a literal string.
`SITE_DATE`	`sosa:phenomenonTime`	Encoded as `xsd:dateTime` on a `time:Instant` object.
`ENTRY_DATE`	`sosa:resultTime`	Encoded directly as an `xsd:dateTime`.
`LITTER_PERCENT`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Ground Cover CORVEG: Ground Cover `sosa:observedProperty`: Ground Cover - Litter `sosa:usedProcedure`: Ground Cover Assessment Methods `sosa:hasResult`: Class type: `data:Percent`
`ROCK_PERCENT`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Ground Cover CORVEG: Ground Cover `sosa:observedProperty`: Ground Cover - Rock `sosa:usedProcedure`: Ground Cover Assessment Methods `sosa:hasResult`: Class type: `data:Percent`
`BARE_PERCENT`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Ground Cover CORVEG: Ground Cover `sosa:observedProperty`: Ground Cover - Bare `sosa:usedProcedure`: Ground Cover Assessment Methods `sosa:hasResult`: Class type: `data:Percent`
`CRYPTO_PERCENT`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Ground Cover CORVEG: Ground Cover `sosa:observedProperty`: Ground Cover - Cryptogram `sosa:usedProcedure`: Ground Cover Assessment Methods `sosa:hasResult`: Class type: `data:Percent`
`SAMPLELEVEL_ID`	`plot-x:sampleLevel`	Match the source value to the `skos:hiddenLabel` of a narrower concept of Site Sample Level Values.
`SAMPLETYPE_ID`	`plot-x:sampleType`	Match the source value to the `skos:hiddenLabel` of a narrower concept of Site Sample Type Values.
`SAMPLEFLORISTICS_ID`	`plot-x:floristics`	Match the source value to the `skos:hiddenLabel` of a narrower concept of Site Sample Floristics Value.
`SAMPLE_AREA`	`ssn-ext:hasMember`, `sosa:hasResult`	`sosa:observedProperty`: Area `sosa:usedProcedure`: Site Size Method `sosa:hasResult`: Class type: `data:QuantitativeMeasure` Unit of measure: Square Meter
`HAS_PHOTO`		Not captured by TERN Plot Ontology.
`HAS_BASAL_BYSTRATA`		Not encoded directly by TERN Plot Ontology. Can be determined by testing for the existence of a `sosa:Observation` with `sosa:observedProperty` Basal Area whose `sosa:hasFeatureOfInterest/sosa:isSampleOf` is of this site, or a `sosa:Observation` whose `sosa:ObservationCollection` has `sosa:hasFeatureOfInterest/sosa:isSampleOf` of this site.
`HAS_COVER_BYSTRATA`		Not encoded directly by TERN Plot Ontology. Can be determined by testing for the existence of a `sosa:Observation` with `sosa:observedProperty` Crown Cover whose `sosa:hasFeatureOfInterest/sosa:isSampleOf` is of this site, or a `sosa:Observation` whose `sosa:ObservationCollection` has `sosa:hasFeatureOfInterest/sosa:isSampleOf` of this site.
`HAS_STEM_BYSTRATA`		Not encoded directly by TERN Plot Ontology. Can be determined by testing for the existence of a `sosa:Observation` with `sosa:observedProperty` Stem Density whose `sosa:hasFeatureOfInterest/sosa:isSampleOf` is of this site, or a `sosa:Observation` whose `sosa:ObservationCollection` has `sosa:hasFeatureOfInterest/sosa:isSampleOf` of this site.
`HAS_BASAL_BYTAXA`		Not encoded directly by TERN Plot Ontology. Can be determined by testing for the existence of a `sosa:Observation` with `sosa:observedProperty` Basal Area whose `sosa:hasFeatureOfInterest/sosa:isSampleOf` is of this site, or a `sosa:Observation` whose `sosa:ObservationCollection` has `sosa:hasFeatureOfInterest/sosa:isSampleOf` of this site.
`HAS_COVER_BYTAXA`		Not encoded directly by TERN Plot Ontology. Can be determined by testing for the existence of a `sosa:Observation` with `sosa:observedProperty` Crown Cover whose `sosa:hasFeatureOfInterest/sosa:isSampleOf` is of this site, or a `sosa:Observation` whose `sosa:ObservationCollection` has `sosa:hasFeatureOfInterest/sosa:isSampleOf` of this site.
`HAS_STEM_BYTAXA`		Not encoded directly by TERN Plot Ontology. Can be determined by testing for the existence of a `sosa:Observation` with `sosa:observedProperty` Stem Density whose `sosa:hasFeatureOfInterest/sosa:isSampleOf` is of this site, or a `sosa:Observation` whose `sosa:ObservationCollection` has `sosa:hasFeatureOfInterest/sosa:isSampleOf` of this site.
`UPDATE_USER`		Not captured by TERN Plot Ontology.
`LAST_UPDATE`	`dct:modified`	Not captured by TERN Plot Ontology. Database entry or last modified time.

Action Tasks

@Edmond Chuc (Unlicensed) Update ETL with new URIs.

@Edmond Chuc (Unlicensed) Update RDF Example once new URIs have been added.