Soil Bulk Density

Owned by Edmond Chuc (Unlicensed)
Last updated: 16 Apr 2020 by Javier Sanchez
4 min read

Input

Source: AUSPLOTS_RANGELANDS.SOIL_BULK_DENSITY

Interpretation in TERN Plot Ontology

Encoding each row in RDF requires:

  • An ssn-ext:ObservationCollection with the observation group encoded with dct:type 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

Range: plot:SiteVisit

sample_id

sosa:hasSample

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

Range: sosa:Sample

  • sosa:observedProperty: Soil Sample Depth review required Sample doesn’t have observedProperties

  • sosa:hasResult:

    • rdf:type: data:Text

    • data:value: sample_id

  • sosa:isResultOf:

    review required Should not be Soil Bulk Density Method? - TS, the sample depths are described in the soil observation method, hence reference to that method.

 

Name has “ID” in it, but the data does not look like an ID. Example values:

  • 20 - 30cm.

  • 0

  • 1

  • 2

  • 0.00 - 0.10

  • 0 - 10cm

  • None

Looks more like a comment on the size of the sample.

review required Ideally this should be cleaned and converted to a controlled vocabulary of:

  • 0cm - 10cm

  • 10cm - 20cm

  • 20cm - 30cm

Problem is, since it is entered as free text, in the future, the values could be slightly different and then it will break our pipeline.

paper_bag_weight

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

  • sosa:observedProperty: Bag Weight

  • sosa:usedProcedure: Soil Bulk Density Method

  • sosa:hasResult:

    • rdf:type: data:QuantitativeMeasure

    • data:standard: unit:GM

    • data:value: paper_bag_weight

oven_dried_weight_in_bag

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

ring_weight

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

ring_volume

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

  • sosa:observedProperty: Ring Volume

  • sosa:usedProcedure: Soil Bulk Density Method

  • sosa:hasResult:

    • rdf:type: data:QuantitativeMeasure

    • data:standard: unit:CentiM3

    • data:value: ring_volume

gravel_weight

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

gravel_volume

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

fine_earth_weight

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

fine_earth_weight_in_bag

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

fine_earth_volume

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

fine_earth_bulk_density

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

  • sosa:observedProperty: Soil Bulk Density

  • sosa:usedProcedure: Soil Bulk Density Method

  • sosa:hasResult:

    • rdf:type: data:QuantitativeMeasure

    • data:standard: todo g/cm3 is not available in QUDT unit

    • data:value: fine_earth_bulk_density

gravel_bulk_density

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

TERN: Soil Profile

AUSPLOTS: Soil

  • sosa:observedProperty: Soil Bulk Density

  • sosa:usedProcedure: Soil Bulk Density Method

  • sosa:hasResult:

    • rdf:type: data:QuantitativeMeasure

    • data:standard: todo g/cm3 is not available in QUDT unit

    • data:value: fine_earth_bulk_density

Example Row

ID

SITE_LOCATION_VISIT_ID

SAMPLE_ID

PAPER_BAG_WEIGHT

OVEN_DRIED_WEIGHT_IN_BAG

RING_WEIGHT

GRAVEL_WEIGHT

RING_VOLUME

GRAVEL_VOLUME

FINE_EARTH_WEIGHT_IN_BAG

FINE_EARTH_WEIGHT

FINE_EARTH_VOLUME

FINE_EARTH_BULK_DENSITY

GRAVEL_BULK_DENSITY

WET_WEIGHT_IN_BAG

ID

SITE_LOCATION_VISIT_ID

SAMPLE_ID

PAPER_BAG_WEIGHT

OVEN_DRIED_WEIGHT_IN_BAG

RING_WEIGHT

GRAVEL_WEIGHT

RING_VOLUME

GRAVEL_VOLUME

FINE_EARTH_WEIGHT_IN_BAG

FINE_EARTH_WEIGHT

FINE_EARTH_VOLUME

FINE_EARTH_BULK_DENSITY

GRAVEL_BULK_DENSITY

WET_WEIGHT_IN_BAG

64763

53471

0

null

null

154.06

null

209.35

null

null

332.85

209.35

1.59

null

null

RDF Example

