Typical Sensor JSON
'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'}}}
Example Columns and Row
source | name | location | longitude | latitude | max_end_time | min_start_time | parameters | huc8 | huc_name | online_status |
---|---|---|---|---|---|---|---|---|---|---|
United States Geological Survey | 3254520 | LICKING RIVER AT HWY 536 NEAR ALEXANDRIA, KY | -84.447995 | 38.9203417 | 2019-12-18T21:30:00Z | 2007-10-01T06:00:00Z | discharge-ft3s, dissolved-oxygen-mgl, nitrate-nitrite-as-n-mgl, pH, specific-conductance-uScm, turbidity-fnu, water-temperature-c, | 5100101 | Licking | online |
Issues with Data
Source | Issue |
---|---|
USGS | A few locations show id instead of text |
Water Quality Portal | many missing start and end time (update?) many missing parameters |
several sources | missing location |