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 #1

Updated by Alexander Watzinger almost 9 years ago

  • Target version changed from 1.2.0 to 78
Actions #2

Updated by Alexander Watzinger almost 9 years ago

  • Subject changed from Administrative Units to Administrative Units (on hold - waiting for geo data)
  • Description updated (diff)
Actions #3

Updated by Alexander Watzinger almost 9 years ago

  • Target version changed from 78 to Wishlist
Actions #4

Updated by Alexander Watzinger almost 9 years ago

  • Subject changed from Administrative Units (on hold - waiting for geo data) to Administrative Units
  • Description updated (diff)
Actions #5

Updated by Alexander Watzinger almost 9 years ago

  • Target version changed from Wishlist to 88
Actions #6

Updated by Alexander Watzinger almost 9 years ago

Actions #7

Updated by Alexander Watzinger over 8 years ago

  • Description updated (diff)
Actions #8

Updated by Alexander Watzinger over 8 years ago

  • Description updated (diff)
Actions #9

Updated by Alexander Watzinger over 8 years ago

  • Target version changed from 88 to Wishlist
Actions #10

Updated by Alexander Watzinger almost 8 years ago

  • Category changed from Maps to Backend
  • Status changed from Assigned to Acknowledged
  • Assignee deleted (Stefan Eichert)
Actions #11

Updated by Alexander Watzinger over 6 years ago

  • Status changed from Acknowledged to Rejected

Closing ticket as rejected because we never received geografic data. Can be reopened if data should be available.

Actions #12

Updated by Alexander Watzinger over 6 years ago

  • Target version deleted (Wishlist)
Actions

Also available in: Atom PDF