@prefix ausplots: <http://linked.data.gov.au/dataset/ausplots/> . @prefix ausplots-cv: <http://linked.data.gov.au/def/ausplots-cv/> . @prefix biod: <http://linked.data.gov.au/def/biodiversity/> . @prefix bioreg: <http://linked.data.gov.au/dataset/bioregion/> . @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 geosparql-ext: <http://linked.data.gov.au/def/geox#> . @prefix ldp: <http://www.w3.org/ns/ldp#> . @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 reg: <http://purl.org/linked-data/registry/> . @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: <http://www.w3.org/ns/ssn/> . @prefix ssn-ext: <http://www.w3.org/ns/ssn/ext/> . @prefix time: <http://www.w3.org/2006/time#> . @prefix ui: <http://purl.org/linked-data/registry-ui#> . @prefix unit: <http://qudt.org/vocab/unit/> . @prefix void: <http://rdfs.org/ns/void#> . @prefix xml: <http://www.w3.org/XML/1998/namespace> . @prefix xsd: <http://www.w3.org/2001/XMLSchema#> . ausplots:s-oc-53471 a ssn-ext:ObservationCollection ; rdfs:label "AUSPLOTS Rangelands 'Soil' Observation Collection for SiteVisit: '53471'" ; plot:wasSubActivityOf ausplots:sv-53471 ; dct:identifier 53471 ; dct:type <http://linked.data.gov.au/def/ausplots-cv/68eec465-a91e-49a8-9265-6da7ef8ad284> ; sosa:hasSample ausplots:s-oc-53471-sbd-64763-s-1; ssn-ext:hasMember ausplots:s-oc-53471-sbd-64763-o-1, ausplots:s-oc-53471-sbd-64763-o-2, ausplots:s-oc-53471-sbd-64763-o-3, ausplots:s-oc-53471-sbd-64763-o-4 . ausplots:s-oc-53471-sbd-64763-o-1 a sosa:Observation ; rdfs:label "SiteVisit: '53471' | Soil Bulk Density: '64763' | Observation 1 (RING_WEIGHT)" ; sosa:hasFeatureOfInterest ausplots:s-oc-53471-sbd-64763-s-1 ; sosa:hasResult [ a data:QuantitativeMeasure ; data:standard unit:TODO ; data:value 154.06000000 ] ; sosa:observedProperty ausplots-cv:e8ce6d92-062d-47cc-8c3c-0a84bb3478dd ; sosa:usedProcedure ausplots-cv:c31d4b2e-ed09-4cd1-903a-749405e1d25f . ausplots:s-oc-53471-sbd-64763-o-2 a sosa:Observation ; rdfs:label "SiteVisit: '53471' | Soil Bulk Density: '64763' | Observation 2 (RING_VOLUME)" ; sosa:hasFeatureOfInterest ausplots:s-oc-53471-sbd-64763-s-1 ; sosa:hasResult [ a data:QuantitativeMeasure ; data:standard unit:TODO ; data:value 209.35000000 ] ; sosa:observedProperty <http://linked.data.gov.au/def/ausplots-cv/1da0c450-475a-48f2-b558-ccc2b3b74996> ; sosa:usedProcedure ausplots-cv:c31d4b2e-ed09-4cd1-903a-749405e1d25f . ausplots:s-oc-53471-sbd-64763-o-3 a sosa:Observation ; rdfs:label "SiteVisit: '53471' | Soil Bulk Density: '64763' | Observation 3 (FINE_EARTH_VOLUME)" ; sosa:hasFeatureOfInterest ausplots:s-oc-53471-sbd-64763-s-1 ; sosa:hasResult [ a data:QuantitativeMeasure ; data:standard unit:TODO ; data:value 209.35000000 ] ; sosa:observedProperty ausplots-cv:c851d7a8-c14b-4e44-9feb-267c87227990 ; sosa:usedProcedure ausplots-cv:c31d4b2e-ed09-4cd1-903a-749405e1d25f . ausplots:s-oc-53471-sbd-64763-o-4 a sosa:Observation ; rdfs:label "SiteVisit: '53471' | Soil Bulk Density: '64763' | Observation 4 (FINE_EARTH_BULK_DENSITY)" ; sosa:hasFeatureOfInterest ausplots:s-oc-53471-sbd-64763-s-1 ; sosa:hasResult [ a data:QuantitativeMeasure ; data:standard unit:TODO ; data:value 1.59000000 ] ; sosa:observedProperty <http://linked.data.gov.au/def/ausplots-cv/4c2c9752-efcd-4f35-bdad-b15126c838f1> ; sosa:usedProcedure ausplots-cv:c31d4b2e-ed09-4cd1-903a-749405e1d25f . ausplots:s-oc-53471-sbd-64763-s-1 a sosa:Sample ; rdfs:label "AUSPLOTS Rangelands Soil Bulk Density: 64763, Site Visit: 53471, Sample 1" ; rdfs:comment "Sample - 1" ; sosa:hasResult [ a data:Text ; data:value "0" ] ; sosa:isResultOf [ a sosa:Sampling ; sosa:usedProcedure ausplots-cv:c31d4b2e-ed09-4cd1-903a-749405e1d25f ] .