{"id":"99115ce6-5e78-47df-aacd-2f4335137349","type":"DATASET","name":"Street tree plantings in Steglitz-Zehlendorf","slug":"street-tree-plantings-in-steglitz-zehlendorf","description":"This list contains the plantings that have already taken place. The plantings that have already been commissioned will only be transferred to the tree cadastre after they have been carried out. The contained trees were planted at different times with the help of donations to the district, through the fundraising campaign of the city tree campaign, by our trainees and by companies on behalf of the district. The new plantings receive a three-year growth care. A commissioned casting care in the 4th and 5th The year of manufacture follows. In dry periods, you as a local resident can help to overcome the ‘thirst route’ with additional water supplies and thus support us very much.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"https://www.berlin.de/ba-steglitz-zehlendorf/politik-und-verwaltung/aemter/strassen-und-gruenflaechenamt/gruenflaechen/baeume/baumpflanzungen/index.php/index/all.xls?q=","status":"ACTIVE","verification_state":"VERIFIED","tags":[],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=berlin.de","primary_source_url":"https://www.berlin.de/ba-steglitz-zehlendorf/politik-und-verwaltung/aemter/strassen-und-gruenflaechenamt/gruenflaechen/baeume/baumpflanzungen/index.php/index/all.xls?q=","extraction_confidence":"0.16","created_at":"2026-07-04T11:41:23.669Z","updated_at":"2026-08-18T09:58:53.671Z","last_verified_at":"2026-08-18T09:58:53.671Z","deprecated_at":null,"ranking_score":56,"last_ranked_at":"2026-08-09T07:39:38.830Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-04T07:18:13.431Z","search_vector":"'4th':91B,319B '5th':93B,321B 'a':307B,313B,332B,422B 'act':177B 'acting':405B 'ad':150B 'added':378B 'addit':115B,214B 'additional':343B,442B 'after':261B 'afterward':205B,433B 'alreadi':15B,22B,142B 'already':243B,250B,370B 'and':295B,320B,346B,403B,430B 'are':377B,438B 'as':331B 'at':272B 'be':255B 'been':251B,264B 'behalf':71B,179B,299B,407B 'berlin':133B,361B 'by':292B,296B,400B 'cadastr':32B 'cadastre':260B 'campaign':58B,63B,170B,286B,291B,398B 'can':335B 'care':84B,88B,189B,312B,316B,417B 'carri':37B 'carried':265B 'cast':87B 'casting':315B 'citi':61B 'city':289B 'citywid':166B 'citywide':394B 'commiss':24B,86B,147B,195B 'commissioned':252B,314B,375B,423B 'compani':69B 'companies':297B 'complet':156B 'completed':384B 'contain':10B,40B 'contained':268B 'contains':238B 'continu':198B 'continuing':426B 'contractor':176B 'contractors':404B 'cover':140B 'covers':368B 'dataset':125B,353B 'differ':45B 'different':273B 'district':54B,74B,134B,173B,182B,225B,282B,302B,362B,401B,410B,453B 'donat':51B,164B 'donations':279B,392B 'dri':100B,207B 'dry':328B,435B 'during':434B 'each':411B 'effort':228B 'efforts':456B 'encourag':211B 'encouraged':439B 'exclud':144B 'excluding':372B 'fifth':203B,431B 'follow':98B 'follows':326B 'for':418B 'fourth':201B,429B 'from':387B 'fundrais':57B 'fundraising':285B 'growth':83B,311B 'have':242B,249B,263B 'help':49B,108B,217B,277B,336B,445B 'in':232A,317B,327B,359B,427B 'includ':162B 'including':390B 'it':367B 'list':9B,126B,237B 'lists':354B 'local':105B,333B 'mainten':227B 'maintenance':455B 'manufactur':97B 'manufacture':325B 'much':123B,351B 'new':76B,184B,304B,412B 'newli':127B 'newly':355B 'of':278B,287B,300B,324B,363B,408B 'on':298B,406B 'once':383B 'one':145B 'ones':373B 'only':254B,374B 'organ':187B 'organized':415B 'origin':158B 'originate':386B 'our':293B 'out':266B 'overcom':110B 'overcome':338B 'period':101B,208B 'periods':329B,436B 'place':17B,245B 'plant':3A,12B,19B,43B,77B,128B,143B,169B,185B 'planted':271B,356B,371B 'planting':397B,413B 'plantings':231A,240B,247B,305B 'provid':213B 'provide':441B 'receiv':78B,186B 'receive':306B 'receives':414B 'regist':154B 'register':382B 'resid':106B,163B,209B 'resident':334B,391B 'residents':437B 'rout':113B 'route':341B 's':454B 'servic':197B 'service':425B 'shortag':222B 'shortages':450B 'sourc':161B 'sources':389B 'steglitz':6A,137B,234A,365B 'steglitz-zehlendorf':5A,136B,233A,364B 'street':1A,129B,229A,357B 'supplement':223B 'supplementing':451B 'suppli':117B 'supplies':345B 'support':120B,348B 'surviv':220B 'survive':448B 'taken':16B,244B 'that':241B,248B 'the':239B,246B,258B,267B,276B,281B,284B,288B,301B,303B,318B,322B,339B,360B,380B,393B,409B,428B,452B 'they':262B 'thirst':112B,340B 'this':236B,352B 'three':81B,191B,309B,419B 'three-year':80B,308B 'through':283B 'thus':119B,347B 'time':46B 'times':274B 'to':257B,280B,337B,379B,440B,444B 'traine':66B,174B 'trainees':294B,402B 'transfer':28B 'transferred':256B 'tree':2A,31B,41B,62B,130B,141B,153B,157B,168B,219B,230A,259B,290B,381B,396B 'tree-plant':167B 'tree-planting':395B 'trees':269B,358B,369B,385B,447B 'us':121B,349B 'various':160B,388B 'very':350B 'water':116B,188B,196B,215B,221B,344B,449B 'watering':416B,424B,443B 'were':270B 'which':376B 'will':253B 'with':275B,342B,421B 'work':171B,399B 'year':82B,95B,192B,204B,310B,323B 'years':420B,432B 'you':330B 'young':218B,446B 'zehlendorf':7A,138B,235A,366B","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-07-05T08:06:00.000Z","geographic_scope":"NATIONAL","name_en":null,"description_en":"This dataset lists newly planted street trees in the Berlin district of Steglitz-Zehlendorf. It covers trees already planted, excluding ones only commissioned, which are added to the tree register once completed. Trees originate from various sources, including resident donations, the citywide tree-planting campaign, work by district trainees, and contractors acting on behalf of the district. Each new planting receives organized watering care for three years, with a commissioned watering service continuing in the fourth and fifth years afterward. During dry periods, residents are encouraged to provide additional watering to help young trees survive water shortages, supplementing the district's maintenance efforts.","native_lang":"de","access_level":"direct","formats":["XLSX"],"capability_tier":"sample","trust_score":33.40384615384615,"access":{"level":"direct","primary":{"kind":"download","label":"Download XLSX","method":"GET","url":"https://www.berlin.de/ba-steglitz-zehlendorf/politik-und-verwaltung/aemter/strassen-und-gruenflaechenamt/gruenflaechen/baeume/baumpflanzungen/index.php/index/all.xls?q=","format":"XLSX","byte_size":"45282","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download XLSX","method":"GET","url":"https://www.berlin.de/ba-steglitz-zehlendorf/politik-und-verwaltung/aemter/strassen-und-gruenflaechenamt/gruenflaechen/baeume/baumpflanzungen/index.php/index/all.xls?q=","format":"XLSX","byte_size":"45282","source":"distribution","runnable":true}],"formats":["XLSX"]},"maturity":{"entry_id":"99115ce6-5e78-47df-aacd-2f4335137349","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-18T16:23:34.240Z"},"api_details":null,"dataset_details":{"id":"de710787-bc68-4d0f-bbcf-ae6dba985004","entry_id":"99115ce6-5e78-47df-aacd-2f4335137349","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:00:27.161Z","updated_at":"2026-07-20T11:00:27.161Z","publisher":null,"publisher_url":null,"distributions":[{"id":"c29640cd-c38e-46b2-a902-f7e6ffa93211","dataset_details_id":"de710787-bc68-4d0f-bbcf-ae6dba985004","title":"all.xls","description":null,"access_url":"https://www.berlin.de/ba-steglitz-zehlendorf/politik-und-verwaltung/aemter/strassen-und-gruenflaechenamt/gruenflaechen/baeume/baumpflanzungen/index.php/index/all.xls?q=","download_url":"https://www.berlin.de/ba-steglitz-zehlendorf/politik-und-verwaltung/aemter/strassen-und-gruenflaechenamt/gruenflaechen/baeume/baumpflanzungen/index.php/index/all.xls?q=","media_type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","format":"xlsx","byte_size":"45282","license_id":null,"license_raw":null,"last_checked_at":"2026-08-18T09:58:52.875Z","is_available":true,"last_http_status":200,"created_at":"2026-07-20T11:00:27.561Z","updated_at":"2026-08-18T09:58:52.875Z"}],"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":"e4ee5629-5607-4279-8e02-b39b45b17e14","entry_id":"99115ce6-5e78-47df-aacd-2f4335137349","status":"VERIFIED","last_checked_at":"2026-08-18T09:58:53.510Z","p50_latency_ms":5273,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-04T11:43:46.155Z","updated_at":"2026-08-18T09:58:53.510Z","consecutive_successes":27,"probe_url":"https://www.berlin.de/ba-steglitz-zehlendorf/politik-und-verwaltung/aemter/strassen-und-gruenflaechenamt/gruenflaechen/baeume/baumpflanzungen/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-18T09:58:53.510Z"},"data_profile":{"id":"caaf2c8a-4533-4484-9f9b-edcbde598349","entry_id":"99115ce6-5e78-47df-aacd-2f4335137349","profile_source":"excel","profile_kind":"dataset","dataset_id":null,"fields":[{"name":"PLZ","type":"number","label":null,"filterable":false,"description":null},{"name":"Ortsteil","type":"text","label":null,"filterable":false,"description":null},{"name":"Strasse","type":"text","label":null,"filterable":false,"description":null},{"name":"Hausnr","type":"text","label":null,"filterable":false,"description":null},{"name":"Baumnr","type":"text","label":null,"filterable":false,"description":null},{"name":"Baumart","type":"text","label":null,"filterable":false,"description":null},{"name":"Pflanzjahr","type":"int","label":null,"filterable":false,"description":null}],"field_count":7,"sample_records":[{"PLZ":"14195.0","Baumnr":"R0059","Hausnr":"3","Baumart":"Prunus serrulata 'Kanzan'","Strasse":"Bachstelzenweg","Ortsteil":"Dahlem","Pflanzjahr":"2021"},{"PLZ":"14195.0","Baumnr":"R0033","Hausnr":"1/1A","Baumart":"Prunus sargentii","Strasse":"Bachstelzenweg","Ortsteil":"Dahlem","Pflanzjahr":"2021"},{"PLZ":"14195.0","Baumnr":"R0051","Hausnr":"1A","Baumart":"Tilia cordata 'Rancho'","Strasse":"Bachstelzenweg","Ortsteil":"Dahlem","Pflanzjahr":"2021"},{"PLZ":"14195.0","Baumnr":"R0141","Hausnr":"9a","Baumart":"Tilia cordata 'Rancho'","Strasse":"Bachstelzenweg","Ortsteil":"Dahlem","Pflanzjahr":"2021"},{"PLZ":"14195.0","Baumnr":"L0034","Hausnr":"ggü 1A","Baumart":"Prunus sargentii","Strasse":"Bachstelzenweg","Ortsteil":"Dahlem","Pflanzjahr":"2021"}],"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":null,"status":"partial","error_message":null,"profiled_at":"2026-07-27T11:01:40.085Z","run_id":"c75f0bd3-e46c-46b6-9404-9e77c942d201","created_at":"2026-07-20T11:00:27.030Z","updated_at":"2026-07-27T11:01:40.085Z","license_raw":null,"license_id":null,"consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true},"datasets":[],"limits":[]}