Project

General

Profile

Actions

Feature #575

closed

Administrative Units

Added by Alexander Watzinger about 9 years ago. Updated over 6 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
Backend
Target version:
-
Start date:
2015-11-12
Estimated time:

Description

Needed data from geographers

- define needed depth, e.g. for Austria Katastralgemeinde, it doesn't matter if different depths for different regions
- all data in one table like the Austrian example one we already received:

columns: id, parent_id,    name,     type,  code,  the_geom
    e.g.  4,       204, Ferlach, Gemeinde, 20405, 010300...

- root elements e.g. austria have no parent_id
- no multiple inheritance (parents)
- country specific typehierachy for admin units (e.g. for Austria: city, katastralgemeinde, ...) implement with E53 -> P2 -> E55

To do

- get administrative units with coordinates
- how to distinguish these units from other (user entered) place entites (use type?)
- dpp and medcon
- editable? and if how to?
- import them to database
- implement in UI

How to import attached file AT_admin.backup

createdb units_austria
psql -d units_austria -c 'CREATE EXTENSION postgis;'
pg_restore --verbose --clean --no-acl --no-owner -d units_austria AT_admin.backup

For some reason I have to run the pg_restore a second time to import without errors.


Files

AT_admin.backup (5.83 MB) AT_admin.backup Alexander Watzinger, 2016-02-19 17:03
Actions

Also available in: Atom PDF