Input

Source: AUSPLOTS_RANGELANDS.CHARACTERISATION_COARSE_FRAGS_LITHOLOGY
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
soil_characterisation_id
Used by the observation.
lithology_code
ssn-ext:hasMember, sosa:hasResult
Member of ssn-ext:ObservationCollection with dct:type
TERN: Land Surface
Ausplots: Land Surface
sosa:observedProperty: Lithology of coarse fragments
sosa:usedProcedure: Soil Characterisation Method
sosa:hasResult: value from collection Lithology
Example Row

ID	SOIL_CHARACTERISATION_ID	LITHOLOGY_CODE
ID	SOIL_CHARACTERISATION_ID	LITHOLOGY_CODE
103854	118632	NC
Example RDF

@prefix ausplots: <http://linked.data.gov.au/dataset/ausplots/> .
@prefix ausplots-cv: <http://linked.data.gov.au/def/ausplots-cv/> .
@prefix data: <http://linked.data.gov.au/def/datatype/> .
@prefix dct: <http://purl.org/dc/terms/> .
@prefix plot: <http://linked.data.gov.au/def/plot/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix sosa: <http://www.w3.org/ns/sosa/> .
@prefix ssn-ext: <http://www.w3.org/ns/ssn/ext/> .
@prefix tern-ssn: <https://w3id.org/tern/ontologies/ssn/> .
@prefix time: <http://www.w3.org/2006/time#> .

ausplots:s-oc-53471 a ssn-ext:ObservationCollection ;
    rdfs:label "AUSPLOTS Rangelands 'Soil' Observation Collection for SiteVisit: '53471'" ;
    plot:wasSubActivityOf ausplots:sv-53471 ;
    dct:type ausplots-cv:68eec465-a91e-49a8-9265-6da7ef8ad284 ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-59890 ] ;
    ssn-ext:hasMember ausplots:s-oc-53471-ccfl-103854-o-1,
        ausplots:s-oc-53471-ccfl-103855-o-1,
        ausplots:s-oc-53471-ccfl-103856-o-1,
        ausplots:s-oc-53471-ccfl-103857-o-1,
        ausplots:s-oc-53471-ccfl-103858-o-1,
        ausplots:s-oc-53471-ccfl-103859-o-1,
        ausplots:s-oc-53471-ccfl-103860-o-1,
        ausplots:s-oc-53471-ccfl-103861-o-1,
        ausplots:s-oc-53471-ccfl-103862-o-1 .

ausplots:s-oc-58629 a ssn-ext:ObservationCollection ;
    rdfs:label "AUSPLOTS Rangelands 'Soil' Observation Collection for SiteVisit: '58629'" ;
    plot:wasSubActivityOf ausplots:sv-58629 ;
    dct:type ausplots-cv:68eec465-a91e-49a8-9265-6da7ef8ad284 ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-61306 ] ;
    ssn-ext:hasMember ausplots:s-oc-58629-ccfl-111795-o-1,
        ausplots:s-oc-58629-ccfl-111796-o-1,
        ausplots:s-oc-58629-ccfl-111797-o-1,
        ausplots:s-oc-58629-ccfl-111798-o-1 .

ausplots:s-oc-53471-ccfl-103854-o-1 a sosa:Observation ;
    rdfs:label "Site Visit: '53471' | Soil Characterisation Coarse Fragments Lithology: '103854' | Observation 1 (LITHOLOGY_CODE)" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-59890 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value ausplots-cv:f3159eee-d8ae-4e5f-a7cf-de171d58e859 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value ausplots-cv:8fe133e4-8534-4184-bc9c-0163a8860db8 ] ;
    sosa:phenomenonTime ausplots:t2013-06-13-h15-m1-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 ] ;
    tern-ssn:collectedSample ausplots:s-oc-53471-sc-118632-s-1 .

ausplots:s-oc-53471-ccfl-103855-o-1 a sosa:Observation ;
    rdfs:label "Site Visit: '53471' | Soil Characterisation Coarse Fragments Lithology: '103855' | Observation 1 (LITHOLOGY_CODE)" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-59890 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value ausplots-cv:f3159eee-d8ae-4e5f-a7cf-de171d58e859 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value ausplots-cv:8fe133e4-8534-4184-bc9c-0163a8860db8 ] ;
    sosa:phenomenonTime ausplots:t2013-06-13-h15-m1-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 ] ;
    tern-ssn:collectedSample ausplots:s-oc-53471-sc-118633-s-1 .

