When you use ArcMap to publish shape file to Arcgis Server, by default you will get                        

                      Supports Advanced Queries: false

                User visiting this web site will have a bad experience, every request get 1000 feature, those 1000 feature are NOT geographically distributed, they are jamed in a narrow corner.

                Arcgis Server by default limit 1000 feature per request.  (You can reset the limit when you publish to Arcgis server from ArcMap). For example, user send ajax request via feature service rest api, ask for parcels within a large area. Instead of giving you 1 million parcles, arcgis server only give you 1000 parcels per time.

                On the map server feature service page, if you see Supports Advanced Queries: false, those returned 1000 parcels will jamed to a narrow cornor or a narrow side.  

                  Ideally user want to see those returned 1000 parcels geographically spatial evenly distributed cross all area, not narrowly jamed to a side or corner.

                  Solution is set   Supports Advanced Queries: true

                          Base on ESRI's document, Supports Advanced Queries would be false in the following scenarios:

 

                                1). The layer / table resides in a workspace other than an Enterprise Geodatabase or File Geodatabase.

 

                                2). The layer / table is joined with another layer / table from a different workspace.

 

 

                         If you the source of shape files is a File geodatabase or Enterprise geodatabase, you were able to get Supports Advanced Queries as true automatically. You don't need to do any configure, all you need to do is in ArcCatalog, create a geodatabase, import feature from shape file. Then in ArcMap, reset layer's source to geodatabase, done. 

 

                

 

ESRI's document :  https://developers.arcgis.com/rest/services-reference/enterprise/layer-table.htm

supportsStatistics and supportsAdvancedQueries are dependent on the layer data source.

supportsStatistics would return false in the following scenarios:

  • The layer / table resides in a workspace other than an enterprise or file geodatabase.
  • The layer / table has more than one join defined on it.
  • The layer / table is joined with another layer / table from a different workspace.
  • The layer / table has an outer join and where the workspace is earlier than 10.1, Geodatabase and application server connection is used.

supportsAdvancedQueries would return false in the following scenarios:

  • The layer / table resides in a workspace other than an enterprise database or File Geodatabase.
  • The layer / table is joined with another layer / table from a different workspace.

 

 

 

Support Distinct : false ? how to enable in map service ?

https://community.esri.com/t5/arcgis-enterprise-questions/support-distinct-false-how-to-enable-in-map-service/td-p/679593

 

 

 

 

 

by

Please log in or register