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.

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`