...
Attribuut | Type (bold = index) | Berekening / Filtering | Opmerkingen / voorbeeld |
|---|---|---|---|
ID | varchar (PK) | GUID zone-[occurence ID] | |
URI | varchar |
| |
zoneId | varchar | GUID zone |
|
geometry | Geometry (MultiPolygon) | MobilityHindranceZone | |
pointOnSurface | Geometry (Point) | ||
zoneType | varchar | Label | |
zoneTypeId | varchar |
| |
consequences | text | Regel per consequence | |
hindranceGipodId | integer | Vanaf hier allemaal attributen van hinder | |
hindranceURI |
| ||
hindranceConsequenceOf | text | regel per concequenceOf | |
hindranceDescription | text | ||
hindranceOwner | varchar | Label | |
hindranceOwnerId | varchar | Link naar organisatie | |
hindranceContactorganisations | Enkel publieke contactgegevens Als tekst, 1 regel per contactgegeven: Rol: Organisatie, Naam, E-mail, Telefoon, URL | ||
hindranceStart | datetime | ||
hindranceEnd | datetime | ||
hindranceStatus | varchar | Label | |
hindranceStatusId | varchar | Taxonomie | |
hindranceCreatedOn | datetime | ||
hindranceLastModified | datetime | ||
hindranceOsloJson | JSON | Oslo detail hinder (zonder niet-publieke informatie) | Referenties (taxonomie, …) verwijzen naar absolute url’s onder https://private-api.gipod.vlaanderen.be/api/v1/… Zie bovenste tabel |
hindranceZoneOsloJson | JSON | Oslo detail hinderZone |
...
HinderZoneConsequence
Attribuut | Type (bold = index) | Berekening / Filtering | Opmerkingen / voorbeeld |
|---|---|---|---|
ID | varchar (PK) | GUID zone-consequenceId-[occurence 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) | |
hindranceStatus | varchar | Label | |
hindranceStatusId | varchar |
| |
hindranceCreatedOn | datetime | ||
hindranceLastModified | datetime | ||
hindranceOsloJson | JSON | Oslo detail van hinder (zonder niet-publieke informatie) | Referenties (taxonomie, …) verwijzen naar absolute url’s onder https://private-api.gipod.vlaanderen.be/api/v1/… Zie bovenste tabel |
hindranceZoneOsloJson | JSON | Oslo detail hinderZone |
...