{"columns":[{"name":"objectid","type":"int32"},{"name":"nsg_name","type":"string"},{"name":"nsg_nr","type":"int16"},{"name":"nsg_beschr","type":"string"},{"name":"status","type":"int16"},{"name":"nsgbeart_bez_de","type":"string"},{"name":"nsgbeart_bez_fr","type":"string"},{"name":"datfrist","type":"timestamp[us]"},{"name":"differenz","type":"int16"},{"name":"nsgbeadt_bez_de","type":"string"},{"name":"nsgbeadt_bez_fr","type":"string"},{"name":"url_beschl","type":"string"},{"name":"url_plan","type":"string"},{"name":"url_info","type":"string"},{"name":"bezeich","type":"string"},{"name":"artikel","type":"string"},{"name":"geometry","type":"binary"},{"name":"bbox","type":"struct<min_x: double, min_y: double, max_x: double, max_y: double>"}],"n_rows":14,"rows_kept":14,"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":14,"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":"nsg_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"nsg_nr","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"nsg_beschr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"status","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"nsgbeart_bez_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"nsgbeart_bez_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"datfrist","type":"timestamp[us]","nullable":true,"metadata":null,"children":null},{"name":"differenz","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"nsgbeadt_bez_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"nsgbeadt_bez_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"url_beschl","type":"string","nullable":true,"metadata":null,"children":null},{"name":"url_plan","type":"string","nullable":true,"metadata":null,"children":null},{"name":"url_info","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bezeich","type":"string","nullable":true,"metadata":null,"children":null},{"name":"artikel","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 binary field_id=-1 nsg_name (String);\n  optional int32 field_id=-1 nsg_nr (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 nsg_beschr (String);\n  optional int32 field_id=-1 status (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 nsgbeart_bez_de (String);\n  optional binary field_id=-1 nsgbeart_bez_fr (String);\n  optional int64 field_id=-1 datfrist (Timestamp(isAdjustedToUTC=false, timeUnit=microseconds, is_from_converted_type=false, force_set_converted_type=false));\n  optional int32 field_id=-1 differenz (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 nsgbeadt_bez_de (String);\n  optional binary field_id=-1 nsgbeadt_bez_fr (String);\n  optional binary field_id=-1 url_beschl (String);\n  optional binary field_id=-1 url_plan (String);\n  optional binary field_id=-1 url_info (String);\n  optional binary field_id=-1 bezeich (String);\n  optional binary field_id=-1 artikel (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\": [2578124.393, 1183476.31, 2633113.237, 1213343.469], \"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}}}}}"]]}
[10,"Aaredelta am Bielersee",30,"Perimeter Schutzgebiet bestehend",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",5,"Schutzperimeter mit neuen Bestimmungen","Périmètre de protection soumis à de nouvelles dispositions","https://oerebfiles.apps.be.ch/9986/6893/030_Sb_Aaredelta_am_Bielersee_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/030_Schutzplan_Aaredelta_am_Bielersee_A1.pdf","https://oerebfiles.apps.be.ch/9986/6893/030_Erlaeuterungsbericht_zum_Beschluss.pdf",null,null,{"$binary":{"bytes":813,"sig":"other"}},{"min_x":2578728.478,"min_y":1210837.687,"max_x":2579809.946,"max_y":1211828.648}]
[7,"Aaredelta am Bielersee",30,"Perimeter Schutzgebiet bestehend",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",1,"Wegfallende Fläche","Surface à supprimer","https://oerebfiles.apps.be.ch/9986/6893/030_Sb_Aaredelta_am_Bielersee_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/030_Schutzplan_Aaredelta_am_Bielersee_A1.pdf","https://oerebfiles.apps.be.ch/9986/6893/030_Erlaeuterungsbericht_zum_Beschluss.pdf",null,null,{"$binary":{"bytes":813,"sig":"other"}},{"min_x":2578124.393,"min_y":1210726.46,"max_x":2578806.774,"max_y":1210984.754}]
[12,"Aaredelta am Bielersee",30,"Zone B2 - Badebereich saisonal",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",4,"Weitere neue Zone","Nouvelle zone ","https://oerebfiles.apps.be.ch/9986/6893/030_Sb_Aaredelta_am_Bielersee_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/030_Schutzplan_Aaredelta_am_Bielersee_A1.pdf","https://oerebfiles.apps.be.ch/9986/6893/030_Erlaeuterungsbericht_zum_Beschluss.pdf","Zone B2 - Badebereich saisonal","6ii",{"$binary":{"bytes":413,"sig":"other"}},{"min_x":2579516.313,"min_y":1211459.611,"max_x":2579607.804,"max_y":1211549.799}]
[13,"Aaredelta am Bielersee",30,"Zone A",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",3,"Neue Zone mit speziellen Vorschriften","Nouvelle zone soumise à des prescriptions spéciales","https://oerebfiles.apps.be.ch/9986/6893/030_Sb_Aaredelta_am_Bielersee_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/030_Schutzplan_Aaredelta_am_Bielersee_A1.pdf","https://oerebfiles.apps.be.ch/9986/6893/030_Erlaeuterungsbericht_zum_Beschluss.pdf","Zone A","5",{"$binary":{"bytes":445,"sig":"other"}},{"min_x":2578637.143,"min_y":1211009.077,"max_x":2581035.767,"max_y":1213343.469}]
[9,"Aaredelta am Bielersee",30,"Perimeter Schutzgebiet bestehend",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",5,"Schutzperimeter mit neuen Bestimmungen","Périmètre de protection soumis à de nouvelles dispositions","https://oerebfiles.apps.be.ch/9986/6893/030_Sb_Aaredelta_am_Bielersee_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/030_Schutzplan_Aaredelta_am_Bielersee_A1.pdf","https://oerebfiles.apps.be.ch/9986/6893/030_Erlaeuterungsbericht_zum_Beschluss.pdf",null,null,{"$binary":{"bytes":6640,"sig":"other"}},{"min_x":2579716.647,"min_y":1211621.185,"max_x":2580755.381,"max_y":1212746.625}]
[8,"Aaredelta am Bielersee",30,"Perimeter Schutzgebiet neu",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",2,"Hinzukommende Fläche","Surfaces à ajouter","https://oerebfiles.apps.be.ch/9986/6893/030_Sb_Aaredelta_am_Bielersee_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/030_Schutzplan_Aaredelta_am_Bielersee_A1.pdf","https://oerebfiles.apps.be.ch/9986/6893/030_Erlaeuterungsbericht_zum_Beschluss.pdf",null,null,{"$binary":{"bytes":4451,"sig":"other"}},{"min_x":2578637.143,"min_y":1210984.754,"max_x":2581227.606,"max_y":1213343.469}]
[11,"Aaredelta am Bielersee",30,"Zone B1 - Badebereich saisonal",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",4,"Weitere neue Zone","Nouvelle zone ","https://oerebfiles.apps.be.ch/9986/6893/030_Sb_Aaredelta_am_Bielersee_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/030_Schutzplan_Aaredelta_am_Bielersee_A1.pdf","https://oerebfiles.apps.be.ch/9986/6893/030_Erlaeuterungsbericht_zum_Beschluss.pdf","Zone B1 - Badebereich saisonal","6i",{"$binary":{"bytes":221,"sig":"other"}},{"min_x":2579816.025,"min_y":1211999.46,"max_x":2579902.623,"max_y":1212059.204}]
[6,"Aaredelta am Bielersee",30,"Perimeter Schutzgebiet bestehend",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",1,"Wegfallende Fläche","Surface à supprimer","https://oerebfiles.apps.be.ch/9986/6893/030_Sb_Aaredelta_am_Bielersee_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/030_Schutzplan_Aaredelta_am_Bielersee_A1.pdf","https://oerebfiles.apps.be.ch/9986/6893/030_Erlaeuterungsbericht_zum_Beschluss.pdf",null,null,{"$binary":{"bytes":5648,"sig":"other"}},{"min_x":2579929.815,"min_y":1211578.18,"max_x":2580452.517,"max_y":1212388.521}]
[14,"Aaredelta am Bielersee",30,"Zone C",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",4,"Weitere neue Zone","Nouvelle zone ","https://oerebfiles.apps.be.ch/9986/6893/030_Sb_Aaredelta_am_Bielersee_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/030_Schutzplan_Aaredelta_am_Bielersee_A1.pdf","https://oerebfiles.apps.be.ch/9986/6893/030_Erlaeuterungsbericht_zum_Beschluss.pdf","Zone C","7",{"$binary":{"bytes":493,"sig":"other"}},{"min_x":2579960.732,"min_y":1211738.345,"max_x":2580162.782,"max_y":1211928.382}]
[5,"Buhuettli",223,"Zone B",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",3,"Neue Zone mit speziellen Vorschriften","Nouvelle zone soumise à des prescriptions spéciales","https://oerebfiles.apps.be.ch/9986/6893/223_Sb_Buhuettli_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/223_Schutzplan_Buhuettli_50x30.pdf",null,"Zone B","IV 6 und V 9b",{"$binary":{"bytes":845,"sig":"other"}},{"min_x":2632656.696,"min_y":1184145.321,"max_x":2632807.332,"max_y":1184276.816}]
[4,"Buhuettli",223,"Zone A",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",4,"Weitere neue Zone","Nouvelle zone ","https://oerebfiles.apps.be.ch/9986/6893/223_Sb_Buhuettli_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/223_Schutzplan_Buhuettli_50x30.pdf",null,"Zone A","IV 5 und IV 8 a, c, e",{"$binary":{"bytes":2477,"sig":"other"}},{"min_x":2632646.849,"min_y":1183486.47,"max_x":2633108.891,"max_y":1184284.743}]
[2,"Buhuettli",223,"Perimeter Schutzgebiet neu",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",2,"Hinzukommende Fläche","Surfaces à ajouter","https://oerebfiles.apps.be.ch/9986/6893/223_Sb_Buhuettli_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/223_Schutzplan_Buhuettli_50x30.pdf",null,null,null,{"$binary":{"bytes":5330,"sig":"other"}},{"min_x":2632631.879,"min_y":1183476.31,"max_x":2633113.237,"max_y":1184319.64}]
[1,"Buhuettli",223,"Perimeter Schutzgebiet bestehend",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",1,"Wegfallende Fläche","Surface à supprimer","https://oerebfiles.apps.be.ch/9986/6893/223_Sb_Buhuettli_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/223_Schutzplan_Buhuettli_50x30.pdf",null,null,null,{"$binary":{"bytes":1240,"sig":"other"}},{"min_x":2632639.018,"min_y":1183491.152,"max_x":2633018.762,"max_y":1184190.64}]
[3,"Buhuettli",223,"Perimeter Schutzgebiet bestehend",9,"Eröffnung","notification","2026-06-26T00:00:00.000000",5,"Schutzperimeter mit neuen Bestimmungen","Périmètre de protection soumis à de nouvelles dispositions","https://oerebfiles.apps.be.ch/9986/6893/223_Sb_Buhuettli_2026.pdf","https://oerebfiles.apps.be.ch/9986/plan/223_Schutzplan_Buhuettli_50x30.pdf",null,null,null,{"$binary":{"bytes":2269,"sig":"other"}},{"min_x":2632639.892,"min_y":1183484.991,"max_x":2633102.338,"max_y":1184201.92}]