EPA Sample Site and Codes

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:
stationvariable
EPA:MNPCA1:01-0062EPA:273-1
EPA:21FLSWFD:FL0228000090500EPA:16327-1
EPA:21FLBSG:103EPA:16327-1
EPA:21NC01WQ:G4900000EPA:151-1

Issue with WQX: No category information getting returned. Just nothing in value