monitoring_plots

0 rows


Description

Regions within planting subzones that can be comprehensively surveyed in order to extrapolate results for the entire zone. Any monitoring plot in a subzone is expected to have roughly the same number of plants of the same species as any other monitoring plot in the same subzone.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
observation_photos.monitoring_plot_id observation_photos_monitoring_plot_id_fkeyR
observation_plot_conditions.monitoring_plot_id observation_plot_conditions_monitoring_plot_id_fkeyC
observation_plots.monitoring_plot_id observation_plots_monitoring_plot_id_fkeyC
observed_plot_coordinates.monitoring_plot_id observed_plot_coordinates_monitoring_plot_id_fkeyC
observed_plot_species_totals.monitoring_plot_id observed_plot_species_totals_monitoring_plot_id_fkeyC
recorded_plants.monitoring_plot_id recorded_plants_monitoring_plot_id_fkeyC
planting_subzone_id int8 19 null
planting_subzones.id monitoring_plots_planting_subzone_id_fkeyC

Which planting subzone this monitoring plot is part of.
name text 2147483647 null
full_name text 2147483647 null
created_by int8 19 null
users.id monitoring_plots_created_by_fkeyR

Which user created the monitoring plot.
created_time timestamptz 35,6 null

When the monitoring plot was originally created.
modified_by int8 19 null
users.id monitoring_plots_modified_by_fkeyR

Which user most recently modified the monitoring plot.
modified_time timestamptz 35,6 null

When the monitoring plot was most recently modified.
boundary geometry 2147483647 null

Boundary of the monitoring plot. Coordinates always use SRID 4326 (WGS 84 latitude/longitude).
permanent_cluster int4 10 √ null

If this plot is a candidate to be a permanent monitoring plot, its position in the randomized list of plots for the planting zone. Starts at 1 for each planting zone. There are always 4 plots with a given sequence number in a given zone. If null, this plot is not part of a 4-plot cluster but may still be chosen as a temporary monitoring plot.
permanent_cluster_subplot int4 10 √ null

If this plot is a candidate to be a permanent monitoring plot, its ordinal position from 1 to 4 in the 4-plot cluster. 1=southwest, 2=southeast, 3=northeast, 4=northwest.
is_available bool 1 true

Indexes

Constraint Name Type Sort Column(s)
monitoring_plots_pkey Primary key Asc id
monitoring_plots_planting_subzone_id_name_key Must be unique Asc/Asc planting_subzone_id + name

Check Constraints

Constraint Name Constraint
cluster_has_subplot ((((permanent_cluster IS NOT NULL) AND (permanent_cluster_subplot IS NOT NULL)) OR ((permanent_cluster IS NULL) AND (permanent_cluster_subplot IS NULL))))
subplot_is_valid (((permanent_cluster_subplot >= 1) AND (permanent_cluster_subplot <= 4)))

Relationships

Close relationships within degrees of separation