Input

Source: AUSPLOTS_RANGELANDS.SOIL_SUBSITE_OBSERVATIONS

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`
`subsite_id`	`dct:hasPart`	Domain: `plot:Site` of the main site Range: `plot:Site` of this sub-site TS- I think these are the sub soil sampling sites, see page 50 of manual and data sheet at end of the manual (page 82 and 84) (five sub soil sampling sites within a 25 m x 25 m zone in the south west corner of the plot @ 0-10 cm, 10-20 cm and 20-30 cm)
`zone`		review EC - For all the location data, we can convert it the UTM system to latitude and longitude and capture the data with the `plot:Location` and `geo:Point` classes. TS - see comment above
`easting`		review TS - see comment above
`northing`		review TS - see comment above
`zero_to_ten_barcode`	`sosa:hasSample`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Soil Profile AUSPLOTS: Soil Range: `sosa:Sample` `sosa:hasResult`: `rdf:type`: `data:Text` `data:value`: `zero_to_ten_barcode` Create `sosa:Sampling` instance `sosa:usedProcedure`: http://linked.data.gov.au/def/ausplots-cv/b49db586-17e6-4a6b-8a48-167e2ad9c577
`ten_to_twenty_barcode`	`sosa:hasSample`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Soil Profile AUSPLOTS: Soil Range: `sosa:Sample` `sosa:hasResult`: `rdf:type`: `data:Text` `data:value`: `ten_to_twenty_barcode` Create `sosa:Sampling` instance `sosa:usedProcedure`: http://linked.data.gov.au/def/ausplots-cv/b49db586-17e6-4a6b-8a48-167e2ad9c577
`twenty_to_thirty_barcode`	`sosa:hasSample`	Domain: `ssn-ext:ObservationCollection` with `dct:type` TERN: Soil Profile AUSPLOTS: Soil Range: `sosa:Sample` `sosa:hasResult`: `rdf:type`: `data:Text` `data:value`: `twenty_to_thirty_barcode` Create `sosa:Sampling` instance `sosa:usedProcedure`: http://linked.data.gov.au/def/ausplots-cv/b49db586-17e6-4a6b-8a48-167e2ad9c577
`comments`	`rdfs:comment`
`metagenomics_are_available`		Not captured by TERN Plot Ontology. Can see if it is available by testing to see if a `metagenomic_barcode` sample is present.
`metagenomic_barcode`	`sosa:hasSample`	Domain: `ssn-ext:ObservationCollection` Range: `sosa:Sample` `sosa:hasResult`: `rdf:type`: `data:Text` `data:value`: `metagenomic_barcode` Create `sosa:Sampling` instance `sosa:usedProcedure`: http://linked.data.gov.au/def/ausplots-cv/b49db586-17e6-4a6b-8a48-167e2ad9c577
`metagenomic_url`		Not captured by TERN Plot Ontology. All values are null.
`photo_no`		Done TS: should be sample, with `sosa:usedProcedure`: http://linked.data.gov.au/def/ausplots-cv/b49db586-17e6-4a6b-8a48-167e2ad9c577 Should this be a sample or an observation? The value is not the photo file name. What is it?
`photo_url`		Not captured by TERN Plot Ontology. All values are either null or “EMPTY”.
`observer`		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

Example Row

ID	SITE_LOCATION_VISIT_ID	SUBSITE_ID	ZONE	EASTING	NORTHING	ZERO_TO_TEN_BARCODE	TEN_TO_TWENTY_BARCODE	TWENTY_TO_THIRTY_BARCODE	COMMENTS	METAGENOMICS_ARE_AVAILABLE	METAGENOMIC_BARCODE	METAGENOMIC_URL	PHOTO_NO	PHOTO_URL	OBSERVER

ID	SITE_LOCATION_VISIT_ID	SUBSITE_ID	ZONE	EASTING	NORTHING	ZERO_TO_TEN_BARCODE	TEN_TO_TWENTY_BARCODE	TWENTY_TO_THIRTY_BARCODE	COMMENTS	METAGENOMICS_ARE_AVAILABLE	METAGENOMIC_BARCODE	METAGENOMIC_URL	PHOTO_NO	PHOTO_URL	OBSERVER
329296	53471	1	55	202744	7851382	QDA 050387	QDA 050388	QDA 050389	between grass tussocks	TRUE	QDA 053180	null	null	null	4

Example RDF

@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:l-53471-329296 a plot:Location ;
    rdfs:label "Location l-53471-329296" ;
    plot-x:isLocationOf ausplots:site-53471-329296 ;
    dct:description "Location from SubSite: '329296' converted from UTM (zone=55, easting=202744, northing=7851382)" ;
    dct:identifier "l-53471-329296" ;
    geosparql:hasGeometry [ a geo:Point ;
            geo:lat -1.940984e+01 ;
            geo:long 1.441696e+02 ] .

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-sso-329296-s-1,
        ausplots:s-oc-53471-sso-329296-s-2,
        ausplots:s-oc-53471-sso-329296-s-3,
        ausplots:s-oc-53471-sso-329296-s-4;
    ssn-ext:hasMember ausplots:s-oc-53471-sso-329296-o-1 .

ausplots:s-oc-53471-sso-329296-o-1 a sosa:Observation ;
    rdfs:label "SiteVisit: '53471' | Soil Subsite Observations: '329296' | Observation 1 (OBSERVER)" ;
    sosa:hasFeatureOfInterest ausplots:s-oc-53471-sso-329296-s-1,
        ausplots:s-oc-53471-sso-329296-s-2,
        ausplots:s-oc-53471-sso-329296-s-3,
        ausplots:s-oc-53471-sso-329296-s-4 ;
    sosa:hasResult <http://linked.data.gov.au/def/ausplots-cv/3c8cb579-ebc1-4b63-90a8-b5c792040225> ;
    sosa:observedProperty <not_needed> ;
    sosa:usedProcedure ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 .

ausplots:site-53471-329296 a plot:Site ;
    rdfs:label "SubsiteID: '1' | SiteVisit: '53471' | Site: '59890'" ;
    dct:identifier "53471-329296" ;
    dct:isPartOf ausplots:site-59890 ;
    rdfs:comment "This is a Subsite" ;
    sosa:hasSample ausplots:s-oc-53471-sso-329296-s-1,
        ausplots:s-oc-53471-sso-329296-s-2,
        ausplots:s-oc-53471-sso-329296-s-3,
        ausplots:s-oc-53471-sso-329296-s-4 .

ausplots:s-oc-53471-sso-329296-s-1 a sosa:Sample ;
    rdfs:label "Sample: QDA   050387" ;
    dct:identifier "QDA   050387" ;
    rdfs:comment "Column: ZERO_TO_TEN_BARCODE",
        "between grass tussocks" ;
    sosa:hasResult [ a data:Text ;
            data:value "QDA   050387" ] ;
    sosa:isResultOf [ a sosa:Sampling ;
            sosa:usedProcedure <http://linked.data.gov.au/def/ausplots-cv/6d5764b3-6a0c-4937-88f1-11fe280c6524> ] .

ausplots:s-oc-53471-sso-329296-s-2 a sosa:Sample ;
    rdfs:label "Sample: QDA   050388" ;
    dct:identifier "QDA   050388" ;
    rdfs:comment "Column: TEN_TO_TWENTY_BARCODE",
        "between grass tussocks" ;
    sosa:hasResult [ a data:Text ;
            data:value "QDA   050388" ] ;
    sosa:isResultOf [ a sosa:Sampling ;
            sosa:usedProcedure <http://linked.data.gov.au/def/ausplots-cv/6d5764b3-6a0c-4937-88f1-11fe280c6524> ] .

ausplots:s-oc-53471-sso-329296-s-3 a sosa:Sample ;
    rdfs:label "Sample: QDA   050389" ;
    dct:identifier "QDA   050389" ;
    rdfs:comment "Column: TWENTY_TO_THIRTY_BARCODE",
        "between grass tussocks" ;
    sosa:hasResult [ a data:Text ;
            data:value "QDA   050389" ] ;
    sosa:isResultOf [ a sosa:Sampling ;
            sosa:usedProcedure <http://linked.data.gov.au/def/ausplots-cv/6d5764b3-6a0c-4937-88f1-11fe280c6524> ] .

ausplots:s-oc-53471-sso-329296-s-4 a sosa:Sample ;
    rdfs:label "Sample: QDA 053180" ;
    dct:identifier "QDA 053180" ;
    rdfs:comment "Column: METAGENOMIC_BARCODE",
        "between grass tussocks" ;
    sosa:hasResult [ a data:Text ;
            data:value "QDA 053180" ] ;
    sosa:isResultOf [ a sosa:Sampling ;
            sosa:usedProcedure <http://linked.data.gov.au/def/ausplots-cv/6d5764b3-6a0c-4937-88f1-11fe280c6524> ] .