topic Re: Automatically compress File Geodabases in Data Management Questions

Automatically compress File Geodabases

MarkVolz — Thu, 10 Dec 2020 13:51:47 GMT

Hello,

I would like to know if there is geoprocessing script or another way to crawl through a directory and automatically compress any File Geodabases within the subfolder. This would save me the time of needing to manually search for all of the Geodatabases in directory.

Thanks!

P.S. I did come across this script, but it appears to apply towards SQL databases and not File Geodabases. https://community.esri.com/t5/data-management-documents/compress-geodatabase-tool/ta-p/908944

Re: Automatically compress File Geodabases

JohannesBierer — Thu, 10 Dec 2020 13:56:43 GMT

Maybe this could help you?

https://gis.stackexchange.com/questions/129454/how-to-compact-geodatabases-in-multiple-directories-using-arcpy

Re: Automatically compress File Geodabases

JohannesBierer — Thu, 10 Dec 2020 14:02:50 GMT

Could this help you?

https://gis.stackexchange.com/questions/129454/how-to-compact-geodatabases-in-multiple-directories-using-arcpy

Re: Automatically compress File Geodabases

JohannesBierer — Thu, 10 Dec 2020 14:17:08 GMT

Not tested but could work?

It's from here: "https://gis.stackexchange.com/questions/129454/how-to-compact-geodatabases-in-multiple-directories-using-arcpy"

import arcpy, os from arcpy import env arcpy.env.workspace = r"C:\" for path, dirs, files in os.walk(arcpy.env.workspace): for dir in dirs: if ".gdb" in dir: workspace = os.path.join(path, dir) arcpy.Compact_management(workspace)

Re: Automatically compress File Geodabases

JoeBorgione — Thu, 10 Dec 2020 15:15:14 GMT

It would not be a tough script to write; psuedo code might like look like this:

import arcpy arcpy.env.workpace = #directory of geodatabases fgdbList = arcpy.ListWorkspaces("*", "FileGDB") for fgdb in fgdbList: arcpy.CompressFileGeodatabaseData_management(fgdb)

The question I have though is what is the purpose of compressing a file geodatabase on a regular basis?

Re: Automatically compress File Geodabases

MarkVolz — Thu, 10 Dec 2020 15:22:26 GMT

Joe,

I will check out your script to compress Geodatabases. To answer your question, the purpose of compressing the File Geodabases is to reduce the storage on older Geodatabases that are infrequently used, such as those in archive folders. In theory this should be a one-time script. All that being said, I hope I am not confusing compressing a database with compacting a database. Please let me know if you disagree.

Re: Automatically compress File Geodabases

JoeBorgione — Thu, 10 Dec 2020 15:26:50 GMT

I'm pretty sure I've never compressed a fgdb. when I read about it in help page, I got the impression that it's a one and done operation. Compressing an Egdb is an ongoing maintenance operation and I've written and executed scripts for those.

Re: Automatically compress File Geodabases

Robert_LeClair — Thu, 10 Dec 2020 16:03:36 GMT

Mark - I think what you're looking for is Compact (Data Management) to reduce file size on disk. This keeps the contents still editable whereas Compress File Geodatabase makes the contents read-only.

Re: Automatically compress File Geodabases

JoeBorgione — Thu, 10 Dec 2020 16:12:05 GMT

From the compact help page:

swap out the following in my code:

#replace: arcpy.CompressFileGeodatabaseData_management(fgdb) #with arcpy.Compact_management(fgdb)

That should do the trick for you....

Re: Automatically compress File Geodabases

MarkVolz — Mon, 14 Dec 2020 16:37:48 GMT

This and Joe's code worked.

Please note that there is a difference between arcpy.Compact_management(workspace), and arcpy.CompressFileGeodatabaseData_management(workspace). The latter of which will zip up the files.

Thank You!