Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Source: AUSPLOTS_RANGELANDS.SOILS_CHARACTERISATION

...

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 SOIL

Status
colourYellow
titleTERN:
Soil Profile

Status
colourGreen
titleAUSPLOTS:
Soil

lower_depth

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type SOIL

Status
colourYellow
titleTERN:
Soil Profile

Status
colourGreen
titleAUSPLOTS:
Soil

horizon

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type SOIL

  • sosa:observedProperty: Soil Horizon

  • sosa:usedProcedure:

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colour

    Blue

    Green
    titleAUSPLOTS:
    Soil

    Status
    colourYellow
    titlereview 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 SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    texture_qualifier

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    texture_modifier

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL

  • sosa:observedProperty: Soil Texture Modifier

  • Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    colour_when_moist

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    Status
    colourYellow
    titlereview 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 SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    Status
    colourYellow
    titlereview 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 SOIL

    sosa:

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    mottles_abundance

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    mottles_size

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    segregations_abundance

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    segregations_size

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    segregations_nature

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL:ObservationCollection with dct:type

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    segregations_form

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    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 SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    smallest_size_2

    Not captured by TERN Plot Ontology.

    All values are null.

    next_size_1

    Status
    colourYellow
    titlereview required

    Possibly also linking to lut_structure_size - need to confirm. Foreign keys are convincing.

    next_size_2

    Not captured by TERN Plot Ontology.

    All values are null.

    smallest_size_type_1

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL:ObservationCollection with dct:type

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    smallest_size_type_2

    ssn-ext:hasMember, sosa:hasResult

    Not captured by TERN Plot Ontology.

    next_size_type_1

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    next_size_type_2

    ssn-ext:hasMember, sosa:hasResult

    Not captured by TERN Plot Ontology.

    pedality_fabric

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    pedality_grade

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL with dct:type

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    ph

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    • sosa:observedProperty: Soil pH

    • sosa:usedProcedure: Soil Characterisation Method

    • sosa:hasResult:

      • rdf:type: data:QuantitativeMeasure

      • data:standard:

        Status
        colourRed
        titletodo
        pH not available in QUDT units.

      • data:value: ph

    ec

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    effervescence

    ssn-ext:hasMember, sosa:hasResult

    Member of ssn-ext:ObservationCollection with dct:type SOIL

    Status
    colourYellow
    titleTERN:
    Soil Profile

    Status
    colourGreen
    titleAUSPLOTS:
    Soil

    ...