arcgis.features module

Entities located in space with a set of properties can be represented as features.

# Obtain a feature from a feature layer:

# Query a Feature Layer to get a Feature Set
>>> feature_set = feature_layer.query(where="OBJECTID=1")
# Assign a variable to the list of features in the Feature Set
>>> feature_list = feature_set.features
# Get an individual feature
>>> feature = feature_list[0]

# Verify the object type
>>> type(feature)
arcgis.features.feature.Feature
# Print the string representation of the feature
>>> feature
{"geometry": {"x": -8238318.738276444, "y": 4970309.724235498, "spatialReference": {"wkid": 102100, "latestWkid": 3857}},
"attributes": {"Incident_Type": "Structural-Sidewalk Collapse", "Location": "927 Broadway", "Borough": "Manhattan",
"Creation_Date": 1477743211000, "Closed_Date": null, "Latitude": 40.7144215406227, "Longitude": -74.0060763804198,
"ObjectId": 1}}

property as_dict

Retrieves the feature layer as a dictionary.

Returns:

The feature as a dictionary

property as_row

Retrieves the feature as a tuple containing two lists:

List of:	Description
row values	the specific attribute values and geometry for this feature
field names	the name for each attribute field

Returns:

A tuple of two lists: row values and field names

property attributes

Get/Set the attribute values for a feature

Parameter	Description
value	Required dict.

Returns:

A dictionary of feature attribute values with field names as the key

#Example to set attribute values

