(Edit: I shortened the script as a big portion of it wasn't part of the main problem.) I'm working on a script to re-project shapefiles from a selected shapefile with a different projection. While the execution of the tool works, it fails when overwriting the same file regardless of adding in arcpy.env.overwriteOutput = True. Here is the script used: if srcDesc . SpatialReference . Name == targetDesc . SpatialReference . Name : continue #Shapefiles in the targeted folder that don't match will reprojected to the selected shapefile. else : #Replaces the TargetFolder's ".shp" at the end of the end of the name with "_projected." ReprojectedData = InFolder . replace ( ".shp" , "_projected" ) #Tool re-projects the datasets that doesn't match the spatial reference of the targeted shapefile. arcpy . Project_management ( InFolder , ReprojectedData , InFile ) #Displays a message of success of the projected datasets.print "Projected " + str(InFolder) arcpy . AddMessage ( "Projected " + str ( InFolder ) ) Is there a different way of using an overwrite output for a script such as this?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Overwrite Output Error 999999

JacobHorwitz1

(Edit: I shortened the script as a big portion of it wasn't part of the main problem.)

I'm working on a script to re-project shapefiles from a selected shapefile with a different projection. While the execution of the tool works, it fails when overwriting the same file regardless of adding in arcpy.env.overwriteOutput = True.

Here is the script used:

<SPAN class="keyword token">if</SPAN> srcDesc<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">.</SPAN>Name <SPAN class="operator token">==</SPAN> targetDesc<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">.</SPAN>Name<SPAN class="punctuation token">:</SPAN>
<SPAN class="keyword token">continue</SPAN>

<SPAN class="comment token">#Shapefiles in the targeted folder that don't match will reprojected to the selected shapefile.</SPAN>

<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>

<SPAN class="comment token">#Replaces the TargetFolder's ".shp" at the end&nbsp; of the end of the name with "_projected."</SPAN>

ReprojectedData <SPAN class="operator token">=</SPAN> InFolder<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">".shp"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"_projected"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Tool re-projects the datasets that doesn't match the spatial reference of the targeted shapefile.</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>Project_management<SPAN class="punctuation token">(</SPAN>InFolder<SPAN class="punctuation token">,</SPAN> ReprojectedData<SPAN class="punctuation token">,</SPAN> InFile<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Displays a message of success of the projected datasets.print "Projected " + str(InFolder)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Projected "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>InFolder<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Is there a different way of using an overwrite output for a script such as this?

Find more posts tagged with

Accepted answers

JacobHorwitz1

I was able to finally find the solution! I had to add an extra ".shp" to "_projected" as "_projected.shp." to fix the Error: 999999.

All comments

Brian_Wilson

I've done this many many times when "overwriting" because setting overwrite to True often fails, causing my scripts to exit,

if arcpy.Exists(fc): arcpy.management.Delete(fc)

The problem I've been seeing is when I publish a feature class to Portal with overwrite True and it creates a new service with the same name. You can't do "delete old and create new" because it will give the new layer a different unique ID and that means all your maps are broken.

(I came here because I saw Error 999999 and Overwrite in the "Related" column and got excited. 🙂

(I'm thinking of running off Error 999999 t-shirts, I think it would be a great inside joke for Esri users.)

JacobHorwitz1

I was able to finally find the solution! I had to add an extra ".shp" to "_projected" as "_projected.shp." to fix the Error: 999999.

forestknutsen1

I have noticed the env overwrite is not always honored. I typically delete (as Dan suggested) or add a number to the end of my names and increment it to generate unqunie names,

DanPatterson_Retired

Is your destination workspace a file geodatabse? I ask since you are replacing *.shp with _projected, implying such.

I also suggest that you dump the try-except block and dedent everything since the exception is not informative. It is better to get a real error than a message that something failed. Exception tracking will return the same error message for the most part, as dumping the try except block.

Sometimes it is just better to use a Delete_management, to delete existing data rather than relying on the overwriteOutput

JacobHorwitz1

Reupdated the post for Syntax Highlighter.

DanPatterson_Retired

Jacob could you format your code so that it has line numbers

/blogs/dan_patterson/2016/08/14/script-formatting

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.