Upload Formats

Example JSON upload file

{ "location": { "name": "NMWDI-$autoinc", "description": "No Description Available", "properties": { "altitude": 5495.8701171875, "altitude_accuracy": 0.5199999809265137, "altitude_datum": "NAVD88", "altitude_method": "LiDAR DEM" }, "geometry": { "type": "Point", "coordinates": [ -108.06889231646282, 36.79656589018368 ] } }, "sensor": { "name": "Steel-tape measurement", "description": "No Description Available" }, "datastream": { "name": "Depth Below Surface", "description": "manual measurements", "unitofMeasurement": "foot", "observationType": "double" }, "observed_property": { "name": "Depth below ground surface", "description": "manual measurement depth to groundwater" }, "thing": { "name": "AR-0001", "description": "Water Well", "properties": { "data_reliability": "Data field checked by reporting agency", "project": null, "organization": "NMBGMR", "organization_id": "AR-0001", "organization_key": "PointID" } }, "observations": [ "2015-08-18T00:00:00.000Z, 6.62", "2016-01-18T00:00:00.000Z, 6.36", "2016-03-15T00:00:00.000Z, 5.97", "2016-06-01T00:00:00.000Z, 4.82", "2016-10-18T00:00:00.000Z, 6.51", "2016-11-21T00:00:00.000Z, 5.96", "2017-01-24T00:00:00.000Z, 5.69", "2017-03-15T00:00:00.000Z, 5.56", "2017-06-01T00:00:00.000Z, 4.58", "2018-03-28T00:00:00.000Z, 6.31", "2018-10-11T00:00:00.000Z, 6.6", "2019-04-09T00:00:00.000Z, 5.19" ], "destination": "https://st.newmexicowaterdata.org/FROST-Server/v1.1" }

 

This information is not up to date. Upload to ST via this mechanism is only used internally.

 

 

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

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