{"columns":[{"name":"objectid","type":"int32"},{"name":"sitzgem","type":"string"},{"name":"bfsnr","type":"string"},{"name":"gemname","type":"string"},{"name":"kj020","type":"int32"},{"name":"gbtrgem","type":"int32"},{"name":"zbetrszi","type":"int32"},{"name":"anrhbtr","type":"int32"},{"name":"geometry","type":"binary"},{"name":"bbox","type":"struct<min_x: double, min_y: double, max_x: double, max_y: double>"}],"n_rows":38,"rows_kept":38,"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":38,"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.1 (build b390a7c376)","schema":{"fields":[{"name":"objectid","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"sitzgem","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bfsnr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"gemname","type":"string","nullable":true,"metadata":null,"children":null},{"name":"kj020","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"gbtrgem","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"zbetrszi","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"anrhbtr","type":"int32","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 sitzgem (String);\n  optional binary field_id=-1 bfsnr (String);\n  optional binary field_id=-1 gemname (String);\n  optional int32 field_id=-1 kj020 (Int(bitWidth=32, isSigned=true));\n  optional int32 field_id=-1 gbtrgem (Int(bitWidth=32, isSigned=true));\n  optional int32 field_id=-1 zbetrszi (Int(bitWidth=32, isSigned=true));\n  optional int32 field_id=-1 anrhbtr (Int(bitWidth=32, isSigned=true));\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\": [2556582.617, 1130584.965, 2677745.365, 1241284.17], \"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}}}}}"]]}
[32,"Frutigen","762, 563, 564, 565, 567","Diemtigen, Frutigen, Kandergrund, Kandersteg, Reichenbach im Kandertal",3096,267030,53026,320056,{"$binary":{"bytes":74717,"sig":"other"}},{"min_x":2599570.742,"min_y":1139996.651,"max_x":2631090.842,"max_y":1168588.977}]
[38,"Saanen","841, 842, 792, 843, 793, 794","Gsteig, Lauenen, Lenk, Saanen, St. Stephan, Zweisimmen",2745,236756,65264,302020,{"$binary":{"bytes":68173,"sig":"other"}},{"min_x":2581081.764,"min_y":1130584.965,"max_x":2609045.802,"max_y":1160852.045}]
[20,"Thun","928, 929, 934, 942","Heimberg, Hilterfingen, Oberhofen am Thunersee, Thun",9662,833348,362059,1195406,{"$binary":{"bytes":104515,"sig":"other"}},{"min_x":2610944.956,"min_y":1173148.563,"max_x":2619256.146,"max_y":1184257.061}]
[6,"Uetendorf","921, 770, 941, 943, 944, 885","Amsoldingen, Stocken-Höfen, Thierachern, Uebeschi, Uetendorf, Uttigen",2642,227873,46027,273900,{"$binary":{"bytes":28365,"sig":"other"}},{"min_x":2606909.905,"min_y":1170847.859,"max_x":2612995.371,"max_y":1184131.464}]
[31,"Riggisberg","863, 852, 869, 879, 880, 853, 855, 889, 884","Burgistein, Guggisberg, Kaufdorf, Riggisberg, Rüeggisberg, Rüschegg, Schwarzenburg, Thurnen, Toffen",4094,353108,84657,437765,{"$binary":{"bytes":68669,"sig":"other"}},{"min_x":2588683.04,"min_y":1168848.668,"max_x":2606792.857,"max_y":1192100.355}]
[24,"Täuffelen","491, 735, 492, 493, 494, 495, 496, 497, 498, 499, ","Brüttelen, Epsach, Erlach, Finsterhennen, Gals, Gampelen, Ins, Lüscherz, Müntschemier, Siselen, Täuffelen, Treiten, Tschugg",2959,255214,71224,326438,{"$binary":{"bytes":119136,"sig":"other"}},{"min_x":2568552.574,"min_y":1202842.552,"max_x":2584759.683,"max_y":1214625.886}]
[16,"Saint-Imier","432, 434, 441, 443, 445, 448","Cormoret, Courtelary, Renan (BE), Saint-Imier, Sonvilier, Villeret",2136,184230,92221,276451,{"$binary":{"bytes":28109,"sig":"other"}},{"min_x":2556582.617,"min_y":1215060.006,"max_x":2574805.609,"max_y":1228843.242}]
[13,"Péry-La Heutte","431, 433, 372, 438, 450, 442, 449, 444","Corgémont, Cortébert, Evilard, Orvin, Péry-La Heutte, Romont (BE), Sauge, Sonceboz-Sombeval",2424,209070,70554,279624,{"$binary":{"bytes":35277,"sig":"other"}},{"min_x":2573266.597,"min_y":1219962.121,"max_x":2593419.635,"max_y":1229663.014}]
[37,"Biel/Bienne","371","Biel/Bienne",10633,917096,797495,1714591,{"$binary":{"bytes":43901,"sig":"other"}},{"min_x":2581979.546,"min_y":1219038.356,"max_x":2590453.908,"max_y":1225131.412}]
[29,"La Neuveville","723, 724, 726","La Neuveville, Nods, Plateau de Diesse",1275,109969,43253,153221,{"$binary":{"bytes":48701,"sig":"other"}},{"min_x":2568491.966,"min_y":1212139.371,"max_x":2581935.988,"max_y":1223067.287}]
[5,"Nidau","739, 743, 745","Ipsach, Nidau, Port",2918,251678,135871,387548,{"$binary":{"bytes":27085,"sig":"other"}},{"min_x":2583425.285,"min_y":1217319.629,"max_x":2587976.862,"max_y":1219953.139}]
[4,"Lyss","301, 302, 732, 972, 382, 734, 383, 385, 386, 303, ","Aarberg, Bargen (BE), Bellmund, Berken, Büetigen, Bühl, Büren an der Aare, Diessbach bei Büren, Dotzigen, Grossaffoltern, Hermrigen, Jens, Kallnach, Kappelen, Lyss, Merzligen, Mörigen, Oberwil bei Büren, Radelfingen, Rapperswil (BE), Seedorf (BE), Sutz-Lattrigen, Walperswil, Wengi, Worben",10695,922444,286882,1209325,{"$binary":{"bytes":106803,"sig":"other"}},{"min_x":2579639.965,"min_y":1202123.788,"max_x":2621048.182,"max_y":1231299.106}]
[7,"Brügg","731, 733, 390, 744, 746, 747, 748, 749","Aegerten, Brügg, Meinisberg, Orpund, Safnern, Scheuren, Schwadernau, Studen (BE)",3724,321195,153852,475047,{"$binary":{"bytes":21965,"sig":"other"}},{"min_x":2586019.281,"min_y":1217114.595,"max_x":2595440.156,"max_y":1224490.293}]
[26,"Tramelan","683, 687, 690, 691, 692, 694, 696, 437, 701, 716, ","Champoz, Corcelles (BE), Court, Crémines, Eschert, Grandval, Loveresse, Mont-Tramelan, Perrefitte, Petit-Val, Reconvilier, Roches (BE), Saicourt, Saules (BE), Seehof, Sorvilier, Tavannes, Tramelan, Valbirse",4299,370789,171710,542498,{"$binary":{"bytes":76445,"sig":"other"}},{"min_x":2569418.638,"min_y":1227676.956,"max_x":2609050.777,"max_y":1241284.17}]
[22,"Kirchberg (BE)","401, 405, 411, 412, 415, 420, 422","Aefligen, Ersigen, Kernenried, Kirchberg (BE), Lyssach, Rüdtligen-Alchenflüh, Rüti bei Lyssach",2685,231581,78111,309692,{"$binary":{"bytes":28749,"sig":"other"}},{"min_x":2607281.874,"min_y":1210725.651,"max_x":2615369.853,"max_y":1219357.775}]
[23,"Münchenbuchsee","951, 402, 381, 971, 533, 535, 948, 867, 406, 408, ","Affoltern im Emmental, Alchenstorf, Arch, Attiswil, Bätterkinden, Deisswil bei Münchenbuchsee, Forst-Längenbühl, Gurzelen, Hasle bei Burgdorf, Hellsau, Hindelbank, Höchstetten, Koppigen, Krauchthal, Leuzigen, Lützelflüh, Münchenbuchsee, Niederbipp, Oberbipp, Pieterlen, Rüegsau, Rumisberg, Rüti bei Büren, Schüpfen, Seftigen, Sumiswald, Trachselwald, Utzenstorf, Walliswil bei Niederbipp, Walliswil bei Wangen, Wangen an der Aare, Wattenwil, Wiedlisbach, Wiler bei Utzenstorf, Willadingen",16273,1403546,440224,1843770,{"$binary":{"bytes":255684,"sig":"other"}},{"min_x":2588981.084,"min_y":1175809.488,"max_x":2635225.088,"max_y":1238152.092}]
[34,"Burgdorf","404, 418","Burgdorf, Oberburg",3713,320246,194603,514849,{"$binary":{"bytes":32211,"sig":"other"}},{"min_x":2610386.9,"min_y":1203635.15,"max_x":2616415.812,"max_y":1214982.563}]
[2,"Ostermundigen","363, 358","Ostermundigen, Stettlen",4210,363113,241521,604633,{"$binary":{"bytes":25293,"sig":"other"}},{"min_x":2602913.1,"min_y":1198799.854,"max_x":2607691.733,"max_y":1202284.565}]
[18,"Ittigen","362","Ittigen",2157,186041,127143,313184,{"$binary":{"bytes":17101,"sig":"other"}},{"min_x":2601088.509,"min_y":1201815.784,"max_x":2604052.802,"max_y":1205305.522}]
[27,"Bolligen","352","Bolligen",1273,109796,26261,136058,{"$binary":{"bytes":24141,"sig":"other"}},{"min_x":2602814.052,"min_y":1201068.912,"max_x":2608471.385,"max_y":1205914.542}]
[35,"Moosseedorf","403, 538, 541, 540, 543, 544, 551, 557","Bäriswil, Fraubrunnen, Iffwil, Jegenstorf, Mattstetten, Moosseedorf, Urtenen-Schönbühl, Zuzwil (BE)",5109,440651,129607,570258,{"$binary":{"bytes":42797,"sig":"other"}},{"min_x":2600186.273,"min_y":1205037.341,"max_x":2609768.34,"max_y":1219079.769}]
[10,"Wohlen bei Bern","353, 354, 307, 360","Bremgarten bei Bern, Kirchlindach, Meikirch, Wohlen bei Bern",3701,319211,85091,404302,{"$binary":{"bytes":26141,"sig":"other"}},{"min_x":2587831.183,"min_y":1200975.087,"max_x":2600792.603,"max_y":1207926.351}]
[25,"Bern","351","Bern",22679,1956064,1169667,3125730,{"$binary":{"bytes":52445,"sig":"other"}},{"min_x":2589007.981,"min_y":1196443.171,"max_x":2604334.389,"max_y":1204343.6}]
[30,"Zollikofen","361","Zollikofen",2140,184575,119005,303580,{"$binary":{"bytes":13869,"sig":"other"}},{"min_x":2599528.593,"min_y":1203362.925,"max_x":2602686.167,"max_y":1206451.573}]
[3,"Köniz","870, 355","Kehrsatz, Köniz",9360,807300,387669,1194969,{"$binary":{"bytes":54493,"sig":"other"}},{"min_x":2591818.807,"min_y":1189893.363,"max_x":2603664.446,"max_y":1198414.549}]
[12,"Neuenegg","662, 663, 665, 666, 667, 668, 670, 671","Ferenbalm, Frauenkappelen, Gurbrü, Kriechenwil, Laupen, Mühleberg, Neuenegg, Wileroltigen",2871,247624,81153,328777,{"$binary":{"bytes":42977,"sig":"other"}},{"min_x":2580875.27,"min_y":1192752.899,"max_x":2594891.25,"max_y":1203610.527}]
[9,"Münsingen","866, 868, 611, 872, 616, 622, 623, 632","Gerzensee, Jaberg, Kiesen, Kirchdorf (BE), Münsingen, Oppligen, Rubigen, Wichtrach",4968,428490,115602,544092,{"$binary":{"bytes":46477,"sig":"other"}},{"min_x":2604959.758,"min_y":1182209.699,"max_x":2612971.756,"max_y":1195746.865}]
[1,"Belp","861","Belp",2235,192769,78465,271234,{"$binary":{"bytes":16189,"sig":"other"}},{"min_x":2602993.246,"min_y":1189044.163,"max_x":2608216.953,"max_y":1197074.791}]
[21,"Muri bei Bern","356","Muri bei Bern",2527,217954,80469,298423,{"$binary":{"bytes":20829,"sig":"other"}},{"min_x":2602320.715,"min_y":1196070.738,"max_x":2606561.148,"max_y":1199977.171}]
[17,"Worb","627","Worb",2181,188111,91850,279961,{"$binary":{"bytes":24941,"sig":"other"}},{"min_x":2606318.531,"min_y":1195354.57,"max_x":2613632.111,"max_y":1200066.532}]
[11,"Konolfingen","602, 603, 606, 607, 608, 609, 610, 612, 613, 615, ","Arni (BE), Biglen, Brenzikofen, Freimettigen, Grosshöchstetten, Häutligen, Herbligen, Konolfingen, Landiswil, Mirchel, Niederhünigen, Oberdiessbach, Oberhünigen, Oberthal, Walkringen, Zäziwil",4719,407014,94528,501541,{"$binary":{"bytes":97597,"sig":"other"}},{"min_x":2610532.929,"min_y":1183884.171,"max_x":2620830.859,"max_y":1203951.85}]
[8,"Langnau im Emmental","902","Langnau im Emmental",1849,159476,59041,218517,{"$binary":{"bytes":41837,"sig":"other"}},{"min_x":2623761.212,"min_y":1195140.255,"max_x":2632832.773,"max_y":1205796.346}]
[28,"Langenthal","321, 323, 329, 331, 332, 333, 337, 340, 341, 342, ","Aarwangen, Bannwil, Langenthal, Lotzwil, Madiswil, Melchnau, Roggwil (BE), Rütschelen, Schwarzhäusern, Thunstetten, Ursenbach, Wynau",8053,694571,315803,1010374,{"$binary":{"bytes":96913,"sig":"other"}},{"min_x":2620389.547,"min_y":1217544.453,"max_x":2633710.086,"max_y":1235347.863}]
[33,"Herzogenbuchsee","973, 976, 977, 979, 980, 982, 985, 421, 988, 989, ","Bettenhausen, Graben, Heimenhausen, Herzogenbuchsee, Inkwil, Niederönz, Ochlenberg, Rumendingen, Seeberg, Thörigen, Wynigen",3435,296269,99719,395988,{"$binary":{"bytes":74401,"sig":"other"}},{"min_x":2614512.717,"min_y":1213780.43,"max_x":2624213.083,"max_y":1230921.736}]
[15,"Meiringen","573, 574, 782, 783, 580, 784, 785, 589, 786, 592","Brienz (BE), Brienzwiler, Guttannen, Hasliberg, Hofstetten bei Brienz, Innertkirchen, Meiringen, Oberried am Brienzersee, Schattenhalb, Schwanden bei Brienz",2327,200704,57668,258372,{"$binary":{"bytes":91613,"sig":"other"}},{"min_x":2636766.191,"min_y":1152384.552,"max_x":2677745.365,"max_y":1182413.598}]
[14,"Steffisburg","925, 931, 932, 939, 940, 945","Fahrni, Homberg, Horrenbach-Buchen, Steffisburg, Teuffenthal (BE), Unterlangenegg",3522,303773,90659,394432,{"$binary":{"bytes":59053,"sig":"other"}},{"min_x":2612772.369,"min_y":1177355.133,"max_x":2630898.027,"max_y":1184631.464}]
[36,"Spiez","768","Spiez",2178,187853,66804,254656,{"$binary":{"bytes":54717,"sig":"other"}},{"min_x":2614104.541,"min_y":1167637.202,"max_x":2621943.834,"max_y":1174639.38}]
[19,"Unterseen","572, 576, 581, 584, 585, 587, 593, 594","Bönigen, Grindelwald, Interlaken, Lauterbrunnen, Leissigen, Matten bei Interlaken, Unterseen, Wilderswil",4590,395888,191947,587835,{"$binary":{"bytes":142883,"sig":"other"}},{"min_x":2623432.947,"min_y":1147408.727,"max_x":2653973.574,"max_y":1174790.824}]