Login   Register  
PHP Classes
elePHPant
Icontem

geozonedb: Get world geographic data from GeoNames into MySQL

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (7)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2011-06-14 (3 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 623 All time: 4,590 This week: 1,463Up
Version License PHP version Categories  
geozonedb 0.4GNU General Public Lice...5PHP 5, Databases, Web services, Geogr...
Description Author  

This class can get world geographic data from GeoNames into MySQL.

It can retrieve geographic data files about countries of the world from the GeoNames site and populates a MySQL database for easier lookup.

The class can create the necessary MySQL tables and fill them with country data elements like names, codes, capital names, location coordinates, city names, postal codes, etc..

Innovation Award  
PHP Programming Innovation award nominee
June 2011
Number 4


Prize: One subscription to the PDF edition of the PHP Architect magazine
GeoNames is site that aggregates information of all regions around the world. That information may be searched in the site or via a Web service.

However, if you need to perform intensive queries on the available information, it would be faster if you query it locally. The site also provides dumps of their database, so you can retrieve and use it locally in any other site.

This class can parse the Geonames database dump files and import it into a local MySQL database to make it easier to query the Geonames information in a much faster way.

Manuel Lemos
Picture of Virgilio lino
Name: Virgilio lino <contact>
Classes: 2 packages by
Country: Italy Italy
Age: 35
All time rank: 176470 in Italy Italy
Week rank: 774 Up36 in Italy Italy Up
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files  
File Role Description
Accessible without login Plain text file geozonedb.php Class main class
Accessible without login Plain text file readme Doc. instructions
Accessible without login Plain text file engine.php Example library used by main class put in includes directory
Accessible without login Plain text file includes_configure.php Conf. put on includes directory
Accessible without login Plain text file includes_geozonedb.php Aux. put on includes directory
Accessible without login Plain text file geozonesearch.php Class class for interface to use on your application
Accessible without login Plain text file index.php Appl. example of usage

 Version Control Unique User Downloads Download Rankings  
 0%Total:623All time:4,590
 This week:0This week:1,463Up