Hello,
There are some mistakes in admin_code1 of Mexico https://download.geonames.org/export/zip/MX.zip
I take the FIPS code (here: http://www.geonames.org/MX/administrative-division-.html or here: https://en.wikipedia.org/wiki/List_of_FIPS_region_codes_(M%E2%80%93O)#MX:_Mexico) and can see that admin_name1 for the postals and location make sense but the codes are wrongly mapped.
Here is the mapping needed to convert them correctly
Code:
05 => 07
06 => 08
07 => 05
08 => 06
Here are some example rows 05 is Chiapas but marked as Coahuila
Code:
MX 25543 La Tinaja Coahuila de Zaragoza 05 Abasolo 001 27.1805 -101.4326 4
Here are some more example rows for the 4 different codes:
05 is Chiapas
Code:
MX 25544 Los Ángeles (Osvaldo Mata) Coahuila de Zaragoza 05 Abasolo 001 27.1764 -101.4287 4
MX 25544 El Nogal Coahuila de Zaragoza 05 Abasolo 001 27.1224 -101.2458 3
MX 25544 El Cangrejo Coahuila de Zaragoza 05 Abasolo 001 27.1224 -101.2458 3
06 is Chihuahua
Code:
MX 28300 Armería Centro Colima 06 Armería 001 Ciudad de Armería 05 18.965 -103.9099 1
MX 28304 Lázaro Cárdenas Colima 06 Armería 001 Ciudad de Armería 05 19.0092 -103.9984 1
MX 28304 Cristo Rey Colima 06 Armería 001 Ciudad de Armería 05 18.965 -103.9099 1
MX 28304 Lindavista Colima 06 Armería 001 Ciudad de Armería 05 19.0092 -103.9984 1
07 is Coahuila
Code:
MX 30590 Nuevo Milenio Chiapas 07 Acacoyagua 001 15.4141 -92.6817 3
MX 30590 San Pedro Chiapas 07 Acacoyagua 001 15.3425 -92.6603 4
MX 30590 Río Grande Chiapas 07 Acacoyagua 001 15.3686 -92.7365 4
08 is Colima
Code:
MX 32800 Los Carriles Chihuahua 08 Ahumada 001 29.4351 -104.6309 1
MX 32800 Fátima Chihuahua 08 Ahumada 001 30.4492 -106.3807 1
MX 32800 Chihuahuita Chihuahua 08 Ahumada 001 30.4492 -106.3807 1
MX 32800 Ahumada Chihuahua 08 Ahumada 001 29.4351 -104.6309 1