topic Using CSV with XY Location Mode in ArcGIS Earth Questions

Using CSV with XY Location Mode

GeoffroyRicher-Lalonde — Fri, 12 Apr 2024 13:59:16 GMT

Hello, me again 😅

Importing a CSV with the XY Location Mode, the process will fail if the columns used for X or Y coordinates are named with a special character or a space.

The columns do get new (special-character-free) names in the "attributeFields" section of the JSON, but the "xFieldName" and "yFieldName" still use the original problematic names.

Thank you !

Re: Using CSV with XY Location Mode

YujingChang — Mon, 15 Apr 2024 03:03:57 GMT

Thank you very much for notifying us of this issue. We would like to investigate this further to provide a prompt and accurate resolution. Could you kindly provide us with some sample CSV data that exhibits the problem? This will greatly assist our technical team in their debugging efforts.

We truly appreciate your assistance and patience as we work to enhance our application.

Best，
Yujing

Re: Using CSV with XY Location Mode

GeoffroyRicher-Lalonde — Mon, 15 Apr 2024 17:07:09 GMT

Hello @YujingChang. Of course, here is some sample CSV data.

If you use WorkingX and WorkingY for X and Y coordinates, it will work because these attribute names do not contain spaces or special characters.
Broken X and Broken Y won't work because of the spaces in the names.
Broken(X) and Broken(Y) won't work because of the parentheses in the names.

Note that any attribute that is not used for X and Y coordinates can contain spaces or special characters.

Re: Using CSV with XY Location Mode

YujingChang — Fri, 19 Apr 2024 08:08:29 GMT

Thank you for providing the details and data. This enhancement will be included in the upcoming 2.2 release, scheduled for mid-May. We invite you to use and enjoy the improved user experience.