Aggregate Points (GeoAnalytics Desktop)

Summary

Aggregates points into polygon features or bins. A polygon is returned with a count of points as well as optional statistics at all locations where points exist.

Learn more about how time stepping works

Illustration

Aggregate Points tool illustration
Examples of aggregating points into polygons (first row), time-enabled points into polygons with time stepping (second row), points into bins (third row), and points into bins with time stepping (fourth row) are shown.

Usage

  • You can specify the areas where the points will be aggregated in either of the following ways:

    • Use a polygon layer.
    • Use a square, hexagonal, or H3 bin of a specified size that is generated when the analysis is run.

    You can provide the area layer to use for analysis, or you can generate bins of a specified size and shape (hexagon, square, or H3) into which the points will be aggregated. The bin size specifies how large square and hexagon bins will be.

    • If you are aggregating into hexagons, the size is the height of each hexagon, and the width of the resulting hexagon will be 2 times the height divided by the square root of 3.
    • If you are aggregating into squares, the bin size is the height of the square, which is equal to the width.
    • If you are aggregating into H3 bins, bin size is determined by the specified H3 bin resolution. The H3 bin resolution can be a value between 0 and 15 in which 0 produces the largest bins and 15 produces the smallest bins.

    Hexagonal and square bins

  • Analysis with binning requires that the input is projected or that the output coordinate system is set to a projected coordinate system. If the data is not in a projected coordinate system and you do not set one, a projection will be used based on the extent of the data you are analyzing.

  • The output feature layer is always a polygon layer. Only polygons that contain points will be returned, and resulting polygons will be completely removed from the result layer.

    Polygons returned with point features
    The input point and polygon features are shown in the first image and the resulting area features from the Aggregate Points tool are shown in the second image.

  • If time is enabled on the input, you can apply time stepping to the analysis. Each time step is analyzed independent of features outside the time step. To use time stepping, the input data must be time enabled and represent an instant in time. When time stepping is applied, output features will be time intervals represented by the START_DATETIME and END_DATETIME fields.

    Learn more about time stepping

  • The most basic aggregations will calculate a count of the number of points in each polygon. Statistics (count, sum, minimum, maximum, range, mean, standard deviation, and variance) can also be calculated on numerical fields, and statistics (count, any) can be calculated on string fields. The statistics will be calculated on each area separately. If you specify a statistic that is not valid (the mean of a string field, for example), it will be skipped.

    Note:

    When count is applied to a field, it returns a count of the nonnull values present in the field. When any is applied to a string field, it returns a single string present in the field.

  • If time is enabled on the input, you can apply time stepping to the analysis. Each time step is analyzed independent of features outside the time step. To use time stepping, the input data must be time enabled and represent an instant in time. When time stepping is applied, output features will be time intervals represented by the START_DATETIME and END_DATETIME fields.

    Learn more about time stepping

  • If you specify a time-step interval, time-step repeat, or reference time, and time is not enabled on the data, an error will occur.

  • The Time Step Reference parameter can be a date and time value or solely a date value; it cannot be solely a time value.

  • The following fields are included in the output features:

    Field nameDescription

    count

    The count of features within each polygon.

    statistic_fieldname

    Specified statistics will each create an attribute field, named in the following format: statistic_fieldname. For example, the maximum and standard deviation of the id field are MAX_id and SD_id, respectively.

    start_date

    When time stepping is specified, output polygons will have a time interval. This field represents the start time.

    end_date

    When time stepping is specified, output polygons will have a time interval. This field represents the end time.

    bin_id

    The numeric H3 bin ID. This field is only included when aggregating into H3 bins.

  • You can improve the performance of the Aggregate Points tool by using one or more of the following tips:

    • Set the extent environment so you only analyze data of interest.
    • Larger bins will perform better than smaller bins. If you are unsure about which size to use, start with a larger bin to prototype.
    • Similar to bins, larger time steps will perform better than smaller time steps.
    • Use data that is local to where the analysis is being run.

  • This geoprocessing tool is powered by Spark. Analysis is completed on your desktop machine using multiple cores in parallel. See Considerations for GeoAnalytics Desktop tools to learn more about running analysis.

  • When running GeoAnalytics Desktop tools, the analysis is completed on your desktop machine. For optimal performance, data should be available on your desktop. If you are using a hosted feature layer, it is recommended that you use ArcGIS GeoAnalytics Server. If your data isn't local, it will take longer to run a tool. To use your ArcGIS GeoAnalytics Server to perform analysis, see GeoAnalytics Tools.

  • Similar analysis can also be completed using the Aggregate Points tool in the Standard Feature Analysis toolbox.

Parameters

LabelExplanationData Type
Point Layer

The point features that will be aggregated into polygons or bins.

Feature Layer
Output Feature Class

A new feature class with the aggregated polygon results.

Feature Class
Polygon or Bin

Specifies how the Point Layer parameter value will be aggregated.

  • PolygonThe point layer will be aggregated into a polygon dataset.
  • BinThe point layer will be aggregated into square or hexagonal bins that are generated when the tool is run.
String
Polygon Layer
(Optional)

The polygon features into which the input points will be aggregated.

Feature Layer
Bin Type
(Optional)

