topic Re: arcmap drawing errors in ArcGIS for Office Questions

arcmap drawing errors

RobertMitchell — Tue, 17 Sep 2019 09:06:57 GMT

I keep getting the same error message appear:

"One or more layers failed to draw:

[File Name].csv Events: An invalid SQL statement was used."

I have noticed that this happens when I zoom in and not all coordinates are visible on the map.

For context I am using basemaps with XY coordinates inputted. These have been saved in a CSV file with 8 decimal points and 'Number' for type in Excel selected.

Please see images below for demonstration of the problem.

Any help will be greatly appreciated. I have tried removing some points but this is a rather slow process and I may need them at some point.

Thank you in advance

Re: arcmap drawing errors

ShannonChavez — Thu, 26 Sep 2019 17:59:04 GMT

Good Morning Robert,

I would recommend calling in to chat with Technical Support. They can be reached at 1-888-377-4575.

Best,

Re: arcmap drawing errors

TylerSchwartz2 — Thu, 26 Sep 2019 19:04:45 GMT

Try exporting your events layer as a feature class (a good practice to follow anytime you add X,Y data). Events layers are very limited and my practice is to always export them before running any type of analysis.

Re: arcmap drawing errors

RobertMitchell — Sun, 06 Oct 2019 04:35:17 GMT

Thank you so much! This worked perfectly. I must have missed a step when inputting the data previously!