Bussiness case
...
Attribuut | Type (bold = zoekbaar) | Berekening / Filtering | Opmerkingen / voorbeeld |
---|---|---|---|
ID | varchar (PK) | gipodId-[occurrence ID] | [GipodID]-YYMMDDHHMM |
gipodId | integer | ||
URI | varchar |
| |
geometry | Geometry (MultiPolygon) | Unie van inname zones
| |
pointOnSurface | Geometry (Point) | enkel voor WMS | |
description | |||
reference | |||
type | varchar | Label (Werk / Evenement / grondwerk) | |
typeId | varchar | | |
publicDomainOccupancyTypes | text | Puntkomma separated types | Type1; Type2 |
status | varchar | Enkel innames met status: concreet gepland, in uitvoering, lopende | |
statusId | varchar | Verwijziging naar taxonomie | |
start | datetime (UTC) | ||
end | datetime (UTC) | ||
timeSchedule (basis tekstje) | text | Tonen zoals in huidige WMS (wederkerigheid)
| |
owner | varchar | ||
ownerId | varchar |
| |
contactOrganisations | text | Als tekst, 1 regel per contactgegevengescheiden door puntkomma: Rol: Organisatie, Naam, E-mail, Telefoon, URL;Rol2: Organisatie, Naam, E-mail, Telefoon, URL;Te bekijken of dit wel de goeie oplossing is, splitsen in regels vs comma separated, … | |
mobilityHindrances (❗ aangepast, was consequences) | text | Puntkomma separated per hinder die gevolg is van deze inname |
|
groundworkCategory | varchar | Enkel bij grondwerken, anders null | |
groundworkCategoryId | varchar |
| |
groundworkSpecification | text | Puntkomma separated specificatie | |
groundworkPartOfTrenchSynergy | text | Puntkomma separated Ssyn | |
createdOn | datetime | ||
lastModifiedOn | datetime |
...
Attribuut | Type (bold = index) | Berekening / Filtering | Opmerkingen / voorbeeld |
---|---|---|---|
ID | varchar (PK) | GUID zone-[occurrence ID] | |
URI | varchar |
| |
zoneId | varchar | GUID zone |
|
geometry | Geometry (MultiPolygon) | MobilityHindranceZone | |
pointOnSurface | Geometry (Point) | enkel voor WMS | |
zoneType | varchar | Label | |
zoneTypeId | varchar |
| |
consequences | text | Puntkomma separated per consequence | |
hindranceGipodId | integer | Vanaf hier allemaal attributen van hinder | |
hindranceURI |
| ||
hindranceConsequenceOf | text | Puntkomma separated per concequenceOf | |
hindranceDescription | text | ||
hindranceOwner | varchar | Label | |
hindranceOwnerId | varchar | Link naar organisatie | |
hindranceContactorganisations | Enkel publieke contactgegevensAls tekst, 1 regel per contactgegeven, gescheiden door puntkomma, als tekst: Rol: Organisatie, Naam, E-mail, Telefoon, URLoliver.may verder te bekijken (zie ook inname) | ||
hindranceStart | datetime | ||
hindranceEnd | datetime | ||
hindranceStatus | varchar | Label | |
hindranceStatusId | varchar | Taxonomie | |
hindranceCreatedOn | datetime | ||
hindranceLastModified | datetime |
...
Attribuut | Type (bold = index) | Berekening / Filtering | Opmerkingen / voorbeeld | |||||
---|---|---|---|---|---|---|---|---|
ID | varchar (PK) | GUID zone-consequenceId-[occurrence ID] | ||||||
URI | varchar |
| ||||||
zoneId | varchar |
| ||||||
geometry | Geometry (MultiPolygon) | MobilityHindranceZone | ||||||
pointOnSurface | Geometry (Point) | |||||||
zoneType | varchar | Label | ||||||
zoneTypeId | varchar |
| ||||||
consequence | varchar | Leaf uit consequence taxonomie boom | Label | |||||
consequenceTreeLevel0 | varchar | Niveau 0 in de consequence taxonomie boom | vb. “Gemotoriseerd verkeer” | |||||
consequenceTreeLevel1 | varchar | Niveau 1 in de consequence taxonomie boom (of null) | vb. “Hoogtebeperking” | |||||
consequenceTreeLevel2 | varchar | Niveau 2 in de consequence taxonomie boom (of null) | vb. “Max x m hoogte” | |||||
consequenceTreeLevel3 | varchar | Niveau 3 in de consequence taxonomie boom (of null) | vb. “Hoogtebeperking: max 2,5 m” | |||||
consequenceId | varchar | Id Leaf uit consequence taxonomie boom | ||||||
consequenceTreeLevel0Id | varchar | Id Niveau 0 in de consequence taxonomie boom | ||||||
consequenceTreeLevel1Id | varchar | Id Niveau 1 in de consequence taxonomie boom (of null) | ||||||
consequenceTreeLevel2Id | varchar | Id Niveau 2 in de consequence taxonomie boom (of null) | ||||||
consequenceTreeLevel3Id | varchar | Id Niveau 3 in de consequence taxonomie boom (of null) | ||||||
hindranceGipodId | integer | Vanaf hier allemaal attributen van hinder | ||||||
hindranceURI |
| |||||||
hindranceStatus | varchar | Label | ||||||
hindranceStatusId | varchar |
| ||||||
hindranceCreatedOn | datetime | |||||||
hindranceLastModified | datetime | hindranceGipodId | integer | Vanaf hier allemaal attributen van hinder | hindranceURI |
|
Datalagen WFS / API Features
...
Inname occurrence
point on surfaceInname occurrencemultipolygoon
Mobiliteitshinder
Mobiliteitshinder occurrence
point on surfaceMobiliteitshinder occurrencemultipolygoon
Mobiliteitshindergevolg
Mobiliteitshindergevolg occurrence point on surfaceMobiliteitshindergevolg occurrence multipolygoon