Input

Source: AUSPLOTS_RANGELANDS.SITE_LOCATION_VISIT

Intepretation in TERN Plot Ontology

Encoding each row in RDF requires

…

Mapping Table

Source Column	Destination RDF Predicate	Comments

Source Column	Destination RDF Predicate	Comments
`site_location_visit_id`	`dct:identifier`, `rdfs:label`
`site_location_id`	`sosa:hasFeatureOfInterest`	Domain: `plot:SiteVisit` Range: `plot:Site`
`visit_start_date`	`prov:startedAtTime`	`xsd:dateTime`
`visit_end_date`	`prov:endedAtTime`	`xsd:dateTime`
`photopoints_exist`		review required Tina: Not useful. A boolean to tell if photos exist for the plot site. May be useful to have in the future.
`leaf_area_index_exists`		review required Tina: Not useful. LAI is useful for some analyses work. May be useful to have in the future but the data is not currently recorded in the database. It is in Excel spreadsheets in TERN AusPlots Adelaide.
`basal_wedge_has_been_collected`		review required Tina: Not useful. Need to confirm if this is useful or not.
`visit_notes`	`rdfs:comment`	`xsd:string`
`location_description`	`dct:description`	`xsd:string`
`erosion_type`	`ssn-ext:hasMember`, `sosa:hasResult`	Member of `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface Ausplots: Land Surface `sosa:observedProperty`: Accelerated Erosion Type `sosa:usedProcedure`: Plot Description Method `sosa:hasResult`: value from collection Erosion Type
`erosion_abundance`	`ssn-ext:hasMember`, `sosa:hasResult`	Member of `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface Ausplots: Land Surface `sosa:observedProperty`: Erosion Extent `sosa:usedProcedure`: Plot Description Method `sosa:hasResult`: value from collection Erosion Abundance
`erosion_state`	`ssn-ext:hasMember`, `sosa:hasResult`	Member of `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface Ausplots: Land Surface `sosa:observedProperty`: State of erosion `sosa:usedProcedure`: Plot Description Method `sosa:hasResult`: value from collection Erosion State
`microrelief`	`ssn-ext:hasMember`, `sosa:hasResult`	Member of `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface Ausplots: Land Surface `sosa:observedProperty`: Microrelief `sosa:usedProcedure`: Plot Description Method `sosa:hasResult`: value from collection Microrelief
`drainage_type`	`ssn-ext:hasMember`, `sosa:hasResult`	Member of `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface Ausplots: Land Surface `sosa:observedProperty`: Drainage Type `sosa:usedProcedure`: Plot Description Method `sosa:hasResult`: value from collection Drainage
`disturbance`	`ssn-ext:hasMember`, `sosa:hasResult`	Member of `ssn-ext:ObservationCollection` with `dct:type` TERN: Land Surface Ausplots: Land Surface `sosa:observedProperty`: Disturbance Type at Site `sosa:usedProcedure`: Plot Description Method `sosa:hasResult`: value from collection Disturbance
`climatic_condition`	`ssn-ext:hasMember`, `sosa:hasResult`	Member of `ssn-ext:ObservationCollection` with `dct:type` TERN: Location AUSPLOTS: Site and location `sosa:observedProperty`: Climatic Condition `sosa:usedProcedure`: Plot Description Method `sosa:hasResult`: `rdf:type`: `data:Text` `data:value`: `climatic_condition`
`vegetation_condition`	`ssn-ext:hasMember`, `sosa:hasResult`	Member of `ssn-ext:ObservationCollection` with `dct:type` TERN: Location AUSPLOTS: Site and location `sosa:observedProperty`: Vegetation Condition `sosa:usedProcedure`: Plot Description Method `sosa:hasResult`: `rdf:type`: `data:Text` `data:value`: `vegetation_condition`
`observer_veg`		Domain: `ssn-ext:ObservationCollection` with `dct:type` Plant species Range: todo - create the person record in https://bitbucket.org/terndatateam/org-and-person/src/master/ Looks like this is the value of who the observer was for the collected vegetation data. Do we need to collect the observer information? We didn’t for CORVEG. Tina: Double check with Guru if we capture this.
`observer_soil`		Domain: `ssn-ext:ObservationCollection` with `dct:type` Soil Range: todo - create the person record in https://bitbucket.org/terndatateam/org-and-person/src/master/ Looks like this is the value of who the observer was for the collected soil data. Do we need to collect the observer information? We didn’t for CORVEG. Tina: Double check with Guru if we capture this.
`described_by`		review required Looks like this is the value of who the observer was that described something. Do we need to collect the observer information? We didn’t for CORVEG. Tina: Double check with Guru if we capture this.
`a_s_c`		Not captured by TERN Plot Ontology. Value is a text. Example: 3TEIOAOARBHKK-, 3CACQCZCPAGLLU, NC, etc. Is it some kind of code? The serial number of the instrument used? What is `a_s_c`? This is the Australian Soil Classification. May not be useful as quoted by Emrys and Andrew. See page 225 of the Yellow Book for the codes. The values here also contain numbers, which I have no idea what it is. Andrew didn’t know how the codes were formulated. Data is no longer recorded since 2013.
`pit_marker_easting`		Model the pit markers as part of a sub-site to the main plot site. The pit markers are to be converted from UTM to lat/long as `geo:Point`. This is the pit markers for the soil pit outside the main plot site used for soil characterisation. This is required. The soil pit is outside of the main plot site because they do not want to dig a massive whole inside the actual site. This is created to collect soil characterisations such as soil chemistry, etc. Modelled as sub-site with Location (Converted to lat/long)
`pit_marker_northing`		Modelled as sub-site with Location (Converted to lat/long)
`pit_marker_mga_zones`		Modelled as sub-site with Location (Converted to lat/long)
`pit_marker_datum`		Modelled as sub-site with Location (Comment in subsite)
`pit_marker_location_method`		Modelled as sub-site with Location (Comment in subsite)
`soil_observation_type`		Member of `ssn-ext:ObservationCollection` with `dct:type` TERN: Location AUSPLOTS: Site and location `sosa:observedProperty`: Soil Observation Type `sosa:usedProcedure`: Soil observation method `sosa:hasResult`: value from collection Soil Observation Type
`ok_to_publish`		Not captured by TERN Plot Ontology. We only check the value of this and capture any records that are `true`.
`sample_location_comment`	`rdfs:comment`	`xsd:string`
`site_visit_photo_name`		Not captured by TERN Plot Ontology. The site’s photo name. We already have the table ‘photographs’ that records the filename as the SITE_NAME. This is following the AEKOS procedure with images and filenames.
`distance_to_nearest_community`		Add to comment.
`distance_to_nearest_infrastructure`		Add to comment.
`comment_on_distance_to_community`		Add to comment.
`comment_on_distance_to_infrastructure`		Add to comment.

Example Row

SITE_LOCATION_VISIT_ID	SITE_LOCATION_ID	VISIT_START_DATE	VISIT_END_DATE	PHOTOPOINTS_EXISTS	LEAF_AREA_INDEX_EXISTS	BASAL_WEDGE_HAS_BEEN_COLLECTED	VISIT_NOTES	LOCATION_DESCRIPTION	EROSION_TYPE	EROSION_ABUNDANCE	EROSION_STATE	MICRORELIEF	DRAINAGE_TYPE	DISTURBANCE	CLIMATIC_CONDITION

SITE_LOCATION_VISIT_ID	SITE_LOCATION_ID	VISIT_START_DATE	VISIT_END_DATE	PHOTOPOINTS_EXISTS	LEAF_AREA_INDEX_EXISTS	BASAL_WEDGE_HAS_BEEN_COLLECTED	VISIT_NOTES	LOCATION_DESCRIPTION	EROSION_TYPE	EROSION_ABUNDANCE	EROSION_STATE	MICRORELIEF	DRAINAGE_TYPE	DISTURBANCE	CLIMATIC_CONDITION
53471	59890	2013-06-13 15:01:00	2013-06-13 15:01:00	TRUE	TRUE	TRUE	Point Intercept incomplete- transect East5 to West5 was not finished. All rest are ok.	Blackbraes National Park 18kms northwest of homestead. Open woodland of Eucalyptus crebra with grassy understorey of Heteropogon contortus and Themeda triandra on metamorphosed sediments on a slope.	NC	0	NC	B	4	1L	WET

VEGETATION_CONDITION	OBSERVER_VEG	OBSERVER_SOIL	DESCRIBED_BY	A_S_C	PIT_MARKER_EASTING	PIT_MARKER_NORTHING	PIT_MARKER_MGA_ZONES	PIT_MARKER_DATUM	PIT_MARKER_LOCATION_METHOD	SOIL_OBSERVATION_TYPE	OK_TO_PUBLISH	SAMPLE_LOCATION_COMMENT	SITE_VISIT_PHOTO_NAME	DISTANCE_TO_NEAREST_COMMUNITY	DISTANCE_TO_NEAREST_INFRASTRUCTURE	COMMENT_ON_DISTANCE_TO_COMMUNITY	COMMENT_ON_DISTANCE_TO_INFRASTRUCTURE

VEGETATION_CONDITION	OBSERVER_VEG	OBSERVER_SOIL	DESCRIBED_BY	A_S_C	PIT_MARKER_EASTING	PIT_MARKER_NORTHING	PIT_MARKER_MGA_ZONES	PIT_MARKER_DATUM	PIT_MARKER_LOCATION_METHOD	SOIL_OBSERVATION_TYPE	OK_TO_PUBLISH	SAMPLE_LOCATION_COMMENT	SITE_VISIT_PHOTO_NAME	DISTANCE_TO_NEAREST_COMMUNITY	DISTANCE_TO_NEAREST_INFRASTRUCTURE	COMMENT_ON_DISTANCE_TO_COMMUNITY	COMMENT_ON_DISTANCE_TO_INFRASTRUCTURE
AVG	3	13	3	NC	202743.0	7851366.0	55	WGS84	GPS	PA	TRUE	Standard soil, soil metagenomic, vegetation vouchers and genetic/isotope samples are available for use by researchers. To find out how to access AusPlots' samples, contact: tern.adelaide@adelaide.edu.au	QDAEIU0003_SIM_.JPG	50	220	Community confined to plot	Old track 170m north east of plot

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:d-oc-53471 a ssn-ext:ObservationCollection ;
    rdfs:label "AUSPLOTS Rangelands 'Disturbance' Observation Collection for SiteVisit: '53471'" ;
    plot:wasSubActivityOf ausplots:sv-53471 ;
    dct:identifier 53471 ;
    dct:type <http://linked.data.gov.au/def/ausplots-cv/8dde4847-d2cb-4f97-8687-127cf09737cf> ;
    ssn-ext:hasMember ausplots:d-oc-53471-sv-53471-o-1 .

ausplots:ls-oc-53471 a ssn-ext:ObservationCollection ;
    rdfs:label "AUSPLOTS Rangelands 'Land Surface' Observation Collection for SiteVisit: '53471'" ;
    plot:wasSubActivityOf ausplots:sv-53471 ;
    dct:identifier 53471 ;
    dct:type ausplots-cv:cc209eca-94bd-48fe-be9d-af3a8efbfa11 ;
    ssn-ext:hasMember ausplots:ls-oc-53471-sv-53471-o-1,
        ausplots:ls-oc-53471-sv-53471-o-2,
        ausplots:ls-oc-53471-sv-53471-o-3,
        ausplots:ls-oc-53471-sv-53471-o-4,
        ausplots:ls-oc-53471-sv-53471-o-5 .

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> ;
    ssn-ext:hasMember ausplots:s-oc-53471-sv-53471-o-1 .

ausplots:sl-oc-53471 a ssn-ext:ObservationCollection ;
    rdfs:label "AUSPLOTS Rangelands 'Site and Location' Observation Collection for SiteVisit: '53471'" ;
    plot:wasSubActivityOf ausplots:sv-53471 ;
    dct:identifier 53471 ;
    dct:type <http://linked.data.gov.au/def/ausplots-cv/41ebcc66-d337-4e23-b310-7b2747391f47> ;
    ssn-ext:hasMember ausplots:sl-oc-53471-sv-53471-o-1,
        ausplots:sl-oc-53471-sv-53471-o-2,
        ausplots:sl-oc-53471-sv-53471-o-3,
        ausplots:sl-oc-53471-sv-53471-o-4,
        ausplots:sl-oc-53471-sv-53471-o-5 .

ausplots:v-oc-53471 a ssn-ext:ObservationCollection ;
    rdfs:label "AUSPLOTS Rangelands 'Vegetation' Observation Collection for SiteVisit: '53471'" ;
    plot:wasSubActivityOf ausplots:sv-53471 ;
    dct:identifier 53471 ;
    dct:type <http://linked.data.gov.au/def/ausplots-cv/22a69fd5-c072-4e0f-ad93-f7f18d05faf5> ;
    ssn-ext:hasMember ausplots:v-oc-53471-sv-53471-o-1 .

ausplots:d-oc-53471-sv-53471-o-1 a sosa:Observation ;
    rdfs:label "SiteVisit: '53471' | Site Location Visit: '53471' | Observation 1 (DISTURBANCE)" ;
    sosa:hasResult <http://linked.data.gov.au/def/ausplots-cv/09affc06-acd5-494b-907d-dc733bbb2fab> ;
    sosa:observedProperty <http://linked.data.gov.au/def/ausplots-cv/9be76ebc-fa0a-45c9-bcc9-5270ff7cca27> ;
    sosa:usedProcedure ausplots-cv:cd3ceed2-a820-472b-aace-6a52469cc9cb .

ausplots:ls-oc-53471-sv-53471-o-1 a sosa:Observation ;
    rdfs:label "SiteVisit: '53471' | Site Location Visit: '53471' | Observation 1 (EROSION_TYPE)" ;
    sosa:hasResult ausplots-cv:f3159eee-d8ae-4e5f-a7cf-de171d58e859 ;
    sosa:observedProperty <http://linked.data.gov.au/def/ausplots-cv/8d3944f0-a3c1-4059-ba1d-70a63ff2347d> ;
    sosa:usedProcedure ausplots-cv:cd3ceed2-a820-472b-aace-6a52469cc9cb .

ausplots:ls-oc-53471-sv-53471-o-2 a sosa:Observation ;
    rdfs:label "SiteVisit: '53471' | Site Location Visit: '53471' | Observation 2 (EROSION_ABUNDANCE)" ;
    sosa:hasResult <http://linked.data.gov.au/def/ausplots-cv/7fa3bc46-82fd-4035-b5ba-4f39d2e87bd9> ;
    sosa:observedProperty ausplots-cv:af8da351-9274-4f72-92ed-2285fbaed2ba ;
    sosa:usedProcedure ausplots-cv:cd3ceed2-a820-472b-aace-6a52469cc9cb .

ausplots:ls-oc-53471-sv-53471-o-3 a sosa:Observation ;
    rdfs:label "SiteVisit: '53471' | Site Location Visit: '53471' | Observation 3 (EROSION_STATE)" ;
    sosa:hasResult ausplots-cv:f3159eee-d8ae-4e5f-a7cf-de171d58e859 ;
    sosa:observedProperty <http://linked.data.gov.au/def/ausplots-cv/310de8de-240d-46af-8a22-5192c24e050a> ;
    sosa:usedProcedure ausplots-cv:cd3ceed2-a820-472b-aace-6a52469cc9cb .

ausplots:ls-oc-53471-sv-53471-o-4 a sosa:Observation ;
    rdfs:label "SiteVisit: '53471' | Site Location Visit: '53471' | Observation 4 (MICRORELIEF)" ;
    sosa:hasResult ausplots-cv:f36071ae-c765-4bd7-a1ec-7ba2d1b58d33 ;
    sosa:observedProperty <http://linked.data.gov.au/def/ausplots-cv/76f90a63-b160-40c5-916e-02983f2bc096> ;
    sosa:usedProcedure ausplots-cv:cd3ceed2-a820-472b-aace-6a52469cc9cb .

ausplots:ls-oc-53471-sv-53471-o-5 a sosa:Observation ;
    rdfs:label "SiteVisit: '53471' | Site Location Visit: '53471' | Observation 5 (DRAINAGE_TYPE)" ;
    sosa:hasResult <http://linked.data.gov.au/def/ausplots-cv/48ab393f-811f-4683-9d55-fa4b28de03d4> ;
    sosa:observedProperty <http://linked.data.gov.au/def/ausplots-cv/76f90a63-b160-40c5-916e-02983f2bc096> ;
    sosa:usedProcedure ausplots-cv:cd3ceed2-a820-472b-aace-6a52469cc9cb .

ausplots:s-oc-53471-sv-53471-o-1 a sosa:Observation ;
    rdfs:label "SiteVisit: '53471' | Site Location Visit: '53471' | Observation 1 (SOIL_OBSERVATION_TYPE)" ;
    sosa:hasResult <http://linked.data.gov.au/def/ausplots-cv/8b12f88d-337a-46ab-8294-4fff9cf1f35a> ;
    sosa:observedProperty <http://linked.data.gov.au/def/ausplots-cv/2374823f-e8f3-4dc2-80e0-5bf341a95bee> ;
    sosa:usedProcedure <http://linked.data.gov.au/def/ausplots-cv/6d5764b3-6a0c-4937-88f1-11fe280c6524> .

ausplots:sl-oc-53471-sv-53471-o-1 a sosa:Observation ;
    rdfs:label "SiteVisit: '53471' | Site Location Visit: '53471' | Observation 1 (CLIMATIC_CONDITION)" ;
    sosa:hasResult [ a data:Text ;
            data:value "WET" ] ;
    sosa:observedProperty ausplots-cv:cde9be44-f208-4411-9f16-9dab96d4c425 ;
    sosa:usedProcedure ausplots-cv:cd3ceed2-a820-472b-aace-6a52469cc9cb .

ausplots:v-oc-53471-sv-53471-o-1 a sosa:Observation ;
    rdfs:label "SiteVisit: '53471' | Site Location Visit: '53471' | Observation 1 (VEGETATION_CONDITION)" ;
    sosa:hasResult [ a data:Text ;
            data:value "AVG" ] ;
    sosa:observedProperty ausplots-cv:ff69c254-e549-45e8-a320-e28ead5092c8 ;
    sosa:usedProcedure ausplots-cv:cd3ceed2-a820-472b-aace-6a52469cc9cb .

ausplots:sv-53471 a plot:SiteVisit ;
    rdfs:label "AUSPLOTS Rangelands SiteVisit '53471'" ;
    dct:description "Blackbraes National Park 18kms northwest of homestead. Open woodland of Eucalyptus crebra with grassy understorey of Heteropogon contortus and Themeda triandra on metamorphosed sediments on a slope." ;
    dct:identifier 53471 ;
    rdfs:comment "comment_on_distance_to_community: Community confined to plot",
        "comment_on_distance_to_infrastructure: Old track 170m north east of plot",
        "distance_to_nearest_community: 50",
        "distance_to_nearest_infrastructure: 220",
        "sample_location_comment: Standard soil, soil metagenomic, vegetation vouchers and genetic/isotope samples are available for use by researchers. To find out how to access AusPlots' samples, contact: tern.adelaide@adelaide.edu.au",
        "visit_notes: Point Intercept incomplete- transect East5 to West5 was not finished. All rest are ok." ;
    prov:endedAtTime "2013-06-13T15:01:00"^^xsd:dateTime ;
    prov:startedAtTime "2013-06-13T15:01:00"^^xsd:dateTime ;
    sosa:hasFeatureOfInterest ausplots:site-59890 .
    
ausplots:site-58053-pit a plot:Site ;
    rdfs:label "PIT Subsite | SiteVisit: '58053' | Site: '60341'" ;
    dct:identifier "58053-pit" ;
    dct:isPartOf ausplots:site-60341 .

ausplots:site-loc-53471-pit a plot:Location ;
    rdfs:label "Location site-loc-53471-pit" ;
    plot-x:isLocationOf ausplots:site-53471-pit ;
    dct:description "Location from PIT SubSite converted from UTM (zone=55, easting=202743.00000000, northing=7851366.00000000)" ;
    dct:identifier "site-loc-53471-pit" ;
    geosparql:hasGeometry [ a geo:Point ;
            geo:lat -19.409986779373885 ;
            geo:long 144.16959958258258 ] .