Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

include Dresden boroughs into Colouring Dresden platform #23

Closed
traveller195 opened this issue Feb 18, 2023 · 4 comments
Closed

include Dresden boroughs into Colouring Dresden platform #23

traveller195 opened this issue Feb 18, 2023 · 4 comments

Comments

@traveller195
Copy link
Contributor

The aim is to show boroughs of the city of Dresden in the Colouring Dresden platform

  • take 'Stadtteile' from Dresden and put it as .geojson and also hardcoded into 'geometries' db table ...
  • to show those boundaries in the map and to use it perhaps for analysis in the planning section

see colouring-cities/colouring-core#1102

@traveller195
Copy link
Contributor Author

see colouring-cities/colouring-core#1102

my plan is now, to:

  1. remove the London borough data from 'geometries' table
  2. insert building geometries from temp table into 'geometries' table
  3. prepare city borough data from Dresden https://opendata.dresden.de/informationsportal/#app/mainpage//stadtteile for both db table 'geometries' and 'external_data_borough_boundary'
  4. insert borough in those both tables

@traveller195
Copy link
Contributor Author

traveller195 commented Feb 20, 2023

first delete London borough geometries from both tables. Care about the order, because of references/ foreign key:

DELETE FROM public.external_data_borough_boundary;

DELETE FROM public.geometries;

so, now the geometries table is clean to input the initial building geometries.
Afterwards, I can insert the Dresden borough data...

@traveller195
Copy link
Contributor Author

in geojson (not in database table) boroughs were changed c42cead

@traveller195
Copy link
Contributor Author

should be okay now. in Database it is more for planning section / category, so it should be updated in the future, if also city boroughs are relevant there

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant