Versions Compared

Version Old Version 3 New Version Current
Changes made by

Jake Ross

Jake Ross

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

These are literals. Meaning that it is literally the value stored for that field. For example the value for a Thing/name is Water Well and the Description is Well drilled or set into subsurface for the purposes of pumping water or monitoring groundwater

Items in <> are field names in the source dataset, i.e. g crosswalk.

Items in italics are literals

...

SensorThings Entity

...

Name

...

Description

...

NMBGMR

...

CABQ

...

Location

...

<PointID>

...

<loc_name>

...

Thing

...

Water Well

...

Datastream

...

Ground Water Levels

...

ObservedProperty

...

Depth to Water Below Land Surface

...

depth to water below land surface

...

Sensor

...

Pressure

...

Continuous measurement of groundwater depth by pressure transducer

...

Sensor

...

Acoustic

...

crosswalk. These are dynamically filed when actually saving data to ST. For example the value for a Location/name is not a static value; each Location has a different name. Therefore for my convenience Im listing the field name from the source dataset.

<?>= field name TBD

PODS

example Location. https://ose.newmexicowaterdata.org/FROST-Server/v1.1/Locations(243429)

example Thing. https://ose.newmexicowaterdata.org/FROST-Server/v1.1/Things(243429)

SensorThings Entity

Name

Description

Properties (additional metadata associated with each entity)

Example

Location

<pod_basin>.<pod_nbr>.<pod_suffix>

?

elevation: <elevation>

county: <county>

legal: <legal>

grant: <grant>

block: <blk>

nm_plane_zone: <zone>

plss_township_id: <tws>

plss_range_id: <rng>

plss_sec: <sec>

"county": "De Baca",
"plss_sec": "04",
"elevation": 0.0,
"county_code": "DB",
"plss_range_id": "24E",
"plss_township_id": "04N"

Thing

POD

Point of Diversion

use_code: <use_>

use: <use_description>

use_of_well: <use_of_wel>

casing_size: <casing_siz>

groundwater_source: <groundwater_source_description>

groundwater_source_code: <grnd_wtr_s>

surface_source: <surface_source_description>

surface_source_code: <surface_co>

pod_status_code: <pod_status>

pod_status:<pod_status_description>

status_code: <status>

status: <status_description>

well_drill_start_date: <start_date>

well_drill_finish_date: <finish_dat>

well_plug_date: <plug_date>

well_proof_of_completion_date: <pcw_rcv_date>

well_depth: <depth_well>

pump_type: <pump_type>

aquifer: <aquifer>

well_tag: <well_tag>

static_level: <static_level>

"use": "72-12-1 domestic and livestock watering",
"status": "Permit",
"use_code": "DOL",
"well_tag": "20DB7",
"pod_status": "Pending",
"well_depth": 0.0,
"casing_size": 0.0,
"status_code": "PMT",
"static_level": 0.0,
"well_plug_date": "NaN",
"percent_shallow": 0.0,
"pod_status_code": "PEN",
"surface_source_code": 0.0,
"well_drill_start_date": "NaN",
"well_drill_finish_date": "NaN",
"well_proof_of_completion_date": "NaN"

Location Fields

type

Point

X

<easting>

Y

<northing>

Zone

<utm_zone>

All PODs fields

L= property of Location

T=property of Thing

Code Block
  OBJECTID_1 
  OBJECTID
L pod_basin
L pod_nbr
L pod_suffix
  ref
  pod_name
L tws
L rng
L sec
  qtr_4th
  qtr_16th
  qtr_64th
L blk
L zone
  x
  y
L grant_
L legal
L county
T start_date
T finish_dat
T plug_date
T pcw_rcv_da
T elevation
T depth_well
T grnd_wtr_s
  percent_sh
  depth_wate
  log_file_d
  sched_date
T use_of_wel
T pump_type
  pump_seria
  discharge
T aquifer
  sys_date
  subdiv_nam
  subdiv_loc
  restrict_
  lat_deg
  lat_min
  lat_sec
  lon_deg
  lon_min
  lon_sec
T surface_co
  estimate_y
T pod_status
T casing_siz
  ditch_name
T utm_zone
T easting
T northing
  datum
  utm_source
  utm_accura
  xy_source
  xy_accurac
  lat_lon_so
  lat_lon_ac
  tract_nbr
  map_nbr
  surv_map
  other_loc
  pod_rec_nb
  cfs_start_
  cfs_end_md
  cfs_cnv_fa
  cs_code
  wrats_s_id
  utm_error
