Revision 12601
Added by Aaron Marcuse-Kubitza almost 11 years ago
| validations.sql | ||
|---|---|---|
| 152 | 152 |
CREATE VIEW _plots_10a_aggregate_observation_individual_counts AS |
| 153 | 153 |
SELECT p.project_name, |
| 154 | 154 |
(pm."SiteCode")::text AS plot_code, |
| 155 |
po."PlotObsID" AS individual_id,
|
|
| 155 |
(po."PlotObsID")::text AS individual_id,
|
|
| 156 | 156 |
po."NoInd" AS individuals |
| 157 | 157 |
FROM ((projects p |
| 158 | 158 |
JOIN "plotMetadata" pm ON ((p.project_id = pm.project_id))) |
| 159 | 159 |
JOIN "plotObservations" po ON ((pm."PlotID" = po."PlotID"))) |
| 160 |
ORDER BY p.project_name, (pm."SiteCode")::text, po."PlotObsID";
|
|
| 160 |
ORDER BY p.project_name, (pm."SiteCode")::text, (po."PlotObsID")::text;
|
|
| 161 | 161 |
|
| 162 | 162 |
|
| 163 | 163 |
-- |
Also available in: Unified diff
bugfix: inputs/SALVIAS/validations.sql: _plots_10a_aggregate_observation_individual_counts: changed individual_id type to match output query