Combining data from ch.bfs.gebaeude_wohnungs_register with ÖREB-Themen

[Dmitry K]

Hello,

I am trying to combine data for future analysis.

First dataset is actual buildings details, e.g. https://api3.geo.admin.ch/rest/services/swisstopo/MapServer/ch.bfs.gebaeude_wohnungs_register/158048_0/extendedHtmlPopup?lang=en

And second dataset is probably ÖREB-Kataster - where building requirements/limitations defined per plot, e.g. Max allowed height of building, max area of house, max volume of house etc. However, I failed to find corresponding map on map.geo.admin.ch or in layers list https://api3.geo.admin.ch/api/faq/index.html#which-layers-are-available
for second dataset.

I suppose second dataset provided per canton, as I've managed to find it on maps.zh.ch However, extra difficulty at the moment - there is no connection between first dataset and second dataset. After investigation, I came to conclusion that data must be interconnected via coordinates on a map.
first dataset has GKODE, GKODN fields,

and second dataset has Geometrie field with type POINT or CURVEPOLYGON - depending on a table.

But I've stuck with understanding how to match it one to another. May be i miss something?

I am trying to do this task using direct access to databases, because it is needed to analyze a lot of data and it can take ages via API.

[Pasquale Di Donato]

Dear Dmitry,

Assuming your use case is to identify which public law restritions on landownership apply to a building of interest and that your working area is the canton of ZU, a possible way to proceed is as follows:

1) Instead of https://api3.geo.admin.ch/rest/services/swisstopo/MapServer/ch.bfs.gebaeude_wohnungs_register/158048_0/extendedHtmlPopup?lang=en you could use the following request:  https://api3.geo.admin.ch/rest/services/swisstopo/MapServer/ch.bfs.gebaeude_wohnungs_register/158048_0 which will give you a json file back. In the json file you'll find an attribute "egrid"

2) Read the value of the "egrid" attribute and call the ÖREB service of the canton ZU: https://maps.zh.ch/oereb/v2/extract/json/?EGRID=CH567799912157, which will give you a json file of the restrictions back (json schema is here: https://schemas.geo.admin.ch/V_D/OeREB/2.0/extractdata.json) 

Hope this help,

Pasquale

[Dmitry K]

Hello, Pasquale.

Thank you very much for the links!

First one is really good! I've noticed API response has even more data than popup page.
e.g. gvolnorm and gvolsce

I've checked the second one, and managed to find there AreaShare value, 

however, there are still missed Nutzungsziffer and Gebäudehöhe values.

That values displayed on a map view.

Best regards,
Dmitry.