include Dresden boroughs into Colouring Dresden platform

[traveller195]

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 https://github.com/colouring-cities/colouring-core/issues/1102

[traveller195]

see https://github.com/colouring-cities/colouring-core/issues/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]

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]

in geojson (not in database table) boroughs were changed https://github.com/colouring-cities/colouring-dresden/commit/c42cead9092f7d3061693672cbd1653967e11c0f

[traveller195]

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