Review OGroups mapping
TERN OBS GROUP | AUSPLOTS OBS GROUP | OGROUP BEFORE REVIEW | YB Chapter | DB Table | Column | Type | Comments |
Vegetation | basal_area | basal_area | Oproperty | Missing QUDT unit | |||
Vegetation | basal_area | basal_area_factor | SSN hasInput of method |
| |||
Vegetation | basal_area | hits | Oproperty |
| |||
Vegetation | basal_area | id | ID |
| |||
Vegetation | basal_area | point_id |
| Link to Site_Location_Point?? | |||
Vegetation | basal_area | site_location_visit_id | ID |
| |||
Vegetation | basal_area | veg_barcode | Sample |
| |||
Vegetation | genetic_vouchers | genetic_barcode_analysis_url | NA | NC | |||
Vegetation | genetic_vouchers | primary_gen_barcode | Sample |
| |||
Vegetation | genetic_vouchers | sample_for_dna | Comment |
| |||
Vegetation | genetic_vouchers | sample_for_isotope | NA | NC | |||
Vegetation | genetic_vouchers | secondary_gen_barcode_1 | Sample |
| |||
Vegetation | genetic_vouchers | secondary_gen_barcode_2 | Sample |
| |||
Vegetation | genetic_vouchers | secondary_gen_barcode_3 | Sample |
| |||
Vegetation | genetic_vouchers | secondary_gen_barcode_4 | Sample |
| |||
Vegetation | genetic_vouchers | site_location_visit_id | ID |
| |||
Vegetation | genetic_vouchers | tea_bag_is_synthetic | NA | NC | |||
Vegetation | genetic_vouchers | veg_barcode | Sample |
| |||
Vegetation | herbarium_determination | determination_date | dwct:Taxon |
| |||
Vegetation | herbarium_determination | determiner | dwct:Taxon |
| |||
Vegetation | herbarium_determination | determiner_comment | dwct:Taxon |
| |||
Vegetation | herbarium_determination | herbarium_determination | dwct:Taxon |
| |||
Vegetation | herbarium_determination | is_uncertain_determination | dwct:Taxon |
| |||
Vegetation | herbarium_determination | specimen_stored_at | dwct:Taxon |
| |||
Vegetation | herbarium_determination | state_accession_number | dwct:Taxon |
| |||
Vegetation | herbarium_determination | veg_barcode | Sample |
| |||
Vegetation | point_intercept | dead | Oproperty |
| |||
Vegetation | point_intercept | growth_form | Oproperty |
| |||
Vegetation | point_intercept | height | Oproperty |
| |||
Vegetation | point_intercept | id | ID |
| |||
Vegetation | point_intercept | in_canopy_sky | Oproperty |
| |||
Vegetation | point_intercept | method | NA | NC | |||
Vegetation | point_intercept | point_number | Sample |
| |||
Vegetation | point_intercept | site_location_visit_id | ID |
| |||
Vegetation | point_intercept | substrate | Oproperty |
| |||
Vegetation | point_intercept | transect | Subsite and Location |
| |||
Plant species | Vegetation | point_intercept | veg_barcode | Sample |
| ||
Plant species | Vegetation | species_growth_forms | growth_form | Oproperty |
| ||
Plant species per stratum | Plant species | Vegetation | species_growth_forms | species_name | ID |
| |
Plant species per stratum | Plant species | Vegetation | veg_vouchers | default_growth_form | Oproperty |
| |
Plant species per stratum | Plant species | Vegetation | veg_vouchers | field_name | ID |
| |
Plant species per stratum | Plant species | Vegetation | veg_vouchers | herbarium_sheet_id | NA | NC | |
Plant species per stratum | Plant species | Vegetation | veg_vouchers | site_location_visit_id | ID |
| |
Plant species | Plant species | Vegetation | veg_vouchers | veg_barcode | Sample |
| |
Plant species per stratum | Vegetation | structural_summary | description | Comment |
| ||
Plant species per stratum | Vegetation | structural_summary | ground_1_dominant | Oproperty |
| ||
Plant species per stratum | Vegetation | structural_summary | ground_2_dominant | Oproperty |
| ||
Plant species per stratum | Vegetation | structural_summary | ground_3_dominant | Oproperty |
| ||
Plant species per stratum | Vegetation | structural_summary | id | ID |
| ||
Vegetation Comunnity | Vegetation | structural_summary | mass_flowering_event | Oproperty |
| ||
Plant species per stratum | Vegetation | structural_summary | mid_1_dominant | Oproperty |
| ||
Plant species per stratum | Vegetation | structural_summary | mid_2_dominant | Oproperty |
| ||
Plant species per stratum | Vegetation | structural_summary | mid_3_dominant | Oproperty |
| ||
Plant species per stratum | Vegetation | structural_summary | phenology_comment | Comment |
| ||
Plant species per stratum | Vegetation | structural_summary | site_location_visit_id | ID |
| ||
Plant species per stratum | Vegetation | structural_summary | upper_1_dominant | Oproperty |
| ||
Plant species per stratum | Vegetation | structural_summary | upper_2_dominant | Oproperty |
| ||
Plant species per stratum | Vegetation | structural_summary | upper_3_dominant | Oproperty |
| ||
Vegetation | leaf area index | id | ID |
| |||
Vegetation | leaf area index | location_of_lai_data | Oproperty |
| |||
Vegetation | leaf area index | site_location_visit_id | ID |
| |||
Vegetation | leaf area index | completion_date_time | SOSA:resultTime of the OP |
| |||
Vegetation | photopoints | completion_date_time | SOSA:resultTime of the OP |
| |||
Vegetation | photopoints | id | ID |
| |||
Vegetation | photopoints | photo_storage_location | Oproperty |
| |||
Vegetation | photopoints | photopoint_centre_peg_lat | NA | NC | |||
Vegetation | photopoints | photopoint_centre_peg_long | NA | NC | |||
Vegetation | photopoints | photopoint_lat_1 | NA | NC | |||
Vegetation | photopoints | photopoint_lat_2 | NA | NC | |||
Vegetation | photopoints | photopoint_lat_3 | NA | NC | |||
Vegetation | photopoints | photopoint_long_1 | NA | NC | |||
Vegetation | photopoints | photopoint_long_2 | NA | NC | |||
Vegetation | photopoints | photopoint_long_3 | NA | NC | |||
Vegetation | photopoints | site_location_visit_id | ID |
| |||
??? | Substrate | site_location | other_outcrop_lithology | Oproperty |
| ||
??? | Substrate | site_location | outcrop_lithology | Oproperty |
| ||
??? | Substrate | site_location | surface_strew_lithology | Oproperty |
| ||
??? | Substrate | site_location | surface_strew_size | Oproperty |
| ||
Soil Profile | soil_bulk_density | fine_earth_bulk_density | Oproperty |
| |||
Soil Profile | soil_bulk_density | fine_earth_volume | Oproperty |
| |||
Soil Profile | soil_bulk_density | fine_earth_weight | Oproperty |
| |||
Soil Profile | soil_bulk_density | fine_earth_weight_in_bag | Oproperty |
| |||
Soil Profile | soil_bulk_density | gravel_bulk_density | Oproperty |
| |||
Soil Profile | soil_bulk_density | gravel_volume | Oproperty |
| |||
Soil Profile | soil_bulk_density | gravel_weight | Oproperty |
| |||
Soil Profile | soil_bulk_density | id | ID |
| |||
Soil Profile | soil_bulk_density | oven_dried_weight_in_bag | Oproperty |
| |||
Soil Profile | soil_bulk_density | paper_bag_weight | Oproperty |
| |||
Soil Profile | soil_bulk_density | ring_volume | Oproperty |
| |||
Soil Profile | soil_bulk_density | ring_weight | Oproperty |
| |||
Soil Profile | soil_bulk_density | sample_id | Sample |
| |||
Soil Profile | soil_bulk_density | site_location_visit_id | ID |
| |||
Soil Profile | soil_characterisation | collected_by | People and organizations |
| |||
Soil Profile | soil_characterisation | colour_when_dry | Oproperty |
| |||
Soil Profile | soil_characterisation | colour_when_moist | Oproperty |
| |||
Soil Profile | soil_characterisation | comments | Comment |
| |||
Soil Profile | soil_characterisation | ec | Oproperty | Missing QUDT unit | |||
Soil Profile | soil_characterisation | effervescence | Oproperty |
| |||
Soil Profile | soil_characterisation | horizon | Oproperty |
| |||
Soil Profile | soil_characterisation | id | ID |
| |||
Soil Profile | soil_characterisation | layer_barcode | Sample |
| |||
Soil Profile | soil_characterisation | lower_depth | Oproperty |
| |||
Soil Profile | soil_characterisation | mottles_abundance | Oproperty |
| |||
Soil Profile | soil_characterisation | mottles_colour | Oproperty |
| |||
Soil Profile | soil_characterisation | mottles_size | Oproperty |
| |||
Soil Profile | soil_characterisation | next_size_1 | Oproperty |
| |||
Soil Profile | soil_characterisation | next_size_2 | NA | NC | |||
Soil Profile | soil_characterisation | next_size_type_1 | Oproperty |
| |||
Soil Profile | soil_characterisation | next_size_type_2 | NA | NC | |||
Soil Profile | soil_characterisation | pedality_fabric | Oproperty |
| |||
Soil Profile | soil_characterisation | pedality_grade | Oproperty |
| |||
Soil Profile | soil_characterisation | ph | Oproperty | Missing QUDT unit | |||
Soil Profile | soil_characterisation | segregations_abundance | Oproperty |
| |||
Soil Profile | soil_characterisation | segregations_form | Oproperty |
| |||
Soil Profile | soil_characterisation | segregations_nature | Oproperty |
| |||
Soil Profile | soil_characterisation | segregations_size | Oproperty |
| |||
Soil Profile | soil_characterisation | site_location_visit_id | ID |
| |||
Soil Profile | soil_characterisation | smallest_size_1 | Oproperty |
| |||
Soil Profile | soil_characterisation | smallest_size_2 | NA | NC | |||
Soil Profile | soil_characterisation | smallest_size_type_1 | Oproperty |
| |||
Soil Profile | soil_characterisation | smallest_size_type_2 | NA | NC | |||
Soil Profile | soil_characterisation | texture_grade | Oproperty |
| |||
Soil Profile | soil_characterisation | texture_modifier | Oproperty |
| |||
Soil Profile | soil_characterisation | texture_qualifier | Oproperty |
| |||
Soil Profile | soil_characterisation | upper_depth | Oproperty |
| |||
Soil Profile | soil_subsite_observations | comments | Comment |
| |||
Soil Profile | soil_subsite_observations | easting | Subsite and Location |
| |||
Soil Profile | soil_subsite_observations | id | ID |
| |||
Soil Profile | soil_subsite_observations | metagenomic_barcode | Sample |
| |||
Soil Profile | soil_subsite_observations | metagenomic_url | NA | NC | |||
Soil Profile | soil_subsite_observations | metagenomics_are_available | NA | NC | |||
Soil Profile | soil_subsite_observations | northing | Subsite and Location |
| |||
Soil Profile | soil_subsite_observations | observer | People and organizations |
| |||
Soil Profile | soil_subsite_observations | photo_no | Sample |
| |||
Soil Profile | soil_subsite_observations | photo_url | NA | NC | |||
Soil Profile | soil_subsite_observations | site_location_visit_id | ID |
| |||
Soil Profile | soil_subsite_observations | subsite_id | Subsite and Location |
| |||
Soil Profile | soil_subsite_observations | ten_to_twenty_barcode | Sample |
| |||
Soil Profile | soil_subsite_observations | twenty_to_thirty_barcode | Sample |
| |||
Soil Profile | soil_subsite_observations | zero_to_ten_barcode | Sample |
| |||
Soil Profile | soil_subsite_observations | zone | Subsite and Location |
| |||
Location | site_location | app_lat | NA | NC | |||
Location | site_location | app_long | NA | NC | |||
Location | site_location | bioregion_name | NA | NC | |||
Location | site_location | comments | Comment |
| |||
Location | site_location | description | Comment |
| |||
Location | site_location | established_date | Comment |
| |||
Location | site_location | paddock | NA | NC | |||
Location | site_location | plot_dimensions | Oproperty |
| |||
Location | site_location | plot_is_100m_by_100m | NA | NC | |||
Location | site_location | plot_is_aligned_to_grid | Oproperty |
| |||
Location | site_location | plot_is_permanently_marked | Oproperty |
| |||
Site and location | Location | site_location | property | Suggested addition to the Plot Ontology Extension |
| ||
Site and location | Location | site_location_point | easting | NA | NC | ||
Site and location | Location | site_location_point | id | ID |
| ||
Site and location | Location | site_location_point | latitude | Location |
| ||
Site and location | Location | site_location_point | longitude | Location |
| ||
Site and location | Location | site_location_point | northing | NA | NC | ||
Site and location | Location | site_location_point | point | Location |
| ||
Site and location | Location | site_location_point | site_location_id | ID |
| ||
Site and location | Location | site_location_point | threedcq | NA | NC | ||
Site and location | Location | site_location_point | zone | NA | NC | ||
Site and location | Location | site_location_visit | a_s_c | NA | NC | ||
Site and location | Location | site_location_visit | basal_wedge_has_been_collected | NA | NC | ||
Site and location | Location | site_location_visit | climatic_condition | Oproperty |
| ||
Site and location | Location | site_location_visit | comment_on_distance_to_community | Comment |
| ||
Site and location | Location | site_location_visit | comment_on_distance_to_infrastructure | Comment |
| ||
Site and location | Location | site_location_visit | described_by | ??? |
| ||
Site and location | Location | site_location_visit | distance_to_nearest_community | Comment |
| ||
Site and location | Location | site_location_visit | distance_to_nearest_infrastructure | Comment |
| ||
Site and location | Location | site_location_visit | location_description | Comment |
| ||
Site and location | Location | site_location_visit | pit_marker_datum | Subsite and Location |
| ||
Site and location | Location | site_location_visit | pit_marker_easting | Subsite and Location |
| ||
Site and location | Location | site_location_visit | pit_marker_location_method | Subsite and Location |
| ||
Site and location | Location | site_location_visit | pit_marker_mga_zones | Subsite and Location |
| ||
Site and location | Location | site_location_visit | pit_marker_northing | Subsite and Location |
| ||
Site and location | Location | site_location_visit | sample_location_comment | Comment |
| ||
Site and location | Location | site_location_visit | site_location_id | ID |
| ||
Site and location | Location | site_location_visit | site_location_visit_id | ID |
| ||
Location | site_location_visit | soil_observation_type | Oproperty |
| |||
Vegetation Comunnity | Location | site_location_visit | vegetation_condition | Oproperty |
| ||
Site and location | Location | site_location_visit | visit_end_date | Comment |
| ||
Site and location | Location | site_location_visit | visit_notes | Comment |
| ||
Site and location | Location | site_location_visit | visit_start_date | Comment |
| ||
Landform | Landform | Site and location | Landform | site_location | landform_element | Oproperty | Landform does not exists in Ausplots |
Landform | Landform | Site and location | Landform | site_location | landform_pattern | Oproperty | Landform does not exists in Ausplots |
Land surface | characterisation_coarse_frags_abundance | coarse_frag_abund_id | Oproperty |
| |||
Land surface | characterisation_coarse_frags_abundance | id | ID |
| |||
Land surface | characterisation_coarse_frags_abundance | soil_characterisation_id | ID |
| |||
Land surface | characterisation_coarse_frags_lithology | id | ID |
| |||
Land surface | characterisation_coarse_frags_lithology | lithology_code | Oproperty |
| |||
Land surface | characterisation_coarse_frags_lithology | soil_characterisation_id | ID |
| |||
Land surface | characterisation_coarse_frags_shape | coarse_frag_shape_id | Oproperty |
| |||
Land surface | characterisation_coarse_frags_shape | id | ID |
| |||
Land surface | characterisation_coarse_frags_shape | soil_characterisation_id | ID |
| |||
Land surface | characterisation_coarse_frags_size | coarse_frag_size_id | Oproperty |
| |||
Land surface | characterisation_coarse_frags_size | id | ID |
| |||
Land surface | characterisation_coarse_frags_size | soil_characterisation_id | ID |
| |||
Land surface | site_location | site_aspect | Oproperty |
| |||
Land surface | site_location | site_location_id | ID |
| |||
Land surface | site_location | site_location_name | ID |
| |||
Land surface | site_location | site_slope | Oproperty |
| |||
Land surface | site_location_visit | disturbance | Oproperty |
| |||
Land surface | site_location_visit | drainage_type | Oproperty |
| |||
Land surface | site_location_visit | erosion_abundance | Oproperty |
| |||
Land surface | site_location_visit | erosion_state | Oproperty |
| |||
Land surface | site_location_visit | erosion_type | Oproperty |
| |||
Land surface | site_location_visit | microrelief | Oproperty |
| |||
Land surface | visit_surface_coarse_frags_abundance | coarse_frag_abund_id | Oproperty |
| |||
Land surface | visit_surface_coarse_frags_abundance | id | ID |
| |||
Land surface | visit_surface_coarse_frags_abundance | site_location_visit_id | ID |
| |||
Land surface | visit_surface_coarse_frags_lithology | id | ID |
| |||
Land surface | visit_surface_coarse_frags_lithology | lithology_code | Oproperty |
| |||
Land surface | visit_surface_coarse_frags_lithology | site_location_visit_id | ID |
| |||
Land surface | visit_surface_coarse_frags_size | coarse_frag_size_id | Oproperty |
| |||
Land surface | visit_surface_coarse_frags_size | id | ID |
| |||
Land surface | visit_surface_coarse_frags_size | site_location_visit_id | ID |
| |||
Land surface | visit_surface_coarse_frags_type | coarse_frag_type_id | Oproperty |
| |||
Land surface | visit_surface_coarse_frags_type | id | ID |
| |||
Land surface | visit_surface_coarse_frags_type | site_location_visit_id | ID |
| |||
Land surface | visit_surface_soil_conditions | id | ID |
| |||
Land surface | visit_surface_soil_conditions | site_location_visit_id | ID |
| |||
Land surface | visit_surface_soil_conditions | surface_soil_condition_id | Oproperty |
|