Here is how to quickly assign geographic coordinates to street addresses using the online program called,
batchgeo
First, prepare a set of street addresses in a tab delimited format. Here's an example I typed into a spreadsheet:
| Name | Address | City | Province |
| Cafe | 175 West Ave | Kitchener | Ontario |
| WLU | 75 University Ave. W | Waterloo | Ontario |
| Kitchener | 200 King St. W. | Kitchener | Ontario |
|
|
|
|
|
| |
|
|
| Second, cut and past this table into batchbgeo |
|
|
|
|
|
|
|
|
|
|
|
|
| Third, follow the remaining steps laid out by the batchgeo software to set the options and geocode the table. The map can be displayed online and/or saved as a kml file. The kml file can then be loaded into Google Earth or imported into Google Maps, as shown by the map below. | |
|
|
|
|
|
|
|
