topic Re: Copy attribute table fields from one shapefile to another in New to GIS Questions

Copy attribute table fields from one shapefile to another

KeithAddison1 — Wed, 09 Sep 2015 20:04:33 GMT

I have about 20 shapefiles that all need to have the same attribute table fields. I have the attribute table fields all setup the way I want for one of the shapefiles. I want to copy this attribute table setup over to the other shapefiles. The entries of the tables are all empty for now, I just want to use the same columns/fields for all the shapefiles. How can I copy the attribute table into the remaining shapefiles? Using ArcInfo 10.0

Re: Copy attribute table fields from one shapefile to another

WesMiller — Wed, 09 Sep 2015 20:07:21 GMT

Do you have a common field that you can use to to join the two feature classes or are you going to need to do a spatial join to link the data?

Re: Copy attribute table fields from one shapefile to another

KeithAddison1 — Wed, 09 Sep 2015 20:17:18 GMT

The only field they all have in common is SHAPE (all polygons), can I use that for a join?

Re: Copy attribute table fields from one shapefile to another

IanMurray — Wed, 09 Sep 2015 20:18:41 GMT

If you are comfortable with python, you could make a list of all the fields of the one (template) shapefile you have set-up, then loop through each other shapefile and add a field for each field that exists in the template shapefile.

If this is the way you want to go about it and you need help with this, I can get you some code to use to manage this process.

Re: Copy attribute table fields from one shapefile to another

DarrenWiens2 — Wed, 09 Sep 2015 20:19:58 GMT

You could:

1.) Copy your template shapefile

2.) Append the features from one of 20 shapefiles to the copy (Schema type = NO_TEST)

...and repeat.

Re: Copy attribute table fields from one shapefile to another

WesMiller — Wed, 09 Sep 2015 20:54:41 GMT

If you use a spatial join the fields from both feature classes would be present in a new feature class, but i don't think that will do what you are after. i miss read your question sorry. I would suggest using model builder set it up for each of the fields you want to add on one feature class and let it run then change the feature class to another and run it again until you get all 20

Re: Copy attribute table fields from one shapefile to another

KeithAddison1 — Wed, 09 Sep 2015 21:02:18 GMT

I figured out a workaround by merging all the shapefiles together then setting up the attribute table & breaking each feature back out into its individual shapefile. Not ideal but takes less time than entering each field for all 20 shapefiles. Can't believe I didn't think of that sooner, I guess that's because I assumed there would be an easy way to copy/paste attribute table templates.

I am learning Python so I would be interested in seeing code to do this for some arbitrary field names, say: A, B & C. It could also come in handy if I run into this situation again for a great many shapefiles and I can't come up with a workaround.

Re: Copy attribute table fields from one shapefile to another

IanMurray — Sat, 11 Dec 2021 09:29:08 GMT

This is far from an ideal solution, since I am uncomfortable with dictionaries, I make a list of lists that contain the attributes for existings fields using the arcpy module. In the below example, your "template" shapefile needs to be in a seperate directory from the rest, since this script does not check to see if a field already exists. If your other shapefiles were in multiple directories or subdirectories, we would need to use the os module walk function, or arcpy.da.Walk to create the list of shapes.

I do not have data to test on at the moment, so this is untested and I can't show the output.

#importing Modules
import arcpy
#Creating variable for template file path
template_shp = "FilePathtoShp"
#Making a list of Field Objects
fields = arcpy.ListFields(template_shp)
#Creating empty list to append field attribute list to
allfields = []
#Looping through field objects
for field in fields:
    #Creating empty list to append field attributes to
    field_attributes = []
    #Appending all relevant field object elements as strings to list
    field_attributes.append(field.name , field.type , field.precision , field.scale, field.length, field.aliasName , field.isNullable , field.required)
    #Appending list of field elements to new field list
    allfields.append(field_attributes)
#Setting workspace
arcpy.env.workspace = "directoryofshapefiles"
#Creating List of FeatureClasses in workspace
shapes = arcpy.ListFeatureClasses()
#Looping through each shape
for shape in shapes:
    #Looping through each field 
    for field in allfields:
        #Adding field based on field attributes of original field
        arcpy.AddField_management(shape , field[0] , field[1] , field[2], field[3], field[4] , field[5], field[6] , field[7])

I'm sure someone more proficient with python could show a better way.

Re: Copy attribute table fields from one shapefile to another

DarrenWiens2 — Sat, 11 Dec 2021 09:29:11 GMT

For what it's worth, running the built-in feature class level tools (Copy, then Append) seems to work about twice as fast as adding fields individually. See below where Test A uses feature class level tools and Test B uses field level tools (I believe these are comparing apples to apples, but I could be wrong). For small feature classes, the differences are pretty small, but for large datasets, the time difference could be considerable. I'd say the code is somewhat simpler, as well.

import arcpy, time

# Set up shared conditions
arcpy.env.workspace = r'C:\junk\new_fields'
arcpy.env.overwriteOutput = True
template = 'template.shp' # the template FC
fcs = arcpy.ListFeatureClasses('*Copy*') # the "other" FCs

#############################################

# Test A
starttime1 = time.time()

outCounter = 1
for fc in fcs:
    newCopy = "output_" + str(outCounter) + '.shp'
    arcpy.Copy_management(template, newCopy)
    arcpy.Append_management(fc, newCopy, 'NO_TEST')
    outCounter += 1

endtime1 = time.time() - starttime1
print 'Total time: ' + str(endtime1) +'s' # about 3.5 seconds

############################################

# Test B
starttime2 = time.time()

fields = arcpy.ListFields(template)
allfields = []
for field in fields:
    if field.name != 'FID' and field.name != 'Shape':
        allfields.append([field.name , field.type , field.precision , field.scale, field.length, field.aliasName , field.isNullable , field.required])
for shape in fcs:
    for field in allfields:
        arcpy.AddField_management(shape , field[0] , field[1] , field[2], field[3], field[4] , field[5], field[6] , field[7])

endtime2 = time.time() - starttime2
print 'Total time: ' + str(endtime2) +'s' # about 7 seconds

Re: Copy attribute table fields from one shapefile to another

KeithAddison1 — Mon, 14 Sep 2015 20:05:30 GMT

What exactly does the Test A code output to? I put in the template shapefile and workspace path I want to use in place of template.shp, and add print newCopy to the end and it tells me newCopy is not defined, there's no new shapefile in the workspace, or anywhere else on the C drive. The rest of the code runs fine, I just can figure out where its sending the results.

Re: Copy attribute table fields from one shapefile to another

DarrenWiens2 — Mon, 14 Sep 2015 20:33:08 GMT

For me, it output new files to:

C:\junk\new_fields\output_1.shp

C:\junk\new_fields\output_2.shp

C:\junk\new_fields\output_3.shp

C:\junk\new_fields\output_4.shp

C:\junk\new_fields\output_5.shp

Re: Copy attribute table fields from one shapefile to another

KeithAddison1 — Mon, 14 Sep 2015 21:02:44 GMT

Well this is baffling, here is the code I run:

import arcpy, time

arcpy.env.workspace = r'C:\Users\keith.addison\Documents\PythonStuff'

arcpy.env.overwriteOutput = True

template = 'ParcelDataAC150.shp'

fcs = arcpy.ListFeatureClasses('*Copy*')

starttime1 = time.time()

outCounter = 1

for fc in fcs:

newCopy = "output_" + str(outCounter) + '.shp'

arcpy.Copy_management(template, newCopy)

arcpy.Append_management(fc, newCopy, 'NO_TEST')

outCounter += 1

endtime1 = time.time() - starttime1

print 'Total time: ' + str(endtime1) +'s'

And it doesn't create any new shapefiles in the working directory or anywhere else, it also outputs the run time as 0.0s. I've tried running it with several different template shapefiles with varying populated and unpopulated field setups to no avail.

Re: Copy attribute table fields from one shapefile to another

DarrenWiens2 — Mon, 14 Sep 2015 21:22:41 GMT

You've got your template and "other" shapefiles. In my example, my "other" shapefiles happened to have the word "Copy" in their file names. Do yours? The line fcs = arcpy.ListFeatureClasses('*Copy*') means find the feature classes with the word "Copy" in the file name. Do you have any such shapefiles?

Re: Copy attribute table fields from one shapefile to another

KeithAddison1 — Tue, 15 Sep 2015 17:46:24 GMT

That was it, thanks! Sorry about that, I'm still figuring out Python syntax.