topic Re: Selection Widget for SFV2.2 (with a query builder) in ArcGIS Viewer for Flex Questions

Selection Widget for SFV2.2 (with a query builder)

MarkHoyland — Mon, 21 Feb 2011 19:55:25 GMT

The Selection widget has a "Select by Attributes" and "Select by Location" option similar to ArcGIS.
It has options where you can set your selection type eg New Selection, Add to Selection, Remove from Selection.
Select from multiple layers that interstect/contain etc another layer.
You can view the results for each layer in a datagrid, and export to tab delimited text file.

Widget link: http://www.arcgis.com/home/item.html?id=20ed6af9ab204548bbf092d51b51fef8

I built this because it seemed like a fun project and the temptation of a Flex a Widget T-shirt was too much to resist.:o

If you download please leave feedback and rate the widgets (this should apply to any widget you download) as the feed back really helps to know what users are after.

Re: Selection Widget for SFV2.2 (with a query builder)

JeffLegato — Thu, 24 Feb 2011 18:22:44 GMT

Mark,
Great widget! I am in the process of configuring it now and am having trouble getting the results to display in the grid. I can successfully run a query and zoom to the selected features but my selection results table remains empty although when I hover over the table the information is highlighted on the map and I can click on the table results and the map zooms to that item. Any ideas?

Also can I configure an alias for the fields?

Thanks!

Re: Selection Widget for SFV2.2 (with a query builder)

MarkHoyland — Thu, 24 Feb 2011 18:44:27 GMT

Jeff,
"when I hover over the table the information is highlighted on the map"
So you can see the attribute data in the infowindow? Is this for all of your layers or just one.
Is the data you are querying available external so I can have a look.
Could you post your SelectionWidget.xml file.

Alias are net set up for this widget.

Re: Selection Widget for SFV2.2 (with a query builder)

JeffLegato — Sat, 11 Dec 2021 21:07:43 GMT

I can see the attribute data in the info widow. Sorry, this app is internal so I can't share it with you but you can see the screenshot...

https://picasaweb.google.com/lh/photo/MRAgqqb33p2IAU0QMogAXg?feat=directlink

<?xml version="1.0" ?>
<configuration>
    <layers>
        <layer>
            <name>Parcels</name>
            <url>http://pacific/ArcGIS/rest/services/Planning/SLOCO_Parcels_CD_LU/MapServer/0</url>
            <titlefield>SLOCO.SDE.SLO_PARCEL_CD_LU.APN</titlefield>
            <linkfield>SLOCO.SDE.PLN_Tidemark_pmt.link</linkfield>
            <fields>
                  <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.APN"/> 
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.ASSESSEE" alias="Assessee"/> 
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.C_O"/>
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.ADDRESS_1"/>
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.CITY"/>
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.STATE"/>
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.ZIP"/>
    <field name="SLOCO.SDE.PLN_Tidemark_pmt.link"/>
            </fields>
 <infowindowfields>
                   <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.APN"/> 
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.ASSESSEE" alias="Assessee"/> 
    <field name="SLOCO.SDE.PLN_Tidemark_pmt.link"/>
   </infowindowfields>
        </layer>
       
    </layers>
    <zoomscale>5000</zoomscale>
    <info>widgets/InfoTemplates/InfoPopupWidget.swf</info>
</configuration>

Re: Selection Widget for SFV2.2 (with a query builder)

DanielOchoa — Thu, 24 Feb 2011 21:39:41 GMT

Mark,

I'll echo the previous - great widget....and I see you are sharing Robs code. Collaboration is one of the keys to success....

Now, just putting it out there....combine the graphical selection tools (circle, square,line, etc) of Rob's eSearch with your query search parameters= perfect search tool!

~ D

Re: Selection Widget for SFV2.2 (with a query builder)

MarkHoyland — Thu, 24 Feb 2011 22:35:42 GMT

