lut_landform_element |
Table |
description |
text |
2147483647 |
√ |
|
null |
|
site_location |
Table |
outcrop_lithology |
varchar |
2147483647 |
√ |
|
'NC'::character varying |
|
lut_soil_tex_grade |
Table |
bolus_description |
text |
2147483647 |
|
|
null |
|
lut_lithology |
Table |
rock_type |
varchar |
2147483647 |
|
|
null |
|
lut_erosion_state |
Table |
id |
text |
2147483647 |
|
|
null |
|
SiteVisit_Vouchers_and_Determinations |
View |
visit_start_date |
timestamp |
29 |
√ |
|
null |
|
soil_subsite_observations |
Table |
metagenomics_are_available |
bool |
1 |
|
|
null |
|
soils_file_uploads |
Table |
site_location_id |
int4 |
10 |
√ |
|
null |
|
SiteVisit_Vouchers_and_Determinations |
View |
herbarium_determination |
text |
2147483647 |
√ |
|
null |
|
lut_ibra |
Table |
bioregion_description |
text |
2147483647 |
√ |
|
null |
|
soil_characterisation |
Table |
ec |
float8 |
17 |
√ |
|
null |
|
All_Broken_PI_Points |
View |
in_canopy_sky |
bool |
1 |
√ |
|
null |
|
herbarium_determination |
Table |
herbarium_determination |
text |
2147483647 |
√ |
|
null |
|
site_location |
Table |
plot_is_aligned_to_grid |
bool |
1 |
√ |
|
true |
|
lut_seg_abundance |
Table |
id |
text |
2147483647 |
|
|
null |
|
lut_substrate |
Table |
description |
text |
2147483647 |
√ |
|
null |
|
lut_landform_pattern |
Table |
landform_pattern |
text |
2147483647 |
√ |
|
null |
|
All Point Intercept Points for a Plot |
View |
in_canopy_sky |
bool |
1 |
√ |
|
null |
|
lut_pedality_fabric |
Table |
id |
text |
2147483647 |
|
|
null |
|
site_location_visit |
Table |
site_visit_photo_name |
varchar |
2147483647 |
√ |
|
null |
|
site_location |
Table |
app_long |
varchar |
2147483647 |
√ |
|
null |
|
lut_coarse_frag_shape |
Table |
type |
text |
2147483647 |
|
|
null |
|
lut_basal_point |
Table |
point_id |
text |
2147483647 |
|
√ |
nextval('lut_basal_point_point_id_seq'::regclass) |
|
lut_substrate |
Table |
substrate |
text |
2147483647 |
|
|
null |
|
lut_mottle_size |
Table |
id |
text |
2147483647 |
|
|
null |
|
All Point Intercept Points for a Plot |
View |
substrate |
varchar |
2147483647 |
√ |
|
null |
|
soil_characterisation |
Table |
next_size_2 |
text |
2147483647 |
√ |
|
null |
|
SiteVisit_Vouchers_and_Determinations |
View |
veg_barcode |
text |
2147483647 |
√ |
|
null |
|
lut_pedality_type |
Table |
pedality_type |
text |
2147483647 |
|
|
null |
|
site_location_visit |
Table |
basal_wedge_has_been_collected |
bool |
1 |
√ |
|
false |
|
photopoints |
Table |
photopoint_long_2 |
text |
2147483647 |
√ |
|
null |
|
basal_area |
Table |
basal_area |
float8 |
17 |
√ |
|
null |
|
lut_surface_soil_cond |
Table |
id |
text |
2147483647 |
|
|
null |
|
soil_characterisation |
Table |
segregations_abundance |
text |
2147483647 |
|
|
null |
|
site_location_visit |
Table |
soil_observation_type |
text |
2147483647 |
√ |
|
'P'::text |
|
site_location |
Table |
app_lat |
varchar |
2147483647 |
√ |
|
null |
|
enter_determinations |
View |
determination_date |
timestamp |
29 |
√ |
|
null |
|
lut_surface_soil_cond |
Table |
condition |
text |
2147483647 |
|
|
null |
|
site_location_visit |
Table |
sample_location_comment |
varchar |
2147483647 |
√ |
|
null |
|
lut_growth_form |
Table |
definition |
text |
2147483647 |
√ |
|
null |
|
lut_erosion_type |
Table |
id |
text |
2147483647 |
|
|
null |
|
visit_surface_coarse_frags_abundance |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
herbarium_determination |
Table |
veg_barcode |
text |
2147483647 |
|
|
null |
|
dgps_file_uploads |
Table |
processed |
bool |
1 |
√ |
|
null |
|
lut_basal_point |
Table |
distance_from_sw_corner |
text |
2147483647 |
|
|
null |
|
lai |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
site_location |
Table |
landform_element |
varchar |
2147483647 |
√ |
|
'NC'::character varying |
|
site_location |
Table |
comments |
text |
2147483647 |
√ |
|
null |
|
site_location_visit |
Table |
observer_veg |
int4 |
10 |
√ |
|
13 |
|
soil_characterisation |
Table |
next_size_type_2 |
text |
2147483647 |
√ |
|
null |
|
lut_state |
Table |
state |
text |
2147483647 |
|
|
null |
|
lut_datum |
Table |
description_geoscience_australia |
text |
2147483647 |
√ |
|
null |
|
herbarium_sheet |
Table |
return_date |
timestamp |
29 |
√ |
|
null |
|
visit_surface_coarse_frags_type |
Table |
id |
serial |
10 |
|
√ |
nextval('visit_surface_coarse_frags_type_id_seq'::regclass) |
|
lut_observer |
Table |
affiliation |
varchar |
2147483647 |
|
|
null |
|
lut_seg_size |
Table |
id |
text |
2147483647 |
|
|
null |
|
soil_characterisation |
Table |
layer_barcode |
text |
2147483647 |
√ |
|
null |
|
soil_subsite_observations |
Table |
id |
serial |
10 |
|
√ |
nextval('soil_subsite_observations_id_seq'::regclass) |
|
site_location_point |
Table |
zone |
int4 |
10 |
|
|
null |
|
visit_surface_coarse_frags_size |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
soil_bulk_density |
Table |
ring_volume |
float8 |
17 |
√ |
|
null |
|
basal_area |
Table |
basal_area_factor |
float8 |
17 |
√ |
|
null |
|
lut_soil_obs_type |
Table |
type |
text |
2147483647 |
|
|
null |
|
genetic_vouchers |
Table |
veg_barcode |
text |
2147483647 |
|
|
null |
|
soil_bulk_density |
Table |
gravel_bulk_density |
float8 |
17 |
√ |
|
null |
|
characterisation_coarse_frags_abundance |
Table |
soil_characterisation_id |
int4 |
10 |
|
|
null |
|
enter_determinations |
View |
determiner |
text |
2147483647 |
√ |
|
null |
|
lut_seg_form |
Table |
id |
text |
2147483647 |
|
|
null |
|
lut_microrelief |
Table |
description |
text |
2147483647 |
√ |
|
null |
|
soil_characterisation |
Table |
comments |
text |
2147483647 |
√ |
|
null |
|
site_location_visit |
Table |
visit_start_date |
timestamp |
29 |
√ |
|
null |
|
dgps_file_uploads |
Table |
site_location_id |
int4 |
10 |
√ |
|
null |
|
site_location_visit |
Table |
vegetation_condition |
text |
2147483647 |
√ |
|
null |
|
soils_file_uploads |
Table |
file_path |
varchar |
2147483647 |
√ |
|
null |
|
lut_soil_tex_grade |
Table |
clay_content |
text |
2147483647 |
|
|
null |
|
herbarium_sheet |
Table |
follow_up_date |
timestamp |
29 |
√ |
|
null |
|
lut_datum |
Table |
datum |
text |
2147483647 |
|
|
null |
|
site_location_visit |
Table |
erosion_abundance |
text |
2147483647 |
√ |
|
'NC'::text |
|
lut_pedality_type |
Table |
description |
text |
2147483647 |
|
|
null |
|
basal_area |
Table |
hits |
int4 |
10 |
|
|
null |
|
soil_bulk_density |
Table |
fine_earth_bulk_density |
float8 |
17 |
√ |
|
null |
|
lut_soil_tex_grade |
Table |
code |
text |
2147483647 |
|
|
null |
|
soil_characterisation |
Table |
next_size_1 |
text |
2147483647 |
√ |
|
null |
|
soil_characterisation |
Table |
smallest_size_type_1 |
text |
2147483647 |
|
|
null |
|
lut_landform_element |
Table |
code |
text |
2147483647 |
|
|
null |
|
lut_landform_element |
Table |
landform_element |
text |
2147483647 |
√ |
|
null |
|
herbarium_determination |
Table |
specimen_stored_at |
varchar |
2147483647 |
√ |
|
null |
|
characterisation_coarse_frags_shape |
Table |
coarse_frag_shape_id |
text |
2147483647 |
|
|
null |
|
photopoints |
Table |
photopoint_long_3 |
text |
2147483647 |
√ |
|
null |
|
herbarium_sheet |
Table |
lodgement_date |
timestamp |
29 |
√ |
|
null |
|
soil_characterisation |
Table |
next_size_type_1 |
text |
2147483647 |
|
|
null |
|
genetic_vouchers |
Table |
primary_gen_barcode |
text |
2147483647 |
√ |
|
null |
|
site_location_visit |
Table |
distance_to_nearest_infrastructure |
int4 |
10 |
√ |
|
null |
|
All Point Intercept Points for a Plot |
View |
growth_form |
varchar |
2147483647 |
√ |
|
null |
|
site_location_visit |
Table |
location_description |
text |
2147483647 |
√ |
|
null |
|
lut_drainage |
Table |
id |
int4 |
10 |
|
|
null |
|
lut_datum |
Table |
equatorial_radius_in_m |
text |
2147483647 |
√ |
|
null |
|
structural_summary |
Table |
mass_flowering_event |
bool |
1 |
√ |
|
null |
|
lut_effervescence |
Table |
effervescence |
text |
2147483647 |
|
|
null |
|
genetic_vouchers |
Table |
genetic_barcode_analysis_url |
varchar |
2147483647 |
√ |
|
null |
|
lut_pedality_grade |
Table |
id |
text |
2147483647 |
|
|
null |
|
visit_surface_soil_conditions |
Table |
surface_soil_condition_id |
text |
2147483647 |
|
|
null |
|
site_location_visit |
Table |
described_by |
int4 |
10 |
√ |
|
13 |
|
point_intercept |
Table |
method |
varchar |
2147483647 |
√ |
|
null |
|
species_growth_forms |
Table |
species_name |
varchar |
2147483647 |
|
|
null |
|
site_location_visit |
Table |
distance_to_nearest_community |
int4 |
10 |
√ |
|
null |
|
site_location_visit |
Table |
erosion_type |
text |
2147483647 |
√ |
|
'NC'::text |
|
lai |
Table |
completion_date_time |
timestamp |
29 |
√ |
|
null |
|
soils_file_uploads |
Table |
id |
serial |
10 |
|
√ |
nextval('soils_file_uploads_id_seq'::regclass) |
|
lut_erosion_abund |
Table |
abundance |
text |
2147483647 |
|
|
null |
|
characterisation_coarse_frags_lithology |
Table |
lithology_code |
varchar |
2147483647 |
|
|
null |
|
visit_surface_coarse_frags_lithology |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
soil_subsite_observations |
Table |
comments |
text |
2147483647 |
√ |
|
null |
|
lut_soil_tex_qual |
Table |
qualification |
text |
2147483647 |
|
|
null |
|
soil_characterisation |
Table |
horizon |
text |
2147483647 |
√ |
|
null |
|
visit_surface_coarse_frags_lithology |
Table |
id |
serial |
10 |
|
√ |
nextval('visit_surface_coarse_frags_lithology_id_seq'::regclass) |
|
lut_landform_pattern |
Table |
occasional_elements |
text |
2147483647 |
√ |
|
null |
|
structural_summary |
Table |
ground_1_dominant |
text |
2147483647 |
√ |
|
null |
|
All_Broken_PI_Points |
View |
substrate |
varchar |
2147483647 |
√ |
|
null |
|
herbarium_determination |
Table |
determiner_comment |
varchar |
2147483647 |
√ |
|
null |
|
soil_bulk_density |
Table |
fine_earth_volume |
float8 |
17 |
√ |
|
null |
|
soil_characterisation |
Table |
mottles_abundance |
text |
2147483647 |
|
|
null |
|
soil_subsite_observations |
Table |
photo_url |
text |
2147483647 |
√ |
|
null |
|
site_location_visit |
Table |
disturbance |
text |
2147483647 |
√ |
|
'NC'::text |
|
soil_characterisation |
Table |
texture_qualifier |
text |
2147483647 |
√ |
|
null |
|
lut_structure_size |
Table |
id |
text |
2147483647 |
|
|
null |
|
structural_summary |
Table |
mid_2_dominant |
text |
2147483647 |
√ |
|
null |
|
lut_microrelief |
Table |
id |
text |
2147483647 |
|
|
null |
|
dets_file_uploads |
Table |
processed |
bool |
1 |
√ |
|
null |
|
site_location |
Table |
plot_dimensions |
varchar |
2147483647 |
√ |
|
null |
|
characterisation_coarse_frags_size |
Table |
soil_characterisation_id |
int4 |
10 |
|
|
null |
|
lut_soil_tex_mod |
Table |
id |
text |
2147483647 |
|
|
null |
|
soil_characterisation |
Table |
texture_grade |
text |
2147483647 |
√ |
|
null |
|
characterisation_coarse_frags_lithology |
Table |
id |
serial |
10 |
|
√ |
nextval('characterisation_coarse_frags_lithology_id_seq'::regclass) |
|
site_location_point |
Table |
site_location_id |
int4 |
10 |
|
|
null |
|
soil_characterisation |
Table |
smallest_size_type_2 |
text |
2147483647 |
√ |
|
null |
|
site_location_visit |
Table |
pit_marker_easting |
float8 |
17 |
√ |
|
null |
|
site_location |
Table |
other_outcrop_lithology |
varchar |
2147483647 |
√ |
|
null |
|
site_location_visit |
Table |
pit_marker_mga_zones |
int4 |
10 |
√ |
|
null |
|
veg_vouchers |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
lut_seg_nature |
Table |
id |
text |
2147483647 |
|
|
null |
|
lut_mottle_size |
Table |
size |
text |
2147483647 |
|
|
null |
|
site_location_visit |
Table |
comment_on_distance_to_community |
varchar |
2147483647 |
√ |
|
null |
|
herbarium_determination |
Table |
determiner |
text |
2147483647 |
√ |
|
null |
|
All_Broken_PI_Points |
View |
site_location_name |
varchar |
2147483647 |
√ |
|
null |
|
site_location_visit |
Table |
drainage_type |
int4 |
10 |
√ |
|
7 |
|
visit_surface_coarse_frags_abundance |
Table |
coarse_frag_abund_id |
text |
2147483647 |
|
|
null |
|
site_location |
Table |
paddock |
varchar |
2147483647 |
√ |
|
null |
|
lut_pedality_grade |
Table |
pedality |
text |
2147483647 |
|
|
null |
|
SiteVisit_Vouchers_and_Determinations |
View |
site_location_visit_id |
int4 |
10 |
√ |
|
null |
|
lut_datum |
Table |
reference_spheroid |
text |
2147483647 |
√ |
|
null |
|
structural_summary |
Table |
id |
serial |
10 |
|
√ |
nextval('structural_summary_id_seq'::regclass) |
|
soil_characterisation |
Table |
segregations_size |
text |
2147483647 |
|
|
null |
|
soil_bulk_density |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
visit_surface_coarse_frags_abundance |
Table |
id |
serial |
10 |
|
√ |
nextval('visit_surface_coarse_frags_abundance_id_seq'::regclass) |
|
soils_file_uploads |
Table |
processed |
bool |
1 |
√ |
|
null |
|
lut_soil_tex_mod |
Table |
modifier |
text |
2147483647 |
|
|
null |
|
site_location_point |
Table |
northing |
float8 |
17 |
√ |
|
null |
|
site_location_point |
Table |
id |
serial |
10 |
|
√ |
nextval('site_location_point_id_seq'::regclass) |
|
All_Broken_PI_Points |
View |
growth_form |
varchar |
2147483647 |
√ |
|
null |
|
soil_characterisation |
Table |
ph |
float8 |
17 |
√ |
|
null |
|
site_location |
Table |
established_date |
timestamp |
29 |
√ |
|
null |
|
lut_pedality_grade |
Table |
grade |
text |
2147483647 |
|
|
null |
|
lut_seg_nature |
Table |
nature |
text |
2147483647 |
|
|
null |
|
characterisation_coarse_frags_shape |
Table |
soil_characterisation_id |
int4 |
10 |
|
|
null |
|
lut_coarse_frag_size |
Table |
size |
text |
2147483647 |
|
|
null |
|
lut_erosion_state |
Table |
state |
text |
2147483647 |
|
|
null |
|
lut_pedality_fabric |
Table |
pedality_fabric |
text |
2147483647 |
|
|
null |
|
lut_ibra |
Table |
bioregion_name |
text |
2147483647 |
|
|
null |
|
lut_pedality_type |
Table |
id |
text |
2147483647 |
|
|
null |
|
enter_determinations |
View |
veg_barcode |
text |
2147483647 |
√ |
|
null |
|
SiteVisit_Vouchers_and_Determinations |
View |
site_location_name |
varchar |
2147483647 |
√ |
|
null |
|
lut_erosion_type |
Table |
erosion_type |
text |
2147483647 |
√ |
|
null |
|
herbarium_sheet |
Table |
state |
text |
2147483647 |
|
|
null |
|
genetic_vouchers |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
soil_subsite_observations |
Table |
twenty_to_thirty_barcode |
text |
2147483647 |
√ |
|
null |
|
All_Broken_PI_Points |
View |
transect |
varchar |
2147483647 |
√ |
|
null |
|
soil_characterisation |
Table |
pedality_fabric |
text |
2147483647 |
|
|
null |
|
lut_landform_pattern |
Table |
typical_elements |
text |
2147483647 |
√ |
|
null |
|
lut_soil_obs_type |
Table |
description |
text |
2147483647 |
|
|
null |
|
site_location_visit |
Table |
erosion_state |
text |
2147483647 |
√ |
|
'NC'::text |
|
lut_pedality_grade |
Table |
description |
text |
2147483647 |
|
|
null |
|
lut_seg_size |
Table |
size |
text |
2147483647 |
|
|
null |
|
soil_characterisation |
Table |
collected_by |
int4 |
10 |
√ |
|
null |
|
site_location_point |
Table |
longitude |
float8 |
17 |
|
|
null |
|
lut_observer |
Table |
full_name |
text |
2147483647 |
|
|
null |
|
soil_subsite_observations |
Table |
zero_to_ten_barcode |
text |
2147483647 |
√ |
|
null |
|
soil_subsite_observations |
Table |
observer |
int4 |
10 |
|
|
null |
|
soil_subsite_observations |
Table |
zone |
int4 |
10 |
√ |
|
null |
|
SiteVisit_Vouchers_and_Determinations |
View |
field_name |
text |
2147483647 |
√ |
|
null |
|
dets_file_uploads |
Table |
id |
serial |
10 |
|
√ |
nextval('dets_file_uploads_id_seq'::regclass) |
|
characterisation_coarse_frags_abundance |
Table |
coarse_frag_abund_id |
text |
2147483647 |
|
|
null |
|
characterisation_coarse_frags_size |
Table |
id |
varchar |
2147483647 |
|
√ |
nextval('characterisation_coarse_frags_size_id_seq'::regclass) |
|
lai |
Table |
id |
serial |
10 |
|
√ |
nextval('lai_id_seq'::regclass) |
|
lut_erosion_abund |
Table |
id |
text |
2147483647 |
|
|
null |
|
photopoints |
Table |
photopoint_long_1 |
text |
2147483647 |
√ |
|
null |
|
soil_characterisation |
Table |
segregations_form |
text |
2147483647 |
|
|
null |
|
site_location_point |
Table |
threedcq |
float8 |
17 |
√ |
|
null |
|
photopoints |
Table |
photopoint_centre_peg_long |
text |
2147483647 |
√ |
|
null |
|
All Point Intercept Points for a Plot |
View |
method |
varchar |
2147483647 |
√ |
|
null |
|
photopoints |
Table |
photo_storage_location |
text |
2147483647 |
√ |
|
null |
|
photopoints |
Table |
completion_date_time |
timestamp |
29 |
√ |
|
null |
|
visit_surface_soil_conditions |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
lut_microrelief |
Table |
type |
text |
2147483647 |
√ |
|
null |
|
herbarium_sheet |
Table |
comments |
text |
2147483647 |
√ |
|
null |
|
veg_vouchers |
Table |
default_growth_form |
text |
2147483647 |
√ |
|
null |
|
lut_datum |
Table |
description |
text |
2147483647 |
√ |
|
null |
|
site_location_visit |
Table |
photopoints_exists |
bool |
1 |
√ |
|
false |
|
lut_landform_pattern |
Table |
compare_with |
text |
2147483647 |
√ |
|
null |
|
soil_bulk_density |
Table |
gravel_weight |
float8 |
17 |
√ |
|
null |
|
lut_mottle_colour |
Table |
colour |
text |
2147483647 |
|
|
null |
|
point_intercept |
Table |
dead |
bool |
1 |
√ |
|
null |
|
site_location_point |
Table |
latitude |
float8 |
17 |
|
|
null |
|
soil_characterisation |
Table |
pedality_grade |
text |
2147483647 |
|
|
null |
|
species_growth_forms |
Table |
growth_form |
varchar |
2147483647 |
√ |
|
null |
|
soil_characterisation |
Table |
colour_when_moist |
text |
2147483647 |
√ |
|
null |
|
lut_location_method |
Table |
location_tech_type |
varchar |
2147483647 |
|
|
null |
|
veg_vouchers |
Table |
field_name |
text |
2147483647 |
√ |
|
null |
|
site_location |
Table |
bioregion_name |
varchar |
2147483647 |
|
|
null |
|
All Point Intercept Points for a Plot |
View |
site_location_name |
varchar |
2147483647 |
√ |
|
null |
|
structural_summary |
Table |
ground_2_dominant |
text |
2147483647 |
√ |
|
null |
|
site_location_visit |
Table |
a_s_c |
text |
2147483647 |
√ |
|
null |
|
lut_bioregions |
Table |
abbreviation |
varchar |
2147483647 |
|
|
null |
|
lut_disturbance |
Table |
disturbance |
text |
2147483647 |
|
|
null |
|
soil_characterisation |
Table |
smallest_size_2 |
text |
2147483647 |
√ |
|
null |
|
veg_vouchers |
Table |
herbarium_sheet_id |
int4 |
10 |
√ |
|
null |
|
point_intercept |
Table |
height |
float8 |
17 |
√ |
|
null |
|
soil_subsite_observations |
Table |
metagenomic_barcode |
text |
2147483647 |
√ |
|
null |
|
visit_surface_coarse_frags_size |
Table |
id |
serial |
10 |
|
√ |
nextval('visit_surface_coarse_frags_size_id_seq'::regclass) |
|
site_location_visit |
Table |
visit_end_date |
timestamp |
29 |
√ |
|
null |
|
soil_bulk_density |
Table |
gravel_volume |
float8 |
17 |
√ |
|
null |
|
lut_surface_strew_size |
Table |
size |
text |
2147483647 |
|
|
null |
|
soil_characterisation |
Table |
mottles_size |
text |
2147483647 |
|
|
null |
|
point_intercept |
Table |
in_canopy_sky |
bool |
1 |
√ |
|
null |
|
All Point Intercept Points for a Plot |
View |
height |
float8 |
17 |
√ |
|
null |
|
soil_subsite_observations |
Table |
photo_no |
text |
2147483647 |
√ |
|
null |
|
herbarium_sheet |
Table |
herbarium_sheet_id |
serial |
10 |
|
√ |
nextval('herbarium_sheet_herbarium_sheet_id_seq'::regclass) |
|
site_location |
Table |
site_aspect |
varchar |
2147483647 |
√ |
|
null |
|
structural_summary |
Table |
mid_1_dominant |
text |
2147483647 |
√ |
|
null |
|
genetic_vouchers |
Table |
secondary_gen_barcode_4 |
text |
2147483647 |
√ |
|
null |
|
site_location |
Table |
site_location_name |
varchar |
2147483647 |
|
|
null |
|
lut_datum |
Table |
year_of_acceptance |
text |
2147483647 |
√ |
|
null |
|
enter_determinations |
View |
is_uncertain_determination |
bool |
1 |
√ |
|
null |
|
lut_basal_point |
Table |
point_name |
text |
2147483647 |
|
|
null |
|
lut_mottle_colour |
Table |
id |
text |
2147483647 |
|
|
null |
|
characterisation_coarse_frags_lithology |
Table |
soil_characterisation_id |
int4 |
10 |
|
|
null |
|
soil_subsite_observations |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
lut_soil_tex_qual |
Table |
id |
text |
2147483647 |
|
|
null |
|
soil_subsite_observations |
Table |
subsite_id |
text |
2147483647 |
√ |
|
null |
|
dets_file_uploads |
Table |
file_path |
varchar |
2147483647 |
√ |
|
null |
|
lut_mga_zone |
Table |
eastern_boundary |
text |
2147483647 |
|
|
null |
|
photopoints |
Table |
id |
serial |
10 |
|
√ |
nextval('photopoints_id_seq'::regclass) |
|
site_location_visit |
Table |
pit_marker_datum |
text |
2147483647 |
√ |
|
null |
|
All_Broken_PI_Points |
View |
point_number |
int4 |
10 |
√ |
|
null |
|
lut_drainage |
Table |
drainage |
text |
2147483647 |
|
|
null |
|
visit_surface_coarse_frags_size |
Table |
coarse_frag_size_id |
text |
2147483647 |
|
|
null |
|
photopoints |
Table |
photopoint_lat_1 |
text |
2147483647 |
√ |
|
null |
|
genetic_vouchers |
Table |
secondary_gen_barcode_1 |
text |
2147483647 |
√ |
|
null |
|
lut_lithology |
Table |
code |
varchar |
2147483647 |
|
|
null |
|
basal_area |
Table |
id |
serial |
10 |
|
√ |
nextval('basal_area_id_seq'::regclass) |
|
lut_mga_zone |
Table |
datum |
text |
2147483647 |
|
|
null |
|
site_location_visit |
Table |
pit_marker_northing |
float8 |
17 |
√ |
|
null |
|
site_location |
Table |
plot_is_permanently_marked |
bool |
1 |
√ |
|
true |
|
site_location_visit |
Table |
visit_notes |
text |
2147483647 |
√ |
|
null |
|
point_intercept |
Table |
point_number |
int4 |
10 |
√ |
|
null |
|
lut_soil_tex_grade |
Table |
name |
text |
2147483647 |
|
|
null |
|
site_location_visit |
Table |
pit_marker_location_method |
text |
2147483647 |
√ |
|
null |
|
site_location_visit |
Table |
site_location_id |
int4 |
10 |
|
|
null |
|
structural_summary |
Table |
phenology_comment |
text |
2147483647 |
√ |
|
null |
|
structural_summary |
Table |
mid_3_dominant |
text |
2147483647 |
√ |
|
null |
|
lut_seg_abundance |
Table |
abundance |
text |
2147483647 |
|
|
null |
|
lut_mottle_abund |
Table |
id |
text |
2147483647 |
|
|
null |
|
lut_coarse_frag_abund |
Table |
id |
text |
2147483647 |
|
|
null |
|
basal_area |
Table |
veg_barcode |
text |
2147483647 |
|
|
null |
|
lut_landform_pattern |
Table |
id |
text |
2147483647 |
|
|
null |
|
lut_datum |
Table |
inverse_flattening |
text |
2147483647 |
√ |
|
null |
|
site_location |
Table |
landform_pattern |
varchar |
2147483647 |
√ |
|
'NC'::character varying |
|
soil_characterisation |
Table |
upper_depth |
float8 |
17 |
√ |
|
null |
|
herbarium_determination |
Table |
is_uncertain_determination |
bool |
1 |
√ |
|
null |
|
point_intercept |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
site_location_visit |
Table |
climatic_condition |
text |
2147483647 |
√ |
|
null |
|
All_Broken_PI_Points |
View |
height |
float8 |
17 |
√ |
|
null |
|
site_location_visit |
Table |
observer_soil |
int4 |
10 |
√ |
|
13 |
|
site_location_point |
Table |
point |
text |
2147483647 |
√ |
|
null |
|
characterisation_coarse_frags_abundance |
Table |
id |
varchar |
2147483647 |
|
√ |
nextval('characterisation_coarse_frags_abundance_id_seq'::regclass) |
|
soil_bulk_density |
Table |
fine_earth_weight |
float8 |
17 |
√ |
|
null |
|
lut_soil_obs_type |
Table |
id |
text |
2147483647 |
|
|
null |
|
structural_summary |
Table |
ground_3_dominant |
text |
2147483647 |
√ |
|
null |
|
genetic_vouchers |
Table |
secondary_gen_barcode_3 |
text |
2147483647 |
√ |
|
null |
|
soil_characterisation |
Table |
id |
serial |
10 |
|
√ |
nextval('soil_characterisation_id_seq'::regclass) |
|
lut_structure_size |
Table |
size |
text |
2147483647 |
|
|
null |
|
soil_bulk_density |
Table |
ring_weight |
float8 |
17 |
√ |
|
null |
|
lut_drainage |
Table |
description |
text |
2147483647 |
|
|
null |
|
site_location_visit |
Table |
leaf_area_index_exists |
bool |
1 |
√ |
|
false |
|
visit_surface_coarse_frags_type |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
site_location_visit |
Table |
ok_to_publish |
bool |
1 |
|
|
false |
|
enter_determinations |
View |
field_name |
text |
2147483647 |
√ |
|
null |
|
site_location_visit |
Table |
comment_on_distance_to_infrastructure |
varchar |
2147483647 |
√ |
|
null |
|
lut_basal_point |
Table |
notes |
text |
2147483647 |
√ |
|
null |
|
soil_characterisation |
Table |
effervescence |
text |
2147483647 |
|
|
null |
|
All Point Intercept Points for a Plot |
View |
transect |
varchar |
2147483647 |
√ |
|
null |
|
soil_characterisation |
Table |
texture_modifier |
text |
2147483647 |
√ |
|
null |
|
dgps_file_uploads |
Table |
file_path |
varchar |
2147483647 |
√ |
|
null |
|
herbarium_sheet |
Table |
family |
varchar |
2147483647 |
√ |
|
null |
|
photopoints |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
SiteVisit_Vouchers_and_Determinations |
View |
is_uncertain_determination |
bool |
1 |
√ |
|
null |
|
lut_state |
Table |
description |
text |
2147483647 |
|
|
null |
|
lut_bioregions |
Table |
name |
varchar |
2147483647 |
√ |
|
null |
|
lut_disturbance |
Table |
id |
text |
2147483647 |
|
|
null |
|
visit_surface_coarse_frags_lithology |
Table |
lithology_code |
varchar |
2147483647 |
|
|
null |
|
All Point Intercept Points for a Plot |
View |
veg_barcode |
varchar |
2147483647 |
√ |
|
null |
|
structural_summary |
Table |
upper_3_dominant |
text |
2147483647 |
√ |
|
null |
|
visit_surface_soil_conditions |
Table |
id |
serial |
10 |
|
√ |
nextval('visit_surface_soil_conditions_id_seq'::regclass) |
|
lut_landform_pattern |
Table |
common_elements |
text |
2147483647 |
√ |
|
null |
|
basal_area |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
soil_subsite_observations |
Table |
metagenomic_url |
varchar |
2147483647 |
√ |
|
null |
|
genetic_vouchers |
Table |
secondary_gen_barcode_2 |
text |
2147483647 |
√ |
|
null |
|
soil_subsite_observations |
Table |
easting |
int4 |
10 |
√ |
|
null |
|
point_intercept |
Table |
transect |
varchar |
2147483647 |
√ |
|
null |
|
site_location_visit |
Table |
microrelief |
text |
2147483647 |
√ |
|
'NC'::text |
|
site_location |
Table |
property |
varchar |
2147483647 |
√ |
|
null |
|
lut_mga_zone |
Table |
mga_zone |
int4 |
10 |
|
|
null |
|
photopoints |
Table |
photopoint_lat_2 |
text |
2147483647 |
√ |
|
null |
|
genetic_vouchers |
Table |
tea_bag_is_synthetic |
text |
2147483647 |
√ |
|
null |
|
site_location |
Table |
plot_is_100m_by_100m |
bool |
1 |
√ |
|
true |
|
lut_effervescence |
Table |
id |
text |
2147483647 |
|
|
null |
|
soil_characterisation |
Table |
segregations_nature |
text |
2147483647 |
|
|
null |
|
structural_summary |
Table |
upper_2_dominant |
text |
2147483647 |
√ |
|
null |
|
characterisation_coarse_frags_size |
Table |
coarse_frag_size_id |
text |
2147483647 |
|
|
null |
|
soil_characterisation |
Table |
colour_when_dry |
text |
2147483647 |
√ |
|
null |
|
lut_mottle_abund |
Table |
abundance |
text |
2147483647 |
|
|
null |
|
site_location_visit |
Table |
site_location_visit_id |
serial |
10 |
|
√ |
nextval('site_location_visit_site_location_visit_id_seq'::regclass) |
|
herbarium_determination |
Table |
determination_date |
timestamp |
29 |
√ |
|
null |
|
lut_landform_pattern |
Table |
description |
text |
2147483647 |
√ |
|
null |
|
photopoints |
Table |
photopoint_lat_3 |
text |
2147483647 |
√ |
|
null |
|
site_location |
Table |
surface_strew_lithology |
varchar |
2147483647 |
√ |
|
null |
|
enter_determinations |
View |
site_location_visit_id |
int4 |
10 |
√ |
|
null |
|
point_intercept |
Table |
veg_barcode |
varchar |
2147483647 |
√ |
|
null |
|
veg_vouchers |
Table |
veg_barcode |
text |
2147483647 |
|
|
null |
|
soil_bulk_density |
Table |
sample_id |
text |
2147483647 |
√ |
|
null |
|
soil_subsite_observations |
Table |
northing |
int4 |
10 |
√ |
|
null |
|
soil_bulk_density |
Table |
oven_dried_weight_in_bag |
float8 |
17 |
√ |
|
null |
|
dgps_file_uploads |
Table |
id |
serial |
10 |
|
√ |
nextval('dgps_file_uploads_id_seq'::regclass) |
|
lut_coarse_frag_size |
Table |
id |
text |
2147483647 |
|
|
null |
|
structural_summary |
Table |
description |
text |
2147483647 |
√ |
|
null |
|
point_intercept |
Table |
id |
serial |
10 |
|
√ |
nextval('point_intercept_id_seq'::regclass) |
|
herbarium_sheet |
Table |
herbarium_sheet_name |
text |
2147483647 |
√ |
|
null |
|
soil_bulk_density |
Table |
id |
serial |
10 |
|
√ |
nextval('soil_bulk_density_id_seq'::regclass) |
|
lai |
Table |
location_of_lai_data |
text |
2147483647 |
√ |
|
null |
|
site_location |
Table |
site_location_id |
serial |
10 |
|
√ |
nextval('site_location_site_location_id_seq'::regclass) |
|
genetic_vouchers |
Table |
sample_for_dna |
text |
2147483647 |
√ |
|
null |
|
All Point Intercept Points for a Plot |
View |
point_number |
int4 |
10 |
√ |
|
null |
|
characterisation_coarse_frags_shape |
Table |
id |
serial |
10 |
|
√ |
nextval('characterisation_coarse_frags_shape_id_seq'::regclass) |
|
All Point Intercept Points for a Plot |
View |
dead |
bool |
1 |
√ |
|
null |
|
lut_location_method |
Table |
description |
varchar |
2147483647 |
√ |
|
null |
|
lut_mga_zone |
Table |
western_boundary |
text |
2147483647 |
|
|
null |
|
soil_bulk_density |
Table |
paper_bag_weight |
float8 |
17 |
√ |
|
null |
|
soil_bulk_density |
Table |
fine_earth_weight_in_bag |
float8 |
17 |
√ |
|
null |
|
enter_determinations |
View |
herbarium_determination |
text |
2147483647 |
√ |
|
null |
|
lut_pedality_fabric |
Table |
description |
text |
2147483647 |
|
|
null |
|
soil_characterisation |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
lut_lithology |
Table |
outcrop_lithology |
varchar |
2147483647 |
√ |
|
null |
|
All_Broken_PI_Points |
View |
veg_barcode |
varchar |
2147483647 |
√ |
|
null |
|
lut_coarse_frag_abund |
Table |
type |
text |
2147483647 |
|
|
null |
|
lut_seg_form |
Table |
form |
text |
2147483647 |
|
|
null |
|
site_location |
Table |
site_slope |
varchar |
2147483647 |
√ |
|
null |
|
point_intercept |
Table |
substrate |
varchar |
2147483647 |
|
|
null |
|
site_location |
Table |
description |
text |
2147483647 |
|
|
null |
|
photopoints |
Table |
photopoint_centre_peg_lat |
text |
2147483647 |
√ |
|
null |
|
All_Broken_PI_Points |
View |
dead |
bool |
1 |
√ |
|
null |
|
structural_summary |
Table |
upper_1_dominant |
text |
2147483647 |
√ |
|
null |
|
herbarium_sheet |
Table |
follow_up_text |
text |
2147483647 |
√ |
|
null |
|
site_location |
Table |
surface_strew_size |
int4 |
10 |
√ |
|
null |
|
lut_coarse_frag_shape |
Table |
id |
text |
2147483647 |
|
|
null |
|
soil_characterisation |
Table |
smallest_size_1 |
text |
2147483647 |
√ |
|
null |
|
lut_observer |
Table |
id |
serial |
10 |
|
√ |
nextval('observer_id_seq'::regclass) |
|
structural_summary |
Table |
site_location_visit_id |
int4 |
10 |
|
|
null |
|
visit_surface_coarse_frags_type |
Table |
coarse_frag_type_id |
text |
2147483647 |
|
|
null |
|
dets_file_uploads |
Table |
site_location_id |
int4 |
10 |
√ |
|
null |
|
basal_area |
Table |
point_id |
text |
2147483647 |
|
|
null |
|
lut_surface_strew_size |
Table |
id |
int4 |
10 |
|
|
null |
|
point_intercept |
Table |
growth_form |
varchar |
2147483647 |
√ |
|
null |
|
herbarium_determination |
Table |
state_accession_number |
text |
2147483647 |
√ |
|
null |
|
soil_characterisation |
Table |
mottles_colour |
text |
2147483647 |
|
|
null |
|
soil_subsite_observations |
Table |
ten_to_twenty_barcode |
text |
2147483647 |
√ |
|
null |
|
lut_mga_zone |
Table |
projection |
text |
2147483647 |
|
|
null |
|
lut_growth_form |
Table |
growth_form |
text |
2147483647 |
|
|
null |
|
soil_characterisation |
Table |
lower_depth |
float8 |
17 |
√ |
|
null |
|
genetic_vouchers |
Table |
sample_for_isotope |
text |
2147483647 |
√ |
|
null |
|
enter_determinations |
View |
state_accession_number |
text |
2147483647 |
√ |
|
null |
|
site_location_point |
Table |
easting |
float8 |
17 |
√ |
|
null |
|