I converted data to decimal degrees. All my data in ArcMap is going through WGS 1984. However when it draws, my points they come out in a line far South of Texas. Any Ideas?
longitude is the X, latitude is the Y, what did you use to plot it? Also, a good idea to get rid of the blank rows before bringing it into ArcMap. Further details required as to your procedure otherwise any further answers would be guessing.
I have narrowed it down to being a space most likely in my latitude. (in excel) Once its in ArcMap I can see in attributes Latitude is null. I am brand new to GIS, but I believe I plotted it with WSG 1984. (That's what I set) I am importing from text file with wizard, its delineated with tabs, and I have set General/Text appropriately. Now I am just unsure how to locate the space and delete it. To convert I manually typed in formula and applied row by row.
if that doesn't work, then your numeric fields have 'crap' in them and will have to be processed out.
Could you attach a snapshot of your excel sheet with the fieldnames and the sample Lon/Lat values?
they are in an attachment to the original post, they do contain entries where coordinates are empty ie Alcino
Oops!!! Sorry. I checked it from my inbox, so missed the attachments.
You could convert the Excel sheet to table. Then create XY data from table using GCS_WGS_1984 spatial reference. Export the event layer to shapefile.
Using select by attributes, select the records where latitude = 0.
Start Editing, and delete the selected records. Save and stop editing.
The resulting data looks like this, with 9272 records.
I removed the trailing space from the "Latitude" field name and was able to display your points in ArcMap. Give that a shot.
Retrieving data ...