{"id":"ch.bfs.gebaeude_wohnungs_register","name":"GWR: Geb\u00e4udestatus","fields":[{"name":"lgbkr","type":"SMALLINT","alias":"Grundbuchkreisnummer","values":[0,13,20,280,6796]},{"name":"gebf","type":"INTEGER","alias":"Energiebezugsfl\u00e4che","values":[320,null,972,942,221]},{"name":"gvolsce","type":"SMALLINT","alias":"Informationsquelle zum Geb\u00e4udevolumen","values":[859,null,869,857,853]},{"name":"ltyp","type":"SMALLINT","alias":"Typ des Grundst\u00fccks","values":[null]},{"name":"strnamk","type":"VARCHAR","alias":"Kurztext Strasse","values":[["Ch. de l'Ormet"],["Niederhaus"],["Rte du Prieur\u00e9"],["Schlipfweg"],["Schulhausstr."]]},{"name":"ganzwhg","type":"SMALLINT","alias":"Anzahl Wohnungen","values":[1,null,8,13,6]},{"name":"genh1","type":"SMALLINT","alias":"Energie-/W\u00e4rmequelle Heizung 1","values":[7500,7501,7540,null,7598]},{"name":"dkodn","type":"FLOAT","alias":"N-Geb\u00e4udeeingangskoordinate","values":[1152315.0,1201949.667,1225692.347,1259488.094,1271396.402]},{"name":"lparz","type":"VARCHAR","alias":"Grundst\u00fccksnummer","values":["1032","121","1462","266","743"]},{"name":"gschutzr","type":"SMALLINT","alias":"Zivilschutzraum","values":[0,null,1]},{"name":"gwaerscew2","type":"SMALLINT","alias":"Informationsquelle Warmwasser 2","values":[855,null,859,860,869]},{"name":"gbaup","type":"SMALLINT","alias":"Bauperiode","values":[8011,8012,null,8023,8013]},{"name":"wbez","type":"VARCHAR","alias":"Lage auf dem Stockwerk","values":[[null],null,["Links","Rechts","Links","Rechts","Links","Rechts","Links","Rechts"],["Est-droite","Centre-est","Est-gauche","Est-droite","Centre-est","Est-gauche","Est-gauche","Est-droite","Centre-est",null,"Est-gauche","Est-droite","Centre-est"],[null,null,null,null,null,null,null]]},{"name":"wazim","type":"SMALLINT","alias":"Anzahl Zimmer","values":[[4],null,[2,3,2,4,2,3,2,3],[2,1,3,2,1,3,3,2,1,3,3,2,1],[5]]},{"name":"doffadr","type":"SMALLINT","alias":"Offizielle Adresse","values":[0,1]},{"name":"lparzsx","type":"BIGINT","alias":"Suffix der Grundst\u00fccksnummer","values":[null]},{"name":"warea","type":"SMALLINT","alias":"Wohnungsfl\u00e4che [m2]","values":[[130],[150],null,[145],[45,70,35,90,50,75,50,75]]},{"name":"gwaerdath2","type":"DATETIME","alias":"Aktualisierungsdatum Heizung 2","values":["-","01.09.2026","14.04.2025","16.04.2025","29.11.2001"]},{"name":"gwaersceh2","type":"SMALLINT","alias":"Informationsquelle Heizung 2","values":[864,null,859,855,860]},{"name":"dplzname","type":"VARCHAR","alias":"Ortschaft","values":["Buchs SG","Ecublens VD","Montignez","Riehen","R\u00fcderswil"]},{"name":"dplz4","type":"SMALLINT","alias":"Postleitzahl","values":[1024,2924,3437,4125,9470]},{"name":"gwaerdatw2","type":"DATETIME","alias":"Aktualisierungsdatum Warmwasser 2","values":["-","01.09.2026","14.04.2025","16.04.2025","29.11.2001"]},{"name":"gdekt","type":"VARCHAR","alias":"Kantonsk\u00fcrzel","values":["BE","BS","JU","SG","VD"]},{"name":"wkche","type":"SMALLINT","alias":"Kocheinrichtung","values":[[0],[1],null,[1,1,1,1,1,1,1,1],[1,1,1,1,1,1,1,1,1,1,1,1,1]]},{"name":"gbez","type":"VARCHAR","alias":"Name des Geb\u00e4udes","values":["","Autoeinstellhalle","K\u00fchlcontainer 2","Renaissance","unterirdisches_Gebaeude"]},{"name":"wexpdat","type":"DATETIME","alias":"Datenstand","values":[["2026-09-19T00:00:00"],null,["2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00"],["2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00"],["2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00","2026-09-19T00:00:00"]]},{"name":"gwaerscew1","type":"SMALLINT","alias":"Informationsquelle Warmwasser 1","values":[855,865,869,null,859]},{"name":"strsp","type":"VARCHAR","alias":"Sprache des Strassennamen","values":[["DE"],["FR"],["IT"],["RO"]]},{"name":"gbaum","type":"SMALLINT","alias":"Baumonat des Geb\u00e4udes","values":[1,null,5,6,9]},{"name":"egaid","type":"INTEGER","alias":"Eidg. Geb\u00e4udeadressidentifikator (EGAID)","values":[100263276,100640180,103154349,103261667,103296387]},{"name":"wbauj","type":"SMALLINT","alias":"Baujahr Wohnung","values":[[1999],null,[2025],[1999,1999,1999,1999,1999,1999,1999,1999],[1999,1999,1999,1999,1999,1999,1999,1999,1999,1999,1999,1999,1999]]},{"name":"genw2","type":"SMALLINT","alias":"Energie-/W\u00e4rmequelle Warmwasser  2","values":[7500,null,7520,7598,7540]},{"name":"dexpdat","type":"DATETIME","alias":"Datenstand","values":["19.09.2026"]},{"name":"ggdenr","type":"SMALLINT","alias":"BFS-Gemeindenummer","values":[905,2703,3271,5635,6807]},{"name":"gwaersceh1","type":"SMALLINT","alias":"Informationsquelle Heizung 1","values":[855,865,869,null,859]},{"name":"garea","type":"INTEGER","alias":"Geb\u00e4udefl\u00e4che [m2]","values":[28,73,116,160,164]},{"name":"ggdename","type":"VARCHAR","alias":"Gemeindename","values":["Basse-Allaine","Buchs (SG)","Ecublens (VD)","Riehen","R\u00fcderswil"]},{"name":"gazzi","type":"SMALLINT","alias":"Anzahl separate Wohnr\u00e4ume","values":[null,1,2]},{"name":"gwaerdatw1","type":"DATETIME","alias":"Aktualisierungsdatum Warmwasser 1","values":["-","01.09.2026","12.10.2021","27.09.2025","29.11.2001"]},{"name":"ewid","type":"SMALLINT","alias":"Eidg. Wohnungsidentifikator (EWID)","values":[["1"],null,["1","2","3","4","5","6","7","8"],["1","2","3","4","5","6","7","8","9","12","13","14","15"],["9"]]},{"name":"gastw","type":"SMALLINT","alias":"Anzahl Geschosse","values":[2,null,4,6,3]},{"name":"gwaerzh1","type":"SMALLINT","alias":"W\u00e4rmeerzeuger Heizung 1","values":[7400,7410,7436,null,7430]},{"name":"strname_deinr","type":"VARCHAR","alias":"Strasse Nr","values":["Chemin de l'Ormet 35f","Niederhaus 124","Route du Prieur\u00e9 8a","Schlipfweg 22","Schulhausstrasse 8a.1"]},{"name":"id","type":"VARCHAR","alias":"ch.bfs.gebaeude_wohnungs_register.id","values":["280128965_0","459257_0","502255426_0","504138127_0","984233_0"]},{"name":"strname","type":"VARCHAR","alias":"Strassenbezeichnung","values":[["Chemin de l'Ormet"],["Niederhaus"],["Route du Prieur\u00e9"],["Schlipfweg"],["Schulhausstrasse"]]},{"name":"gabbj","type":"SMALLINT","alias":"Abbruchjahr des Geb\u00e4udes","values":[null]},{"name":"dkode","type":"FLOAT","alias":"E-Geb\u00e4udeeingangskoordinate","values":[2532401.0,2571378.919,2615371.516,2620723.728,2754089.279]},{"name":"whgnr","type":"VARCHAR","alias":"Administrative WohnungsNr","values":[["1"],[null],null,["1","2","101","102","201","202","301","302"],["203","202","301","303","302","201","101","103","102",null,"1","3","2"]]},{"name":"gwaerzw2","type":"SMALLINT","alias":"W\u00e4rmeerzeuger Warmwasser 2","values":[7600,null,7634,7699,7630]},{"name":"gwaerzh2","type":"SMALLINT","alias":"W\u00e4rmeerzeuger Heizung 2","values":[7400,null,7452,7499,7430]},{"name":"plz_plz6","type":"VARCHAR","alias":"PLZ/PLZ6","values":["1024/102400","2924/292400","3437/343700","4125/412500","9470/947000"]},{"name":"gebnr","type":"VARCHAR","alias":"Amtliche Geb\u00e4udenummer","values":["","25665","261WO01141","en_attente","n.v."]},{"name":"weinr","type":"VARCHAR","alias":"Physische Wohnungsnummer","values":[[null],null,[null,null,null,null,null,null,null,null],["202","203","301","302","303","201","101","102","103",null,"1","2","3"],[null,null,null,null,null,null,null]]},{"name":"gkat","type":"SMALLINT","alias":"Geb\u00e4udekategorie","values":[1020,1030,1040,1060,1080]},{"name":"edid","type":"SMALLINT","alias":"Eidg. Eingangsidentifikator (EDID)","values":["0","1"]},{"name":"wmehrg","type":"SMALLINT","alias":"Mehrgeschossige Wohnung","values":[[0],[1],null,[0,0,0,0,0,0,0,0],[0,0,0,0,0,0,0,0,0,0,0,0,0]]},{"name":"gwaerzw1","type":"SMALLINT","alias":"W\u00e4rmeerzeuger Warmwasser 1","values":[7610,7650,null,7630,7660]},{"name":"gkode","type":"FLOAT","alias":"E-Geb\u00e4udekoordinate","values":[2532401.78,2571374.863,2615372.559,2620725.046,2754089.42]},{"name":"egrid","type":"VARCHAR","alias":"Eidg. Grundst\u00fccksidentifikator (EGRID)","values":["CH427731896717","CH470672684482","CH708945068354","CH743546277656","CH973877788497"]},{"name":"gstat","type":"SMALLINT","alias":"Geb\u00e4udestatus","values":[1001,1002,1004]},{"name":"gkodn","type":"FLOAT","alias":"N-Geb\u00e4udekoordinate","values":[1152315.053,1201947.111,1225696.879,1259487.619,1271400.069]},{"name":"egid","type":"VARCHAR","alias":"Eidg. Geb\u00e4udeidentifikator (EGID)","values":["280128965","459257","502255426","504138127","984233"]},{"name":"gklas","type":"SMALLINT","alias":"Geb\u00e4udeklasse","values":[1110,1122,1130,1242,1278]},{"name":"wstat","type":"SMALLINT","alias":"Wohnungsstatus","values":[[3004],null,[3004,3004,3004,3004,3004,3004,3004,3004],[3004,3004,3004,3004,3004,3004,3004,3004,3004,3004,3004,3004,3004],[3004,3004,3004,3004,3004,3004,3004]]},{"name":"gvolnorm","type":"SMALLINT","alias":"Geb\u00e4udevolumen: Norm","values":[969,null,962,961]},{"name":"genh2","type":"SMALLINT","alias":"Energie-/W\u00e4rmequelle Heizung 2","values":[7500,null,7560,7599,7540]},{"name":"strindx","type":"VARCHAR","alias":"Indexzeichen Strasse","values":[["Nie"],["Orm"],["Pri"],["SCH"],["Sch"]]},{"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,null,null,null],[null,null,null,null,null,null,null]]},{"name":"wstwk","type":"SMALLINT","alias":"Stockwerk","values":[[3100],null,[3100,3100,3101,3101,3102,3102,3103,3103],[3102,3102,3103,3103,3103,3102,3101,3101,3101,3401,3100,3100,3100],[3102]]},{"name":"genw1","type":"SMALLINT","alias":"Energie-/W\u00e4rmequelle Warmwasser 1","values":[7500,7501,7560,null,7598]},{"name":"stroffiziel","type":"VARCHAR","alias":"Strassenbezeichnung offiziell","values":["0","1"]},{"name":"esid","type":"INTEGER","alias":"Eidg. Strassenidentifikator (ESID)","values":[10012083,10026596,10032634,10118031,10198029]},{"name":"gbauj","type":"SMALLINT","alias":"Baujahr des Geb\u00e4udes","values":[1925,null,1748,2025,1930]},{"name":"deinr","type":"VARCHAR","alias":"Eingangsnummer Geb\u00e4ude","values":["124","22","35f","8a","8a.1"]},{"name":"gwaerdath1","type":"DATETIME","alias":"Aktualisierungsdatum Heizung 1","values":["-","01.09.2026","12.10.2021","27.09.2025","29.11.2001"]},{"name":"dplzz","type":"SMALLINT","alias":"Postleitzahl-Zusatzziffer","values":[0,1,2,21,41]},{"name":"gvol","type":"INTEGER","alias":"Geb\u00e4udevolumen [m3]","values":[749,null,686,2250,4018]},{"name":"gexpdat","type":"DATETIME","alias":"Publikationsstand","values":["19.09.2026"]},{"name":"gksce","type":"SMALLINT","alias":"Koordinatenherkunft","values":[901,904,905,909]}]}