Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| observation_id | int8 | 19 | null |
|
|
||||||
| stratum_id | int8 | 19 | √ | null |
|
|
|||||
| stratum_history_id | int8 | 19 | null |
|
|
||||||
| total_live | int4 | 10 | null |
|
|
||||||
| total_dead | int4 | 10 | null |
|
|
||||||
| total_existing | int4 | 10 | null |
|
|
||||||
| permanent_live | int4 | 10 | null |
|
|
||||||
| survival_rate | int4 | 10 | √ | null |
|
|
|||||
| survival_rate_std_dev | int4 | 10 | √ | null |
|
|
|||||
| plant_density | int4 | 10 | √ | null |
|
|
|||||
| plant_density_std_dev | int4 | 10 | √ | null |
|
|
|||||
| survival_rate_area | numeric | 0 | √ | null |
|
|
Total area in hectares of substrata whose observation results contributed to the survival rate. |
||||
| observed_density | int4 | 10 | √ | null |
|
|
Plant density (plants per hectare) based only on the plots observed in this observation, without carrying forward last-observed data for substrata that were not observed. |
||||
| needs_recalculation | bool | 1 | false |
|
|
If true, this row and the species totals for the same observation and scope are stale and will be rebuilt by the observation results recalculation job. Existing values are the last computed ones. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| observation_stratum_results_pkey | Primary key | Asc/Asc | observation_id + stratum_history_id |
| observation_stratum_results_observation_id_idx | Performance | Asc | observation_id |
| observation_stratum_results_stratum_id_idx | Performance | Asc | stratum_id |