>>> feat_set = feature_layer.query(where="1=1")
>>> feat_list = feat_set.features
>>> feat = feat_list[0]
>>> feat.attributes = {"field1 : "value", field2 : "value"}

property fields

Retrieves the attribute field names for the feature as a list of strings

Returns:

A list of strings

classmethod from_dict(feature, sr=None)

Creates a Feature object from a dictionary.

Returns:

A Feature

classmethod from_json(json_str)

Creates a Feature object from a JSON string.

Returns:

A Feature

property geometry

Get/Set the geometry of the feature, if any.

Parameter	Description
value	Required string. Values: ‘Polyline’ | ‘Polygon’ | ‘Point’ Note Setting this value will override the current geometry dictionary if already present.

Returns:

The feature’s geometry as a dictionary.

# Get the current geometry
>>> feat_set = feature_layer.query(where="1=1")
>>> feat_list = feat_set.features
>>> feat = feat_list[0]
>>> feat.geometry
{'x': -8238318.738276444,
 'y': 4970309.724235498,
 'spatialReference': {'wkid': 102100, 'latestWkid': 3857}}

property geometry_type

Retrieves the geometry type of the Feature as a string.

Returns:

The geometry type of the Feature as a string

get_value(field_name)

Retrieves the value for a specified field name.

Parameter	Description
field_name	Required String. The name for each attribute field. Note feature.fields will return a list of all field names.

Returns:

The value for the specified attribute field of the Feature

set_value(field_name, value)

Sets an attribute value for a given field name.

Parameter	Description
field_name	Required String. The name of the field to update.
value	Required. Value to update the field with.

Returns:

A boolean indicating whether field_name value was updated (True), or not updated (False).

# Usage Example

>>> feat_set = feature_layer.query(where="OBJECTID=1")
>>> feat = feat_set.features[0]
>>> feat.fields
['OBJECTID',
 'FID_Commun',
 'AREA',
 'PERIMETER',
 'NAME',
 'COUNTY',
 'CONAME']
>>> feat.get_value("NAME")
'Original Name'
>>> feat.set_value(field_name = "NAME", value = "New Name")
True

Note

To save edits from the above snippet, use edit_features() with feat_set in a list as the updates argument.

The FeatureLayer class is the primary concept for working with Feature objects in a GIS.

User objects create, import, export, analyze, edit, and visualize features, i.e. entities in space as feature layers.

Feature layers can be added to and visualized using maps. They act as inputs to and outputs from feature analysis tools.

Feature layers are created by publishing feature data to a GIS, and are exposed as a broader resource (Item) in the GIS. Feature layer objects can be obtained through the layers attribute on feature layer Items in the GIS.

append(item_id=None, upload_format='featureCollection', source_table_name=None, field_mappings=None, edits=None, source_info=None, upsert=False, skip_updates=False, use_globalids=False, update_geometry=True, append_fields=None, rollback=False, skip_inserts=None, upsert_matching_field=None, upload_id=None, layer_mappings=None, *, return_messages=None, future=False)

The append method is used to update an existing hosted FeatureLayer object. See the Append (Feature Service/Layer) page in the ArcGIS REST API documentation for more information.

Note

The append method is only available in ArcGIS Online and ArcGIS Enterprise 10.8.1+

Parameter	Description
item_id	Optional string. The ID for the Portal item that contains the source file. Used in conjunction with editsUploadFormat.
upload_format	Required string. The source append data format. The default is featureCollection. Values: ‘sqlite’ | ‘shapefile’ | ‘filegdb’ | ‘featureCollection’ | ‘geojson’ | ‘csv’ | ‘excel’ Note You can find the Feature Layer’s supported formats by checking the featureLayer.properties.supportedAppendFormats property.
source_table_name	Required string. Required even when the source data contains only one table, e.g., for file geodatabase. # Example usage: source_table_name= "Building"
field_mappings	Optional list. Used to map source data to a destination layer. Syntax: field_mappings=[{“name” : <”targetName”>, “sourceName” : < “sourceName”>}, …] # Example usage: field_mappings=[{"name" : "CountyID", "sourceName" : "GEOID10"}]
edits	Optional dictionary. Only feature collection json is supported. Append supports all format through the upload_id or item_id.
source_info	Optional dictionary. This is only needed when appending data from excel or csv. The appendSourceInfo can be the publishing parameter returned from analyze the csv or excel file.
upsert	Optional boolean. Optional parameter specifying whether the edits needs to be applied as updates if the feature already exists. Default is false.
skip_updates	Optional boolean. Parameter is used only when upsert is true.
use_globalids	Optional boolean. Specifying whether upsert needs to use GlobalId when matching features.
update_geometry	Optional boolean. The parameter is used only when upsert is true. Skip updating the geometry and update only the attributes for existing features if they match source features by objectId or globalId.(as specified by useGlobalIds parameter).
append_fields	Optional list. The list of destination fields to append to. This is supported when upsert=true or false. #Values: ["fieldName1", "fieldName2",....]
rollback	Optional boolean. Optional parameter specifying whether the upsert edits needs to be rolled back in case of failure. Default is false.
skip_inserts	Used only when upsert is true. Used to skip inserts if the value is true. The default value is false.
upsert_matching_field	Optional string. The layer field to be used when matching features with upsert. ObjectId, GlobalId, and any other field that has a unique index can be used with upsert. This parameter overrides use_globalids; e.g., specifying upsert_matching_field will be used even if you specify use_globalids = True. Example: upsert_matching_field=”MyfieldWithUniqueIndex”
upload_id	Optional string. The itemID field from an upload() response, corresponding with the appendUploadId REST API argument. This argument should not be used along side the item_id argument.
layer_mappings	Optional list of dictionaries. This is needed if the source is featureService. It is used to map a source layer to a destination layer. Only one source can be mapped to a layer. Syntax: layerMappings=[{“id”: <layerID>, “sourceId”: <layer id>}]
return_messages	Optional Boolean. When set to True, the messages returned from the append will be returned. If False, the response messages will not be returned. This alters the output to be a tuple consisting of a (Boolean, Dictionary).
future	Optional boolean. If True, a future object will be returned and the process will not wait for the task to complete. The default is False, which means wait for results.

Returns:

A boolean indicating success (True), or failure (False). When return_messages is True, the response messages will be return in addition to the boolean as a tuple. If future = True, then the result is a Future object. Call result() to get the response.

# Usage Example

>>> feature_layer.append(source_table_name= "Building",
                        field_mappings=[{"name" : "CountyID",
                                        "sourceName" : "GEOID10"}],
                        upsert = True,
                        append_fields = ["fieldName1", "fieldName2",...., fieldname22],
                        return_messages = False)
<True>

calculate(where, calc_expression, sql_format='standard', version=None, sessionid=None, return_edit_moment=None, future=False)

The calculate operation is performed on a FeatureLayer resource. calculate updates the values of one or more fields in an existing feature service layer based on SQL expressions or scalar values. The calculate operation can only be used if the supportsCalculate property of the layer is True. Neither the Shape field nor system fields can be updated using calculate. System fields include ObjectId and GlobalId.

Inputs	Description
where	Required String. A where clause can be used to limit the updated records. Any legal SQL where clause operating on the fields in the layer is allowed.
calc_expression	Required List. The array of field/value info objects that contain the field or fields to update and their scalar values or SQL expression. Allowed types are dictionary and list. List must be a list of dictionary objects. Calculation Format is as follows: {“field” : “<field name>”, “value” : “<value>”}
sql_format	Optional String. The SQL format for the calc_expression. It can be either standard SQL92 (standard) or native SQL (native). The default is standard. Values: standard, native
version	Optional String. The geodatabase version to apply the edits.
sessionid	Optional String. A parameter which is set by a client during long transaction editing on a branch version. The sessionid is a GUID value that clients establish at the beginning and use throughout the edit session. The sessonid ensures isolation during the edit session. This parameter applies only if the isDataBranchVersioned property of the layer is true.
return_edit_moment	Optional Boolean. This parameter specifies whether the response will report the time edits were applied. If true, the server will return the time edits were applied in the response’s edit moment key. This parameter applies only if the isDataBranchVersioned property of the layer is true.
future	Optional boolean. If True, a future object will be returned and the process will not wait for the task to complete. The default is False, which means wait for results. This applies to 10.8+ only

Returns:

A dictionary with the following format:

{ ‘updatedFeatureCount’: 1, ‘success’: True }

If future = True, then the result is a Future object. Call result() to get the response.

# Usage Example 1:

print(fl.calculate(where="OBJECTID < 2",
                   calc_expression={"field": "ZONE", "value" : "R1"}))

# Usage Example 2:

print(fl.calculate(where="OBJECTID < 2001",
                   calc_expression={"field": "A",  "sqlExpression" : "B*3"}))

property container

Get/Set the FeatureLayerCollection to which this layer belongs.

Parameter	Description
value	Required FeatureLayerCollection.

Returns:

The Feature Layer Collection where the layer is stored

property contingent_values

Returns the define contingent values for the given layer. :returns: Dict[str,Any]

delete_features(deletes=None, where=None, geometry_filter=None, gdb_version=None, rollback_on_failure=True, return_delete_results=True, future=False)

Deletes features in a FeatureLayer or Table

Parameter	Description
deletes	Optional string. A comma separated string of OIDs to remove from the service.
where	Optional string. A where clause for the query filter. Any legal SQL where clause operating on the fields in the layer is allowed. Features conforming to the specified where clause will be deleted.
geometry_filter	Optional SpatialFilter. A spatial filter from arcgis.geometry.filters module to filter results by a spatial relationship with another geometry.
gdb_version	Optional string. The geodatabase version. This parameter applies only if the isDataVersioned property of the layer is true.
rollback_on_failure	Optional boolean. Optional parameter to specify if the edits should be applied only if all submitted edits succeed. If false, the server will apply the edits that succeed even if some of the submitted edits fail. If true, the server will apply the edits only if all edits succeed. The default value is true.
return_delete_results	Optional Boolean. Optional parameter that indicates whether a result is returned per deleted row when the deleteFeatures operation is run. The default is true.
future	Optional boolean. If True, a future object will be returned and the process will not wait for the task to complete. The default is False, which means wait for results.

Returns:

A dictionary if future=False (default), else If future = True, then the result is a Future object. Call result() to get the response.

# Usage Example with only a "where" sql statement

>>> from arcgis.features import FeatureLayer

>>> gis = GIS("pro")
>>> buck = gis.content.search("owner:"+ gis.users.me.username)
>>> buck_1 =buck[1]
>>> lay = buck_1.layers[0]

>>> la_df = lay.delete_features(where = "OBJECTID > 15")
>>> la_df
{'deleteResults': [
{'objectId': 1, 'uniqueId': 5, 'globalId': None, 'success': True},
{'objectId': 2, 'uniqueId': 5, 'globalId': None, 'success': True},
{'objectId': 3, 'uniqueId': 5, 'globalId': None, 'success': True},
{'objectId': 4, 'uniqueId': 5, 'globalId': None, 'success': True},
{'objectId': 5, 'uniqueId': 5, 'globalId': None, 'success': True},
{'objectId': 6, 'uniqueId': 6, 'globalId': None, 'success': True},
{'objectId': 7, 'uniqueId': 7, 'globalId': None, 'success': True},
{'objectId': 8, 'uniqueId': 8, 'globalId': None, 'success': True},
{'objectId': 9, 'uniqueId': 9, 'globalId': None, 'success': True},
{'objectId': 10, 'uniqueId': 10, 'globalId': None, 'success': True},
{'objectId': 11, 'uniqueId': 11, 'globalId': None, 'success': True},
{'objectId': 12, 'uniqueId': 12, 'globalId': None, 'success': True},
{'objectId': 13, 'uniqueId': 13, 'globalId': None, 'success': True},
{'objectId': 14, 'uniqueId': 14, 'globalId': None, 'success': True},
{'objectId': 15, 'uniqueId': 15, 'globalId': None, 'success': True}]}

edit_features(adds=None, updates=None, deletes=None, gdb_version=None, use_global_ids=False, rollback_on_failure=True, return_edit_moment=False, attachments=None, true_curve_client=False, session_id=None, use_previous_moment=False, datum_transformation=None, future=False)

Adds, updates, and deletes features to the associated FeatureLayer or Table in a single call.

Note

When making large number (250+ records at once) of edits, append should be used over edit_features to improve performance and ensure service stability.

Inputs	Description
adds	Optional FeatureSet/List. The array of features to be added.
updates	Optional FeatureSet/List. The array of features to be updated.
deletes	Optional FeatureSet/List. string of OIDs to remove from service
use_global_ids	Optional boolean. Instead of referencing the default Object ID field, the service will look at a GUID field to track changes. This means the GUIDs will be passed instead of OIDs for delete, update or add features.
gdb_version	Optional string. The geodatabase version to apply edits. This parameter applies only if the isDataVersioned property of the layer is true.
rollback_on_failure	Optional boolean. Optional parameter to specify if the edits should be applied only if all submitted edits succeed. If false, the server will apply the edits that succeed even if some of the submitted edits fail. If true, the server will apply the edits only if all edits succeed. The default value is true.
return_edit_moment	Optional boolean. Introduced at 10.5, only applicable with ArcGIS Server services only. Specifies whether the response will report the time edits were applied. If set to true, the server will return the time in the response’s editMoment key. The default value is false.
attachments	Optional Dict. This parameter adds, updates, or deletes attachments. It applies only when the use_global_ids parameter is set to true. For adds, the globalIds of the attachments provided by the client are preserved. When useGlobalIds is true, updates and deletes are identified by each feature or attachment globalId, rather than their objectId or attachmentId. This parameter requires the layer’s supportsApplyEditsWithGlobalIds property to be true. Attachments to be added or updated can use either pre-uploaded data or base 64 encoded data. Inputs Inputs Description adds List of attachments to add. updates List of attachements to update deletes List of attachments to delete See the Apply Edits to a Feature Service layer in the ArcGIS REST API for more information.
true_curve_client	Optional boolean. Introduced at 10.5. Indicates to the server whether the client is true curve capable. When set to true, this indicates to the server that true curve geometries should be downloaded and that geometries containing true curves should be consumed by the map service without densifying it. When set to false, this indicates to the server that the client is not true curves capable. The default value is false.
session_id	Optional String. Introduced at 10.6. The session_id is a GUID value that clients establish at the beginning and use throughout the edit session. The sessonID ensures isolation during the edit session. The session_id parameter is set by a client during long transaction editing on a branch version.
use_previous_moment	Optional Boolean. Introduced at 10.6. The use_previous_moment parameter is used to apply the edits with the same edit moment as the previous set of edits. This allows an editor to apply single block of edits partially, complete another task and then complete the block of edits. This parameter is set by a client during long transaction editing on a branch version. When set to true, the edits are applied with the same edit moment as the previous set of edits. When set to false or not set (default) the edits are applied with a new edit moment.
datum_transformation	Optional Integer/Dictionary. This parameter applies a datum transformation while projecting geometries in the results when out_sr is different than the layer’s spatial reference. When specifying transformations, you need to think about which datum transformation best projects the layer (not the feature service) to the outSR and sourceSpatialReference property in the layer properties. For a list of valid datum transformation ID values ad well-known text strings, see Using spatial references. For more information on datum transformations please see the transformation parameter in the Project operation documentation. Examples Inputs Description WKID Integer. Ex: datum_transformation=4326 WKT Dict. Ex: datum_transformation={“wkt”: “<WKT>”} Composite Dict. Ex: datum_transformation=```{‘geoTransforms’:[{‘wkid’:<id>,’forward’:<true|false>},{‘wkt’:’<WKT>’,’forward’:<True|False>}]}```
future	Optional Boolean. If the FeatureLayer has supportsAsyncApplyEdits set to True, then edits can be applied asynchronously. If True, a future object will be returned and the process will not wait for the task to complete. The default is False, which means wait for results.

Returns:

A dictionary by default, or If future = True, then the result is a Future object. Call result() to get the response.

# Usage Example 1:

feature = [
{
    'attributes': {
        'ObjectId': 1,
        'UpdateDate': datetime.datetime.now(),
    }
}]
lyr.edit_features(updates=feature)

# Usage Example 2:

adds = {"geometry": {"x": 500, "y": 500, "spatialReference":
                    {"wkid": 102100, "latestWkid": 3857}},
        "attributes": {"ADMIN_NAME": "Fake Location"}
        }
lyr.edit_features(adds=[adds])

# Usage Example 3:

lyr.edit_features(deletes=[2542])

property estimates

Returns up-to-date approximations of layer information, such as row count and extent. Layers that support this property will include infoInEstimates information in the layer’s properties.

Currently available with ArcGIS Online and Enterprise 10.9.1+

Returns:

Dict[str, Any]

export_attachments(output_folder, label_field=None)

Exports attachments from the FeatureLayer in Imagenet format using the output_label_field.

Parameter	Description
output_folder	Required string. Output folder where the attachments will be stored. If None, a default folder is created
label_field	Optional string. Field which contains the label/category of each feature.

Returns:

Nothing is returned from this method

property field_groups

Returns the defined list of field groups for a given layer.

Returns:

dict[str,Any]

classmethod fromitem(item, layer_id=0)

The fromitem method creates a FeatureLayer from an Item object.

Parameter	Description
item	Required Item object. The type of item should be a Feature Service that represents a FeatureLayerCollection
layer_id	Required Integer. the id of the layer in feature layer collection (feature service). The default for layer_id is 0.

Returns:

A FeatureSet object

# Usage Example

>>> from arcgis.features import FeatureLayer

>>> gis = GIS("pro")
>>> buck = gis.content.search("owner:"+ gis.users.me.username)
>>> buck_1 =buck[1]
>>> buck_1.type
'Feature Service'
>>> new_layer= FeatureLayer.fromitem(item = buck_1)
>>> type(new_layer)
<class 'arcgis.features.layer.FeatureLayer'>

generate_renderer(definition, where=None)

Groups data using the supplied definition (classification definition) and an optional where clause. The result is a renderer object.

Note

Use baseSymbol and colorRamp to define the symbols assigned to each class. If the operation is performed on a table, the result is a renderer object containing the data classes and no symbols.

Parameter	Description
definition	Required dict. The definition using the renderer that is generated. Use either class breaks or unique value classification definitions. See Classification Objects for additional details.
where	Optional string. A where clause for which the data needs to be classified. Any legal SQL where clause operating on the fields in the dynamic layer/table is allowed.

Returns:

A JSON Dictionary

# Example Usage
FeatureLayer.generate_renderer(
    definition = {"type":"uniqueValueDef",
                  "uniqueValueFields":["Has_Pool"],
                  "fieldDelimiter": ",",
                  "baseSymbol":{
                      "type": "esriSFS",
                      "style": "esriSLSSolid",
                      "width":2
                      },
                    "colorRamp":{
                        "type":"algorithmic",
                        "fromColor":[115,76,0,255],
                        "toColor":[255,25,86,255],
                        "algorithm": "esriHSVAlgorithm"
                        }
                },
    where = "POP2000 > 350000"
    )

get_html_popup(oid)

The get_html_popup method provides details about the HTML pop-up authored by the User using ArcGIS Pro or ArcGIS Desktop.

Parameter	Description
oid	Optional string. Object id of the feature to get the HTML popup.

Returns:

A string

get_unique_values(attribute, query_string='1=1')

Retrieves a list of unique values for a given attribute in the FeatureLayer.

Parameter	Description
attribute	Required string. The feature layer attribute to query.
query_string	Optional string. SQL Query that will be used to filter attributes before unique values are returned. ex. “name_2 like ‘%K%’”

Returns:

A list of unique values

# Usage Example with only a "where" sql statement

>>> from arcgis.features import FeatureLayer

>>> gis = GIS("pro")
>>> buck = gis.content.search("owner:"+ gis.users.me.username)
>>> buck_1 =buck[1]
>>> lay = buck_1.layers[0]
>>> layer = lay.get_unique_values(attribute = "COUNTY")
>>> layer
['PITKIN', 'PLATTE', 'TWIN FALLS']

property manager

The manager property is a helper object to manage the FeatureLayer, such as updating its definition.

Returns:

A FeatureLayerManager

# Usage Example

>>> manager = FeatureLayer.manager

property metadata

Get the Feature Layer’s metadata.

Note

If metadata is disabled on the GIS or the layer does not support metadata, None will be returned.

Returns:

String of the metadata, if any

property properties

The properties property retrieves and set properties of this object.

query(where='1=1', out_fields='*', time_filter=None, geometry_filter=None, return_geometry=True, return_count_only=False, return_ids_only=False, return_distinct_values=False, return_extent_only=False, group_by_fields_for_statistics=None, statistic_filter=None, result_offset=None, result_record_count=None, object_ids=None, distance=None, units=None, max_allowable_offset=None, out_sr=None, geometry_precision=None, gdb_version=None, order_by_fields=None, out_statistics=None, return_z=False, return_m=False, multipatch_option=None, quantization_parameters=None, return_centroid=False, return_all_records=True, result_type=None, historic_moment=None, sql_format=None, return_true_curves=False, return_exceeded_limit_features=None, as_df=False, datum_transformation=None, time_reference_unknown_client=None, **kwargs)

The query method queries a FeatureLayer based on a sql statement.

Parameter	Description
where	Optional string. SQL-92 WHERE clause syntax on the fields in the layer is supported for most data sources. Some data sources have restrictions on what is supported. Hosted feature services in ArcGIS Enterprise running on a spatiotemporal data source only support a subset of SQL-92. Below is a list of supported SQL-92 with spatiotemporal-based feature services: ( ‘<=’ | ‘>=’ | ‘<’ | ‘>’ | ‘=’ | ‘!=’ | ‘<>’ | LIKE ) (AND | OR) (IS | IS_NOT) (IN | NOT_IN) ( ‘(’ ( expr ( ‘,’ expr )* )? ‘)’ ) COLUMN_NAME BETWEEN LITERAL_VALUE AND LITERAL_VALUE
out_fields	Optional 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. Note If specifying return_count_only, return_id_only, or return_extent_only as True, do not specify this parameter in order to avoid errors.
object_ids	Optional string. The object IDs of this layer or table to be queried. The object ID values should be a comma-separated string. Note There might be a drop in performance if the layer/table data source resides in an enterprise geodatabase and more than 1,000 object_ids are specified.
distance	Optional integer. 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.
units	Optional string. 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`
time_filter	Optional list. The format is of [<startTime>, <endTime>] using datetime.date, datetime.datetime or timestamp in milliseconds. Syntax: time_filter=[<startTime>, <endTime>] ; specified as datetime.date, datetime.datetime or timestamp in milliseconds
geometry_filter	Optional from filters. Allows for the information to be filtered on spatial relationship with another geometry.
max_allowable_offset	Optional float. This option can be used to specify the max_allowable_offset to be used for generalizing geometries returned by the query operation. The max_allowable_offset is in the units of out_sr. If out_sr is not specified, max_allowable_offset is assumed to be in the unit of the spatial reference of the layer.
out_sr	Optional Integer. The WKID for the spatial reference of the returned geometry.
geometry_precision	Optional Integer. 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).
gdb_version	Optional string. The geodatabase version to query. This parameter applies only if the isDataVersioned property of the layer is true. If this is not specified, the query will apply to the published map’s version.
return_geometry	Optional boolean. If true, geometry is returned with the query. Default is true.
return_distinct_values	Optional boolean. If true, it returns distinct values based on the fields specified in out_fields. This parameter applies only if the supportsAdvancedQueries property of the layer is true. This parameter can be used with return_count_only to return the count of distinct values of subfields. Note Make sure to set return_geometry to False if this is set to True. Otherwise, reliable results will not be returned.
return_ids_only	Optional boolean. Default is False. If true, the response only includes an array of object IDs. Otherwise, the response is a feature set. When object_ids are specified, setting this parameter to true is invalid.
return_count_only	Optional boolean. 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.
return_extent_only	Optional boolean. 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.
order_by_fields	Optional string. 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. example: STATE_NAME ASC, RACE DESC, GENDER Note If specifying return_count_only, return_id_only, or return_extent_only as True, do not specify this parameter in order to avoid errors.
group_by_fields_for_statistics	Optional string. One or more field names on which the values need to be grouped for calculating the statistics. example: STATE_NAME, GENDER
out_statistics	Optional list of dictionaries. The definitions for one or more field-based statistics to be calculated. Syntax: [ { “statisticType”: “<count | sum | min | max | avg | stddev | var>”, “onStatisticField”: “Field1”, “outStatisticFieldName”: “Out_Field_Name1” }, { “statisticType”: “<count | sum | min | max | avg | stddev | var>”, “onStatisticField”: “Field2”, “outStatisticFieldName”: “Out_Field_Name2” } ]
statistic_filter	Optional StatisticFilter instance. The definitions for one or more field-based statistics can be added, e.g. statisticType, onStatisticField, or outStatisticFieldName. Syntax: sf = StatisticFilter() sf.add(statisticType=”count”, onStatisticField=”1”, outStatisticFieldName=”total”) sf.filter
return_z	Optional boolean. 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.
return_m	Optional boolean. 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.
multipatch_option	Optional x/y footprint. This option dictates how the geometry of a multipatch feature will be returned.
result_offset	Optional integer. 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). This option is ignored if return_all_records is True (i.e. by default).
result_record_count	Optional integer. This option can be used for fetching query results up to the result_record_count specified. When result_offset is specified but this parameter is not, the map service defaults it to max_record_count. The maximum value for this parameter is the value of the layer’s max_record_count property. This option is ignored if return_all_records is True (i.e. by default).
quantization_parameters	Optional dict. Used to project the geometry onto a virtual grid, likely representing pixels on the screen.
return_centroid	Optional boolean. Used to return the geometry centroid associated with each feature returned. If true, the result includes the geometry centroid. The default is false. Only supported on layer with polygon geometry type.
return_all_records	Optional boolean. When True, the query operation will call the service until all records that satisfy the where_clause are returned. Note: result_offset and result_record_count will be ignored if return_all_records is True. Also, if return_count_only, return_ids_only, or return_extent_only are True, this parameter will be ignored.
result_type	Optional string. The result_type parameter can be used to control the number of features returned by the query operation. Values: None | standard | tile
historic_moment	Optional integer. The historic moment to query. This parameter applies only if the layer is archiving enabled and the supportsQueryWithHistoricMoment property is set to true. This property is provided in the layer resource. If historic_moment is not specified, the query will apply to the current features.
sql_format	Optional string. The sql_format parameter can be either standard SQL92 standard or it can use the native SQL of the underlying datastore native. The default is none which means the sql_format depends on useStandardizedQuery parameter. Values: none | standard | native
return_true_curves	Optional boolean. When set to true, returns true curves in output geometries. When set to false, curves are converted to densified polylines or polygons.
return_exceeded_limit_features	Optional boolean. Optional parameter which is true by default. When set to true, features are returned even when the results include ‘exceededTransferLimit’: True. When set to false and querying with resultType = tile features are not returned when the results include ‘exceededTransferLimit’: True. This allows a client to find the resolution in which the transfer limit is no longer exceeded without making multiple calls.
as_df	Optional boolean. If True, the results are returned as a DataFrame instead of a FeatureSet.
datum_transformation	Optional Integer/Dictionary. This parameter applies a datum transformation while projecting geometries in the results when out_sr is different than the layer’s spatial reference. When specifying transformations, you need to think about which datum transformation best projects the layer (not the feature service) to the outSR and sourceSpatialReference property in the layer properties. For a list of valid datum transformation ID values ad well-known text strings, see Coordinate systems and transformations. For more information on datum transformations, please see the transformation parameter in the Project operation. Examples Inputs Description WKID Integer. Ex: datum_transformation=4326 WKT Dict. Ex: datum_transformation={“wkt”: “<WKT>”} Composite Dict. Ex: datum_transformation=```{‘geoTransforms’:[{‘wkid’:<id>,’forward’:<true|false>},{‘wkt’:’<WKT>’,’forward’:<True|False>}]}```
kwargs	Optional dict. Optional parameters that can be passed to the Query function. This will allow users to pass additional parameters not explicitly implemented on the function. A complete list of functions available is documented on the Query REST API.

Returns:

A FeatureSet containing the features matching the query unless another return type is specified, such as return_count_only, return_extent_only, or return_ids_only.

# Usage Example with only a "where" sql statement

>>> feat_set = feature_layer.query(where = "OBJECTID= 1")
>>> type(feat_set)
<arcgis.Features.FeatureSet>
>>> feat_set[0]
<Feature 1>

# Usage Example of an advanced query returning the object IDs instead of Features

>>> id_set = feature_layer.query(where = "OBJECTID1",
                                   out_fields = ["FieldName1, FieldName2"],
                                   distance = 100,
                                   units = 'esriSRUnit_Meter',
                                   return_ids_only = True)

>>> type(id_set)
<Array>
>>> id_set[0]
<"Item_id1">

# Usage Example of an advanced query returning the number of features in the query

>>> search_count = feature_layer.query(where = "OBJECTID1",
                                   out_fields = ["FieldName1, FieldName2"],
                                   distance = 100,
                                   units = 'esriSRUnit_Meter',
                                   return_count_only = True)

>>> type(search_count)
<Integer>
>>> search_count
<149>

# Usage Example with "out_statistics" parameter

>>> stats = [{
        'onStatisticField': "1",
        'outStatisticFieldName': "total",
        'statisticType': "count"
    }]
>>> feature_layer.query(out_statistics=stats, as_df=True) # returns a DataFrame containting total count

# Usage Example with "StatisticFilter" parameter

>>> from arcgis._impl.common._filters import StatisticFilter
>>> sf1 = StatisticFilter()
>>> sf1.add(statisticType="count", onStatisticField="1", outStatisticFieldName="total")
>>> sf1.filter # This is to print the filter content
>>> feature_layer.query(statistic_filter=sf1, as_df=True) # returns a DataFrame containing total count

query_3d(where=None, out_fields=None, object_ids=None, distance=None, units=None, time_filter=None, geometry_filter=None, gdb_version=None, return_distinct_values=None, order_by_fields=None, group_by_fields_for_statistics=None, out_statistics=None, result_offset=None, result_record_count=None, historic_moment=None, sql_format=None, format_3d_objects=None, time_reference_unknown_client=None)

The query3D operation allows clients to query 3D object features and is based on the feature service layer query operation. The 3D object feature layer still supports layer and service level feature service query operations.

Parameter	Description
where	Optional string. SQL-92 WHERE clause syntax on the fields in the layer is supported for most data sources. Some data sources have restrictions on what is supported. Hosted feature services in ArcGIS Enterprise running on a spatiotemporal data source only support a subset of SQL-92. Below is a list of supported SQL-92 with spatiotemporal-based feature services: ( ‘<=’ | ‘>=’ | ‘<’ | ‘>’ | ‘=’ | ‘!=’ | ‘<>’ | LIKE ) (AND | OR) (IS | IS_NOT) (IN | NOT_IN) ( ‘(’ ( expr ( ‘,’ expr )* )? ‘)’ ) COLUMN_NAME BETWEEN LITERAL_VALUE AND LITERAL_VALUE
out_fields	Optional 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 to return all fields in the result.
object_ids	Optional string. The object IDs of this layer or table to be queried. The object ID values should be a comma-separated string. Note There might be a drop in performance if the layer/table data source resides in an enterprise geodatabase and more than 1,000 object_ids are specified.
distance	Optional integer. 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.
units	Optional string. 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`
time_filter	Optional list. The format is of [<startTime>, <endTime>] using datetime.date, datetime.datetime or timestamp in milliseconds. Syntax: time_filter=[<startTime>, <endTime>] ; specified as datetime.date, datetime.datetime or timestamp in milliseconds
geometry_filter	Optional from filters. Allows for the information to be filtered on spatial relationship with another geometry.
gdb_version	Optional string. The geodatabase version to query. This parameter applies only if the isDataVersioned property of the layer is true. If this is not specified, the query will apply to the published map’s version.
return_distinct_values	Optional boolean. If true, it returns distinct values based on the fields specified in out_fields. This parameter applies only if the supportsAdvancedQueries property of the layer is true. This parameter can be used with return_count_only to return the count of distinct values of subfields. Note Make sure to set return_geometry to False if this is set to True. Otherwise, reliable results will not be returned.
order_by_fields	Optional string. 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. example: STATE_NAME ASC, RACE DESC, GENDER Note If specifying return_count_only, return_id_only, or return_extent_only as True, do not specify this parameter in order to avoid errors.
group_by_fields_for_statistics	Optional string. One or more field names on which the values need to be grouped for calculating the statistics. example: STATE_NAME, GENDER
out_statistics	Optional list of dictionaries. The definitions for one or more field-based statistics to be calculated. Syntax: [ { “statisticType”: “<count | sum | min | max | avg | stddev | var>”, “onStatisticField”: “Field1”, “outStatisticFieldName”: “Out_Field_Name1” }, { “statisticType”: “<count | sum | min | max | avg | stddev | var>”, “onStatisticField”: “Field2”, “outStatisticFieldName”: “Out_Field_Name2” } ]
result_offset	Optional integer. 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). This option is ignored if return_all_records is True (i.e. by default).
result_record_count	Optional integer. This option can be used for fetching query results up to the result_record_count specified. When result_offset is specified but this parameter is not, the map service defaults it to max_record_count. The maximum value for this parameter is the value of the layer’s max_record_count property. This option is ignored if return_all_records is True (i.e. by default).
historic_moment	Optional integer. The historic moment to query. This parameter applies only if the layer is archiving enabled and the supportsQueryWithHistoricMoment property is set to true. This property is provided in the layer resource. If historic_moment is not specified, the query will apply to the current features.
sql_format	Optional string. The sql_format parameter can be either standard SQL92 standard or it can use the native SQL of the underlying datastore native. The default is none which means the sql_format depends on useStandardizedQuery parameter. Values: none | standard | native
format_3d_objects	Optional string. Specifies the 3D format that will be used to request a feature. If set to a valid format ID (see layer resource), the geometry of the feature response will be a 3D envelope of the 3D object and will include asset maps for the 3D object. Since formats are created asynchronously, review the flags field in the asset map to determine if the format is available (conversionStatus is COMPLETED). If conversionStatus is INPROGRESS, the format is not ready. Request the feature again later. If a feature does not have the specified format, the feature will still be returned according to the query parameters (such as the where clause), but the asset mapping will be missing. Values: “3D_dae” | “3D_dwg” | “3D_fbx” | “3D_glb” | “3D_gltf” | “3D_ifc” | “3D_obj” | “3D_shapebuffer” | “3D_shapebufferg” | “3D_usdc” | “3D_usdz”
time_reference_unknown_client	Optional boolean. Setting time_reference_unknown_client as True indicates that the client is capable of working with data values that are not in UTC. If its not set to true, and the service layer’s datesInUnknownTimeZone property is true, then an error is returned. The default is False Its possible to define a service’s time zone of date fields as unknown. Setting the time zone as unknown means that date values will be returned as-is from the database, rather than as date values in UTC. Non-hosted feature services can be set to use an unknown time zone using ArcGIS Server Manager. Setting the time zones to unknown also sets the datesInUnknownTimeZone layer property as true. Currently, hosted feature services do not support this setting. This setting does not apply to editor tracking date fields which are stored and returned in UTC even when the time zone is set to unknown. Most clients released prior to ArcGIS Enterprise 10.9 will not be able to work with feature services that have an unknown time setting.

