Improve parcel reference #139

New Issue

mpeltriaux · 2022-04-06T12:40:32+02:00

mpeltriaux commented

2022-04-06 12:40:32 +02:00

Status quo

The current implementation looks like this:

However, in a recent meeting we agreed on further details, which need to be added to such information:

Kreisschlüssel
Gemeindeschlüssel
Verbandsgemeinde
Verbandsgemeindeschlüssel

ToDo

These information might be important but the table's width would grow too much. Therefore we need to restructure this table layout and take some inspiration from the previous layout from the predecessor system:

Which means:

Add a small table above the parcel table, which holds all relevant data on Kreis, Verbandsgemeinde and Gemeinde, including their keys (Schlüssel).
Remove Kreis from parcel table

Improve WFS fetching

Currently we are not fetching any data regarding Verbandsgemeinde and keys in general. We need to extend the WFS fetching such as all this data will be persisted in the database.

Improve filtering

Holding (hopefully) persistent keys for such spatial references, we can further enhance the filtering capabilities of Kreis, Gemarkung, ... on all overview views:

If the input value is a string -> filter on the name
If the input value is an integer -> filter on key

# Status quo The current implementation looks like this: ![grafik](/attachments/4a59a338-5b0f-4ce8-b421-0dbe7114d334) However, in a recent meeting we agreed on further details, which need to be added to such information: * Kreisschlüssel * Gemeindeschlüssel * Verbandsgemeinde * Verbandsgemeindeschlüssel # ToDo These information might be important but the table's width would grow too much. Therefore we need to restructure this table layout and take some inspiration from the previous layout from the predecessor system: ![grafik](/attachments/b314ab05-4da5-4626-8f24-2b13a8dae99b) Which means: 1. Add a small table above the parcel table, which holds all relevant data on Kreis, Verbandsgemeinde and Gemeinde, including their keys (Schlüssel). 1. Remove Kreis from parcel table ## Improve WFS fetching Currently we are not fetching any data regarding Verbandsgemeinde and keys in general. We need to extend the WFS fetching such as all this data will be persisted in the database. ## Improve filtering Holding (hopefully) persistent keys for such spatial references, we can further enhance the filtering capabilities of Kreis, Gemarkung, ... on all overview views: * If the input value is a string -> filter on the name * If the input value is an integer -> filter on key

grafik.png

31 KiB

grafik.png

20 KiB

mpeltriaux added the

enhancement

label 2022-04-06 12:40:32 +02:00

mpeltriaux self-assigned this 2022-04-06 12:40:32 +02:00

mpeltriaux commented

2022-04-11 10:28:36 +02:00

Frontend layout has been updated, database models optimized and fetching code changed.

Models

Formerly District and Parcel models have been enhanced:

District
- split into District (Kreis), Municipal (Gemeinde), ParcelGroup (Gemarkung)
all models hold a key and name attribute for easier referencing

Commands

sanitize_db has been extended to clean for unused Municipals and ParcelGroups

Frontend layout has been updated, database models optimized and fetching code changed. ![grafik](/attachments/806382f6-aef3-419a-9276-334eb7b0bcce) ### Models Formerly `District` and `Parcel` models have been enhanced: * District * split into `District` (Kreis), `Municipal` (Gemeinde), `ParcelGroup` (Gemarkung) * all models hold a `key` and `name` attribute for easier referencing ### Commands * sanitize_db has been extended to clean for unused `Municipals` and `ParcelGroups`

grafik.png

38 KiB

mpeltriaux referenced this issue from a commit

2022-04-11 10:55:20 +02:00

#139 Parcel filter improved

mpeltriaux referenced this issue

2022-04-11 12:21:35 +02:00

139_Improve_parcel_reference #141

mpeltriaux commented

2022-04-11 12:22:59 +02:00