Specifies the bin shape that will be generated to hold the aggregated points.

  • SquareSquare bins will be generated in which the Bin Size value represents the height of a square. This is the default.
  • HexagonHexagonal bins will be generated in which the Bin Size value represents the height between two parallel sides.
  • H3H3 bins will be generated. The bin size will be determined by the Bin Resolution parameter value.
String
Bin Size
(Optional)

The distance interval that represents the bin size and units into which the Point Layer value will be aggregated. The distance interval must be a linear unit.

Linear Unit
Time Step Interval
(Optional)

A value that specifies the duration of the time step. This parameter is only available if the input points are time enabled and represent an instant in time.

Time stepping can only be applied if time is enabled on the input.

Time Unit
Time Step Repeat
(Optional)

A value that specifies how often the time-step interval occurs. This parameter is only available if the input points are time enabled and represent an instant in time.

Time Unit
Time Step Reference
(Optional)

A date that specifies the reference time with which to align the time steps. The default is January 1, 1970, at 12:00 a.m. This parameter is only available if the input points are time enabled and represent an instant in time.

Date
Summary Fields
(Optional)

The statistics that will be calculated on specified fields.

Value Table
Bin Resolution
(Optional)

The resolution of the H3 bins. This is a value between 0 and 15 in which 0 will produce the largest H3 bins and 15 will produce the smallest H3 bins.

Long

arcpy.gapro.AggregatePoints(point_layer, out_feature_class, polygon_or_bin, {polygon_layer}, {bin_type}, {bin_size}, {time_step_interval}, {time_step_repeat}, {time_step_reference}, {summary_fields}, {bin_resolution})
NameExplanationData Type
point_layer

The point features that will be aggregated into polygons or bins.

Feature Layer
out_feature_class

A new feature class with the aggregated polygon results.

Feature Class
polygon_or_bin

Specifies how the point_layer parameter value will be aggregated.

  • POLYGONThe point layer will be aggregated into a polygon dataset.
  • BINThe point layer will be aggregated into square or hexagonal bins that are generated when the tool is run.
String
polygon_layer
(Optional)

The polygon features into which the input points will be aggregated.

Feature Layer
bin_type
(Optional)

Specifies the bin shape that will be generated to hold the aggregated points.

  • SQUARESquare bins will be generated in which the bin_size value represents the height of a square. This is the default.
  • HEXAGONHexagonal bins will be generated in which the bin_size value represents the height between two parallel sides.
  • H3H3 bins will be generated. The bin size will be determined by the bin_resolution parameter value.
String
bin_size
(Optional)

The distance interval that represents the bin size and units into which the point_layer value will be aggregated. The distance interval must be a linear unit.

Linear Unit
time_step_interval
(Optional)

A value that specifies the duration of the time step. This parameter is only available if the input points are time enabled and represent an instant in time.

Time stepping can only be applied if time is enabled on the input.

Time Unit
time_step_repeat
(Optional)

A value that specifies how often the time-step interval occurs. This parameter is only available if the input points are time enabled and represent an instant in time.

Time Unit
time_step_reference
(Optional)

A date that specifies the reference time with which to align the time steps. The default is January 1, 1970, at 12:00 a.m. This parameter is only available if the input points are time enabled and represent an instant in time.

Date
summary_fields
[summary_fields,...]
(Optional)

The statistics that will be calculated on specified fields.

  • COUNT—The number of nonnull values. It can be used on numeric fields or strings. The count of [null, 0, 2] is 2.
  • SUM—The sum of numeric values in a field. The sum of [null, null, 3] is 3.
  • MEAN—The mean of numeric values. The mean of [0,2, null] is 1.
  • MIN—The minimum value of a numeric field. The minimum of [0, 2, null] is 0.
  • MAX—The maximum value of a numeric field. The maximum value of [0, 2, null] is 2.
  • STDDEV—The standard deviation of a numeric field. The standard deviation of [1] is null. The standard deviation of [null, 1,1,1] is null.
  • VAR—The variance of a numeric field in a track. The variance of [1] is null. The variance of [null, 1,1,1] is null.
  • RANGE—The range of a numeric field. This is calculated as the minimum value subtracted from the maximum value. The range of [0, null, 1] is 1. The range of [null, 4] is 0.
  • ANY—A sample string from a field of type string.

Value Table
bin_resolution
(Optional)

The resolution of the H3 bins. This is a value between 0 and 15 in which 0 will produce the largest H3 bins and 15 will produce the smallest H3 bins.

Long

Code sample

AggregatePoints (Python window)

The following Python window script demonstrates how to use the AggregatePoints function.

# Name: AggregatePoints.py
# Description: Aggregate 311 events into 1 KM Bins.

# Import system modules
import arcpy

arcpy.env.workspace = "C:/data/CityData.gdb"

# Set local variables
inFeatures = "SF311"
summaryFields = ["Year", "Beat"]
summaryStatistics = [["Arrest", "COUNT"], ["District", "COUNT"]]
out = "AggregateWildfires"

# Run Aggregate Points
arcpy.gapro.AggregatePoints(inFeatures, out, "BIN", None, "HEXAGON", 
                            "1 Kilometers")

Licensing information

  • Basic: No
  • Standard: No
  • Advanced: Yes

Related topics