Teryt Database Bundle

Teryt is Poland territorial division database available at http://eteryt.stat.gov.pl This bundle adds commands that download files from teryt API, parse xml files and insert data into database.

Installation

Add to your composer.json file following line

"require": {
    "fsi/teryt-database-bundle": "^3.0"
}

Register bundles in AppKernel.php

public function registerBundles()
{
    return [
        // ...
        new FSi\Bundle\TerytDatabaseBundle\FSiTerytDbBundle(),
        new Doctrine\Bundle\FixturesBundle\DoctrineFixturesBundle(),
        // ...
    ];
}

Add following configuration:

fsi_teryt_db:
    api:
        url: "https://uslugaterytws1.stat.gov.pl/wsdl/terytws1.wsdl"
        username: "<your username>"
        password: "<your password>"

From now commands should be available in your application.

Download XML files from teryt page

$ cd project
$ symfony console teryt:download:territorial-division
$ symfony console teryt:download:places-dictionary
$ symfony console teryt:download:places
$ symfony console teryt:download:streets

All above commands have an additional argument --target, that allows you to download files in a place other than "%kernel.project_dir%/teryt/ (default download target folder).

Import data from XML files to database

First you need to unzip the downloaded .zip files.

$ cd project/teryt
$ unzip territorial-division.zip
$ unzip places-dictionary.zip
$ unzip places.zip
$ unzip streets.zip

It is important to execute following commands in the given order:

$ cd project
$ symfony console doctrine:schema:update --force
$ symfony console doctrine:fixtures:load
$ symfony console teryt:import:territorial-division teryt/TERC.xml
$ symfony console teryt:import:places-dictionary teryt/WMRODZ.xml
$ symfony console teryt:import:places teryt/SIMC.xml
$ symfony console teryt:import:streets teryt/ULIC.xml