{"columns":[{"name":"objectid","type":"int32"},{"name":"ravzname","type":"string"},{"name":"ravzbez","type":"string"},{"name":"ravznr","type":"int16"},{"name":"adresse","type":"string"},{"name":"plz_ort","type":"string"},{"name":"email","type":"string"},{"name":"telefon","type":"string"},{"name":"geometry","type":"binary"},{"name":"bbox","type":"struct<min_x: double, min_y: double, max_x: double, max_y: double>"}],"n_rows":13,"rows_kept":13,"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":13,"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":"ravzname","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ravzbez","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ravznr","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"adresse","type":"string","nullable":true,"metadata":null,"children":null},{"name":"plz_ort","type":"string","nullable":true,"metadata":null,"children":null},{"name":"email","type":"string","nullable":true,"metadata":null,"children":null},{"name":"telefon","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 ravzname (String);\n  optional binary field_id=-1 ravzbez (String);\n  optional int32 field_id=-1 ravznr (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 adresse (String);\n  optional binary field_id=-1 plz_ort (String);\n  optional binary field_id=-1 email (String);\n  optional binary field_id=-1 telefon (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\": [2582208.368, 1170256.556, 2633231.0, 1229954.627], \"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}}}}}"]]}
[8,"RAV Gümligen","RAV Gü",8,"Worbstrasse 223","3073 Gümligen","rav.guemligen@be.ch","+41 31 636 02 31",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2605160.877,"min_y":1198023.105,"max_x":2605160.877,"max_y":1198023.105}]
[7,"RAV Bern West","RAV Bw",7,"Lagerhausweg 10","3018 Bern","rav.bernwest@be.ch","+41 31 636 03 40",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2596613.0,"min_y":1198483.0,"max_x":2596613.0,"max_y":1198483.0}]
[4,"RAV Lyss","RAV Ly",4,"Bahnhofstrasse  9","3250 Lyss","rav.lyss@be.ch","+41 31 636 04 70",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2589925.95,"min_y":1213848.933,"max_x":2589925.95,"max_y":1213848.933}]
[3,"ORP Bienne","ORP Bi",2,"Rue Centrale 63","2501 Bienne","orp.bienne@be.ch","+41 31 635 35 60",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2585555.0,"min_y":1220570.0,"max_x":2585555.0,"max_y":1220570.0}]
[13,"RAV Biel","RAV Bi",3,"Zentralstrasse 63","2501 Biel","rav.biel@be.ch","+41 31 635 35 30",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2585555.0,"min_y":1220570.0,"max_x":2585555.0,"max_y":1220570.0}]
[2,"ORP Jura bernois","ORP Jb",1,"Rue du Quai 20","2710 Tavannes","orp.jura-bernois@be.ch","+41 31 636 17 00",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2582208.368,"min_y":1229954.627,"max_x":2582208.368,"max_y":1229954.627}]
[6,"RAV Bern Zentrum","RAV Bz",6,"Reiterstrasse 9b","3013 Bern","rav.bernzentrum@be.ch","+41 31 636 02 62",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2601727.873,"min_y":1200343.949,"max_x":2601727.873,"max_y":1200343.949}]
[5,"RAV Zollikofen","RAV Zo",5,"Industriestrasse 35","3052 Zollikofen","rav.zollikofen@be.ch","+41 31 636 08 00",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2602038.251,"min_y":1206067.362,"max_x":2602038.251,"max_y":1206067.362}]
[9,"RAV Burgdorf","RAV Bd",10,"Oberburgstrasse 8","3400 Burgdorf","rav.burgdorf@be.ch","+41 31 636 13 22",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2614067.649,"min_y":1211395.427,"max_x":2614067.649,"max_y":1211395.427}]
[1,"RAV Langenthal","RAV Lt",9,"Murgenthalstrasse 15","4901 Langenthal","rav.langenthal@be.ch","+41 31 636 13 00",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2626372.947,"min_y":1229709.154,"max_x":2626372.947,"max_y":1229709.154}]
[10,"RAV Thun","RAV Th",11,"Mönchstrasse 4b","3600 Thun","rav.thun@be.ch","+41 31 636 34 60",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2614511.962,"min_y":1178161.918,"max_x":2614511.962,"max_y":1178161.918}]
[11,"RAV Spiez","RAV Sp",12,"Krattigstrasse 4","3700 Spiez","rav.spiez@be.ch","+41 31 636 03 20",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2618729.018,"min_y":1170256.556,"max_x":2618729.018,"max_y":1170256.556}]
[12,"RAV Interlaken","RAV In",13,"Kammistrasse 13","3800 Interlaken","rav.interlaken@be.ch","+41 31 636 20 01",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2633231.0,"min_y":1171286.0,"max_x":2633231.0,"max_y":1171286.0}]