The world of data

I’ve been investigating options for accessing the data on our portal using AI assistants, mainly Claude code. I previously posted my experience of a REST to MCP adapter, which works, but is a bit clunky and not very token efficient. I have recently experimented with a new library called mcp2cli which enables the coding agent to use CLI commands to query data on our portal.MCP2CLI can create a skill which introspects the swagger.json  - which is published under the portal’s API tab, to understand the explore API of the portal. This enables the coding agent to discover datasets, understand their structure and create SQL queries to return filtered and aggregated data. The skill is an alternative approach to MCP servers that is more token efficient due to progressive disclosure and the use of a command line interface to query the data. I iterated over creation of the ski

Hey community! 🚀Ready for a new challenge? 🏆This round is all about Forms.We’d love to hear how you’re using the Forms feature - the context, how you set it up, what data you collected, and, most importantly, what it changed for you.Did it help you…✨ save time or streamline a workflow?✨ build a new asset or surface insights?✨ collaborate better across teams or with users?✨ or something else entirely?Share your use case in the thread, check out others’ ideas, and don’t forget to react to your favorites! 👍💬The submission with the most likes will earn the new Monthly Challenge badge 🎖️Let the inspiration and the competition begin! 🔥Monthly ch

Hi allI’ve been using Claude Code quite a lot for developing software and doing analysis. It’s an agentic AI coding assistant in the CLI if you haven’t come across it. Anthropic (the parent company) developed a protocol called MCP to help the AI use external resources like APIs.Someone has developed a tool to take openapi or swagger API specifications and turn it into MCP tools. What this means is that you can ask Claude Code, in natural language, questions about your data, and it will translate this, quite well into code to send a request to the API and return data. HuWise have done something similar on the portal in their “Explore data with AI” feature, but this is a bit more powerful for deeper analysis - but re

Hello, I can see that the region ID - Name used for Japan in OpenDataSoft follows the FIPS standard. I also see in different sources that FIPS is no more used since 2008. Do we know why OpenDataSoft is still using this norm ? is there a way they could update to use one of the used norms in the whole world now ( JIS X 0401 or ISO )

Are there plans to add more mapping capability for Studio Maps - for example clusters, dots and shapes and heat maps - same functionality that is shown in Map Builder? 

Hello dear community,I’m having an issue with sorting in the filter. I created a dropdown filter with the names of care homes. The problem is that the alphabetical order doesn’t prioritize uppercase and lowercase letters correctly. I have care homes named "dandelion" and "irides" which are lowercase and appear at the very end of the filter. Is there a way to work around this?                <div class="shared-width-ods-selects">                    <div ods-facet-results="reglist"                         ods-facet-results-facet-name="name"                         ods-facet-results-context="myctx0"                         ods-facet-results-sort="alphanum">                        <ods-select ng-init="myctx0.parameters['refine.name'] = []"                                    options="reglist"                                    selected-values="myctx0.parameters['refine.name']"

Is it possible to remove the label indicating the cluster count ? - or at least the option to style it  - so the label has the same colour as the icon behind it?

Dear Support Team,I am currently trying to display data in a chart, and I have encountered an issue. The chart is displaying the years along the X-axis, but some years are not being shown, likely due to space constraints.Is there a way to force the diagram to display the missing years, such as 2017, 2019, and so on?Thank you for your assistance. I look forward to your guidance on how to resolve this issue.Best regards,Boris

Hello Community,It seems many of you are looking to create content that helps your users get more value from the portal.We’d love to know how you currently support your users, and how we can make it easier for you.Quick poll, takes 2 min tops. Mind giving it a go?👉 Go to the poll.Thanks a ton! 

I’ve been trying to use the Geofilter.polygon to refine the results in a dataset per this documentation:https://userguide.opendatasoft.com/en/articles/2257346#:~:text=geofilter.polygon,%2C2.386968)However it always looks like it does a text search in the records.  Is there a setting I need to activate at the dataset level to accept geofilter options? 

I’ve found this article very interesting :  https://open.substack.com/pub/benn/p/disband-the-analytics-team

Hello,  I’m student, and I need to use OpenDataSoft for French municipalities per year, I want to know if it’s possible to get an API key to get this kind of data without limitations please. This is the data that I need between 2015 and 2024. https://public.opendatasoft.com/explore/embed/dataset/georef-france-commune-millesime/table/?disjunctive.reg_name&disjunctive.dep_name&disjunctive.arrdep_name&disjunctive.ze2020_name&disjunctive.epci_name&disjunctive.ept_name&disjunctive.com_name&disjunctive

Hello Community!Great news—posts are now available in 9 different languages! 🎉If a post is in a language you’re not comfortable with, just click “Translate” below the post and select your preferred language. AI will handle the rest. 📌 Bonus: You can also translate all replies to a post at once, just like this: Try it out and let us know what you think! 🚀

Hi we are trying to truncate the first 5 characters of a field and for some reason the Replace via Regular Expression processor doesn’t seem to ‘work”We have tried:^(.{1,5})(?:|$)Regex101.com seems to match it correctly and which replaces the first 5 characters with blank so then we tried this^.{5}(.*)which seems to replace all of it with a blank…  Help please.  If anyone can create a small library of useful regex strings for use that would be really appreciated!  

