Using the STORET Values database on disrupter
Some SQl Queries
select * from variables where
variablename like '%choice%'
2004 - Lake Physical Appearance (choice list) EPA:14485-1
4050 - hydrograph limb EPA:273-1
1123 - EPA:151-1 Fish Kill, severity (choice list) EPA:151-1
3768 EPA:243-1 NULL Flow, stream stage (choice list)1591 EPA:16327-1 NULL Depth, Secchi Disk Depth (Choice List)Categorical/Text Data
Always says on bottom
select * from datavalues where
variableid = 2004
Stations:
| station | variable |
|---|
| EPA:MNPCA1:01-0062 | EPA:273-1 |
| EPA:21FLSWFD:FL0228000090500 | EPA:16327-1 |
| EPA:21FLBSG:103 | EPA:16327-1 |
| EPA:21NC01WQ:G4900000 | EPA:151-1 |
Issue with WQX: No category information getting returned. Just nothing in value