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
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 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-situation:sit-2537 a ssn-ext:ObservationCollection ;
    rdfs:label "Site 2537 situation observation collection" ;
    dct:modified "2016-10-21T10:07:52"^^xsd:dateTime ;
    dct:type <http://linked.data.gov.au/def/corveg-cv/7c492ba1-e28b-4419-b229-68d073a92818> ;
    sosa:hasFeatureOfInterest corveg-site:site-2537 ;
    ssn-ext:hasMember corveg-situation:sit-2537-1,
        corveg-situation:sit-2537-2,
        corveg-situation:sit-2537-3,
        corveg-situation:sit-2537-4,
        corveg-situation:sit-2537-5,
        corveg-situation:sit-2537-6,
        corveg-situation:sit-2537-7,
        corveg-situation:sit-2537-8 .

corveg-situation:sit-2537-1 a sosa:Observation ;
    rdfs:label "Site 2537 land situation observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-2537 ;
    sosa:hasResult corveg-cv:b83709f5-1777-4fce-8ae5-52317447c8c9 ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/214cb352-75bc-4d5e-ad94-fa20084da882> ;
    sosa:phenomenonTime corveg-site:t1991-06-25-h0-m0-s0 ;
    sosa:usedProcedure corveg-cv:accc1498-2bcb-4409-a7df-75f86e9a35e7 .

corveg-situation:sit-2537-2 a sosa:Observation ;
    rdfs:label "Site 2537 land element observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-2537 ;
    sosa:hasResult <http://linked.data.gov.au/def/corveg-cv/71785ffc-b497-4249-a9b7-4045ecc4663d> ;
    sosa:observedProperty corveg-cv:d9b0e1c7-9372-4f6a-bc99-d92291f83c45 ;
    sosa:phenomenonTime corveg-site:t1991-06-25-h0-m0-s0 ;
    sosa:usedProcedure corveg-cv:accc1498-2bcb-4409-a7df-75f86e9a35e7 .

corveg-situation:sit-2537-3 a sosa:Observation ;
    rdfs:label "Site 2537 erosion pattern observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-2537 ;
    sosa:hasResult <http://linked.data.gov.au/def/corveg-cv/6e7c305c-c2c0-4867-9d5d-1388395bbd97> ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/4a3ed3ca-99c5-47c1-8ac0-a7d7e1238b34> ;
    sosa:phenomenonTime corveg-site:t1991-06-25-h0-m0-s0 ;
    sosa:usedProcedure corveg-cv:accc1498-2bcb-4409-a7df-75f86e9a35e7 .

corveg-situation:sit-2537-4 a sosa:Observation ;
    rdfs:label "Site 2537 slope type observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-2537 ;
    sosa:hasResult <http://linked.data.gov.au/def/corveg-cv/951e5ace-558a-4c21-baed-069a4a9f2e1b> ;
    sosa:observedProperty corveg-cv:ffd5b4cb-87cf-4724-92db-cea54da0f8fd ;
    sosa:phenomenonTime corveg-site:t1991-06-25-h0-m0-s0 ;
    sosa:usedProcedure <http://linked.data.gov.au/def/corveg-cv/1063c7f1-9812-41cb-a85d-edf7fb959516> .

corveg-situation:sit-2537-5 a sosa:Observation ;
    rdfs:label "Site 2537 slope angle observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-2537 ;
    sosa:hasResult [ a data:QuantitativeMeasure ;
            data:standard unit:DEG ;
            data:value 1 ] ;
    sosa:observedProperty corveg-cv:a981282e-8d78-4497-85ff-2321b3a3066d ;
    sosa:phenomenonTime corveg-site:t1991-06-25-h0-m0-s0 ;
    sosa:usedProcedure <http://linked.data.gov.au/def/corveg-cv/1063c7f1-9812-41cb-a85d-edf7fb959516> .

corveg-situation:sit-2537-6 a sosa:Observation ;
    rdfs:label "Site 2537 aspect angle observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-2537 ;
    sosa:hasResult [ a data:QuantitativeMeasure ;
            data:standard unit:DEG ;
            data:value 35 ] ;
    sosa:observedProperty <http://linked.data.gov.au/def/corveg-cv/203e1b76-a23a-4412-8244-37e724b37714> ;
    sosa:phenomenonTime corveg-site:t1991-06-25-h0-m0-s0 ;
    sosa:usedProcedure <http://linked.data.gov.au/def/corveg-cv/1063c7f1-9812-41cb-a85d-edf7fb959516> .

corveg-situation:sit-2537-7 a sosa:Observation ;
    rdfs:label "Site 2537 altitude observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-2537 ;
    sosa:hasResult [ a data:QuantitativeMeasure ;
            data:standard <http://www.opengis.net/def/crs/epsg/0/5711> ;
            data:value 295 ] ;
    sosa:observedProperty corveg-cv:ee27ca69-bb61-4191-a06e-144fe24b70c4 ;
    sosa:phenomenonTime corveg-site:t1991-06-25-h0-m0-s0 ;
    sosa:usedProcedure <http://linked.data.gov.au/def/corveg-cv/1960026f-6428-4ee6-8c7a-a3e9ae0dd335> .

corveg-situation:sit-2537-8 a sosa:Observation ;
    rdfs:label "Site 2537 landform pattern observation" ;
    sosa:hasFeatureOfInterest corveg-site:site-2537 ;
    sosa:hasResult <http://linked.data.gov.au/def/corveg-cv/0177a99c-0e2c-4df3-90d3-b893d096c611> ;
    sosa:observedProperty corveg-cv:c7727061-97d6-4047-8d89-f25ca3221645 ;
    sosa:phenomenonTime corveg-site:t1991-06-25-h0-m0-s0 ;
    sosa:usedProcedure corveg-cv:accc1498-2bcb-4409-a7df-75f86e9a35e7 .

corveg-site:t1991-06-25-h0-m0-s0 a time:Instant ;
    time:inXSDDateTime "1991-06-25T00:00:00"^^xsd:dateTime .

Mapping Table

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

Situation Table (Landscape Features)

Interpretation in TERN Plot Ontology

Example RDF

Mapping Table

Action Items