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

Compare with Current View Page History

« Previous Version 11 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

column namedefinition
sourceName of Institution that provides the data
nameName of sensor provided by source.  If no name is provided by the source, naming convention applied in parser.
locationDescription of the location of the sensor provided by source.  
max_end_timeTimestamp of most recent datapoint
min_start_timeTimestamp of first chronological datapoint


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