topic Re: Flex Widget Help : Spatial Query in ArcGIS Viewer for Flex Questions

Flex Widget Help : Spatial Query

BrianO_keefe — Mon, 12 Jan 2015 16:20:18 GMT

I've been stepping so far away from Flex maps lately due to the Web App Builder and Javascript maps. Now I've got a map that management wants me to keep in Flex right now and add a spatial query element.

I have Council Districts (on one layer) and Incidents (each year has it's own layer). I need to create a way for Fire to query incidents by Council District. What the best widget for this?

Re: Flex Widget Help : Spatial Query

RobertScheitlin__GISP — Mon, 12 Jan 2015 16:35:57 GMT

Brian,

This is what the eSearch is designed for

Re: Flex Widget Help : Spatial Query

AnthonyGiles — Mon, 12 Jan 2015 16:39:51 GMT

Brain,

If I am reading your question correctly you want to perform a spatial query i.e. select the points from one layer that intersect with a polygon from another layer, have a look at the Roberts e-search widget that allows you to perform spatial searches from the results of another search:

http://www.arcgis.com/home/item.html?id=5d4995ccdb99429185dfd8d8fb2a513e

Regards

Anthony

Re: Flex Widget Help : Spatial Query

BrianO_keefe — Mon, 12 Jan 2015 16:41:57 GMT

Then I guess my experience with the eSearch widget is incomplete because I've never tried to do a spatial query like this with it. Is there a good example somewhere?

Re: Flex Widget Help : Spatial Query

RobertScheitlin__GISP — Mon, 12 Jan 2015 17:05:23 GMT

Brain,

Here are some steps to follow in the Live Preview Site

Leave the search layer as "Louisville Zoning" and the search layer field as "Zoning Code"
Click the search drop down list and choose "OTF" and click search.
Click the search search button at the top of the widget.
Change the buffer distance to one mile (you need to do this on the live preview site as there is no spatial search layer that is actually contained in the search result there) and click the buffer button.
Now in the search entities of drop down choose "Traffic Cameras"
Now click the "entirely contained in" button.
Choose buffer graphic. Now you have all the traffic cameras that are within on mile of the parcels that have a zoning code of "OTF".

Re: Flex Widget Help : Spatial Query

BrianO_keefe — Mon, 12 Jan 2015 17:26:37 GMT

Ok...

I see how this could work. But how do I configure this IN the widget? Is there an example? I can't wrap my head around the XML necessary to get this rolling. One working example would be perfect. I am able to deconstruct from other REST services and such... cut-n-paste would do it.

Anyone?

Re: Flex Widget Help : Spatial Query

RobertScheitlin__GISP — Mon, 12 Jan 2015 17:59:34 GMT

Brian,

I think that you are over thinking this. You just add both layers that you are interested in searching (Council Districts and Incidents) like you would any other search layer and the only difference is on Incidents layer you make sure that the spatialsearchlayer is set to true (this is what will add "Incidents" to the Spatial Search drop down list):

Re: Flex Widget Help : Spatial Query

BrianO_keefe — Mon, 12 Jan 2015 19:03:49 GMT

*facepalm*

Yup. Overthinking. My co-worker claims I do that ALOT. (I think he's right)

Of course now I'm having issues with a date search inside of one of the REST services.

I'm using...

<value prompt="Example: 1/1/2014-12:56" isvaluerequired="true">(ALARMDATE) = trime('[value]')</value>

And getting squat. I've used "ALARMDATE = '[value]'" and (ALARMDATE} LIKE ('%[value]%') and nothing is working... I'm not certain on the DATE requirements for fields in the eSearch widget so it's probably something simple... any ideas?

Re: Flex Widget Help : Spatial Query

RobertScheitlin__GISP — Mon, 12 Jan 2015 19:14:34 GMT

Brain,

There is an example of a date search in the eSearchWidget.xml

<value prompt="Example: 2012/04/16">datetime >= '[value] 00:00:00'</value>

Re: Flex Widget Help : Spatial Query

BrianO_keefe — Mon, 12 Jan 2015 21:48:03 GMT

I had already tried that and it wouldn't work with my date field. I've tried a few variants on the field and finally just gave up. I don't know why it wouldn't work.

Re: Flex Widget Help : Spatial Query

RobertScheitlin__GISP — Mon, 12 Jan 2015 21:50:24 GMT

Brian,

Is the data a true esri date field type? Is it coming from and enterprise geodatabase or etc, etc.?

Re: Flex Widget Help : Spatial Query

BrianO_keefe — Mon, 12 Jan 2015 22:04:37 GMT

ALARMDATE ( type: esriFieldTypeDate , alias: ALARMDATE , length: 36 )

Yes. It is.

Re: Flex Widget Help : Spatial Query

RobertScheitlin__GISP — Mon, 12 Jan 2015 22:14:22 GMT

Is it coming from and enterprise geodatabase or etc, etc.?

Re: Flex Widget Help : Spatial Query

BrianO_keefe — Mon, 12 Jan 2015 22:16:42 GMT

Sorry. Yes. Enterprise Geodatabase.

http://maps.cityoftulsa.org/gis/rest/services/intStarterMaps/intFire/MapServer/7‌

Re: Flex Widget Help : Spatial Query

AnthonyGiles — Mon, 12 Jan 2015 22:28:28 GMT

Robert, Brian,

Sorry to jump in, but is the following valid due to the greater than sign:

<value prompt="Example: 2012/04/16">datetime >= '[value] 00:00:00'</value>

should it not be:

<value prompt="Example: 2012/04/16">datetime >= '[value] 00:00:00'</value>

Regards

Anthony

Re: Flex Widget Help : Spatial Query

RobertScheitlin__GISP — Mon, 12 Jan 2015 23:14:21 GMT

Brian,

Here is what I got working with your data:

<value prompt="1/1/2014" isvaluerequired="true" autosubmit="true">ALARMDATE >= date'[value] 00:00:00'</value>

Re: Flex Widget Help : Spatial Query

RobertScheitlin__GISP — Mon, 12 Jan 2015 23:16:44 GMT

Anthony,

No this time it seems to be the underlying DB type required the "date" designator

Re: Flex Widget Help : Spatial Query

BrianO_keefe — Mon, 12 Jan 2015 23:30:46 GMT

I actually tried something that like. I was using "TRIM" in front of Value thinking that the user entry was padded maybe. and I researched someway to cast that variable to a date, I hadn't found the simple "DATE" command.

I am completely grateful, I get to add that field back in, but I have to ask. HOW.

Is this just DB experience, Flex experience, ArcGIS experience, or what? I would like to know how you got to that answer. If only so I can quit asking questions like this and just get to map making! lol

Thanks again...

Re: Flex Widget Help : Spatial Query

RobertScheitlin__GISP — Mon, 12 Jan 2015 23:46:29 GMT

Brain,

Well I start with getting the query to work in the REST endpoint. ArcGIS Dektop help has a great section about searching date fields. Once I knew the proper format for your services DB then it was simply plugging in the right SQL Statement in the xml.