Projects / geozonedb

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 www.geonames.org 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.

Tags
Licenses
Implementation

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.

        Screenshot

        Project Spotlight

        OpenStack4j

        A Fluent OpenStack client API for Java.

        Screenshot

        Project Spotlight

        TurnKey TWiki Appliance

        A TWiki appliance that is easy to use and lightweight.