Returns:

A dictionary containing the feature, asset map, and asset information for the layer.

USAGE EXAMPLE: Query 3D objects

# Import the required modules
from arcgis.gis import GIS
from arcgis.features import FeatureLayer

# Connect to your GIS
gis = GIS(profile="your_enterprise_profile")

# Search for the feature layer
search_result = gis.content.search("3D Object Feature Layer", "Feature Layer")
feature_layer = search_result[0]

# Create a FeatureLayer object
layer = FeatureLayer(feature_layer.url, gis)

# Query the 3D objects
result = layer.query_3d(where="OBJECTID < 10", out_fields="*", format_3d_objects="3D_dae")
print(result)

query_analytics(out_analytics, where='1=1', out_fields='*', analytic_where=None, geometry_filter=None, out_sr=None, return_geometry=True, order_by=None, result_type=None, cache_hint=None, result_offset=None, result_record_count=None, quantization_param=None, sql_format=None, future=True, **kwargs)

The query_analytics exposes the standard SQL windows functions that compute aggregate and ranking values based on a group of rows called window partition. The window function is applied to the rows after the partitioning and ordering of the rows. query_analytics defines a window or user-specified set of rows within a query result set. query_analytics can be used to compute aggregated values such as moving averages, cumulative aggregates, or running totals.

