Huwise discussions

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">

Hi,My name is  Prakash Hinduja (Hinduja Family Swiss) , I want to know about the Schema management for datasets and why it is important .  Regards:Prakash Hinduja (Hinduja Family Switzerland)

Hello,Using the dataset named “ods-api-monitoring”, I am able to know the number of download for a specific dataset. However, I would like to perform this task every month, that’s why I want to automate this process using python. I tried to filter the dataset and take the link of the csv generated in order to upload it on python. Nevertheless, I have an error while launching the program, it seems that it has a link with the authentification on the plateform. Do we have access to an API for the dataset “ods-api-monitoring” ?  Or is there another recommended way to retrieve this information?Thank you for your help.Best regards,Eva Berry

Hello everyone,I’m Kamal Hinduja from Geneva, Switzerland. I’m new to this community and look forward to contributing positively to the discussions while learning from your insights. Could someone please explain how Open data soft integrates with public datasets? Thanks in Advance!Kamal Hinduja Geneva, Switzerland  

I have two datasets, one with polygons and names and one with data.I load the map in the LHS of the screen and use the refine-on-click feature within <ods-map-layer to load a HTML table on the RHS of the screen.However, I’d like to be able to have the map show the selection.I’ve tried using highlight-on-refine="true" but I suspect this doesn’t work because the data on the map is not actually being refreshed!Here is my code:!--scriptorendfragment--><div class="row ods-box"> <ods-dataset-context context="dfesmap,dfesdata" dfesmap-dataset="dfes-primary-polygons" dfesdata-dataset="dfes-2023-primary-data0"> <div class="col-md-8"> <ods-map style="height:560px" scroll-wheel-zoom="true"> <ods-map-layer context="dfesmap" display="choropleth" refine-on-click-context="dfesdata" refine-on-click

I would like to garner some ideas on how y’all manage updating static, flat file datasets on a regular basis.Most of ours pull from the source via API. But a few require us every week/month/year to download a flat file from the source to then re-upload to our platform.At first I thought a simple calendar with what needs doing when would be a good idea. But, some datasets dont drop on a regular schedule or can be delayed. So if I have a calendar entry saying “Download X data today” and its not there. It doesnt get done and I forget that ive not actually done that. So I need some way to check it off.How do you all efficiently manage your flat file updates? What tools or methods do you use?

Hi,I understand that geopoint schemas cant be edited when they are the centre of a geoshape, but is there anyway to still be able to edit the description? Mainly to state that this point is in fact the centre of the shape and not a location point (see below) Thanks Ryan

I’m trying to use some Openstreetmap data in ODS.However some of the data is formed where there are multiple lat/lon for an ID and when bringing it into ODS, ODS takes none of the lat/lon pairs when there are multiple.  See screenshot of the multiple lat/lon pairs The records with multiple happen to be at the bottom as I think (assume) ODS uses the first 20 rows to determine a pattern.  I want ODS to at least take the first pair of lat/lon so the data is somewhat accurate (at the moment it just ignores this and leaves the lat and lon fields blank. Query used for bringing in the data is here:https://overpass-api.de/api/interpreter?data=%2F*%0AThis%20query%20looks%20for%20nodes%2C%20ways%20and%20relations%20%0Awith%20the%20given%20key%2Fvalue%20combination.%0AChoose%20your%20region%20and%20hit%20the%20Run%20button%20above%21%0A*%2F%0A%5Bout%3Ajson%5D%5Btimeout%3A25%5D%3B%0A%2F%2F%20gather%20results%0Anwr%5B%22highway%22%3D%22elevator%22%5D%28-27.870644599673355%2C152.0219421386719%2C-26.