topic how to recalculate spatial index in Developers Questions https://community.esri.com/t5/developers-questions/how-to-recalculate-spatial-index/m-p/453141#M3025 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/120003_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>How can I recalculate the spatial index for a featureclass in SQL Server programatically?</P><P>I already use the interfaces IIndexEdit and IGeometryDefEdit to recalculate the index by cloning the old index, following the example "RebuildSpatialIndex" in the developer help.</P><P>But I have to recalculate the extent because of performance issues. I can do it in ArcCatalog (Button "Neu berechnen" in the picture above), but how to reach the functionality programatically?</P><P></P><P>Thanks for any hint!</P><P>Frank</P></BODY></HTML> Fri, 31 Jul 2015 07:22:42 GMT FrankHochstrate 2015-07-31T07:22:42Z how to recalculate spatial index https://community.esri.com/t5/developers-questions/how-to-recalculate-spatial-index/m-p/453141#M3025 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/120003_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>How can I recalculate the spatial index for a featureclass in SQL Server programatically?</P><P>I already use the interfaces IIndexEdit and IGeometryDefEdit to recalculate the index by cloning the old index, following the example "RebuildSpatialIndex" in the developer help.</P><P>But I have to recalculate the extent because of performance issues. I can do it in ArcCatalog (Button "Neu berechnen" in the picture above), but how to reach the functionality programatically?</P><P></P><P>Thanks for any hint!</P><P>Frank</P></BODY></HTML> Fri, 31 Jul 2015 07:22:42 GMT https://community.esri.com/t5/developers-questions/how-to-recalculate-spatial-index/m-p/453141#M3025 FrankHochstrate 2015-07-31T07:22:42Z Re: how to recalculate spatial index https://community.esri.com/t5/developers-questions/how-to-recalculate-spatial-index/m-p/453142#M3026 <HTML><HEAD></HEAD><BODY><P>Grüß Dich,</P><P></P><P>Have you looked into a Python option? This link explains an approach using ArcPy to do what you are looking for.</P><P></P><P>*** EDITED WITH CORRECT LINK ***</P><P><A href="http://resources.arcgis.com/en/help/main/10.2/0017/00170000014w000000.htm" title="http://resources.arcgis.com/en/help/main/10.2/0017/00170000014w000000.htm">ArcGIS Help 10.2 - Rebuild Indexes (Data Management)</A> </P><P></P><P>*** EDITED WITH CORRECT LINK ***</P><P></P><P>Viel Glück,</P><P>Shaun</P></BODY></HTML> Fri, 31 Jul 2015 13:06:45 GMT https://community.esri.com/t5/developers-questions/how-to-recalculate-spatial-index/m-p/453142#M3026 ShaunConway 2015-07-31T13:06:45Z Re: how to recalculate spatial index https://community.esri.com/t5/developers-questions/how-to-recalculate-spatial-index/m-p/453143#M3027 <HTML><HEAD></HEAD><BODY><P>Shaun-</P><P></P><P>thanks for the hint, but I couldn't find ArcPy functions, that will do the desired work.</P><P>I suppose, the task is "too specific", it depends on the given DBMS.</P><P></P><P>I still hope, someone has an idea...</P><P></P><P>-Frank</P></BODY></HTML> Fri, 31 Jul 2015 14:59:37 GMT https://community.esri.com/t5/developers-questions/how-to-recalculate-spatial-index/m-p/453143#M3027 FrankHochstrate1 2015-07-31T14:59:37Z Re: how to recalculate spatial index https://community.esri.com/t5/developers-questions/how-to-recalculate-spatial-index/m-p/453144#M3028 <HTML><HEAD></HEAD><BODY><P>Sorry for the bad link. Here is the correct link. Or you can search on Rebuild Indexes under Data Management.</P><P></P><P><A href="http://resources.arcgis.com/en/help/main/10.2/0017/00170000014w000000.htm" title="http://resources.arcgis.com/en/help/main/10.2/0017/00170000014w000000.htm">ArcGIS Help 10.2 - Rebuild Indexes (Data Management)</A> </P><P></P><P>Shaun</P></BODY></HTML> Fri, 31 Jul 2015 15:06:48 GMT https://community.esri.com/t5/developers-questions/how-to-recalculate-spatial-index/m-p/453144#M3028 ShaunConway 2015-07-31T15:06:48Z Re: how to recalculate spatial index https://community.esri.com/t5/developers-questions/how-to-recalculate-spatial-index/m-p/453145#M3029 <HTML><HEAD></HEAD><BODY><P>Are you trying to Recalculate the <STRONG>Spatial Index</STRONG> or the <STRONG>Extent</STRONG> of that feature class?</P></BODY></HTML> Fri, 31 Jul 2015 16:15:24 GMT https://community.esri.com/t5/developers-questions/how-to-recalculate-spatial-index/m-p/453145#M3029 AsrujitSengupta 2015-07-31T16:15:24Z Re: how to recalculate spatial index https://community.esri.com/t5/developers-questions/how-to-recalculate-spatial-index/m-p/453146#M3030 <HTML><HEAD></HEAD><BODY><P>I try to recalculate both. First I rebuild the spatial index but after that the feature class extend is equal to the extent of the feature dataset. </P><P></P><P><IMG alt="" class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/120277_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P><IMG alt="" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/120276_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>After creating the spatial index I have to recalculate the extent of the feature class (Button "Neu berechnen").</P></BODY></HTML> Mon, 03 Aug 2015 06:23:36 GMT https://community.esri.com/t5/developers-questions/how-to-recalculate-spatial-index/m-p/453146#M3030 FrankHochstrate1 2015-08-03T06:23:36Z