Hello Community, the New Year is approaching and I thought we could share a few things - personal achievements, movies, songs, books, and other stuff (in data or not) — that have inspired us over the last 12 months.One of my achievements: Community launch, love it!🤩 Another one: 16 min in a wall sit challenge with my colleagues - it makes me question my career choices 🤔😅 My fav podcast of the year (in French): Raphaël Gaillard - Notre cerveau ne se supporte plus: on pharmacology, psychology, psychedelics, and brain chips…What are yours??Auto-translation 🪄Bonjour la communauté, la nouvelle année approche et j'ai pensé que nous pourrions partager quelques éléments - réalisations personnelles, films, chansons, livres et autres choses (en données ou non) - qui nous ont inspirés au cours des 1

Bonjour, j’aimerais savoir comment pourras-je faire pour creer un clé API sur l’api BODACCAuto-translation 🪄Hello, I would like to know how I can create an API key on the BODACC API.

I am experiencing an issue with resetting the selection in an ods-select element that is used in my visualization. <div class="grid"> <div class="shared-width-ods-selects"> <div ods-facet-results="reglist" ods-facet-results-facet-name="name" ods-facet-results-context="myctx0" ods-facet-results-sort="alphanum"> <ods-select ng-init="myctx0.parameters['refine.name'] = []" options="reglist" selected-values="myctx0.parameters['refine.name']" multiple="false" label-modifier="name" value-modifier="name" placeholder="Pf

Bonjour, J’essaie actuellement de faire un diagramme en colonnes (barres verticales). Ce que je parviens à faire.Sauf qu’après avoir ventilé ma série, j’ai essayé de trier par les valeurs décroissantes de l’axe y.Mallheureusement, je n’y arrive pas et j’ai un tri par défaut (suivant l’axe des abssices).Dans l’éditeur de code, mon code ressemble à ça:<ods-chart single-y-axis="true"   align-month="true"> <ods-chart-query context="ctx"                       field-x="x"                             maxpoints="50"                             series-breakdown="break"                            stacked="normal"                             sort=y”>                            <ods-chart-serie expression-y="y"                                              chart-type="column"                                              function-y="S

Hi,I'm using the following API from Opendatasoft to access postal code data:API Endpoint: https://data.opendatasoft.com/api/explore/v2.1/catalog/datasets/geonames-postal-code@public/recordsThis api is not available right now , When i trigger this api showing message like “The requested dataset geonames-postal-code does not exist.”. Please provide a reason for this Auto-translation 🪄Bonjour, j'utilise l'API suivante d'Opendatasoft pour accéder aux données de code postal :Point de terminaison de l'API : https://data.opendatasoft.com/api/explore/v2.1/catalog/datasets/geonames-postal-code@public/recordsCette API n'est pas disponible pour le moment. Lorsque je déclenche cette API, un message du type « Le jeu de donn

Hi everyone ! I would like to use a processor to convert Unix Timestamps into DateTime in the format %d/%m/%Y %H:%M:%S (‘1729698397000’ => ‘23/10/2024 15:46:37’). Do you have any idea what expression to use?My source is the JC Decaux API https://developer.jcdecaux.com/#/opendata/vls?page=getstarted.PS: for some reason, I don't want to use the dataset that already exists on the Data Hub.Thanks in advance for your help!!! 😃Auto-translation 🪄Bonjour à tous ! Je souhaiterais utiliser un processeur pour convertir les Timestamps Unix en DateTime au format %d/%m/%Y %H:%M:%S (‘1729698397000’ => ‘23/10/2024 15:46:37’). Avez-vous une idée de l’expression à utiliser ? Ma source est l’API JC Decaux https://developer.jcdecaux.com/#/opendata/vls?page=getstarted.PS : pour une raison quelconq

Hello everyone, I'm sharing with you our new dashboard on baby names in our region.I hope this will inspire your creations. If you have any technical questions, I'll be happy to answer them and share the code. 😉Auto-translation 🪄Bonjour à tous, je partage avec vous notre nouveau tableau de bord sur les prénoms de bébé dans notre région. J'espère que cela inspirera vos créations. Si vous avez des questions techniques, je serai ravie d'y répondre et de partager le code. 😉

Hello to all dear members of the ODS community, We would like to share with you our latest dashboard, which presents several key figures from our canton (and by district and municipality) in various fields. All feedback is welcome, and we hope it will be a good source of inspiration.🤗✨Link✨  SStat FribourgAuto-translation 🪄Bonjour à tous chers membres de la communauté ODS, Nous souhaitons partager avec vous notre dernier tableau de bord, qui présente plusieurs chiffres clés de notre canton (et par district et commune) dans divers domaines. Tous les retours sont les bienvenus et nous espérons qu'ils seront une bonne source d'inspiration.🤗✨Lien✨  SStat Fribourg

Dear Support Team,I am reaching out with a technical question regarding my project.I am encountering an issue with initializing (lastdate) . Specifically, I need this variable to be correctly set in order to use it in a dropdown menu. This logic was working fine previously, but today I noticed that it no longer functions as expected. Here is a simplified snippet of my code:           <div class="sticky-content"               ng-init="variables = {}">                    <div ods-adv-analysis="dateanalysis"                           ods-adv-analysis-context="myctx"                           ods-adv-analysis-select="max(jahr) as maxdate">                                                  </div>               <div class="advanced-kpi--top">                  <h2>                   <strong>Filtern nach Spital und Jahr:</strong></h2> 

Frankston City Council has to demonstrate its performance to stakeholders, increase trust with residents and ensure that it is delivering on their changing needs. To do this the council has made it a key objective to increase engagement, trust and sustainable development and management of its assets and infrastructure.Discover how the city of Frankston is delivering information proactively from across the organization and sharing it in understandable ways to demonstrate good governance and ethical behavior while increasing transparency around decision making.Find out more →