Huwise discussions

Hi all,If a dataset contains both a geopoint and a geoshape, is there anyway to select which will be displayed when you add it onto a map for example ? By default it seems to show the shapes Thanks RyanAuto-translation 🪄Bonjour à tous,Si un ensemble de données contient à la fois un géopoint et une géoforme, est-il possible de sélectionner celui qui sera affiché lorsque vous l'ajouterez sur une carte par exemple ? Par défaut, il semble afficher les formes Merci Ryan

Hello,I have a dataset with a “date” variable and I would like to dynamically assign the start date of my graph as the last date in my dataset -20 years. I can use an ods-adv-analysis to obtain the latest date in my dataset, but I can't subtract 20 years from it. Furthermore, I can hardcode the start date, but not using a dynamic variable:<div ods-adv-analysis="maxdate" ods-adv-analysis-context="pibcroissancetrimestre" ods-adv-analysis-select="max(date) as maxdate" > {{last_date = maxdate[0].maxdate; ""}} {{last_date}} {{ pibcroissancetrimestre.parameters['q.from_date.date'] = 'date>=2005-09-30T00:00:00+00:00 '; ""}}Can someone help me fix this code?Thanks in advanceNathan

HelloWhen I add a territory for a dataset, and retrieve the dataset through the API, then I get a random code (e.g. ch_80_2477 ). It is quite cumbersome to map these by hand, but I’ve done it for ~10 cities and regions. Now, we have a new dataset with a lot more territories, and it would be cumbersome (and unnecessary, honestly), to map these by hand. Where can I find a list with all of these codes, so that I can import them and use them in my code? Do these follow a public standard?Thank you!

Hi All,We currently have a document library on our website, however we have had feedback from customers that its not easy to navigate.As a result we are exploring the possibility of using our Open Data Portal as a home of a new “Technical Library” containing 200+ pdfs etc of supporting documents. Now it seems that after about 80 additional attachments I cant add anymore. As a DNO, we are very cautious around data security so essentially I need a solution where the documents can be stored on the Portal itself in an ideal world, because using options like github, sharepoint etc arent really viable as getting permission would likely be a dead end.Anyone got any ideas or examples of similar resources? Potential to spilt the attachments over multiple datasets but that becomes a bit of a nightmare to maintain/policeThanksRyan

In the past we were able to draw a polygon in a geographical map (e.g. Germany Postal Codes). This was used to extract a specific list of postal codes and areas based on the polygon. Right now it does not seem to be possible to draw those polygons on the map anymore. Is there a way around it or a possibility in the future again? 

Hello,I am a student and currently working on a data project that involves the use of public datasets hosted on this platform, specifically: OSM France – Parking Area OSM France – Public Service I would like to access these datasets programmatically via your API, but I am unable to locate or generate an API key from my account.Could you please grant me API access or guide me on how to obtain the necessary API key for these datasets?If it requires approval from a workspace administrator, please let me know the appropriate steps or contact.Thank you very much for your time and assistance.Kind regards,Chleo Hinn

Hi !We have recently created a page for our DNOA data report, it all works well and happy with it, apart from one map which doesnt seem to be loading correctly Distribution Network Options Assessment — Open Data | Northern Powergrid The map in question is in the “Network Dashboard” tab, and has a lot of grey space. It works fine if i full screen then minimize again. Any thoughts as to why it appears to stop loading? Thanks Ryan

Does anyone have any tips on how to shape data in our portals to work better with the AI tools? The concern from our leadership is someone will ask a question and if the data contains too many filterable items it could return an incorrect result.Is there any guidelines on how to better shape the data to make it easier for AI to understand and provide results?

Is there any way to retrieve this information via one of the APIs?I have approx 126 datasets and I want to check the refresh schedules set for all of these against the update frequency set in the asset metadata field. 

Hi, I’m Kamal Hinduja , Switzerland(Swiss). Can anyone explain me in details Are there limits on API call rates or data retrieval sizes? Thanks 

I am kindly requesting air quality datasets with variables  PM2.5, PM10, O₃, NO₂, SO₂, etc.) across many locations in Africa.

As there is still missing a button that hides a public dataset from catalog, we’re trying to do a workaround.For that, we would like to incorporate a public dataset of our secondary workspace, which isn’t publicly promoted, into a dashboard/code-editor’s page of our primary workspace. Has someone tried something similar? Has it worked out?My first thought was to do it via “domain” attribute of “ods-dataset-context” widget, but that didn’t work out: <ods-dataset-context context="test" test-dataset="test-index-dataset" test-domain="https://myseconddomain.opendatasoft.com/" ></ods-dataset-context>Thanks for your ideas :)

Is there a way to add metadata and dataset schema translations (e.g. in english or italian) via the Automation API?

Hi All,Is there any definitions for the possible “Actions” in the portal api monitoring? Ie what defines a “download” etc Thanks Ryan 

Hello everybody,I have 2 maps in my dashboard (2 different years):  I would like to have a shared “location” between those two.For example, if I zoom on the left one, I want the right one to be zoomed also.Is it possible ?Thanks in advance

I have a date selector on a custom view: https://cityobservatory.birmingham.gov.uk/explore/dataset/percentage-universal-credit-claimants-in-employment-wmca-wards-2025/insight/ The date selector is based on the date field which is set to type of month. However its only showing years. How can I have this show months? <div ods-facet-results="date" ods-facet-results-facet-name="date"ods-facet-results-context="ctxfiltered" ods-facet-results-sort="-alphanum"> <ods-selectselected-values="ctxfiltered.parameters['refine.date']"multiple="false"options="date"label-modifier="name"value-modifier="name"placeholder="Date"></ods-select></div> 

