Trouble selecting on a date field

Question

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?

JosephElfelt1 · Answer

Thanks but that does not solve my problem.

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

RandyBurton · Answer

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

JosephElfelt1 · Answer

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