Manage Feature Bin Cache (Data Management)

Summary

Manages the feature binning cache for data that has database computed feature binning enabled.

Feature binning aggregates large amounts of point features into dynamic polygon bins that vary through scaled levels of detail. Learn how to enable database computed feature binning and work with binned feature layers.

Usage

  • Use this tool when database computed feature binning has been enabled on a feature class and a static cache has been generated. If the underlying data has changed, run this tool to update the cache to reflect the most recent state of the data. If you run this tool on a feature class without a static cache, a static cache is generated. Use this tool to add or delete summary statistics that are stored in the cache or to modify the cache level of detail.

  • You can manage feature bins for binned point and multipoint feature classes stored in an enterprise geodatabase or database.

    Supported platforms are as follows:

    • IBM Db2
    • Microsoft SQL Server
    • Oracle
    • PostgreSQL

  • Use the Level of Detail parameter to specify the maximum level of detail for the tiling scheme to include in the cache. Tiling schemes are a continuum of scale ranges. Depending on the map, you may want to forego caching of some of the extremely large or small scales in the tiling scheme. Choose a level of detail that most closely matches the intended use of the map in which the data will be shown.

Parameters

LabelExplanationData Type
Input Features

The binned feature class that will have its static cache updated.

Feature Layer
Bin Type
(Optional)

Specifies the type of feature binning visualization that will be enabled.

  • Flat hexagonThe flat hexagon binning scheme, also known as flat geohex or flat hexbinning, will be enabled. The tiles are a tessellation of hexagons in which the orientation of the hexagons has a flat edge of the hexagon on top. This is the default for Microsoft SQL Server, Oracle, and PostgreSQL data.
    Flat hexagon bin type
  • Pointy hexagonThe pointy hexagon binning scheme, also known as pointy geohex or pointy hexbinning, will be enabled. The tiles are a tessellation of hexagons in which the orientation of the hexagons has a point of the hexagon on top.
    Pointy hexagon bin type
  • SquareThe square binning scheme in which the tiles are a tessellation of squares, also known as geosquare or squarebinning, will be enabled. This is the default for Db2 data.
    Square hexagon bin type
  • GeohashThe geohash binning scheme in which the tiles are a tessellation of rectangles will be enabled. Because geohash bins always use the WGS84 geographic coordinate system (GCS WGS84, EPSG WKID 4326), you cannot specify a bin coordinate system for geohash bins.
    Geohash bin type
String
Level of Detail
(Optional)

Specifies the maximum level of detail that will be used for the cache.

Tiling schemes are a continuum of scale ranges. Depending on the map, you may want to forego caching of some of the extremely large or small scales in the tiling scheme. This tool examines the scale dependencies in the map and attempts to provide a maximum range of scale for caching. Choose a level of detail that most closely matches the intended use of the map in which the data will be shown.

  • WorldA world scale will be used as the maximum level of detail.
  • ContinentsMultiple continents scale will be used as the maximum level of detail.
  • ContinentA single continent scale will be used as the maximum level of detail.
  • CountriesMultiple countries scale will be used as the maximum level of detail.
  • CountryA single country scale will be used as the maximum level of detail.
  • StatesMultiple states scale will be used as the maximum level of detail.
  • StateA single state scale will be used as the maximum level of detail.
  • CountiesMultiple counties scale will be used as the maximum level of detail.
  • CountyA single county scale will be used as the maximum level of detail.
  • CitiesMultiple cities scale will be used as the maximum level of detail.
  • CityA single city scale will be used as the maximum level of detail.
String
Add Statistic to Cache
(Optional)

Specifies the statistics that will be summarized and stored in the bin cache. Statistics are used to symbolize bins and provide aggregate information for all the points in a bin. One summary statistic, shape_count (which is the total feature count), is always available.

  • Field—The field on which the summary statistics will be calculated. Supported field types are short integer, long integer, big integer, float, and double.
  • Statistic Type—The type of statistic that will be calculated for the specified field. Statistics are calculated for all features in the bin. Available statistics types are as follows:
    • Mean (AVG)—The mean (average value) for the specified field will be calculated.
    • Minimum (MIN)—The minimum (smallest value) of all records for the specified field will be identified.
    • Maximum (MAX)—The maximum (largest value) of all records for the specified field will be identified.
    • Standard deviation (STDDEV)—The standard deviation value for the field will be calculated.
    • Sum (SUM)—The sum of the values for the specified field will be calculated.

