arcgis.geoanalytics.manage_data module

These tools are used for the day-to-day management of geographic and tabular data.

copy_to_data_store copies data to your ArcGIS Data Store and creates a layer in your web GIS.

append_data

manage_data.append_data(append_layer, field_mapping=None, gis=None)

Only available at ArcGIS Enterprise 10.6.1 and later.

The Append Data task appends tabular, point, line, or polygon data to an existing layer. The input layer must be a hosted feature layer. The tool will add the appended data as rows to the input layer. No new output layer is created.

Argument

Description

input_layer

required FeatureLayer , The table, point, line or polygon features.

append_layer

required FeatureLayer. The table, point, line, or polygon features to be appended to the input_layer. To append geometry, the append_layer must have the same geometry type as the input_layer. If the geometry types are not the same, the append_layer geometry will be removed and all other matching fields will be appended. The geometry of the input_layer will always be maintained.

field_mapping

Defines how the fields in append_layer are appended to the input_layer.

The following are set by default:

  • All append_layer fields that match input_layer schema will be appended.

  • Fields that exist in the input_layer and not in the append_layer will be appended with null values.

  • Fields that exist in the append_layer and not in the input_layer will not be appended.

Optionally choose how input_layer fields will be appended from the following:

  • AppendField - Matches the input_layer field with an append_layer field of a different name. Field types must match.

  • Expression - Calculates values for the resulting field. Values are calculated using Arcade expressions. To assign null values, use ‘null’.

gis

optional GIS, the GIS on which this tool runs. If not specified, the active GIS is used.
Returns

boolean

calculate_fields

manage_data.calculate_fields(field_name, data_type, expression, track_aware=False, track_fields=None, output_name=None, gis=None)

The Calculate Field task works with a layer to create and populate a new field. The output is a new feature layer, that is the same as the input features, with the additional field added.

Argument

Description

input_layer

required service , The table, point, line or polygon features containing potential incidents.

field_name

required string, A string representing the name of the new field. If the name already exists in the dataset, then a numeric value will be appended to the field name.

data_type

required string, the type for the new field. Values: Date |Double | Integer | String

expression

required string, An Arcade expression used to calculate the new field values. You can use any of the Date, Logical, Mathematical or Text function available with Arcade.

track_aware

optional boolean, Boolean value denoting if the expression is track aware. Default: False

track_fields

optional string, The fields used to identify distinct tracks. There can be multiple track_fields. track_fields are only required when track_aware is true.

output_name

optional string, The task will create a feature service of the results. You define the name of the service.

gis

optional GIS, the GIS on which this tool runs. If not specified, the active GIS is used.
Returns

Feature Layer

clip_layer

..automethod:: arcgis.geoanalytics.manage_data.clip_layer

copy_to_data_store

manage_data.copy_to_data_store(output_name: str = None, gis=None)

Copies an input feature layer or table to an ArcGIS Data Store and creates a layer in your web GIS.

For example

  • Copy a collection of .csv files in a big data file share to the spatiotemporal data store for visualization.

  • Copy the features in the current map extent that are stored in the spatiotemporal data store to the relational data store.

This tool will take an input layer and copy it to a data store. Data will be copied to the ArcGIS Data Store and will be stored in your relational or spatiotemporal data store.

For example, you could copy features that are stored in a big data file share to a relational data store and specify that only features within the current map extent will be copied. This would create a hosted feature service with only those features that were within the specified map extent.

Parameters:

input_layer: Input Layer (feature layer). Required parameter.

output_name: Output Layer Name (str). Required parameter.

gis: Optional, the GIS on which this tool runs. If not specified, the active GIS is used.

Returns:

output - Output Layer as a feature layer collection item

dissolve_boundaries

manage_data.dissolve_boundaries(dissolve_fields=None, summary_fields=None, multipart=False, output_name=None, gis=None)

The Dissolve Boundaries task finds polygons that intersect or have the same field values and merges them together to form a single polygon.

Examples:

A city council wants to control liquor sales by refusing new licenses to stores within 1,000 feet of schools, libraries, and parks. After creating a 1,000-foot buffer around the schools, libraries, and parks, the buffered layers can be joined together and the boundaries can be dissolved to create a single layer of restricted areas.

Usage Notes:

Only available at ArcGIS Enterprise 10.7 and later.

Argument

Description

input_layer

required FeatureLayer. The point, line or polygon features.

dissolve_fields

Optional string. A comma seperated list of strings for each field that you want to dissolve on.

summary_fields

Optional list. Calculate one or more statistics for the dissolved areas by using the summary_fields parameter. The input is a list of key/value pairs in the following format:

