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

Tool for generating Feature Class including field names/type...

TravisLathrop1

I am trying to build a tool that will generate a feature class and then populate the fields with the correct column name and format based off a Excel file. Has anyone had any luck doing this before? I'm looking for model or code examples if anyone happens to have anything similar. Has anyone seen any tutoria documents online that do this type of request? That could help also.

Thanks in advance!

Find more posts tagged with

Accepted answers

All comments

DarrenWiens2

Hmmm. Is this in the right place?

AlexZhuk

I created a small/quick/convenient model for myself.

----

TravisLathrop1

Darren-I've had more time to digest this and I had some simply syntax errors on the front end. After I got those resolved it crashed out on me at the second to last line. Any ideas on what i might change?

DarrenWiens2

Step 1: convert Excel to CSV file. If you don't want to do that, you can work with Excel directly, but it's more complicated.

Step 2: run Python script. This will probably take some time to digest. Comments follow '#' (leave in or delete. They will be ignored).

import arcpy, csv, os

fc = r'C:/junk/FILE_GDB.gdb/newEmptyFC' # point to where you want your FC
if arcpy.Exists(fc):
    arcpy.Delete_management(fc) # delete FC if it exists
arcpy.CreateFeatureclass_management(os.path.dirname(fc),
                                    os.path.basename(fc)) # create FC

fieldtypes = {  'char':'TEXT',
                'inte':'LONG'} # dictionary to translate from your listed data types to ArcGIS data types. You'll have to add more.

with open(r'C:/junk/excel_test.csv', 'rb') as csvfile: # open CSV file
    reader = csv.reader(csvfile, dialect='excel') # make a CSV reader
    headers = reader.next() # skip header row
    for row in reader: # read through rows
        if row[0] <> 'OBJECTID': # don't create OID field. Will be created automatically
            print fieldtypes[row[1][:4]] # convince yourself that it is using the dictionary properly
            arcpy.AddField_management(fc, row[0], fieldtypes[row[1][:4]]) # create field of appropriate data type, based on first 4 characters in CSV file

TravisLathrop1

Thanks for the follow up Darren.

I have no code to share as I've been working in model builder. If you think the python route is the way to go I'm all ears. Here is what my Excel file looks like. I want column A to represent the fields in the new feature class and the values in column B should the the field type. Is this doable?

DarrenWiens2

This is certainly possible using Python. If you want to go in that direction, please post your starting script, or at least your Excel file as an example.

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.