database-obmbuildings issueshttps://git.gfz-potsdam.de/globaldynamicexposure/openbuildingmap/database-obmbuildings/-/issues2023-01-10T16:11:56+01:00https://git.gfz-potsdam.de/globaldynamicexposure/openbuildingmap/database-obmbuildings/-/issues/1Add back building attributes as they are being built-up2023-01-10T16:11:56+01:00Felix DelattreAdd back building attributes as they are being built-upThe building attributes of the legacy database are:
```
column_name | data_type
-----------------+-----------------------------
osm_id | bigint
z_order | integer
geometry | geometry(Geo...The building attributes of the legacy database are:
```
column_name | data_type
-----------------+-----------------------------
osm_id | bigint
z_order | integer
geometry | geometry(Geometry,900913)
building | text
building_use | text
building_levels | text
amenity | text
occupancy | text
position | text
floor_space | double precision
last_modified | timestamp without time zone
area | double precision
```
Let's add them back, one by one as we need them (have a `rabotnik` rule that populates them).
\fyi @cnievas @ds @marius @nicgarhttps://git.gfz-potsdam.de/globaldynamicexposure/openbuildingmap/database-obmbuildings/-/issues/2Add field for occupancy2021-08-16T16:34:56+02:00Marius Kriegerowskimarius@gfz-potsdam.deAdd field for occupancyDepends on !6
\cc @fd @prehn @cnievasDepends on !6
\cc @fd @prehn @cnievashttps://git.gfz-potsdam.de/globaldynamicexposure/openbuildingmap/database-obmbuildings/-/issues/6Add last_update trigger2023-02-14T11:23:43+01:00Laurens OostwegelAdd last_update triggerLaurens OostwegelLaurens Oostwegelhttps://git.gfz-potsdam.de/globaldynamicexposure/openbuildingmap/database-obmbuildings/-/issues/4Build docker artifact2023-01-10T16:14:03+01:00Marius Kriegerowskimarius@gfz-potsdam.deBuild docker artifactRun the migrations and provide a dockerized staging artifact. Will be very helpful for testing against the actual database structure.Run the migrations and provide a dockerized staging artifact. Will be very helpful for testing against the actual database structure.Marius Kriegerowskimarius@gfz-potsdam.deMarius Kriegerowskimarius@gfz-potsdam.dehttps://git.gfz-potsdam.de/globaldynamicexposure/openbuildingmap/database-obmbuildings/-/issues/3Follow-up from "Draft: Added ci" - Add sql linter2021-10-25T12:22:59+02:00Marius Kriegerowskimarius@gfz-potsdam.deFollow-up from "Draft: Added ci" - Add sql linterThe following discussion from !6 should be addressed:
- [ ] @fd started a [discussion](https://git.gfz-potsdam.de/dynamicexposure/openbuildingmap/database-obmbuildings/-/merge_requests/6#note_73928): (+3 comments)
> I looked into ...The following discussion from !6 should be addressed:
- [ ] @fd started a [discussion](https://git.gfz-potsdam.de/dynamicexposure/openbuildingmap/database-obmbuildings/-/merge_requests/6#note_73928): (+3 comments)
> I looked into the errors of `sqlfluff` and it seems to me that there is something wrong with this linter :cry: it seems to get basic things in Postgres' SQL pretty wrong :thumbsdown:https://git.gfz-potsdam.de/globaldynamicexposure/openbuildingmap/database-obmbuildings/-/issues/5Introduce Laurens to obmbuildings2022-06-28T16:54:00+02:00Lars LingnerIntroduce Laurens to obmbuildings- [] get access
- [] show code
- [] make documentation- [] get access
- [] show code
- [] make documentationLars LingnerLars Lingner