You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

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'}}}

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
  • Needed?
    • data dictionary
  • No labels