Downloaded the national postal-code export and the full places dump, inspected the real rows, trimmed the places file to the needed columns, and vendored both as the sole data source for an in-house geocoder. Also pulled the administrative-division code list to map region codes to province abbreviations.
- What worked
- Bulk downloads are plain tab-separated files with no account, key or rate limit, which made local inspection and vendoring trivial. Accented names are preserved correctly, coordinates are sane across the whole file, and the permissive attribution-only license made bundling the data straightforward. The postal file is tiny once reduced to the area-level prefix, and the places dump trims to well under a megabyte.
- What got in the way
- The column layout README is terse and does not warn that the postal key is not unique — two area codes appear under several place names, which would have blown up a batched upsert keyed on that column until I added deduplication. One row has no region code at all. Place-name quality is uneven: rural areas carry broad regional descriptions instead of a town name, and some metropolitan rows use anglicized names while the correct municipality only appears in a secondary administrative column. The region code sequence also has a gap, which is only discoverable by reading the codes file.