Jeff,
I think this might be to do with the fully qualified field names. eg SLOCO.SDE.SLO_PARCEL_CD_LU.APN instead of APN
I am guessing you are doing this because your link field is from a different featureclass?
The intended use is that all the fields come from the same featureclass.(layer in the .xml config)
Your link field should be a field in the SLO_PARCEL_CD_LU layer.
Is the link the same for all parcels or different?

Test out your layer without the link field and without the fully qualified names and see if that works.

Re: Selection Widget for SFV2.2 (with a query builder)

MarkHoyland — Thu, 24 Feb 2011 22:55:47 GMT

Hi Daniel,
The widget is based on the FlexViewer's built in search widget, with the addition of Robert's unionGeom function. That function is brilliant as it is client side and so quick. It is definately worth looking at what others have done and reusing there work (if permitted of course).

I did think about including graphical selection tools but there were a few widgets that already did this sort of thing, so I decided against it.

But yes a select by Graphic option like ArcGIS would be good.
I will see about adding one.
(I am also happy to include contributions and enhancements from others.)

Re: Selection Widget for SFV2.2 (with a query builder)

JeffLegato — Fri, 25 Feb 2011 14:08:53 GMT

Test out your layer without the link field and without the fully qualified names and see if that works.

Yep, that did the trick. Thanks for the help!

That link field is unique but based on the APN so I'll have to experiment a little and see what I can do.

So my suggestions for improvements would be to allow aliases and fully qualified fields so that you can use joined tables. 😉

Seriously though, thanks for all the work you put into these things. My application would be severely lacking if it were not for people like yourself and Robert.

Re: Selection Widget for SFV2.2 (with a query builder)

MarkHoyland — Mon, 28 Feb 2011 20:14:14 GMT

Sertact(February 24, 2011)
Great widget. Many thanks for the great job. A small question. When make the selection and the results are returned. The results are not displayed at their correct locations on the map. When I double click from the grid it kind of centers the correct location for that record but again all the others are not displayed correctly. My map service and map are at the same datum which is WGS84. One other thing at your SelectionWidgetUtil.as I realized that you add/subtract 5000 to get the graphic extent of the records selected. I think this value is a bit high if one is using Decimal degrees with wgs84 datum. Any suggestions for these. Many thanks again.

Sertact,
The results are returned as a featurelayer which is a direct representation of the GIS data. If it is not in the correct place it sounds like some sort of projection issue?? If you put the base map that you are using with this widget into ArcGIS and overlay your data on top of it, does it line up correctly. Is your data available externally?

The zoom function in SelectionWidgetUtil.as is copied from one of my other projects which is using projected data. The 5000 was for metres (5 kilometres) So for decimal degrees it would be a bit high. I will update this at some stage (maybe use pan to point xy instead).

Re: Selection Widget for SFV2.2 (with a query builder)

SertaçTAKIL — Tue, 01 Mar 2011 07:43:39 GMT

Sertact,
The results are returned as a featurelayer which is a direct representation of the GIS data. If it is not in the correct place it sounds like some sort of projection issue?? If you put the base map that you are using with this widget into ArcGIS and overlay your data on top of it, does it line up correctly. Is your data available externally?

The zoom function in SelectionWidgetUtil.as is copied from one of my other projects which is using projected data. The 5000 was for metres (5 kilometres) So for decimal degrees it would be a bit high. I will update this at some stage (maybe use pan to point xy instead).

Sorry my data is not publicly available. Yes they do line up in ArcGIS. All my service layers are of WGS84 datum with decimal degrees. The strange thing is they are at their right place but the icons that indicate their places are at the wrong place. When I click to a result from the result list it zooms to that feature correctly, and puts the icon to the correct location for that record (and for some others that are close to that feature). But when I pan or zoom in/out I see that the icons for the other results are at the wrong places. Can it be some kind of a refresh issue? I wonder.

That's what I thougt with the zoom issue. no problem with that ridght now.
Thanks for the answer.

Re: Selection Widget for SFV2.2 (with a query builder)

MarkHoyland — Sat, 11 Dec 2021 21:07:45 GMT

