topic Re: Problems with Statistics in ArcGIS REST APIs and Services Questions

Problems with Statistics

RobChouinard — Wed, 20 Feb 2013 19:58:49 GMT

I have 3 problems with Statistics:

A temporary service you can try this out on: REMOVED

1.) Statistics do not work with a version other than DEFAULT. So If I add a table in as version Office statistics do not work. If I add table in as version DEFAULT statistics do work. See Species_DEFAULT and Species_Office in map service above.

2.) If a versioned table is added to a feature service, it shows it supports statistics in the feature service but not in the map service. It in fact doesn't support then in either. I don't have a public example of this ATM.

3.) Statistics do not work with views. I create a view in the sde (SQL Express) via ArcCatalog and add it to a map service as version DEFAULT. Rest map service shows it supports statistics in both DEFAULT and Office versions but statistics do not work. See vInspectionsMosSites_Office and vInspectionsMosSites_DEFAULT in map service above.

A quick and easy statistic I am trying out:
Where: 1=1

Output Statistics:
[{
"statisticType":"count",
"onStatisticField":"*",
"outStatisticFieldName":"Count"
}]

Is there going to be support for versioned statistics in a future release? It would be a pain to be able to edit data and not see the changes in the statistics.

Re: Problems with Statistics

TanuHoque — Tue, 28 May 2013 16:58:46 GMT

getting statistics from non-default version is supported for 10.2.

in query stats request, do not use "*" as 'onStatisticField', instead provide e.g. OBJECTID.
try to avoid using anything that could potentially be a keyword or function name in the outStatisticFieldName. in you case, try something other than "count". Also, this is an optional property that you don't need to specify.

Re: Problems with Statistics

RobChouinard — Tue, 28 May 2013 17:13:52 GMT

Thanks for these tips. Is there an ETA for 10.2? Also does 10.2 allow statistics on views?

Re: Problems with Statistics

TanuHoque — Wed, 29 May 2013 16:06:46 GMT

Views should not be any different than FeatureClasses. It should be working with 10.1 too. Would you mind contact Esri Technical Support with reproducible steps/data? We'll be more than happy to look into the reason it is failing for you.

Thanks.

Re: Problems with Statistics

RobChouinard — Wed, 29 May 2013 16:42:36 GMT

Here is an example of a failed query on a view: http://gis.citrusmosquito.org/arcgis_public/rest/services/Stats_Test/MapServer/4/query?where=1%3D1&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&outFields=&returnGeometry=true&maxAllowableOffset=&geometryPrecision=&outSR=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=%5B%7B%0D%0A+%22statisticType%22%3A%22count%22%2C%0D%0A+%22onStatisticField%22%3A%22ESRI_OID%22%2C%0D%0A+%22outStatisticFieldName%22%3A%22CountAll%22%0D%0A+%7D%5D&returnZ=false&returnM=false&gdbVersion=&returnDistinctValues=false&f=html

The layer vInspectionsMosSites_DEFAULT shows it supports both Advanced Queries and Statistics.

Re: Problems with Statistics

TanuHoque — Thu, 30 May 2013 15:04:41 GMT

Rob,
I'm afraid the link to your map service will not help much.
Please contact Esri Tech Support -- they will probably look at your data etc. to find out where the problem lies.

Thanks.

Re: Problems with Statistics

JakeMatthys — Mon, 12 Aug 2013 18:57:18 GMT

I have also found that the OutputStatistics in ArcGIS Server 10.11 will not work with map service layers that are created from feature classes that are in SDO geometry. Will OutputStatistics work with SDO geometry in the future?
Thanks,
- Jake

Re: Problems with Statistics

TanuHoque — Tue, 13 Aug 2013 19:56:39 GMT

Jake,
I'm not sure why it is not working for you. I'd appreciate if you could contact Esri Tech Support and have them take a look at this.

Thanks.