Note

See the query method for a similar function.

SQL Windows Function

A window function performs a calculation across a set of rows (SQL partition or window) that are related to the current row. Unlike regular aggregate functions, use of a window function does not return single output row. The rows retain their separate identities with each calculation appended to the rows as a new field value. The window function can access more than just the current row of the query result.

query_analytics currently supports the following windows functions:

• Aggregate functions

• Analytic functions

• Ranking functions

Aggregate Functions

Aggregate functions are deterministic function that perform a calculation on a set of values and return a single value. They are used in the select list with optional HAVING clause. GROUP BY clause can also be used to calculate the aggregation on categories of rows. query_analytics can be used to calculate the aggregation on a specific range of value. Supported aggregate functions are:

• Min

• Max

• Sum

• Count

• AVG

• STDDEV

• VAR

Analytic Functions

Several analytic functions available now in all SQL vendors to compute an aggregate value based on a group of rows or windows partition. Unlike aggregation functions, analytic functions can return single or multiple rows for each group.

• CUM_DIST

• FIRST_VALUE

• LAST_VALUE

• LEAD

• LAG

• PERCENTILE_DISC

• PERCENTILE_CONT

• PERCENT_RANK

Ranking Functions

Ranking functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows.

• RANK

• NTILE

• DENSE_RANK

• ROW_NUMBER

Partitioning

Partitions are extremely useful when you need to calculate the same metric over different group of rows. It is very powerful and has many potential usages. For example, you can add partition by to your window specification to look at different groups of rows individually.

partitionBy clause divides the query result set into partitions and the sql window function is applied to each partition. The ‘partitionBy’ clause normally refers to the column by which the result is partitioned. ‘partitionBy’ can also be a value expression (column expression or function) that references any of the selected columns (not aliases).

Parameter	Description
out_analytics	Required List. A set of analytics to calculate on the Feature Layer. The definitions for one or more field-based or expression analytics to be computed. This parameter is supported only on layers/tables that return true for supportsAnalytics property. Note If outAnalyticFieldName is empty or missing, the server assigns a field name to the returned analytic field. The argument should be a list of dictionaries that define analystics. An analytic definition specifies: the type of analytic - key: analyticType the field or expression on which it is to be computed - key: onAnalyticField the resulting output field name -key: outAnalyticFieldName the analytic specifications - analysticParameters See Overview for details. # Dictionary structure and options for this parameter [ { "analyticType": "<COUNT | SUM | MIN | MAX | AVG | STDDEV | VAR | FIRST_VALUE, LAST_VALUE, LAG, LEAD, PERCENTILE_CONT, PERCENTILE_DISC, PERCENT_RANK, RANK, NTILE, DENSE_RANK, EXPRESSION>", "onAnalyticField": "Field1", "outAnalyticFieldName": "Out_Field_Name1", "analyticParameters": { "orderBy": "<orderBy expression", "value": <double value>,// percentile value "partitionBy": "<field name or expression>", "offset": <integer>, // used by LAG/LEAD "windowFrame": { "type": "ROWS" | "RANGE", "extent": { "extentType": "PRECEDING" | "BOUNDARY", "PRECEDING": { "type": <"UNBOUNDED" | "NUMERIC_CONSTANT" | "CURRENT_ROW"> "value": <numeric constant value> } "BOUNDARY": { "start": "UNBOUNDED_PRECEDING", "NUMERIC_PRECEDING", "CURRENT_ROW", "startValue": <numeric constant value>, "end": <"UNBOUNDED_FOLLOWING" | "NUMERIC_FOLLOWING" | "CURRENT_ROW", "endValue": <numeric constant value> } } } } } } ] # Usage Example: >>> out_analytics = [{"analyticType": "FIRST_VALUE", "onAnalyticField": "POP1990", "analyticParameters": { "orderBy": "POP1990", "partitionBy": "state_name" }, "outAnalyticFieldName": "FirstValue"}]
where	Optional string. The default is 1=1. The selection sql statement.
out_fields	Optional List of field names to return. Field names can be specified either as a List of field names or as a comma separated string. The default is “*”, which returns all the fields.
analytic_where	Optional String. A where clause for the query filter that applies to the result set of applying the source where clause and all other params.
geometry_filter	Optional from arcgis.geometry.filter. Allows for the information to be filtered on spatial relationship with another geometry.
out_sr	Optional Integer. The WKID for the spatial reference of the returned geometry.
return_geometry	Optional boolean. If true, geometry is returned with the query. Default is true.
order_by	Optional string. 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. example: STATE_NAME ASC, RACE DESC, GENDER
result_type	Optional string. The result_type parameter can be used to control the number of features returned by the query operation. Values: None | standard | tile
cache_hint	Optional Boolean. If you are performing the same query multiple times, a user can ask the server to cache the call to obtain the results quicker. The default is False.
result_offset	Optional integer. 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).
result_record_count	Optional integer. This option can be used for fetching query results up to the result_record_count specified. When result_offset is specified but this parameter is not, the map service defaults it to max_record_count. The maximum value for this parameter is the value of the layer’s max_record_count property.
quantization_parameters	Optional dict. Used to project the geometry onto a virtual grid, likely representing pixels on the screen.
sql_format	Optional string. The sql_format parameter can be either standard SQL92 standard or it can use the native SQL of the underlying datastore native. The default is none which means the sql_format depends on useStandardizedQuery parameter. Values: none | standard | native
future	Optional Boolean. This determines if a Future object is returned (True) the method returns the results directly (False).

