{"id":"ch.bfs.gebaeude_wohnungs_register","name":"GWR: Geb\u00e4udestatus","fields":[{"name":"whgnr","type":"VARCHAR","alias":"Administrative WohnungsNr","values":[["282_1"],[null],null,[null,null,null,null,null,null,null,null],["1","2","3","101","102","103","201","202","203","301","302","303","401","402","403"]]},{"name":"lparzsx","type":"BIGINT","alias":"Suffix der Grundst\u00fccksnummer","values":[null]},{"name":"gwaerscew1","type":"SMALLINT","alias":"Informationsquelle Warmwasser 1","values":[855,860,864,869,null]},{"name":"gwaerdatw1","type":"DATETIME","alias":"Aktualisierungsdatum Warmwasser 1","values":["01.02.2013","10.06.2013","20.12.2023","21.01.2025","29.11.2001"]},{"name":"id","type":"VARCHAR","alias":"ch.bfs.gebaeude_wohnungs_register.id","values":["11135362_0","191066952_0","191125915_0","191996012_0","558074_0"]},{"name":"strname","type":"VARCHAR","alias":"Strassenbezeichnung","values":[["Ausserb\u00e4chlen"],["Dorfmattenstrasse"],["Grabenstrasse"],["Herisauerstrasse"],["Via Goiro"]]},{"name":"gazzi","type":"SMALLINT","alias":"Anzahl separate Wohnr\u00e4ume","values":[null,8,1]},{"name":"gastw","type":"SMALLINT","alias":"Anzahl Geschosse","values":[2,null,3,1,6]},{"name":"genh1","type":"SMALLINT","alias":"Energie-/W\u00e4rmequelle Heizung 1","values":[7500,7520,7530,7598,7599]},{"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,null,null,null,null,null],[null,null]]},{"name":"gvol","type":"INTEGER","alias":"Geb\u00e4udevolumen [m3]","values":[null,6357,483,815,58823]},{"name":"dplzname","type":"VARCHAR","alias":"Ortschaft","values":["Cadro","Gossau SG","H\u00e4gglingen","Oey","Studen BE"]},{"name":"gexpdat","type":"DATETIME","alias":"Publikationsstand","values":["03.04.2026"]},{"name":"gwaerzw2","type":"SMALLINT","alias":"W\u00e4rmeerzeuger Warmwasser 2","values":[null,7600]},{"name":"gschutzr","type":"SMALLINT","alias":"Zivilschutzraum","values":[null,0,1]},{"name":"gvolnorm","type":"SMALLINT","alias":"Geb\u00e4udevolumen: Norm","values":[null,962]},{"name":"ggdenr","type":"SMALLINT","alias":"BFS-Gemeindenummer","values":[749,762,3443,4068,5192]},{"name":"gwaerscew2","type":"SMALLINT","alias":"Informationsquelle Warmwasser 2","values":[null,860,865,869,864]},{"name":"edid","type":"SMALLINT","alias":"Eidg. Eingangsidentifikator (EDID)","values":["0","1","6"]},{"name":"wexpdat","type":"DATETIME","alias":"Datenstand","values":[["2026-04-03T00:00:00"],null,["2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00"],["2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00","2026-04-03T00:00:00"],["2026-04-03T00:00:00","2026-04-03T00:00:00"]]},{"name":"wstwk","type":"SMALLINT","alias":"Stockwerk","values":[[3100],null,[3100,3100,3100,3101,3101,3101,3102,3102],[3100,3100,3100,3101,3101,3101,3102,3102,3102,3103,3103,3103,3104,3104,3104],[3102,3101]]},{"name":"dplzz","type":"SMALLINT","alias":"Postleitzahl-Zusatzziffer","values":[0,2,3,5,21]},{"name":"gvolsce","type":"SMALLINT","alias":"Informationsquelle zum Geb\u00e4udevolumen","values":[null,859,869]},{"name":"egid","type":"VARCHAR","alias":"Eidg. Geb\u00e4udeidentifikator (EGID)","values":["11135362","191066952","191125915","191996012","558074"]},{"name":"wkche","type":"SMALLINT","alias":"Kocheinrichtung","values":[[1],null,[1,1,1,1,1,1,1,1],[1,1,1,1,1,1,1,1,1,1,1,1,1,1,1],[1,1]]},{"name":"gkodn","type":"FLOAT","alias":"N-Geb\u00e4udekoordinate","values":[1100356.684,1166109.589,1217844.808,1248839.417,1252903.381]},{"name":"lparz","type":"VARCHAR","alias":"Grundst\u00fccksnummer","values":["1110","1114","365","656","67"]},{"name":"gkode","type":"FLOAT","alias":"E-Geb\u00e4udekoordinate","values":[2589880.845,2611238.487,2661100.354,2719613.298,2736677.933]},{"name":"egrid","type":"VARCHAR","alias":"Eidg. Grundst\u00fccksidentifikator (EGRID)","values":["CH210709029364","CH487115508731","CH556246193558","CH796478953665","CH857021779324"]},{"name":"gkat","type":"SMALLINT","alias":"Geb\u00e4udekategorie","values":[1020,1030,1040,1060,1080]},{"name":"gebf","type":"INTEGER","alias":"Energiebezugsfl\u00e4che","values":[null,1910,92,140,126]},{"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]]},{"name":"warea","type":"SMALLINT","alias":"Wohnungsfl\u00e4che [m2]","values":[[120],[177],null,[126,104,126,126,104,126,126,126],[81]]},{"name":"gebnr","type":"VARCHAR","alias":"Amtliche Geb\u00e4udenummer","values":["","1481","261WO02515","360","656a"]},{"name":"gstat","type":"SMALLINT","alias":"Geb\u00e4udestatus","values":[1001,1004]},{"name":"gksce","type":"SMALLINT","alias":"Koordinatenherkunft","values":[901,904,905,909]},{"name":"deinr","type":"VARCHAR","alias":"Eingangsnummer Geb\u00e4ude","values":["1","16","32a","39a","45.2"]},{"name":"ggdename","type":"VARCHAR","alias":"Gemeindename","values":["Diemtigen","Gossau (SG)","H\u00e4gglingen","Lugano","Studen (BE)"]},{"name":"gabbj","type":"SMALLINT","alias":"Abbruchjahr des Geb\u00e4udes","values":[null]},{"name":"gbauj","type":"SMALLINT","alias":"Baujahr des Geb\u00e4udes","values":[null,1919,2013,1950,2016]},{"name":"genw1","type":"SMALLINT","alias":"Energie-/W\u00e4rmequelle Warmwasser 1","values":[7500,7510,7530,7560,7598]},{"name":"wbauj","type":"SMALLINT","alias":"Baujahr Wohnung","values":[[1999],null,[2013,2013,2013,2013,2013,2013,2013,2013],[null],[2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016]]},{"name":"gbaum","type":"SMALLINT","alias":"Baumonat des Geb\u00e4udes","values":[null,5,10,7,9]},{"name":"gwaerdath1","type":"DATETIME","alias":"Aktualisierungsdatum Heizung 1","values":["10.06.2013","21.01.2025","21.03.2019","29.11.2001","31.12.2023"]},{"name":"ltyp","type":"SMALLINT","alias":"Typ des Grundst\u00fccks","values":[null]},{"name":"gwaersceh2","type":"SMALLINT","alias":"Informationsquelle Heizung 2","values":[null,865,869,860,864]},{"name":"egaid","type":"INTEGER","alias":"Eidg. Geb\u00e4udeadressidentifikator (EGAID)","values":[100396227,101561906,101885042,102217689,103353433]},{"name":"strname_deinr","type":"VARCHAR","alias":"Strasse Nr","values":["Ausserb\u00e4chlen 32a","Dorfmattenstrasse 16","Grabenstrasse 39a","Herisauerstrasse 45.2","Via Goiro 1"]},{"name":"ganzwhg","type":"SMALLINT","alias":"Anzahl Wohnungen","values":[1,null,8,15,2]},{"name":"doffadr","type":"SMALLINT","alias":"Offizielle Adresse","values":[0,1]},{"name":"dplz4","type":"SMALLINT","alias":"Postleitzahl","values":[2557,3753,5607,6965,9200]},{"name":"gbaup","type":"SMALLINT","alias":"Bauperiode","values":[8012,8013,8017,8022,null]},{"name":"gwaerdatw2","type":"DATETIME","alias":"Aktualisierungsdatum Warmwasser 2","values":["-","10.06.2013","27.09.2025","29.11.2001","30.11.2020"]},{"name":"garea","type":"INTEGER","alias":"Geb\u00e4udefl\u00e4che [m2]","values":[73,105,130,313,382]},{"name":"gbez","type":"VARCHAR","alias":"Name des Geb\u00e4udes","values":["","Kelleranlage","Neubau Einfamilienhaus","Stall","unterirdisches_Gebaeude"]},{"name":"wmehrg","type":"SMALLINT","alias":"Mehrgeschossige Wohnung","values":[[1],null,[0,0,0,0,0,0,0,0],[0],[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]]},{"name":"wazim","type":"SMALLINT","alias":"Anzahl Zimmer","values":[[4],null,[4,3,4,4,3,4,4,4],[3],[2,3,3,4,3,4,4,3,4,4,3,4,2,2,3]]},{"name":"gwaerzh2","type":"SMALLINT","alias":"W\u00e4rmeerzeuger Heizung 2","values":[null,7400]},{"name":"dkodn","type":"FLOAT","alias":"N-Geb\u00e4udeeingangskoordinate","values":[1100354.447,1166112.797,1217849.519,1248839.592,1252903.387]},{"name":"wstat","type":"SMALLINT","alias":"Wohnungsstatus","values":[[3004],null,[3004,3004,3004,3004,3004,3004,3004,3004],[3001],[3004,3004,3004,3004,3004,3004,3004,3004,3004,3004,3004,3004,3004,3004,3004]]},{"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","10","11","12","13","14","15"],["1","2"]]},{"name":"esid","type":"INTEGER","alias":"Eidg. Strassenidentifikator (ESID)","values":[10062446,10070185,10135781,10149924,10192013]},{"name":"genh2","type":"SMALLINT","alias":"Energie-/W\u00e4rmequelle Heizung 2","values":[null,7500]},{"name":"strsp","type":"VARCHAR","alias":"Sprache des Strassennamen","values":[["DE"],["FR"],["IT"]]},{"name":"stroffiziel","type":"VARCHAR","alias":"Strassenbezeichnung offiziell","values":["1"]},{"name":"gwaerzh1","type":"SMALLINT","alias":"W\u00e4rmeerzeuger Heizung 1","values":[7400,7410,7430,7431,7434]},{"name":"gwaersceh1","type":"SMALLINT","alias":"Informationsquelle Heizung 1","values":[855,860,864,869,null]},{"name":"genw2","type":"SMALLINT","alias":"Energie-/W\u00e4rmequelle Warmwasser  2","values":[null,7500]},{"name":"lgbkr","type":"SMALLINT","alias":"Grundbuchkreisnummer","values":[0,3,16,280,4068]},{"name":"dexpdat","type":"DATETIME","alias":"Datenstand","values":["03.04.2026"]},{"name":"dkode","type":"FLOAT","alias":"E-Geb\u00e4udeeingangskoordinate","values":[2589884.651,2611237.488,2661097.765,2719611.539,2736677.932]},{"name":"strindx","type":"VARCHAR","alias":"Indexzeichen Strasse","values":[["Aus"],["Dor"],["Goi"],["Gra"],["Her"]]},{"name":"wbez","type":"VARCHAR","alias":"Lage auf dem Stockwerk","values":[[null],null,["Links","Mitte","Rechts","Links","Mitte","Rechts","Links","Rechts"],["SUED"],[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]]},{"name":"gdekt","type":"VARCHAR","alias":"Kantonsk\u00fcrzel","values":["AG","BE","SG","TI","VS"]},{"name":"gklas","type":"SMALLINT","alias":"Geb\u00e4udeklasse","values":[1110,1122,1251,1271,1272]},{"name":"strnamk","type":"VARCHAR","alias":"Kurztext Strasse","values":[["Ausserb\u00e4chlen"],["Dorfmattenstr."],["Grabenstr."],["Herisauerstr."],["Via Goiro"]]},{"name":"gwaerdath2","type":"DATETIME","alias":"Aktualisierungsdatum Heizung 2","values":["-","10.06.2013","13.07.2015","27.09.2025","29.11.2001"]},{"name":"plz_plz6","type":"VARCHAR","alias":"PLZ/PLZ6","values":["2557/255700","3753/375300","5607/560700","6965/696500","9200/920000"]},{"name":"gwaerzw1","type":"SMALLINT","alias":"W\u00e4rmeerzeuger Warmwasser 1","values":[7600,7610,7630,7650,7699]}]}