You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to open-data...@googlegroups.com
Hello,
Does anyone know if there’s a list of all street names in Montreal? I have a huge database of addresses and I want to make sure all street names are correctly spelled.
Thanks.
Roberto
Roberto Rocha
Multimedia and data journalist
The Gazette - a division of Postmedia Network Inc
1010 Sainte-Catherine Street West, Suite 200, Montreal QC, H3B 5L1
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to open-data...@googlegroups.com
Hi Roberto,
From the AdressesQuebec download, you can look at the shape file folder (ESRISHP) and open the AQ_ROUTES.DBF. You used to be able to open dbf files with excel but you can't anymore. However, you can use OpenOffice Calc. One of the columns is the road names but you will need to filter for unique values because the same road name is repeated many times.
Hope that helps,
Guillaume
Rocha, Roberto (Montreal Gazette)
unread,
Mar 15, 2012, 9:50:05 AM3/15/12
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to open-data...@googlegroups.com
These are all great suggestions. I'll try each one and report back.
Guillaume, I can also open a .dbf in QGIS and export it as CSV. Easy.
Thanks everyone.
~~~~~~~~~~~~~~~~~~~~~~
I apologize for typos or funny wording. This was sent from a mobile phone.