how can i quickly create poi's from for usps mailboxes? see link...
Thu, 09/06/2007 - 9:33am
 16 years
|
http://www.payphone-project.com/mailboxes/
enter any zip (i.e. 92843) code and u get several rows that has st name; description; city; and zip. the two important info are the st. name and the description.
i can copy/paste info into excel, use text->columns feature and get the st. name in first column and description in second column. from there, how do i get the latitude/longitude for csv/poi format?
u can also click for google mashup map if u view source, it lists the coordinates. is there an easy way to covert info from the mashup into csv? thanks.
Use a Batch Geocoder
there are a few available ... one example : http://www.gpsvisualizer.com/geocoder/
you can cut/paste multiple addresses and it will output long./lat.
EZ Mailboxes
the two important info are the st. name and the description.
Grab all four columns and Paste Special, Text.
Use Text to Columns to parse column 3 "City" so you get both city and state.
Sooner or later you're going to want to get rid of the duplicates. With a short list like this, I'd do it by hand. If you do a long list, you'll probably want to use software (POI Verifier?) after geocoding.
Copy everything (including the first row with the labels) and use www.batchgeocode.com. Use column 1 for address, 3 for city, 4 for state, 2 for description.
Copy the output and paste it back into Excel. Reorder so column 1 is Lon, 2 is Lat, 3 is description (no need for the fourth column in this file).
Save As a CSV file....
- Keith