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 |
lower_depth
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL |
horizon
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type 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 |
texture_qualifier
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL |
texture_modifier
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL |
colour_when_moist
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type 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 | 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 |
mottles_abundance
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL |
mottles_size
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL |
segregations_abundance
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL |
segregations_size
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL |
segregations_nature
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL |
segregations_form
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type 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 |
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 |
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 |
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 |
pedality_grade
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL |
ph
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL |
ec
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL TS - this is Soil Electrical conductivity, Electrical conductivity (EC) is the ability of a material to transmit (conduct) an electrical current and is commonly expressed in units of milliSiemens per meter (mS/m). Soil EC measurements may also be reported in units of , which is equal to the reading in mS/m divided by 100. Check with Ausplots which units they are using. | Status |
|---|
| colour | Yellow |
|---|
| title | review required |
|---|
|
- check what unit with AusPlots guys. |
effervescence
| ssn-ext:hasMember, sosa:hasResult
| Member of ssn-ext:ObservationCollection with dct:type SOIL |