{"id":"a53a348e-49c8-4321-9e93-62677692a512","type":"API","name":"Bornes (poubelles) de la propreté urbaine","slug":"bornes-poubelles-de-la-proprete-urbaine","description":"Ce jeu de données contient les bornes (poubelles situées sur l'espace public) gérées par le service de la Propreté urbaine de l'Eurométropole.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://data.strasbourg.eu/explore/dataset/bornes_proprete_urbaine/","docs_url":"https://data.strasbourg.eu/explore/dataset/bornes_proprete_urbaine/","repo_url":null,"status":"ACTIVE","verification_state":"VERIFIED","tags":[],"logo_url":"https://data.strasbourg.eu/assets/favicon?tstamp=154210176917","primary_source_url":"https://data.strasbourg.eu/explore/dataset/bornes_proprete_urbaine/","extraction_confidence":"0.00","created_at":"2026-07-25T20:20:28.420Z","updated_at":"2026-09-07T01:11:13.321Z","last_verified_at":"2026-09-07T00:31:58.269Z","deprecated_at":null,"ranking_score":56,"last_ranked_at":"2026-08-31T16:43:16.777Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-28T03:26:55.367Z","search_vector":"'born':1A,13B 'bornes':31A,43B 'ce':7B,37B 'contient':11B,41B 'de':3A,9B,24B,28B,33A,39B,54B,58B 'donnees':40B 'donné':10B 'espac':18B 'espace':48B 'eurometropole':60B 'eurométropol':30B 'gerees':50B 'gérées':20B 'jeu':8B,38B 'l':17B,29B,47B,59B 'la':4A,25B,34A,55B 'le':22B,52B 'les':12B,42B 'par':21B,51B 'poubell':2A,14B 'poubelles':32A,44B 'proprete':35A,56B 'propreté':5A,26B 'public':19B,49B 'servic':23B 'service':53B 'situees':45B 'situé':15B 'sur':16B,46B 'urbain':6A,27B 'urbaine':36A,57B","popularity_score":"0.0000","maintenance_score":"0.7000","institution_id":null,"institution_type":null,"country_code":"FR","official_confidence":0,"proof_summary":"Confidence: 0%","source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-26T10:15:00.000Z","geographic_scope":"NATIONAL","name_en":null,"description_en":null,"native_lang":null,"access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":38.75,"merged_into_entry_id":null,"identity_key":"API|https://data.strasbourg.eu/explore/dataset/bornes_proprete_urbaine|bornes (poubelles) de la propreté urbaine","upstream_ref":"data.strasbourg.eu:dataset:bornes_proprete_urbaine","access":{"level":"direct","primary":{"kind":"download","label":"Export CSV","method":"GET","url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},"actions":[{"kind":"download","label":"Export CSV","method":"GET","url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"List records","method":"GET","url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine/records?limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Select & filter","method":"GET","url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine/records?select=id_borne%2Cgeo_shape%2Cetat&where=id_borne+is+not+null&limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Run verified request","method":"GET","url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine","source":"probe","runnable":true},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://data.strasbourg.eu/explore/dataset/bornes_proprete_urbaine/","source":"docs","runnable":false}],"formats":["CSV"]},"maturity":{"entry_id":"a53a348e-49c8-4321-9e93-62677692a512","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":0,"proven_threshold":80,"institution_id":null,"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":"data.strasbourg.eu","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-09-09T02:53:26.977Z"},"api_details":{"id":"c3c776f2-aaa6-45e1-9f9f-bafca016a25c","entry_id":"a53a348e-49c8-4321-9e93-62677692a512","base_url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine","openapi_url":null,"graphql_url":null,"api_version":null,"spec_format":null,"endpoints_count":null,"endpoints":[],"rate_limit_info":null,"free_tier_limits":null,"ping_url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine","created_at":"2026-07-25T20:20:28.580Z","updated_at":"2026-07-25T20:20:28.580Z"},"dataset_details":{"id":"9200305c-8034-41e3-8721-48cb628e0001","entry_id":"a53a348e-49c8-4321-9e93-62677692a512","upstream_issued":null,"upstream_modified":"2026-08-13T15:43:19.000Z","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":"opendatasoft","source_portal_url":"https://data.strasbourg.eu","created_at":"2026-07-25T20:23:56.664Z","updated_at":"2026-09-02T08:40:48.547Z","publisher":null,"publisher_url":null,"distributions":[],"license":null},"license":{"id":"lo-2.0","spdx_id":"etalab-2.0","name":"Licence Ouverte 2.0 (France / Etalab)","url":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"national","notes":null,"created_at":"2026-06-12T16:29:19.729Z"},"reuse":{"license_id":"lo-2.0","license_name":"Licence Ouverte 2.0 (France / Etalab)","license_url":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","commercial_use":{"status":"yes","value":true},"redistribution":{"status":"yes","value":true},"attribution_required":{"status":"yes","value":true},"share_alike":{"status":"no","value":false},"personal_data_warning":{"status":"yes","value":true},"cache_and_mirror":{"status":"yes","value":true},"undetermined":[],"basis":"licence_text","confidence":0.95,"confidence_tier":"high","source_text":"Texte de la licence - le reutilisateur est libre \"de la communiquer, la reproduire, la copier ; de l'adapter, la modifier, l'extraire et la transformer, notamment pour creer des Informations derivees ; de la diffuser, la redistribuer, la publier et la transmettre, de l'exploiter a titre commercial\". Seule obligation : \"mentionner la paternite de l'Information : sa source (a minima le nom du Concedant) et la date de la derniere mise a jour\". Le texte rappelle que le reutilisateur doit respecter \"le cadre legal relatif a la protection des donnees a caractere personnel\". Aucune clause de partage a l'identique n'est imposee.","source_url":"https://github.com/etalab/licence-ouverte/blob/master/LO.md","reviewed_at":null},"license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","latest_check":{"id":"ffef0650-8f80-42be-aff1-5142e6d68eff","entry_id":"a53a348e-49c8-4321-9e93-62677692a512","status":"VERIFIED","last_checked_at":"2026-09-07T00:31:58.050Z","p50_latency_ms":3285,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-27T06:13:18.288Z","updated_at":"2026-09-07T00:31:58.050Z","consecutive_successes":11,"probe_url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/json; charset=utf-8","probe_succeeded_at":"2026-09-07T00:31:58.050Z"},"data_profile":{"id":"b4dca03b-1bfa-4e6c-9b51-7bebec76cfca","entry_id":"a53a348e-49c8-4321-9e93-62677692a512","profile_source":"opendatasoft","profile_kind":"dataset","dataset_id":"bornes_proprete_urbaine","fields":[{"name":"id_borne","type":"text","label":"Identifiant de la borne","filterable":true,"description":"Identifiant de la borne"},{"name":"geo_shape","type":"geo_shape","label":null,"filterable":false,"description":null},{"name":"etat","type":"text","label":null,"filterable":true,"description":"Etat"},{"name":"geo_point_2d","type":"geo_point_2d","label":"Geo Point","filterable":false,"description":null},{"name":"type_borne","type":"text","label":"Type de borne","filterable":true,"description":"Type de borne"},{"name":"mal_voyant","type":"text","label":"Accessibilité mal voyant","filterable":true,"description":"Mal voyant ?"},{"name":"couleur","type":"text","label":null,"filterable":true,"description":"Couleur"},{"name":"emplacement","type":"text","label":null,"filterable":true,"description":"Emplacement"},{"name":"compteur_degrad","type":"text","label":"Compteur de dégradation","filterable":true,"description":"Compteur de dégradation"},{"name":"contenance","type":"text","label":null,"filterable":true,"description":"Contenance"}],"field_count":10,"sample_records":[{"etat":"implanté","couleur":"vert olive","id_borne":"222","geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[7.766363942,48.5512431789]},"properties":{}},"contenance":"80 L","mal_voyant":"non","type_borne":"borne en fonte","emplacement":"surface","geo_point_2d":{"lat":48.5512431789,"lon":7.766363942},"compteur_degrad":"4"},{"etat":"implanté","couleur":"à définir","id_borne":"233","geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[7.7668259702,48.5452458541]},"properties":{}},"contenance":"80 L","mal_voyant":"non","type_borne":"borne en fonte","emplacement":"surface","geo_point_2d":{"lat":48.5452458541,"lon":7.7668259702},"compteur_degrad":"4"},{"etat":"implanté","couleur":"gris terre d'ombre","id_borne":"2099","geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[7.7537634809,48.5492820182]},"properties":{}},"contenance":"120 L","mal_voyant":"oui","type_borne":"corbeille vigipirate","emplacement":"surface","geo_point_2d":{"lat":48.5492820182,"lon":7.7537634809},"compteur_degrad":"4"},{"etat":"implanté","couleur":"vert olive","id_borne":"2325","geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[7.7671178944,48.5552623164]},"properties":{}},"contenance":"80 L","mal_voyant":"non","type_borne":"borne en fonte","emplacement":"surface","geo_point_2d":{"lat":48.5552623164,"lon":7.7671178944},"compteur_degrad":"4"},{"etat":"implanté","couleur":"vert olive","id_borne":"2499","geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[7.7696845936,48.5644869487]},"properties":{}},"contenance":"80 L","mal_voyant":"non","type_borne":"borne en fonte","emplacement":"surface","geo_point_2d":{"lat":48.5644869487,"lon":7.7696845936},"compteur_degrad":"4"}],"record_count":"5058","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine/records?limit=20","curl":"curl -s 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine/records?limit=20' -H 'Accept: application/json'","label":"List records","method":"GET","description":"First 20 records of the dataset as JSON."},{"url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine/records?select=id_borne%2Cgeo_shape%2Cetat&where=id_borne+is+not+null&limit=20","curl":"curl -s 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine/records?select=id_borne%2Cgeo_shape%2Cetat&where=id_borne+is+not+null&limit=20' -H 'Accept: application/json'","label":"Select & filter","method":"GET","description":"Project specific fields (id_borne, geo_shape, etat) and filter with ODSQL where clauses."},{"url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine/exports/csv","curl":"curl -sL 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/bornes_proprete_urbaine/exports/csv' -o dataset.csv","label":"Export CSV","method":"GET","description":"Full dataset export as CSV (also available: json, parquet, xlsx)."}],"status":"ok","error_message":null,"profiled_at":"2026-09-02T08:40:47.519Z","run_id":"9089978f-5af8-43dd-ad11-7e8fb58b26e9","created_at":"2026-07-25T20:23:56.166Z","updated_at":"2026-09-02T08:40:47.519Z","license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","license_id":"lo-2.0","consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true,"personal_data":{"status":"none","basis":"no_person_column_cited","grain":"none","allowed":true,"columns":{"direct_identifiers":[],"family_names":[],"given_names":[],"attributes":[],"unresolved_names":[],"measures":[],"entity_identifiers":[]},"publication":null,"publication_evidence":null,"notice":"personal data: no cited column names a natural person (the cited columns are all this reads)"}},"datasets":[],"limits":[{"id":"ee308e53-4851-446e-bccc-dbee6f0faa1a","entry_id":"a53a348e-49c8-4321-9e93-62677692a512","limit_type":"requests_per_day","value":"2000000","unit":"requests","period":"day","scope":"per-ip","source_id":null,"claim_type":"measured","confidence":"0.90","observed_at":"2026-09-02T08:40:48.724Z"}],"source_access":{"status":"accessed_despite_disallow","host":"data.strasbourg.eu","requested_path_prefix":"/api/explore/v2.1/","robots_url":"https://data.strasbourg.eu/robots.txt","user_agent_group":"*","robots_rule":"Disallow: /api/","robots_read_at":"2026-08-25T11:29:16.804Z","decision_ref":"owner decision 2026-08-22, recorded in docs/PROGRESS.md NEEDS-HUMAN: public-sector open-data portals whose purpose is machine access; the directive is an Opendatasoft vendor default reflecting no publisher intent. Concern raised and overruled; see the row.","note":"This answer is derived from a host whose robots.txt DISALLOWS the path Commodity requests, and Commodity requests it anyway under the decision named in `decision_ref`. The rule is quoted verbatim so you can read it yourself. Commodity does not send a user-agent it is not, so any `Allow` granted to a named crawler in that file is not claimed here."},"field_provenance_source_access":{"status":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"THIS PLATFORM’S READING OF ITS OWN CONDUCT: that it requests a path this host forbids. No publisher asserts it and none was asked to","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"host":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"the host Commodity addressed, lowercased and stripped of scheme and port by this platform so that one host has one row and one reading","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"requested_path_prefix":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"THE PATH THE VERDICT IS ABOUT, derived from the base URLs this platform stores for the host — not `/`, and not an assumed `/api/`. A verdict about a path we do not call would describe someone else’s traffic","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"robots_url":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"where the file was fetched from — composed by this platform from the host, at the one location the protocol fixes, so it can be re-fetched and the reading disputed","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"user_agent_group":{"basis":"stored_sample","derived":false,"upstream_field":"the `User-agent` line the deciding rule sits under","transform":"the group heading that made the rule OURS, verbatim from the stored file. Where it is `*` the directive addresses everyone; a group naming another crawler was not applied, because Commodity does not send a user-agent it is not","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"robots_rule":{"basis":"stored_sample","derived":false,"upstream_field":"the directive line of the matching group","transform":"THE PUBLISHER’S OWN LINE, QUOTED AND UNCUT, as read from robots.txt at the moment below and stored — not fetched for this request, and not part of this response’s payload. It is here so the verdict beside it can be checked rather than taken from us","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"robots_read_at":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"OUR CLOCK when the file was read, never a `Date` header the origin sent. It bounds how stale this reading may be: a publisher can have changed the file since","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"decision_ref":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"WHO DECIDED TO CALL IT ANYWAY, AND WHEN. Recorded by this platform and required by the database before the exception may exist at all, so it can never be anonymous","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"note":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"this platform’s sentence explaining what the reader is holding. Written here, by us, and not a quotation of anybody","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}}},"manifest":{"answer_sha256":"0eac9413d33d2591dbdb9e31e49a355140db8495641255a751288d926678fa91","answer_sha256_rule":"sha256 (hex, UTF-8) of JSON.stringify(this body) after deleting the keys listed in manifest.stamped_keys from manifest, and deleting manifest itself if it is then empty. The hash was computed before the stamp existed, so no field of the stamp is inside it.","stamped_keys":["answer_sha256","answer_sha256_rule","stamped_keys","row_count","row_count_basis","live","live_basis","created_at","created_at_basis","durable_citation"],"row_count":31,"row_count_basis":"Objects that are elements of a JSON array anywhere in this body, excluding manifest. Not a claim about which collection is the answer. Largest single collection: data_profile.fields[] (10 rows).","live":false,"live_basis":"This body was replayed from the worker edge cache (x-edge-cache: hit); the bytes, and therefore answer_sha256, are those of the execution that filled the cache.","created_at":"2026-09-09T02:54:13.783Z","created_at_basis":"When this response body was assembled, deliberately OUTSIDE the hashed bytes so the same answer hashes identically on every request. Not the upstream read time — that is provenance[].retrieved_at. A zone-cached replay carries the assembly time, not your receipt time.","durable_citation":"This manifest is produced at response time and is NOT stored. A durable, replayable citation is persisted only on an explicit cite: GET /api/v1/entries/{id-or-slug}/evidence, or the MCP cite_query tool. Both are entry-scoped, because evidence_manifests is entry-shaped; a domain answer spanning several sources has no single entry and cannot be persisted through that path."}}