Database Properties
Database Type: PostgreSQL - 17.4 (Debian 17.4-1.pgdg110+2)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| plot_t0_observations | 0 | 6 | 6 | -1 | Table | Which observation to use to determine t0 plot density. |
| planting_site_populations | 0 | 2 | 4 | -1 | Table | Total number of plants of each species in each planting site. |
| biomass_forest_types | 1 | 0 | 2 | -1 | Table | (Enum) Types for forest in a biomass observation. |
| observation_plots | 10 | 8 | 15 | -1 | Table | Information about monitoring plots that are required to be surveyed as part of observations. This is not populated until the scheduled start time of the observation. |
| plantings | 0 | 10 | 10 | -1 | Table | Details about plants that were planted or reassigned as part of a delivery. There is one plantings row per species in a delivery. |
| observed_plot_species_totals | 0 | 4 | 10 | -1 | Table | Aggregated per-monitoring-plot, per-species totals of plants recorded during observations. |
| simplified_planting_site_histories | 0 | 1 | 3 | -1 | Table | Simplified boundary geometries for planting site versions. |
| observation_media_files | 0 | 7 | 7 | -1 | Table | Observation-specific details about a photo or video of a monitoring plot. Generic metadata is in the |
| simplified_substratum_histories | 0 | 1 | 2 | -1 | Table | Simplified boundary geometries for substratum versions. |
| simplified_strata | 0 | 1 | 2 | -1 | Table | Simplified boundary geometries for strata. |
| planting_site_histories | 4 | 2 | 8 | -1 | Table | Versions of planting site maps over time. Each time a planting site map changes, the new map is inserted into this table and its child tables. |
| observation_biomass_quadrat_species | 0 | 10 | 5 | -1 | Table | Herbaceous species at each quadrat of a monitoring plot of a biomass observation |
| planting_sites | 13 | 6 | 16 | -1 | Table | Top-level information about entire planting sites. Every planting site has at least one stratum. |
| recorded_plants | 0 | 7 | 8 | -1 | Table | Information about individual plants observed in monitoring plots. |
| mangrove_tides | 1 | 0 | 2 | -1 | Table | (Enum) High/Low tide at a mangrove during an observation. |
| tree_growth_forms | 1 | 0 | 2 | -1 | Table | (Enum) Growth form of each species in a biomass observation. |
| observation_media_types | 1 | 0 | 2 | -1 | Table | (Enum) Types of observation plot media. This refers to the type of thing that’s being depicted, not the content type of the media file. |
| observation_types | 1 | 0 | 2 | -1 | Table | (Enum) Type of observation, currently only used for ad hoc observations. |
| substratum_histories | 2 | 2 | 8 | -1 | Table | Versions of substratum maps over time. Each time a planting site map changes, its substrata’ maps are inserted into this table. |
| simplified_stratum_histories | 0 | 1 | 2 | -1 | Table | Simplified boundary geometries for stratum versions. |
| planting_site_notifications | 0 | 2 | 5 | -1 | Table | Tracks which notifications have already been sent regarding planting sites. |
| deliveries | 3 | 5 | 9 | -1 | Table | Incoming deliveries of new seedlings to a planting site. Mostly exists to link plantings and nursery withdrawals. |
| observation_biomass_quadrat_details | 3 | 5 | 4 | -1 | Table | Details of a biomass observation at each quadrat of a monitoring plot. |
| observation_plot_statuses | 1 | 0 | 2 | -1 | Table | (Enum) The status of an observation plot. |
| recorded_species_certainties | 5 | 0 | 2 | -1 | Table | (Enum) Levels of certainty about the identity of a species recorded in a monitoring plot observation. |
| planting_types | 1 | 0 | 2 | -1 | Table | (Enum) Type of planting associated with a delivery. Different planting types distinguish reassignments from initial plantings. |
| observation_biomass_species | 8 | 5 | 8 | -1 | Table | Herbaceous and tree species data for a biomass observation. |
| simplified_substrata | 0 | 1 | 2 | -1 | Table | Simplified boundary geometries for substrata. |
| substratum_populations | 0 | 2 | 4 | -1 | Table | Total number of plants of each species in each substratum. |
| monitoring_plots | 16 | 5 | 15 | -1 | Table | Regions within substrata that can be comprehensively surveyed in order to extrapolate results for the entire stratum. Any monitoring plot in a substratum is expected to have roughly the same number of plants of the same species as any other monitoring plot in the same substratum. |
| stratum_histories | 2 | 2 | 7 | -1 | Table | Versions of stratum maps over time. Each time a planting site map changes, its strata’ maps are inserted into this table. |
| observation_plot_positions | 4 | 0 | 2 | -1 | Table | (Enum) Positions in a monitoring plot where users can take photos or record coordinates. |
| strata | 8 | 4 | 18 | -1 | Table | Regions within planting sites that have a consistent set of conditions such that survey results from any part of the stratum can be extrapolated to the entire stratum. strata are subdivided into plots. Every stratum has at least one plot. |
| stratum_populations | 0 | 2 | 4 | -1 | Table | Total number of plants of each species in each stratum. |
| planting_seasons | 0 | 1 | 7 | -1 | Table | Start and end dates of planting seasons for planting sites. |
| observation_requested_substrata | 0 | 2 | 2 | -1 | Table | If an observation should only cover a specific set of substrata, the substratum IDs are stored here. If an observation is of the entire site (the default), there will be no rows for that observation in this table. |
| observation_biomass_details | 4 | 6 | 13 | -1 | Table | Recorded data for a biomass observation. |
| plot_t0_densities | 0 | 4 | 7 | -1 | Table | Density for a plot per species, in plants per hectare. |
| monitoring_plot_overlaps | 0 | 2 | 2 | -1 | Table | Which monitoring plots overlap with previously-used monitoring plots. A plot may overlap with multiple older or newer plots. |
| observed_plot_coordinates | 0 | 5 | 5 | -1 | Table | Observed GPS coordinates in monitoring plots. Does not include photo coordinates or coordinates of recorded plants. |
| observations | 16 | 4 | 11 | -1 | Table | Scheduled observations of planting sites. This table may contain rows describing future observations as well as current and past ones. |
| recorded_plant_statuses | 1 | 0 | 2 | -1 | Table | (Enum) Possible statuses of a plant recorded during observation of a monitoring plot. |
| observed_site_species_totals | 0 | 4 | 10 | -1 | Table | Aggregated per-planting-site, per-species totals of plants recorded during observations. |
| observable_conditions | 1 | 0 | 2 | -1 | Table | (Enum) Conditions that can be observed in a monitoring plot. |
| substrata | 10 | 6 | 14 | -1 | Table | Regions within strata that are a convenient size for a planting operation. Typically <10Ha. |
| observed_stratum_species_totals | 0 | 4 | 10 | -1 | Table | Aggregated per-stratum, per-species totals of plants recorded during observations. |
| simplified_planting_sites | 0 | 1 | 3 | -1 | Table | Simplified boundary geometries for planting sites. |
| observation_plot_conditions | 0 | 3 | 3 | -1 | Table | List of conditions observed in each monitoring plot. |
| observed_substratum_species_totals | 0 | 4 | 10 | -1 | Table | Aggregated per-substratum, per-species totals of plants recorded during observations. |
| draft_planting_sites | 0 | 7 | 13 | -1 | Table | Details of planting sites that are in the process of being defined. |
| observation_states | 1 | 0 | 2 | -1 | Table | (Enum) Where in the observation lifecycle a particular observation is. |
| recorded_trees | 0 | 7 | 14 | -1 | Table | Recorded trees or shrubs of a biomass observation. |
| stratum_t0_temp_densities | 0 | 4 | 7 | -1 | Table | Density for a stratum per species, in plants per hectare. Only applies to temporary plots and only if survival_rate_includes_temp_plots is set to true for the stratum’s planting site. |
| monitoring_plot_histories | 1 | 6 | 8 | -1 | Table | Versions of monitoring plots over time. Each time a planting site changes, its monitoring plots are added to this table. |