Soil Bulk Density
Input
Source: AUSPLOTS_RANGELANDS.SOIL_BULK_DENSITY
Interpretation in TERN Plot Ontology
Encoding each row in RDF requires:
An
ssn-ext:ObservationCollectionwith the observation group encoded withdct:typetodo
Mapping Table
Source Column | Destination RDF Predicate | Comments |
|---|---|---|
|
|
|
|
| Domain: Range: |
|
| Member of Range:
Name has “ID” in it, but the data does not look like an ID. Example values:
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:
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. |
|
| Member of TERN: Soil Profile AUSPLOTS: Soil
|
|
| Member of TERN: Soil Profile AUSPLOTS: Soil
|
|
| Member of TERN: Soil Profile AUSPLOTS: Soil
|
|
| Member of TERN: Soil Profile AUSPLOTS: Soil
|
|
| Member of TERN: Soil Profile AUSPLOTS: Soil
|
|
| Member of TERN: Soil Profile AUSPLOTS: Soil
|
|
| Member of TERN: Soil Profile AUSPLOTS: Soil
|
|
| Member of TERN: Soil Profile AUSPLOTS: Soil
|
|
| Member of TERN: Soil Profile AUSPLOTS: Soil
|
|
| Member of TERN: Soil Profile AUSPLOTS: Soil
|
|
| Member of TERN: Soil Profile AUSPLOTS: Soil
|
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 ] .