'created': u'2018-03-23T15:48:32Z',
 u'geoType': u'Feature',
 u'geometry': {u'coordinates': [-84.44799549, 38.9203417, 0],
               u'type': u'Point'},
 u'id': 1445,
 u'max_end_time': u'2019-12-18T21:30:00Z',
 u'min_start_time': u'2007-10-01T06:00:00Z',
 u'name': u'03254520',
 u'parameters': [u'discharge-ft3s',
                 u'discharge-ft3s-qc',
                 u'dissolved-oxygen-mgl',
                 u'dissolved-oxygen-mgl-qc',
                 u'nitrate-nitrite-as-n-mgl',
                 u'nitrate-nitrite-as-n-mgl-qc',
                 u'pH',
                 u'pH-qc',
                 u'specific-conductance-uScm',
                 u'specific-conductance-uScm-qc',
                 u'turbidity-fnu',
                 u'turbidity-fnu-qc',
                 u'water-temperature-c',
                 u'water-temperature-c-qc'],
 u'properties': {u'huc': {u'huc2': {u'code': u'05'},
                          u'huc4': {u'code': u'0510'},
                          u'huc6': {u'code': u'051001'},
                          u'huc8': {u'code': u'05100101'},
                          u'huc_name': u'Licking'},
                 u'location': u'LICKING RIVER AT HWY 536 NEAR ALEXANDRIA, KY',
                 u'name': u'03254520',
                 u'online_status': u'online',
                 u'popupContent': u'03254520',
                 u'region': u'0510',
                 u'type': {u'id': u'usgs',
                           u'network': u'NWIS',
                           u'title': u'United States Geological Survey'}}}


Column Definition


Example Columns and Row

sourcenamelocationlongitudelatitudemax_end_timemin_start_timeparametershuc8huc_nameonline_status
United States Geological Survey3254520LICKING RIVER AT HWY 536 NEAR ALEXANDRIA, KY-84.44799538.92034172019-12-18T21:30:00Z2007-10-01T06:00:00Zdischarge-ft3s,
dissolved-oxygen-mgl,
nitrate-nitrite-as-n-mgl,
pH,
specific-conductance-uScm,
turbidity-fnu,
water-temperature-c,
5100101Lickingonline


Issues with Data

SourceIssuePertinence?
USGSA few locations show id instead of text
Water Quality Portal

many missing start and end time (update?)

many missing parameters


several sourcesmissing location
several sourcesmissing huc_name
several sourcesmissing online status