Adrenalin’s Experience

Velib Paris pushpins for Microsoft Autoroute 2002

Posted in Uncategorized by Adrenalin on June 1, 2008

Yesterday walking around the Paris and searching for velib I thought it were a good idea to have all the points on mine Autoroute map..
Today didn’t found a 2 clicks way to import something, but I still found all the station with latitude and longitude data from http://www.velib.paris.fr/service/carto, but in XML format.
Unfortunately autoroute 2002 seem to be too old for xml, anyway, didn’t take too much with a regular expression I extracted interested columns separated by tabulator character and constructed a cvs file.

Copy it from here http://pastebin.com/pastebin.php?dl=f441c1181

Save this into a velib_pushs.csv, after On the Data menu, click Import Data Wizard, importing from a plain-text file (*.txt, *.csv) select the velib_pushs.csv file, click Next, first column is name, second Address, third Latitude fourth Longitude click finish, now look at the Paris, you should see a lot of pushpins, like here:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: