PHP Classes

File: readme

Recommend this page to a friend!
  Classes of Virgilio lino   geozonedb   readme   Download  
File: readme
Role: Documentation
Content type: text/plain
Description: instructions
Class: geozonedb
Get world geographic data from GeoNames into MySQL
Author: By
Last change: version 5.0 instructions
Date: 12 years ago
Size: 4,743 bytes
 

Contents

Class file image Download
Copyright Virgilio Lino 2011 Geozonedb. virgiliolino@gmail.com Based on data taken from geonames.org The framework and sql files are released under dual license, Creative Commons Attribution 3.0 License and gpl license 2. GeoZoneDB is an opensource project to load geozone data into sql files, ready to download if you don't want to lose time. Database has been conceived to be as fast as possible to retrieve data from every Community, State, Country of the world, with population, postal code, etc. GeoZoneDB 0.5 geozonedb.php - world data extraction framework geozonesearch.php - this is the only class you need if you plan to integrate geodata in your software or site. An example of autosuggest is on file index.php please read comments on beginning of the file I'm building a new dump in english, you'll just need to download it and include some files to have all data in your software. I highly recommend to create a database just for geographical data as it together with your database tables, it could slowdown everything. Read the instructions for GeoZoneDB0.4 as are ok for 0.5 Please let me know if you like it to virgiliolino@gmail.com send me suggestions, or if you want TO HELP ME!!!! I'm searching for every skill, even if you are not a programmer i need someone to create a dump of every world language, i need some one to put files on my site, etc GeoZoneDB 0.4 What is GeoZoneDB -------------------------------------------------------------------------------------------------------------------- You may just download(its still not updated to version 0.4): geozonedb_dump_data.tar.bz2 wich is an sql file, if you import it in your database you'll have an optimized database with all the world zones, 2 country tables, and more than one hundred zones comunity tables To create a database with new 0.4 version do what follows: 0. Create a database with for example phpmyadmin or you may use an old database To setup: 1. includes/configure.php DB_SERVER : the server name: usually it's fine to live "localhost" DB_SERVER_USERNAME : the username : the username to access the db DB_SERVER_PASSWORD : the password of the user to access the db DB_DATABASE : the name of the database There is no need to create the tables in the database, tables will be automatically generated usage: to populate the countries data: $geo=new geoZoneDB(); $geo->setLocale('IT'); // if setted data will not be loaded in english but in the language indicated $geo->loadCountries(); to populate the zones data: $geo=new geoZoneDB(); $geo->loadZones(); ************************************************************************ HELP WANTED I need help to optimize the database, i plan to integrate the framework with Sphinx indexes. I need help to improve the php framework to import data. I need help to build a multilevel set of combos to navigate throw country-state-community. I plan to build on next release an autosuggest system instead of multilevel set of combos. please contact me at virgiliolino@gmail.com --------------------------------------------------------------------------------- Changes: Version 0.4 ---------------------------------------------------------------------------------------------------- I've done some OO evolution of the code, on this version i'm gonna try MYsql fulltext search capabilities, even if benchmarks around on the net tell mysql fullsearch is slow, i've done some tries and i think it's ok, i get same benchmark as with innodb but without advanced capabilities on IR applied to index. -result ordered by ranking! Version 0.3 ---------------------------------------------------------------------------------------------------- I've changed the structure of the every zones table, i'ved removed the ISOnumeric field, it's the field to identify the country, but, as the information is inserted on the table named by the country code, i think it could be enough to take the table number, however I've created a ZoneToCountry table with two fields, it will be usefull to identify the country a zone comes from. The second most important change is that Zone_ID will be a unique ID among all the zone tables, so the extraction framework must assing a unique id to every zone row, i mean unique not just inside the table on where it's but, unique among every zone table, in these way we have a 32bit, the first target to apply the sphinx indexing capabilities. We plan to build a view with all the zone tables and to index it with the open source indexing server.