I have a spreadsheet with the coordinates in DD. The Longitude numbers did not have a - in front. For example 114.235 not -114.235. So I added another column named Long and added the -. I then tried to import the data into arc map using add data xy but the Long column does not show up as one of my options in the add data xy box. I am assuming it has something to do with the original Longitude columns formating????
Thanks,
Jane
I have now imported the points following the addition of the - in front of
the longitude numbers. I used gsc wgs 1984 and the points are still
showing up in the same place as when the - was not there...which is in the
middle of the ocean
What else could account for the points importing and presenting at the
wrong location.
Thanks
I did and it worked!
Thanks guys:)
don't 'add' a - in front... multiply your values by -1 as they have suggested.
Thanks Adam and Abullah, I think you are both right. So I will import the
table to a Geodatabse then use the field calculator to add a - in front of
the number.
Thanks for your help.
yes, you are right , when you add the - you make ArcGIS read this column as text field. but ArcGIS look for number field.
so I prefer to keep the original spreadsheet without modify. And Import that table to Geodatabase. then make field calculator to coordinate fields to multiply -1 . then use this table to add x y data.
Hi Jane - It may have something to do with that column. How did you add the '-'? The only way I've had that work in the past is to use a '-1' multiplier to get the number format to stick. There's a chance your process converted the numbers to text.
-Adam Z
Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
