Web Content Center

Mexican Localities

This database lists the communities, towns and cities within all 32 states in Mexico. This is a sub-set of the Mexican Postal Code database, with the postal codes left out. There are slightly fewer records because this database also leaves out the 'special' listings for individual buildings, organizations, etc. Each locality listed here includes the governing municipality and state within which it is located. 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 four fields in the database:

Number - a counter field
Locality - the name of the town, community or city
Municipality - the governing municipality within which the locality is found
State - the state within which the locality is found

MySQL Db Table Structure:

CREATE TABLE `MEXLOC` (
  `num` int(6) unsigned NOT NULL auto_increment,
  `locality` varchar(80) NOT NULL default '',
  `municipality` varchar(60) NOT NULL default '',
  `state` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`num`),
  KEY `locality` (`locality`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

Sample Records:

"25815";"El Jobal Nuevo";"Loma Bonita";"Oaxaca"
"25816";"El Roble";"Loma Bonita";"Oaxaca"
"25817";"La Esperanza Agua Pescadito";"Loma Bonita";"Oaxaca"
"25818";"Monterrosa";"Loma Bonita";"Oaxaca"
"25819";"Nuevo Horizonte";"Loma Bonita";"Oaxaca"
"25820";"San Felipe";"Loma Bonita";"Oaxaca"
"25821";"Cosolapa Centro";"Cosolapa";"Oaxaca"
"25822";"Obreros";"Cosolapa";"Oaxaca"
"25823";"Santa Fe";"Cosolapa";"Oaxaca"
"25824";"La Laguna";"Cosolapa";"Oaxaca"

Database: Mexican Localities
Number of Records: 41417
Price: U.S. $18.00