I have spreadsheet data with columns of Lat/Longs, along with the data that I'd like to display on the map. Can anyone tell me how to use the Lat/Long data to geocode and tie the data to the specific points. This is for a world map.
I am going around in circles trying to get addresses displayed in ArcGIS - can someone please help??
First i tried importing lists of addresses - didn't work - then i added to the addresses - that didn't work either. Then i read that longitude/latitude addresses usually import better - so I have used geocoder software (http://www.gpsvisualizer.com/geocoder/) to find the longitude and latitude of the addresses in Perth, Western Australia that I am working with.
The format that the geocoder gave didn't work - i got error messages. So i've fiddled again and again with the data before reading that the format for importing longitude and latitude data needs to have decimals and a dash between the two numbers.
Feeling way to confident I again altered my data. These are an example with three longitude/lattitudes:
I put this data in an excel file and saved as a CSV file - then tried to import to ArcGIS - here: http://www.arcgis.com/home/webmap/viewer.html - selecting the 'add' button - then 'add layer from file' button.
Then i get this message: Error The layer was not created because no locations could be found. Make sure your data has valid addresses or geographic coordinates (latitude/longitude).
Its been four hours (today, that is) trying to get my data to display on a map. will it ever work??
what i am trying to do - i have a whole bunch of addresses - these relate to interviews of people who were impacted by a bushfire (wildfire) in western australia - then i have addreses of where they evacuated to first, then later, and then later than that. I want to create 'trips' from this data - on the one map - and be able to filter according to basic demographic data. So - each person starts from their home address - then there's a line from there to where they went first - then another line to the second place etc - and the map shows all the 'trips' these people took.
First problem - if i use the format you suggest for the longitude/latitude the excel program thinks that i'm trying to do some calculation as there is a '-' at the front of the line. So copying and pasting into a fresh sheet of excel doesn't work. As far as i understand you can only create a CSV file from an excel file? I've tried saving a word document as a 'text document' with the '-' at the front of the longitude/latitude but that doesn't work either.
any idea how to turn off the calculation thing in the excel file so i can use an '-' at the beginning of data in a datacell??
If i could solve that then i could try again - to import that data and see if i can get it mapped on the ArcGIS i have open.
I dont know if you have any specific requirement to save it in csv. You can use txt files as well. It just works fine in ESRI softwares. I have tested this in text file format with http://www.arcgis.com/home/webmap/viewer.html
You have to format the column to have numbers in excel
If you must use excel, put your Latitude (Y) and Longitude (X) in two seperate numerical columns. Be sure to set the number of decimal places that will accomodate your data.
Personally, I use excel for billing and taxes; it's a great accounting tool. For real-live data, I prefer a real-live database.
I would gladly use an alternative to excel - not wedded to it at all. can you please suggest what software i can use and how to lay it out so that i can import those longitude and latitude co-ordinates?
I tried saving the data in a word document as a text file and then importing that - but error message.
I have tried importing the addresses - error message.
I am still a mile away from where i want to be with this - but it would feel slightly positive if i could just import some data that displayed.
