observed_plot_coordinates

0 rows


Description

Observed GPS coordinates in monitoring plots. Does not include photo coordinates or coordinates of recorded plants.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
observation_id int8 19 null
observation_plots.observation_id observed_plot_coordinates_observation_id_monitoring_plot_i_fkeyR
observations.id observed_plot_coordinates_observation_id_fkeyC
monitoring_plot_id int8 19 null
monitoring_plots.id observed_plot_coordinates_monitoring_plot_id_fkeyC
observation_plots.monitoring_plot_id observed_plot_coordinates_observation_id_monitoring_plot_i_fkeyR
position_id int4 10 null
observation_plot_positions.id observed_plot_coordinates_position_id_fkeyR
gps_coordinates geometry 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
observed_plot_coordinates_pkey Primary key Asc id
one_point_per_position Must be unique Asc/Asc/Asc observation_id + monitoring_plot_id + position_id

Relationships

Close relationships within degrees of separation