Mexican Postal CodesThis database lists the communities, towns and cities within all 32 states in Mexico, and gives the local postal code. Each locality is further categorized by the governing municipality and state within which it is located, and the city from which mail is routed -- usually the nearest large city. The data is provided as a zipped 'comma separated file' -- although in fact the semi-colon is used as a separator, rather than comma. All fields are enclosed in quote marks. There are seven fields in the database:
The locality types included are: Colonia, Gran usuario, Fraccionamiento, Unidad habitacional, Condominio, Barrio, Residencial, Zona comercial, Granja, Ejido, Rancho o rancheria, Ampliacion, Fabrica o industria, Aeropuerto, Zona industrial, Conjunto habitacional, Parque industrial, Unidad, Villa, Hacienda, Pueblo, Zona urbana, Centro urbano, Campamento, Zona federal, Club de golf, Ciudad, Campo militar, Base naval, Conjunto industrial, Exhacienda, Ingenio, Zona rural, Congregacion, Centro, Finca, Poblado comunal, Estacion, Equipamiento, Oficina Postal. MySQL Db Table Structure: CREATE TABLE `MEXPC` ( `num` int(6) unsigned NOT NULL auto_increment, `pc` varchar(6) NOT NULL default '', `locality` varchar(80) NOT NULL default '', `loctype` varchar(30) NOT NULL default '', `municipality` varchar(60) NOT NULL default '', `city` varchar(60) NOT NULL default '', `state` varchar(30) NOT NULL default '', PRIMARY KEY (`num`), KEY `locality` (`locality`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; Sample Records:
Database: Mexican Postal Codes
Copyright 2008 by Andrew J Morris, All rights reserved |