{"columns":[{"name":"objectid","type":"int32"},{"name":"ebstelle","type":"string"},{"name":"adresse","type":"string"},{"name":"plz","type":"int16"},{"name":"ort","type":"string"},{"name":"telefon","type":"string"},{"name":"email","type":"string"},{"name":"url","type":"string"},{"name":"egid","type":"int32"},{"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":"ebstelle","type":"string","nullable":true,"metadata":null,"children":null},{"name":"adresse","type":"string","nullable":true,"metadata":null,"children":null},{"name":"plz","type":"int16","nullable":true,"metadata":null,"children":null},{"name":"ort","type":"string","nullable":true,"metadata":null,"children":null},{"name":"telefon","type":"string","nullable":true,"metadata":null,"children":null},{"name":"email","type":"string","nullable":true,"metadata":null,"children":null},{"name":"url","type":"string","nullable":true,"metadata":null,"children":null},{"name":"egid","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 ebstelle (String);\n  optional binary field_id=-1 adresse (String);\n  optional int32 field_id=-1 plz (Int(bitWidth=16, isSigned=true));\n  optional binary field_id=-1 ort (String);\n  optional binary field_id=-1 telefon (String);\n  optional binary field_id=-1 email (String);\n  optional binary field_id=-1 url (String);\n  optional int32 field_id=-1 egid (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\": [\"Polygon\", \"MultiPolygon\"], \"bbox\": [2556242.237, 1130584.965, 2677740.501, 1243834.79], \"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}}}}}"]]}
[12,"Erziehungsberatung EB Spiez","Seestrasse 34",3700,"Spiez","+41 31 635 99 00","eb.spiez@be.ch","https://www.eb.bkd.be.ch/de/start/ueber-uns/regionalstellen/eb-spiez.html",1394617,{"$binary":{"bytes":66141,"sig":"other"}},{"min_x":2581081.764,"min_y":1130584.965,"max_x":2631090.842,"max_y":1174639.38}]
[10,"Erziehungsberatung EB Thun","Scheibenstrasse 11C",3600,"Thun","+41 31 635 58 58","eb.thun@be.ch","https://www.eb.bkd.be.ch/de/start/ueber-uns/regionalstellen/eb-thun.html",190637652,{"$binary":{"bytes":55235,"sig":"other"}},{"min_x":2601204.119,"min_y":1169938.068,"max_x":2632773.591,"max_y":1190516.108}]
[3,"Erziehungsberatung EB Köniz-Liebefeld","Waldeggstrasse 37",3097,"Liebefeld","+41 31 635 24 50","eb.koeniz@be.ch","https://www.eb.bkd.be.ch/de/start/ueber-uns/regionalstellen/eb-koeniz.html",190102184,{"$binary":{"bytes":39597,"sig":"other"}},{"min_x":2588688.021,"min_y":1168848.668,"max_x":2609741.158,"max_y":1198414.549}]
[8,"Service psychologique pour enfants et adolescents SPE St-Imier","Rue Francillon 16",2610,"St-Imier","+41 31 636 16 96","spe.st-imier@be.ch","https://www.eb.bkd.be.ch/fr/start/ueber-uns/regionalstellen/eb-st-imier.html",1319980,{"$binary":{"bytes":15901,"sig":"other"}},{"min_x":2556242.237,"min_y":1215060.01,"max_x":2574805.609,"max_y":1228843.242}]
[11,"Service psychologique pour enfants et adolescents SPE Bienne","Rue du Contrôle 20",2503,"Biel-Bienne","+41 31 635 95 95","spe.biel-bienne@be.ch","https://www.eb.bkd.be.ch/fr/start/ueber-uns/regionalstellen/eb-bienne.html",190198916,{"$binary":{"bytes":32483,"sig":"other"}},{"min_x":2568491.966,"min_y":1212139.371,"max_x":2593419.635,"max_y":1229631.553}]
[2,"Erziehungsberatung EB Biel","Bahnhofstrasse 50",2502,"Biel-Bienne","+41 31 636 15 20","eb.biel@be.ch","https://www.eb.bkd.be.ch/de/start/ueber-uns/regionalstellen/eb-biel.html",1755527,{"$binary":{"bytes":77213,"sig":"other"}},{"min_x":2568552.574,"min_y":1202123.788,"max_x":2609050.777,"max_y":1241284.17}]
[6,"Service psychologique pour enfants et adolescents SPE Tavannes","Grand Rue 4",2710,"Tavannes","+41 31 636 16 86","spe.tavannes@be.ch","https://www.eb.bkd.be.ch/fr/start/ueber-uns/regionalstellen/eb-tavannes.html",1380369,{"$binary":{"bytes":43171,"sig":"other"}},{"min_x":2569418.638,"min_y":1221583.634,"max_x":2610093.259,"max_y":1243834.79}]
[1,"Erziehungsberatung EB Bern","Effingerstrasse 12",3011,"Bern","+41 31 633 41 41","eb.bern@be.ch","https://www.eb.bkd.be.ch/de/start/ueber-uns/regionalstellen/eb-bern.html",2242686,{"$binary":{"bytes":64311,"sig":"other"}},{"min_x":2575209.931,"min_y":1185975.15,"max_x":2612971.756,"max_y":1214215.781}]
[4,"Erziehungsberatung EB Ittigen","Gerbelacker 1",3063,"Ittigen","+41 31 635 99 25","eb.ittigen@be.ch","https://www.eb.bkd.be.ch/de/start/ueber-uns/regionalstellen/eb-ittigen.html",1287789,{"$binary":{"bytes":33229,"sig":"other"}},{"min_x":2601088.509,"min_y":1192375.704,"max_x":2617170.92,"max_y":1205914.542}]
[13,"Erziehungsberatung EB Langnau","Oberstrasse 20",3550,"Langnau i.E.","+41 31 636 15 60","eb.langnau@be.ch","https://www.eb.bkd.be.ch/de/start/ueber-uns/regionalstellen/eb-langnau.html",9023168,{"$binary":{"bytes":62669,"sig":"other"}},{"min_x":2610534.121,"min_y":1181694.682,"max_x":2639362.476,"max_y":1206724.702}]
[9,"Erziehungsberatung EB Burgdorf","Dunantstr. 7b",3400,"Burgdorf","+41 31 635 52 52","eb.burgdorf@be.ch","https://www.eb.bkd.be.ch/de/start/ueber-uns/regionalstellen/eb-burgdorf.html",190366880,{"$binary":{"bytes":61197,"sig":"other"}},{"min_x":2601726.725,"min_y":1196041.124,"max_x":2635225.088,"max_y":1224239.887}]
[7,"Erziehungsberatung EB Langenthal","Jurastrasse 46",4900,"Langenthal","+41 31 636 15 70","eb.langenthal@be.ch","https://www.eb.bkd.be.ch/de/start/ueber-uns/regionalstellen/eb-langenthal.html",1260858,{"$binary":{"bytes":43565,"sig":"other"}},{"min_x":2610705.391,"min_y":1210713.743,"max_x":2634282.266,"max_y":1238152.092}]
[5,"Erziehungsberatung EB Interlaken","Bahnhofstrasse 20",3800,"Interlaken","+41 31 635 36 50","eb.interlaken@be.ch","https://www.eb.bkd.be.ch/de/start/ueber-uns/regionalstellen/eb-interlaken.html",9005752,{"$binary":{"bytes":86951,"sig":"other"}},{"min_x":2623442.352,"min_y":1147408.727,"max_x":2677740.501,"max_y":1182846.624}]