STA Query Examples

OSE Pods

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

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

Get the first page (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 (1000) of Locations with the county De Baca, 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 (1000) of Things the 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 (1000) of Locations in De Baca county that have associated Things 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'

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