STA Query Examples

OSE Pods

• Get first page (up to 1000) of Locations. Include the total count of Locations.

  • https://ose.newmexicowaterdata.org/FROST-Server/v1.1/Locations?$count=True

• Get the first page (up to 1000) of Locations with the county code DB, ordered by descending id

  • https://ose.newmexicowaterdata.org/FROST-Server/v1.1/Locations?$count=True&$orderby=id desc&$filter=properties/county_code eq 'DB'

• Get the first page (up to 1000) of Locations De Baca county, ordered by descending id

  • https://ose.newmexicowaterdata.org/FROST-Server/v1.1/Locations?$count=True&$orderby=id desc&$filter=properties/county eq 'De Baca'

• Get the first page (up to 1000) of Things that have Permit status. Include associated Locations

  • https://ose.newmexicowaterdata.org/FROST-Server/v1.1/Things?$filter=properties/status eq 'Permit'&$expand=Locations

• Get the first page (up to 1000) of Locations in De Baca county that have associated Things with Permit status

  • https://ose.newmexicowaterdata.org/FROST-Server/v1.1/Locations?$filter=properties/county eq 'De Baca'&$expand=Things&$filter=Things/properties/status eq 'Permit'

• Get the first page (up to 1000) of Locations in De Baca county that have associated Things with Permit status AND a well depth less than 100 feet.

  • https://ose.newmexicowaterdata.org/FROST-Server/v1.1/Locations?$filter=properties/county eq 'De Baca'&$expand=Things&$filter=Things/properties/status eq 'Permit'&$filter=Things/properties/well_depth le 100

Outdated: 8/25/21

Retrieve all Things in CGWMN. (really all things with properties/project equal to CGWMN)

https://st.newmexicowaterdata.org/FROST-Server/v1.1/Things?$filter=properties/project eq 'CGWMN'&$orderby=name

with number of things in CGWMN

https://st.newmexicowaterdata.org/FROST-Server/v1.1/Things?$filter=properties/project eq 'CGWMN'&$orderby=name&$count=true

Retrieve all Locations and associated data

https://st.newmexicowater.data.org/FROST-Server/v1.1/Locations?$expand=Things/Datastreams/Sensor