{"id":"2c852396-3ded-4c56-9231-bc493f3f6d83","type":"DATASET","name":"Berlin memorial plaques in Steglitz-Zehlendorf","slug":"berlin-memorial-plaques-in-steglitz-zehlendorf","description":"Here you will find an overview of all memorial plaques, memorial bars and all historical places in Steglitz-Zehlendorf.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"https://www.berlin.de/ba-steglitz-zehlendorf/ueber-den-bezirk/sehens-und-wissenswertes/gedenktafeln/index.php/index/all.csv?q=","status":"ACTIVE","verification_state":"VERIFIED","tags":["culture","geospatial"],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=berlin.de","primary_source_url":"https://www.berlin.de/ba-steglitz-zehlendorf/ueber-den-bezirk/sehens-und-wissenswertes/gedenktafeln/index.php/index/all.csv?q=","extraction_confidence":"0.16","created_at":"2026-06-28T11:15:53.115Z","updated_at":"2026-08-16T09:18:20.566Z","last_verified_at":"2026-08-16T08:05:42.941Z","deprecated_at":null,"ranking_score":56,"last_ranked_at":"2026-08-10T16:48:32.413Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-16T09:18:20.566Z","search_vector":"'a':169B 'all':114B,120B 'an':111B,151B 'and':119B,134B,178B,186B,194B 'as':168B 'bar':19B,34B 'bars':118B,133B 'be':174B 'berlin':1A,48B,100A,147B 'can':173B 'commemor':38B,57B,96B 'commemorate':156B 'commemorative':137B,195B 'cultur':98C 'dataset':29B,72B,128B,171B 'district':46B,68B,92B,145B,167B,191B 'document':86B 'documentation':185B 'event':60B 'events':159B 'find':11B,110B 'geospati':71B,99C 'geospatial':170B 'germani':49B 'germany':148B 'here':107B 'heritag':85B 'heritage':184B 'histor':22B,37B,64B 'histori':94B 'historical':121B,136B,163B 'history':193B 'in':103A,123B,140B,189B 'interest':89B,188B 'it':149B,172B 'landmark':97B 'landmarks':196B 'list':30B 'lists':129B 'local':84B,183B 'locat':40B,78B 'locate':177B 'located':139B 'map':80B,179B 'marker':55B 'markers':154B 'memori':2A,16B,18B,31B,33B 'memorial':101A,115B,117B,130B,132B 'notabl':58B 'notable':157B 'of':113B,146B,153B,162B 'or':160B 'other':135B 'overview':13B,53B,112B,152B 'peopl':59B 'people':158B 'place':23B,62B 'places':122B,161B 'plaqu':3A,17B,32B 'plaques':102A,116B,131B 'provid':51B 'provides':150B 'public':88B,187B 's':192B 'signific':65B 'significance':164B 'site':39B,82B 'sites':138B,181B 'steglitz':6A,26B,44B,105A,125B,143B 'steglitz-zehlendorf':5A,25B,43B,104A,124B,142B 'support':83B 'supporting':182B 'that':155B 'the':141B,166B,190B 'these':180B 'this':127B 'to':176B 'use':76B 'used':175B 'will':109B 'within':66B,165B 'you':108B 'zehlendorf':7A,27B,45B,106A,126B,144B","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-29T13:15:57.375Z","geographic_scope":"NATIONAL","name_en":null,"description_en":"This dataset lists memorial plaques, memorial bars, and other historical commemorative sites located in the Steglitz-Zehlendorf district of Berlin, Germany. It provides an overview of markers that commemorate notable people, events, or places of historical significance within the district. As a geospatial dataset, it can be used to locate and map these sites, supporting local heritage documentation and public interest in the district's history and commemorative landmarks.","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/ueber-den-bezirk/sehens-und-wissenswertes/gedenktafeln/index.php/index/all.csv?q=","format":"CSV","byte_size":"11608","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download CSV","method":"GET","url":"https://www.berlin.de/ba-steglitz-zehlendorf/ueber-den-bezirk/sehens-und-wissenswertes/gedenktafeln/index.php/index/all.csv?q=","format":"CSV","byte_size":"11608","source":"distribution","runnable":true}],"formats":["CSV"]},"maturity":{"entry_id":"2c852396-3ded-4c56-9231-bc493f3f6d83","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:50:53.129Z"},"api_details":null,"dataset_details":{"id":"e32b65ba-70ea-4058-830b-fc174ce39524","entry_id":"2c852396-3ded-4c56-9231-bc493f3f6d83","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-17T03:05:48.023Z","updated_at":"2026-07-17T03:05:48.023Z","publisher":null,"publisher_url":null,"distributions":[{"id":"0c4c5d79-d26e-43f7-b71f-ad50a706633a","dataset_details_id":"e32b65ba-70ea-4058-830b-fc174ce39524","title":"all.csv","description":null,"access_url":"https://www.berlin.de/ba-steglitz-zehlendorf/ueber-den-bezirk/sehens-und-wissenswertes/gedenktafeln/index.php/index/all.csv?q=","download_url":"https://www.berlin.de/ba-steglitz-zehlendorf/ueber-den-bezirk/sehens-und-wissenswertes/gedenktafeln/index.php/index/all.csv?q=","media_type":"text/csv","format":"csv","byte_size":"11608","license_id":null,"license_raw":null,"last_checked_at":"2026-08-16T09:18:19.881Z","is_available":true,"last_http_status":200,"created_at":"2026-07-17T03:05:48.429Z","updated_at":"2026-08-16T09:18:19.881Z"}],"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":"ba7a45dc-6de0-49ff-9edf-728b852c90ae","entry_id":"2c852396-3ded-4c56-9231-bc493f3f6d83","status":"VERIFIED","last_checked_at":"2026-08-16T08:05:42.626Z","p50_latency_ms":1173,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-06-28T11:17:30.924Z","updated_at":"2026-08-16T08:05:42.626Z","consecutive_successes":26,"probe_url":"https://www.berlin.de/ba-steglitz-zehlendorf/ueber-den-bezirk/sehens-und-wissenswertes/gedenktafeln/index.php/index/all.csv?q=","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/csv","probe_succeeded_at":"2026-08-16T08:05:42.626Z"},"data_profile":{"id":"cb0777f3-5e07-4a86-80d8-71e6a4fdaad3","entry_id":"2c852396-3ded-4c56-9231-bc493f3f6d83","profile_source":"distribution","profile_kind":"dataset","dataset_id":null,"fields":[{"name":"id","type":"int","label":null,"description":null,"description_en":"Unique identifier for the memorial entry."},{"name":"name","type":"text","label":null,"description":null,"description_en":"Name of the person the memorial commemorates."},{"name":"funktion","type":"text","label":null,"description":null,"description_en":"Profession or role of the commemorated person."},{"name":"adresse","type":"text","label":null,"description":null,"description_en":"Street address of the memorial's location."},{"name":"stadtteil","type":"text","label":null,"description":null,"description_en":"District within Steglitz-Zehlendorf where the memorial is located."},{"name":"typ","type":"text","label":null,"description":null,"description_en":"Type of memorial, such as plaque or historical site."}],"field_count":6,"sample_records":[{"id":"16","typ":"Gedenktafel","name":"Friedrich Meinecke","adresse":"Am Hirschsprung 13, 14195 Berlin","funktion":"Historiker","stadtteil":"Dahlem"},{"id":"19","typ":"Historische Orte","name":"Carl Raddatz","adresse":"Am Schülerheim 6, 14195 Berlin","funktion":"Schauspieler","stadtteil":"Dahlem"},{"id":"34","typ":"Gedenktafel","name":"Johann Peter Süßmilch","adresse":"Berliner Straße 2, 14169 Berlin","funktion":"Universalwissenschaftler und Propst von Cölln","stadtteil":"Dahlem"},{"id":"49","typ":"Gedenktafel","name":"Otto Heinrich Warburg","adresse":"Boltzmannstraße 14, 14195 Berlin","funktion":"Biochemiker, Mediziner","stadtteil":"Dahlem"},{"id":"73","typ":"Gedenkstelen","name":"Das Oskar-Helene-Heim","adresse":"Clayallee 182, 14195 Berlin","funktion":"","stadtteil":"Dahlem"}],"record_count":null,"data_size_bytes":"11608","dataset_count":null,"query_examples":[{"url":"https://www.berlin.de/ba-steglitz-zehlendorf/ueber-den-bezirk/sehens-und-wissenswertes/gedenktafeln/index.php/index/all.csv?q=","curl":"curl -sL 'https://www.berlin.de/ba-steglitz-zehlendorf/ueber-den-bezirk/sehens-und-wissenswertes/gedenktafeln/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/ueber-den-bezirk/sehens-und-wissenswertes/gedenktafeln/index.php/index/all.csv?q=","curl":"curl -sL 'https://www.berlin.de/ba-steglitz-zehlendorf/ueber-den-bezirk/sehens-und-wissenswertes/gedenktafeln/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-25T15:54:24.090Z","run_id":"2600b480-47dc-4359-b1c0-de1364aa1282","created_at":"2026-07-17T03:05:47.888Z","updated_at":"2026-08-05T06:13:02.166Z","license_raw":null,"license_id":null,"consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true},"datasets":[],"limits":[]}