{"id":"f1a943b2-b6d6-4360-9ec5-82e25d056395","type":"DATASET","name":"School building card","slug":"school-building-card","description":"The map gives an overview of construction projects at public general education schools in Berlin, through which new school places have been and will be created. The new sites will be created through new construction, refurbishment, reactivation or expansion measures. The data cover the period from the school year 2014/2015 to the school year 2025/2026. The basic data are based, among other things, on the current reports on measures and financial controlling for the school building programme, on the state of play of the Berlin School Building Plan and on the current investment programme of the State of Berlin 2023-2027.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"https://www.berlin.de/sen/bildung/schule/bauen-und-sanieren/schulbaukarte/index.php/index/all.xls?q=","status":"ACTIVE","verification_state":"VERIFIED","tags":["education","construction"],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=berlin.de","primary_source_url":"https://www.berlin.de/sen/bildung/schule/bauen-und-sanieren/schulbaukarte/index.php/index/all.xls?q=","extraction_confidence":"0.16","created_at":"2026-06-28T11:16:01.507Z","updated_at":"2026-08-16T12:59:43.172Z","last_verified_at":"2026-08-16T12:59:43.172Z","deprecated_at":null,"ranking_score":56,"last_ranked_at":"2026-08-10T16:48:33.987Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-04T07:18:20.328Z","search_vector":"'-2027':104B,183B,316B,395B '2014/2015':53B,142B,265B,354B '2023':103B,182B,315B,394B '2025/2026':58B,145B,270B,357B 'among':64B,276B 'an':219B,409B 'and':238B,285B,304B,344B,369B,385B,407B,413B 'are':274B 'at':224B,322B 'author':189B 'authorities':401B 'base':63B 'based':275B 'basic':60B,272B 'be':240B,246B 'been':237B 'berlin':18B,88B,102B,116B,169B,177B,188B,230B,300B,314B,328B,381B,389B,400B 'build':2A,79B,90B,136B,163B,171B 'building':214A,291B,302B,375B,383B 'buildings':348B 'by':399B 'capac':203B 'capacity':415B 'card':3A,215A 'citi':207B 'city':419B 'construct':10B,38B,108B,129B,212C 'construction':222B,250B,320B,341B 'control':75B,159B 'controlling':287B,371B 'cover':46B,137B,258B 'covering':349B 'creat':29B,35B,119B,122B 'create':334B 'created':241B,247B,331B 'current':69B,95B,153B,281B,307B,365B 'data':45B,61B,150B,257B,273B,362B 'dataset':106B,318B 'draw':151B,363B 'educ':15B,113B,211C 'education':227B,325B 'expans':42B,133B,204B 'expansion':254B,345B,416B 'financi':74B,158B 'financial':286B,370B 'for':288B,372B,393B,403B 'from':261B,352B 'general':14B,112B,226B,324B 'give':6B 'gives':218B 'have':236B,330B 'in':229B,327B,417B 'includ':127B 'include':339B 'infrastructur':193B 'infrastructure':405B 'invest':96B,179B 'investment':308B,391B 'is':397B 'it':396B 'maintain':186B 'maintained':398B 'map':5B,107B,217B 'maps':319B 'measur':43B,72B,126B,156B 'measures':255B,284B,338B,368B 'new':21B,31B,37B,123B,128B,233B,243B,249B,335B,340B 'of':221B,296B,298B,310B,313B,346B,379B,388B,411B 'on':279B,283B,293B,305B,364B,367B 'ongo':200B 'ongoing':412B 'or':253B,332B 'other':277B 'overview':8B,198B,220B,410B 'period':48B,139B,260B,351B 'place':23B,125B 'places':235B,337B 'plan':91B,172B,194B,202B,303B,384B 'planned':414B 'planning':406B 'play':85B,297B 'programm':80B,97B,164B,180B 'programme':292B,309B,376B,392B 'project':11B,109B 'projects':223B,321B 'provid':196B 'provides':408B 'public':13B,111B,225B,323B 'reactiv':40B,131B 'reactivation':252B,343B 'refurbish':39B,130B 'refurbishment':251B,342B 'report':70B,154B 'reports':282B,366B 'respons':190B 'responsible':402B 's':390B,420B 'school':1A,16B,22B,51B,56B,78B,89B,114B,124B,135B,146B,162B,170B,192B,209B,213A,234B,263B,268B,290B,301B,336B,347B,358B,374B,382B,404B,421B 'schools':228B,326B 'site':32B 'sites':244B 'state':83B,100B,175B,295B,312B,387B 'status':166B,378B 'system':210B,422B 'that':329B 'the':216B,242B,256B,259B,262B,267B,271B,280B,289B,294B,299B,306B,311B,350B,353B,356B,360B,373B,377B,380B,386B,418B 'thing':66B 'things':278B 'this':317B 'through':231B,248B 'to':266B,355B 'under':149B 'underlying':361B 'which':232B 'will':239B,245B,333B 'year':52B,57B,147B,264B,269B,359B","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-29T16:22:00.000Z","geographic_scope":"NATIONAL","name_en":null,"description_en":"This dataset maps construction projects at public general education schools in Berlin that have created or will create new school places. Measures include new construction, refurbishment, reactivation, and expansion of school buildings, covering the period from the 2014/2015 to the 2025/2026 school year. The underlying data draw on current reports on measures and financial controlling for the school building programme, the status of the Berlin School Building Plan, and the State of Berlin's investment programme for 2023-2027. It is maintained by Berlin authorities responsible for school infrastructure planning and provides an overview of ongoing and planned capacity expansion in the city's school system.","native_lang":"de","access_level":"direct","formats":["XLSX"],"capability_tier":"sample","trust_score":34.94230769230769,"access":{"level":"direct","primary":{"kind":"download","label":"Download XLSX","method":"GET","url":"https://www.berlin.de/sen/bildung/schule/bauen-und-sanieren/schulbaukarte/index.php/index/all.xls?q=","format":"XLSX","byte_size":"52870","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download XLSX","method":"GET","url":"https://www.berlin.de/sen/bildung/schule/bauen-und-sanieren/schulbaukarte/index.php/index/all.xls?q=","format":"XLSX","byte_size":"52870","source":"distribution","runnable":true}],"formats":["XLSX"]},"maturity":{"entry_id":"f1a943b2-b6d6-4360-9ec5-82e25d056395","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":"profiled","level_index":3,"level_label":"Profiled","meaning":"Schema, dimensions and licence understood","counts_as_coverage":false,"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":false,"reached":false,"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:59:41.488Z"},"api_details":null,"dataset_details":{"id":"18a25a75-8d7b-4b71-9583-60ec78012ef5","entry_id":"f1a943b2-b6d6-4360-9ec5-82e25d056395","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-20T11:01:38.214Z","updated_at":"2026-07-20T11:01:38.214Z","publisher":null,"publisher_url":null,"distributions":[{"id":"a54e3a76-cc45-46f6-955e-68f16726b2b4","dataset_details_id":"18a25a75-8d7b-4b71-9583-60ec78012ef5","title":"all.xls","description":null,"access_url":"https://www.berlin.de/sen/bildung/schule/bauen-und-sanieren/schulbaukarte/index.php/index/all.xls?q=","download_url":"https://www.berlin.de/sen/bildung/schule/bauen-und-sanieren/schulbaukarte/index.php/index/all.xls?q=","media_type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","format":"xlsx","byte_size":"52870","license_id":null,"license_raw":null,"last_checked_at":"2026-08-16T12:59:41.581Z","is_available":true,"last_http_status":200,"created_at":"2026-07-20T11:01:38.657Z","updated_at":"2026-08-16T12:59:41.581Z"}],"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":"27c8b7b6-9dc2-4d1a-b05f-619ffa8d80d3","entry_id":"f1a943b2-b6d6-4360-9ec5-82e25d056395","status":"VERIFIED","last_checked_at":"2026-08-16T12:59:42.887Z","p50_latency_ms":2331,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-06-28T11:17:37.807Z","updated_at":"2026-08-16T12:59:42.887Z","consecutive_successes":13,"probe_url":"https://www.berlin.de/sen/bildung/schule/bauen-und-sanieren/schulbaukarte/index.php/index/all.xls?q=","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","probe_succeeded_at":"2026-08-16T12:59:42.887Z"},"data_profile":{"id":"e10b04cd-cc52-46c5-8e28-5890637ce054","entry_id":"f1a943b2-b6d6-4360-9ec5-82e25d056395","profile_source":"excel","profile_kind":"dataset","dataset_id":null,"fields":[{"name":"Schulnummer","type":"text","label":null,"filterable":false,"description":null},{"name":"Schulname","type":"text","label":null,"filterable":false,"description":null},{"name":"Bezirk","type":"text","label":null,"filterable":false,"description":null},{"name":"Schulart","type":"text","label":null,"filterable":false,"description":null},{"name":"Baumaßnahme","type":"text","label":null,"filterable":false,"description":null},{"name":"Beschreibung","type":"text","label":null,"filterable":false,"description":null},{"name":"Gebaute Schulplätze","type":"int","label":null,"filterable":false,"description":null},{"name":"Schulplätze nach Baumaßnahme","type":"text","label":null,"filterable":false,"description":null},{"name":"Zügigkeit nach Baumaßnahme","type":"text","label":null,"filterable":false,"description":null},{"name":"Nutzungsübergabe","type":"text","label":null,"filterable":false,"description":null},{"name":"Gesamtkosten","type":"text","label":null,"filterable":false,"description":null},{"name":"Straße","type":"text","label":null,"filterable":false,"description":null},{"name":"Postleitzahl","type":"int","label":null,"filterable":false,"description":null},{"name":"Ort","type":"text","label":null,"filterable":false,"description":null}],"field_count":14,"sample_records":[{"Ort":"Berlin","Bezirk":"Mitte","Straße":"Bergstr. 58","Schulart":"Grundschule","Schulname":"Papageno-Grundschule","Schulnummer":"01G02","Baumaßnahme":"Sanierung; Erweiterung","Beschreibung":"Gesamtsanierung, Anbau zur Schulplatzerweiterung, Erweiterung durch einen Modularen Ergänzungsbau","Gesamtkosten":"rund 16,2 Mio.","Postleitzahl":"10115","Nutzungsübergabe":"2027/2028","Gebaute Schulplätze":"288","Zügigkeit nach Baumaßnahme":"4-zügig","Schulplätze nach Baumaßnahme":"576"},{"Ort":"Berlin","Bezirk":"Mitte","Straße":"Rathenower Str. 18","Schulart":"Grundschule","Schulname":"Kurt-Tucholsky-Grundschule","Schulnummer":"01G11","Baumaßnahme":"Sanierung","Beschreibung":"Sanierung Sanitär- und Umkleide-bereiche Sporthalle; Schulhofge-staltung  einschließlich Wegeverbindung Fritz-Schloß-Park","Gesamtkosten":"rund 3 Mio.","Postleitzahl":"10559","Nutzungsübergabe":"2019/2020","Gebaute Schulplätze":"0","Zügigkeit nach Baumaßnahme":"k.A.","Schulplätze nach Baumaßnahme":"k.A."},{"Ort":"Berlin","Bezirk":"Mitte","Straße":"Lessingstr. 5","Schulart":"Grundschule","Schulname":"Hansa-Grundschule","Schulnummer":"01G19","Baumaßnahme":"Sanierung","Beschreibung":"Strangsanierung, Sanierung Sanitär","Gesamtkosten":"rund 1,1 Mio","Postleitzahl":"10555","Nutzungsübergabe":"2020/2021","Gebaute Schulplätze":"0","Zügigkeit nach Baumaßnahme":"k.A.","Schulplätze nach Baumaßnahme":"k.A."},{"Ort":"Berlin","Bezirk":"Mitte","Straße":"Prinzenallee 8","Schulart":"Grundschule","Schulname":"Gesundbrunnen-Grundschule","Schulnummer":"01G27","Baumaßnahme":"Sanierung","Beschreibung":"Sanierung Räume, Keller, Sanitär","Gesamtkosten":"rund 3,5 Mio.","Postleitzahl":"13357","Nutzungsübergabe":"2019/2020","Gebaute Schulplätze":"0","Zügigkeit nach Baumaßnahme":"k.A.","Schulplätze nach Baumaßnahme":"k.A."},{"Ort":"Berlin","Bezirk":"Mitte","Straße":"Gotenburger Str. 8","Schulart":"Grundschule","Schulname":"Wilhelm-Hauff-Grundschule","Schulnummer":"01G29","Baumaßnahme":"Sanierung","Beschreibung":"Sanierung Schulgebäude","Gesamtkosten":"rund 4,6 Mio.","Postleitzahl":"13359","Nutzungsübergabe":"2019/2020","Gebaute Schulplätze":"0","Zügigkeit nach Baumaßnahme":"k.A.","Schulplätze nach Baumaßnahme":"k.A."}],"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":null,"status":"partial","error_message":null,"profiled_at":"2026-07-27T11:13:49.446Z","run_id":"8fa954bb-7df5-4e37-a2b8-2c1851341161","created_at":"2026-07-20T11:01:38.076Z","updated_at":"2026-07-27T11:13:49.446Z","license_raw":null,"license_id":null,"consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true},"datasets":[],"limits":[]}