{"id":"2b5d187e-a65a-461a-8e89-0114f54b1818","type":"API","name":"Pictavie- statistiques mensuelles 2014 - 2024","slug":"pictavie-statistiques-mensuelles-2014-2024","description":"**Le service Pictavie :** PICTAVIE est un service ouvert depuis 2004. Il a pour objectif de recevoir et d’enregistrer les dysfonctionnements repérés sur l’espace public par les usagers. Il est joignable : - Par un n° vert : 0 800 88 11 39 (gratuit depuis un poste fixe) - Par courrie…","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://www.data.gouv.fr/dataservices/pictavie-statistiques-mensuelles-2014-2024","docs_url":"https://data.grandpoitiers.fr/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/api-doc","repo_url":null,"status":"ACTIVE","verification_state":"VERIFIED","tags":["government","digital"],"logo_url":"https://udata-avatars.s3.rbx.io.cloud.ovh.net/b4/b22b0058774433baf6b98ea40e6efe-100.jpg","primary_source_url":"https://www.data.gouv.fr/dataservices/pictavie-statistiques-mensuelles-2014-2024","extraction_confidence":"0.40","created_at":"2026-06-07T22:08:56.678Z","updated_at":"2026-08-14T07:53:13.920Z","last_verified_at":"2026-08-14T06:38:09.457Z","deprecated_at":null,"ranking_score":63,"last_ranked_at":"2026-08-03T15:30:35.813Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-04T05:11:27.858Z","search_vector":"'-2024':10A,63B,151A,204B '0':47B,188B '11':50B,191B '2004':20B,71B,161B,212B '2014':4A,9A,62B,145A,150A,203B '2024':5A,146A '39':51B,192B '800':48B,189B '88':49B,190B 'a':163B,207B,241B 'across':136B,277B 'activ':118B 'activity':259B 'and':218B,257B,271B 'as':230B 'be':238B 'by':213B,224B,248B 'can':237B 'channel':129B,270B 'courri':58B 'courrie':199B 'cover':138B 'covered':279B 'd':28B,169B 'damag':90B 'damaged':231B 'dataset':110B,251B 'de':25B,166B 'depui':19B,53B 'depuis':160B,194B 'digit':141C 'dysfonctionn':31B 'dysfonctionnements':172B 'email':108B,249B 'enregistr':29B 'enregistrer':170B 'espac':35B 'espace':176B 'est':15B,41B,156B,182B 'et':27B,168B 'evolv':135B 'evolved':276B 'fix':56B 'fixe':197B 'for':205B 'free':103B,244B 'furnitur':94B 'furniture':235B 'govern':140C 'grand':73B,214B 'gratuit':52B,193B 'has':275B 'how':265B,272B 'il':21B,40B,162B,181B 'infrastructur':91B 'infrastructure':232B 'insight':122B,263B 'into':264B 'issu':81B,132B 'issue':273B 'issues':222B 'joignabl':42B 'joignable':183B 'l':34B,175B 'le':11B,152B 'les':30B,38B,171B,179B 'line':105B,246B 'malfunct':79B 'malfunctions':220B 'mensuell':3A 'mensuelles':144A 'month':7A,59B 'monthly':148A,200B 'n':45B,186B 'objectif':24B,165B 'of':255B 'on':226B 'oper':69B 'operated':210B 'or':221B,233B,247B 'ouvert':18B,159B 'over':260B 'par':37B,43B,57B,178B,184B,198B 'period':139B,280B 'phone':104B,245B 'pictavi':1A,6A,13B,14B,65B 'pictavie':142A,147A,154B,155B,206B 'poitier':74B 'poitiers':215B 'post':55B 'poste':196B 'pour':23B,164B 'provid':121B 'providing':262B 'public':36B,67B,86B,177B,208B,227B 'receiv':76B 'receive':217B 'recevoir':26B,167B 'record':78B,219B 'reperes':173B 'report':95B,115B,128B,133B 'reporting':269B,274B 'reports':236B,256B 'repéré':32B 'resid':84B,125B 'residents':225B,266B 'servic':12B,17B,68B,117B 'service':153B,158B,209B,258B 'sinc':70B 'since':211B 'space':87B 'spaces':228B 'spot':82B 'spotted':223B 'statist':8A,61B 'statistics':149A,202B 'statistiqu':2A 'statistiques':143A 'street':93B,234B 'submit':98B 'submitted':239B 'such':229B 'sur':33B,174B 'the':253B,268B,278B 'this':250B 'time':120B,261B 'to':216B 'toll':102B,243B 'toll-fre':101B 'toll-free':242B 'track':111B 'tracks':252B 'un':16B,44B,54B,157B,185B,195B 'usag':39B,60B 'usage':201B 'usagers':180B 'use':126B,267B 'vert':46B,187B 'via':99B,240B 'volum':113B 'volume':254B","popularity_score":"0.0000","maintenance_score":"0.7000","institution_id":"e0e5f471-8522-4a98-a5b1-69bf08c7b7b9","institution_type":"MUNICIPALITY","country_code":"FR","official_confidence":40,"proof_summary":"official domain (data.gouv.fr) (catalog: api_gouv_fr)","source_seed_url":null,"is_public_sector":true,"published_at":"2026-06-07T22:08:56.678Z","geographic_scope":"NATIONAL","name_en":"Pictavie - monthly statistics 2014-2024","description_en":"Monthly usage statistics (2014-2024) for Pictavie, a public service operated since 2004 by Grand Poitiers to receive and record malfunctions or issues spotted by residents on public spaces, such as damaged infrastructure or street furniture. Reports can be submitted via a toll-free phone line or by email. This dataset tracks the volume of reports and service activity over time, providing insight into how residents use the reporting channel and how issue reporting has evolved across the covered period.","native_lang":"fr","access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":65.75,"access":{"level":"direct","primary":{"kind":"download","label":"Export CSV","method":"GET","url":"https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/lines?format=csv&size=10000","format":"CSV","source":"query_example","runnable":true,"direct":true},"actions":[{"kind":"download","label":"Export CSV","method":"GET","url":"https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/lines?format=csv&size=10000","format":"CSV","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"List records","method":"GET","url":"https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/lines?size=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Run verified request","method":"GET","url":"https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/","source":"probe","runnable":true},{"kind":"query","label":"Schema","method":"GET","url":"https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/schema","source":"query_example","runnable":true,"direct":false},{"kind":"spec","label":"OpenAPI spec","method":"GET","url":"https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/api-docs.json","source":"openapi","runnable":false},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://data.grandpoitiers.fr/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/api-doc","source":"docs","runnable":false},{"kind":"landing","label":"Visit homepage","method":"GET","url":"https://www.data.gouv.fr/dataservices/pictavie-statistiques-mensuelles-2014-2024","source":"homepage","runnable":false}],"formats":["CSV"]},"maturity":{"entry_id":"2b5d187e-a65a-461a-8e89-0114f54b1818","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":40,"proven_threshold":80,"institution_id":"e0e5f471-8522-4a98-a5b1-69bf08c7b7b9","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.data.gouv.fr","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:58:33.835Z"},"api_details":{"id":"98b0f849-d7b0-4cf0-9e64-6ae86cd3d1ec","entry_id":"2b5d187e-a65a-461a-8e89-0114f54b1818","base_url":"https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/","openapi_url":"https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/api-docs.json","graphql_url":null,"api_version":null,"spec_format":"openapi","endpoints_count":null,"endpoints":[],"rate_limit_info":null,"free_tier_limits":null,"ping_url":"https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/","created_at":"2026-06-07T22:08:56.697Z","updated_at":"2026-06-07T22:08:56.697Z"},"dataset_details":{"id":"b7360d8f-35a0-49da-8b96-97dba46ae55b","entry_id":"2b5d187e-a65a-461a-8e89-0114f54b1818","upstream_issued":null,"upstream_modified":"2025-02-07T09:59:09.469Z","themes":[],"update_frequency":"annual","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":"datafair","source_portal_url":"https://data.grandpoitiers.fr","created_at":"2026-06-26T13:11:29.063Z","updated_at":"2026-07-26T16:19:51.273Z","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/2014/05/Licence_Ouverte.pdf","latest_check":{"id":"f3755809-a41e-4d87-bf00-5ad72881c8ba","entry_id":"2b5d187e-a65a-461a-8e89-0114f54b1818","status":"VERIFIED","last_checked_at":"2026-08-14T06:38:09.226Z","p50_latency_ms":1429,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-06-08T12:43:08.764Z","updated_at":"2026-08-14T06:38:09.226Z","consecutive_successes":14,"probe_url":"https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/json; charset=utf-8","probe_succeeded_at":"2026-08-14T06:38:09.226Z"},"data_profile":{"id":"cd9d05aa-3ef9-4f7f-85ba-b93913276748","entry_id":"2b5d187e-a65a-461a-8e89-0114f54b1818","profile_source":"datafair","profile_kind":"dataset","dataset_id":null,"fields":[{"name":"annee","type":"integer","label":"Année","concept":"annee-poitiers","filterable":true,"description":null,"description_en":"Year of the reported monthly statistics."},{"name":"1","type":"integer","label":"Janvier","filterable":true,"description":null,"description_en":"Number of Pictavie reports recorded in January."},{"name":"2","type":"integer","label":"Février","filterable":true,"description":null,"description_en":"Number of Pictavie reports recorded in February."},{"name":"3","type":"integer","label":"Mars","filterable":true,"description":null,"description_en":"Number of Pictavie reports recorded in March."},{"name":"4","type":"integer","label":"Avril","filterable":true,"description":null,"description_en":"Number of Pictavie reports recorded in April."},{"name":"5","type":"integer","label":"Mai","filterable":true,"description":null,"description_en":"Number of Pictavie reports recorded in May."},{"name":"6","type":"integer","label":"Juin","filterable":true,"description":null,"description_en":"Number of Pictavie reports recorded in June."},{"name":"7","type":"integer","label":"Juillet","filterable":true,"description":null,"description_en":"Number of Pictavie reports recorded in July."},{"name":"8","type":"integer","label":"Août","filterable":true,"description":null,"description_en":"Number of Pictavie reports recorded in August."},{"name":"9","type":"integer","label":"Septembre","filterable":true,"description":null,"description_en":"Number of Pictavie reports recorded in September."},{"name":"10","type":"integer","label":"Octobre","filterable":true,"description":null,"description_en":"Number of Pictavie reports recorded in October."},{"name":"11","type":"integer","label":"Novembre","filterable":true,"description":null,"description_en":"Number of Pictavie reports recorded in November."},{"name":"12","type":"integer","label":"Décembre","filterable":true,"description":null,"description_en":"Number of Pictavie reports recorded in December."}],"field_count":13,"sample_records":[{"1":412,"2":351,"3":296,"4":455,"5":336,"6":345,"7":223,"8":80,"9":373,"10":400,"11":518,"12":415,"annee":2024,"_score":null},{"1":399,"2":312,"3":416,"4":482,"5":458,"6":482,"7":435,"8":346,"9":475,"10":462,"11":515,"12":356,"annee":2023,"_score":null},{"1":350,"2":302,"3":344,"4":348,"5":422,"6":492,"7":358,"8":494,"9":368,"10":436,"11":367,"12":322,"annee":2022,"_score":null},{"1":317,"2":320,"3":400,"4":355,"5":322,"6":398,"7":397,"8":283,"9":524,"10":518,"11":368,"12":308,"annee":2021,"_score":null},{"1":395,"2":375,"3":311,"4":156,"5":309,"6":320,"7":381,"8":421,"9":461,"10":444,"11":330,"12":317,"annee":2020,"_score":null}],"record_count":"11","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/lines?size=20","curl":"curl -s 'https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/lines?size=20' -H 'Accept: application/json'","label":"List records","method":"GET","description":"First 20 records of the dataset as JSON."},{"url":"https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/schema","curl":"curl -s 'https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/schema' -H 'Accept: application/json'","label":"Schema","method":"GET","description":"Field definitions (columns, types) of the dataset."},{"url":"https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/lines?format=csv&size=10000","curl":"curl -sL 'https://data.grandpoitiers.fr/data-fair/api/v1/datasets/espace-public-signalement-des-anomalies-sur-lespace-public-statistiques-mensuelles-2014-2024/lines?format=csv&size=10000' -o dataset.csv","label":"Export CSV","method":"GET","description":"Records as CSV (raises size for larger exports)."}],"status":"ok","error_message":null,"profiled_at":"2026-07-26T16:19:50.472Z","run_id":"1d2f3234-d2f0-40c4-89e5-5c2b01fc7b35","created_at":"2026-06-12T19:33:12.253Z","updated_at":"2026-07-26T16:19:50.472Z","license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2014/05/Licence_Ouverte.pdf","license_id":"lo-2.0","consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true},"datasets":[],"limits":[]}