
The value of ESRI_OID field might possibly change for each request.

This resultant field is always called ESRI_OID unless a field of that name already exists. If multiple fields are chosen, the values in these fields will be used as a key to generate a unique integer value. Map server does not enforce the uniqueness of values in the unique identifier field of a queryTable. It is your responsibility to guarantee that values in this field meet this requirement. Map server operations will behave unpredictably when non-unique or null values are encountered. Since the value in the unique identifier field uniquely identifies a row or feature object, values in that field must always be unique and not null. The mosaic rule parameter is used by many image service operations, for example, export image and identify operations.
#ARCGIS 10.3 FIELD DATA TYPES LICENSE#
However, if a single string field or a group of fields is used as the unique identifier, map server maps those unique values to an integer. Mosaic rule objects Description As of 10.5, you must license your ArcGIS Server as an ArcGIS Image Server in order to use this resource with a mosaic dataset.The image service uses a mosaic rule to mosaic multiple rasters on-the-fly. If a single integer field is specified, map server uses the values in that field directly to uniquely identify all features and rows returned from a queryTable. These field types include integer, string, GUID, and date. The following dataSource objects are discussed here: Table data source Query table data source Raster data source Join table data source Table data sourceTable data source. A dataSource is a table, feature class, or raster that resides in a registered workspace (either a folder or geodatabase). OidFields: There are only certain field types that can be used as a unique identifier. Data Source object Description This topic discusses the JSON representation of a dataSource object. When querying a table that does not have a geometry column, do not include geometryType and spatialReference. When querying a table that stores geometry in a non-native format, the result is returned as a table that can be used in query operations.
#ARCGIS 10.3 FIELD DATA TYPES FULL#
When a query layer is added as a dynamic layer to a map service, the extent defaults to the full extent of the spatial reference provided in the request (new beginning at version 10.3). Spatial views are database views that contain a single spatial column.

For example, use this layer in an export operation by specifying a renderer. Be aware that you cannot edit data through a database view in ArcMap or an ArcGIS feature service. When querying a table that stores geometry in the database native format, the result is returned as a layer that can be used in any operation supported by dynamic layer. Spatial information used by a queryTable is not required to be in a QueryTable uses SQL to directly query database tables and views, Layers allow both spatial and nonspatial information stored in aĭBMS to be easily integrated into map service operations. A queryTable is a layer/table that is defined by a SQL query.
