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. |
| observation_plot_statuses | 1 | 0 | 2 | -1 | Table | (Enum) The status of an observation plot. |
| planting_site_populations | 0 | 2 | 4 | -1 | Table | Total number of plants of each species in each planting site. |
| 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. |
| 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. |
| 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. |
| 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. |
| stratum_histories | 1 | 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. |
| observed_plot_species_totals | 0 | 4 | 12 | -1 | Table | Aggregated per-monitoring-plot, per-species totals of plants recorded during observations. |
| strata | 7 | 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_media_files | 0 | 7 | 7 | -1 | Table | Observation-specific details about a photo or video of a monitoring plot. Generic metadata is in the |
| 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. |
| planting_site_histories | 3 | 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. |
| 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. |
| observation_biomass_quadrat_species | 0 | 10 | 5 | -1 | Table | Herbaceous species at each quadrat of a monitoring plot of a biomass observation |
| planting_sites | 12 | 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. |
| 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. |
| observed_plot_coordinates | 0 | 5 | 5 | -1 | Table | Observed GPS coordinates in monitoring plots. Does not include photo coordinates or coordinates of recorded plants. |
| recorded_plant_statuses | 1 | 0 | 2 | -1 | Table | (Enum) Possible statuses of a plant recorded during observation of a monitoring plot. |
| mangrove_tides | 1 | 0 | 2 | -1 | Table | (Enum) High/Low tide at a mangrove during an observation. |
| observed_site_species_totals | 0 | 4 | 12 | -1 | Table | Aggregated per-planting-site, per-species totals of plants recorded during observations. |
| tree_growth_forms | 1 | 0 | 2 | -1 | Table | (Enum) Growth form of each species in a biomass observation. |
| observable_conditions | 1 | 0 | 2 | -1 | Table | (Enum) Conditions that can be observed in a monitoring plot. |
| substrata | 9 | 6 | 14 | -1 | Table | Regions within strata that are a convenient size for a planting operation. Typically <10Ha. |
| 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 | 1 | 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. |
| observed_stratum_species_totals | 0 | 4 | 12 | -1 | Table | Aggregated per-stratum, per-species totals of plants recorded during observations. |
| planting_site_notifications | 0 | 2 | 5 | -1 | Table | Tracks which notifications have already been sent regarding planting sites. |
| observation_plot_conditions | 0 | 3 | 3 | -1 | Table | List of conditions observed in each monitoring plot. |
| observed_substratum_species_totals | 0 | 4 | 12 | -1 | Table | Aggregated per-substratum, per-species totals of plants recorded during observations. |
| deliveries | 3 | 5 | 9 | -1 | Table | Incoming deliveries of new seedlings to a planting site. Mostly exists to link plantings and nursery withdrawals. |
| 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. |
| observation_biomass_quadrat_details | 3 | 5 | 4 | -1 | Table | Details of a biomass observation at each quadrat of a monitoring plot. |
| 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. |