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 |
layer_barcode
| sosa:hasSample
| Domain: ssn-ext:ObservationCollection with dct:type SOIL Range: sosa:Sample Create sosa:Sampling instance |
upper_depth
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
lower_depth
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
horizon
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL sosa:observedProperty : Soil Horizon
sosa:usedProcedure : Soil ProfileBlue Soil Status |
---|
colour | Yellow |
---|
title | review required |
---|
| - Is this to another look-up table? It is not linked in the schema. TS double check with Ausplots crew, should have details about horizon, see page 49 of manual The manual quotes the Yellow Book pages 148-158. It’s the HORIZONS chapter/section and each classification has a code which corresponds to the text value in this column. Need to create the controlled vocabulary for this manually as there is no look-up table. |
texture_grade
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
texture_qualifier
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
texture_modifier
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL sosa:observedProperty : Soil Texture Modifier Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
colour_when_moist
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil Status |
---|
colour | Yellow |
---|
title | review required |
---|
| - Values look like a mixture of codes and moisture colour values. TS- colour codes are on page 74 of manual, do they match data values? EC - They don’t match exactly. It’s a string that contains codes for the. colour but there are also numerical values. |
colour_when_dry
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil Status |
---|
colour | Yellow |
---|
title | review required |
---|
| - Values look like a mixture of codes and moisture colour values. TS- colour codes are on page 74 of manual, do they match data values? EC - They don’t match exactly. It’s a string that contains codes for the. colour but there are also numerical values. |
mottles_colour
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL sosa: Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
mottles_abundance
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
mottles_size
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
segregations_abundance
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
segregations_size
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
segregations_nature
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL:ObservationCollection with dct:type Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
segregations_form
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
comments
| rdfs:comments
| |
collected_by
| prov:wasAttributedTo
| Value from look-up table lut_observer rdf:type : prov:Person , sdo:Person
sdo:givenName : First name
sdo:familyName : Last name
prov:actedOnBehalfOf :
|
smallest_size_1
| | Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
smallest_size_2
| | Not captured by TERN Plot Ontology. All values are null. |
next_size_1
| | Status |
---|
colour | Yellow |
---|
title | review required |
---|
|
Possibly also linking to lut_structure_size - need to confirm. Foreign keys are convincing. |
next_size_2
| | Not captured by TERN Plot Ontology. All values are null. |
smallest_size_type_1
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL:ObservationCollection with dct:type Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
smallest_size_type_2
| ssn-ext:hasMember , sosa:hasResult
| Not captured by TERN Plot Ontology. |
next_size_type_1
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
next_size_type_2
| ssn-ext:hasMember , sosa:hasResult
| Not captured by TERN Plot Ontology. |
pedality_fabric
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
pedality_grade
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL with dct:type Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
ph
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
ec
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |
effervescence
| ssn-ext:hasMember , sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL Soil Profile Status |
---|
colour | Green |
---|
title | AUSPLOTS: |
---|
| Soil |