{"columns":[{"name":"objectid","type":"int32"},{"name":"titel_de","type":"string"},{"name":"titel_fr","type":"string"},{"name":"abkrz_de","type":"string"},{"name":"abkrz_fr","type":"string"},{"name":"artnr_de","type":"string"},{"name":"artnr_fr","type":"string"},{"name":"doktyp_de","type":"string"},{"name":"doktyp_fr","type":"string"},{"name":"offiznr_de","type":"string"},{"name":"offiznr_fr","type":"string"},{"name":"doklink_de","type":"string"},{"name":"doklink_fr","type":"string"},{"name":"auszgindex","type":"int16"},{"name":"pub_ab","type":"timestamp[us]"},{"name":"pub_bis","type":"timestamp[us]"},{"name":"rechtst_de","type":"string"},{"name":"rechtst_fr","type":"string"},{"name":"ref_id","type":"string"},{"name":"amt_id","type":"string"},{"name":"amtt_amtname_de","type":"string"},{"name":"amtt_amtname_fr","type":"string"},{"name":"amtt_weblink_de","type":"string"},{"name":"amtt_weblink_fr","type":"string"},{"name":"amtt_uid_amt","type":"string"}],"n_rows":5,"rows_kept":5,"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":0,"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.4 (build 6ddac802ff)","schema":{"fields":[{"name":"objectid","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"titel_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"titel_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"abkrz_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"abkrz_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"artnr_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"artnr_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"doktyp_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"doktyp_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"offiznr_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"offiznr_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"doklink_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"doklink_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"auszgindex","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"pub_ab","type":"timestamp[us]","nullable":true,"metadata":null,"children":null},{"name":"pub_bis","type":"timestamp[us]","nullable":true,"metadata":null,"children":null},{"name":"rechtst_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"rechtst_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ref_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"amt_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"amtt_amtname_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"amtt_amtname_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"amtt_weblink_de","type":"string","nullable":true,"metadata":null,"children":null},{"name":"amtt_weblink_fr","type":"string","nullable":true,"metadata":null,"children":null},{"name":"amtt_uid_amt","type":"string","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 titel_de (String);\n  optional binary field_id=-1 titel_fr (String);\n  optional binary field_id=-1 abkrz_de (String);\n  optional binary field_id=-1 abkrz_fr (String);\n  optional binary field_id=-1 artnr_de (String);\n  optional binary field_id=-1 artnr_fr (String);\n  optional binary field_id=-1 doktyp_de (String);\n  optional binary field_id=-1 doktyp_fr (String);\n  optional binary field_id=-1 offiznr_de (String);\n  optional binary field_id=-1 offiznr_fr (String);\n  optional binary field_id=-1 doklink_de (String);\n  optional binary field_id=-1 doklink_fr (String);\n  optional int32 field_id=-1 auszgindex (Int(bitWidth=16, isSigned=true));\n  optional int64 field_id=-1 pub_ab (Timestamp(isAdjustedToUTC=false, timeUnit=microseconds, is_from_converted_type=false, force_set_converted_type=false));\n  optional int64 field_id=-1 pub_bis (Timestamp(isAdjustedToUTC=false, timeUnit=microseconds, is_from_converted_type=false, force_set_converted_type=false));\n  optional binary field_id=-1 rechtst_de (String);\n  optional binary field_id=-1 rechtst_fr (String);\n  optional binary field_id=-1 ref_id (String);\n  optional binary field_id=-1 amt_id (String);\n  optional binary field_id=-1 amtt_amtname_de (String);\n  optional binary field_id=-1 amtt_amtname_fr (String);\n  optional binary field_id=-1 amtt_weblink_de (String);\n  optional binary field_id=-1 amtt_weblink_fr (String);\n  optional binary field_id=-1 amtt_uid_amt (String);\n}\n"},"kv_metadata":[]}
[1,"Überbauungsvorschriften (Geschäftsnummer SöL 20207989)","Règlement de quartie (Numéro d'affaire GICP 20207989)",null,null,null,null,"Rechtsvorschrift","Législation",null,null,"https://oerebfiles.apps.be.ch/9108/6051/SOEL_20207989.pdf","https://oerebfiles.apps.be.ch/9108/6051/SOEL_20207989.pdf",1,null,null,"inKraft","En_vigueur","20207989","1","Amt für Wasser und Abfall des Kantons Bern","Direction des travaux publics et des transports\n","https://www.bvd.be.ch/de/start/ueber-uns/amt-fuer-wasser-und-abfall.html","https://www.bvd.be.ch/fr/start/ueber-uns/amt-fuer-wasser-und-abfall.html","CHE-113.569.066"]
[2,"Überbauungsvorschriften (Geschäftsnummer SöL 20207991)","Règlement de quartie (Numéro d'affaire GICP 20207991)",null,null,null,null,"Rechtsvorschrift","Législation",null,null,"https://oerebfiles.apps.be.ch/9108/6051/SOEL_20207991.pdf","https://oerebfiles.apps.be.ch/9108/6051/SOEL_20207991.pdf",1,null,null,"inKraft","En_vigueur","20207991","1","Amt für Wasser und Abfall des Kantons Bern","Direction des travaux publics et des transports\n","https://www.bvd.be.ch/de/start/ueber-uns/amt-fuer-wasser-und-abfall.html","https://www.bvd.be.ch/fr/start/ueber-uns/amt-fuer-wasser-und-abfall.html","CHE-113.569.066"]
[3,"Überbauungsvorschriften (Geschäftsnummer SöL 20218648)","Règlement de quartie (Numéro d'affaire GICP 20218648)",null,null,null,null,"Rechtsvorschrift","Législation",null,null,"https://oerebfiles.apps.be.ch/9108/6051/SOEL_20218648.pdf","https://oerebfiles.apps.be.ch/9108/6051/SOEL_20218648.pdf",1,null,null,"inKraft","En_vigueur","20218648","1","Amt für Wasser und Abfall des Kantons Bern","Direction des travaux publics et des transports\n","https://www.bvd.be.ch/de/start/ueber-uns/amt-fuer-wasser-und-abfall.html","https://www.bvd.be.ch/fr/start/ueber-uns/amt-fuer-wasser-und-abfall.html","CHE-113.569.066"]
[4,"Überbauungsvorschriften (Geschäftsnummer SöL 20223909)","Règlement de quartie (Numéro d'affaire GICP 20223909)",null,null,null,null,"Rechtsvorschrift","Législation",null,null,"https://oerebfiles.apps.be.ch/9108/6051/SOEL_20223909.pdf","https://oerebfiles.apps.be.ch/9108/6051/SOEL_20223909.pdf",1,null,null,"inKraft","En_vigueur","20223909","1","Amt für Wasser und Abfall des Kantons Bern","Direction des travaux publics et des transports\n","https://www.bvd.be.ch/de/start/ueber-uns/amt-fuer-wasser-und-abfall.html","https://www.bvd.be.ch/fr/start/ueber-uns/amt-fuer-wasser-und-abfall.html","CHE-113.569.066"]
[5,"Überbauungsvorschriften (Geschäftsnummer SöL 20225513)","Règlement de quartie (Numéro d'affaire GICP 20225513)",null,null,null,null,"Rechtsvorschrift","Législation",null,null,"https://oerebfiles.apps.be.ch/9108/6051/SOEL_20225513.pdf","https://oerebfiles.apps.be.ch/9108/6051/SOEL_20225513.pdf",1,null,null,"inKraft","En_vigueur","20225513","1","Amt für Wasser und Abfall des Kantons Bern","Direction des travaux publics et des transports\n","https://www.bvd.be.ch/de/start/ueber-uns/amt-fuer-wasser-und-abfall.html","https://www.bvd.be.ch/fr/start/ueber-uns/amt-fuer-wasser-und-abfall.html","CHE-113.569.066"]