ausplots:s-oc-53471-ccfl-103856-o-1 a sosa:Observation ;
    rdfs:label "Site Visit: '53471' | Soil Characterisation Coarse Fragments Lithology: '103856' | Observation 1 (LITHOLOGY_CODE)" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-59890 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value ausplots-cv:f3159eee-d8ae-4e5f-a7cf-de171d58e859 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value ausplots-cv:8fe133e4-8534-4184-bc9c-0163a8860db8 ] ;
    sosa:phenomenonTime ausplots:t2013-06-13-h15-m1-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 ] ;
    tern-ssn:collectedSample ausplots:s-oc-53471-sc-118634-s-1 .

ausplots:s-oc-53471-ccfl-103857-o-1 a sosa:Observation ;
    rdfs:label "Site Visit: '53471' | Soil Characterisation Coarse Fragments Lithology: '103857' | Observation 1 (LITHOLOGY_CODE)" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-59890 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value ausplots-cv:f3159eee-d8ae-4e5f-a7cf-de171d58e859 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value ausplots-cv:8fe133e4-8534-4184-bc9c-0163a8860db8 ] ;
    sosa:phenomenonTime ausplots:t2013-06-13-h15-m1-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 ] ;
    tern-ssn:collectedSample ausplots:s-oc-53471-sc-118635-s-1 .

ausplots:s-oc-53471-ccfl-103858-o-1 a sosa:Observation ;
    rdfs:label "Site Visit: '53471' | Soil Characterisation Coarse Fragments Lithology: '103858' | Observation 1 (LITHOLOGY_CODE)" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-59890 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value ausplots-cv:f3159eee-d8ae-4e5f-a7cf-de171d58e859 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value ausplots-cv:8fe133e4-8534-4184-bc9c-0163a8860db8 ] ;
    sosa:phenomenonTime ausplots:t2013-06-13-h15-m1-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 ] ;
    tern-ssn:collectedSample ausplots:s-oc-53471-sc-118636-s-1 .

ausplots:s-oc-53471-ccfl-103859-o-1 a sosa:Observation ;
    rdfs:label "Site Visit: '53471' | Soil Characterisation Coarse Fragments Lithology: '103859' | Observation 1 (LITHOLOGY_CODE)" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-59890 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value ausplots-cv:f3159eee-d8ae-4e5f-a7cf-de171d58e859 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value ausplots-cv:8fe133e4-8534-4184-bc9c-0163a8860db8 ] ;
    sosa:phenomenonTime ausplots:t2013-06-13-h15-m1-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 ] ;
    tern-ssn:collectedSample ausplots:s-oc-53471-sc-118637-s-1 .

ausplots:s-oc-53471-ccfl-103860-o-1 a sosa:Observation ;
    rdfs:label "Site Visit: '53471' | Soil Characterisation Coarse Fragments Lithology: '103860' | Observation 1 (LITHOLOGY_CODE)" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-59890 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value ausplots-cv:f3159eee-d8ae-4e5f-a7cf-de171d58e859 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value ausplots-cv:8fe133e4-8534-4184-bc9c-0163a8860db8 ] ;
    sosa:phenomenonTime ausplots:t2013-06-13-h15-m1-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 ] ;
    tern-ssn:collectedSample ausplots:s-oc-53471-sc-118638-s-1 .

ausplots:s-oc-53471-ccfl-103861-o-1 a sosa:Observation ;
    rdfs:label "Site Visit: '53471' | Soil Characterisation Coarse Fragments Lithology: '103861' | Observation 1 (LITHOLOGY_CODE)" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-59890 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value ausplots-cv:f3159eee-d8ae-4e5f-a7cf-de171d58e859 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value ausplots-cv:8fe133e4-8534-4184-bc9c-0163a8860db8 ] ;
    sosa:phenomenonTime ausplots:t2013-06-13-h15-m1-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 ] ;
    tern-ssn:collectedSample ausplots:s-oc-53471-sc-118639-s-1 .

