topic Re: Feature class to Feature class using python in Python Questions

Feature class to Feature class using python

RyanKammerer1 — Thu, 09 Jul 2015 21:07:49 GMT

I have a feature class that has several sql db tables joined to it. It's been my workflow to update values in these tables, and then export the joined feature class over to sde GDB to use for published map services. I'm trying to automate this step using python. Is there a way in Python to open a map document (with the feature class and joined tables), select the feature class and export the feature class to a Geodatabase? Any help would be much appreciated.

Thank you

Re: Feature class to Feature class using python

SamuelTompsett — Thu, 09 Jul 2015 21:33:50 GMT

Hi Ryan,

I'm not positive about the join, but you can open a mxd with python using the arcpy.mapping module. It has access to the table of contents, so I would imagine the join would be active while open in python.

ArcGIS Help 10.1

-Sam

Re: Feature class to Feature class using python

DarrenWiens2 — Sat, 11 Dec 2021 23:36:36 GMT

Not an answer, but I believe this should have worked. It doesn't. It blanks out all the joined fields in the first layer, which has a join:

import arcpy
arcpy.env.overwriteOutput = True

mxd = arcpy.mapping.MapDocument('C:/junk/junk_map.mxd')

layers = arcpy.mapping.ListLayers(mxd)

arcpy.CopyFeatures_management(layers[0],'C:/junk/FILE_GDB.gdb/copy')

Re: Feature class to Feature class using python

SamuelTompsett — Thu, 09 Jul 2015 21:44:03 GMT

Good to know. Thanks for the reply Darren.

Re: Feature class to Feature class using python

RyanKammerer1 — Mon, 13 Jul 2015 15:27:56 GMT

Just thought I'd thank those for the feedback so far. I appreciate the suggestions and comments, but I still haven't resolved the issue. I'll keep trying.

Thank you

Re: Feature class to Feature class using python

AsrujitSengupta — Mon, 13 Jul 2015 16:32:17 GMT

I am not much into Python, however you can try creating something like this:

Basically, create a Python script which will Join the feature class to the different database tables and then Export the output of the Joins as a new Feature Class to the desired SDE geodatabase, for publishing.

Re: Feature class to Feature class using python

RyanKammerer1 — Mon, 13 Jul 2015 16:42:03 GMT

Thanks Asrujit for the suggestion. I'll give that a try.

Re: Feature class to Feature class using python

BrandonKeinath1 — Mon, 13 Jul 2015 19:56:05 GMT

Hi Ryan,

Another option you might try in python is arcpy.AddJoin. It works like Join Field but since it operates on in-memory features it works much much faster. I converted a model that used Join Field last week that took approximately 3 hours to run. Now using AddJoin it runs in 2.5 minutes.

Brandon

Re: Feature class to Feature class using python

RyanKammerer1 — Mon, 13 Jul 2015 20:46:26 GMT

Thanks for the suggestion Brandon, I'll test arcpy.AddJoin out. I have 7

tables joined to the feature class I'm trying to export to SDE and the

script has been running a good hour and a half and its still chewing on the

7th join. Thanks you for the advice!

Ryan