Does anybody have a good method of doing this? I've tried using the zipfile python library but am utterly confused on how to do it for a file geodatabase since it's not exactly a directory/file structure. My folder structure looks like so, I want to zip up the folder/geodatabase outlined in red: I've tried this (all the indentation is correct in my script, don't know why GeoNet is changing it upon publishing the question): import zipfile #Creates the empty zip file and opens it for writing myzipfile = zipfile . ZipFile ( "D:\GIS_Testing\HabitatDbase\MyZip.zip" , 'w' , zipfile . ZIP_DEFLATED ) for root , dirs , files in os . walk ( "D:\GIS_Testing\HabitatDbase" ) : if root == "D:\GIS_Testing\HabitatDbase\HabitatData.gdb" : for f in files : myzipfile . write ( os . path . join ( root , file ) ) I've also tried using shutil.make_archive and for some reason instead of zipping up my file geodatabase it zips up my python script file which is completely bewildering as I have no idea how it would even get the path to the script file... I get a TypeError on the last line that says "object of type 'type' has no len()"

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

Zip a file geodatabase using ArcPy or Zipfile library

MKF62

Does anybody have a good method of doing this?

I've tried using the zipfile python library but am utterly confused on how to do it for a file geodatabase since it's not exactly a directory/file structure. My folder structure looks like so, I want to zip up the folder/geodatabase outlined in red:

I've tried this (all the indentation is correct in my script, don't know why GeoNet is changing it upon publishing the question):

<SPAN class="keyword token">import</SPAN> zipfile

<SPAN class="comment token">#Creates the empty zip file and opens it for writing</SPAN>
myzipfile <SPAN class="operator token">=</SPAN> zipfile<SPAN class="punctuation token">.</SPAN>ZipFile<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"D:\GIS_Testing\HabitatDbase\MyZip.zip"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'w'</SPAN><SPAN class="punctuation token">,</SPAN> zipfile<SPAN class="punctuation token">.</SPAN>ZIP_DEFLATED<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> root<SPAN class="punctuation token">,</SPAN> dirs<SPAN class="punctuation token">,</SPAN> files <SPAN class="keyword token">in</SPAN> os<SPAN class="punctuation token">.</SPAN>walk<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"D:\GIS_Testing\HabitatDbase"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">if</SPAN> root <SPAN class="operator token">==</SPAN> <SPAN class="string token">"D:\GIS_Testing\HabitatDbase\HabitatData.gdb"</SPAN><SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> files<SPAN class="punctuation token">:</SPAN>
 myzipfile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>root<SPAN class="punctuation token">,</SPAN> file<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>

I've also tried using shutil.make_archive and for some reason instead of zipping up my file geodatabase it zips up my python script file which is completely bewildering as I have no idea how it would even get the path to the script file...

I get a TypeError on the last line that says "object of type 'type' has no len()"

Find more posts tagged with

Accepted answers

DarrenWiens2

Should it be 'f' rather than 'file' in the last line?

All comments

ARyanWADNR

This was super helpful! But one caution for future users, if you copy and paste the script the last line may cause an invalid character error. For some reason the last line from this discussion page contained a Zero-width joiner, unicode "U+200D".

AndyFairbairn

shutil.make_archive(zipfilename, 'zip', root_dir = r"C:\folder\path\containing_fgdb", base_dir = "file_gdb_name.gdb")‍‍‍‍‍‍‍

This should avoid the need to have your file geodatabase in it's own subfolder before zipping, which I think is required in the above solution.

patrick_shp

Slight addendum:

You can't zip the .gdb file directly and upload to portal using this script. It must first be added to a subfolder by itself. So that means that input_geodatabase points to something like r"C:\Users\parent_folder", where "parent_folder" contains only the .gdb file. Hope that makes sense!

patrick_shp

Reviving an older thread, but there aren't too many helpful resources online about this topic...

I had issues utilizing tigerwoulds' script, so I tweaked the function a bit:

zip_geodatabase(input_geodatabase, output_zip)

