2

I have sought and tried many tutorials and documents without success. I have arcgis desktop 10.2.2 installed. I have added a US map as a layer. Then I do the following hoping to display all (2000+) data points on the map as another layer.

Add data > select my csv (which contains 2000+ rows each with a longitude and latitude > display data > OK.

I am able to see all the data imported by right-click > open. But when I did the above sequence of selections, there is only one single dot displayed.

Example:

name class lat  lon
Stony 1 35.773444   -78.6305752
fowler zak 0 38.82349688    -77.61919194

closed as off-topic by PolyGeo Jan 12 '17 at 9:21

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This problem cannot or can no longer be reproduced. Changes to the system or to the asker's circumstances may have rendered the question obsolete, or the question does not include a procedure to enable potential answerers to reproduce the same symptoms. Such questions are off-topic as they are unlikely to help future readers, but editing them to include more details can lead to re-opening." – PolyGeo
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Check your spatial reference, the lat/long data may be in a different format than your US layer. Perhaps the points are being displayed in different units or the zoom level is too high. – Maksim Jul 14 '15 at 18:11
  • Sorry I am very new to arcgis, how do I check/change spatial reference? – KubiK888 Jul 14 '15 at 18:13
  • Right click your layer -> properties -> 'source' tab, look at the coordinate system type. Use the Project tool to match your x/y event layer to the coordinate system of your US layer. – Maksim Jul 14 '15 at 18:16
  • 1
    Adding to the above, you're likely only 'seeing' one dot because relative to the whole map, your points are very close to each other. If you zoomed in to them closely, you'll likely see them all. Lat long is in degrees, such as 41N 87W. The coordinate system for your US layer is probably in meters or feet. So your lat/long data is displaying 41 ft or meters north, 87 west of the US layers 0,0 starting point. Data in the US layer is probably in the hundreds of thousands, even millions, of feet or meters. – recurvata Jul 14 '15 at 18:54
  • Can you show a few rows as an example of what you've got in the table. Without knowing exactly how the coordinate is specified we can't help get the locations exact. CSV (and Excel) can be a little unstable, it might work in your favor to import to DBF/personal (Access) database table. Esri can also 'have a cow' about field names/header row - it should not contain spaces, punctuation and no repeats. – Michael Stimson Jul 15 '15 at 3:56