Returns:

A Pandas DataFrame (pd.DataFrame)

query_date_bins(bin_field, bin_specs, out_statistics, time_filter=None, geometry_filter=None, bin_order=None, where=None, return_centroid=False, in_sr=None, out_sr=None, spatial_rel=None, quantization_params=None, result_offset=None, result_record_count=None, return_exceeded_limit_features=False)

The query_date_bins operation is performed on a FeatureLayer. This operation returns a histogram of features divided into bins based on a date field. The response can include statistical aggregations for each bin, such as a count or sum, and may also include the aggregate geometries (in other words, centroid) for point layers.

The parameters define the bins, the aggregate information returned, and the included features. Bins are defined using the bin parameter. The out_statistics and return_centroid parameters define the information each bin will provide. Included features can be specified by providing a time extent, where condition, and a spatial filter, similar to a query operation.

The contents of the bin_specs parameter provide flexibility for defining bin boundaries. The bin_specs parameter’s unit property defines the time width of each bin, such as one year, quarter, month, day, or hour. Fixed bins can use multiple units for these time widths. The result_offset property defines an offset within that time unit. For example, if your bin unit is day, and you want bin boundaries to go from noon to noon on the next day, the offset would be 12 hours.

Features can be manipulated with the time_filter, where, and geometry_filter parameters. By default, the result will expand to fit the feature’s earliest and latest point of time. The time_filter parameter defines a fixed starting point and ending point of the features based on the field used in binField. The where and geometry_filter parameters allow additional filters to be put on the data.

This operation is only supported on feature services using a spatiotemporal data store. As well, the service property supportsQueryDateBins must be set to true.

To use pagination with aggregated queries on hosted feature services in ArcGIS Enterprise, the supportsPaginationOnAggregatedQueries property must be true on the layer. Hosted feature services using a spatiotemporal data store do not currently support pagination on aggregated queries.

Parameter	Description
bin_field	Required String. The date field used to determine which bin each feature falls into.
bin_specs	Required Dict. A dictionary that describes the characteristics of bins, such as the size of the bin and its starting position. The size of each bin is determined by the number of time units denoted by the number and unit properties. The starting position of the bin is the earliest moment in the specified unit. For example, each year begins at midnight of January 1. An offset inside the bin parameter can provide an offset to the starting position of the bin. This can contain a positive or negative integer value. A bin can take two forms: either a calendar bin or a fixed bin. A calendar bin is aware of calendar-specific adjustments, such as daylight saving time and leap seconds. Fixed bins are, by contrast, always a specific unit of measurement (for example, 60 seconds in a minute, 24 hours in a day) regardless of where the date and time of the bin starts. For this reason, some calendar-specific units are only supported as calendar bins. # Calendar bin >>> bin_specs= {"calendarBin": {"unit": "year", "timezone": "US/Arizona", "offset": { "number": 5, "unit": "hour"} } } # Fixed bin >>> bin_specs= {"fixedBin": { "number": 12, "unit": "hour", "offset": { "number": 5, "unit": "hour"} } }
out_statistics	Required List of Dicts. The definitions for one or more field-based statistics to be calculated: { "statisticType": "<count | sum | min | max | avg | stddev | var>", "onStatisticField": "Field1", "outStatisticFieldName": "Out_Field_Name1" }
time_filter	Optional list. The format is of [<startTime>, <endTime>] using datetime.date, datetime.datetime or timestamp in milliseconds.
geometry_filter	Optional from filters. Allows for the information to be filtered on spatial relationship with another geometry.
bin_order	Optional String. Either “ASC” or “DESC”. Determines whether results are returned in ascending or descending order. Default is ascending.
where	Optional String. A WHERE clause for the query filter. SQL ‘92 WHERE clause syntax on the fields in the layer is supported for most data sources.
return_centroid	Optional Boolean. Returns the geometry centroid associated with all the features in the bin. If true, the result includes the geometry centroid. The default is false. This parameter is only supported on point data.
in_sr	Optional Integer. The WKID for the spatial reference of the input geometry.
out_sr	Optional Integer. The WKID for the spatial reference of the returned geometry.
spatial_rel	Optional String. The spatial relationship to be applied to the input geometry while performing the query. The supported spatial relationships include intersects, contains, envelop intersects, within, and so on. The default spatial relationship is intersects (esriSpatialRelIntersects). Other options are esriSpatialRelContains, esriSpatialRelCrosses, esriSpatialRelEnvelopeIntersects, esriSpatialRelIndexIntersects, esriSpatialRelOverlaps, esriSpatialRelTouches, and esriSpatialRelWithin.
quantization_params	Optional Dict. Used to project the geometry onto a virtual grid, likely representing pixels on the screen. # upperLeft origin position {"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} } } # lowerLeft origin position {"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} } } See Quantization parameters JSON properties for details on format of this parameter. Note This parameter only applies if the layer’s supportsCoordinateQuantization property is true.
result_offset	Optional Int. This parameter fetches query results by skipping the specified number of records and starting from the next record. The default is 0. Note: This parameter only applies if the layer’s supportsPagination property is true.
result_record_count	Optional Int. This parameter fetches query results up to the value specified. When result_offset is specified, but this parameter is not, the map service defaults to the layer’s maxRecordCount property. The maximum value for this parameter is the value of the maxRecordCount property. The minimum value entered for this parameter cannot be below 1. Note: This parameter only applies if the layer’s supportsPagination property is true.
return_exceeded_limit_features	Optional Boolean. When set to True, features are returned even when the results include "exceededTransferLimit": true. This allows a client to find the resolution in which the transfer limit is no longer exceeded withou making multiple calls. The default value is False.

Returns:

A Dict containing the resulting features and fields.

# Usage Example

>>> flyr_item = gis.content.search("*", "Feature Layer")[0]
>>> flyr = flyr_item.layers[0]

>>> qy_result = flyr.query_date_bins(bin_field="boundary",
                                     bin_specs={"calendarBin":
                                                  {"unit":"day",
                                                   "timezone": "America/Los_Angeles",
                                                   "offset": {"number": 8,
                                                              "unit": "hour"}
                                                  }
                                                },
                                     out_statistics=[{"statisticType": "count",
                                                      "onStatisticField": "objectid",
                                                      "outStatisticFieldName": "item_sold_count"},
                                                     {"statisticType": "avg",
                                                     "onStatisticField": "price",
                                                     "outStatisticFieldName": "avg_daily_revenue "}],
                                     time=[1609516800000, 1612195199999])
>>> qy_result
   {
    "features": [
      {
        "attributes": {
          "boundary": 1609516800000,
          "avg_daily_revenue": 300.40,
          "item_sold_count": 79
        }
      },
      {
        "attributes": {
          "boundary": 1612108800000,
          "avg_daily_revenue": null,
          "item_sold_count": 0
        }
      }
    ],
    "fields": [
      {
        "name": "boundary",
        "type": "esriFieldTypeDate"
      },
      {
        "name": "item_sold_count",
        "alias": "item_sold_count",
        "type": "esriFieldTypeInteger"
      },
      {
        "name": "avg_daily_revenue",
        "alias": "avg_daily_revenue",
        "type": "esriFieldTypeDouble"
      }
    ],
    "exceededTransferLimit": false
  }

query_related_records(object_ids, relationship_id, out_fields='*', definition_expression=None, return_geometry=True, max_allowable_offset=None, geometry_precision=None, out_wkid=None, gdb_version=None, return_z=False, return_m=False, historic_moment=None, return_true_curve=False)

The query_related_records operation is performed on a FeatureLayer resource. The result of this operation are feature sets grouped by source layer/table object IDs. Each feature set contains Feature objects including the values for the fields requested by the user. For related layers, if you request geometry information, the geometry of each feature is also returned in the feature set. For related tables, the feature set does not include geometries.

Note

See the query method for a similar function.

Parameter	Description
object_ids	Required string. The object IDs of the table/layer to be queried
relationship_id	Required string. The ID of the relationship to be queried.
out_fields	Required string. the list of fields from the related table/layer to be included in the returned feature set. This list is a comma delimited list of field names. If you specify the shape field in the list of return fields, it is ignored. To request geometry, set return_geometry to true. You can also specify the wildcard “*” as the value of this parameter. In this case, the results will include all the field values.
definition_expression	Optional string. The definition expression to be applied to the related table/layer. From the list of objectIds, only those records that conform to this expression are queried for related records.
return_geometry	Optional boolean. If true, the feature set includes the geometry associated with each feature. The default is true.
max_allowable_offset	Optional float. This option can be used to specify the max_allowable_offset to be used for generalizing geometries returned by the query operation. The max_allowable_offset is in the units of the outSR. If out_wkid is not specified, then max_allowable_offset is assumed to be in the unit of the spatial reference of the map.
geometry_precision	Optional integer. This option can be used to specify the number of decimal places in the response geometries.
out_wkid	Optional Integer. The spatial reference of the returned geometry.
gdb_version	Optional string. The geodatabase version to query. This parameter applies only if the isDataVersioned property of the layer queried is true.
return_z	Optional boolean. 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.
return_m	Optional boolean. 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.
historic_moment	Optional Integer/datetime. The historic moment to query. This parameter applies only if the supportsQueryWithHistoricMoment property of the layers being queried is set to true. This setting is provided in the layer resource. If historic_moment is not specified, the query will apply to the current features. Syntax: historic_moment=<Epoch time in milliseconds>
return_true_curves	Optional boolean. Optional parameter that is false by default. When set to true, returns true curves in output geometries; otherwise, curves are converted to densified Polyline or Polygon objects.

Returns:

Dictionary of the query results

# Usage Example:

# Query returning the related records for a feature with objectid value of 2,
# returning the values in the 6 attribute fields defined in the `field_string`
# variable:

>>> field_string = "objectid,attribute,system_name,subsystem_name,class_name,water_regime_name"
>>> rel_records = feat_lyr.query_related_records(object_ids = "2",
                                                 relationship_id = 0,
                                                 out_fields = field_string,
                                                 return_geometry=True)

>>> list(rel_records.keys())
['fields', 'relatedRecordGroups']

>>> rel_records["relatedRecordGroups"]
[{'objectId': 2,
  'relatedRecords': [{'attributes': {'objectid': 686,
     'attribute': 'L1UBHh',
     'system_name': 'Lacustrine',
     'subsystem_name': 'Limnetic',
     'class_name': 'Unconsolidated Bottom',
     'water_regime_name': 'Permanently Flooded'}}]}]

