Any reason why this wouldn't be working? import arcpy import os basedir = 'C:\\Temp' gdb_name = 'TestGDB' gdb = os . path . join ( basedir , gdb_name ) if arcpy . Exists ( gdb ) : arcpy . env . workspace = gdb else : gdb = arcpy . CreateFileGDB_management ( basedir , gdb_name ) arcpy . env . workspace = gdb I must not be understanding how .Exists() resolves, for if the gdb already exists, it gives me: arcgisscripting.ExecuteError: ERROR 000258: Output C:\Temp\TestGDB.gdb already exists Failed to execute (CreateFileGDB) If the gdb does not exist, it gives me: RuntimeError: Object: Error in accessing environment

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; } } }

Creating a geodatabase and setting it to env.workspace

EricEagle

Any reason why this wouldn't be working?

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> os

basedir <SPAN class="operator token">=</SPAN> <SPAN class="string token">'C:\\Temp'</SPAN>
gdb_name <SPAN class="operator token">=</SPAN> <SPAN class="string token">'TestGDB'</SPAN>
gdb <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>basedir<SPAN class="punctuation token">,</SPAN> gdb_name<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>gdb<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> gdb
<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; gdb <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>CreateFileGDB_management<SPAN class="punctuation token">(</SPAN>basedir<SPAN class="punctuation token">,</SPAN> gdb_name<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> gdb‍‍‍‍‍‍‍‍‍‍‍‍<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>

I must not be understanding how .Exists() resolves, for if the gdb already exists, it gives me:

arcgisscripting.ExecuteError: ERROR 000258: Output C:\Temp\TestGDB.gdb already exists

Failed to execute (CreateFileGDB)

If the gdb does not exist, it gives me:

RuntimeError: Object: Error in accessing environment <workspace>

Find more posts tagged with

Accepted answers

IanMurray

Can you check to make sure it creates the GDB? I think its not creating it at all.

Make line 11 just:

arcpy.CreateFileGDB_management(basedir, gdb_name)

Right now instead of creating the actual gdb, you are setting a variable equal to it, which I'm not sure what that would do but it likely isn't creating it.

All comments

JoshuaBixby

When creating the file geodatabase path for setting a workspace, you need to include the ".gdb" on the end, otherwise you are setting the workspace to a folder.

IanMurray

You are missing the file extension in your gdb variable. gdb_name needs the extension on it before you join the path.

EricEagle

Thanks Ian/Joshua,

When I include the .gdb extension (gdb_name = 'TestGDB.gdb') and the geodatabase exists, it completes. When the geodatabase does not exist, it creates the TestGDB.gdb object, but still gives me the same runtime error.

IanMurray

Can you check to make sure it creates the GDB? I think its not creating it at all.

Make line 11 just:

arcpy.CreateFileGDB_management(basedir, gdb_name)

Right now instead of creating the actual gdb, you are setting a variable equal to it, which I'm not sure what that would do but it likely isn't creating it.

EricEagle

Thanks Ian. It felt like I should be able to dump the method into a variable in one step like other methods to save a line of code, but regardless, it works now, thank you.

JonathanQuinn

Just to provide more insight, if you print the gdb variable, you'll get "<basedir>\<gdb_name>". The OS separator between the out file path and FGDB name isn't escaped properly, as it's set to a backslash, which is why you see that runtime error when trying to use the gdb variable as is. In one line, this worked:

gdb = str(arcpy.CreateFileGDB_management(outDir,outName)).replace("\\","/")

You can replace the single backslash, (escaped with a double backslash), with a forward slash.

JoshuaBixby

I am using ArcGIS 10.5, and Create File GDB returns properly escaped results:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> var <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>CreateFileGDB_management<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'C:\tmp'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'test'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> var
<SPAN class="operator token"><</SPAN>Result <SPAN class="string token">'C:\\tmp\\test.gdb'</SPAN><SPAN class="operator token">></SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>var<SPAN class="punctuation token">)</SPAN>
<SPAN class="token boolean">True</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The double backslashes are perfectly valid, they don't have to be forward slashes.

JonathanQuinn

If you call on the variable without printing, it'll be correct as a Result object. If you print the variable you'll see the backslash is not escaped:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> gdb <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>CreateFileGDB_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"C:/Temp"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"blah.gdb"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> gdb
<SPAN class="operator token"><</SPAN>Result <SPAN class="string token">'C:/Temp\\blah.gdb'</SPAN><SPAN class="operator token">></SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>gdb<SPAN class="punctuation token">)</SPAN>
C<SPAN class="punctuation token">:</SPAN><SPAN class="operator token">/</SPAN>Temp\blah<SPAN class="punctuation token">.</SPAN>gdb
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>gdb<SPAN class="punctuation token">)</SPAN>
<SPAN class="token boolean">True</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> gdb
Runtime error 
Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 File <SPAN class="string token">"<string>"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
 File <SPAN class="string token">"c:\program files (x86)\arcgis\desktop10.5\arcpy\arcpy\geoprocessing\_base.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">541</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> set_
 self<SPAN class="punctuation token">[</SPAN>env<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> val
 File <SPAN class="string token">"c:\program files (x86)\arcgis\desktop10.5\arcpy\arcpy\geoprocessing\_base.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">601</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> __setitem__
 ret_ <SPAN class="operator token">=</SPAN> setattr<SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">.</SPAN>_gp<SPAN class="punctuation token">,</SPAN> item<SPAN class="punctuation token">,</SPAN> value<SPAN class="punctuation token">)</SPAN>
RuntimeError<SPAN class="punctuation token">:</SPAN> Object<SPAN class="punctuation token">:</SPAN> Error <SPAN class="keyword token">in</SPAN> accessing environment <SPAN class="operator token"><</SPAN>workspace<SPAN class="operator token">></SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>gdb<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\\"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"/"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace
u<SPAN class="string token">'C:/Temp/blah.gdb'</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>‍</SPAN><SPAN>‍</SPAN></SPAN>

There seems to be different implementations of arcpy.Exists and arcpy.env.workspace, as the latter seems to look at the result as a string.

curtvprice

This is right on.

eric.eagle It's a little confusing that you have named the result object the same as the gdb full path. A better way to implement this is:

r_gdb = arcpy.CreateFileGDB_management(basedir, gdb_name)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

The result object can be used as input parameter to a tool, in which case it will be converted to a path. Or you can convert it to a path yourself with either of these statements -- or just use gdb which you set earlier in the code.

gdb <SPAN class="operator token">=</SPAN> r_gdb<SPAN class="punctuation token">.</SPAN>getOutput<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>
gdb <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>r_gdb<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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.