{"id":"ch.bfs.gebaeude_wohnungs_register","name":"GWR: Geb\u00e4udestatus","fields":[{"name":"gvol","type":"INTEGER","alias":"Geb\u00e4udevolumen [m3]","values":[null,1902,5642,853,301]},{"name":"gwaersceh1","type":"SMALLINT","alias":"Informationsquelle Heizung 1","values":[null,855,869,860,852]},{"name":"gkat","type":"SMALLINT","alias":"Geb\u00e4udekategorie","values":[1020,1030,1040,1060,1080]},{"name":"dexpdat","type":"DATETIME","alias":"Datenstand","values":["17.08.2026"]},{"name":"gastw","type":"SMALLINT","alias":"Anzahl Geschosse","values":[null,1,2,5,3]},{"name":"ggdenr","type":"SMALLINT","alias":"BFS-Gemeindenummer","values":[1008,1058,2428,2831,5397]},{"name":"weinr","type":"VARCHAR","alias":"Physische Wohnungsnummer","values":[null,[null],[null,null],[null,null,null,null,null,null,null,null,null,null],[null,null,null,null,null,null]]},{"name":"plz_plz6","type":"VARCHAR","alias":"PLZ/PLZ6","values":["4133/413300","4717/471700","6048/604800","6170/617000","6657/665700"]},{"name":"gvolnorm","type":"SMALLINT","alias":"Geb\u00e4udevolumen: Norm","values":[null,962,969,961]},{"name":"gstat","type":"SMALLINT","alias":"Geb\u00e4udestatus","values":[1004]},{"name":"esid","type":"INTEGER","alias":"Eidg. Strassenidentifikator (ESID)","values":[10009679,10175325,10175903,10184931,10245295]},{"name":"edid","type":"SMALLINT","alias":"Eidg. Eingangsidentifikator (EDID)","values":["0","1","5"]},{"name":"gwaerdath2","type":"DATETIME","alias":"Aktualisierungsdatum Heizung 2","values":["-","02.08.2021","12.12.2021","14.04.2021","16.02.2023"]},{"name":"lparz","type":"VARCHAR","alias":"Grundst\u00fccksnummer","values":["136","195","3359","785","834"]},{"name":"egrid","type":"VARCHAR","alias":"Eidg. Grundst\u00fccksidentifikator (EGRID)","values":["CH191778355946","CH380750357481","CH530291074506","CH927562320648","CH943550782841"]},{"name":"strsp","type":"VARCHAR","alias":"Sprache des Strassennamen","values":[["DE"],["FR"],["IT"]]},{"name":"gabbj","type":"SMALLINT","alias":"Abbruchjahr des Geb\u00e4udes","values":[null]},{"name":"wazim","type":"SMALLINT","alias":"Anzahl Zimmer","values":[null,[5],[3],[5,2],[5,4]]},{"name":"wabbj","type":"SMALLINT","alias":"Abbruchjahr Wohnung","values":[null,[null],[null,null],[null,null,null,null,null,null,null,null,null,null],[null,null,null,null,null,null]]},{"name":"wbauj","type":"SMALLINT","alias":"Baujahr Wohnung","values":[null,[1999],[2023,2023],[2021,2021],[1999,1999,1999,1999,1999,1999,1999,1999,1999,1999]]},{"name":"gkode","type":"FLOAT","alias":"E-Geb\u00e4udekoordinate","values":[2619877.608,2620072.217,2644306.829,2666742.413,2692281.29]},{"name":"gwaerzw2","type":"SMALLINT","alias":"W\u00e4rmeerzeuger Warmwasser 2","values":[null,7600,7620]},{"name":"gwaerdatw2","type":"DATETIME","alias":"Aktualisierungsdatum Warmwasser 2","values":["-","02.08.2021","12.12.2021","16.02.2023","29.11.2001"]},{"name":"wbez","type":"VARCHAR","alias":"Lage auf dem Stockwerk","values":[null,[null],[null,null],[null,null,null,null,null,null,null,null,null,null],[null,null,null,null,null,null]]},{"name":"gkodn","type":"FLOAT","alias":"N-Geb\u00e4udekoordinate","values":[1112040.87,1200827.014,1208034.474,1245733.838,1263708.595]},{"name":"lparzsx","type":"BIGINT","alias":"Suffix der Grundst\u00fccksnummer","values":[null]},{"name":"strindx","type":"VARCHAR","alias":"Indexzeichen Strasse","values":[["Kap"],["Kru"],["Lim"],["Obe"],["Sci"]]},{"name":"dkodn","type":"FLOAT","alias":"N-Geb\u00e4udeeingangskoordinate","values":[1112042.257,1200827.362,1208034.607,1245738.038,1263712.256]},{"name":"wexpdat","type":"DATETIME","alias":"Datenstand","values":[null,["2026-08-17T00:00:00"],["2026-08-17T00:00:00","2026-08-17T00:00:00"],["2026-08-17T00:00:00","2026-08-17T00:00:00","2026-08-17T00:00:00","2026-08-17T00:00:00","2026-08-17T00:00:00","2026-08-17T00:00:00","2026-08-17T00:00:00","2026-08-17T00:00:00","2026-08-17T00:00:00","2026-08-17T00:00:00"],["2026-08-17T00:00:00","2026-08-17T00:00:00","2026-08-17T00:00:00","2026-08-17T00:00:00","2026-08-17T00:00:00","2026-08-17T00:00:00"]]},{"name":"gbaum","type":"SMALLINT","alias":"Baumonat des Geb\u00e4udes","values":[null,2,3,12,9]},{"name":"dplz4","type":"SMALLINT","alias":"Postleitzahl","values":[4133,4717,6048,6170,6657]},{"name":"gdekt","type":"VARCHAR","alias":"Kantonsk\u00fcrzel","values":["BL","LU","SO","SZ","TI"]},{"name":"dplzz","type":"SMALLINT","alias":"Postleitzahl-Zusatzziffer","values":[0,1,2,3,5]},{"name":"wmehrg","type":"SMALLINT","alias":"Mehrgeschossige Wohnung","values":[null,[1],[1,0],[0,0],[0]]},{"name":"ltyp","type":"SMALLINT","alias":"Typ des Grundst\u00fccks","values":[null]},{"name":"gebf","type":"INTEGER","alias":"Energiebezugsfl\u00e4che","values":[null,625,879,95,221]},{"name":"dkode","type":"FLOAT","alias":"E-Geb\u00e4udeeingangskoordinate","values":[2619878.399,2620061.875,2644306.805,2666742.79,2692283.86]},{"name":"egaid","type":"INTEGER","alias":"Eidg. Geb\u00e4udeadressidentifikator (EGAID)","values":[101688462,101775452,102215210,103042251,103450568]},{"name":"wstat","type":"SMALLINT","alias":"Wohnungsstatus","values":[null,[3004],[3004,3004],[3004,3004,3004,3004,3004,3004,3004,3004,3004,3004],[3004,3001]]},{"name":"gvolsce","type":"SMALLINT","alias":"Informationsquelle zum Geb\u00e4udevolumen","values":[null,869,859,857]},{"name":"gwaerzh2","type":"SMALLINT","alias":"W\u00e4rmeerzeuger Heizung 2","values":[null,7400,7420]},{"name":"dplzname","type":"VARCHAR","alias":"Ortschaft","values":["Horw","M\u00fcmliswil","Palagnedra","Pratteln","Sch\u00fcpfheim"]},{"name":"lgbkr","type":"SMALLINT","alias":"Grundbuchkreisnummer","values":[0,3,4,208,608]},{"name":"egid","type":"VARCHAR","alias":"Eidg. Geb\u00e4udeidentifikator (EGID)","values":["190494589","191551894","245056231","502131432","502363061"]},{"name":"genw1","type":"SMALLINT","alias":"Energie-/W\u00e4rmequelle Warmwasser 1","values":[null,7520,7560,7598,7530]},{"name":"ggdename","type":"VARCHAR","alias":"Gemeindename","values":["Centovalli","Horw","M\u00fcmliswil-Ramiswil","Pratteln","Sch\u00fcpfheim"]},{"name":"genh2","type":"SMALLINT","alias":"Energie-/W\u00e4rmequelle Heizung 2","values":[null,7500,7570]},{"name":"gazzi","type":"SMALLINT","alias":"Anzahl separate Wohnr\u00e4ume","values":[null,3,1]},{"name":"wstwk","type":"SMALLINT","alias":"Stockwerk","values":[null,[3100],[3102,3101],[3101,3102],[3100,3103,3102,3102,3102,3101,3101,3101,3100,3100]]},{"name":"warea","type":"SMALLINT","alias":"Wohnungsfl\u00e4che [m2]","values":[null,[100],[75],[224,101],[138]]},{"name":"strnamk","type":"VARCHAR","alias":"Kurztext Strasse","values":[["Al Scires\u00e9e"],["Kapuzinerweg"],["Krummeneichstr."],["Limmernstr."],["Obermatt"]]},{"name":"gexpdat","type":"DATETIME","alias":"Publikationsstand","values":["17.08.2026"]},{"name":"gbez","type":"VARCHAR","alias":"Name des Geb\u00e4udes","values":["","MFH mit Gewerbe","Velounterstand","Waschstrasse","\u00d6konomiegeb\u00e4ude"]},{"name":"gebnr","type":"VARCHAR","alias":"Amtliche Geb\u00e4udenummer","values":["","136a","1622a","37a","393a"]},{"name":"gwaerzw1","type":"SMALLINT","alias":"W\u00e4rmeerzeuger Warmwasser 1","values":[null,7630,7650,7610,7632]},{"name":"gwaerdath1","type":"DATETIME","alias":"Aktualisierungsdatum Heizung 1","values":["-","20.11.2020","25.07.2003","26.10.2010","29.06.2022"]},{"name":"genw2","type":"SMALLINT","alias":"Energie-/W\u00e4rmequelle Warmwasser  2","values":[null,7500,7570]},{"name":"ewid","type":"SMALLINT","alias":"Eidg. Wohnungsidentifikator (EWID)","values":[null,["1"],["1","2"],["1","2","3","4","5","6","7","8","9","10"],["1","2","3","4","5","6"]]},{"name":"genh1","type":"SMALLINT","alias":"Energie-/W\u00e4rmequelle Heizung 1","values":[null,7520,7560,7540,7598]},{"name":"gbaup","type":"SMALLINT","alias":"Bauperiode","values":[8011,8012,8013,8022,8023]},{"name":"strname_deinr","type":"VARCHAR","alias":"Strasse Nr","values":["Al Scires\u00e9e 7","Kapuzinerweg 5.1","Krummeneichstrasse 37","Limmernstrasse 236","Obermatt 1.1"]},{"name":"gksce","type":"SMALLINT","alias":"Koordinatenherkunft","values":[901,904,905,909]},{"name":"gwaerscew1","type":"SMALLINT","alias":"Informationsquelle Warmwasser 1","values":[null,855,869,860,852]},{"name":"id","type":"VARCHAR","alias":"ch.bfs.gebaeude_wohnungs_register.id","values":["190494589_0","191551894_0","245056231_0","502131432_0","502363061_0"]},{"name":"wkche","type":"SMALLINT","alias":"Kocheinrichtung","values":[null,[1],[1,1],[1,1,1,1,1,1,1,1,1,1],[1,1,1,1,1,1]]},{"name":"gwaerscew2","type":"SMALLINT","alias":"Informationsquelle Warmwasser 2","values":[null,864,860,869,852]},{"name":"garea","type":"INTEGER","alias":"Geb\u00e4udefl\u00e4che [m2]","values":[9,50,56,201,261]},{"name":"doffadr","type":"SMALLINT","alias":"Offizielle Adresse","values":[0,1]},{"name":"gwaerdatw1","type":"DATETIME","alias":"Aktualisierungsdatum Warmwasser 1","values":["-","20.11.2020","25.07.2003","26.10.2010","29.06.2022"]},{"name":"gwaerzh1","type":"SMALLINT","alias":"W\u00e4rmeerzeuger Heizung 1","values":[null,7430,7450,7436,7410]},{"name":"strname","type":"VARCHAR","alias":"Strassenbezeichnung","values":[["Al Scires\u00e9e"],["Kapuzinerweg"],["Krummeneichstrasse"],["Limmernstrasse"],["Obermatt"]]},{"name":"deinr","type":"VARCHAR","alias":"Eingangsnummer Geb\u00e4ude","values":["1.1","236","37","5.1","7"]},{"name":"gschutzr","type":"SMALLINT","alias":"Zivilschutzraum","values":[null,0,1]},{"name":"gbauj","type":"SMALLINT","alias":"Baujahr des Geb\u00e4udes","values":[1905,1923,1960,2014,null]},{"name":"gklas","type":"SMALLINT","alias":"Geb\u00e4udeklasse","values":[1110,1251,1271,1272,1274]},{"name":"stroffiziel","type":"VARCHAR","alias":"Strassenbezeichnung offiziell","values":["0","1"]},{"name":"ganzwhg","type":"SMALLINT","alias":"Anzahl Wohnungen","values":[null,1,2,10,6]},{"name":"whgnr","type":"VARCHAR","alias":"Administrative WohnungsNr","values":[null,[null],[null,null],[null,null,null,null,null,null,null,null,null,null],["1"]]},{"name":"gwaersceh2","type":"SMALLINT","alias":"Informationsquelle Heizung 2","values":[null,864,869,852,855]}]}