Query (Feature Service/Layer)
- URL:http://<featurelayer-url>/query
- Required Capability:Query
- Version Introduced:10.0
Description
The query operation is performed on a feature service layer resource. The result of this operation is either a feature set or an array of feature IDs (if returnIdsOnly is set to true) and/or a result extent (if returnExtentOnly is set to true).
While there is a limit to the number of features included in the feature set response, there is no limit to the number of object IDs returned in the ID array response. Clients can exploit this to get all the query conforming object IDs by specifying returnIdsOnly=true and subsequently requesting feature sets for subsets of object IDs.
In the feature set response, the layer features include their geometries. The records for tables do not.
Note:If the query results include an empty feature set, the fields set is not returned.
For time-aware layers, you can use the time parameter to specify the time instant or the time extent to query.
You can provide arguments to the query operation defined in the following parameters table:
New in 10.3.1
- The exceededTransferLimit property is now included in the JSON response when paging through a query result with the resultOffset and resultRecordCount parameters. When exceededTransferLimit is true, it indicates there are more query results and you can continue to page through the results. When exceededTransferLimit is false, it indicates that you have reached the end of the query results.
Note:When not using the resultOffset and resultRecordCount parameters, the exceededTransferLimit property may also be included in the query results. In this case, the property will be true only if the number of records exceeds the maximum number configured by the server administrator.
Note:In some cases when using the resultOffset and resultRecordCount parameters, the exceededTransferLimit property may be included in the query results even though the value specified in the resultRecordCount has not been exceeded. This is due to internal spatial index filtering of the query results. For this reason you should always rely on the exceededTransferLimit property to determine if you should page through results rather than relying on the number of results returned from each page. In some extreme cases zero results can be returned but the exceededTransferLimit property will be returned. In these cases you should continue paging though your results until exceededTransferLimit is no longer returned.
New in 10.3
- Supports pagination in a query layer. Use the resultOffset and resultRecordCount parameters to page through a query result.
- Note that when you pass in one of these two parameters and orderByFields is left empty, the map service uses the object-id field to sort the result. For a query layer with a pseudo column as the object-id field (for example, FID), you must provideorderByFields; otherwise the query fails.
Request parameters
|
Parameter |
Details | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| f |
Description: The response format. The default response format is html. Values: html | json | geojson |amf (default, when returnIdsOnly=false and returnCountOnly=false) Values: html | json | geojson (when returnIdsOnly=true or returnCountOnly=true) |
||||||||
| where | Description: A where clause for the query filter. Any legal SQL where clause operating on the fields in the layer is allowed. Examples: where=POP2000 > 350000 where=CITY_NAME = 'Barrington' | ||||||||
| objectIds | Description: The object IDs of this layer or table to be queried. Note:There might be a drop in performance if the layer/table data source resides in an enterprise geodatabase and more than 1,000 objectIds are specified. Syntax: objectIds=<objectId1>, <objectId2> Example: objectIds=37, 462 | ||||||||
| geometry | Description: The geometry to apply as the spatial filter. The structure of the geometry is the same as the structure of the json geometry objects returned by the ArcGIS REST API. In addition to the JSON structures, for envelopes and points, you can specify the geometry with a simpler comma-separated syntax. Syntax:
Examples:
| ||||||||
| geometryType |
Description: The type of geometry specified by the geometry parameter. The geometry type can be an envelope, point, line, or polygon. The default geometry type is an envelope. Values: esriGeometryPoint | esriGeometryMultipoint | esriGeometryPolyline | esriGeometryPolygon | esriGeometryEnvelope | ||||||||
| inSR | Description: The spatial reference of the input geometry. The spatial reference can be specified as either a well-known ID or as a spatial reference JSON object. If the inSR is not specified, the geometry is assumed to be in the spatial reference of the map. | ||||||||
| spatialRel | Description: The spatial relationship to be applied on the input geometry while performing the query. The supported spatial relationships include intersects, contains, envelope intersects, within, and so on. The default spatial relationship is intersects (esriSpatialRelIntersects). Values: esriSpatialRelIntersects | esriSpatialRelContains | esriSpatialRelCrosses | esriSpatialRelEnvelopeIntersects | esriSpatialRelIndexIntersects | esriSpatialRelOverlaps | esriSpatialRelTouches | esriSpatialRelWithin | ||||||||
| relationParam | Description: The spatial relate function that can be applied while performing the query operation. An example for this spatial relate function is "FFFTTT***". For more information on this spatial relate function, see the documentation for the spatial relate function. Note:This parameter is not supported in the ArcGIS Online hosted service case. | ||||||||
| time | Description: The time instant or the time extent to query. Time instant Syntax: time=<timeInstant> Example: time=1199145600000 (1 Jan 2008 00:00:00 GMT) Time extent Syntax: time=<startTime>, <endTime> Example: time=1199145600000, 1230768000000 (1 Jan 2008 00:00:00 GMT to 1 Jan 2009 00:00:00 GMT) A null value specified for start time or end time will represent infinity for start or end time, respectively. Example: time=null, 1230768000000 | ||||||||
| distance | Description: The buffer distance for the input geometries. The distance unit is specified by units. For example, if the distance is 100, the query geometry is a point, units is set to meters, and all points within 100 meters of the point are returned. Syntax: distance=<distance> Example: distance=100 The geodesic buffer is created based on the datum of the output spatial reference if it exists. If there is no output spatial reference, the input geometry spatial reference is used. Otherwise, the native layer spatial reference is used to generate the geometry buffer used in the query. This parameter only applies if supportsQueryWithDistance is true. | ||||||||
| units | Description: The unit for calculating the buffer distance. If unit is not specified, the unit is derived from the geometry spatial reference. If the geometry spatial reference is not specified, the unit is derived from the feature service data spatial reference. This parameter only applies if supportsQueryWithDistance is true. Values: esriSRUnit_Meter | esriSRUnit_StatuteMile | esriSRUnit_Foot | esriSRUnit_Kilometer | esriSRUnit_NauticalMile | esriSRUnit_USNauticalMile | ||||||||
| outFields | Description: The list of fields to be included in the returned result set. This list is a comma delimited list of field names. You can also specify the wildcard "*" as the value of this parameter. In this case, the query results include all the field values. Example: outFields=AREANAME,ST,POP2000 Example (wildcard usage): outFields=* | ||||||||
| returnGeometry | This option was added at 10.1. Description: If true, the result includes the geometry associated with each feature returned. The default is true. Values: true | false | ||||||||
| maxAllowableOffset | This option was added at 10.1. Description: This option can be used to specify the maxAllowableOffset to be used for generalizing geometries returned by the query operation. The maxAllowableOffset is in the units of outSR. If outSR is not specified, maxAllowableOffset is assumed to be in the unit of the spatial reference of the map. Example: maxAllowableOffset=2 | ||||||||
| geometryPrecision | This option was added at 10.1. Description: This option can be used to specify the number of decimal places in the response geometries returned by the Query operation. This applies to X and Y values only (not m or z-values). Example: geometryPrecision=3 | ||||||||
| outSR | Description: The spatial reference of the returned geometry. The spatial reference can be specified as either a well-known ID or as a spatial reference JSON object. If outSR is not specified, the geometry is returned in the spatial reference of the map. | ||||||||
| gdbVersion | //This option was added at 10.1. Description: Geodatabase version to query. This parameter applies only if the isDataVersioned property of the layer is true. If this is not specified, query will apply to the published map’s version. Syntax: gdbVersion=<version> Example: gdbVersion=SDE.DEFAULT | ||||||||
| returnDistinctValues | Description: If true, it returns distinct values based on the fields specified in outFields. This parameter applies only if the supportsAdvancedQueries property of the layer is true. Values: <true | false> Example: returnDistinctValues=true | ||||||||
| returnIdsOnly | Description: If true, the response only includes an array of object IDs. Otherwise, the response is a feature set. The default is false. While there is a limit to the number of features included in the feature set response, there is no limit to the number of object IDs returned in the ID array response. Clients can exploit this to get all the query conforming object IDs by specifying returnIdsOnly=true and subsequently requesting feature sets for subsets of object IDs. When objectIds are specified, setting this parameter to true is invalid. Values: true | false | ||||||||
| returnCountOnly | This option was added at 10.0 SP1. Description: If true, the response only includes the count (number of features/records) that would be returned by a query. Otherwise, the response is a feature set. The default is false. This option supersedes the returnIdsOnly parameter. If returnCountOnly = true, the response will return both the count and the extent. Values: true | false | ||||||||
| returnExtentOnly | This option was added at 10.3. Note:At 10.3, this option is only available for hosted feature services. At 10.3.1, this option is available for hosted and non-hosted feature services. Description: If true, the response only includes the extent of the features that would be returned by the query. If returnCountOnly=true, the response will return both the count and the extent. The default is false. This parameter applies only if the supportsReturningQueryExtent property of the layer is true. Values: true | false | ||||||||
| orderByFields | This option was added at 10.1. Description: One or more field names on which the features/records need to be ordered. Use ASC or DESC for ascending or descending, respectively, following every field to control the ordering. Note:
Syntax: orderByFields=field1 <ORDER>, field2 <ORDER>, field3 <ORDER> Example: orderByFields=STATE_NAME ASC, RACE DESC, GENDER | ||||||||
| groupByFieldsForStatistics | This option was added at 10.1. Description: One or more field names on which the values need to be grouped for calculating the statistics. Note:groupByFieldsForStatistics is valid only when the outStatistics parameter is used. Syntax: groupByFieldsForStatistics=field1, field2 Example: groupByFieldsForStatistics=STATE_NAME, GENDER | ||||||||
| outStatistics | This option was added at 10.1. Description: The definitions for one or more field-based statistics to be calculated. Note:
Values: An array of statistic definitions. A statistic definition specifies the type of statistic, the field on which it is to be calculated, and the resulting output field name. Syntax: Example: | ||||||||
| returnZ | This option was added at 10.1. Description: If true, Z values are included in the results if the features have Z values. Otherwise, Z values are not returned. The default is false. This parameter only applies if returnGeometry is true, and the layer's hasZ property is true. | ||||||||
| returnM | This option was added at 10.1. Description: If true, M values are included in the results if the features have M values. Otherwise, M values are not returned. The default is false. This parameter only applies if returnGeometry is true, and the layer's hasM property is true . | ||||||||
| multipatchOption | Description: This option dictates how the geometry of a multipatch feature will be returned. Values: <xyFootprint> This parameter only applies if the layer's geometryType property is esriGeometryMultiPatch. If multipatchOption=xyFootprint, the xy footprint of each multipatch geometry will be returned in the result. Currently, the only supported value is xyFootprint . If returnGeometry=false, specifying the multipatchOption is not required. | ||||||||
| resultOffset | This option was added at 10.3. Description: This option can be used for fetching query results by skipping the specified number of records and starting from the next record (that is, resultOffset + 1th). The default is 0. This parameter only applies if supportsPagination is true. You can use this option to fetch records that are beyond maxRecordCount. For example, if maxRecordCount is 1000, you can get the next 100 records by setting resultOffset=1000 and resultRecordCount = 100, so the query results will return the results in the range of 1001 to 1100. | ||||||||
| resultRecordCount | This option was added at 10.3. Description: This option can be used for fetching query results up to the resultRecordCount specified. When resultOffset is specified but this parameter is not, the map service defaults it to maxRecordCount. The maximum value for this parameter is the value of the layer's maxRecordCount property. This parameter only applies if supportsPagination is true. Example: resultRecordCount=10 to fetch up to 10 records | ||||||||
| quantizationParameters | This option was added at 10.3. Description: Used to project the geometry onto a virtual grid, likely representing pixels on the screen. Note:
Example 1: {"mode":"view","originPosition":"upperLeft","tolerance":1.0583354500042335,"extent":{"type":"extent","xmin":-18341377.47954369,"ymin":2979920.6113554947,"xmax":-7546517.393554582,"ymax":11203512.89298139,"spatialReference":{"wkid":102100,"latestWkid":3857}}} Example 2: http://services.myserver.com/ERmEceOGq5cHrItq/ArcGIS/rest/services/USAShapeFoldersDec5/FeatureServer/2/query?f=html&where=1=1&returnGeometry=true&spatialRel=esriSpatialRelIntersects&outFields=*&outSR=102100&resultOffset=0&resultRecordCount=2000&quantizationParameters={"mode":"view","originPosition":"upperLeft","tolerance":1.0583354500042335,"extent":{"type":"extent","xmin":-19838806.04126036,"ymin":2146082.189218864,"xmax":-7455049.448307296,"ymax":11542768.51809405,"spatialReference":{"wkid":102100,"latestWkid":3857}}} Example 3: {"mode":"view","originPosition":"lowerLeft","tolerance":1.0583354500042335,"extent":{"type":"extent","xmin":-18341377.47954369,"ymin":2979920.6113554947,"xmax":-7546517.393554582,"ymax":11203512.89298139,"spatialReference":{"wkid":102100,"latestWkid":3857}}} Example 4: http://services.myserver.com/ERmEceOGq5cHrItq/ArcGIS/rest/services/USAShapeFoldersDec5/FeatureServer/1/query?where=1=1&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&distance=&units=esriSRUnit_Meter&outFields=*&returnGeometry=true&maxAllowableOffset=1.0583354500042335&geometryPrecision=&outSR=102100&returnIdsOnly=false&returnCountOnly=false&returnExtentOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&resultOffset=0&resultRecordCount=2000&returnZ=false&returnM=false&quantizationParameters={"mode":"view","originPosition":"lowerLeft","tolerance":1.0583354500042335,"extent":{"type":"extent","xmin":-18341377.47954369,"ymin":2979920.6113554947,"xmax":-7546517.393554582,"ymax":11203512.89298139,"spatialReference":{"wkid":102100,"latestWkid":3857}}}&f=html&token= | ||||||||
| returnCentroid | Optional Description: Used to return the geometry centroid associated with each feature returned. If true, the result includes the geometry centroid. The default is false. Values: true | false Note:
Examples Example 1: (When returnGeometry=true and returnCentroid=true) http://services.myserver.com/ERmEceOGq5cHrItq/ArcGIS/rest/services/USAStatesRiversCapitals/FeatureServer/2/query?where=1=1&objectIds=&uniqueIds=&time=&geometry=&geometryType=esriGeometryEnvelope&geohash=&inSR=&spatialRel=esriSpatialRelIntersects &distance=&units=esriSRUnit_Meter&outFields=*&returnGeometry=true&returnCentroid=true&maxAllowableOffset=&geometryPrecision=&outSR=& returnIdsOnly=false&returnUniqueIdsOnly=false&returnCountOnly=false&returnExtentOnly=false&returnDistinctValues=false&orderByFields=& groupByFieldsForStatistics=&outStatistics=&resultOffset=&resultRecordCount=&returnZ=false&returnM=false& quantizationParameters=&f=html&token= Example 2: (When returnGeometry=false and returnCentroid=true) http://services.myserver.com/ERmEceOGq5cHrItq/ArcGIS/rest/services/USAStatesRiversCapitals/FeatureServer/2/query?where=1=1&objectIds=&uniqueIds=&time=&geometry=&geometryType=esriGeometryEnvelope&geohash=&inSR=&spatialRel=esriSpatialRelIntersects &distance=&units=esriSRUnit_Meter&outFields=*&returnGeometry=false&returnCentroid=true&maxAllowableOffset=&geometryPrecision=&outSR=& returnIdsOnly=false&returnUniqueIdsOnly=false&returnCountOnly=false&returnExtentOnly=false&returnDistinctValues=false&orderByFields=& groupByFieldsForStatistics=&outStatistics=&resultOffset=&resultRecordCount=&returnZ=false&returnM=false& quantizationParameters=&f=html& token= |
Example usage
- Example 1: Query using a WHERE clause:
http://services.myserver.com/ERmEceOGq5cHrItq/ArcGIS/rest/services/Earthquakes/EarthquakesFromLastSevenDays/FeatureServer/0/query?where=magnitude+%3E+4.5&outFields=*&returnGeometry=true&returnIdsOnly=false&f=html
- Example 2: Query a table using a WHERE clause and return OBJECTIDs only:
http://services.myserver.com/ERmEceOGq5cHrItq/ArcGIS/rest/services/SanFrancisco/311Incidents/FeatureServer/1/query?where=agree_with_incident+%3D+1&returnGeometry=true&returnIdsOnly=true&f=html
- Example 3: Page through a query result using resultOffset and resultRecordCount to get the next set of results.Requesting to skip the first 5 records and return the next 10 counties in California ordered by population:
http://services.myserver.com/ERmEceOGq5cHrItq/ArcGIS/rest/services/USA/MapServer/3/query?where=STATE_NAME='California'&outFields=Name,Population&returnGeometry=false&resultOffset=5&resultRecordCount=10&orderByFields=Population&f=pjson
JSON response syntax (when returnIdsOnly=false and returnCountOnly=false)
{
"objectIdFieldName" : "<objectIdFieldName>",
"globalIdFieldName" : "<globalIdFieldName>",
"geometryType" : "<geometryType>", //for feature layers only
"spatialReference" : <spatialReference>, //for feature layers only
"hasZ" : <true|false>, //added in 10.1
"hasM" : <true|false>, //added in 10.1
"fields" : [
{"name" : "<fieldName1>", "type" : "<fieldType1>", "alias" : "<fieldAlias1>", "length" : "<length1>"},
{"name" : "<fieldName2>", "type" : "<fieldType2>", "alias" : "<fieldAlias2>", "length" : "<length2>"}
],
"features" : [ //features will include geometry for feature layers only
<feature1>, <feature2>
]
}
JSON response syntax (when returnCountOnly=true)
{
"count" : <count>
}
JSON response syntax (when returnCountOnly=true and returnExtentOnly=true)
{
"count" : <count>,
"extent" : <envelope>
}
JSON response syntax (when returnIdsOnly=true)
{
"objectIdFieldName" : "<objectIdFieldName>",
"objectIds" : [ <objectId1>, <objectId2> ]
}
JSON response example (when returnIdsOnly=false and returnCountOnly=false)
{
"objectIdFieldName" : "objectid",
"globalIdFieldName" : "",
"geometryType" : "esriGeometryPoint",
"spatialReference" : {
"wkid" : 4326
},
"fields" : [
{
"name" : "objectid",
"type" : "esriFieldTypeOID",
"alias" : "Object ID"
},
{
"name" : "datetime",
"type" : "esriFieldTypeDate",
"alias" : "Earthquake Date",
"length" : 36
},
{
"name" : "depth",
"type" : "esriFieldTypeDouble",
"alias" : "Depth"
},
{
"name" : "eqid",
"type" : "esriFieldTypeString",
"alias" : "Earthquake ID",
"length" : 50
},
{
"name" : "latitude",
"type" : "esriFieldTypeDouble",
"alias" : "Latitude"
},
{
"name" : "longitude",
"type" : "esriFieldTypeDouble",
"alias" : "Longitude"
},
{
"name" : "magnitude",
"type" : "esriFieldTypeDouble",
"alias" : "Magnitude"
},
{
"name" : "numstations",
"type" : "esriFieldTypeInteger",
"alias" : "Number of Stations"
},
{
"name" : "region",
"type" : "esriFieldTypeString",
"alias" : "Region",
"length" : 200
},
{
"name" : "source",
"type" : "esriFieldTypeString",
"alias" : "Source",
"length" : 50
},
{
"name" : "version",
"type" : "esriFieldTypeString",
"alias" : "Version",
"length" : 50
}
],
"features" : [
{
"geometry" : {
"x" : -178.24479999999991,
"y" : 50.012500000000045
},
"attributes" : {
"objectid" : 3745682,
"datetime" : 1272210710000,
"depth" : 31.100000000000001,
"eqid" : "2010vma5",
"latitude" : 50.012500000000003,
"longitude" : -178.2448,
"magnitude" : 4.7999999999999998,
"numstations" : 112,
"region" : "Andreanof Islands, Aleutian Islands, Alaska",
"source" : "us",
"version" : "Q"
}
},
{
"geometry" : {
"x" : -72.865099999999927,
"y" : -37.486599999999953
},
"attributes" : {
"objectid" : 3745685,
"datetime" : 1272210142999,
"depth" : 40.600000000000001,
"eqid" : "2010vma4",
"latitude" : -37.486600000000003,
"longitude" : -72.865099999999998,
"magnitude" : 4.9000000000000004,
"numstations" : 58,
"region" : "Bio-Bio, Chile",
"source" : "us",
"version" : "7"
}
}
]
}
JSON response example (when returnIdsOnly=false, returnCountOnly=false, and outFields="")
{
"objectIdFieldName" : "objectid",
"globalIdFieldName" : "",
"geometryType" : "esriGeometryPoint",
"spatialReference" : {
"wkid" : 4326
},
"fields" : [
],
"features" : [
{
"geometry" : {
"x" : 237.17180000000008,
"y" : 38.844700000000046
},
"attributes" : {
}
},
{
"geometry" : {
"x" : 242.89430000000004,
"y" : 34.559200000000089
},
"attributes" : {
}
}
]
}
JSON response example (when returnIdsOnly=false, returnCountOnly=false, outFields="", and geometryPrecision=3)
{
"objectIdFieldName" : "objectid",
"globalIdFieldName" : "",
"geometryType" : "esriGeometryPoint",
"spatialReference" : {
"wkid" : 4326
},
"fields" : [
],
"features" : [
{
"geometry" : {
"x" : 237.172,
"y" : 38.845
},
"attributes" : {
}
},
{
"geometry" : {
"x" : 242.894,
"y" : 34.559
},
"attributes" : {
}
}
]
}
JSON response example (when returnIdsOnly=true)
{
"objectIdFieldName" : "objectid",
"objectIds" : [1, 2, 3, 4, 5, 7]
}
JSON response example (when returnCountOnly=true)
{
"count":48
}
JSON response example (when returnGeometry=true and returnCentroid=true)
{"geometryType" : "esriGeometryPolygon",
"features" : [
{
"attributes" : {"FID" : 6,},
"geometry" : {"rings" :
[
[
[3665984.6341781, 4199764.97834117],
[3607400.16786144, 4129939.04834019],
[3593238.34218707, 4176854.4199198],
[3665984.6341781, 4199764.97834117]
]
]
},
"centroid" :
{
"x" : 3702339.9805305949,
"y" : 4174890.1188574196
}
}
}
JSON response example (when returnGeometry=false and returnCentroid=true)
{
"geometryType" : "esriGeometryPolygon",
"features" : [
{
"attributes" : {
"FID" : 6,
},
"centroid" :
{
"x" : 3702339.9805305949,
"y" : 4174890.1188574196
}
}
}