Revision 12598
Added by Aaron Marcuse-Kubitza over 10 years ago
vegbien.sql | ||
---|---|---|
7234 | 7234 |
CREATE VIEW _plots_10a_aggregate_observation_individual_counts AS |
7235 | 7235 |
SELECT p.projectname AS project_name, |
7236 | 7236 |
l.authorlocationcode AS plot_code, |
7237 |
ao.sourceaccessioncode AS individual_id,
|
|
7237 |
o.sourceaccessioncode AS individual_id, |
|
7238 | 7238 |
ao.count AS individuals |
7239 | 7239 |
FROM ((((((public.project p |
7240 | 7240 |
JOIN public.source s ON ((p.source_id = s.source_id))) |
Also available in: Unified diff
bugfix: schemas/vegbien.sql: _plots_10a_aggregate_observation_individual_counts: need to use taxonoccurrence.sourceaccessioncode, not aggregateoccurrence.sourceaccessioncode, because aggregateoccurrence.sourceaccessioncode is not populated