ausplots:s-oc-53471-ccfl-103862-o-1 a sosa:Observation ;
    rdfs:label "Site Visit: '53471' | Soil Characterisation Coarse Fragments Lithology: '103862' | Observation 1 (LITHOLOGY_CODE)" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-59890 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value ausplots-cv:f3159eee-d8ae-4e5f-a7cf-de171d58e859 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value ausplots-cv:8fe133e4-8534-4184-bc9c-0163a8860db8 ] ;
    sosa:phenomenonTime ausplots:t2013-06-13-h15-m1-s0 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 ] ;
    tern-ssn:collectedSample ausplots:s-oc-53471-sc-118640-s-1 .

ausplots:s-oc-58629-ccfl-111795-o-1 a sosa:Observation ;
    rdfs:label "Site Visit: '58629' | Soil Characterisation Coarse Fragments Lithology: '111795' | Observation 1 (LITHOLOGY_CODE)" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-61306 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value ausplots-cv:6016e4c0-756a-47e6-bda2-b8683a91df54 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value ausplots-cv:8fe133e4-8534-4184-bc9c-0163a8860db8 ] ;
    sosa:phenomenonTime ausplots:t2018-10-30-h16-m35-s2 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 ] ;
    tern-ssn:collectedSample ausplots:s-oc-58629-sc-127009-s-1 .

ausplots:s-oc-58629-ccfl-111796-o-1 a sosa:Observation ;
    rdfs:label "Site Visit: '58629' | Soil Characterisation Coarse Fragments Lithology: '111796' | Observation 1 (LITHOLOGY_CODE)" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-61306 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value ausplots-cv:6016e4c0-756a-47e6-bda2-b8683a91df54 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value ausplots-cv:8fe133e4-8534-4184-bc9c-0163a8860db8 ] ;
    sosa:phenomenonTime ausplots:t2018-10-30-h16-m35-s2 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 ] ;
    tern-ssn:collectedSample ausplots:s-oc-58629-sc-127010-s-1 .

ausplots:s-oc-58629-ccfl-111797-o-1 a sosa:Observation ;
    rdfs:label "Site Visit: '58629' | Soil Characterisation Coarse Fragments Lithology: '111797' | Observation 1 (LITHOLOGY_CODE)" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-61306 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value ausplots-cv:6016e4c0-756a-47e6-bda2-b8683a91df54 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value ausplots-cv:8fe133e4-8534-4184-bc9c-0163a8860db8 ] ;
    sosa:phenomenonTime ausplots:t2018-10-30-h16-m35-s2 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 ] ;
    tern-ssn:collectedSample ausplots:s-oc-58629-sc-127011-s-1 .

ausplots:s-oc-58629-ccfl-111798-o-1 a sosa:Observation ;
    rdfs:label "Site Visit: '58629' | Soil Characterisation Coarse Fragments Lithology: '111798' | Observation 1 (LITHOLOGY_CODE)" ;
    sosa:hasFeatureOfInterest [ sosa:isSampleOf ausplots:site-61306 ] ;
    sosa:hasResult [ a data:Concept ;
            data:value ausplots-cv:6016e4c0-756a-47e6-bda2-b8683a91df54 ] ;
    sosa:observedProperty [ a sosa:ObservableProperty ;
            data:value ausplots-cv:8fe133e4-8534-4184-bc9c-0163a8860db8 ] ;
    sosa:phenomenonTime ausplots:t2018-10-30-h16-m35-s2 ;
    sosa:usedProcedure [ a sosa:Procedure ;
            data:value ausplots-cv:b49db586-17e6-4a6b-8a48-167e2ad9c577 ] ;
    tern-ssn:collectedSample ausplots:s-oc-58629-sc-127012-s-1 .

ausplots:t2018-10-30-h16-m35-s2 a time:Instant ;
    time:inXSDDateTime "t2018-10-30-h16-m35-s2" .

ausplots:t2013-06-13-h15-m1-s0 a time:Instant ;
    time:inXSDDateTime "t2013-06-13-h15-m1-s0" .
AusPlots Rangelands Dataset Integration

Characterisation Coarse Frags Lithology

Input

Interpretation in TERN Plot Ontology

Mapping Table

Example Row

Example RDF
