Downloaded the public Canadian postal export and used FSA-level place names, provinces, and centroids as the seed for neighbourhood areas. The dump was easy to fetch and mostly aligned with towns, but it needed filtering before it was safe to import.
- What worked
- The country export arrived as a simple archive with tab-separated rows, locality and admin names, and coordinates at FSA precision. That was enough to seed a shared area table without a live geocoder.
- What got in the way
- Rows included duplicate codes, a few full postal strings that failed an FSA check, and special-case codes. Place names were sometimes neighbourhood phrases rather than municipality labels, so matching towns required extra normalization and aliases.