Value Table
Delete Statistic from Cache
(Optional)

The summary statistic that will be deleted from the cache. You cannot delete the default COUNT summary statistic.

String

Derived Output

LabelExplanationData Type
Updated Features

The input features with the updated feature bin cache.

Feature Layer

arcpy.management.ManageFeatureBinCache(in_features, {bin_type}, {max_lod}, {add_cache_statistics}, {delete_cache_statistics})
NameExplanationData Type
in_features

The binned feature class that will have its static cache updated.

Feature Layer
bin_type
(Optional)

Specifies the type of feature binning visualization that will be enabled.

  • FLAT_HEXAGONThe flat hexagon binning scheme, also known as flat geohex or flat hexbinning, will be enabled. The tiles are a tessellation of hexagons in which the orientation of the hexagons has a flat edge of the hexagon on top. This is the default for Microsoft SQL Server, Oracle, and PostgreSQL data.
    Flat hexagon bin type
  • POINTY_HEXAGONThe pointy hexagon binning scheme, also known as pointy geohex or pointy hexbinning, will be enabled. The tiles are a tessellation of hexagons in which the orientation of the hexagons has a point of the hexagon on top.
    Pointy hexagon bin type
  • SQUAREThe square binning scheme in which the tiles are a tessellation of squares, also known as geosquare or squarebinning, will be enabled. This is the default for Db2 data.
    Square hexagon bin type
  • GEOHASHThe geohash binning scheme in which the tiles are a tessellation of rectangles will be enabled. Because geohash bins always use the WGS84 geographic coordinate system (GCS WGS84, EPSG WKID 4326), you cannot specify a bin coordinate system for geohash bins.
    Geohash bin type
String
max_lod
(Optional)

Specifies the maximum level of detail that will be used for the cache.

Tiling schemes are a continuum of scale ranges. Depending on the map, you may want to forego caching of some of the extremely large or small scales in the tiling scheme. This tool examines the scale dependencies in the map and attempts to provide a maximum range of scale for caching. Choose a level of detail that most closely matches the intended use of the map in which the data will be shown.

  • WORLDA world scale will be used as the maximum level of detail.
  • CONTINENTSMultiple continents scale will be used as the maximum level of detail.
  • CONTINENTA single continent scale will be used as the maximum level of detail.
  • COUNTRIESMultiple countries scale will be used as the maximum level of detail.
  • COUNTRYA single country scale will be used as the maximum level of detail.
  • STATESMultiple states scale will be used as the maximum level of detail.
  • STATEA single state scale will be used as the maximum level of detail.
  • COUNTIESMultiple counties scale will be used as the maximum level of detail.
  • COUNTYA single county scale will be used as the maximum level of detail.
  • CITIESMultiple cities scale will be used as the maximum level of detail.
  • CITYA single city scale will be used as the maximum level of detail.
String
add_cache_statistics
[[Field, Statistic Type],...]
(Optional)

Specifies the statistics that will be summarized and stored in the bin cache. Statistics are used to symbolize bins and provide aggregate information for all the points in a bin. One summary statistic, shape_count (which is the total feature count), is always available.

  • Field—The field on which the summary statistics will be calculated. Supported field types are short integer, long integer, big integer, float, and double.
  • Statistic Type—The type of statistic that will be calculated for the specified field. Statistics are calculated for all features in the bin. Available statistics types are as follows:
    • Mean (AVG)—The mean (average value) for the specified field will be calculated.
    • Minimum (MIN)—The minimum (smallest value) of all records for the specified field will be identified.
    • Maximum (MAX)—The maximum (largest value) of all records for the specified field will be identified.
    • Standard deviation (STDDEV)—The standard deviation value for the field will be calculated.
    • Sum (SUM)—The sum of the values for the specified field will be calculated.

Value Table
delete_cache_statistics
[delete_cache_statistics,...]
(Optional)

The summary statistic that will be deleted from the cache. You cannot delete the default COUNT summary statistic.

String

Derived Output

NameExplanationData Type
out_features

The input features with the updated feature bin cache.

Feature Layer

Code sample

ManageFeatureBinCache example (Python window)

Add a new statistic to calculate the maximum depth and set the level of detail of the feature bin cache for a feature layer named Earthquakes.

import arcpy
arcpy.management.ManageFeatureBinCache("lod_gdb.elec.Earthquakes", "SQUARE", 
                                       "STATE", "depth_km MAX")

Environments

Related topics