{"columns":[{"name":"objectid","type":"int32"},{"name":"gemname","type":"string"},{"name":"guelteintr","type":"timestamp[us]"},{"name":"bfsnr","type":"int32"},{"name":"geometry","type":"binary"},{"name":"bbox","type":"struct<min_x: double, min_y: double, max_x: double, max_y: double>"}],"n_rows":37,"rows_kept":37,"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":37,"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":"gemname","type":"string","nullable":true,"metadata":null,"children":null},{"name":"guelteintr","type":"timestamp[us]","nullable":true,"metadata":null,"children":null},{"name":"bfsnr","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 gemname (String);\n  optional int64 field_id=-1 guelteintr (Timestamp(isAdjustedToUTC=false, timeUnit=microseconds, is_from_converted_type=false, force_set_converted_type=false));\n  optional int32 field_id=-1 bfsnr (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.1.0\", \"primary_column\": \"geometry\", \"columns\": {\"geometry\": {\"encoding\": \"WKB\", \"geometry_types\": [\"LineString\"], \"bbox\": [2576115.461, 1187438.922, 2619471.256, 1227098.202], \"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}}}}}"]]}
[6,"Münchenwiler","2009-12-14T00:00:00.000000",669,{"$binary":{"bytes":137,"sig":"other"}},{"min_x":2576115.461,"min_y":1196463.084,"max_x":2576248.918,"max_y":1196477.561}]
[15,"Neuenegg","2016-11-18T00:00:00.000000",670,{"$binary":{"bytes":169,"sig":"other"}},{"min_x":2585756.804,"min_y":1195579.496,"max_x":2585849.263,"max_y":1195621.452}]
[11,"Laupen","2022-03-23T00:00:00.000000",667,{"$binary":{"bytes":57,"sig":"other"}},{"min_x":2586150.418,"min_y":1194166.358,"max_x":2586158.053,"max_y":1194195.087}]
[16,"Schwarzenburg","2025-09-16T00:00:00.000000",855,{"$binary":{"bytes":89,"sig":"other"}},{"min_x":2591306.226,"min_y":1187438.922,"max_x":2591350.554,"max_y":1187471.041}]
[17,"Köniz","2022-03-03T00:00:00.000000",355,{"$binary":{"bytes":57,"sig":"other"}},{"min_x":2595536.247,"min_y":1197646.096,"max_x":2595559.298,"max_y":1197681.558}]
[36,"Bern","2024-05-02T00:00:00.000000",351,{"$binary":{"bytes":57,"sig":"other"}},{"min_x":2595536.247,"min_y":1197646.096,"max_x":2595559.298,"max_y":1197681.558}]
[34,"Niederönz","2017-11-09T00:00:00.000000",982,{"$binary":{"bytes":569,"sig":"other"}},{"min_x":2619321.064,"min_y":1227087.162,"max_x":2619471.256,"max_y":1227098.202}]
[35,"Herzogenbuchsee","2017-11-09T00:00:00.000000",979,{"$binary":{"bytes":569,"sig":"other"}},{"min_x":2619321.064,"min_y":1227087.162,"max_x":2619471.256,"max_y":1227098.202}]
[19,"Oberburg","2024-05-02T00:00:00.000000",418,{"$binary":{"bytes":1257,"sig":"other"}},{"min_x":2612235.283,"min_y":1210690.519,"max_x":2612557.498,"max_y":1211133.856}]
[8,"Vechigen","2022-06-29T00:00:00.000000",359,{"$binary":{"bytes":57,"sig":"other"}},{"min_x":2611162.548,"min_y":1199599.687,"max_x":2611168.545,"max_y":1199608.062}]
[7,"Vechigen","2025-12-01T00:00:00.000000",359,{"$binary":{"bytes":857,"sig":"other"}},{"min_x":2608984.791,"min_y":1198785.624,"max_x":2609125.511,"max_y":1199124.655}]
[20,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":41,"sig":"other"}},{"min_x":2607549.483,"min_y":1205190.856,"max_x":2607560.432,"max_y":1205212.088}]
[24,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":105,"sig":"other"}},{"min_x":2607553.158,"min_y":1205208.013,"max_x":2607555.49,"max_y":1205208.959}]
[23,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":41,"sig":"other"}},{"min_x":2607555.49,"min_y":1205208.959,"max_x":2607558.18,"max_y":1205210.787}]
[22,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":41,"sig":"other"}},{"min_x":2607558.18,"min_y":1205210.787,"max_x":2607560.118,"max_y":1205212.418}]
[21,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":41,"sig":"other"}},{"min_x":2607560.118,"min_y":1205212.088,"max_x":2607560.432,"max_y":1205212.418}]
[25,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":105,"sig":"other"}},{"min_x":2607550.716,"min_y":1205207.9832662567,"max_x":2607553.158,"max_y":1205208.388}]
[26,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":41,"sig":"other"}},{"min_x":2607548.214,"min_y":1205208.388,"max_x":2607550.716,"max_y":1205209.628}]
[28,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":41,"sig":"other"}},{"min_x":2607525.972,"min_y":1205199.533,"max_x":2607548.214,"max_y":1205209.628}]
[30,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":41,"sig":"other"}},{"min_x":2607546.279,"min_y":1205172.931,"max_x":2607547.672,"max_y":1205181.95}]
[29,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":41,"sig":"other"}},{"min_x":2607547.672,"min_y":1205181.95,"max_x":2607549.483,"max_y":1205190.856}]
[33,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":41,"sig":"other"}},{"min_x":2607547.576,"min_y":1205131.093,"max_x":2607548.056,"max_y":1205141.939}]
[32,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":41,"sig":"other"}},{"min_x":2607546.385,"min_y":1205141.939,"max_x":2607547.576,"max_y":1205163.825}]
[31,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":41,"sig":"other"}},{"min_x":2607546.279,"min_y":1205163.825,"max_x":2607546.385,"max_y":1205172.931}]
[27,"Krauchthal","2013-12-06T00:00:00.000000",414,{"$binary":{"bytes":41,"sig":"other"}},{"min_x":2607472.803,"min_y":1205172.677,"max_x":2607525.972,"max_y":1205199.533}]
[9,"Vechigen","2025-12-19T00:00:00.000000",359,{"$binary":{"bytes":57,"sig":"other"}},{"min_x":2608398.416,"min_y":1202591.178,"max_x":2608401.206,"max_y":1202664.397}]
[1,"Moosseedorf","2024-07-31T00:00:00.000000",544,{"$binary":{"bytes":57,"sig":"other"}},{"min_x":2602218.881,"min_y":1206671.018,"max_x":2602231.051,"max_y":1206673.318}]
[12,"Münchenbuchsee","2024-04-22T00:00:00.000000",546,{"$binary":{"bytes":57,"sig":"other"}},{"min_x":2602218.881,"min_y":1206671.018,"max_x":2602231.051,"max_y":1206673.318}]
[13,"Münchenbuchsee","2020-07-21T00:00:00.000000",546,{"$binary":{"bytes":57,"sig":"other"}},{"min_x":2602231.051,"min_y":1206664.238,"max_x":2602254.131,"max_y":1206671.018}]
[4,"Zollikofen","2025-10-07T00:00:00.000000",361,{"$binary":{"bytes":89,"sig":"other"}},{"min_x":2601491.566,"min_y":1205525.699,"max_x":2601547.318,"max_y":1205585.013}]
[14,"Münchenbuchsee","2025-10-07T00:00:00.000000",546,{"$binary":{"bytes":89,"sig":"other"}},{"min_x":2601491.566,"min_y":1205525.699,"max_x":2601547.318,"max_y":1205585.013}]
[3,"Zollikofen","2025-10-07T00:00:00.000000",361,{"$binary":{"bytes":217,"sig":"other"}},{"min_x":2601491.566,"min_y":1205525.699,"max_x":2601558.46,"max_y":1205585.013}]
[5,"Muri bei Bern","2024-11-12T00:00:00.000000",356,{"$binary":{"bytes":57,"sig":"other"}},{"min_x":2602893.72,"min_y":1198422.672,"max_x":2602893.81,"max_y":1198426.542}]
[37,"Bern","2024-10-01T00:00:00.000000",351,{"$binary":{"bytes":57,"sig":"other"}},{"min_x":2602893.72,"min_y":1198422.672,"max_x":2602893.81,"max_y":1198426.542}]
[2,"Stettlen","2025-12-15T00:00:00.000000",358,{"$binary":{"bytes":57,"sig":"other"}},{"min_x":2605613.308,"min_y":1200652.085,"max_x":2605614.139,"max_y":1200704.541}]
[10,"Ostermundigen","2025-12-16T00:00:00.000000",363,{"$binary":{"bytes":57,"sig":"other"}},{"min_x":2605607.226,"min_y":1200734.557,"max_x":2605608.118,"max_y":1200735.188}]
[18,"Köniz","2021-08-19T00:00:00.000000",355,{"$binary":{"bytes":121,"sig":"other"}},{"min_x":2601936.695,"min_y":1196303.451,"max_x":2601960.92,"max_y":1196326.119}]