It is necessary to download two tables in the database: 1 table with regions, 2 table with cities. At first I was recommended by the FIAS database, I downloaded it in the form of xml, in those files that I looked through there are no cities or regions. The remaining files are too large to open. Then I came across api in contact, but all the populated areas fall out there without breaking down into cities, villages, etc. I only need cities.

  • You need a table only ADDROBJ from FIAS (only from the full not from the update). Structure in the format description fias.nalog.ru/Updates.aspx - tutankhamun
  • 2 GB weighs, php parser can not process it, although I allocated more than 4 GB of RAM to execute the script. What could open it? - heff
  • Apparently you have to write your parser, which will read the file in batches - tutankhamun

0