Home
Name Modified Size Downloads / Week Status
geozonesearch0.5.6.tar.bz2 2011-08-17 14.6 kB 0
readme 2011-08-17 5.7 kB 0
geozonesearch0.5.5.tar.bz2 2011-08-16 13.6 kB 0
geozonedb.0.5.tar.bz2 2011-06-15 314.1 kB 0
README.txt 2011-06-13 4.7 kB 0
geodb0.4.tar.bz2 2011-05-25 9.9 MB 0
geodb0.3.tar.bz2 2011-05-20 9.9 MB 0
geozonedb_dump_data.tar.bz2 2011-05-16 8.5 MB 0
Totals: 8 Items   28.5 MB
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.6 Added the API /path/to/server/geozonesearch/index.php?method=getZoneByID&id=:zoneID You'll get everything about a zone, also postalcode, longitude, and latitude GeoZoneDB 0.5.3 I've transformed the class in a Rest service by using Zend Framework, i'm creating a complete MVC application through Zend. Version 0.6 will have both geozonesearch to locally make searches, and Rest service you may try: ******* /path/to/server/geozonesearch/index.php?method=getCountries This will list every country ******* /path/to/server/geozonesearch/index.php?method=search&CountryISO=IT&Community=Mil will show you for example every community in Italy(countriISO=IT stands for Italy) which starts for Mil I need a lot of help/ I've added PDO support, so to be able to work with oracle, postgreSQL and other, but i don't have the time. is there someone? hello? I'm thinking at a SOLR support, my REST should call SOLR I'm working at a MongoDB version. 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.
Source: readme, updated 2011-08-17

Thanks for helping keep SourceForge clean.

Screenshot instructions:
Windows
Mac
Red Hat Linux   Ubuntu

Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)

More information about our ad policies
X

Briefly describe the problem (required):

Upload screenshot of ad (required):
Select a file, or drag & drop file here.

Please provide the ad click URL, if possible:

Get latest updates about Open Source Projects, Conferences and News.

No, Thank you