topic Re: XYTableToPoint not working - no results in ArcGIS Pro Questions

XYTableToPoint not working - no results

JinseoYoon — Tue, 04 May 2021 06:44:44 GMT

Hi,

I am using Arcgis pro notebook for geocoding XY coordinations. While I can do it with "Display XY data" function (by right clicking the layer in the content panel), I cannot do it with a very simple code in the notebook.

The code and output are copied here.

Nothing has been created, either the table or the point shape file.

Can anyone help? Thank you very much in advance.

------ code ---------

arcpy.env.workspace = r"c:\WORK\GIS\OUTPUT.gdb"

# Set the local variables

in_folder = r"c:\WORK\GIS\PED_MOVE\flow_age_ymd_202006_sample.csv"

x_coords = "X_COORD"

y_coords = "Y_COORD"

z_coords = ""

out_fc = "flow_age_ymd_202006_sample"

arcpy.management.XYTableToPoint(in_folder, out_fc, x_coords, y_coords, z_coords, arcpy.SpatialReference("Korea Geodetic Datum 2000"))

----------------

Output

c:\WORK\GIS\OUTPUT.gdb\flow_age_ymd_202006_sample

Messages

Start Time: XXX
WARNING 100160: Some of the features have invalid geometry and have been removed from the result
WARNING 000192: Invalid value for rows: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49
Succeeded at XXX (Elapsed Time: 1.79 seconds)

Re: XYTableToPoint not working - no results

DanPatterson — Tue, 04 May 2021 09:01:17 GMT

Drop the z values a "" is not a valid value for a z coordinate

Re: XYTableToPoint not working - no results

JinseoYoon — Tue, 04 May 2021 09:52:49 GMT

Dear DanPatterson,

Thanks a lot for your suggestion!!

I've tried to remove the z_coord specification (z_coords = ""), and modified the function as below.

arcpy.management.XYTableToPoint(in_folder, out_fc, x_coords, y_coords, arcpy.SpatialReference("Korea Geodetic Datum 2000"))

but it does not work,, the message that I've got was as below.

ExecuteError: ERROR 000622: Failed to execute (XY Table To Point). Parameters are not valid.
ERROR 000623: Invalid value type for parameter z_field.

Would you please advise?

Re: XYTableToPoint not working - no results

DanPatterson — Tue, 04 May 2021 12:00:04 GMT

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

These are the parameters in order, you haven't provided a proper output_feature_class name and you just done drop a parameter you should use named parameters rather than relying positional parameters

arcpy.management.XYTableToPoint(in_table, out_feature_class, x_field, y_field, {z_field}, {coordinate_system})

arcpy.management.XYTableToPoint( in_table = ?, out_feature_class = ?, x_field = ?, y_field = ?, coordinate_system = ?)

Re: XYTableToPoint not working - no results

DavidPike — Tue, 04 May 2021 12:00:14 GMT

Maybe try arcpy.SpatialReference(4737)

Re: XYTableToPoint not working - no results

JinseoYoon — Thu, 06 May 2021 02:42:11 GMT

Thank you again for your advice.

Indeed I've done everything that you have suggested.

in_table = r"D:\XXX\XXX.csv"

x_field = "X_COORD"

y_field = "Y_COORD"

out_feature_class = "flow_age_sample"

arcpy.management.XYTableToPoint(in_table, out_feature_class, x_field, y_field, arcpy.SpatialReference("Korea Geodetic Datum 2000"))

the z-field seems optional, but it seems still needed. Would you advise one more time? Thank you very much for your patients.

ExecuteError: ERROR 000622: Failed to execute (XY Table To Point). Parameters are not valid.
ERROR 000623: Invalid value type for parameter z_field

Re: XYTableToPoint not working - no results

JinseoYoon — Thu, 06 May 2021 02:43:57 GMT

Thank you very much, but it seems the problem occurred due to the z-field specification.

I do not have a z-value field and the function still needs one.

ExecuteError: ERROR 000622: Failed to execute (XY Table To Point). Parameters are not valid.
ERROR 000623: Invalid value type for parameter z_field.

Re: XYTableToPoint not working - no results

DanPatterson — Thu, 06 May 2021 08:36:10 GMT

