Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Status
colourYellow
titlereview 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

Status
colourYellow
titlereview 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

Status
colourYellow
titlereview 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

Status
colourYellow
titleTERN:
Land Surface

Status
colourGreen
titleAusplots:
Land Surface

erosion_abundance

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

Status
colourYellow
titleTERN:
Land Surface

Status
colourGreen
titleAusplots:
Land Surface

erosion_state

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

Status
colourYellow
titleTERN:
Land Surface

Status
colourGreen
titleAusplots:
Land Surface

microrelief

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

Status
colourYellow
titleTERN:
Land Surface

Status
colourGreen
titleAusplots:
Land Surface

drainage_type

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

Status
colourYellow
titleTERN:
Land Surface

Status
colourGreen
titleAusplots:
Land Surface

disturbance

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

Status
colourYellow
titleTERN:
Land Surface

Status
colourGreen
titleAusplots:
Land Surface

climatic_condition

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

Status
colourYellow
titleTERN:
Location

Status
colourGreen
titleAUSPLOTS:
Site and location

vegetation_condition

ssn-ext:hasMember, sosa:hasResult

Member of ssn-ext:ObservationCollection with dct:type

Status
colourYellow
titleTERN:
Location

Status
colourGreen
titleAUSPLOTS:
Site and location

observer_veg

Domain: ssn-ext:ObservationCollection with dct:type Plant species

Range:

Status
colourRed
titletodo
- 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:

Status
colourRed
titletodo
- 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

Status
colourYellow
titlereview 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

Status
colourYellow
titleTERN:
Location

Status
colourGreen
titleAUSPLOTS:
Site and location

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

Member of

Status
colourYellow
titlereview required
ssn-ext:ObservationCollection with dct:type Site?

  • sosa:observedProperty:

    Status
    colourRed
    titletodo

  • TS: not sure if this is an oP, could it just be an identifier? what are the actual values?

  • sosa:usedProcedure:

    Status
    colourRed
    titletodo

  • sosa:hasResult:

    • rdf:type: data:Text

    • data:value: site_visit_photo_name

The site’s photo name. Assuming it is uniqueNot 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.

...