topic Re: XY Table to FeatureClass in Geoprocessing Questions

XY Table to FeatureClass

adamwade1 — Wed, 20 May 2020 01:28:23 GMT

Has anyone figured out a slick way to convert a table with X and Y coordinate values, along with other attributes, to a featureclass in arcpy outside of ArcGIS Desktop like in Spyder or Pycharm?

Roland Vigor from the USGS documented a nice way of converting a pandas dataframe to an arcgis table. I'd like to do something like that only one step further to make a featureclass.

I can use the Make XY Event Layer tool and display the points in Arc and then export those values to a feature class. However, I have dozens of files I need to filter in pandas and then convert to feature classes. So doing it outside of ArcMap using arcpy would be the best process.

I've seen a lot of requests for such a process but have yet to find something that works outside of ArcMap. Any help is much appreciated.

Cheers!

-Adam

Re: XY Table to FeatureClass

JoeBorgione — Wed, 20 May 2020 01:38:49 GMT

When you say 'outside of arcmap' what specifically do you mean? You can do plenty of data table formatting with python, pandas or numpy. But at the end of the day to create a an ESRI feature class, you are going to deploy arcpy.

Re: XY Table to FeatureClass

DanPatterson — Wed, 20 May 2020 02:10:12 GMT

NumPyArrayToTable—Data Access module | Documentation if you have arrays already

or you can read xy-whatever data like text files and spreadsheets using python, numpy or pandas,

then

NumPyArrayToFeatureClass—Data Access module | Documentation

works for point data easily, but you need some magic with arcpy to get poly* features.

Re: XY Table to FeatureClass

adamwade1 — Wed, 20 May 2020 03:10:36 GMT

Hi Joe,

Yes, a user can call arcpy functions in other python environments like Spyder and Pycharm. I like to code in Spyder and automate several arcpy functions using hundreds somethings thousands of separate datasets. For this particular project I had to filter dozens of datasets with geospatial info including XY coordinate values and am trying to covert them to point feature classes for use in ArcMap.

Re: XY Table to FeatureClass

adamwade1 — Wed, 20 May 2020 03:13:53 GMT

Thanks Dan. I think the NumPyArrayToFeatureClass tool would work but it looks like it only runs in ArcGIS Pro and unfortunately I'm running ArcGIS Desktop.

Re: XY Table to FeatureClass

DanPatterson — Wed, 20 May 2020 03:22:55 GMT

it exists in ArcMap as well

NumPyArrayToFeatureClass—Help | Documentation

Re: XY Table to FeatureClass

adamwade1 — Wed, 20 May 2020 03:46:18 GMT

Thanks Dan! That totally worked!

Cheers!

-Adam

Re: XY Table to FeatureClass

CPoynter — Wed, 20 May 2020 03:48:44 GMT

Hi Adam,

An alternative method: ArcPy | Geospatiality

Regards,

Craig