Open Kevin-M-Smith opened 9 years ago
postgres=# select distinct coord_acy_cd as coord_acy_cd, count(*)
from active_sites group by coord_acy_cd order by count desc;
coord_acy_cd | count
--------------+-------
S | 6198
F | 1675
U | 1069
1 | 1060
5 | 827
H | 452
M | 448
T | 298
R | 150
C | 34
| 7
D | 3
E | 3
B | 1
(14 rows)
The coord_acy_cd describes the latitude and longitude coordinate accuracy at a given site.
References
http://waterdata.usgs.gov/usa/nwis/uv?codes_help