Street database of Canada in Excel, SQL, CSV or XML download

Extract from the database

To assess what the data looks like and what can be contained in such a list, you can download a small sample database of the 100 streets in Canada.

Download the list of street names in Canada

Download the database of all cities in Canada

Some companies or ambitious projects need geographical data and require a list of the streets of the communes in Canada. In order to help these large projects, Postalcodezip has prepared a database listing 1 078 625 streets, spread over 867 069 cities with 856 191 postcodes in Canada.

Canada

Database of streets, addresses in Canada

This type of database provides a list of streets for many types of projects. To help developers better understand the possibilities, here is a shortlist of possible applications of the database:

Form entry.
Development of applications requiring the use of postal data.
Pre-fill in the street name more easily in a form requesting a postal address.
Verify the correctness of an address entered by a user.
Generate the postal address of a profile, based on real data.
For an application that already has postal addresses, this database of addresses makes it easier to cross-reference the data and to group buildings, establishments, or customers more easily, based on their postal addresses.
Autocomplete city and location entry using the best localities dataset
Make various statistics to know the number of "blocks" or "driveway" for each area of Canada. Same if they wish to know the number of the streets called "Gd" in Canada.

Did you know: in Canada there are 1 078 625 streets / avenues / places / driveways / boulevards / roads... associated with the name of "Gd"!

Table data

The database contains 4 tables with data that complement each other: streets, municipalities, departments, and the type of roads.

We update all our data every 6 months. At your request, we can provide you with an update 30 days after you have received your file. After that, you will need to contact us. This is a once off purchase.

Table of streets in Canada:

Iso: country code (INSEE code)
Country: country wording
Region: Name of the region
Commune name: full name of the commune
Postal code: postal code
Street: full street name, with the type of lane
Latitude: GPS coordinates
Longitude: GPS coordinates
Elevation: GPS coordinates

Table of communes in Canada:

Iso: country code (INSEE code)
Country: country wording
Region: Name of the region
Commune name: full name of the commune, city, or locality
Postal code: postal code or zip

Take note: for a more complete list, please use the more complete list of communes in Canada. The INSEE code is used as a reference to link the data together in a unique dataset.

Table of departments/region in Canada:

Take note:

The dataset contains 1 078 625 streets, spread over 867 069 towns and cities in Canada, as well as postcodes.
Every week, streets are added, modified, or deleted.

Buy

If you are interested in the list of all the streets, roads, or boulevards in Canada, make a purchase directly on this site.

Make good use of these tables and don't hesitate to share your ideas and creations with others about what you could accomplish with this database.

Additional information like the nature of the lanes or INSEE, NUTS, or FIPS codes for statistical studies is available on request. Please contact us.