Revision 12942
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql | ||
|---|---|---|
| 95 | 95 |
; |
| 96 | 96 |
|
| 97 | 97 |
CREATE VIEW _specimens_16_list_distinct_specimen_descriptions AS |
| 98 |
SELECT DISTINCT notes AS "localityDescription" |
|
| 99 |
FROM aggregateoccurrence |
|
| 100 |
WHERE aggregateoccurrence.source_id = (SELECT source_by_shortname('NY'))
|
|
| 101 |
AND notes IS NOT NULL |
|
| 98 | 102 |
; |
Also available in: Unified diff
validation/aggregating/specimens/qualitative_validations_specimens.sql: implemented _specimens_16_list_distinct_specimen_descriptions