Situation Table (Landscape Features)

Source: CORVEG.SITUATION

Example row:

SITE_ID	LAND_SITUATION_ID	LAND_ELEMENT_ID	EROSION_PATTERN_ID	SLOPE_TYPE_ID	SLOPE_ANGLE	SLOPE_ERROR	ASPECT_ANGLE	ASPECT_ERROR	ALTITUTDE	ALTITUDE_ERROR	UPDATE_USER	LAST_UPDATE	PATTERN_ID

SITE_ID	LAND_SITUATION_ID	LAND_ELEMENT_ID	EROSION_PATTERN_ID	SLOPE_TYPE_ID	SLOPE_ANGLE	SLOPE_ERROR	ASPECT_ANGLE	ASPECT_ERROR	ALTITUTDE	ALTITUDE_ERROR	UPDATE_USER	LAST_UPDATE	PATTERN_ID
2537	3	37	20	8	1	null	35	null	295	null	2289	2016-10-21 10:07:52	14

Interpretation in TERN Plot Ontology

Encoding each row in RDF requires:

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

Example RDF

@prefix corveg-cv: <http://linked.data.gov.au/def/corveg-cv/> .
@prefix corveg-site: <http://linked.data.gov.au/dataset/corveg/site/> .
@prefix corveg-situation: <http://linked.data.gov.au/dataset/corveg/situation/> .
@prefix data: <http://linked.data.gov.au/def/datatype/> .
@prefix dct: <http://purl.org/dc/terms/> .
@prefix epsg-crs: <http://www.opengis.net/def/crs/epsg/0/> .
@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 unit: <http://qudt.org/vocab/unit/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .

corveg-situation:sit-13864 a ssn-ext:ObservationCollection ;
    rdfs:label "Site 13864 situation observation collection" ;
    plot:wasSubActivityOf corveg-site:sitev-13864 ;
    dct:type corveg-cv:7c492ba1-e28b-4419-b229-68d073a92818 ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    ssn-ext:hasMember corveg-situation:sit-13864-1,
        corveg-situation:sit-13864-2,
        corveg-situation:sit-13864-3,
        corveg-situation:sit-13864-4,
        corveg-situation:sit-13864-5,
        corveg-situation:sit-13864-6,
        corveg-situation:sit-13864-7,
        corveg-situation:sit-13864-8 .

corveg-situation:sit-13864-1 a sosa:Observation ;
    rdfs:label "Site 13864 land situation observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:44201cde-3065-42fa-8615-2a882ac5373c ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:214cb352-75bc-4d5e-ad94-fa20084da882 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:accc1498-2bcb-4409-a7df-75f86e9a35e7 ] .

corveg-situation:sit-13864-2 a sosa:Observation ;
    rdfs:label "Site 13864 land element observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:be4296b1-1c23-4690-85ad-25bc52ad5dd6 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:d9b0e1c7-9372-4f6a-bc99-d92291f83c45 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:accc1498-2bcb-4409-a7df-75f86e9a35e7 ] .

corveg-situation:sit-13864-3 a sosa:Observation ;
    rdfs:label "Site 13864 erosion pattern observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:f36c693b-e91a-42a8-99c7-368d0f321cfa ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:4a3ed3ca-99c5-47c1-8ac0-a7d7e1238b34 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:accc1498-2bcb-4409-a7df-75f86e9a35e7 ] .

corveg-situation:sit-13864-4 a sosa:Observation ;
    rdfs:label "Site 13864 slope type observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:fb74b338-664e-4e31-968d-e3b42e59c3d0 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:ffd5b4cb-87cf-4724-92db-cea54da0f8fd ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:1063c7f1-9812-41cb-a85d-edf7fb959516 ] .

corveg-situation:sit-13864-5 a sosa:Observation ;
    rdfs:label "Site 13864 slope angle observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:QuantitativeMeasure ;
            data:standard unit:DEG ;
            data:value 3 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:a981282e-8d78-4497-85ff-2321b3a3066d ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:1063c7f1-9812-41cb-a85d-edf7fb959516 ] .

corveg-situation:sit-13864-6 a sosa:Observation ;
    rdfs:label "Site 13864 aspect angle observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:QuantitativeMeasure ;
            data:standard unit:DEG ;
            data:value 315 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:203e1b76-a23a-4412-8244-37e724b37714 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:1063c7f1-9812-41cb-a85d-edf7fb959516 ] .