[{“statisticType” : “<stat>”, “onStatisticField” : “<field name>”}]

Allows statistics are:

  • Any (string fields only)

  • Count

  • Sum

  • Minimum

  • Maximum

  • Average

  • Variance

  • Standard Deviation

Example:

summary_fields = [{“statisticType”“Sum”, “onStatisticField”“quadrat_area_km2”},

{“statisticType” : “Mean”, “onStatisticField” : “soil_depth_cm”}, {“statisticType” : “Any”, “onStatisticField” : “quadrat_desc”}]

multipart

Optional boolean. If True, the output service can contain multipart features. If False (default):, the output service will only contain single-part features, and individual features will be created for each part.

output_name

optional string. The task will create a feature service of the results. You define the name of the service.

gis

optional GIS. The GIS object where the analysis will take place.
Returns

FeatureLayer

merge_layers

manage_data.merge_layers(merge_layer, merge_attributes=None, output_name=None, gis=None)

The Merge Layers task combines two feature layers to create a single output layer. The tool requires that both layers have the same geometry type (tabular, point, line, or polygon). If time is enabled on one layer, the other must also be time enabled and have the same time type (instant or interval). The result will always contain all fields from the input layer. All fields from the merge layer will be included by default, or you can specify custom merge rules to define the resulting schema. For example:

  • I have three layers for England, Wales, and Scotland and I want a single layer of Great Britain. I can use Merge Layers to combine the areas and maintain all fields from each area.

  • I have two layers containing parcel information for contiguous townships. I want to join them together into a single layer, keeping only the fields that have the same name and type in the two layers.

Only available at ArcGIS Enterprise 10.7 and later.

Argument

Description

input_layer

Required FeatureLayer. The point, line or polygon features.

merge_layer

Required FeatureLayer. The point, line, or polygon features to merge with the input_layer. The merge_layer must contain the same geometry type (tabular, point, line, or polygon) and the same time type (none, instant, or interval) as the input_layer. All fields in the merge_layer will be included in the result layer by default or you can define merge_attributes to customize the resulting schema.

merge_attributes

Optional list. Defines how the fields in mergeLayer will be modified. By default, all fields from both inputs will be included in the output layer.

If a field exists in one layer but not the other, the output layer will still contain the field. The output field will contain null values for the input features that did not have the field. For example, if the input_layer contains a field named TYPE but the merge_layer does not contain TYPE, the output will contain TYPE, but its values will be null for all the features copied from the merge_layer.

You can control how fields in the merge_layer are written to the output layer using the following merge types that operate on a specified merge_layer field:

  • Remove - The field in the merge_layer will be removed from the output layer.

  • Rename - The field in the merge_layer will be renamed in the output layer. You cannot rename a field in the merge_layer to a field in the inputLayer. If you want to make field names equivalent, use Match.

  • Match - A field in the merge_layer is made equivalent to a field in the input_layer specified by mergeValue. For example, the input_layer has a field named CODE and the merge_layer has a field named STATUS. You can match STATUS to CODE, and the output will contain the CODE field with values of the STATUS field used for features copied from the merge_layer. Type casting is supported (for example, double to integer, integer to string) except for string to numeric.

REST web example:

Syntax: This example matches Average_Sales to Mean_Sales,

removesBonus, and renamesField4 to Errors.

```

[{

“mergeLayerField”: “Mean_Sales”, “mergeType”: “Match”, “mergeValue”: “Average_Sales”

}, {

“mergeLayerField”: “Bonus”, “mergeType”: “Remove”,

}, {

“mergeLayerField”: “Field4”, “mergeType”: “Rename”, “mergeValue”: “Errors”

}]

```

output_name

Optional string. The task will create a feature service of the results. You define the name of the service.

gis

Optional GIS. The GIS object where the analysis will take place.
Returns

FeatureLayer

overlay_data

manage_data.overlay_data(overlay_layer, overlay_type='intersect', output_name=None, gis=None)

Only available at ArcGIS Enterprise 10.6.1 and later.

Argument

Description

input_layer

required FeatureLayer. The point, line or polygon features.

overlay_layer

required FeatureLayer. The features that will be overlaid with the input_layer features.

overlay_type

optional string. The type of overlay to be performed. Values: intersect, erase

  • intersect - Computes a geometric intersection of the input layers. Features or portions of features that overlap in both the inputLayer and overlayLayer layers will be written to the output layer. This is the default.

  • erase - Only those features or portions of features in the overlay_layer that are not within the features in the input_layer layer are written to the output.

output_name

optional string. The task will create a feature service of the results. You define the name of the service.

gis

optional GIS. The GIS object where the analysis will take place.
Returns

FeatureLayer