Soil Characterisation

Soil Characterisation

Source: AUSPLOTS_RANGELANDS.SOILS_CHARACTERISATION

This table records the soil chemistry data collected from the soil pit outside the main plot site.

Interpretation in TERN Plot Ontology

Encoding each row in RDF requires:

  • todo

Mapping Table

Source Column

Destination RDF Predicate

Comments

Source Column

Destination RDF Predicate

Comments

id

dct:identifier, rdfs:label

 

site_location_visit_id

plot:wasSubActivityOf

Domain: ssn-ext:ObservationCollection with dct:type SITE AND LOCATION

Range: plot:SiteVisit

layer_barcode

sosa:hasSample

Domain: ssn-ext:ObservationCollection with dct:type SOIL

Range: sosa:Sample

  • sosa:hasResult:

    • rdf:type: data:Text

    • data:value: layer_barcode

Create sosa:Sampling instance

upper_depth

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

lower_depth

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

horizon

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

review required - Is this to another look-up table? It is not linked in the schema.

TS double check with Ausplots crew, should have details about horizon, see page 49 of manual

The manual quotes the Yellow Book pages 148-158. It’s the HORIZONS chapter/section and each classification has a code which corresponds to the text value in this column. Need to create the controlled vocabulary for this manually as there is no look-up table.

texture_grade

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

texture_qualifier

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

texture_modifier

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

colour_when_moist

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

review required - Values look like a mixture of codes and moisture colour values.

TS- colour codes are on page 74 of manual, do they match data values?

EC - They don’t match exactly. It’s a string that contains codes for the. colour but there are also numerical values.

colour_when_dry

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

review required - Values look like a mixture of codes and moisture colour values.

TS- colour codes are on page 74 of manual, do they match data values?

EC - They don’t match exactly. It’s a string that contains codes for the. colour but there are also numerical values.

mottles_colour

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

mottles_abundance

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

mottles_size

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

segregations_abundance

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

segregations_size

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

segregations_nature

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

segregations_form

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

comments

rdfs:comments

 

collected_by

prov:wasAttributedTo

Value from look-up table lut_observer

  • rdf:type: prov:Person, sdo:Person

  • sdo:givenName: First name

  • sdo:familyName: Last name

  • prov:actedOnBehalfOf:

    • rdf:type: prov:Organization, sdo:Organization

    • sdo:legalName: Name of the organization

smallest_size_1

 

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

smallest_size_2

 

Not captured by TERN Plot Ontology.