Revision 13047
Added by Aaron Marcuse-Kubitza about 10 years ago
| trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql | ||
|---|---|---|
| 99 | 99 |
|
| 100 | 100 |
CREATE VIEW _specimens_13_count_of_all_verbatim_and_decimal_lat_long AS |
| 101 | 101 |
SELECT |
| 102 |
( SELECT count(*) AS count
|
|
| 102 |
(SELECT count(*) AS count
|
|
| 103 | 103 |
FROM coordinates |
| 104 | 104 |
WHERE coordinates.source_id = (SELECT source_by_shortname('NY'))
|
| 105 | 105 |
AND (verbatimlatitude IS NOT NULL OR latitude_deg IS NOT NULL)) |
| 106 | 106 |
AS "allLats" |
| 107 |
, ( SELECT count(*) AS count
|
|
| 107 |
, (SELECT count(*) AS count
|
|
| 108 | 108 |
FROM coordinates |
| 109 | 109 |
WHERE coordinates.source_id = (SELECT source_by_shortname('NY'))
|
| 110 | 110 |
AND (latitude_deg IS NOT NULL)) |
| 111 | 111 |
AS "decimalLats" |
| 112 |
, ( SELECT count(*) AS count
|
|
| 112 |
, (SELECT count(*) AS count
|
|
| 113 | 113 |
FROM coordinates |
| 114 | 114 |
WHERE coordinates.source_id = (SELECT source_by_shortname('NY'))
|
| 115 | 115 |
AND (verbatimlongitude IS NOT NULL OR longitude_deg IS NOT NULL)) |
| 116 | 116 |
AS "allLongs" |
| 117 |
, ( SELECT count(*) AS count
|
|
| 117 |
, (SELECT count(*) AS count
|
|
| 118 | 118 |
FROM coordinates |
| 119 | 119 |
WHERE coordinates.source_id = (SELECT source_by_shortname('NY'))
|
| 120 | 120 |
AND (longitude_deg IS NOT NULL)) |
Also available in: Unified diff
validation/aggregating/specimens/qualitative_validations_specimens.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: fixed whitespace