KDAGIS(March 4, 2011)
I really like this widget, thank you! I have one issue. The layers that I have specified to be in the query drop down list get added to the layers I have listed under my More... button. Even though they are already there. So I wind up then having each layer listed twice under my More... button. I've looked around in the code but haven't identified what code I could take out to make it not add the layers to the More.. button.

Nice pickup, I have looked into this and it seems to be a "feature" of TOC component in the MapSwitcher Widget.
TOC.as in com.esri.viewer.components.toc has en event listener on the map for MapEvent.LAYER_ADD.
It automatically adds the FeatureLayers to the TOC when the map fires the event.

There is a workaround however. In the MapSwitcher.xml file you can tell it to exclude layers.
<layerlist visible="true">
<excludelayer>Louisville Police Facilities</excludelayer>
<excludelayer>Counties</excludelayer>
<excludelayer>States</excludelayer>
</layerlist>

Edit:
Here is a fix for the issue. (Ignore the above workaround.)
Add this listener to the init() function in the SelectionWidget.mxml file. Just add as the first line in init()

private function init():void
{
 map.addEventListener(MapEvent.LAYER_ADD, onLayerAdd, false, 100);

The 100 at the end of the listener gives the listener a high priority.

Add the function in the SelectionWidget.mxml file.

private function onLayerAdd(event:MapEvent):void
{
 event.stopImmediatePropagation();
}

This will stop the TOC.as from being notified that a layer was added to the map.
I will update the source code and recompile on the download page when I get a chance.

Re: Selection Widget for SFV2.2 (with a query builder)

KellyEmmons — Tue, 08 Mar 2011 13:17:21 GMT

Perfect, thanks! I also had to add:

import com.esri.ags.events.MapEvent;

And that fixed the issue. Again, this is a great widget. Thanks!

Re: Selection Widget for SFV2.2 (with a query builder)

AdamRepsher — Wed, 16 Mar 2011 17:57:09 GMT

Hi Daniel,
The widget is based on the FlexViewer's built in search widget, with the addition of Robert's unionGeom function. That function is brilliant as it is client side and so quick. It is definately worth looking at what others have done and reusing there work (if permitted of course).

I did think about including graphical selection tools but there were a few widgets that already did this sort of thing, so I decided against it.

But yes a select by Graphic option like ArcGIS would be good.
I will see about adding one.
(I am also happy to include contributions and enhancements from others.)

Mark,
First - Great Widget! This is what I have been searching for!

I would love it if you did add on a select by graphic. Yes, others have done it, but not with anything like the full query builder and spatial select that you have created! 🙂

Cheers!
--Adam

Re: Selection Widget for SFV2.2 (with a query builder)

DanielOchoa — Tue, 22 Mar 2011 18:20:02 GMT

Mark,

Interesting problem here....when using your Selection Widget in a flexviewer where Robert Scheitlin's TOC widget is open, the TOC widget populates with whatever layers are placed into the Selection Widget XML.

Example - Say I have layer one, layer two and layer three in the drop down of the Selection Widget. The selection widget is not set to preload, but the TOC widget is, and lists, say, 3 map services. If I then activate the Selection Widget, as soon as it opens, the TOC widget then lists layer one, layer two and layer three right above the map services in the TOC, and has them turned on. Unchecking them does nothing - the layer visibility of these additions is not controlled from here. They persist even if the selection widget is turned off. The only way to remove them from the TOC wdiget window is to restart the viewer. So, the addition of these layers to the TOC dont cause any issues, but can be confusing for a potential user to see.

My question - is there any way to prevent or fix it so this doesnt happen?

Thanks

Re: Selection Widget for SFV2.2 (with a query builder)

MarkHoyland — Tue, 22 Mar 2011 20:01:03 GMT

Interesting problem here....when using your Selection Widget in a flexviewer where Robert Scheitlin's TOC widget is open, the TOC widget populates with whatever layers are placed into the Selection Widget XML.

Please see above fix in this thread to KDAGIS on the 03-07-2011 02:58 PM, as it sounds like the same thing is happening. I will update the source code on the download page with this fix.

Re: Selection Widget for SFV2.2 (with a query builder)

LisaArnold — Wed, 23 Mar 2011 15:14:58 GMT

Hi Mark,

Thanks for the great widget. I had a couple questions for you.

On the Select by Attribute tab, not all of my unique values for each field are loading. Is there a limit to how many unique values it will load? If not, do you have a suggestion of what I might check to resolve this issue?

I am using the widget on data that doesn't turn on until 1:577,791. If I use the widget zoomed out, where some of my other layers are turned on at 1:4,622,324, the tool returns results but does not draw the highlighting. The selected features are only highlighted/drawn if I am zoomed into the level that the actual layer comes on. Since the widget draws the selection in what I think is a graphics layer it is very fast, so i would like it to show up at the zoomed out scale even though the actual map service layer won't draw until the user zooms to a feature. Is there a way to make this happen?

Thanks for your help!

Re: Selection Widget for SFV2.2 (with a query builder)

francescodi_vito — Thu, 24 Mar 2011 12:12:43 GMT

hy guys, I downloaded this widget and it's great.
But i have a problems with one field of my map service. the field is set on YES/NO, and when i run the selct by attribute for the YES value all it's ok, but when i set the select for NO value i have a #1009 error and say me that "TypeError: Error # 1009: Can not access a property or method of a null object reference." but but despite this i have a result on a map.
Why?
help me

Re: Selection Widget for SFV2.2 (with a query builder)

City_of_Port_Angeles_GIS — Thu, 24 Mar 2011 20:50:47 GMT

Mark,
I seem to be having the same type of problem that Sertac TAKIL was having. When I run a query on just a few point items, the icons show at the correct places. But if I run a query with a lot of point items, the icons are incorrectly placed. This seems to happen only with point data. My polygon data(e.g. Parcels) do not display this behavior. Here is a little bit of oddness associated with this behavior: when the query builder first returns the queried items the basemap flips upside-down then right-side up. The icons are being placed on the upside-down map so when the map flips right-side up the icons are incorrectly placed. Any idea what could be causing this? I am using ArcServer 9.3.1 and FlexViewer 2.2. My site is intended for our utility crews and in-house staff so is not publicly available. Any help would be appreciated.
Thanks,
Billy

Re: Selection Widget for SFV2.2 (with a query builder)

MarkHoyland — Sat, 11 Dec 2021 21:07:48 GMT

Lisa,
List not showing all unique values is to do with an ArcGIS Server setting which controls the amount of features allowed to be returned. The setting can be changed in the server. See the comments on the page where you can download the Selection widget as there is an answer in one of the comments.
I am also currently investigating the paging method to retreive the result as this will get all results regardless of the setting. (One of the esri samples uses paging.)

As for the scale issue,the results are returned to a flex featurelayer, which is similar to a graphicslayer, but the featurelayer is based on the actual layer in the msd/mxd. The scale dependant setting is inherited from the mxd/msd.
There is a minscale, maxscale property that can be set for the featurelayer, so yes what you want can be done.

If you want to add this yourself for all layers you can add the two lines in bold below to the init() function in SelectionWidget.MXML.
I will however add this functionality as a configurable option when I get a chance to update the source code.

for (var i:int = 0; i < lyrList.length(); i++)
{
 var lyrURL:String = lyrList.url;
 var lyrLabel:String = lyrList.name;
 
 var featureLayer:FeatureLayer = new FeatureLayer(lyrURL);
 featureLayer.name = lyrLabel;
 featureLayer.minScale = 0;
 featureLayer.maxScale = 0;
 featureLayer.addEventListener(LayerEvent.LOAD, featureLayer_loadHandler);
}

Re: Selection Widget for SFV2.2 (with a query builder)

MarkHoyland — Fri, 25 Mar 2011 00:53:00 GMT

francesco,
Is your data available to the public?
Is this a text field that has a value of YES/NO ?
If you can run the code from within flashbuilder can you post the full error message or the line that the error occurs on.