{"id":"ch.bafu.gewaesserschutz-klaeranlagen_ausbaugroesse","name":"ARA - Ausbaugr\u00f6sse (EGW)","fields":[{"name":"tel_nr","type":"VARCHAR","alias":"ch.bafu.gewaesserschutz-klaeranlagen_ausbaugroesse.tel_nr","values":[null,"244351802","244591661","244236111","277671483"]},{"name":"frischschlamm_tag","type":"INTEGER","alias":"Frischschlamm (kg/d)","values":[49,54,72,null,506]},{"name":"ort","type":"VARCHAR","alias":"Ort","values":["Evionnaz","Senarclens","Valeyres-sous-Ursins","Villars-sous-Champvent","Yverdon-les-Bains"]},{"name":"abwasseranteil_q347","type":"NUMERIC","alias":"Prozentanteil Abwasser im Vorfluter bei Niedrigwasser","values":[-9999.0,3.796,5.421,21.722,71.131]},{"name":"abw_tagesspitze","type":"INTEGER","alias":"QTW (l/s)","values":[1,2,3,80,500]},{"name":"name_vorfluter","type":"VARCHAR","alias":"Vorflutername","values":["Bey","Broye de Vullierens","Lac de Neuch\u00e2tel","Niaugue","Rh\u00f4ne"]},{"name":"andere_stoffe","type":"VARCHAR","alias":"And. Stoffe","values":[null,"Ja"]},{"name":"kanton","type":"VARCHAR","alias":"Kanton","values":["BE","GR","NE","VD","VS"]},{"name":"nabsolut","type":"INTEGER","alias":"N-Abfl.-konz","values":[null,6,15]},{"name":"vsa_kategorie","type":"VARCHAR","alias":"Reinigungstyp (VSA-Kategorie)","values":["A","B","D","E","H"]},{"name":"abw_tagesmittel","type":"INTEGER","alias":"Q24 (m3/d)","values":[138,150,225,2000,28800]},{"name":"csbabsolut","type":"INTEGER","alias":"CSB-Abfl.-konz.","values":[null,14,60,38,20]},{"name":"csbanteil","type":"INTEGER","alias":"CSB-Elimin.","values":[null,88,90,95,80]},{"name":"nh4_n_ganzjaehrig","type":"VARCHAR","alias":"NH4-N ganzj\u00e4hrig","values":[null,"Ja"]},{"name":"id","type":"INTEGER","alias":"ch.bafu.gewaesserschutz-klaeranlagen_ausbaugroesse.id","values":[549900,593400,593600,593800,621300]},{"name":"name","type":"VARCHAR","alias":"ARA-Name","values":["EVIONNAZ","SENARCLENS(SIEGS)","VALEYRES-SOUS-URSINS","VILLARS-SOUS-CHAMPVENT","YVERDON"]},{"name":"spitzenbelastung_regen","type":"INTEGER","alias":"QRW (l/s)","values":[2,4,7,80,1000]},{"name":"docabsolut","type":"INTEGER","alias":"DOC-Abfl.-konz.","values":[5,null,10,20,1]},{"name":"adresse","type":"VARCHAR","alias":"ch.bafu.gewaesserschutz-klaeranlagen_ausbaugroesse.adresse","values":["Administration communale\nMunicipalit\u00e9 de la Commune","Station d'\u00e9puration","Station d'\u00e9puration\nMichel Robert","Station d'\u00e9puration\nThierry Humbert\nAdministration communale","Station d'\u00e9puration communale"]},{"name":"nanteil","type":"INTEGER","alias":"N-Elimin.","values":[null,47,55,32,60]},{"name":"gesamtpabsolut","type":"NUMERIC","alias":"P-Abfl.-konz.","values":[1.0,null,0.0,0.80000001,0.2]},{"name":"jahr_nat_einwohner","type":"INTEGER","alias":"Erhebungsjahr der angeschlossenen Einwohner","values":[2005,null]},{"name":"gesamt_ungel_stoffe_absolut","type":"INTEGER","alias":"ungel\u00f6ste Stoffe (mg/l)","values":[20,null,10,15,5]},{"name":"docanteil","type":"INTEGER","alias":"DOC-Elimin.","values":[90,null,85,84]},{"name":"nh4_nabsolut","type":"INTEGER","alias":"NH4-N-Abfl.-konz.","values":[null,1,2,0]},{"name":"hoehe","type":"INTEGER","alias":"ch.bafu.gewaesserschutz-klaeranlagen_ausbaugroesse.hoehe","values":[431,438,447,540,544]},{"name":"ausbaugroesse_egw","type":"INTEGER","alias":"Ausbaugr\u00f6sse (EGW)","values":[683,750,900,6517,57500]},{"name":"plz","type":"INTEGER","alias":"ch.bafu.gewaesserschutz-klaeranlagen_ausbaugroesse.plz","values":[1304,1400,1412,1443,1902]},{"name":"hochwert","type":"INTEGER","alias":"ch.bafu.gewaesserschutz-klaeranlagen_ausbaugroesse.hochwert","values":[113850,160400,177415,181520,181770]},{"name":"bsb5absolut","type":"INTEGER","alias":"BSB5-Abfl-konz. (mg/l)","values":[15,18,20,null,10]},{"name":"gewiss_nr","type":"INTEGER","alias":"GEWISS-Nr","values":[95,113,3213,3223,9151]},{"name":"anzahl_nat_einwohner","type":"INTEGER","alias":"Anzahl angeschlossene Einwohner","values":[379,433,637,3744,27045]},{"name":"n_abwassertemperatur","type":"INTEGER","alias":"N-Abw.-Temp.","values":[null,10,16]},{"name":"gesamtpanteil","type":"INTEGER","alias":"P-Elimin.","values":[80,null,95,97,90]},{"name":"gwlnr","type":"VARCHAR","alias":"Gew\u00e4sserlaufnummer des Vorfluters","values":["CH0000950000","CH0001130000","CH0032130000","CH0032230000","CH0037550000"]},{"name":"vorfluterbez","type":"VARCHAR","alias":"ch.bafu.gewaesserschutz-klaeranlagen_ausbaugroesse.vorfluterbez","values":["Fliessgewaesser","See","Versickern"]},{"name":"rechtswert","type":"INTEGER","alias":"ch.bafu.gewaesserschutz-klaeranlagen_ausbaugroesse.rechtswert","values":[526520,534800,539840,540365,568100]},{"name":"reinigungstyp","type":"VARCHAR","alias":"Reinigungstyp","values":["Mechanisch-biologische Reinigung","Mechanisch-biologische Reinigung mit Nitrifikation","Mechanisch-biologische Reinigung mit P-Elimination","Mechanisch-biologische Reinigung mit P-Elimination und Nitrifikation","Mechanisch-biologische Reinigung mit P-Elimination, Nitrifikation und Denitrifikation"]},{"name":"rohabwasser_tag","type":"INTEGER","alias":"BSB5 Rohabw. (kg/d)","values":[41,45,54,391,3450]},{"name":"bsb5anteil","type":"INTEGER","alias":"BSB5-Elimin. (%)","values":[85,90,95,null,97]},{"name":"nh4_nanteil","type":"INTEGER","alias":"NH4-N-Elimin.","values":[null,90,100,85,92]},{"name":"stabilisierter_schlamm_tag","type":"INTEGER","alias":"stabil. Schlamm (kg/d)","values":[25,36,37,4465,null]}]}