Project

General

Profile

« Previous | Next » 

Revision 12598

bugfix: schemas/vegbien.sql: _plots_10a_aggregate_observation_individual_counts: need to use taxonoccurrence.sourceaccessioncode, not aggregateoccurrence.sourceaccessioncode, because aggregateoccurrence.sourceaccessioncode is not populated

View differences:

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