My dataportal has data for a number of Local Authorities in the UK. I want to use the Territory/Geographic filter (or some filter) so people can select the geography they are interested in i.e Birmingham, Coventry, Dudley etc.When I enable the territory filter it requires me to select a default location. But, there is no way to choose another of the locations within my datasets. Its my default or nothing. How can people navigate the catalogue for their chosen geography without having to hack the URL?

For over ten years, you have been publishing, exploring, and using open data with our tools. To support these uses, we have made available two portals powered by Opendatasoft:data.opendatasoft.com, showcasing public data published by Opendatasoft platform clients, public.opendatasoft.com, where we republish complementary open data, maintained by Opendatasoft.These spaces have made it possible to expose a wide diversity of datasets, build enriched use cases, and inspire the community. Today, we are evolving this offering to make it clearer, more sustainable, and more useful for all members of our ecosystem.Clarifying the offer, strengthening the impactWe want to focus our efforts on what is truly useful to you: well-selected, carefully maintained datasets, accessible within a clear framework. To achieve this, we will evolve our system: Closure of data.opendatasoft.com: This portal will no longer be accessible as a public showcase. All existing access will remain functional: datasets wil

I have a little code block on a custom view/code page which links to the dataset. See below:<div class="advanced-kpi--bottom"> <div class="advanced-kpi--bottom-second-stage"> <a class="source" href="/explore/dataset/{{ ctx.dataset.datasetid }}/table/" target="_blank" rel="noopener norefer"> View Source <i class="fa fa-long-arrow-right" aria-hidden="true"></i> </a> </div></div> I would like the href to be dynamic to either use the refine in the dataset context parameters or based on some on page filters. See this page for the filters in question: https://cityobservatory.birmingham.gov.uk/explore/dataset/percentage-households-in-fuel-poverty-wmca-wards/insight/Is this possible? The URL sync is on if that helps. Or do I need to hard code the refine.arealabel into the URL path?

I have a page:https://cityobservatory.birmingham.gov.uk/explore/dataset/test-emergency-admissions-for-copd-icp-outcomes-framework-birmingham-and-solihull-wards/insightWhich has 4 filters on that I want t o affect the majority of the visuals. However, for the map I want this to ignore anything made to the 3rd filter “area_name” but respect all other filters. How can I achieve this?I have tried the following either as its own context or as part of the main one at the start of the page but it just wont listen<ods-dataset-context context="mapctx" mapctx-dataset="{{ ctx.dataset.datasetid }}" mapctx-parameters="{ 'refine.date'= ctx.parameters['refine.date'], 'refine.time_period_range'= ctx.parameters['refine.time_period_range'], 'refine.ethnicity'= ctx.parameters['refine.ethnicity'], 'refine.imd':'ALL' }"> 

Hello Opendatasoft Community, I’m Prakash Hinduja, I’m currently working on a dataset that needs to stay up to date, and I’d like to schedule automatic data updates in Opendatasoft.I’d really appreciate any guidance, examples, or tips from your experience. Thanks in advance for your help! RegardsPrakash Hinduja 

Hi everyone,I’m Dario Schiraldi currently working on a project where I need to join multiple datasets, and I’d love to hear your suggestions on the best practices for performing data joins. Specifically, I’m interested in methods for both SQL and Python.I’d appreciate any insights, tips, or resources you have! Thanks in advance!RegardsDario Schiraldi CEO of Travel Works 

Bonjour, Je cherche à conserver les retours à la ligne de mon fichier d’origine (caractère LF), j’ai essayé avec le processeur “remplacer le texte” mais ça n’a aucun effet.Auriez-vous des pistes ? Merci Auto-translation 🪄Hello, I am looking to keep the newlines of my original file (LF character), I tried with the “replace the text” processor but it has no effect. Do you have any ideas? THANKS

As I’m trying to create a page with the code editor, I’m facing an issue with the refinement of datasets.To automate a line chart for different contexts, so that I can select one dataset of a list of many datasets and use the same ods-chart tag, I want to refine all the contexts before referencing on them in the chart widget. But the important aspect of my question is this: For this refinement, it would be more convenient for me to define the values that should be excluded, instead of the ones that should be included.Is there a possibility to do so?Thank you all in advance! :)

I want to display the evolution of population in all districts of Würzburg with a line chart. For that I use this dataset.In order to compare the districts, I created a series-breakdown on “Stadtbezirk” facet. But since there are 13 districts, this looks a little bit confusing. At the moment, one could unselect several districts by hand by clicking on them in the legend. In this case, it would be more convenient, if there are all but a one ore two districts unselected by default.Is there any possibility to implement this in the HTML or CSS-Code?At the moment, the code for the chart looks like this:<ods-dataset-context context="stadtbezirkehauptwohnsitzaltersgruppen" stadtbezirkehauptwohnsitzaltersgruppen-dataset="stadtbezirke_hauptwohnsitz_altersgruppen"> <ods-chart scientific-display="false" align-month="true"> <ods-chart-query context="stadtbezirkehauptwohnsitzaltersgruppen" field-x="jahr" maxpoints="0" timescale="year" series-breakdown="stadtbezirk">