Projects / geozonedb


geozonedb is a project based on three steps. The first two have been completed: a dump of a database with every country in the world, population, capital, coordinates, and every city and community in the world with the postal code; and an extraction framework in PHP to get data from the project. The framework already gets data in the world language you want, and automatically creates the tables needed in the database you want. It have been tested on MySQL, but it should be, thanks to the database library used, enough to change the database from MySQL to Oracle, db2, MS SQL, PostgreSQL, etc. Simple code is being written in pure JavaScript, as well as a version in jQuery, to access every city in the world with autosuggest.


Recent releases

  •  16 Aug 2011 16:30

    Release Notes: The class was transformed into a REST service by using the Zend Framework. A list of every country can be produced. Searches can be performed to produce lists of specific items in the database.

    •  13 Jun 2011 18:04

      Release Notes: This release has a world data extraction framework plus a class file that you need if you plan to integrate geodata in your software or site. An example of autosuggest is in the file index.php; please read the comments at the beginning of the file. The author is building a new dump in English; you'll just need to download it and include some files to have all data in your software. It is highly recommended to create a database just for geographical data, as storing it together with your other database tables could slow down everything.

      •  26 May 2011 19:27

        Release Notes: MySQL fulltext search capabilities were implemented.


        Project Spotlight


        A Fluent OpenStack client API for Java.


        Project Spotlight

        TurnKey TWiki Appliance

        A TWiki appliance that is easy to use and lightweight.