{"columns":[{"name":"objectid","type":"int32"},{"name":"perid","type":"int16"},{"name":"pname","type":"string"},{"name":"flugjahr","type":"int32"},{"name":"flugdat","type":"string"},{"name":"hoehe","type":"double"},{"name":"dichte","type":"double"},{"name":"status","type":"int16"},{"name":"lidstat_status_de","type":"string"},{"name":"lidstat_status_fr","type":"string"},{"name":"zweck","type":"string"},{"name":"bemerk","type":"string"},{"name":"anehmer","type":"string"},{"name":"geopname","type":"string"},{"name":"datenherr","type":"string"},{"name":"darsttran","type":"int16"},{"name":"geometry","type":"binary"},{"name":"bbox","type":"struct<min_x: double, min_y: double, max_x: double, max_y: double>"}],"n_rows":21,"rows_kept":21,"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":21,"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":"perid","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"pname","type":"string","nullable":true,"metadata":null,"children":null},{"name":"flugjahr","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"flugdat","type":"string","nullable":true,"metadata":null,"children":null},{"name":"hoehe","type":"double","nullable":true,"metadata":null,"children":null},{"name":"dichte","type":"double","nullable":true,"metadata":null,"children":null},{"name":"status","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"lidstat_status_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"lidstat_status_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"zweck","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bemerk","type":"string","nullable":true,"metadata":null,"children":null},{"name":"anehmer","type":"string","nullable":true,"metadata":null,"children":null},{"name":"geopname","type":"string","nullable":true,"metadata":null,"children":null},{"name":"datenherr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"darsttran","type":"int16","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 perid (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 pname (String);\n  optional int32 field_id=-1 flugjahr (Int(bitWidth=32, isSigned=true));\n  optional binary field_id=-1 flugdat (String);\n  optional double field_id=-1 hoehe;\n  optional double field_id=-1 dichte;\n  optional int32 field_id=-1 status (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 lidstat_status_de (String);\n  optional binary field_id=-1 lidstat_status_fr (String);\n  optional binary field_id=-1 zweck (String);\n  optional binary field_id=-1 bemerk (String);\n  optional binary field_id=-1 anehmer (String);\n  optional binary field_id=-1 geopname (String);\n  optional binary field_id=-1 datenherr (String);\n  optional int32 field_id=-1 darsttran (Int(bitWidth=16, 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\": [\"Polygon Z\", \"MultiPolygon Z\"], \"bbox\": [2556240.186, 1132048.672, 2676493.949, 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}}}}}"]]}
[21,1,"Plaine Morte",2011,"10./11.02.2011",850.0,2.93,4,"Projekt abgeschlossen","Projet terminé","DTM, DOP","Grundlage Gefahrenbeurteilung","Swissphoto AG","0","Tiefbauamt des Kantons Bern ",20,{"$binary":{"bytes":445,"sig":"other"}},{"min_x":2602347.489,"min_y":1135191.676,"max_x":2608968.057,"max_y":1138568.185}]
[6,4,"Bern West",2013,"Juni/August 2013",1400.0,4.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","mit Klassifizierung; Helikopter mit TopEye MK III, Riegl LMS-Q780","Flotron AG, Flycom","LDTM50CM, LDOM50CM, LBEROH, LDTMABL1","Amt für Wald des Kantons Bern",50,{"$binary":{"bytes":5608089,"sig":"other"}},{"min_x":2581081.763,"min_y":1132048.672,"max_x":2631035.273,"max_y":1175657.672}]
[14,3,"Mannenberg (Zweisimmen)",2011,"29.03.2011",350.0,10.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","Detailerfassung archäologischer Objekte","Flotron AG, Helimap SA","0","Archäologischer Dienst des Kantons Bern",1,{"$binary":{"bytes":205,"sig":"other"}},{"min_x":2595024.783,"min_y":1157309.381,"max_x":2596458.826,"max_y":1158674.628}]
[2,5,"Bern West",2014,"November 2014",1500.0,4.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","mit Klassifizierung; Flächenflieger mit Riegl LMS-Q780","Flotron AG","LDTM50CM, LDOM50CM, LBEROH, LDTMABL1","Amt für Wald des Kantons Bern",50,{"$binary":{"bytes":13765,"sig":"other"}},{"min_x":2588683.04,"min_y":1171216.211,"max_x":2614379.812,"max_y":1187470.11}]
[10,5,"Thun, Altstadt",2011,"29.03.2011",350.0,20.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","Detailerfassung archäologischer Objekte","Flotron AG, Helimap SA","0","Archäologischer Dienst des Kantons Bern",1,{"$binary":{"bytes":301,"sig":"other"}},{"min_x":2614179.79,"min_y":1178222.103,"max_x":2615000.001,"max_y":1179002.105}]
[17,1,"Challnechwald (Niederried b. K., Kallnach, Fräschels)",2011,"29.03.2011",350.0,10.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","Detailerfassung archäologischer Objekte","Flotron AG, Helimap SA","0","Archäologischer Dienst des Kantons Bern",1,{"$binary":{"bytes":565,"sig":"other"}},{"min_x":2582752.051,"min_y":1205177.688,"max_x":2585232.536,"max_y":1207013.276}]
[15,4,"Jäissberg (Studen)",2011,"29.03.2011",350.0,10.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","Detailerfassung archäologischer Objekte","Flotron AG, Helimap SA","0","Archäologischer Dienst des Kantons Bern",1,{"$binary":{"bytes":181,"sig":"other"}},{"min_x":2587998.793,"min_y":1216991.94,"max_x":2589805.413,"max_y":1218499.185}]
[4,1,"Berner Jura",2011,"April-Mai 2011",2100.0,4.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","mit Klassifizierung; Flächenflieger mit Leica ALS 60","Flotron AG, Astec GmbH","LDTM50CM, LDOM50CM, LBEROH, LDTMABL1","Amt für Wald des Kantons Bern",50,{"$binary":{"bytes":62376,"sig":"other"}},{"min_x":2556240.186,"min_y":1212139.368,"max_x":2619858.283,"max_y":1243834.103}]
[7,2,"Bern Ost",2012,"März-April 2012",1200.0,4.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","mit Klassifizierung; Flächenflieger mit Leica ALS 70","Flotron AG, Astec GmbH","LDTM50CM, LDOM50CM, LBEROH, LDTMABL1","Amt für Wald des Kantons Bern",50,{"$binary":{"bytes":41009,"sig":"other"}},{"min_x":2589008.144,"min_y":1169935.819,"max_x":2639361.012,"max_y":1237301.353}]
[3,5,"Bern West",2014,"März 2014",1700.0,4.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","mit Klassifizierung; Flächenflieger mit Leica ALS70","Flotron AG, Astec GmbH","LDTM50CM, LDOM50CM, LBEROH, LDTMABL1","Amt für Wald des Kantons Bern",50,{"$binary":{"bytes":290847,"sig":"other"}},{"min_x":2568552.576,"min_y":1164968.798,"max_x":2625678.989,"max_y":1221207.199}]
[12,2,"Bern Ost",2014,"November 2014",1500.0,4.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","mit Klassifizierung; Flächenflieger mit Riegl LMS-Q780","Flotron AG","LDTM50CM, LDOM50CM, LBEROH, LDTMABL1","Amt für Wald des Kantons Bern",50,{"$binary":{"bytes":2029,"sig":"other"}},{"min_x":2613586.983,"min_y":1190047.577,"max_x":2614821.799,"max_y":1191516.234}]
[11,2,"Fryburg (Roggwil)",2011,"29.03.2011",350.0,10.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","Detailerfassung archäologischer Objekte","Flotron AG, Helimap SA","0","Archäologischer Dienst des Kantons Bern",1,{"$binary":{"bytes":181,"sig":"other"}},{"min_x":2628400.717,"min_y":1232510.463,"max_x":2629435.569,"max_y":1233306.981}]
[13,3,"Rotlaui",2011,"18.11.2011",0.0,2.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOP","Ereignisanalyse Hochwasser","Flotron AG","0","Tiefbauamt des Kantons Bern ",20,{"$binary":{"bytes":16069,"sig":"other"}},{"min_x":2665148.492,"min_y":1166482.946,"max_x":2666778.482,"max_y":1167462.939}]
[19,2,"Spreitgraben",2011,"18.11.2011",0.0,2.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOP","Ereignisanalyse Hochwasser","Flotron AG","0","Tiefbauamt des Kantons Bern ",30,{"$binary":{"bytes":56437,"sig":"other"}},{"min_x":2661365.388,"min_y":1165614.755,"max_x":2665000.512,"max_y":1169229.648}]
[16,9,"Spreitgraben",2011,"16.07.2011",400.0,2.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOP","Ereignisanalyse Hochwasser","Swissphoto AG","0","Tiefbauamt des Kantons Bern ",20,{"$binary":{"bytes":1213,"sig":"other"}},{"min_x":2662465.919,"min_y":1165163.981,"max_x":2664308.825,"max_y":1169172.831}]
[18,4,"Gletschersand",2011,"18.11.2011",0.0,2.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOP","Ereignisanalyse Hochwasser","Flotron AG","0","Tiefbauamt des Kantons Bern ",30,{"$binary":{"bytes":30901,"sig":"other"}},{"min_x":2646026.93,"min_y":1162371.692,"max_x":2651726.931,"max_y":1164781.707}]
[5,3,"Bern Ost",2012,"März/August 2012",700.0,4.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","mit Klassifizierung; Helikopter mit TopEye MK III, Riegl LMS-Q680","Flotron AG, Blom SWE","LDTM50CM, LDOM50CM, LBEROH, LDTMABL1","Amt für Wald des Kantons Bern",50,{"$binary":{"bytes":26381,"sig":"other"}},{"min_x":2622814.348,"min_y":1150564.787,"max_x":2676493.949,"max_y":1185798.248}]
[1,8,"Hasliaare",2011,"18./19.04.2011",400.0,12.6,4,"Projekt abgeschlossen","Projet terminé","DTM","Überflutungsmodellierung","Swissphoto AG","0","Tiefbauamt des Kantons Bern ",20,{"$binary":{"bytes":5989,"sig":"other"}},{"min_x":2646359.015,"min_y":1174442.084,"max_x":2658944.704,"max_y":1177615.585}]
[8,3,"Bern Ost",2014,"November 2014",1500.0,4.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","mit Klassifizierung; Flächenflieger mit Riegl LMS-Q780","Flotron AG","LDTM50CM, LDOM50CM, LBEROH, LDTMABL1","Amt für Wald des Kantons Bern",50,{"$binary":{"bytes":901,"sig":"other"}},{"min_x":2629438.833,"min_y":1174014.067,"max_x":2629733.836,"max_y":1174436.436}]
[9,3,"Bern Ost",2014,"November 2014",1500.0,4.0,4,"Projekt abgeschlossen","Projet terminé","DTM, DOM","mit Klassifizierung; Flächenflieger mit Riegl LMS-Q780","Flotron AG","LDTM50CM, LDOM50CM, LBEROH, LDTMABL1","Amt für Wald des Kantons Bern",50,{"$binary":{"bytes":2245,"sig":"other"}},{"min_x":2640294.568,"min_y":1171061.286,"max_x":2640997.971,"max_y":1171789.739}]
[20,10,"Lütschine",2011,"18./19.04.2011",500.0,7.5,4,"Projekt abgeschlossen","Projet terminé","DTM","Überflutungsmodellierung","Swissphoto AG","0","Tiefbauamt des Kantons Bern ",20,{"$binary":{"bytes":6637,"sig":"other"}},{"min_x":2632430.014,"min_y":1154645.635,"max_x":2647638.87,"max_y":1167741.816}]