query_top_features(top_filter=None, where=None, objectids=None, start_time=None, end_time=None, geometry_filter=None, out_fields='*', return_geometry=True, return_centroid=False, max_allowable_offset=None, out_sr=None, geometry_precision=None, return_ids_only=False, return_extents_only=False, order_by_field=None, return_z=False, return_m=False, result_type=None, as_df=True)

The query_top_features is performed on a FeatureLayer. This operation returns a feature set or spatially enabled dataframe based on the top features by order within a group. For example, when querying counties in the United States, you want to return the top five counties by population in each state. To do this, you can use query_top_features to group by state name, order by desc on the population and return the first five rows from each group (state).

The top_filter parameter is used to set the group by, order by, and count criteria used in generating the result. The operation also has many of the same parameters (for example, where and geometry) as the layer query operation. However, unlike the layer query operation, query_top_feaures does not support parameters such as outStatistics and its related parameters or return distinct values. Consult the advancedQueryCapabilities layer property for more details.

If the feature layer collection supports the query_top_feaures operation, it will include “supportsTopFeaturesQuery”: True, in the advancedQueryCapabilities layer property.

Note

See the query method for a similar function.

Parameter	Description
top_filter	Required Dict. The top_filter define the aggregation of the data. groupByFields define the field or fields used to aggregate your data. topCount defines the number of features returned from the top features query and is a numeric value. orderByFields defines the order in which the top features will be returned. orderByFields can be specified in either ascending (asc) or descending (desc) order, ascending being the default. Example: {“groupByFields”: “worker”, “topCount”: 1, “orderByFields”: “employeeNumber”}
where	Optional String. A WHERE clause for the query filter. SQL ‘92 WHERE clause syntax on the fields in the layer is supported for most data sources.
objectids	Optional List. The object IDs of the layer or table to be queried.
start_time	Optional Datetime. The starting time to query for.
end_time	Optional Datetime. The end date to query for.
geometry_filter	Optional from arcgis.geometry.filter. Allows for the information to be filtered on spatial relationship with another geometry.
out_fields	Optional String. The list of fields to include in the return results.
return_geometry	Optional Boolean. If False, the query will not return geometries. The default is True.
return_centroid	Optional Boolean. If True, the centroid of the geometry will be added to the output.
max_allowable_offset	Optional float. This option can be used to specify the max_allowable_offset to be used for generalizing geometries returned by the query operation. The max_allowable_offset is in the units of out_sr. If out_sr is not specified, max_allowable_offset is assumed to be in the unit of the spatial reference of the layer.
out_sr	Optional Integer. The WKID for the spatial reference of the returned geometry.
geometry_precision	Optional Integer. 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).
return_ids_only	Optional boolean. Default is False. If true, the response only includes an array of object IDs. Otherwise, the response is a feature set.
return_extent_only	Optional boolean. 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.
order_by_field	Optional Str. Optional string. 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. example: STATE_NAME ASC, RACE DESC, GENDER
return_z	Optional boolean. 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.
return_m	Optional boolean. 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.
result_type	Optional String. The result_type can be used to control the number of features returned by the query operation. Values: none | standard | tile
as_df	Optional Boolean. If False, the result is returned as a FeatureSet. If True (default) the result is returned as a spatially enabled dataframe.

Returns:

Default is a pd.DataFrame, but when `as_df=False` returns a FeatureSet. If `return_count_only=True`, the return type is Integer. If `return_ids_only=True`, a list of value is returned.

property renderer

Get/Set the Renderer of the Feature Layer.

Parameter	Description
value	Required dict.

Note

When set, this overrides the default symbology when displaying it on a webmap.

Returns:

`InsensitiveDict`: A case-insensitive dict like object used to update and alter JSON A varients of a case-less dictionary that allows for dot and bracket notation.

property time_filter

The time_filter method is used to set a time filter instead of querying time-enabled map service layers or time-enabled feature service layers, a time filter can be specified. Time can be filtered as a single instant or by separating the two ends of a time extent with a comma.

Note

The time_filter method is supported starting at Enterprise 10.7.1+.

Input	Description
value	Required Datetime/List Datetime. This is a single or list of start/stop date.

Returns:

A string of datetime values as milliseconds from epoch

update_metadata(file_path)

The update_metadata updates a FeatureLayer metadata from an xml file.

Parameter	Description
file_path	Required String. The path to the .xml file that contains the metadata.

Returns:

A boolean indicating success (True), or failure (False)

validate_sql(sql, sql_type='where')

The validate_sql operation validates an SQL-92 expression or WHERE clause. The validate_sql operation ensures that an SQL-92 expression, such as one written by a user through a user interface, is correct before performing another operation that uses the expression.

Note

For example, validateSQL can be used to validate information that is subsequently passed in as part of the where parameter of the calculate operation.

validate_sql also prevents SQL injection. In addition, all table and field names used in the SQL expression or WHERE clause are validated to ensure they are valid tables and fields.

Parameter	Description
sql	Required String. The SQL expression of WHERE clause to validate. Example: “Population > 300000”
sql_type	Optional String. Three SQL types are supported in validate_sql where (default) - Represents the custom WHERE clause the user can compose when querying a layer or using calculate. expression - Represents an SQL-92 expression. Currently, expression is used as a default value expression when adding a new field or using the calculate API. statement - Represents the full SQL-92 statement that can be passed directly to the database. No current ArcGIS REST API resource or operation supports using the full SQL-92 SELECT statement directly. It has been added to the validateSQL for completeness. Values: where | expression | statement

Returns:

A JSON Dictionary indicating ‘success’ or ‘error’

append(item_id=None, upload_format='featureCollection', source_table_name=None, field_mappings=None, edits=None, source_info=None, upsert=False, skip_updates=False, use_globalids=False, update_geometry=True, append_fields=None, rollback=False, skip_inserts=None, upsert_matching_field=None, upload_id=None, layer_mappings=None, *, return_messages=None, future=False)

The append method is used to update an existing hosted FeatureLayer object. See the Append (Feature Service/Layer) page in the ArcGIS REST API documentation for more information.

Note

The append method is only available in ArcGIS Online and ArcGIS Enterprise 10.8.1+

Parameter	Description
item_id	Optional string. The ID for the Portal item that contains the source file. Used in conjunction with editsUploadFormat.
upload_format	Required string. The source append data format. The default is featureCollection. Values: ‘sqlite’ | ‘shapefile’ | ‘filegdb’ | ‘featureCollection’ | ‘geojson’ | ‘csv’ | ‘excel’ Note You can find the Feature Layer’s supported formats by checking the featureLayer.properties.supportedAppendFormats property.
source_table_name	Required string. Required even when the source data contains only one table, e.g., for file geodatabase. # Example usage: source_table_name= "Building"
field_mappings	Optional list. Used to map source data to a destination layer. Syntax: field_mappings=[{“name” : <”targetName”>, “sourceName” : < “sourceName”>}, …] # Example usage: field_mappings=[{"name" : "CountyID", "sourceName" : "GEOID10"}]
edits	Optional dictionary. Only feature collection json is supported. Append supports all format through the upload_id or item_id.
source_info	Optional dictionary. This is only needed when appending data from excel or csv. The appendSourceInfo can be the publishing parameter returned from analyze the csv or excel file.
upsert	Optional boolean. Optional parameter specifying whether the edits needs to be applied as updates if the feature already exists. Default is false.
skip_updates	Optional boolean. Parameter is used only when upsert is true.
use_globalids	Optional boolean. Specifying whether upsert needs to use GlobalId when matching features.
update_geometry	Optional boolean. The parameter is used only when upsert is true. Skip updating the geometry and update only the attributes for existing features if they match source features by objectId or globalId.(as specified by useGlobalIds parameter).
append_fields	Optional list. The list of destination fields to append to. This is supported when upsert=true or false. #Values: ["fieldName1", "fieldName2",....]
rollback	Optional boolean. Optional parameter specifying whether the upsert edits needs to be rolled back in case of failure. Default is false.
skip_inserts	Used only when upsert is true. Used to skip inserts if the value is true. The default value is false.
upsert_matching_field	Optional string. The layer field to be used when matching features with upsert. ObjectId, GlobalId, and any other field that has a unique index can be used with upsert. This parameter overrides use_globalids; e.g., specifying upsert_matching_field will be used even if you specify use_globalids = True. Example: upsert_matching_field=”MyfieldWithUniqueIndex”
upload_id	Optional string. The itemID field from an upload() response, corresponding with the appendUploadId REST API argument. This argument should not be used along side the item_id argument.
layer_mappings	Optional list of dictionaries. This is needed if the source is featureService. It is used to map a source layer to a destination layer. Only one source can be mapped to a layer. Syntax: layerMappings=[{“id”: <layerID>, “sourceId”: <layer id>}]
return_messages	Optional Boolean. When set to True, the messages returned from the append will be returned. If False, the response messages will not be returned. This alters the output to be a tuple consisting of a (Boolean, Dictionary).
future	Optional boolean. If True, a future object will be returned and the process will not wait for the task to complete. The default is False, which means wait for results.

Returns:

A boolean indicating success (True), or failure (False). When return_messages is True, the response messages will be return in addition to the boolean as a tuple. If future = True, then the result is a Future object. Call result() to get the response.

# Usage Example

>>> feature_layer.append(source_table_name= "Building",
                        field_mappings=[{"name" : "CountyID",
                                        "sourceName" : "GEOID10"}],
                        upsert = True,
                        append_fields = ["fieldName1", "fieldName2",...., fieldname22],
                        return_messages = False)
<True>

calculate(where, calc_expression, sql_format='standard', version=None, sessionid=None, return_edit_moment=None, future=False)

The calculate operation is performed on a FeatureLayer resource. calculate updates the values of one or more fields in an existing feature service layer based on SQL expressions or scalar values. The calculate operation can only be used if the supportsCalculate property of the layer is True. Neither the Shape field nor system fields can be updated using calculate. System fields include ObjectId and GlobalId.

Inputs	Description
where	Required String. A where clause can be used to limit the updated records. Any legal SQL where clause operating on the fields in the layer is allowed.
calc_expression	Required List. The array of field/value info objects that contain the field or fields to update and their scalar values or SQL expression. Allowed types are dictionary and list. List must be a list of dictionary objects. Calculation Format is as follows: {“field” : “<field name>”, “value” : “<value>”}
sql_format	Optional String. The SQL format for the calc_expression. It can be either standard SQL92 (standard) or native SQL (native). The default is standard. Values: standard, native
version	Optional String. The geodatabase version to apply the edits.
sessionid	Optional String. A parameter which is set by a client during long transaction editing on a branch version. The sessionid is a GUID value that clients establish at the beginning and use throughout the edit session. The sessonid ensures isolation during the edit session. This parameter applies only if the isDataBranchVersioned property of the layer is true.
return_edit_moment	Optional Boolean. This parameter specifies whether the response will report the time edits were applied. If true, the server will return the time edits were applied in the response’s edit moment key. This parameter applies only if the isDataBranchVersioned property of the layer is true.
future	Optional boolean. If True, a future object will be returned and the process will not wait for the task to complete. The default is False, which means wait for results. This applies to 10.8+ only

