Importing Cornwall, ON open data

Communities Canada
,
1

The City of Cornwall, Ontario publishes it’s open map data under their City of Cornwall Open Government Licence, a slightly modified version of the OSM-Compatible OGL - Ontario.

Of note, they publish:

(there are many other maps also available)

I want to import the Address Points, as currently none of the buildings on OSM have address tags. The city uses slightly different tags, but I am writing a python script to fix and clean them up. I also want to use the Buildings, Zoning, Parks and other maps as references to fix and update these data types, as the current information is mostly from 2020 it seems, while the city’s data is from 2024.

2

Currently, I am facing the dilemma of how the addresses are formatted; the street names are all capitalized.

Below is an example of the tags as in the city map:

ADDRESS=1450 SECOND ST E
CITY=CORNWALL
COUNTRY=CA
DIRECTION=E
POSTAL=K6H5Z8
PROVINCE=ON
STREET=SECOND
STREET_LNG=SECOND ST E
ST_NUMBER=1450
SUFFIX=ST

Now, Second Street East is easy to correct, but it seems I will have to correct every street name first.

3
4

For addresses, make sure to format the postal code in the A1A 1A1 format.

I wouldn’t add any data to the repository itself, just documentation and scripts

1 Like