topic Re: Trouble selecting on a date field in ArcGIS REST APIs and Services Questions

Trouble selecting on a date field

JosephElfelt1 — Sun, 26 May 2019 02:30:38 GMT

I am working with a MapServer layer that support dynamic layers. The data is tornado damage going back a number of years. My goal is to select only 2019 data.

This tile call displays all the data:

https://services.dat.noaa.gov/arcgis/rest/services/nws_damageassessmenttoolkit/DamageViewer/MapServer/export?bbox=-11767…

In order to select 2019 data I add the following dynamicLayers parameter with a definition expression:

&dynamicLayers=[{"source":{"type":"mapLayer","mapLayerId":0},"definitionExpression":"stormdate > DATE '2019-01-01'"}]

Here is the tile call with the dynamicLayers parameter added. This call displays...nothing.

https://services.dat.noaa.gov/arcgis/rest/services/nws_damageassessmenttoolkit/DamageViewer/MapServer/export?bbox=-11767633.378559455,5058296.783799826,-9001224.450862357,3957603.5764932865&size=1131,450&dpi=96&format=png24&transparent=true&bboxSR=3857&imageSR=3857&layers=show:0&f=image&dynamicLayers=[{"source":{"type":"mapLayer","mapLayerId":0},"definitionExpression":"stormdate > DATE '2019-01-01'"}]

Where did I mess up?

Re: Trouble selecting on a date field

JosephElfelt1 — Sun, 26 May 2019 12:38:19 GMT

Note that I do not want to change how the data is rendered. Instead I simply want to display a subset of the data.

Re: Trouble selecting on a date field

RandyBurton — Tue, 28 May 2019 17:24:22 GMT

Since you are making a URL request, it needs to be URL encoded. You might try:

https://services.dat.noaa.gov/arcgis/rest/services/nws_damageassessmenttoolkit/DamageViewer/MapServer/export?bbox=-11767633.378559455,5058296.783799826,-9001224.450862357,3957603.5764932865&size=1131,450&dpi=96&format=png24&transparent=true&bboxSR=3857&imageSR=3857&layers=show:0&f=image&dynamicLayers=%5B%7B%22source%22%3A%7B%22type%22%3A%22mapLayer%22%2C%22mapLayerId%22%3A0%7D%2C%22definitionExpression%22%3A%22stormdate%20%3E%20DATE%20%272019-01-01%27%22%7D%5D

See: HTML URL Encoding Reference and urlencoder.org

Re: Trouble selecting on a date field

JosephElfelt1 — Tue, 28 May 2019 19:54:01 GMT

Thanks but that does not solve my problem.

Adding url encoding does not let me select just the 2019 data.