{"columns":[{"name":"objectid","type":"int32"},{"name":"gew_code","type":"int16"},{"name":"patstnt_name_de","type":"string"},{"name":"patstnt_name_fr","type":"string"},{"name":"gew_beschr","type":"int16"},{"name":"patstbt_beschr_de","type":"string"},{"name":"patstbt_beschr_fr","type":"string"},{"name":"gew_typ","type":"int16"},{"name":"patstypt_typ_de","type":"string"},{"name":"patstypt_typ_fr","type":"string"},{"name":"url_de","type":"string"},{"name":"url_fr","type":"string"},{"name":"geometry","type":"binary"},{"name":"bbox","type":"struct<min_x: double, min_y: double, max_x: double, max_y: double>"}],"n_rows":15,"rows_kept":15,"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":15,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"DuckDB version v1.4.4 (build 6ddac802ff)","schema":{"fields":[{"name":"objectid","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"gew_code","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"patstnt_name_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"patstnt_name_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"gew_beschr","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"patstbt_beschr_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"patstbt_beschr_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"gew_typ","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"patstypt_typ_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"patstypt_typ_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"url_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"url_fr","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 gew_code (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 patstnt_name_de (String);\n  optional binary field_id=-1 patstnt_name_fr (String);\n  optional int32 field_id=-1 gew_beschr (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 patstbt_beschr_de (String);\n  optional binary field_id=-1 patstbt_beschr_fr (String);\n  optional int32 field_id=-1 gew_typ (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 patstypt_typ_de (String);\n  optional binary field_id=-1 patstypt_typ_fr (String);\n  optional binary field_id=-1 url_de (String);\n  optional binary field_id=-1 url_fr (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.0.0\", \"primary_column\": \"geometry\", \"columns\": {\"geometry\": {\"encoding\": \"WKB\", \"geometry_types\": [\"Polygon\", \"MultiPolygon\"], \"bbox\": [2568520.667, 1136871.499, 2670702.5, 1234028.615], \"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}}}}}"]]}
[12,118,"Arnensee","Lac d'Arnon",118,"-","-",3,"Bergsee","lac de montagne","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_118_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_118_FR.pdf",{"$binary":{"bytes":2317,"sig":"other"}},{"min_x":2582593.7,"min_y":1136871.499,"max_x":2583279.4,"max_y":1138210.0}]
[6,210,"Wohlensee","Lac de Wohlen",210,"Von der Neubrücke bis zum Kraftwerk Mühleberg","Du Neubrücke jusqu'à l'usine hydro-électrique de Mühleberg",2,"Stausee","lac de retenue","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_210_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_210_FR.pdf",{"$binary":{"bytes":22093,"sig":"other"}},{"min_x":2587904.1,"min_y":1200923.299,"max_x":2599206.843,"max_y":1202557.129}]
[1,213,"Stau von Aarberg","Retenue d'Aarberg",213,"Vom Stauwehr Niederried bis zum Stauwehr Aarberg","Du barrage de Niederried jusqu'au barrage d'Aarberg",2,"Stausee","lac de retenue","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_213_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_213_FR.pdf",{"$binary":{"bytes":4777,"sig":"other"}},{"min_x":2584852.699,"min_y":1205813.0,"max_x":2587514.399,"max_y":1209658.033}]
[5,212,"Niederriedsee","Lac de Niederried",212,"Von der Einmündung des Chesselgrabens bei Oltigen bis zum Stauwehr Niederried","De l'embouchure du Chesselgraben près d'Oltigen jusqu'au barrage de Niederried",2,"Stausee","lac de retenue","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_212_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_212_FR.pdf",{"$binary":{"bytes":6253,"sig":"other"}},{"min_x":2584735.6,"min_y":1203769.5,"max_x":2586329.2,"max_y":1205863.1}]
[15,108,"Zihlkanal","Canal de la Thielle",108,"Vom Neuenburger- bis zum Bielersee","Du lac de Neuchâtel jusqu'au lac de Bienne",4,"übrige stehende Gewässer","diverses eaux stagnantes","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_108_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_108_FR.pdf",{"$binary":{"bytes":2355,"sig":"other"}},{"min_x":2568520.667,"min_y":1206169.908,"max_x":2572640.024,"max_y":1211278.1}]
[4,102,"Bielersee","Lac de Bienne",102,"-","-",1,"See","lac","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_102_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_102_FR.pdf",{"$binary":{"bytes":106253,"sig":"other"}},{"min_x":2572179.826,"min_y":1209658.199,"max_x":2584660.213,"max_y":1220432.901}]
[3,223,"Stau von Bannwil","Retenue de Bannwil",223,"Von der Brücke in Wangen an der Aare bis zum Kraftwerk Bannwil","Du pont de Wangen sur l'Aar jusqu'à l'usine hydro-électrique de Bannwil",2,"Stausee","lac de retenue","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_223_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_223_FR.pdf",{"$binary":{"bytes":10273,"sig":"other"}},{"min_x":2616385.066,"min_y":1230561.615,"max_x":2622305.301,"max_y":1231928.0}]
[2,227,"Stau von Wynau","Retenue de Wynau",227,"Von der Brücke beim Schloss in Aarwangen bis zu den Stauwehren des Kraftwerks Wynau","Du pont près du château d'Aarwangen jusqu'aux barrages de l'usine hydro-électrique de Wynau",2,"Stausee","lac de retenue","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_227_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_227_FR.pdf",{"$binary":{"bytes":3901,"sig":"other"}},{"min_x":2624502.106,"min_y":1232805.01,"max_x":2626300.952,"max_y":1234028.615}]
[11,113,"Engstlensee","Lac d'Engstlen",113,"-","-",3,"Bergsee","lac de montagne","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_113_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_113_FR.pdf",{"$binary":{"bytes":2221,"sig":"other"}},{"min_x":2669367.6,"min_y":1180308.7,"max_x":2670702.5,"max_y":1180916.199}]
[9,111,"Gelmersee","La de Gelmer",111,"-","-",3,"Bergsee","lac de montagne","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_111_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_111_FR.pdf",{"$binary":{"bytes":2749,"sig":"other"}},{"min_x":2667513.625,"min_y":1162496.907,"max_x":2668886.376,"max_y":1163692.501}]
[7,112,"Mattenalpsee mit Chammlibach","Lac de Mattenalp avec Chammlibach",112,"-","-",3,"Bergsee","lac de montagne","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_112_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_112_FR.pdf",{"$binary":{"bytes":2285,"sig":"other"}},{"min_x":2660566.875,"min_y":1164292.5,"max_x":2661175.688,"max_y":1164986.094}]
[8,100,"Brienzersee","Lac de Brienz",100,"-","-",1,"See","lac","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_100_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_100_FR.pdf",{"$binary":{"bytes":23245,"sig":"other"}},{"min_x":2634116.0,"min_y":1170867.0,"max_x":2646709.796,"max_y":1178688.845}]
[14,101,"Thunersee","Lac de Thoune",101,"-","-",1,"See","lac","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_101_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_101_FR.pdf",{"$binary":{"bytes":48685,"sig":"other"}},{"min_x":2614301.916,"min_y":1167070.3,"max_x":2630022.8,"max_y":1177272.816}]
[13,115,"Oeschinensee","Lac d'Oeschinen",115,"-","-",3,"Bergsee","lac de montagne","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_115_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_115_FR.pdf",{"$binary":{"bytes":14397,"sig":"other"}},{"min_x":2621133.522,"min_y":1149233.839,"max_x":2622936.049,"max_y":1150213.162}]
[10,110,"Räterichsbodensee","Lac de Räterichsboden",110,"-","-",3,"Bergsee","lac de montagne","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_110_DE.pdf","https://geofiles.be.ch/geoportal/pub/zusatzdaten/ANGFISCH/Patentgewaesser_110_FR.pdf",{"$binary":{"bytes":3789,"sig":"other"}},{"min_x":2667615.187,"min_y":1158750.594,"max_x":2668828.687,"max_y":1160313.0}]