{"columns":[{"name":"objectid","type":"int32"},{"name":"pp_id","type":"int32"},{"name":"pp_name","type":"string"},{"name":"pp_v_seit","type":"timestamp[us]"},{"name":"pp_v_bis","type":"timestamp[us]"},{"name":"adresse","type":"string"},{"name":"plz","type":"int16"},{"name":"ortschaft","type":"string"},{"name":"telefon","type":"string"},{"name":"email","type":"string"},{"name":"verwaltung","type":"string"},{"name":"geometry","type":"binary"},{"name":"bbox","type":"struct<min_x: double, min_y: double, max_x: double, max_y: double>"}],"n_rows":11,"rows_kept":11,"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":11,"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":"pp_id","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"pp_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pp_v_seit","type":"timestamp[us]","nullable":true,"metadata":null,"children":null},{"name":"pp_v_bis","type":"timestamp[us]","nullable":true,"metadata":null,"children":null},{"name":"adresse","type":"string","nullable":true,"metadata":null,"children":null},{"name":"plz","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"ortschaft","type":"string","nullable":true,"metadata":null,"children":null},{"name":"telefon","type":"string","nullable":true,"metadata":null,"children":null},{"name":"email","type":"string","nullable":true,"metadata":null,"children":null},{"name":"verwaltung","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 pp_id (Int(bitWidth=32, isSigned=true));\n  optional binary field_id=-1 pp_name (String);\n  optional int64 field_id=-1 pp_v_seit (Timestamp(isAdjustedToUTC=false, timeUnit=microseconds, is_from_converted_type=false, force_set_converted_type=false));\n  optional int64 field_id=-1 pp_v_bis (Timestamp(isAdjustedToUTC=false, timeUnit=microseconds, is_from_converted_type=false, force_set_converted_type=false));\n  optional binary field_id=-1 adresse (String);\n  optional int32 field_id=-1 plz (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 ortschaft (String);\n  optional binary field_id=-1 telefon (String);\n  optional binary field_id=-1 email (String);\n  optional binary field_id=-1 verwaltung (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\": [\"Polygon\", \"MultiPolygon\"], \"bbox\": [2556240.186, 1130584.965, 2677745.365, 1243834.103], \"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}}}}}"]]}
[2,1009,"Obersimmental - Saanenland","2017-01-01T00:00:00.000000","2024-12-31T00:00:00.000000","Honegg",3777,"Saanenmöser","033 722 00 22","info@kasisa.ch","Bergregion Obersimmental-Saanenland",{"$binary":{"bytes":53053,"sig":"other"}},{"min_x":2581081.764,"min_y":1130584.965,"max_x":2608971.451,"max_y":1167180.247}]
[7,1008,"Entwicklungsraum Thun (ERT)","2017-01-01T00:00:00.000000","2024-12-31T00:00:00.000000","Fliederweg 11",3600,"Thun","033 225 61 61","info@ertthun.ch","Entwicklungsraum Thun",{"$binary":{"bytes":85053,"sig":"other"}},{"min_x":2594690.81,"min_y":1151484.837,"max_x":2632773.353,"max_y":1187309.913}]
[9,1007,"Naturpark Gantrisch","2017-01-01T00:00:00.000000","2024-12-31T00:00:00.000000","Schlossgasse 13",3150,"Schwarzenburg","031 808 00 20","karin.remund@gantrisch.ch","Förderverein Region Gantrisch",{"$binary":{"bytes":48125,"sig":"other"}},{"min_x":2588683.04,"min_y":1168848.668,"max_x":2609747.799,"max_y":1197074.791}]
[3,1003,"Seeland","2017-01-01T00:00:00.000000","2024-12-31T00:00:00.000000","Milchstrasse 9",3072,"Ostermundigen","031 938 22 65","helen.husmann@bernerbauern.ch","Berner Bauern Verband",{"$binary":{"bytes":115053,"sig":"other"}},{"min_x":2568552.574,"min_y":1202123.794,"max_x":2604428.678,"max_y":1228480.232}]
[6,1002,"Parc régional Chasseral","2017-01-01T00:00:00.000000","2024-12-31T00:00:00.000000","Place de la Gare 2",2610,"Saint-Imier","032 942 39 49","info@parcchasseral.ch","Parc régional Chasseral réseaux écologiques",{"$binary":{"bytes":62461,"sig":"other"}},{"min_x":2556240.186,"min_y":1212135.483,"max_x":2593419.633,"max_y":1233045.9}]
[5,1001,"Trois-Vaux","2017-01-01T00:00:00.000000","2024-12-31T00:00:00.000000","le Plan 37",2616,"Renan","032 963 15 51","cajb.haemmerli@bluewin.ch","Chambre d'agriculture du Jura bernois CAJB",{"$binary":{"bytes":55059,"sig":"other"}},{"min_x":2577395.751,"min_y":1227857.803,"max_x":2610093.259,"max_y":1243834.103}]
[8,1006,"Berner Mittelland","2017-01-01T00:00:00.000000","2024-12-31T00:00:00.000000","Milchstrasse 9",3072,"Ostermundigen","031 938 22 65","helen.husmann@bernerbauern.ch","Berner Bauern Verband",{"$binary":{"bytes":107367,"sig":"other"}},{"min_x":2575209.931,"min_y":1182877.788,"max_x":2622384.216,"max_y":1219079.769}]
[1,1005,"Emmental","2017-01-01T00:00:00.000000","2024-12-31T00:00:00.000000","Milchstrasse 9",3072,"Ostermundigen","031 938 22 65","helen.husmann@bernerbauern.ch","Berner Bauern Verband",{"$binary":{"bytes":98461,"sig":"other"}},{"min_x":2605003.288,"min_y":1181694.157,"max_x":2639362.476,"max_y":1224162.479}]
[11,1004,"Oberaargau","2017-01-01T00:00:00.000000","2024-12-31T00:00:00.000000","Waldhof 2",4900,"Langenthal","031 636 42 47","markus.maag@vol.be.ch","INFORAMA",{"$binary":{"bytes":86385,"sig":"other"}},{"min_x":2610705.391,"min_y":1210713.743,"max_x":2634285.895,"max_y":1238152.092}]
[10,1011,"Oberland-Ost","2017-01-01T00:00:00.000000","2024-12-31T00:00:00.000000","Obere Fuhren 216",3807,"Iseltwald","079 562 70 41","claudia.schatzmann@oberland-ost.ch","Regionalkonferenz Oberland-Ost",{"$binary":{"bytes":93873,"sig":"other"}},{"min_x":2623432.947,"min_y":1147408.727,"max_x":2677745.365,"max_y":1182847.564}]
[4,1010,"Kandertal","2017-01-01T00:00:00.000000","2024-12-31T00:00:00.000000","Honegg",3777,"Saanenmöser","033 722 00 22","info@kasisa.ch","Planungsregion Kandertal",{"$binary":{"bytes":33293,"sig":"other"}},{"min_x":2603839.643,"min_y":1139996.651,"max_x":2631090.841,"max_y":1166195.262}]