topic Data does not display on the map, but present in the attribute table in Transportation Questions

Data does not display on the map, but present in the attribute table

Michigan_StateUniversity — Sun, 08 Jul 2018 14:47:45 GMT

I am facing issues with geocoding point features from an excel sheet that contains the X and Y coordinates. I am successfully able to create the event layer from the spreadsheet. However, whenever I am trying to save the event layer (that is temporarily created while geocoding the points) as a shapefile, it does not display on the map. However, the attribute table shows that the data has correctly been exported to the shapefile. If it is so, then why am I not able to see the points in shapefile on the map? Please help. Thanks!

Re: Data does not display on the map, but present in the attribute table

JoshuaBixby — Sun, 08 Jul 2018 16:27:18 GMT

Could it be a projection issue where the points exist they just aren't in the extent you are looking at?

Re: Data does not display on the map, but present in the attribute table

Michigan_StateUniversity — Sun, 08 Jul 2018 16:34:29 GMT

I do not think so. I tried with zoom to layer. Also, when the events layer gets created, the points are shown in the map, but there is no data in the attribute table. It is just the opposite to the shapefile issue.

Re: Data does not display on the map, but present in the attribute table

JoshuaBixby — Sun, 08 Jul 2018 16:52:38 GMT

If you can share some (not all) of the data, that is helpful for others.

Re: Data does not display on the map, but present in the attribute table

DanPatterson_Retired — Sun, 08 Jul 2018 18:23:24 GMT

Use Share instead of multiple posting.

Your original post https://community.esri.com/thread/217542-data-does-not-display-on-the-map-but-present-in-the-attribute-table

Re: Data does not display on the map, but present in the attribute table

Michigan_StateUniversity — Sun, 08 Jul 2018 22:39:34 GMT

Here is my .csv file and the same file in the excel format. The two columns "Latitude and Longitude" are of the X and Y coordinates.

Re: Data does not display on the map, but present in the attribute table

DanPatterson_Retired — Sun, 08 Jul 2018 23:31:37 GMT

No longitude or latitude coordinates in either file.

What column were/are they supposed to be in?

Re: Data does not display on the map, but present in the attribute table

Michigan_StateUniversity — Sun, 08 Jul 2018 23:34:12 GMT

Columns titled as "Latitude" and "Longitude".

Re: Data does not display on the map, but present in the attribute table

DanPatterson_Retired — Mon, 09 Jul 2018 00:36:53 GMT

I meant the Letter... they don't open with the excel column names replaced.

Re: Data does not display on the map, but present in the attribute table

Michigan_StateUniversity — Mon, 09 Jul 2018 00:41:09 GMT

You mean, you dont see them in the .xlsx version? How about the .csv format?

Re: Data does not display on the map, but present in the attribute table

Michigan_StateUniversity — Mon, 09 Jul 2018 00:42:53 GMT

They are in columns "AX" and "BD"

Re: Data does not display on the map, but present in the attribute table

DanPatterson_Retired — Mon, 09 Jul 2018 00:46:55 GMT

found thanks

The data are fine... save to a file geodatabase since the field names won't allow for any other format (ie shapefiles).

I just use the XY to Point tool in arctoolbox, saved it to a geodatabase and you are done