Revision 13101
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql | ||
|---|---|---|
| 72 | 72 |
|
| 73 | 73 |
-- _specimens_11_list_of_three_standard_political_divisions |
| 74 | 74 |
SELECT DISTINCT place.country, |
| 75 |
place.stateprovince, |
|
| 75 |
place.stateprovince AS "stateProvince",
|
|
| 76 | 76 |
place.county |
| 77 | 77 |
FROM place |
| 78 | 78 |
WHERE (place.source_id = ( SELECT source_by_shortname((:datasource)::text) AS source_by_shortname)); |
| ... | ... | |
| 94 | 94 |
WHERE (taxonoccurrence.source_id = ( SELECT source_by_shortname((:datasource)::text) AS source_by_shortname)) |
| 95 | 95 |
GROUP BY ( SELECT party.fullname |
| 96 | 96 |
FROM party |
| 97 |
WHERE (party.party_id = taxonoccurrence.collector_id)), specimenreplicate.collectionnumber, aggregateoccurrence.collectiondate
|
|
| 97 |
WHERE (party.party_id = taxonoccurrence.collector_id)), specimenreplicate.collectionnumber, (aggregateoccurrence.collectiondate)::text
|
|
| 98 | 98 |
ORDER BY ( SELECT party.fullname |
| 99 | 99 |
FROM party |
| 100 |
WHERE (party.party_id = taxonoccurrence.collector_id)), specimenreplicate.collectionnumber, aggregateoccurrence.collectiondate;
|
|
| 100 |
WHERE (party.party_id = taxonoccurrence.collector_id)), specimenreplicate.collectionnumber, (aggregateoccurrence.collectiondate)::text;
|
|
| 101 | 101 |
|
| 102 | 102 |
-- _specimens_13_count_of_all_verbatim_and_decimal_lat_long |
| 103 | 103 |
SELECT ( SELECT count(*) AS count |
Also available in: Unified diff
validation/aggregating/specimens/qualitative_validations_specimens.sql: updated to DB