Query table data source is a layer/table that is defined by a SQL query.
Referenced by: dataSource
Properties
Property | Details |
---|---|
geometryType | The geometry type. When querying a table that does not have a geometry column, do not include geometryType. Valid values:
|
oidFields | Comma separated list of identifier fields. There are only certain field types that can be used as a unique identifier. These field types include integer, string, GUID, and date. 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. 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. |
query | The SQL query. |
spatialReference | The spatial reference of the geometry column. When querying a table that does not have a geometry column, do not include spatialReference. |
type | String value indicating the type for the dataSource. Valid value of this property queryTable |
workspaceId | The unique string value used to identify the datasource's workspace. |
Query Table dataSource Example
{
"type": "queryTable",
"workspaceId": "SqlMAP",
"oidFields": "taxlotid",
"query": "SELECT * FROM TaxLots",
"geometryType": "esriGeometryPolygon",
"spatialReference": {
"wkid": 4326
}
}