topic Re: ArcGIS Server's Query - Returned w/ different records in ArcGIS JavaScript Maps SDK Questions

ArcGIS Server's Query - Returned w/ different records

ShaningYu — Mon, 24 Nov 2014 17:26:21 GMT

I tried 2 things:

1) Run the code sourced from ESRI (see attached). The query returned > 100 features and populated on the left pane's Grid.

2) Go to the service site: http://trainingcloud.arcgis.com/arcgis/rest/services/Redlands_PointsOfInterest/MapServer/0, and run the query: where: NAME Like '%Redlands%' Geometry Type: Envelope Out fields: OBJECTID, NAME, Match_addr, TEL, TYPE Spatialo relationship: Contains Or use the link http://trainingcloud.arcgis.com/arcgis/rest/services/Redlands_PointsOfInterest/MapServer/0/query?where=NAME+Like+%27%25Redlands%25%27&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelContains&relationParam=&outFields=OBJECTID%2C+NAME%2C+Match_addr%2C+TEL%2C+TYPE&returnGeometry=true&maxAllowableOffset=&geometryPrecision=&outSR=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&returnDistinctValues=false&f=html which results in only 12 records.

Tried several times with the same results on both cases. Can someone explain why? Thanks.

My Template

Name	Address

Created by J. Doe

Re: ArcGIS Server's Query - Returned w/ different records

RobertScheitlin__GISP — Mon, 24 Nov 2014 17:31:48 GMT

Shaning

Run the code sourced from ESRI

What code?

Re: ArcGIS Server's Query - Returned w/ different records

ShaningYu — Mon, 24 Nov 2014 18:23:15 GMT

Did you see the attached file? Thanks.

Re: ArcGIS Server's Query - Returned w/ different records

RobertScheitlin__GISP — Mon, 24 Nov 2014 18:48:04 GMT

Shaning,

no it was not attached when I replied.

The issue is initially when you run the code the results contain all features that intersect the maps view extent and when you run your query you are only looking for features that have 'Redlands' in its name.

I think your confusion is that you are seeing 'Redlands' in the in the Match_addr of the initial 100+ results and are expecting to see the same when you query. If you change your query to this then you will see results similar to what you are when you initially run the app:

http://trainingcloud.arcgis.com/arcgis/rest/services/Redlands_PointsOfInterest/MapServer/0/query?where=Match_addr+Like+%27%25Redlands%25%27&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelContains&relationParam=&outFields=OBJECTID%2C+NAME%2C+Match_addr%2C+TEL%2C+TYPE%2C+Match_addr&returnGeometry=true&maxAllowableOffset=&geometryPrecision=&outSR=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&returnDistinctValues=false&f=html

Re: ArcGIS Server's Query - Returned w/ different records

ShaningYu — Mon, 24 Nov 2014 19:52:30 GMT

Rob: Thanks a lot.