topic Re: arcpy.Append_management creates spatial index in Python Questions https://community.esri.com/t5/python-questions/arcpy-append-management-creates-spatial-index/m-p/425520#M33424 <HTML><HEAD></HEAD><BODY><P>Ausome post Neil's,</P><P>Been struggling to find a solution to this, especially when the feature class turns to million rows, the append goes on for ever on postgre DB.</P><P>But, after this environment setting, it just takes minutes.</P><P></P><P>However, i have a question to you.</P><P>Do i need to rebuild the spatial index regularly or will the postgre DB take care of this?</P><P>I know that, i am asking a postgre DB related question, but this might be applicable for others as well.</P><P></P><P>Regards</P><P>Sandeep</P></BODY></HTML> Fri, 04 Sep 2015 09:36:45 GMT SandeepKuniel 2015-09-04T09:36:45Z arcpy.Append_management creates spatial index https://community.esri.com/t5/python-questions/arcpy-append-management-creates-spatial-index/m-p/425516#M33420 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We are using arcpy.Append_management to import shape files into existing tables in an Oracle database. For some reason Append_management automatically creates a spatial index after the append. We don't want this behaviour. How can we disable the automagical creation of a spatial index?</P><P></P><P>Thanks,</P><P>Rob</P></BODY></HTML> Thu, 12 Feb 2015 09:02:50 GMT https://community.esri.com/t5/python-questions/arcpy-append-management-creates-spatial-index/m-p/425516#M33420 Rvan_Rijen 2015-02-12T09:02:50Z Re: arcpy.Append_management creates spatial index https://community.esri.com/t5/python-questions/arcpy-append-management-creates-spatial-index/m-p/425517#M33421 <HTML><HEAD></HEAD><BODY><P>Well the creation of the spatial index is a feature of the geodb.</P><P>You can create a very long list of inputs and have them all appended together, that way the spatial index is calculated only once at the end.</P><P>If you append them invidually, each time append runs the spatial index will be recalculated, which does increase processing time.</P><P>Perhaps you can mess with the spatialGrid1, 2, 3 in the arcpy.env settings. Set them all to 0 and see what happens.</P></BODY></HTML> Thu, 12 Feb 2015 09:25:43 GMT https://community.esri.com/t5/python-questions/arcpy-append-management-creates-spatial-index/m-p/425517#M33421 NeilAyres 2015-02-12T09:25:43Z Re: arcpy.Append_management creates spatial index https://community.esri.com/t5/python-questions/arcpy-append-management-creates-spatial-index/m-p/425518#M33422 <HTML><HEAD></HEAD><BODY><P>Thanks Neil!</P><P></P><P>For me as an Oracle developer, the automatic creation of the spatial index is not a feature but a bug <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P><P>Your reply has triggered me to look at the arcpy.env settings and initial test show that maintainSpatialIndex does the trick</P><P></P><PRE __default_attr="python" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14237349824418743" jivemacro_uid="_14237349824418743" modifiedtitle="true"><P>arcpy.env.maintainSpatialIndex = True</P></PRE><P><BR />It's a bit counter-intuitive, but it looks like arcpy.env.maintainSpatialIndex = True actually means: leave the spatial index status unchanged and if none exists, don't create one.</P><P></P><P>Regards,</P><P>Rob</P></BODY></HTML> Thu, 12 Feb 2015 10:00:13 GMT https://community.esri.com/t5/python-questions/arcpy-append-management-creates-spatial-index/m-p/425518#M33422 Rvan_Rijen 2015-02-12T10:00:13Z Re: arcpy.Append_management creates spatial index https://community.esri.com/t5/python-questions/arcpy-append-management-creates-spatial-index/m-p/425519#M33423 <HTML><HEAD></HEAD><BODY><P>Good to here that you have found the workaround</P></BODY></HTML> Thu, 12 Feb 2015 10:32:26 GMT https://community.esri.com/t5/python-questions/arcpy-append-management-creates-spatial-index/m-p/425519#M33423 NeilAyres 2015-02-12T10:32:26Z Re: arcpy.Append_management creates spatial index https://community.esri.com/t5/python-questions/arcpy-append-management-creates-spatial-index/m-p/425520#M33424 <HTML><HEAD></HEAD><BODY><P>Ausome post Neil's,</P><P>Been struggling to find a solution to this, especially when the feature class turns to million rows, the append goes on for ever on postgre DB.</P><P>But, after this environment setting, it just takes minutes.</P><P></P><P>However, i have a question to you.</P><P>Do i need to rebuild the spatial index regularly or will the postgre DB take care of this?</P><P>I know that, i am asking a postgre DB related question, but this might be applicable for others as well.</P><P></P><P>Regards</P><P>Sandeep</P></BODY></HTML> Fri, 04 Sep 2015 09:36:45 GMT https://community.esri.com/t5/python-questions/arcpy-append-management-creates-spatial-index/m-p/425520#M33424 SandeepKuniel 2015-09-04T09:36:45Z