{"columns":[{"name":"objectid","type":"int32"},{"name":"stat_nr","type":"string"},{"name":"stat_name","type":"string"},{"name":"gemname","type":"string"},{"name":"e_koord","type":"double"},{"name":"n_koord","type":"double"},{"name":"gewname","type":"string"},{"name":"daten_ab","type":"timestamp[us]"},{"name":"url_info","type":"string"},{"name":"geometry","type":"binary"},{"name":"bbox","type":"struct<min_x: double, min_y: double, max_x: double, max_y: double>"}],"n_rows":18,"rows_kept":18,"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":18,"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":"stat_nr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"stat_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"gemname","type":"string","nullable":true,"metadata":null,"children":null},{"name":"e_koord","type":"double","nullable":true,"metadata":null,"children":null},{"name":"n_koord","type":"double","nullable":true,"metadata":null,"children":null},{"name":"gewname","type":"string","nullable":true,"metadata":null,"children":null},{"name":"daten_ab","type":"timestamp[us]","nullable":true,"metadata":null,"children":null},{"name":"url_info","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 stat_nr (String);\n  optional binary field_id=-1 stat_name (String);\n  optional binary field_id=-1 gemname (String);\n  optional double field_id=-1 e_koord;\n  optional double field_id=-1 n_koord;\n  optional binary field_id=-1 gewname (String);\n  optional int64 field_id=-1 daten_ab (Timestamp(isAdjustedToUTC=false, timeUnit=microseconds, is_from_converted_type=false, force_set_converted_type=false));\n  optional binary field_id=-1 url_info (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\": [2568420.0, 1181875.0, 2630257.0, 1231650.0], \"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}}}}}"]]}
[18,"A099","Bibere, Kerzers, Autobahnviadukt","Kerzers",2581273.0,1201861.0,"Bibere","2007-11-08T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A099&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2581273.0,"min_y":1201861.0,"max_x":2581273.0,"max_y":1201861.0}]
[3,"A022","Suze, Villeret, Pont de la STEP","Villeret",2568420.0,1223260.0,"Suze","1993-10-31T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A022&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2568420.0,"min_y":1223260.0,"max_x":2568420.0,"max_y":1223260.0}]
[15,"2307","Suze Sonceboz","Sonceboz-Sombeval",2579810.0,1227350.0,"Suze","2004-02-11T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=2307&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2579810.0,"min_y":1227350.0,"max_x":2579810.0,"max_y":1227350.0}]
[16,"A047","Worben, Hinderfeld","Worben",2588569.0,1216818.0,"Sagibach Worben","1995-05-22T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A047&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2588569.0,"min_y":1216818.0,"max_x":2588569.0,"max_y":1216818.0}]
[1,"A069","Lyssbach, Schüpfen, Bundkofen","Schüpfen",2594451.0,1210540.0,"Lyssbach","1991-07-10T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A069&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2594451.0,"min_y":1210540.0,"max_x":2594451.0,"max_y":1210540.0}]
[5,"A062","Chrouchtalbach, Krauchthal, Weichel","Krauchthal",2609787.0,1207551.0,"Chrouchtalbach","1998-07-02T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A062&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2609787.0,"min_y":1207551.0,"max_x":2609787.0,"max_y":1207551.0}]
[12,"A070","Luterbach, Oberburg","Oberburg",2614020.0,1209727.0,"Luterbach","1984-01-01T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A070&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2614020.0,"min_y":1209727.0,"max_x":2614020.0,"max_y":1209727.0}]
[13,"A042","Urtenen, Kernenried","Kernenried",2607891.0,1213532.0,"Urtenen","1987-07-17T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A042&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2607891.0,"min_y":1213532.0,"max_x":2607891.0,"max_y":1213532.0}]
[10,"A115","Ösch, Koppigen, Neumatt","Koppigen",2612803.0,1220799.0,"Ösch","2019-12-01T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A115&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2612803.0,"min_y":1220799.0,"max_x":2612803.0,"max_y":1220799.0}]
[4,"A029","Önz, Heimenhausen, Hueb","Heimenhausen",2619680.0,1228265.0,"Önz","1987-01-01T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A029&status=0",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2619680.0,"min_y":1228265.0,"max_x":2619680.0,"max_y":1228265.0}]
[17,"A116","Oenz, Wanzwil","Heimenhausen",2619405.0,1227655.0,"Önz","1987-01-01T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A116&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2619405.0,"min_y":1227655.0,"max_x":2619405.0,"max_y":1227655.0}]
[2,"A025","Langete, Roggwil BE, Obere Brüel","Roggwil (BE)",2627513.0,1231510.0,"Langete","1984-01-01T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A025&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2627513.0,"min_y":1231510.0,"max_x":2627513.0,"max_y":1231510.0}]
[7,"A088","Rot, Roggwil BE, Seijumatte","Roggwil (BE)",2630257.0,1231650.0,"Rot","2005-05-20T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A088&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2630257.0,"min_y":1231650.0,"max_x":2630257.0,"max_y":1231650.0}]
[14,"A051","Langete, Leimiswil, Weinstegen","Madiswil",2626212.0,1221961.0,"Langete","1996-06-10T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A051&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2626212.0,"min_y":1221961.0,"max_x":2626212.0,"max_y":1221961.0}]
[8,"2343","Langete, Huttwil","Huttwil",2629560.0,1219135.0,"Langete","2002-01-01T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=2343&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2629560.0,"min_y":1219135.0,"max_x":2629560.0,"max_y":1219135.0}]
[9,"2500","Worble Ittigen","Ittigen",2603005.0,1202455.0,"Worble","1998-01-01T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=2500&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2603005.0,"min_y":1202455.0,"max_x":2603005.0,"max_y":1202455.0}]
[6,"A086","Chise, Freimettigen, ARA","Freimettigen",2614322.0,1190508.0,"Chise","2004-11-12T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A086&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2614322.0,"min_y":1190508.0,"max_x":2614322.0,"max_y":1190508.0}]
[11,"A102","Gürbe, Burgistein Station","Burgistein",2605886.0,1181875.0,"Gürbe","2009-01-01T00:00:00.000000","https://www.wada.sites.be.ch/geoportal/trosec/html/details.html?station=A102&status=1",{"$binary":{"bytes":21,"sig":"other"}},{"min_x":2605886.0,"min_y":1181875.0,"max_x":2605886.0,"max_y":1181875.0}]