observed_plot_coordinates

-1 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
observations.id observed_plot_coordinates_observation_id_fkey C
observation_plots.observation_id observed_plot_coordinates_observation_id_monitoring_plot_i_fkey R
monitoring_plot_id int8 19 null
monitoring_plots.id observed_plot_coordinates_monitoring_plot_id_fkey C
observation_plots.monitoring_plot_id observed_plot_coordinates_observation_id_monitoring_plot_i_fkey R
position_id int4 10 null
observation_plot_positions.id observed_plot_coordinates_position_id_fkey R
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