tbl = r"D:\XXX\XXX.csv" x_fld = "X_COORD" y_fld= "Y_COORD" out_fc = "flow_age_sample" coord = arcpy.SpatialReference("Korea Geodetic Datum 2000") arcpy.management.XYTableToPoint( in_table=tbl, out_feature_class=out_fc, x_field=x_fld, y_field=y_fld, coordinate_system=coord)

They were invalid because you dropped a position argument. Use named arguments to guarantee they are correct and have values, or provide an appropriate null value for ones you are skipping

Re: XYTableToPoint not working - no results

JinseoYoon — Thu, 06 May 2021 21:14:11 GMT

Thank you very much, but it still does not work. I followed your suggestion and the results are the same. The position argument dos not seem necessary, and the z-value can be just omitted since it is only an optional.

Re: XYTableToPoint not working - no results

JinseoYoon — Thu, 06 May 2021 21:14:31 GMT

arcpy.management.XYTableToPoint(
in_table = in_folder,
out_feature_class = out_fc,
x_field = x_coords,
y_field = y_coords,
coordinate_system = coord)

Re: XYTableToPoint not working - no results

JinseoYoon — Thu, 06 May 2021 21:14:47 GMT

Messages

Start Time: 2021년 5월 7일 금요일 오전 5:58:25
WARNING 100160: Some of the features have invalid geometry and have been removed from the result
WARNING 000192: Invalid value for rows: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49

Re: XYTableToPoint not working - no results

DanPatterson — Thu, 06 May 2021 21:17:57 GMT

That leaves issues with your csv, assuming that you have 49 point features, it seems they are all wrong or not properly formatted as a *.csv file.

Perhaps posting a few sample lines of the file might help

A, B, C

1, 2, 3

4, 5, 6

....

for instance

Re: XYTableToPoint not working - no results

JinseoYoon — Mon, 10 May 2021 06:27:54 GMT

Thank you and sorry for the late response.

I thought that too, but with this data, the xy point shape file could be successfully made with the "Display XY Data" tool by simply right clicking the table in the content panel.

I attach the file here, would you please take a look? It would be very much appreciated. Thank you very much!

Re: XYTableToPoint not working - no results

DanPatterson — Mon, 10 May 2021 11:39:12 GMT

The coordinates are in a projected coordinate system.

I had to use another one for Korea, so the results may not be correct.

Yours isn't listed in the available projected coordinates for Korea.

Here is what I got with what I used.

Back to you to figure out what to use, to make the error go away.

Re: XYTableToPoint not working - no results

JinseoYoon — Mon, 10 May 2021 21:46:28 GMT

Thank you very much!! The problem was in the coordination system as you pointed out. Thank you for making this work!!! I really appreciate it!!!

Re: XYTableToPoint not working - no results

DanPatterson — Mon, 10 May 2021 22:13:09 GMT

No problem...

Re: XYTableToPoint not working - no results

AlessioRadice — Wed, 12 Jan 2022 11:28:21 GMT

Sorry to crash into a solved issue but I have the same problem trying to display XY data from a table provided (as .txt, as .csv, as .xlsx, I tried different ways)

Data are in European Datum 1950 reference system.

I do not really figure out what is going wrong.

I also point out that, for another project, I could successfully do it some time ago. Then, today I tried to redo the same command and got the same warning message.

Many thanks, alessio

Re: XYTableToPoint not working - no results

AlessioRadice — Fri, 14 Jan 2022 08:05:28 GMT

Sorry to crash into a solved issue but I have the same problem trying to display XY data from a table provided (as .txt, as .csv, as .xlsx, I tried different ways)

Data are in European Datum 1950 reference system.

I do not really figure out what is going wrong.

I also point out that, for another project, I could successfully do it some time ago. Then, today I tried to redo the same command and got the same warning message.

Many thanks, alessio

sponda_dx.txt

98 KB

sponda_dx.xlsx

93 KB

sponda_dx.csv

98 KB

Re: XYTableToPoint not working - no results

JoaoPinto — Thu, 27 Jan 2022 17:06:36 GMT

Hi DanPatterson!

I have the same problem.

My points maybe projected in ETRS89.

Initially I thought there was conflict with the esri basemap coordinate system.

But the same errors appear as JinseoYoon.

I attach my csv.

Thanks