L pod_sub_ba  #
T well_tag
T static_lev
  pod_file
  basin
  nbr
  suffix
  sub_basin
  status
T use_
T total_div  #not yet added
  sub_file
  sum_rec_nb
  sf_header
  db_file
  own_lname
  own_fname
  addr1
  addr2
  city
  state
  zip
  contact_ln
  contact_fn
  nmwrrs_wrs
  in_state
  podlocdate
  loc_error
  wr_count
  replaced
  GlobalID

Groundwater Levels

NMBGMR Groundwater Levels

SensorThings Entity

Name

Description

Properties (additional metadata associated with each entity)

Location

<PointID>

Location of well where measurements are made (in this case groundwater level measurement below land surface)

AltDatum: <AltDatum>

Altitude: <Altitude>

AltSource: <Location.AltitudeMethod><LU_AltitudeMethod>

Agency: NMBGMR

Thing

Water Well

Well drilled or set into subsurface for the purposes of pumping water or monitoring groundwater

WellDepth: <WellData.WellDepth>

GeologicFormation: <WellData.FormationZone>

ScreenIntervals: [{ScreenTop: <WellScreens.ScreenTop>

ScreenBottom: <WellScreens.ScreenBottom>

ScreenDescription: <WellScreens.ScreenDescription>}]

Agency: NMBGMR

Use: <LU_CurrentUse.Meaning>

Status: <LU_Status.Meaning>

Datastream

Groundwater Levels

Measurement of groundwater depth in a water well, as measured below ground surface

Agency: NMBGMR

MeasuringPointHeightRelativeToGroundSurface:

MeasuringPointHeightRelativeToGroundSurfaceUnits:

MeasuringPointHeightRelativeToGroundSurfaceDescription:

QualityControlled:

ObservedProperty

Depth to Water Below Ground Surface

Depth to water below ground surface

Sensor

Pressure

Continuous (periodic automated) measurement depth to water in Feet below ground surface (converted from pressure reading from depth below ground surface in feet). Not Provisional. Quality Controlled

Agency: NMBGMR

Sensor

Acoustic

Continuous (periodic automated) measurement depth to water in Feet below ground surface (converted from acoustic device). Not Provisional. Quality Controlled

Agency: NMBGMR

Sensor

Manual

Manual measurement of groundwater depth by

field technician

Sensor

<>

Analytical Chemistry

steel tape, electronic probe or other

Agency: NMBGMR

Manual Observations resultQuality: {'DataQuality': <LU_DataQuality.Meaning> }

parameters: {'MeasurementMethod': <LU_MeasurementMethod.Meaning>,

'DataSource': ...,

'LevelStatus':...,

'MeasuringAgency':...}

Location Fields

type

Point

X

<easting>

Y

<northing>

Zone

12

CABQ Ground Water Levels

SensorThings Entity

Name

Description

Properties (additional metadata associated with each entity)

Location

<loc_name>

Site where measurements are made

Agency: CABQ

Thing

Water Well

Well drilled or set into subsurface for the purposes of pumping water or monitoring groundwater

Agency: CABQ

Datastream

Ground Water Levels

Measurement of static groundwater depth in a water well, as measured below land surface

Agency: CABQ

ObservedProperty

Depth to Water Below Land Surface

depth to water below land surface

Sensor

<?>

<?>

Analytical Chemistry

NMBGMR chem

SensorThings Entity

Name

Description

Properties (additional metadata associated with each entity)

Location

<PointID>

Site where measurements are made

Thing

Water Well

Datastream

Analytical Chemistry

Agency: NMBGMR

Location

<PointID>

ObservedProperty

Ca

Calcium

ObservedProperty

Na

Sodium

ObservedProperty

TDS

Total Dissolved Solids

ObservedProperty

Sensor

CABQ Analytical Chemistry

SensorThings Entity

Name

Description

Properties (additional metadata associated with each entity)

Location

<loc_name>

Site where measurements are made

Thing

Water Well

Datastream

Analytical Chemistry

Agency: CABQ

ObservedProperty

Ca

Calcium

ObservedProperty

Na

Sodium

ObservedProperty

TDS

Total Dissolved Solids

ObservedProperty

?

?

Sensor

?

?