topic Re: Problem using the LIKE operator in a query in ArcGIS REST APIs and Services Questions

Problem using the LIKE operator in a query

JosephElfelt1 — Fri, 28 Aug 2020 19:39:11 GMT

This query command works fine.

https://geodata.epa.gov/arcgis/rest/services/ORD/ROE_PercentChangeCarbonStorage/MapServer/2/query?f=GeoJSON&returnGeometry=true&outFields=*&where=CountyName LIKE 'Skagit County'

But this one with a wildcard fails.

https://geodata.epa.gov/arcgis/rest/services/ORD/ROE_PercentChangeCarbonStorage/MapServer/2/query?f=GeoJSON&returnGeometry=true&outFields=*&where=CountyName LIKE 'Ska%'

All the documentation says % is a wildcard for 0-to-many characters.

What am I doing wrong?

Re: Problem using the LIKE operator in a query

JayJohnsonWashoeCounty — Fri, 28 Aug 2020 22:27:37 GMT

Because the % sign is special in URLs, you have to use a code (i.e. escaping the character) so it knows you mean to use the % as a wildcard and not in its normal URL context.

Try this (use %25 instead of just %):

https://geodata.epa.gov/arcgis/rest/services/ORD/ROE_PercentChangeCarbonStorage/MapServer/2/query?f=GeoJSON&returnGeometry=true&outFields=*&where=CountyName LIKE 'Skag%25'

Jay

Re: Problem using the LIKE operator in a query

JosephElfelt1 — Fri, 28 Aug 2020 23:06:32 GMT

Thank you Jay

Apparently my brain cell that used to know that tidbit has died.

Joseph Elfelt