{"id":"70178c2d-3404-41ad-8f3f-55403025b0fa","type":"DATASET","name":"Search Directory - All construction work at schools in Steglitz-Zehlendorf","slug":"search-directory-all-construction-work-at-schools-in-steglitz-zehlendorf","description":"Here you will find data on construction measures at schools in Steglitz-Zehlendorf as part of the Berlin School Construction Offensive. The data is successively completed.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"https://www.berlin.de/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/alle-baumassnahmen/index.php/index/all.csv?q=","status":"ACTIVE","verification_state":"VERIFIED","tags":["education"],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=berlin.de","primary_source_url":"https://www.berlin.de/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/alle-baumassnahmen/index.php/index/all.csv?q=","extraction_confidence":"0.16","created_at":"2026-06-27T11:14:48.017Z","updated_at":"2026-08-16T08:24:23.049Z","last_verified_at":"2026-08-16T08:24:23.049Z","deprecated_at":null,"ranking_score":56,"last_ranked_at":"2026-08-09T15:59:15.293Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-08T03:43:26.587Z","search_vector":"'a':190B,245B 'all':129A 'and':194B,201B 'as':152B,182B,215B,230B 'at':132A,146B,170B,205B 'avail':108B 'available':234B 'becom':107B 'becomes':233B 'being':216B 'berlin':30B,48B,60B,125B,156B,174B,186B,251B 'build':77B 'building':203B 'carri':54B 'carried':180B 'complet':38B,92B 'completed':164B,218B 'construct':4A,18B,32B,42B,62B,96B 'construction':130A,144B,158B,168B,188B,222B 'coverag':94B 'coverage':220B 'data':16B,35B,142B,161B 'dataset':40B,86B,166B,212B 'describ':88B 'described':214B 'directori':2A 'directory':128A 'district':49B,84B,175B,210B 'educ':122B,126C 'education':248B 'expand':69B,101B,195B,227B 'expect':99B 'expected':225B 'find':15B,141B 'focus':120B,246B 'for':242B 'germani':117B 'germany':243B 'here':138B 'in':134A,148B,172B,250B 'individu':80B 'individual':206B 'inform':106B 'information':232B 'infrastructur':71B,123B 'infrastructure':197B,249B 'is':162B,213B,224B,236B 'it':198B,235B 'list':41B 'lists':167B 'mean':93B 'meaning':219B 'measur':19B,43B,97B 'measures':145B,169B,223B 'modern':67B 'modernize':193B 'more':231B 'nation':114B 'national':240B 'of':154B,176B,184B,221B 'offens':33B,63B 'offensive':159B,189B 'on':143B,247B 'ongo':74B 'ongoing':200B 'out':181B 'over':228B 'part':27B,57B,153B,183B 'plan':76B 'planned':202B 'program':65B,191B 'progress':91B 'progressively':217B 'project':78B 'projects':204B 'publish':111B 'published':237B 'record':73B 'records':199B 'school':7A,21B,31B,45B,61B,70B,81B,157B,187B,196B 'schools':133A,147B,171B,207B 'scope':115B,241B 'search':1A,127A 'steglitz':10A,24B,52B,136A,150B,178B 'steglitz-zehlendorf':9A,23B,51B,135A,149B,177B 'success':37B 'successively':163B 'the':155B,160B,173B,185B,209B,211B,239B 'this':165B 'time':103B,229B 'to':192B,226B 'will':140B 'with':244B 'within':82B,112B,208B,238B 'work':5A,131A 'you':139B 'zehlendorf':11A,25B,53B,137A,151B,179B","popularity_score":"0.0000","maintenance_score":"0.7000","institution_id":"9b80e8c7-91fe-4282-868f-ecbb510cb44f","institution_type":"MUNICIPALITY","country_code":"DE","official_confidence":null,"proof_summary":null,"source_seed_url":null,"is_public_sector":true,"published_at":"2026-06-27T12:15:24.985Z","geographic_scope":"NATIONAL","name_en":null,"description_en":"This dataset lists construction measures at schools in the Berlin district of Steglitz-Zehlendorf, carried out as part of the Berlin School Construction Offensive, a program to modernize and expand school infrastructure. It records ongoing and planned building projects at individual schools within the district. The dataset is described as being progressively completed, meaning coverage of construction measures is expected to expand over time as more information becomes available. It is published within the national scope for Germany, with a focus on education infrastructure in Berlin.","native_lang":"en","access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":34.94230769230769,"access":{"level":"direct","primary":{"kind":"download","label":"Download CSV","method":"GET","url":"https://www.berlin.de/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/alle-baumassnahmen/index.php/index/all.csv?q=","format":"CSV","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download CSV","method":"GET","url":"https://www.berlin.de/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/alle-baumassnahmen/index.php/index/all.csv?q=","format":"CSV","source":"distribution","runnable":true}],"formats":["CSV"]},"maturity":{"entry_id":"70178c2d-3404-41ad-8f3f-55403025b0fa","granularity":"entry","granularity_label":"One unit = one catalog entry. A PROXY for the SCOPE.md §4 ladder, which governs source families, not entries: a family with 400 entries moves this reading 400 times as much as a family with one. Never compare or combine with the source_family reading.","level":"executable","level_index":4,"level_label":"Executable","meaning":"Queries run through Commodity","counts_as_coverage":true,"blocked_by":null,"rungs":[{"level":"discovered","level_index":1,"label":"Discovered","meaning":"Source and metadata recorded","evidence":"membership of the named population the ladder is taken over","counts_as_coverage":false,"met":true,"reached":true,"criterion":"TRUE"},{"level":"verified","level_index":2,"label":"Verified","meaning":"Access tested successfully","evidence":"entries.verification_state = 'VERIFIED'","counts_as_coverage":false,"met":true,"reached":true,"criterion":"entries.verification_state = 'VERIFIED'"},{"level":"profiled","level_index":3,"label":"Profiled","meaning":"Schema, dimensions and licence understood","evidence":"a data profile with at least one field (entry_data_profiles.field_count > 0)","counts_as_coverage":false,"met":true,"reached":true,"criterion":"EXISTS (SELECT 1 FROM entry_data_profiles p WHERE p.entry_id = entries.id AND COALESCE(p.field_count, 0) > 0)"},{"level":"executable","level_index":4,"label":"Executable","meaning":"Queries run through Commodity","evidence":"entries.capability_tier = 'live' — today's proxy for \"queryable through us\"","counts_as_coverage":true,"met":true,"reached":true,"criterion":"entries.capability_tier = 'live'"},{"level":"joinable","level_index":5,"label":"Joinable","meaning":"Canonical identifiers and concepts mapped","evidence":"a field link to a canonical identifier whose sampled VALUES match its format","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_field_links efl WHERE efl.entry_id = entries.id AND efl.identifier_id IS NOT NULL AND efl.value_status = 'match')"},{"level":"reproducible","level_index":6,"label":"Reproducible","meaning":"Snapshots and transformation evidence retained","evidence":"at least one retained evidence manifest (migration 078)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM evidence_manifests em WHERE em.entry_id = entries.id)"},{"level":"guaranteed","level_index":7,"label":"Guaranteed","meaning":"Monitored against an operational reliability target","evidence":"an active reliability target with a named monitor (migration 096)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_reliability_targets rt WHERE rt.entry_id = entries.id AND rt.is_active = true)"}],"officialness":{"basis":"catalog_inherited","label":"Inherited from the upstream catalog: this item came from a trusted official government catalog, and that provenance — not per-item proof — is the warrant. Its own proof score is below 80 or it matched no registered institution (apps/worker/src/connectors/catalog/qualify-store.ts).","proof_confidence":null,"proven_threshold":80,"institution_id":"9b80e8c7-91fe-4282-868f-ecbb510cb44f","definition":"CASE WHEN COALESCE(entries.is_public_sector, false) IS NOT TRUE THEN 'not_official' WHEN COALESCE(entries.official_confidence, 0) >= 80 AND entries.institution_id IS NOT NULL THEN 'per_item_proven' ELSE 'catalog_inherited' END"},"source_family":{"key":"www.berlin.de","label":"One unit = one source family, approximated by the serving host of the entry's primary source URL (e.g. bdl.stat.gov.pl). A COMPUTED stand-in for the curated families of SCOPE.md §5, which no table holds yet. A family sits at the highest level any of its entries has reached, because a family is integrated to the depth of its deepest working integration. Never compare or combine with the entry reading."},"generated_at":"2026-08-16T13:52:33.721Z"},"api_details":null,"dataset_details":{"id":"27e47e16-2a2f-4330-8030-581fd92fd438","entry_id":"70178c2d-3404-41ad-8f3f-55403025b0fa","upstream_issued":null,"upstream_modified":null,"themes":[],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":null,"license_id":null,"license_raw":null,"has_documentation":false,"has_data_dictionary":false,"has_versioning":false,"source_portal":null,"source_portal_url":null,"created_at":"2026-07-16T15:51:53.789Z","updated_at":"2026-07-16T15:51:53.789Z","publisher":null,"publisher_url":null,"distributions":[{"id":"848a4c82-2e9c-4a58-a0fb-eacc504752cc","dataset_details_id":"27e47e16-2a2f-4330-8030-581fd92fd438","title":"all.csv","description":null,"access_url":"https://www.berlin.de/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/alle-baumassnahmen/index.php/index/all.csv?q=","download_url":"https://www.berlin.de/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/alle-baumassnahmen/index.php/index/all.csv?q=","media_type":"text/csv","format":"csv","byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":"2026-08-16T08:24:21.680Z","is_available":true,"last_http_status":200,"created_at":"2026-07-16T15:51:54.273Z","updated_at":"2026-08-16T08:24:21.680Z"}],"license":null},"license":null,"reuse":{"license_id":null,"license_name":null,"license_url":null,"commercial_use":{"status":"unknown","value":null},"redistribution":{"status":"unknown","value":null},"attribution_required":{"status":"unknown","value":null},"share_alike":{"status":"unknown","value":null},"personal_data_warning":{"status":"unknown","value":null},"cache_and_mirror":{"status":"unknown","value":null},"undetermined":["commercial_use","redistribution","attribution_required","share_alike","personal_data_warning","cache_and_mirror"],"basis":"unverified","confidence":0.1,"confidence_tier":"low","source_text":null,"source_url":null,"reviewed_at":null},"license_raw":null,"latest_check":{"id":"c23c3f36-98e5-4b0c-b792-fc392914aaa3","entry_id":"70178c2d-3404-41ad-8f3f-55403025b0fa","status":"VERIFIED","last_checked_at":"2026-08-16T08:24:22.808Z","p50_latency_ms":1434,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-06-27T11:15:12.864Z","updated_at":"2026-08-16T08:24:22.808Z","consecutive_successes":50,"probe_url":"https://www.berlin.de/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/alle-baumassnahmen/index.php/index/all.csv?q=","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/csv","probe_succeeded_at":"2026-08-16T08:24:22.808Z"},"data_profile":{"id":"d8eef0a2-ee1c-4670-ad09-0f807ad87f24","entry_id":"70178c2d-3404-41ad-8f3f-55403025b0fa","profile_source":"distribution","profile_kind":"dataset","dataset_id":null,"fields":[{"name":"id","type":"int","label":null,"description":null,"description_en":"Unique identifier for the construction project record."},{"name":"foto","type":"text","label":null,"description":null,"description_en":"Path or URL to a photo of the school building."},{"name":"schulname","type":"text","label":null,"description":null,"description_en":"Name of the school where construction takes place."},{"name":"schulart","type":"text","label":null,"description":null,"description_en":"Type of school, such as primary school or Gymnasium."},{"name":"ortsteil","type":"text","label":null,"description":null,"description_en":"Berlin locality or district where the school is located."},{"name":"gebaut_wird","type":"text","label":null,"description":null,"description_en":"Description of the construction work being carried out."},{"name":"stand","type":"text","label":null,"description":null,"description_en":"Current status of the construction project."},{"name":"kosten","type":"number","label":null,"description":null,"description_en":"Cost of the construction measure, in millions of euros."},{"name":"zeitraum","type":"text","label":null,"description":null,"description_en":"Time period during which the construction takes place."},{"name":"fertigstellung","type":"text","label":null,"description":null,"description_en":"Year or period when the construction is completed."},{"name":"weitere_informationen","type":"text","label":null,"description":null,"description_en":"Link to further information about the construction project."}],"field_count":11,"sample_records":[{"id":"16","foto":"/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/weiterfuehrende-schulen/arndt-gymnasium-dahlem_1600x1200px.jpg","stand":"fertig","kosten":"0,83","ortsteil":"Dahlem","schulart":"Gymnasium","zeitraum":"2017-2020","schulname":"Arndt-Gymnasium Dahlem","gebaut_wird":"Brandschutzmaßnahmen","fertigstellung":"2024","weitere_informationen":"/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/weiterfuehrende-schulen/arndt-gymnasium-dahlem-1445826.php"},{"id":"238","foto":"/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/muehlenau-hauptfassade-ii.jpg","stand":"fertig","kosten":"0,7","ortsteil":"Dahlem","schulart":"Grundschule","zeitraum":"2022-2024","schulname":"Mühlenau-Grundschule","gebaut_wird":"Fenstersanierung und Sporthallenboden","fertigstellung":"2023/2024","weitere_informationen":"/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/grundschulen/muehlenau-grundschule-1217835.php"},{"id":"37","foto":"/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/schule-mit-foerderschwerpunkt/biesalski-schule-eingang.jpg","stand":"fertig","kosten":"7","ortsteil":"Dahlem","schulart":"Schule mit Förderschwerpunkt","zeitraum":"2021-2023","schulname":"Biesalski-Schule","gebaut_wird":"Modularer Erweiterungsbau-GE-MEB inkl. Außenanlage","fertigstellung":"2023","weitere_informationen":"/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/schule-mit-foerderschwerpunkt/biesalski-schule-1218184.php"},{"id":"52","foto":"/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/20210805_130647.jpg","stand":"fertig","kosten":"","ortsteil":"Wannsee","schulart":"Grundschule","zeitraum":"","schulname":"Conrad-Grundschule","gebaut_wird":"Dachsanierung","fertigstellung":"2023","weitere_informationen":"/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/grundschulen/conrad-grundschule-1217888.php"},{"id":"112","foto":"/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/giesensdorfer-aussenansicht-mit-schriftzug.jpg","stand":"fertig","kosten":"4,4","ortsteil":"Lichterfelde","schulart":"Grundschule","zeitraum":"2020-2023","schulname":"Giesensdorfer-Grundschule","gebaut_wird":"Errichtung des Erweiterungsbaus II","fertigstellung":"2023","weitere_informationen":"/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/grundschulen/giesensdorfer-grundschule-1217896.php"}],"record_count":null,"data_size_bytes":"33343","dataset_count":null,"query_examples":[{"url":"https://www.berlin.de/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/alle-baumassnahmen/index.php/index/all.csv?q=","curl":"curl -sL 'https://www.berlin.de/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/alle-baumassnahmen/index.php/index/all.csv?q=' -o data.csv","label":"Download distribution","method":"GET","description":"Full csv file download — the schema shown was inferred from the file's first records."},{"url":"https://www.berlin.de/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/alle-baumassnahmen/index.php/index/all.csv?q=","curl":"curl -sL 'https://www.berlin.de/ba-steglitz-zehlendorf/aktuelles/schulbauoffensive/alle-baumassnahmen/index.php/index/all.csv?q=' -H 'Range: bytes=0-4095'","label":"Preview first bytes","method":"GET","description":"First 4 KB of the file (servers honoring Range requests)."}],"status":"ok","error_message":null,"profiled_at":"2026-07-25T17:02:24.005Z","run_id":"47b54098-0203-401f-b4ee-e352f193ec8c","created_at":"2026-07-16T15:51:53.632Z","updated_at":"2026-08-05T06:12:04.816Z","license_raw":null,"license_id":null,"consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true},"datasets":[],"limits":[]}