def zip_geodatabase(input_geodatabase, output_zip):
     # Create a zip file
     with zipfile.ZipFile(output_zip, 'w') as zipf:
          # Iterate over all files in the geodatabase
          for root, dirs, files in os.walk(input_geodatabase):
               for file in files:
                    # Add each file to the zip file
                    file_path = os.path.join(root, file)
                    if file[-5:] != '.lock':
                         zipf.write(file_path, os.path.relpath(file_path, input_geodatabase))

#input_geodatabase = r"C:\Users\myfile.gdb"
#output_zip = r"C:\Users\myoutputfile.zip"
#zip_geodatabase(input_geodatabase, output_zip)

danashney

Since this took me much longer to figure out than I care to admit:

The sample provided by TigerWoulds results in a copy of the inputGDB within a zipped folder of the same name. If you want to create a zipped copy without that nesting then remove

gdbName + '\\' +

from the line

myzip.write(os.path.join(gdbFile, f), gdbName + '\\' + os.path.basename(f))

DAVIDWADSWORTH_LVVWD

Thanks for sharing.

DAVIDWADSWORTH_LVVWD

Thanks for adding this key distinction. Saved me a lot of time.

tigerwoulds

Old post but figured I'd post my solution incase it helps anyone else. This function will zip the geodatabase and skip any lock files. I was trying to implement the zip in a larger codebase and kept running into locks.

def zipGDB(inputGDB):
    gdbFile = str(inputGDB)
    outFile = gdbFile[0:-4] + '.zip'
    gdbName = os.path.basename(gdbFile)
    with zipfile.ZipFile(outFile, mode='w', compression=zipfile.ZIP_DEFLATED, allowZip64=True) as myzip:
        for f in os.listdir(gdbFile):
            if f[-5:] != '.lock':
                myzip.write(os.path.join(gdbFile, f), gdbName + '\\' + os.path.basename(f))
    print('Completed zipping: {}'.format(gdbFile))

VinceAngelo

The '.gdb' of a file geodatabase is a directory, not a file. The file geodatabase is the directory and all the files below it (except the lock files -- you can keep those out).

- V

AaronKoelker

As usual, seconds after posting a question -- I get it to work. However I used shutil.make_archive instead of the above ZipFile method.

shutil.make_archive(zipfilename, 'zip', fgdb)‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

zipfilename = filename of your new zip, plus the path ("D:/MyFolder/ExampleFolder/thenameofmynewzip"), leave off the .zip file extension
fgdb = the file geodatabase you want to zip ("D:/MyFolder/ExampleFolder/MyFGDB.gdb")

EDIT: Actually, while the above code technically works, it won't be a good solution if you're trying to zip up the fgdb for uploading to ArcGIS Online. Instead, have fgdb point to the folder that contains the MyFGDB.gdb file, rather than the .gdb file itself. Otherwise you'll get an error when uploading to AGO. You'll also want separate the the new zipfile and the fgdb into their own folders, or add code to grab the fgdb specifically (similar to what the original post is doing). If not, you'll get an empty zip within your zip since it creates the new zip file first before adding in your .gdb, looks like. I'm sure someone else has a more elegant solution to this bit.

AaronKoelker

This is one of the only examples I can find of zipping up a .gdb with python, however when I try to use this method,(accounting for the typo in the last line) my new zip file contains the entire folder structure leading up to the .gdb. Anyone have an idea of how to just zip up the .gdb file?

MichelleMathias

I just put some pressure on the vendor to get us a fix soon.

JoshuaBixby

Agreed, now that the mangling is affecting discussions in addition to blogs, the impacts will be much more significant.

DanPatterson_Retired

Michelle Mathias‌ code mangling still today... it is going to get ugly until they fix it

MKF62

Hahaha, seriously, of course it's just a typo. Thank you!! I'll leave the thread up because I couldn't find any good examples on how to zip up a file geodatabase in python on GeoNet. Maybe it'll help someone later...

DarrenWiens2

Should it be 'f' rather than 'file' in the last line?

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.