I believe I'm not the first one asking about this, but I was wondering if there is a database file for the Canadian postal codes. I checked the CVS repository, but no luck there. I have tried to download a database dump from GeoNames but don't really know where to start the import process into MySQL. For example, the GeoNames timezone is listed in plain English (America/Vancouver) and the Location timezone is an integer (-8), etc.
1) Does anybody know if a database file for the Canadian postal codes is available?
2) Is there a "recipe" to convert a GeoNames database dump to a MySQL file?
Any help would be really appreciated.
Thanks a lot,