Returns:

A dictionary with the following format:

{ ‘updatedFeatureCount’: 1, ‘success’: True }

If future = True, then the result is a Future object. Call result() to get the response.

# Usage Example 1:

print(fl.calculate(where="OBJECTID < 2",
                   calc_expression={"field": "ZONE", "value" : "R1"}))

# Usage Example 2:

print(fl.calculate(where="OBJECTID < 2001",
                   calc_expression={"field": "A",  "sqlExpression" : "B*3"}))

property container

Get/Set the FeatureLayerCollection to which this layer belongs.

Parameter	Description
value	Required FeatureLayerCollection.

Returns:

The Feature Layer Collection where the layer is stored

property contingent_values

Returns the define contingent values for the given layer. :returns: Dict[str,Any]

delete_features(deletes=None, where=None, geometry_filter=None, gdb_version=None, rollback_on_failure=True, return_delete_results=True, future=False)

Deletes features in a FeatureLayer or Table

Parameter	Description
deletes	Optional string. A comma separated string of OIDs to remove from the service.
where	Optional string. A where clause for the query filter. Any legal SQL where clause operating on the fields in the layer is allowed. Features conforming to the specified where clause will be deleted.
geometry_filter	Optional SpatialFilter. A spatial filter from arcgis.geometry.filters module to filter results by a spatial relationship with another geometry.
gdb_version	Optional string. The geodatabase version. This parameter applies only if the isDataVersioned property of the layer is true.
rollback_on_failure	Optional boolean. Optional parameter to specify if the edits should be applied only if all submitted edits succeed. If false, the server will apply the edits that succeed even if some of the submitted edits fail. If true, the server will apply the edits only if all edits succeed. The default value is true.
return_delete_results	Optional Boolean. Optional parameter that indicates whether a result is returned per deleted row when the deleteFeatures operation is run. The default is true.
future	Optional boolean. If True, a future object will be returned and the process will not wait for the task to complete. The default is False, which means wait for results.

Returns:

A dictionary if future=False (default), else If future = True, then the result is a Future object. Call result() to get the response.

# Usage Example with only a "where" sql statement

>>> from arcgis.features import FeatureLayer

>>> gis = GIS("pro")
>>> buck = gis.content.search("owner:"+ gis.users.me.username)
>>> buck_1 =buck[1]
>>> lay = buck_1.layers[0]

>>> la_df = lay.delete_features(where = "OBJECTID > 15")
>>> la_df
{'deleteResults': [
{'objectId': 1, 'uniqueId': 5, 'globalId': None, 'success': True},
{'objectId': 2, 'uniqueId': 5, 'globalId': None, 'success': True},
{'objectId': 3, 'uniqueId': 5, 'globalId': None, 'success': True},
{'objectId': 4, 'uniqueId': 5, 'globalId': None, 'success': True},
{'objectId': 5, 'uniqueId': 5, 'globalId': None, 'success': True},
{'objectId': 6, 'uniqueId': 6, 'globalId': None, 'success': True},
{'objectId': 7, 'uniqueId': 7, 'globalId': None, 'success': True},
{'objectId': 8, 'uniqueId': 8, 'globalId': None, 'success': True},
{'objectId': 9, 'uniqueId': 9, 'globalId': None, 'success': True},
{'objectId': 10, 'uniqueId': 10, 'globalId': None, 'success': True},
{'objectId': 11, 'uniqueId': 11, 'globalId': None, 'success': True},
{'objectId': 12, 'uniqueId': 12, 'globalId': None, 'success': True},
{'objectId': 13, 'uniqueId': 13, 'globalId': None, 'success': True},
{'objectId': 14, 'uniqueId': 14, 'globalId': None, 'success': True},
{'objectId': 15, 'uniqueId': 15, 'globalId': None, 'success': True}]}

edit_features(adds=None, updates=None, deletes=None, gdb_version=None, use_global_ids=False, rollback_on_failure=True, return_edit_moment=False, attachments=None, true_curve_client=False, session_id=None, use_previous_moment=False, datum_transformation=None, future=False)

Adds, updates, and deletes features to the associated FeatureLayer or Table in a single call.

Note

When making large number (250+ records at once) of edits, append should be used over edit_features to improve performance and ensure service stability.

Inputs	Description
adds	Optional FeatureSet/List. The array of features to be added.
updates	Optional FeatureSet/List. The array of features to be updated.
deletes	Optional FeatureSet/List. string of OIDs to remove from service
use_global_ids	Optional boolean. Instead of referencing the default Object ID field, the service will look at a GUID field to track changes. This means the GUIDs will be passed instead of OIDs for delete, update or add features.
gdb_version	Optional string. The geodatabase version to apply edits. This parameter applies only if the isDataVersioned property of the layer is true.
rollback_on_failure	Optional boolean. Optional parameter to specify if the edits should be applied only if all submitted edits succeed. If false, the server will apply the edits that succeed even if some of the submitted edits fail. If true, the server will apply the edits only if all edits succeed. The default value is true.
return_edit_moment	Optional boolean. Introduced at 10.5, only applicable with ArcGIS Server services only. Specifies whether the response will report the time edits were applied. If set to true, the server will return the time in the response’s editMoment key. The default value is false.
attachments	Optional Dict. This parameter adds, updates, or deletes attachments. It applies only when the use_global_ids parameter is set to true. For adds, the globalIds of the attachments provided by the client are preserved. When useGlobalIds is true, updates and deletes are identified by each feature or attachment globalId, rather than their objectId or attachmentId. This parameter requires the layer’s supportsApplyEditsWithGlobalIds property to be true. Attachments to be added or updated can use either pre-uploaded data or base 64 encoded data. Inputs Inputs Description adds List of attachments to add. updates List of attachements to update deletes List of attachments to delete See the Apply Edits to a Feature Service layer in the ArcGIS REST API for more information.
true_curve_client	Optional boolean. Introduced at 10.5. Indicates to the server whether the client is true curve capable. When set to true, this indicates to the server that true curve geometries should be downloaded and that geometries containing true curves should be consumed by the map service without densifying it. When set to false, this indicates to the server that the client is not true curves capable. The default value is false.
session_id	Optional String. Introduced at 10.6. The session_id is a GUID value that clients establish at the beginning and use throughout the edit session. The sessonID ensures isolation during the edit session. The session_id parameter is set by a client during long transaction editing on a branch version.
use_previous_moment	Optional Boolean. Introduced at 10.6. The use_previous_moment parameter is used to apply the edits with the same edit moment as the previous set of edits. This allows an editor to apply single block of edits partially, complete another task and then complete the block of edits. This parameter is set by a client during long transaction editing on a branch version. When set to true, the edits are applied with the same edit moment as the previous set of edits. When set to false or not set (default) the edits are applied with a new edit moment.
datum_transformation	Optional Integer/Dictionary. This parameter applies a datum transformation while projecting geometries in the results when out_sr is different than the layer’s spatial reference. When specifying transformations, you need to think about which datum transformation best projects the layer (not the feature service) to the outSR and sourceSpatialReference property in the layer properties. For a list of valid datum transformation ID values ad well-known text strings, see Using spatial references. For more information on datum transformations please see the transformation parameter in the Project operation documentation. Examples Inputs Description WKID Integer. Ex: datum_transformation=4326 WKT Dict. Ex: datum_transformation={“wkt”: “<WKT>”} Composite Dict. Ex: datum_transformation=```{‘geoTransforms’:[{‘wkid’:<id>,’forward’:<true|false>},{‘wkt’:’<WKT>’,’forward’:<True|False>}]}```
future	Optional Boolean. If the FeatureLayer has supportsAsyncApplyEdits set to True, then edits can be applied asynchronously. If True, a future object will be returned and the process will not wait for the task to complete. The default is False, which means wait for results.

Returns:

A dictionary by default, or If future = True, then the result is a Future object. Call result() to get the response.

# Usage Example 1:

feature = [
{
    'attributes': {
        'ObjectId': 1,
        'UpdateDate': datetime.datetime.now(),
    }
}]
lyr.edit_features(updates=feature)

# Usage Example 2:

adds = {"geometry": {"x": 500, "y": 500, "spatialReference":
                    {"wkid": 102100, "latestWkid": 3857}},
        "attributes": {"ADMIN_NAME": "Fake Location"}
        }
lyr.edit_features(adds=[adds])

# Usage Example 3:

lyr.edit_features(deletes=[2542])

property estimates

Returns up-to-date approximations of layer information, such as row count and extent. Layers that support this property will include infoInEstimates information in the layer’s properties.

Currently available with ArcGIS Online and Enterprise 10.9.1+

Returns:

Dict[str, Any]

export_attachments(output_folder, label_field=None)

Exports attachments from the FeatureLayer in Imagenet format using the output_label_field.

Parameter	Description
output_folder	Required string. Output folder where the attachments will be stored. If None, a default folder is created
label_field	Optional string. Field which contains the label/category of each feature.

Returns:

Nothing is returned from this method

property field_groups

Returns the defined list of field groups for a given layer.

Returns:

dict[str,Any]

classmethod fromitem(item, index=0)

The fromitem method returns the layer at the specified index from a layer Item object.

Parameter	Description
item	Required Item. An item containing layers.
index	Optional int. The index of the layer amongst the item’s layers

Returns:

The layer at the specified index.

# Usage Example

>>> layer.fromitem(item="9311d21a9a2047d19c0faaebd6f2cca6", index=3)

generate_renderer(definition, where=None)

Groups data using the supplied definition (classification definition) and an optional where clause. The result is a renderer object.

Note

Use baseSymbol and colorRamp to define the symbols assigned to each class. If the operation is performed on a table, the result is a renderer object containing the data classes and no symbols.

Parameter	Description
definition	Required dict. The definition using the renderer that is generated. Use either class breaks or unique value classification definitions. See Classification Objects for additional details.
where	Optional string. A where clause for which the data needs to be classified. Any legal SQL where clause operating on the fields in the dynamic layer/table is allowed.

Returns:

A JSON Dictionary

# Example Usage
FeatureLayer.generate_renderer(
    definition = {"type":"uniqueValueDef",
                  "uniqueValueFields":["Has_Pool"],
                  "fieldDelimiter": ",",
                  "baseSymbol":{
                      "type": "esriSFS",
                      "style": "esriSLSSolid",
                      "width":2
                      },
                    "colorRamp":{
                        "type":"algorithmic",
                        "fromColor":[115,76,0,255],
                        "toColor":[255,25,86,255],
                        "algorithm": "esriHSVAlgorithm"
                        }
                },
    where = "POP2000 > 350000"
    )

get_html_popup(oid)

The get_html_popup method provides details about the HTML pop-up authored by the User using ArcGIS Pro or ArcGIS Desktop.

