I???m working on a project to identify sexual offenders by their alias name(s). When I do a query on an alias name it displays the master name (given name) and location. However an offender with the master name of James may have multiple alias???s like: Jim, Jimmy and Jimmie. I want to remove the duplicate results and display the master name and location only once. Can I remove the duplicates with a SQL DISTINCT statement? Does anyone have an example of a SQL DISTINCT in a query.where? I???m using ArcGIS 10 Desktop and Server. Thanks
//Loop through the QueryTask results and populate an array //with the unique values var features = results.features; dojo.forEach (features, function(feature) { zone = feature.attributes.ZONING_TYPE; if (!testVals[zone]) { testVals[zone] = true; values.push({name:zone}); } });
I have never tried using the esri.tasks.StatisticDefinition object but it looks like you might be able to use the statisticType = 'count' and then you could use the returned featureset to obtain your unique list based on the onStatisticField.
Once you have setup the StatisticsDefinition object then you can use it in your Query Object (esri.tasks.Query)
Query.outStatistics
However, note that there seems to be the following requirements: 1) Requires ArcGIS Server service version 10.1 or greater (As of v2.6) 2) outStatistics is only supported on layers/tables where supportsStatistics is true. 3) If outStatistics is specified the only other query parameters that will be used are groupByFieldsForStatistics, orderByFields, text, timeExtent and where.
What I do not know is if the StatisticsDefinition only permits statistics on integer fields or if you can use the statistics type = "count" for character fields.
Maybe you could add it to the query object, and try it. If that doesn't work you could experiment with just using esri.request() to do the query manually.
In ArcMap, File--add a query layer, then create a SQL query with DISTINCT. Note although it says add a layer, you do not need to have spatial column. The query will be added as a TABLE.
