topic Re: Create Feature Class using Field name and Alias from File in ArcGIS Pro Questions

Create Feature Class using Field name and Alias from File

Paul_Duffy_Waters_of_LIFE — Thu, 15 Aug 2024 17:36:04 GMT

Hi,

I want to create a feature class from a file.

I want to be able to specify the field name and associated Alias based on the contents of the attached file.

Each new field is an Integer Type, with the field name to come from the cdLpaCode column and the associated alias from the indAlias column.

Is there a way of doing this in Python or Model Builder? I need to repeat the process for around a hundred files.

Thanks,

Paul

Re: Create Feature Class using Field name and Alias from File

DavidSolari — Thu, 15 Aug 2024 17:59:11 GMT

Here's a simple implementation that spits out a point feature class in Web Mercator and nullable long integer fields, should be easy to alter this to suit your needs

from os import path def workbook_to_fc(file_path: str, fc_path: str): excel = arcpy.conversion.ExcelToTable(file_path, "memory\\fields")[0] arcpy.management.CreateFeatureclass(*path.split(fc_path), "POINT", spatial_reference=arcpy.SpatialReference(3857)) fields = [[name, "LONG", alias, None, None, None] for _, name, alias in arcpy.da.SearchCursor(excel, "*")] arcpy.management.AddFields(fc_path, fields)

Re: Create Feature Class using Field name and Alias from File

Paul_Duffy_Waters_of_LIFE — Fri, 16 Aug 2024 08:59:57 GMT

Hi David,

Thanks for that. Unfortuntately I haven't a great deal of experience with Python yet!

If you have the time could you please indicate which elements I would need to modify?

Thanks,

Paul