topic Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro. in ArcGIS Pro Questions

Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro.

JayHodny — Mon, 31 Jul 2017 17:36:59 GMT

Hi. I have a .csv file which contains street camera attribute information, including latitudes (Y) and longitude (X) for each camera location. This would be a point feature class. I can Add Data, and bring in the CSV file as a standalone table. However, when I right-click on the CSV file, click on Display XY Data, which brings up the Make XY Event Layer, I get this error - "Error 000055: Cannot create a Query Table for this workspace......." when I run the GP tool. I have not seen this error before. I know I have used this workflow in the past without any issues. If this cannot be resolved quickly, I will have to find a work around. Thank you.

Re: Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro.

DanPatterson_Retired — Mon, 31 Jul 2017 17:41:34 GMT

could be barking at the filename... it has spaces and a -

Re: Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro.

JayHodny — Mon, 31 Jul 2017 17:51:20 GMT

Thank you. I removed all spaces and the '-' and shortened the csv file name. Error persists.

Re: Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro.

JayHodny — Mon, 31 Jul 2017 18:04:07 GMT

Hi Dan. I checked the formatting of the lats and longs, and there were a half a dozen or so coordinate pairs that were suspect. After I cleaned them up, I was able to create the XY layer. Thank you for your help. Jay

Re: Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro.

JayantaPoddar — Mon, 31 Jul 2017 18:07:08 GMT

Ensure the structure of the data is fine in the CSV file. Could you attach a sample of the CSV file, so that we could check for any issue in it?

Re: Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro.

JayHodny — Mon, 31 Jul 2017 18:11:40 GMT

Hi Jayanta, I found some coordinate pairs in the csv that were suspect and corrected them. I was then able to create an XY event layer, and performed a 'Data Export Features' on the temporary event layer, and was able to create a feature class in my gdb. I think I am back on track. Many thanks! Jay

Re: Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro.

RobertHadsell — Fri, 01 Jun 2018 15:45:50 GMT

I ran into this same issue this morning. After month's of running smoothly, one of my python scripts failed with the following Error Code:

ERROR 000055: Cannot create a Query Table for this workspace
Failed to execute (MakeXYEventLayer).

The problem ended up being the data type of the lat long fields in my table. They were of the 'Text' Data type rather than a Double...once corrected, the tool worked! It was very strange, I tried to run the Make XY Event Layer tool manually with the table and ArcGIS Pro automatically populated the X and Y fields for me with the correct fields (but of the wrong data type). Not sure why it took in a text parameter if the tool doesn't allow text for the inputs...

Solution was to change my schema.ini file to bring these fields in as Double and that fixed everything.

Esri may need to consider making that a restriction on the inputs to only accept numeric data types for these parameters in the tools GUI and consider altering the error code to be more data type specific rather than workspace specific. I spent a good part of an hour chasing down a workspace issue when it ended up being a simple data type conversion. Hope this helps!

Thanks,

Robert

Re: Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro.

AdrianWelsh — Fri, 01 Jun 2018 16:23:55 GMT

Robert,

Why were you fields coming in as text? Are there text values in the CSV? I find that, in a raw CSV, if I only have decimal values, the CSV is read in as a double.

Re: Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro.

RobertHadsell — Fri, 01 Jun 2018 16:27:51 GMT

Hello Adrian,

I'm not 100% sure why they were coming in as text. My original schema.ini file didn't include these fields, so I assume that was the issue. I made the change in the ini file and the fields come in as double now...The table I am working with has ~35 fields with text, date, and numeric data types. It's possible Arc wasn't sure how to read each field from the CSV.

Thanks,

Robert

Re: Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro.

mrmark — Wed, 06 Jun 2018 00:36:10 GMT

Robert - thanks for the fix.

My table appeared fine as a CSV, but was giving me this error, so I read the help for Error 000055 which tells me:

Creating a query table is not supported for the specified workspace. Query tables can only be created using data from a geodatabase or an OLE DB connection.

And the "solution" is to convert the data into one of those things. So - import it into a Geodatabase Table. No complaints. XY Event Layer creation fails again, still with Error 000055.

Anyway - like you, I don't know why the Longitude column was a double, but the Latitude was a Text field. Schema to force that column as Double and it all works just fine.

Re: Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro.

JacobSteiner — Mon, 18 Jun 2018 05:52:11 GMT

Robert, thanks! On a rather large table with XY data, when attempting to Make an XY Event Layer, ArcGIS Pro misidentified data types for me as well. There was no apparent in application way to correct. After directly editing the schema.ini to reflect actual data types, I was able to process the table of interest.

That dataset of interest was from GeoNames, it was the allCountries.zip, but the same is true for individual country tables as well.

Re: Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro.

MaxSquires — Thu, 13 Aug 2020 11:43:19 GMT

You could also look at the schema.ini file (hidden in windows) that is alongside the csv file you are dealing with.

this file allows the configuration of the column data type. For instance, i kept getting an error "Invalid Field Type" when calling arcpy.management.XYTableToPoint

the schema.ini file had listed the data type as a string for both columns.

line indicated by -1 shows the original results (when Col1=Longitude Text)

line indicated by -2 shows the results after updating the Latitude and Longitude columns.

note:

double quotes are only used to escape otherwise used column delimiters. i.e. if you have a comma in the column value, you will need to "double quote" it so that it doesn't create an additional column for that row.

Re: Unable to 'Display XY Data' and 'Make XY Event Layer' from csv file in ArcGIS Pro.

BryanVallejo — Mon, 21 Dec 2020 13:15:16 GMT

I had the same problem I just want to share my solution.
When I was running the tool MakeXYEvent, I notice that the column Lat and Long are read as Text datatype. But, automatically my Arcgispro creates a new column automatically named Lat_D and Long_D as Double datatype.
So, in the code I just used these new column names. I did not nothing else and now works ok.
Thanks for the comments here everythings helped me to solved it.