[GIS] Exporting ArcSDE feature classes into file geodatabase with ArcPy

arcpyexportfeature-class

I would like to use Windows task scheduler to automatically (monthly) create a new file geodatabase and then export feature classes from SDE into the new file geodatabase. Im using this code, however I get an exucute error that states that the geodatabase already exists.

# Name: CreateGDB.py
# Description: Create a file GDB
# Import system modules
import arcpy
import datetime

out_folder_path = "w:/GISDATA/Database_Backups"
nowstart = datetime.datetime.now()
YearMonthDay = nowstart.strftime("%Y_%m_%d")
out_name = "TEST_WSdata_" + YearMonthDay + ".gdb"

# Execute CreateFileGDB
arcpy.CreateFileGDB_management(out_folder_path, out_name)

arcpy.env.workspace = 'C:\Users\cbgibson\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog\TEST_WSdata.sde'
# Local variables:
waterFC = ['WATERLINES', 'GRAVITY']

for fc in waterFC:
# Process: Feature Class to Geodatabase (multiple)
    arcpy.FeatureClassToGeodatabase_conversion(fc, out_name)

Best Answer

I worked through the problem and found a solution. I also revised the code to copy ALL feature classes in the WATER dataset, instead of listing each one individually.

# Name: BackupGDB.py
# Description: Create a file GDB

# Import system modules
import arcpy
from arcpy import env # WAS MISSING IN ORIGINAL POST
import datetime

out_folder_path = "w:/GISDATA/Database_Backups"
nowstart = datetime.datetime.now()
YearMonthDay = nowstart.strftime("%Y_%m_%d")
out_name = "TEST_WSdata_" + YearMonthDay + ".gdb"

# Execute CreateFileGDB
arcpy.CreateFileGDB_management(out_folder_path, out_name)


# Set environment settings
env.workspace = "C:\Users\cbgibson\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog\TEST_WSdata.sde"

# Set local variables
waterFC = arcpy.ListFeatureClasses("", "", "WATER") #CHANGED TO INCLUDE ALL FEATURE CLASSES IN THE WATER DATASET
outLocation = "w:/GISDATA/Database_Backups/" +"TEST_WSdata_" + YearMonthDay + ".gdb" 

# Execute TableToGeodatabase
for fc in waterFC:
    arcpy.FeatureClassToGeodatabase_conversion(fc, outLocation)

Related Solutions

[GIS] Creating report of all feature classes in geodatabase using ArcPy

Make sure the directory C:\tmp exists. If it does not, your third call will fail. I normally use unicode and double slashes for my workspaces.

u"J:\\restored-20101025\\basemaps\\ALTA\\FileGeodatabase\\GEOBASE_GIS_DATA.gdb"

But the big problem is that your logfile.close() is inside your for loop. That needs to be outside the for loop, or else you will close the logfile after the first featureclass name is written. You also have a typo in your variable assignment for fcLst.

import arcpy, os
arcpy.env.workspace = u"J:\\restored-20101025\\basemaps\\ALTA\\FileGeodatabase\\GEOBASE_GIS_DATA.gdb"
if os.path.exists(arcpy.env.workspace):
    if not os.path.isdir(r"C:\tmp"):
        os.mkdir(r"C:\tmp")
    logfile = open(r"C:\tmp\log.txt", "w")
    fcList = arcpy.ListFeatureClasses()
    dsList = arcpy.ListDatasets()
    for fc in fcList:
        logfile.write(fc+"\n")
    for ds in dsList:
        fcList = arcpy.ListFeatureClasses("","All",ds)
        for fc in fcList:
            logfile.write(fc+"\n")
    logfile.close() 
else:
    print("Workspace does not exist.")

[GIS] Exporting lists of Feature classes and fields from SDE

Here's an example you can reference. It prints the results to both the console and to a text file, but you could easily manipulate it to write to a .csv file.

Hope this helps.

-ST

Results :

Feature Class Name : CR.CANADA1  
Geometry Type      : Polygon  
Has Spatial Index  : True  
Spatial Reference  : GCS_North_American_1927
  Field Name : CR.CANADA1.AREA       Field Type : Double            Field Length : 8
  Field Name : CODE                  Field Type : String            Field Length : 4
  Field Name : NAME                  Field Type : String            Field Length : 25
  Field Name : POP1991               Field Type : Double            Field Length : 8
  Field Name : POP91_SQMI            Field Type : Double            Field Length : 8
  Field Name : SHAPE                 Field Type : Geometry          Field Length : 4
  Field Name : SHAPE.AREA            Field Type : Double            Field Length : 0
  Field Name : SHAPE.LEN             Field Type : Double            Field Length : 0
  Field Name : SHAPE.FID             Field Type : OID               Field Length : 0
# of Fields in Feature Class 'CR.CANADA1' = 9

CODE :

import arcpy

logfile = open(r'C:\TEMP\ListFCs_ListFieldNames_ListFieldTypes.log', 'w')

def log_results(message):
    print(message)
    logfile.write(message)
    logfile.flush()
    return

def main():
    try:
        wk = arcpy.env.workspace = 'Database Connections/ORCL - SDE@SRVRNAME.sde'
        fcList = arcpy.ListFeatureClasses("*")
        fcList.sort()

        if not arcpy.Exists(wk):
            log_results("\n" + " SDE Connection File DOES NOT EXIST!!\n")
        else:
            fcCnt = 0
            fldCnt = 0

            for fc in fcList:
                fcCnt += 1
                desc = arcpy.Describe(fc)
                log_results ("\n Feature Class Name : {0}  \n Geometry Type      : {1}  \n Has Spatial Index  : {2}  \n Spatial Reference  : {3}".format(fc,desc.shapeType,str(desc.hasSpatialIndex),desc.spatialReference.name))
                #field = [f.name for f in arcpy.ListFields(fc)]
                fields = arcpy.ListFields(fc)
                fldCnt = 0
                for field in fields:
                    log_results ("\n    Field Name : {0: <24}  Field Type : {1: <20}  Field Length : {2}".format(field.name, field.type, field.length))
                    fldCnt += 1
                log_results ("\n # of Fields in Feature Class '{0}' = {1} \n".format(fc, fldCnt))

        log_results ("\n TOTAL # OF FEATURE CLASSES LISTED = {0}".format(fcCnt))
        log_results ("\n\n COMPLETED!! \n")

        logfile.close()

    except arcpy.ExecuteError:
        log_results (arcpy.GetMessages(2))

    except Exception as e:
        log_results (e[0])

if __name__ == '__main__':
    main()

Best Answer

Related Solutions

[GIS] Creating report of all feature classes in geodatabase using ArcPy

[GIS] Exporting lists of Feature classes and fields from SDE

Related Question