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 feature classes stored in an enterprise geodatabase or database.
Supported platforms are as follows:
IBM Db2
Microsoft SQL Server
Oracle
PostgreSQL
SQLite
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.
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 hexagon—The 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, SQLite, and PostgreSQL data.
Pointy hexagon—The 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.
Square—The 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.
Geohash—The 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.
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.
World—A world scale will be used as the maximum level of detail.
Continents—Multiple continents scale will be used as the maximum level of detail.
Continent—A single continent scale will be used as the maximum level of detail.
Countries—Multiple countries scale will be used as the maximum level of detail.
Country—A single country scale will be used as the maximum level of detail.
States—Multiple states scale will be used as the maximum level of detail.
State—A single state scale will be used as the maximum level of detail.
Counties—Multiple counties scale will be used as the maximum level of detail.
County—A single county scale will be used as the maximum level of detail.
Cities—Multiple cities scale will be used as the maximum level of detail.
City—A 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 features in a bin. One summary statistic, shape_count (which is the total feature count), is always available.
Value table columns:
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.
Mean—The mean (average value) for the specified field will be calculated.
Minimum—The minimum (smallest value) of all records for the specified field will be identified.
Maximum—The maximum (largest value) of all records for the specified field will be identified.
Standard deviation—The standard deviation value for the field will be calculated.
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
Label
Explanation
Data type
Updated Features
The input features with the updated feature bin cache.
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_HEXAGON—The 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, SQLite, and PostgreSQL data.
POINTY_HEXAGON—The 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.
SQUARE—The 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.
GEOHASH—The 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.
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.
WORLD—A world scale will be used as the maximum level of detail.
CONTINENTS—Multiple continents scale will be used as the maximum level of detail.
CONTINENT—A single continent scale will be used as the maximum level of detail.
COUNTRIES—Multiple countries scale will be used as the maximum level of detail.
COUNTRY—A single country scale will be used as the maximum level of detail.
STATES—Multiple states scale will be used as the maximum level of detail.
STATE—A single state scale will be used as the maximum level of detail.
COUNTIES—Multiple counties scale will be used as the maximum level of detail.
COUNTY—A single county scale will be used as the maximum level of detail.
CITIES—Multiple cities scale will be used as the maximum level of detail.
CITY—A 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 features in a bin. One summary statistic, shape_count (which is the total feature count), is always available.
Value table columns:
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.
AVG—The mean (average value) for the specified field will be calculated.
MIN—The minimum (smallest value) of all records for the specified field will be identified.
MAX—The maximum (largest value) of all records for the specified field will be identified.
STDDEV—The standard deviation value for the field will be calculated.
SUM—The sum of the values for the specified field will be calculated.
