I'm new to this site and the idea of geocoding and I am in love. This site and community are spectacular. I'm looking for a way to get the address, city and state out of these POI files (lat/lon/name). Is there a free way to batch convert them all? Thank you community.
That is very hard to do if not impossible. The problem being that using the lat/lon works fairly well to find an address's exact location on a short street but on long streets that run for miles the algorithm that maps use to guesstimate a address's exact location are far less accurate.
The location of any particular address is estimated by taking the know address at one end of the street and the known address on the other end and estimating the location somewhere in between. So using the lat/lon to find what the address is could be very close or could be way off.
Agree that a batch conversion will not be accurate for the reasons indicated, but let us know what you would do with the information and maybe we can come up with something.
This site will do it, but I haven't used it myself so I can't verify the accuracy, but it is easy and free.
If I understand your question correctly, all you need to do is edit the CSV file. It's already broken down to where it has the coordinates, name, and in almost all cases the complete address and often the phone number.
Box Car's correct. There are good POI files here in the factory, and bad ones.
An example of a good POI file might be "Gander Mountain stores." (Full disclosure: it's my file). In addition to the long/lat, the name contains the city and the comments contain the address and phone number.
An example of a bad POI file, in my opinion, is the Bahama Breeze file. Every entry has nothing but the long/lat and the name "Bahama Breeze." There's absolutely no information in the file other than that.
It's a lot of effort to create an informative POI, but it's worth the effort to the rest of us.
As rjrsw stated, the address would be impossible. As an example, every mapping program I have used shows the addresses in my block as going to 1972, when actually the addresses only go to 1958. On the mapping software my house shows about two houses east of where it actually is. Finding the state and city from the coordinates would be a piece of cake
As has been mentioned, there are good poi's and there are bad poi's. The poi's I have created contain Lat, lon, name, address, and a phone number in the csv file. Then there are those that contain lat, lon, and name only.
not sure why this is needed..
but, i can image if there is a tool to convert lat/lon to street address. When you convert it back to lat/lon, it is unlikely to get the original value.
Plus, sometimes, you might be given a street address close enough, but, could be miles away by driving. So, really, why?
I have a file with long/lat/name and no info in fourth field. Using EPE, I can extract city & state. That might help when planning a trip.
I just thought of one method you could use, but you would have to have Streets & Trips or an equivalent program and it would also be time consuming unless you were doing just a few. Also the address still wouldn't be accurate, the only advantage would be you could import a csv or gpx file and see it on a map.
i just use notepad to edit csv files, make notepad as wide as needed so all the cords are lined up you can add deleate cords names phone no's . i use google earth set to decimal degrees to get cords then add the info to the poi file and all the info you need just make sure you follow the format
lon,lat,"text" oh and dont forget when you save the file make sure the ex is .csv
hope that helps someone
terms | privacy | contactCopyright © 2006-2016