{"columns":[{"name":"objectid","type":"int32"},{"name":"displayatt","type":"string"},{"name":"atnr","type":"int16"},{"name":"msbezeichn","type":"string"},{"name":"msart","type":"int16"},{"name":"msart_de","type":"string"},{"name":"msart_fr","type":"string"},{"name":"mstyp","type":"int16"},{"name":"mstyp_de","type":"string"},{"name":"mstyp_fr","type":"string"},{"name":"msstat","type":"int16"},{"name":"msstat_de","type":"string"},{"name":"msstat_fr","type":"string"},{"name":"relation","type":"string"}],"n_rows":6,"rows_kept":6,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"DuckDB version v1.3.0 (build 71c5c07cdd)","schema":{"fields":[{"name":"objectid","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"displayatt","type":"string","nullable":true,"metadata":null,"children":null},{"name":"atnr","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"msbezeichn","type":"string","nullable":true,"metadata":null,"children":null},{"name":"msart","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"msart_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"msart_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"mstyp","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"mstyp_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"mstyp_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"msstat","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"msstat_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"msstat_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"relation","type":"string","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 duckdb_schema {\n  optional int32 field_id=-1 objectid (Int(bitWidth=32, isSigned=true));\n  optional binary field_id=-1 displayatt (String);\n  optional int32 field_id=-1 atnr (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 msbezeichn (String);\n  optional int32 field_id=-1 msart (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 msart_de (String);\n  optional binary field_id=-1 msart_fr (String);\n  optional int32 field_id=-1 mstyp (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 mstyp_de (String);\n  optional binary field_id=-1 mstyp_fr (String);\n  optional int32 field_id=-1 msstat (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 msstat_de (String);\n  optional binary field_id=-1 msstat_fr (String);\n  optional binary field_id=-1 relation (String);\n}\n"},"kv_metadata":[]}
[1,null,11694,"keine Bezeichnung",1801,"baulich","travaux de construction",2208,"Verringerung Pegeländerungsraten ","Diminuer les taux de variation du niveau d’eau",1909,"realisiert (G)","réalisé (C)","{\"sanwakra_atswasu\" : [{\"objectid\" : 1, \"atnr\" : 11694, \"anlagenr\" : 16101, \"anlagename\" : \"Innertkirchen I\", \"atbezeichn\" : \"Rückgabe: Innertkirchen Gadmerwasser\", \"atortsname\" : \"Guttannen\", \"beeintr\" : \"N\", \"beeintr_de\" : \"nein\", \"beeintr_fr\" : \"non\", \"gewabnr\" : 1, \"symbol\" : \"P-SS-Symbol9\"}]}"]
[2,null,11950,"keine Bezeichnung",1801,"baulich","travaux de construction",2208,"Verringerung Pegeländerungsraten ","Diminuer les taux de variation du niveau d’eau",1901,"möglich (S)","Envisageable (E)","{\"sanwakra_atswasu\" : [{\"objectid\" : 2, \"atnr\" : 11950, \"anlagenr\" : 35023, \"anlagename\" : \"Innergsteig\", \"atbezeichn\" : \"Rückgabe: Schüpfenweid\", \"atortsname\" : \"Gsteig\", \"beeintr\" : \"Y\", \"beeintr_de\" : \"ja\", \"beeintr_fr\" : \"oui\", \"gewabnr\" : 5, \"symbol\" : \"P-SS-Symbol2\"}]}"]
[3,null,11695,"keine Bezeichnung",1801,"baulich","travaux de construction",2208,"Verringerung Pegeländerungsraten ","Diminuer les taux de variation du niveau d’eau",1907,"in Planung (G)","En cours de planification (C)","{\"sanwakra_atswasu\" : [{\"objectid\" : 3, \"atnr\" : 11695, \"anlagenr\" : 19011, \"anlagename\" : \"Isch\", \"atbezeichn\" : \"Rückgabe: Isch\", \"atortsname\" : \"Grindelwald\", \"beeintr\" : \"Y\", \"beeintr_de\" : \"ja\", \"beeintr_fr\" : \"oui\", \"gewabnr\" : 2, \"symbol\" : \"P-SS-Symbol2\"}]}"]
[4,null,11693,"keine Bezeichnung",1801,"baulich","travaux de construction",2208,"Verringerung Pegeländerungsraten ","Diminuer les taux de variation du niveau d’eau",1909,"realisiert (G)","réalisé (C)","{\"sanwakra_atswasu\" : null}"]
[5,null,11840,"keine Bezeichnung",1802,"betrieblich","mesures d’exploitation",2208,"Verringerung Pegeländerungsraten ","Diminuer les taux de variation du niveau d’eau",1909,"realisiert (G)","réalisé (C)","{\"sanwakra_atswasu\" : [{\"objectid\" : 4, \"atnr\" : 11840, \"anlagenr\" : 45029, \"anlagename\" : \"Alte Mühle\", \"atbezeichn\" : \"Rückgabe: Anlage Alte Mühle\", \"atortsname\" : \"Oberbipp\", \"beeintr\" : \"N\", \"beeintr_de\" : \"nein\", \"beeintr_fr\" : \"non\", \"gewabnr\" : 4, \"symbol\" : \"P-SS-Symbol9\"}]}"]
[6,null,11720,"keine Bezeichnung",1801,"baulich","travaux de construction",2208,"Verringerung Pegeländerungsraten ","Diminuer les taux de variation du niveau d’eau",1901,"möglich (S)","Envisageable (E)","{\"sanwakra_atswasu\" : [{\"objectid\" : 5, \"atnr\" : 11720, \"anlagenr\" : 38045, \"anlagename\" : \"Schiffenen\", \"atbezeichn\" : \"Rückgabe: Anlage Schiffenen\", \"atortsname\" : \"Kriechenwil\", \"beeintr\" : \"Y\", \"beeintr_de\" : \"ja\", \"beeintr_fr\" : \"oui\", \"gewabnr\" : 3, \"symbol\" : \"P-SS-Symbol2\"}]}"]