Generate Distance Matrix between addresses.
This program requires a valid API for the Google Maps Distance Matrix API (see https://developers.google.com/maps).
As input to this program an Excel file in 95 format (.xls extension) is needed. It is a simple sheet containing the the following columns (note, all need to be in 'text-format'):
- Abbreviation of location
- Full name of location
- Streetname
- Housenumber plus extension
- Zip-code
- Place
- Country
An example file is included as part of this repository. This program generated .csv output to stdout. You should redirect this to a file with .csv extension. MS Excel can be used to read the matrix file and further process it.
usage: DistanceAPI.py filename
arguments:
filename file to be used as input
output:
csv-data to standard output in a format MS Excel can import. Redirect stdout to a file to import it into MS Excel.
Example input:
| AMS | Royal Palace Amsterdam | Nieuwezijds Voorburgwal | 147 | 1012 RJ | Amsterdam | The Netherlands |
| EIF | Eiffel Tower | Av. Anatole France | 5 | 75007 | Paris | France |
| COL | Colosseum | Piazza del Colosseo | 1 | 00184 | Rome | Italy |
Result (on stdout):
"From / To";"AMS";"EIF";"COL"
"AMS";0;514;1660
"EIF";511;0;1408
"COL";1663;1434;0
Result (when imported in MS Excel):
| From / To | AMS | EIF | COL |
|---|---|---|---|
| AMS | 0 | 514 | 1660 |
| EIF | 511 | 0 | 1408 |
| COL | 1663 | 1434 | 0 |
Want to stimulate the ongoing development? Your BTCs are welcome! Send them to bitcoin:15pqCjD7pPPraGJ8T4yfbkrtFTBX8M4jyw