topic Re: Arcpy XYTableToPoint creating empty feature class in ArcGIS Pro Questions

Arcpy XYTableToPoint creating empty feature class

Scosh — Tue, 20 Aug 2024 21:18:38 GMT

Using XY Table to Point with python creates an empty feature class. I use the exact same data and settings in ArcPro and it works fine.

Things I've checked: this is the correct coordinate system and the fields are in fact populated by valid coordinates.

I think this worked fine before I upgraded to 3.3.1, but I'm not 100% sure on that.

import arcpy

lines = r'C:\Users\...\workspace.gdb\lines'
info = arcpy.da.Describe(lines)
s = info['spatialReference']
results = arcpy.management.XYTableToPoint(in_table = lines,
out_feature_class = r'memory\test_results',
x_field = 'start_x',
y_field = 'start_y',
coordinate_system = s)

Re: Arcpy XYTableToPoint creating empty feature class

Ed_ — Tue, 20 Aug 2024 21:23:22 GMT

right click on the ran instance of the tool under history and send its code to the Python Window compare that to your code and adapt accordingly if needed.

Re: Arcpy XYTableToPoint creating empty feature class

Scosh — Tue, 20 Aug 2024 21:48:22 GMT

I actually just figured it out. This took doesn't work with the feature class's path as the input. Every other tool I've used accepts the path, but not this one. And creating a feature layer from the path doesn't help either.

I had to copy the data to a memory feature class first. That's very annoying.

Re: Arcpy XYTableToPoint creating empty feature class

DanPatterson — Tue, 20 Aug 2024 22:02:50 GMT

it requires a "table view"

XY Table To Point (Data Management)—ArcGIS Pro | Documentation

Make Table View (Data Management)—ArcGIS Pro | Documentation

Re: Arcpy XYTableToPoint creating empty feature class

Scosh — Tue, 20 Aug 2024 23:23:13 GMT

That does not appear to help, at least not in Pro 3.3.1.

The only thing that is helping is using arcpy.management.CopyFeatures to convert the gdb feature class path to a memory feature class.

Also, if you don't convert it BEFORE doing a selection, then you have to convert the selection results back to a gdb feature class and then back to a memory feature class. If you just take the selection results and make a feature layer or new memory feature class, the XYTabletoPoint tool won't work (empty output). The crazy thing is the input data appears to be the same no matter what. It still has the same number of features and correct attributes. There just seems to be something mysterious hidden in the input object that the XY tool doesn't like.

Re: Arcpy XYTableToPoint creating empty feature class

DanPatterson — Wed, 21 Aug 2024 00:11:50 GMT

how are you running the script? a python window from within Pro? a Pro notebook with Pro open? a standalone script with Pro closed?

a memory featureclass is a "view" of the data which may be why it works

Re: Arcpy XYTableToPoint creating empty feature class

Scosh — Wed, 21 Aug 2024 14:21:52 GMT

I've been running it as a standalone script from IDLE.

Re: Arcpy XYTableToPoint creating empty feature class

DanPatterson — Wed, 21 Aug 2024 16:55:14 GMT

It requires a table view as suggested in my previous post, IDLE isn't connected to Pro whereas the python window is

Re: Arcpy XYTableToPoint creating empty feature class

Scosh — Tue, 27 Aug 2024 20:41:38 GMT

I don't understand what you mean. I tried creating a table view in my script and it didn't help.

Are you saying that table views don't work in IDLE, or are you just saying IDLE isn't connected to Pro, because of my comment that I was using Pro 3.3.1? I only mentioned that because I thought ArcPy got updated whenever a new version of Pro came out.