corveg-situation:sit-13864-7 a sosa:Observation ;
    rdfs:label "Site 13864 altitude observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:QuantitativeMeasure ;
            data:standard epsg-crs:5711 ;
            data:value 480 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:ee27ca69-bb61-4191-a06e-144fe24b70c4 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:1960026f-6428-4ee6-8c7a-a3e9ae0dd335 ] .

corveg-situation:sit-13864-8 a sosa:Observation ;
    rdfs:label "Site 13864 landform pattern observation" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf corveg-site:site-13864 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value corveg-cv:f65d3776-02d3-4f03-9e22-bc596b9f99df ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value corveg-cv:c7727061-97d6-4047-8d89-f25ca3221645 ] ;
    sosa:phenomenonTime corveg-site:t1996-06-11-h0-m0-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value corveg-cv:accc1498-2bcb-4409-a7df-75f86e9a35e7 ] .

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`	`sosa:hasFeatureOfInterest`	Domain: `ssn-ext:ObservationCollection` Range: `plot:Site`
`LAND_SITUATION_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Landform CORVEG: Landform Features `sosa:observedProperty`: Landform Situation `sosa:usedProcedure`: Landform Description `sosa:hasResult`: a narrower concept of Landform Type Values matching on the `skos:hiddenLabel`.
`LAND_ELEMENT_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Landform CORVEG: Landform Features `sosa:observedProperty`: Landform Element `sosa:usedProcedure`: Landform Description `sosa:hasResult`: a narrower concept of Landform Element Values matching on the `skos:hiddenLabel`.
`EROSION_PATTERN_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Landform Features `sosa:observedProperty`: Erosional Landform Pattern `sosa:usedProcedure`: Landform Description `sosa:hasResult`: Erosional Landform Pattern Values
`SLOPE_TYPE_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Landform Features `sosa:observedProperty`: Slope Type `sosa:usedProcedure`: Aspect and Slope Assessment `sosa:hasResult`: a narrower concept of Slope Type Values matching on the `skos:hiddenLabel`.
`SLOPE_ANGLE`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Landform Features `sosa:observedProperty`: Slope Angle `sosa:usedProcedure`: Aspect and Slope Assessment `sosa:hasResult`: Class type: `data:QuantitativeMeasure` Unit of measure: `unit:DEG`
`SLOPE_ERROR`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Landform Features `sosa:observedProperty`: Slope Angle `sosa:usedProcedure`: Aspect and Slope Assessment `sosa:hasResult`: Class type: `data:QuantitativeMeasure` Unit of measure: `unit:DEG` Use `data:uncertainty` as the predicate for the value.
`ASPECT_ANGLE`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Landform Features `sosa:observedProperty`: Aspect Angle `sosa:usedProcedure`: Aspect and Slope Assessment `sosa:hasResult`: Class type: `data:QuantitativeMeasure` Unit of measure: `unit:DEG`
`ASPECT_ERROR`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Landform Features `sosa:observedProperty`: Aspect Angle `sosa:usedProcedure`: Aspect and Slope Assessment `sosa:hasResult`: Class type: `data:QuantitativeMeasure` Unit of measure: `unit:DEG` Use `data:uncertainty` as the predicate for the value.
`ALTITUDE`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Landform Features `sosa:observedProperty`: Altitude `sosa:usedProcedure`: Altitude Assessment `sosa:hasResult`: Class type: `data:QuantitativeMeasure` Unit of measure: `unit:M`, Australian Height Datum
`ALTITUDE_ERROR`		Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface CORVEG: Landform Features `sosa:observedProperty`: Altitude `sosa:usedProcedure`: Altitude Assessment `sosa:hasResult`: Class type: `data:QuantitativeMeasure` Unit of measure: `unit:M`, Australian Height Datum Use `data:uncertainty` as the predicate for the value.
`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`.
`PATTERN_ID`	`ssn-ext:hasMember`, `sosa:hasResult`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Landform CORVEG: Landform Features `sosa:observedProperty`: Landform Pattern `sosa:usedProcedure`: Landform Description `sosa:hasResult`: a narrower value of Landform Pattern Values matching on the `skos:hiddenLabel`.

CORVEG Dataset Integration

Situation Table (Landscape Features)

Interpretation in TERN Plot Ontology

Example RDF

Mapping Table

Action Items