Upload Formats

Controlled Vocabulary APi

http://cv-dot-waterdatainitiative-271000.appspot.com/cv

CSV Columns

Column Name	Type	Description
location	string	name of the location
lat	float	latitude in decimal degrees
lon	float	longitude in decimal degrees
location_description	string	optional
thing	string
thing_description	string	optional
sensor	string
sensor_description	string	optional
datastream	string
datastream_description	string	optional
datastream_units	CV_string
observed_property	string
observed_property_description	string	optional
phenomenonTime	ISO 8601
result	float/string/boolean/int

waterdata.csv example

location, lat, lon, location_description, thing, thing_description,sensor, sensor_description, phenomenonTime, result, datastream, datastream_description, datastream_units, observed_property, observed_property_description
foo, 34.23, -105.75, well, water level, water level description, transducer, diver sensor, 2010-01-01T01:00:00.000Z, 10, dbs, depth below surface,foot, bgs, calculated water depth below ground surface
foo, 34.23, -105.75, well, water level, water level description, transducer, diver sensor, 2010-01-01T11:00:00.000Z, 11, dbs, depth below surface,foot, bgs, calculated water depth below ground surface
foo, 34.23, -105.75, well, water level, water level description, transducer, diver sensor, 2010-01-01T12:00:00.000Z, 12, dbs, depth below surface,foot, bgs, calculated water depth below ground surface
foo, 34.23, -105.75, well, water level, water level description, transducer, diver sensor, 2010-01-01T01:00:00.000Z, 10, dbs, depth below surface,foot, bgs, calculated water depth below ground surface
bar, 34.35, -105.12, well, water level, water level description, transducer, diver sensor, 2010-01-01T11:00:00.000Z, 11, dbs, depth below surface,foot, bgs, calculated water depth below ground surface
bar, 34.35, -105.12, well, water level, water level description, transducer, diver sensor, 2010-01-01T12:00:00.000Z, 12, dbs, depth below surface,foot, bgs, calculated water depth below ground surface

waterdata.yml specification

location:
  geometry: Geojson_geometry
  name: float
  description: str
sensor:
  name: str
  description: str
  metadata: str
thing:
  name: str
  description: str
  properties: YAML object
observed_property: 
  name: str
  description: str
  definition: str
datastream:
  name: str
  unitOfMeasurement: CV_str
  description: str
  observationType: CV_str
observations:
  - isotimestamp, float|bool|str

Example upload.yml file

location:
  name: NM-0000
  geometry:
    type: Point
    corrdinates: 
     - -106.76
     - 34.52
  description: WELL
sensor:
  name: DO-131d-31324
  description: Diver pressure transducer
  metadata: http://diver.com/link_to_transducer.pdf
thing:
  name: GroundWaterLevel
  description: NMBGR Groundwater Monitoring Network
observed_property:
  name: Depth below ground surface
  description: continuous pressure transducer measurement of groundwater head
datastream:
  name: Depth Below Surface
  description: calculated depth below ground surface. calibrated to manual measurements
  unitOfMeasurement: foot
  observationType: double
observations:
  - 2020-01-10T00:00:00.000Z,  10.0
  - 2020-01-10T01:00:00.000Z,  11.0
  - 2020-01-10T02:00:00.000Z,  10.4