Skip to end of metadata
Go to start of metadata

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

Compare with Current View Page History

« Previous Version 10 Current »

Below are the two valid upload formats and example files. The supported file formats are YAML and CSV. The required columns are listed in Table 1. CSV Columns

Controlled Vocabulary API

http://cv.newmexicowaterdata.org/cv

Table 1. 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 waterdata.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

  • No labels