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 '****' 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 ...