{"columns":[{"name":"objectid","type":"int32"},{"name":"anlnr","type":"int32"},{"name":"anlname","type":"string"},{"name":"sanierung","type":"int16"},{"name":"schwalat_bez_de","type":"string"},{"name":"schwalat_bez_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":25,"rows_kept":25,"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":25,"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":"anlnr","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"anlname","type":"string","nullable":true,"metadata":null,"children":null},{"name":"sanierung","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"schwalat_bez_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"schwalat_bez_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 anlnr (Int(bitWidth=32, isSigned=true));\n  optional binary field_id=-1 anlname (String);\n  optional int32 field_id=-1 sanierung (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 schwalat_bez_de (String);\n  optional binary field_id=-1 schwalat_bez_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.1.0\", \"primary_column\": \"geometry\", \"columns\": {\"geometry\": {\"encoding\": \"WKB\", \"geometry_types\": [\"Point\"], \"bbox\": [2581353.946, 1136134.202, 2660201.471, 1234766.28], \"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}}}}}"]]}
[22,35023,"Innergsteig",1,"sanierungspflichtige Anlage","installation devant être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2587659.586,"min_y":1136134.202,"max_x":2587659.586,"max_y":1136134.202}]
[17,24039,"Bärgli",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2599317.718,"min_y":1155875.023,"max_x":2599317.718,"max_y":1155875.023}]
[23,35039,"Alp Berzgumm",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2592785.547,"min_y":1146525.094,"max_x":2592785.547,"max_y":1146525.094}]
[13,22014,"Kandersteg (I+II)",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2618169.807,"min_y":1149440.812,"max_x":2618169.807,"max_y":1149440.812}]
[14,22044,"Moosweid",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2610619.722,"min_y":1149429.941,"max_x":2610619.722,"max_y":1149429.941}]
[15,22046,"Moosweid-TW",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2610619.722,"min_y":1149429.941,"max_x":2610619.722,"max_y":1149429.941}]
[19,26023,"Erlenbach",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2608381.869,"min_y":1167295.823,"max_x":2608381.869,"max_y":1167295.823}]
[16,23038,"Spiez",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2617307.965,"min_y":1171740.764,"max_x":2617307.965,"max_y":1171740.764}]
[18,25095,"Simmenfluh",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2614049.912,"min_y":1169099.735,"max_x":2614049.912,"max_y":1169099.735}]
[24,38045,"Schiffenen",1,"sanierungspflichtige Anlage","installation devant être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2581353.946,"min_y":1192425.132,"max_x":2581353.946,"max_y":1192425.132}]
[20,33038,"Pumpwerk Schönau",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2600565.045,"min_y":1198072.043,"max_x":2600565.045,"max_y":1198072.043}]
[3,14023,"Mühle Schüpfen",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2595209.157,"min_y":1209571.226,"max_x":2595209.157,"max_y":1209571.226}]
[21,33093,"Mühleberg",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2588306.086,"min_y":1202016.188,"max_x":2588306.086,"max_y":1202016.188}]
[2,13028,"Niederried-Radelfingen",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2584962.091,"min_y":1205801.275,"max_x":2584962.091,"max_y":1205801.275}]
[1,13015,"Kallnach",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2583999.12,"min_y":1207840.303,"max_x":2583999.12,"max_y":1207840.303}]
[5,15072,"Brügg",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2586314.178,"min_y":1218691.481,"max_x":2586314.178,"max_y":1218691.481}]
[4,14029,"Mühle Affolter",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2594186.173,"min_y":1210429.256,"max_x":2594186.173,"max_y":1210429.256}]
[25,45029,"Alte Mühle",1,"sanierungspflichtige Anlage","installation devant être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2616584.445,"min_y":1234766.28,"max_x":2616584.445,"max_y":1234766.28}]
[7,17028,"Schattenhalb 1",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2657066.386,"min_y":1174503.713,"max_x":2657066.386,"max_y":1174503.713}]
[8,17028,"Schattenhalb 3",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2656990.386,"min_y":1174525.713,"max_x":2656990.386,"max_y":1174525.713}]
[10,17060,"Meiringen I",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2657595.407,"min_y":1175562.732,"max_x":2657595.407,"max_y":1175562.732}]
[9,17041,"Meiringen II",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2657938.415,"min_y":1175903.739,"max_x":2657938.415,"max_y":1175903.739}]
[6,16101,"Innertkirchen (I +II)",1,"sanierungspflichtige Anlage","installation devant être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2660201.471,"min_y":1173342.689,"max_x":2660201.471,"max_y":1173342.689}]
[11,19011,"Isch",1,"sanierungspflichtige Anlage","installation devant être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2646835.177,"min_y":1164091.78,"max_x":2646835.177,"max_y":1164091.78}]
[12,19032,"KW Lütschental",0,"nicht sanierungspflichtige Anlage","installation ne devant pas être assainie",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2639490.139,"min_y":1165249.759,"max_x":2639490.139,"max_y":1165249.759}]