Situation Table

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

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`	`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`	`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`	`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`	`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`	`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`	`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`	`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`	`sosa:observedProperty`: Altitude `sosa:usedProcedure`: Altitude Assessment `sosa:hasResult`: Class type: `data:QuantitativeMeasure` Unit of measure: `unit:M`, Australian Height Datum
`ALTITUDE_ERROR`		`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`	`sosa:observedProperty`: Landform Pattern `sosa:usedProcedure`: Landform Description `sosa:hasResult`: a narrower value of Landform Pattern Values matching on the `skos:hiddenLabel`.

Interpretation in TERN Plot Ontology

Example RDF

Mapping Table

Action Items

0 Comments