{"columns":[{"name":"objectid","type":"int32"},{"name":"atnr","type":"int16"},{"name":"anlagenr","type":"int32"},{"name":"anlagename","type":"string"},{"name":"atbezeichn","type":"string"},{"name":"atortsname","type":"string"},{"name":"gattyp","type":"int16"},{"name":"gattyp_de","type":"string"},{"name":"gattyp_fr","type":"string"},{"name":"gewabnr","type":"int16"},{"name":"symbol","type":"string"},{"name":"geometry","type":"binary"},{"name":"bbox","type":"struct<min_x: double, min_y: double, max_x: double, max_y: double>"}],"n_rows":44,"rows_kept":44,"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":44,"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":"atnr","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"anlagenr","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"anlagename","type":"string","nullable":true,"metadata":null,"children":null},{"name":"atbezeichn","type":"string","nullable":true,"metadata":null,"children":null},{"name":"atortsname","type":"string","nullable":true,"metadata":null,"children":null},{"name":"gattyp","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"gattyp_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"gattyp_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"gewabnr","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"symbol","type":"string","nullable":true,"metadata":null,"children":null},{"name":"geometry","type":"binary","nullable":true,"metadata":null,"children":null},{"name":"bbox","type":"struct<min_x: double, min_y: double, max_x: double, max_y: double>","nullable":true,"metadata":null,"children":[{"name":"min_x","type":"double","nullable":true,"metadata":null,"children":null},{"name":"min_y","type":"double","nullable":true,"metadata":null,"children":null},{"name":"max_x","type":"double","nullable":true,"metadata":null,"children":null},{"name":"max_y","type":"double","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 int32 field_id=-1 atnr (Int(bitWidth=16, isSigned=true));\n  optional int32 field_id=-1 anlagenr (Int(bitWidth=32, isSigned=true));\n  optional binary field_id=-1 anlagename (String);\n  optional binary field_id=-1 atbezeichn (String);\n  optional binary field_id=-1 atortsname (String);\n  optional int32 field_id=-1 gattyp (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 gattyp_de (String);\n  optional binary field_id=-1 gattyp_fr (String);\n  optional int32 field_id=-1 gewabnr (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 symbol (String);\n  optional binary field_id=-1 geometry;\n  optional group field_id=-1 bbox {\n    optional double field_id=-1 min_x;\n    optional double field_id=-1 min_y;\n    optional double field_id=-1 max_x;\n    optional double field_id=-1 max_y;\n  }\n}\n"},"kv_metadata":[["geo","{\"version\": \"1.1.0\", \"primary_column\": \"geometry\", \"columns\": {\"geometry\": {\"encoding\": \"WKB\", \"geometry_types\": [\"Point\"], \"bbox\": [2570353.207, 1141020.673, 2672148.531, 1237429.392], \"crs\": {\"$schema\": \"https://proj.org/schemas/v0.7/projjson.schema.json\", \"type\": \"ProjectedCRS\", \"name\": \"CH1903+ / LV95\", \"base_crs\": {\"name\": \"CH1903+\", \"datum\": {\"type\": \"GeodeticReferenceFrame\", \"name\": \"CH1903+\", \"ellipsoid\": {\"name\": \"Bessel 1841\", \"semi_major_axis\": 6377397.155, \"inverse_flattening\": 299.1528128}}, \"coordinate_system\": {\"subtype\": \"ellipsoidal\", \"axis\": [{\"name\": \"Geodetic latitude\", \"abbreviation\": \"Lat\", \"direction\": \"north\", \"unit\": \"degree\"}, {\"name\": \"Geodetic longitude\", \"abbreviation\": \"Lon\", \"direction\": \"east\", \"unit\": \"degree\"}]}, \"id\": {\"authority\": \"EPSG\", \"code\": 4150}}, \"conversion\": {\"name\": \"Swiss Oblique Mercator 1995\", \"method\": {\"name\": \"Hotine Oblique Mercator (variant B)\", \"id\": {\"authority\": \"EPSG\", \"code\": 9815}}, \"parameters\": [{\"name\": \"Latitude of projection centre\", \"value\": 46.9524055555556, \"unit\": \"degree\", \"id\": {\"authority\": \"EPSG\", \"code\": 8811}}, {\"name\": \"Longitude of projection centre\", \"value\": 7.43958333333333, \"unit\": \"degree\", \"id\": {\"authority\": \"EPSG\", \"code\": 8812}}, {\"name\": \"Azimuth at projection centre\", \"value\": 90, \"unit\": \"degree\", \"id\": {\"authority\": \"EPSG\", \"code\": 8813}}, {\"name\": \"Angle from Rectified to Skew Grid\", \"value\": 90, \"unit\": \"degree\", \"id\": {\"authority\": \"EPSG\", \"code\": 8814}}, {\"name\": \"Scale factor at projection centre\", \"value\": 1, \"unit\": \"unity\", \"id\": {\"authority\": \"EPSG\", \"code\": 8815}}, {\"name\": \"Easting at projection centre\", \"value\": 2600000, \"unit\": \"metre\", \"id\": {\"authority\": \"EPSG\", \"code\": 8816}}, {\"name\": \"Northing at projection centre\", \"value\": 1200000, \"unit\": \"metre\", \"id\": {\"authority\": \"EPSG\", \"code\": 8817}}]}, \"coordinate_system\": {\"subtype\": \"Cartesian\", \"axis\": [{\"name\": \"Easting\", \"abbreviation\": \"E\", \"direction\": \"east\", \"unit\": \"metre\"}, {\"name\": \"Northing\", \"abbreviation\": \"N\", \"direction\": \"north\", \"unit\": \"metre\"}]}, \"scope\": \"Cadastre, engineering survey, topographic mapping (large and medium scale).\", \"area\": \"Liechtenstein; Switzerland.\", \"bbox\": {\"south_latitude\": 45.82, \"west_longitude\": 5.96, \"north_latitude\": 47.81, \"east_longitude\": 10.49}, \"id\": {\"authority\": \"EPSG\", \"code\": 2056}}}}}"]]}
[41,20866,35015,"Lauenen","Entnahme: Lauenen","Lauenen",3301,"Wehranlage","Barrage",10,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2591007.455,"min_y":1141020.673,"max_x":2591007.455,"max_y":1141020.673}]
[16,10846,23038,"Spiez","Entnahme: Simmewehr Port","Hondrich",3301,"Wehranlage","Barrage",45,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2614320.784,"min_y":1169214.132,"max_x":2614320.784,"max_y":1169214.132}]
[15,10618,23038,"Spiez","Entnahme: Kanderwehr","Hondrich",3301,"Wehranlage","Barrage",26,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2617402.82,"min_y":1169337.029,"max_x":2617402.82,"max_y":1169337.029}]
[17,10717,30076,"unbekannt","Entnahme: Chise","Herbligen",3301,"Wehranlage","Barrage",27,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2612639.707,"min_y":1186235.497,"max_x":2612639.707,"max_y":1186235.497}]
[18,10714,30083,"unbekannt","Entnahme: Chise","Oppligen",3301,"Wehranlage","Barrage",27,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2612034.365,"min_y":1185749.171,"max_x":2612034.365,"max_y":1185749.171}]
[20,11720,38045,"Schiffenen","Rückgabe: Anlage Schiffenen","Kriechenwil",3301,"Wehranlage","Barrage",52,"P-G-Symbol3",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2581353.947,"min_y":1192425.133,"max_x":2581353.947,"max_y":1192425.133}]
[22,10854,13015,"Kallnach","Entnahme: Stauwehr Niederried","Niederried, Radelfingen",3301,"Wehranlage","Barrage",66,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2584852.342,"min_y":1205757.367,"max_x":2584852.342,"max_y":1205757.367}]
[21,10885,33093,"Mühleberg","Entnahme: Wohlensee","Mühleberg",3301,"Wehranlage","Barrage",72,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2588300.774,"min_y":1201987.688,"max_x":2588300.774,"max_y":1201987.688}]
[23,10562,13056,"Alte Aare","Entnahme: Aarberg","Aarberg",3301,"Wehranlage","Barrage",73,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2587400.631,"min_y":1209530.542,"max_x":2587400.631,"max_y":1209530.542}]
[24,10632,50032,"Secteur Schmid","Entnahme: Anlage Secteur Schmid","Cormoret",3301,"Wehranlage","Barrage",41,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2570353.207,"min_y":1224318.228,"max_x":2570353.207,"max_y":1224318.228}]
[25,16351,50037,"unbekannt","Entnahme: Schlauchwehr","Cormoret",3301,"Wehranlage","Barrage",41,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2570860.749,"min_y":1224775.887,"max_x":2570860.749,"max_y":1224775.887}]
[26,21351,50053,"Vieille Scierie","Entnahme: Vieille Scierie","Cortébert",3301,"Wehranlage","Barrage",41,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2575389.23,"min_y":1226709.655,"max_x":2575389.23,"max_y":1226709.655}]
[28,11718,50072,"Vielle Scierie","Rückgabe: Anlage Vielle Scierie","Sonceboz-Sombeval",3301,"Wehranlage","Barrage",41,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2579372.263,"min_y":1227463.59,"max_x":2579372.263,"max_y":1227463.59}]
[27,10633,50064,"Usine ETA","Entnahme: Anlage Usine ETA","Corgémont",3301,"Wehranlage","Barrage",41,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2577509.443,"min_y":1226783.916,"max_x":2577509.443,"max_y":1226783.916}]
[29,10866,50075,"Sous les Roches","Entnahme: Tournedos","Sonceboz-Sombeval",3301,"Wehranlage","Barrage",69,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2580310.582,"min_y":1226550.307,"max_x":2580310.582,"max_y":1226550.307}]
[30,21620,51013,"Usine Weber","Entnahme: Barrage Cerne","La Heutte",3301,"Wehranlage","Barrage",69,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2583557.522,"min_y":1226381.278,"max_x":2583557.522,"max_y":1226381.278}]
[40,10656,53021,"Le Cerneux Gorgé","Entnahme: Birse","Moutier",3301,"Wehranlage","Barrage",30,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2595695.725,"min_y":1237429.392,"max_x":2595695.725,"max_y":1237429.392}]
[39,10622,53015,"Tornos SA","Entnahme: La Birse","Moutier",3301,"Wehranlage","Barrage",30,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2594276.046,"min_y":1235430.849,"max_x":2594276.046,"max_y":1235430.849}]
[38,10600,53012,"Moutier","Entnahme: Gorges de Court","Moutier",3301,"Wehranlage","Barrage",30,"P-G-Symbol3",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2593041.197,"min_y":1232860.488,"max_x":2593041.197,"max_y":1232860.488}]
[34,11676,51043,"Bözingen","Rückgabe: Bözingen","Biel ",3301,"Wehranlage","Barrage",69,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2586888.028,"min_y":1222671.425,"max_x":2586888.028,"max_y":1222671.425}]
[33,10861,51042,"Taubenloch","Entnahme: Taubenloch","Biel",3301,"Wehranlage","Barrage",69,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2586383.569,"min_y":1223696.021,"max_x":2586383.569,"max_y":1223696.021}]
[32,10570,51032,"Frinvillier","Entnahme: Barrage de Frinvillier","Vauffelin",3301,"Wehranlage","Barrage",69,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2585920.693,"min_y":1224246.62,"max_x":2585920.693,"max_y":1224246.62}]
[31,10832,51025,"Rondchâtel","Entnahme: Rondchâtel","Péry",3301,"Wehranlage","Barrage",69,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2585459.873,"min_y":1224962.36,"max_x":2585459.873,"max_y":1224962.36}]
[36,10740,47080,"Mühle Steffen","Entnahme: Anlage Mühle Steffen","Niederönz",3301,"Wehranlage","Barrage",59,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2619367.1,"min_y":1225880.876,"max_x":2619367.1,"max_y":1225880.876}]
[37,10736,47082,"Mühle Hosner","Entnahme: Anlage Mühle Hosner","Niederönz",3301,"Wehranlage","Barrage",59,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2619083.849,"min_y":1226524.835,"max_x":2619083.849,"max_y":1226524.835}]
[35,10737,47076,"Alte Mühle Oberönz","Entnahme: Önz","Herzogenbuchsee",3301,"Wehranlage","Barrage",59,"P-G-Symbol1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2619276.854,"min_y":1225362.421,"max_x":2619276.854,"max_y":1225362.421}]
[19,10584,33051,"Felsenau","Entnahme: Engehalde","Bern",3301,"Wehranlage","Barrage",74,"P-G-Symbol3",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2600475.351,"min_y":1201584.306,"max_x":2600475.351,"max_y":1201584.306}]
[42,10667,34125,"Mech.Werkstatt","Entnahme: Anlage Mech.Werkstatt","Ittigen",3301,"Wehranlage","Barrage",33,"P-G-Symbol6",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2601990.264,"min_y":1202937.954,"max_x":2601990.264,"max_y":1202937.954}]
[44,11699,45056,"Bannwil","Rückgabe: KW Bannwil","Bannwil",3301,"Wehranlage","Barrage",78,"P-G-Symbol4",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2622246.49,"min_y":1230969.067,"max_x":2622246.49,"max_y":1230969.067}]
[11,10864,16101,"Innertkirchen I","Entnahme: Teuflauibach","Guttannen",3301,"Wehranlage","Barrage",16,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2668325.536,"min_y":1179532.755,"max_x":2668325.536,"max_y":1179532.755}]
[13,10586,16101,"Innertkirchen I","Entnahme: Engstlenbach","Guttannen",3301,"Wehranlage","Barrage",16,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2668731.413,"min_y":1180612.955,"max_x":2668731.413,"max_y":1180612.955}]
[6,10883,16101,"Innertkirchen I","Entnahme: Wenden","Guttannen",3301,"Wehranlage","Barrage",38,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2671916.228,"min_y":1177247.003,"max_x":2671916.228,"max_y":1177247.003}]
[43,26651,16101,"Innertkirchen I","Geschiebesammler Obermaad","Guttannen",3315,"Geschiebesammler","Dépotoir à alluvions",38,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2671220.0,"min_y":1176582.0,"max_x":2671220.0,"max_y":1176582.0}]
[7,10857,16101,"Innertkirchen I","Entnahme: Steinwasser l","Guttannen",3301,"Wehranlage","Barrage",38,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2672148.531,"min_y":1176256.479,"max_x":2672148.531,"max_y":1176256.479}]
[8,10595,16101,"Innertkirchen I","Entnahme: Gadmenwasser Furen","Guttannen",3301,"Wehranlage","Barrage",38,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2668871.358,"min_y":1175949.886,"max_x":2668871.358,"max_y":1175949.886}]
[9,10867,16101,"Innertkirchen I","Entnahme: Triftwasser l","Guttannen",3301,"Wehranlage","Barrage",38,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2668506.965,"min_y":1172917.182,"max_x":2668506.965,"max_y":1172917.182}]
[10,10596,16101,"Innertkirchen I","Entnahme: Gadmenwasser Hopflauenen","Guttannen",3301,"Wehranlage","Barrage",16,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2664175.539,"min_y":1174149.674,"max_x":2664175.539,"max_y":1174149.674}]
[12,10625,16101,"Innertkirchen I","Entnahme: Leimboden","Guttannen",3301,"Wehranlage","Barrage",16,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2663827.984,"min_y":1175547.119,"max_x":2663827.984,"max_y":1175547.119}]
[14,10574,19032,"KW Lütschental","Entnahme: Burglauenen","Grindelwald",3301,"Wehranlage","Barrage",32,"P-G-Symbol1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2641147.531,"min_y":1165033.822,"max_x":2641147.531,"max_y":1165033.822}]
[1,10818,16101,"Innertkirchen I","Entnahme: Oberaar Stausee","Guttannen",3301,"Wehranlage","Barrage",46,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2663903.478,"min_y":1155568.527,"max_x":2663903.478,"max_y":1155568.527}]
[4,10609,16101,"Innertkirchen I","Entnahme: Hasliaare Rätrichsboden","Guttannen",3301,"Wehranlage","Barrage",46,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2667864.874,"min_y":1160159.595,"max_x":2667864.874,"max_y":1160159.595}]
[5,10599,16101,"Innertkirchen I","Entnahme: Gelmersee","Guttannen",3301,"Wehranlage","Barrage",46,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2667639.462,"min_y":1162674.923,"max_x":2667639.462,"max_y":1162674.923}]
[2,10607,16101,"Innertkirchen I","Entnahme: Hasliaare Grimselsee","Guttannen",3301,"Wehranlage","Barrage",46,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2668303.793,"min_y":1158267.424,"max_x":2668303.793,"max_y":1158267.424}]
[3,10869,16101,"Innertkirchen I","Entnahme: Trübtensee","Guttannen",3301,"Wehranlage","Barrage",46,"P-G-Symbol2",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2665801.902,"min_y":1156384.289,"max_x":2665801.902,"max_y":1156384.289}]