CSV. file (harvest data) not displayed properly in ArcGIS

2395
7
Jump to solution
06-14-2016 04:00 PM
Highlighted
New Contributor II

I have a harvest data csv. file to be imported into ArcGIS.

Then I use "Display XY Data".

It only shows me two points.

Please let me know how I can solve this problem.

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
MVP Esteemed Contributor

check your coordinates field

what is the min and max of the X, and Y (or long and lat) fields.

Is suspect that you have zeros, or worse, blank entries

dump any rows that don't have coordinates within the range of values you expect

View solution in original post

7 Replies
Highlighted
MVP Esteemed Contributor

check your coordinates field

what is the min and max of the X, and Y (or long and lat) fields.

Is suspect that you have zeros, or worse, blank entries

dump any rows that don't have coordinates within the range of values you expect

View solution in original post

Highlighted
New Contributor II

Great thanks Dan!

Reply
0 Kudos
Highlighted
New Contributor II

Hi Dan, just one more question, what's the best thing to do if I want "Statistics" works properly? 

Thanks!

Reply
0 Kudos
Highlighted
MVP Esteemed Contributor

well I don't see a field name selected in the dialog... apparently some FIELD01 is selected.  Also, convert your csv file as a table if you are working in a geodatabase, csv is fine for importing, but you want to save it as a table

Reply
0 Kudos
Highlighted
New Contributor II

Hi Dan, do you mean that I should create a file geodatabase and use "table to geodatabase" to save it? 

Once I've done that, "Statistics" is working fine now thanks.

But one problem I also encounter is that the layer cannot be edited.

Is there a way to convert it into a shapefile or other editable format so that it can be edited?

Reply
0 Kudos
Highlighted
MVP Esteemed Contributor

you can't edit an event layer, you have to convert it to a shapefile or a featureclass in a geodatabase

Also, you should post your questions separately, the thread now contains unrelated content to the original one.

Reply
0 Kudos
Highlighted
New Contributor II

Great thanks 🙂

Reply
0 Kudos