Community

Geoprocessing tool to report spatial index statistics

397
0
12-14-2016 07:05 PM
Status: Open
MarkChilcott
by
Occasional Contributor III

sdetable -o si_stats is a useful command line tool.

Build a Geoprocessing tool to report the same things.

ArcSDE 10.2
Layer    Administration Utility
-----------------------------------------------------
Layer 2237 Spatial Index Statistics:
Level 1,   Grid Size 4000
|-------------------------------------------------------------------|
| Grid Records: 105565                                              |
| Feature Records: 92519                                            |
| Grids/Feature Ratio:  1.14                                        |
| Avg. Features per Grid: 42.88                                     |
| Max. Features per Grid: 8022                                      |
| % of Features Wholly Inside 1 Grid: 91.82                         |
|-------------------------------------------------------------------|
|               Spatial Index Record Count By Group                 |
| Grids:      <=4    >4    >10    >25    >50    >100   >250   >500  |
|---------- ------ ------ ------ ------ ------ ------ ------ ------ |
| Features:  92225    294     98     20      8      2      0      0 |
| % Total:     100%     0%     0%     0%     0%     0%     0%     0%|
|-------------------------------------------------------------------|