Parameter	Description
oid	Optional string. Object id of the feature to get the HTML popup.

Returns:

A string

get_unique_values(attribute, query_string='1=1')

Retrieves a list of unique values for a given attribute in the FeatureLayer.

Parameter	Description
attribute	Required string. The feature layer attribute to query.
query_string	Optional string. SQL Query that will be used to filter attributes before unique values are returned. ex. “name_2 like ‘%K%’”

Returns:

A list of unique values

# Usage Example with only a "where" sql statement

>>> from arcgis.features import FeatureLayer

>>> gis = GIS("pro")
>>> buck = gis.content.search("owner:"+ gis.users.me.username)
>>> buck_1 =buck[1]
>>> lay = buck_1.layers[0]
>>> layer = lay.get_unique_values(attribute = "COUNTY")
>>> layer
['PITKIN', 'PLATTE', 'TWIN FALLS']

property manager

The manager property is a helper object to manage the FeatureLayer, such as updating its definition.

Returns:

A FeatureLayerManager

# Usage Example

>>> manager = FeatureLayer.manager

property metadata

Get the Feature Layer’s metadata.

Note

If metadata is disabled on the GIS or the layer does not support metadata, None will be returned.

Returns:

String of the metadata, if any

property properties

The properties property retrieves and set properties of this object.

query(where='1=1', out_fields='*', time_filter=None, geometry_filter=None, return_geometry=True, return_count_only=False, return_ids_only=False, return_distinct_values=False, return_extent_only=False, group_by_fields_for_statistics=None, statistic_filter=None, result_offset=None, result_record_count=None, object_ids=None, distance=None, units=None, max_allowable_offset=None, out_sr=None, geometry_precision=None, gdb_version=None, order_by_fields=None, out_statistics=None, return_z=False, return_m=False, multipatch_option=None, quantization_parameters=None, return_centroid=False, return_all_records=True, result_type=None, historic_moment=None, sql_format=None, return_true_curves=False, return_exceeded_limit_features=None, as_df=False, datum_transformation=None, time_reference_unknown_client=None, **kwargs)

The query method queries a FeatureLayer based on a sql statement.

Parameter	Description
where	Optional string. SQL-92 WHERE clause syntax on the fields in the layer is supported for most data sources. Some data sources have restrictions on what is supported. Hosted feature services in ArcGIS Enterprise running on a spatiotemporal data source only support a subset of SQL-92. Below is a list of supported SQL-92 with spatiotemporal-based feature services: ( ‘<=’ | ‘>=’ | ‘<’ | ‘>’ | ‘=’ | ‘!=’ | ‘<>’ | LIKE ) (AND | OR) (IS | IS_NOT) (IN | NOT_IN) ( ‘(’ ( expr ( ‘,’ expr )* )? ‘)’ ) COLUMN_NAME BETWEEN LITERAL_VALUE AND LITERAL_VALUE
out_fields	Optional 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. Note If specifying return_count_only, return_id_only, or return_extent_only as True, do not specify this parameter in order to avoid errors.
object_ids	Optional string. The object IDs of this layer or table to be queried. The object ID values should be a comma-separated string. Note There might be a drop in performance if the layer/table data source resides in an enterprise geodatabase and more than 1,000 object_ids are specified.
distance	Optional integer. 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.
units	Optional string. 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`
time_filter	Optional list. The format is of [<startTime>, <endTime>] using datetime.date, datetime.datetime or timestamp in milliseconds. Syntax: time_filter=[<startTime>, <endTime>] ; specified as datetime.date, datetime.datetime or timestamp in milliseconds
geometry_filter	Optional from filters. Allows for the information to be filtered on spatial relationship with another geometry.
max_allowable_offset	Optional float. This option can be used to specify the max_allowable_offset to be used for generalizing geometries returned by the query operation. The max_allowable_offset is in the units of out_sr. If out_sr is not specified, max_allowable_offset is assumed to be in the unit of the spatial reference of the layer.
out_sr	Optional Integer. The WKID for the spatial reference of the returned geometry.
geometry_precision	Optional Integer. 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).
gdb_version	Optional string. The geodatabase version to query. This parameter applies only if the isDataVersioned property of the layer is true. If this is not specified, the query will apply to the published map’s version.
return_geometry	Optional boolean. If true, geometry is returned with the query. Default is true.
return_distinct_values	Optional boolean. If true, it returns distinct values based on the fields specified in out_fields. This parameter applies only if the supportsAdvancedQueries property of the layer is true. This parameter can be used with return_count_only to return the count of distinct values of subfields. Note Make sure to set return_geometry to False if this is set to True. Otherwise, reliable results will not be returned.
return_ids_only	Optional boolean. Default is False. If true, the response only includes an array of object IDs. Otherwise, the response is a feature set. When object_ids are specified, setting this parameter to true is invalid.
return_count_only	Optional boolean. 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.
return_extent_only	Optional boolean. 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.
order_by_fields	Optional string. 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. example: STATE_NAME ASC, RACE DESC, GENDER Note If specifying return_count_only, return_id_only, or return_extent_only as True, do not specify this parameter in order to avoid errors.
group_by_fields_for_statistics	Optional string. One or more field names on which the values need to be grouped for calculating the statistics. example: STATE_NAME, GENDER
out_statistics	Optional list of dictionaries. The definitions for one or more field-based statistics to be calculated. Syntax: [ { “statisticType”: “<count | sum | min | max | avg | stddev | var>”, “onStatisticField”: “Field1”, “outStatisticFieldName”: “Out_Field_Name1” }, { “statisticType”: “<count | sum | min | max | avg | stddev | var>”, “onStatisticField”: “Field2”, “outStatisticFieldName”: “Out_Field_Name2” } ]
statistic_filter	Optional StatisticFilter instance. The definitions for one or more field-based statistics can be added, e.g. statisticType, onStatisticField, or outStatisticFieldName. Syntax: sf = StatisticFilter() sf.add(statisticType=”count”, onStatisticField=”1”, outStatisticFieldName=”total”) sf.filter
return_z	Optional boolean. 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.
return_m	Optional boolean. 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.
multipatch_option	Optional x/y footprint. This option dictates how the geometry of a multipatch feature will be returned.
result_offset	Optional integer. 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). This option is ignored if return_all_records is True (i.e. by default).
result_record_count	Optional integer. This option can be used for fetching query results up to the result_record_count specified. When result_offset is specified but this parameter is not, the map service defaults it to max_record_count. The maximum value for this parameter is the value of the layer’s max_record_count property. This option is ignored if return_all_records is True (i.e. by default).
quantization_parameters	Optional dict. Used to project the geometry onto a virtual grid, likely representing pixels on the screen.
return_centroid	Optional boolean. Used to return the geometry centroid associated with each feature returned. If true, the result includes the geometry centroid. The default is false. Only supported on layer with polygon geometry type.
return_all_records	Optional boolean. When True, the query operation will call the service until all records that satisfy the where_clause are returned. Note: result_offset and result_record_count will be ignored if return_all_records is True. Also, if return_count_only, return_ids_only, or return_extent_only are True, this parameter will be ignored.
result_type	Optional string. The result_type parameter can be used to control the number of features returned by the query operation. Values: None | standard | tile
historic_moment	Optional integer. The historic moment to query. This parameter applies only if the layer is archiving enabled and the supportsQueryWithHistoricMoment property is set to true. This property is provided in the layer resource. If historic_moment is not specified, the query will apply to the current features.
sql_format	Optional string. The sql_format parameter can be either standard SQL92 standard or it can use the native SQL of the underlying datastore native. The default is none which means the sql_format depends on useStandardizedQuery parameter. Values: none | standard | native
return_true_curves	Optional boolean. When set to true, returns true curves in output geometries. When set to false, curves are converted to densified polylines or polygons.
return_exceeded_limit_features	Optional boolean. Optional parameter which is true by default. When set to true, features are returned even when the results include ‘exceededTransferLimit’: True. When set to false and querying with resultType = tile features are not returned when the results include ‘exceededTransferLimit’: True. This allows a client to find the resolution in which the transfer limit is no longer exceeded without making multiple calls.
as_df	Optional boolean. If True, the results are returned as a DataFrame instead of a FeatureSet.
datum_transformation	Optional Integer/Dictionary. This parameter applies a datum transformation while projecting geometries in the results when out_sr is different than the layer’s spatial reference. When specifying transformations, you need to think about which datum transformation best projects the layer (not the feature service) to the outSR and sourceSpatialReference property in the layer properties. For a list of valid datum transformation ID values ad well-known text strings, see Coordinate systems and transformations. For more information on datum transformations, please see the transformation parameter in the Project operation. Examples Inputs Description WKID Integer. Ex: datum_transformation=4326 WKT Dict. Ex: datum_transformation={“wkt”: “<WKT>”} Composite Dict. Ex: datum_transformation=```{‘geoTransforms’:[{‘wkid’:<id>,’forward’:<true|false>},{‘wkt’:’<WKT>’,’forward’:<True|False>}]}```
kwargs	Optional dict. Optional parameters that can be passed to the Query function. This will allow users to pass additional parameters not explicitly implemented on the function. A complete list of functions available is documented on the Query REST API.

Returns:

A FeatureSet containing the features matching the query unless another return type is specified, such as return_count_only, return_extent_only, or return_ids_only.

# Usage Example with only a "where" sql statement

>>> feat_set = feature_layer.query(where = "OBJECTID= 1")
>>> type(feat_set)
<arcgis.Features.FeatureSet>
>>> feat_set[0]
<Feature 1>

# Usage Example of an advanced query returning the object IDs instead of Features

>>> id_set = feature_layer.query(where = "OBJECTID1",
                                   out_fields = ["FieldName1, FieldName2"],
                                   distance = 100,
                                   units = 'esriSRUnit_Meter',
                                   return_ids_only = True)

>>> type(id_set)
<Array>
>>> id_set[0]
<"Item_id1">

# Usage Example of an advanced query returning the number of features in the query

>>> search_count = feature_layer.query(where = "OBJECTID1",
                                   out_fields = ["FieldName1, FieldName2"],
                                   distance = 100,
                                   units = 'esriSRUnit_Meter',
                                   return_count_only = True)

>>> type(search_count)
<Integer>
>>> search_count
<149>

# Usage Example with "out_statistics" parameter

>>> stats = [{
        'onStatisticField': "1",
        'outStatisticFieldName': "total",
        'statisticType': "count"
    }]
>>> feature_layer.query(out_statistics=stats, as_df=True) # returns a DataFrame containting total count

# Usage Example with "StatisticFilter" parameter

>>> from arcgis._impl.common._filters import StatisticFilter
>>> sf1 = StatisticFilter()
>>> sf1.add(statisticType="count", onStatisticField="1", outStatisticFieldName="total")
>>> sf1.filter # This is to print the filter content
>>> feature_layer.query(statistic_filter=sf1, as_df=True) # returns a DataFrame containing total count