2017 © Pedro Peláez
 

library zf2-geoname

maintain a local copy of the Geonames database

image

heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  • Wednesday, July 6, 2016
  • by heartsentwined
  • Repository
  • 2 Watchers
  • 12 Stars
  • 95 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 1 Forks
  • 2 Open issues
  • 26 Versions
  • 0 % Grown

The README.md

zf2-geoname

Build Status, (*1)

Maintain a local copy of the Geonames (places) database., (*2)

This module will install a self-updating local copy of the Geonames (places) database. It covers the location information, as available from the official database dump. It does not cover the "add-ons", e.g. earthquake, weather data, etc, as available from their webservices., (*3)

Attention: the Geonames database is around 1.5GiB - 2GiB in size, when installed in a MySQL database. Are you sure you need a local copy, instead of the official webservices?, (*4)

Installation

Composer:, (*5)

{
  "require": {
    "yalesov/zf2-geoname": "4.*"
  }
}

Then add Yalesov\Geoname to the modules key in (app root)/config/application.config.*, (*6)

Geoname module will also hook onto your application's database, through DoctrineORMModule. It will create a number of tables with the prefix he_geoname_*, and will use the default EntityManager doctrine.entitymanager.orm_default. If your settings are different, please modify the doctrine section of config/module.config.yml as needed., (*7)

Geoname module makes use of the Cron module, so make sure you follow its settings, and have set up your cron job properly., (*8)

Finally, you need to update your database schema. The recommended way is through Doctrine's CLI:, (*9)

$ vendor/bin/doctrine-module orm:schema-tool:update --force

Config

Copy config/geoname.local.php.dist to (app root)/config/autoload/geoname.local.php, and modify the settings., (*10)

  • tmpDir: temporary directory for storing geonames database source files. (Make sure it is script-writable.)
  • cron: (cron expression) how frequently Geoname should be run.

How frequent should cron be? The recommended setup is every 15 minutes, which is also the default. However, you can make your own adjustments:, (*11)

At present (18 Sep 2012), it will take 820 cron jobs to install the database. At 15-minute intervals, that would take ~8.5 days to install the database. As for the updates, only 1 cron job per day is needed. However, setting more than one per day is highly recommended to provide redundancy - just in case the geonames server is temporarily unreachable, for example., (*12)

You can also adjust to a less frequent cron after install. The status field of the Meta entity, or the he_geoname_meta table, will be Yalesov\Geoname\Repository\Meta::STATUS_INSTALL_* during installation, and Yalesov\Geoname\Repository\Meta::STATUS_UPDATE afterwards., (*13)

Usage

Database sync

Just follow the installation instructions. Geoname module will install and update its database in your cron jobs., (*14)

Note: when the sources indicate a "delete", Geoname module will not actually delete the corresponding record from your database; it will only mark it as deprecated (by setting the isDeprecated field to true in the entities Place and AltName). This is to ensure that you can rely on the primary IDs set up by Geoname module in your ZF2 app., (*15)

Querying the database

You can use the Doctrine 2 ORM API directly. Mapping files are located at (zf2-geoname)/src/Yalesov/Geoname/Entity/Mapping. All places' hierarchy, from continent, country, to the various administration levels, have been properly captured in the parent and children fields of the Place entity., (*16)

TODO: add a set of API for common tasks, e.g. finding a place by name, listing all places in a country, etc., (*17)

The Versions

06/07 2016

dev-master

9999999-dev https://github.com/yalesov/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

ISC

The Requires

 

The Development Requires

by Yulij Andreevich Lesov

zf2 zendframework geoname

06/07 2016

v4.2.3

4.2.3.0 https://github.com/yalesov/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

ISC

The Requires

 

The Development Requires

by Yulij Andreevich Lesov

zf2 zendframework geoname

06/07 2016

v4.2.2

4.2.2.0 https://github.com/yalesov/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

ISC

The Requires

 

The Development Requires

by Yulij Andreevich Lesov

zf2 zendframework geoname

06/07 2016

v4.2.1

4.2.1.0 https://github.com/yalesov/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

ISC

The Requires

 

The Development Requires

by Yulij Andreevich Lesov

zf2 zendframework geoname

06/07 2016

v4.2.0

4.2.0.0 https://github.com/yalesov/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

ISC

The Requires

 

The Development Requires

by Yulij Andreevich Lesov

zf2 zendframework geoname

05/07 2016

v4.1.0

4.1.0.0 https://github.com/yalesov/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

ISC

The Requires

 

The Development Requires

by Yulij Andreevich Lesov

zf2 zendframework geoname

05/07 2016

v4.0.0

4.0.0.0 https://github.com/yalesov/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

ISC

The Requires

 

The Development Requires

by Yulij Andreevich Lesov

zf2 zendframework geoname

12/03 2013

3.0.10

3.0.10.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

The Development Requires

by Avatar heartsentwined

zf2 zendframework geoname

12/03 2013

3.0.9

3.0.9.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

The Development Requires

by Avatar heartsentwined

zf2 zendframework geoname

11/02 2013

3.0.8

3.0.8.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

03/10 2012

3.0.7

3.0.7.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

28/09 2012

3.0.6

3.0.6.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

28/09 2012

3.0.5

3.0.5.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

27/09 2012

3.0.4

3.0.4.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

26/09 2012

3.0.3

3.0.3.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

26/09 2012

3.0.2

3.0.2.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

26/09 2012

3.0.0

3.0.0.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

26/09 2012

3.0.1

3.0.1.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

21/09 2012

2.0.2

2.0.2.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

21/09 2012

2.0.1

2.0.1.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

19/09 2012

2.0.0

2.0.0.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

18/09 2012

1.0.2

1.0.2.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

18/09 2012

1.0.1

1.0.1.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

18/09 2012

1.0.0

1.0.0.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

18/09 2012

0.2.0

0.2.0.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname

17/09 2012

0.1.0

0.1.0.0 https://github.com/heartsentwined/zf2-geoname

maintain a local copy of the Geonames database

  Sources   Download

GPL-3.0

The Requires

 

by Avatar heartsentwined

zf2 zendframework geoname