Huwise discussions

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.

I do not see any limitations on the offset and limit parameters for the exports endpoint. However, when I make the following request:https://data.longbeach.gov/api/explore/v2.1/catalog/datasets/lbpd-ripa-data-annual/exports/csv?offset=1I get back a CSV file with only 2 rows and the 2nd row says: “Streaming interrupted due to the following error: Invalid value for sum of offset + limit API parameter: 83714 was found but <= 10000 is expected. (error_code: InvalidRESTParameterError)”I thought the 10000 limit for offset+limit only applied to the records input. Is that wrong?If it’s useful, I am able to retrieve the entire dataset at once:https://data.longbeach.gov/api/explore/v2.1/catalog/datasets/lbpd-ripa-data-annual/exports/csv?offset=0

Dear all,it appears that text search for word components doesn’t include results where the word component starts in the middle of a word element.Can you confirm this search result property and is there a possible work-around or a future feature that allows full-text search within words?ExampleText search “kirsch” finds entries with the attribute “Trauben-Kirsche” but not those with “Traubenkirsche”. URLshttps://data.bs.ch/explore/dataset/100052/table/?q=kirsch&sort=arthttps://data.bs.ch/explore/dataset/100052/table/?sort=art&refine.baumart_lateinisch=Prunus+padushttps://data.bs.ch/explore/dataset/100052/table/?sort=art&refine.baumart_lateinisch=Prunus+padus&q=kirsch

Dear ODS Community,I’m reaching out to see if anyone has experience creating a calendar subscription in ODS. I know you can download calendars via iCal export, but is it also possible to generate an .ics subscription that automatically updates whenever the source data changes?Thank you in advance for your help!

Hello, I am trying to change the thickness of the line in one of my ods-charts. I saw in the documentation that I can use a custom css library to change the formatting (ods-chart: Custom CSS Library – Codelibrary).I added the class="large-chart-series" to my ods-chart and it worked well when I was running the website locally.However when I try to implement the changes in the code editor on the ODS portal I am getting an API error:Is using the custom css library depreciated?What else can I do do change the format of my charts?Below I am pasting the code for the ods-chart I was working on. Thanks for the help  <ods-chart class="large-chart-series" single-y-axis="true" single-y-axis-label="" display-legend="true" label-x="" scientific-display="false" align-month="true" class="no-bg" > <ods-chart-query context="eolienperiodique" field-x="timestamp"

Studio page: If you make an bullet list, no automatic indentation is made for the individual bullet points if an enumeration extends over several lines. This does not look nice, like in this example: 

I am building a KPI card to include on an HTML page on our portal, and I want to show the unique number of users that have used our portal in the last month; by counting the number of distinctvalues in the user_ip_addr column in the ods-api-monitoring dataset.  I have tried to use the ods-aggregation widget to do this, but there is no option for a distinct count in odsAggregationFunction.  Is there an alternative way to show the number of distinct users in the last month?

Is there a limit to the number of characters in text columns? I have long texts in a column and these are cut off in the tooltip and in the table preview. Is there a solution so that the whole text is displayed?

HelloI want to publish a dataset that is in a ZIP format. The source is a URL that I don’t want to share for safety/server load reasons. Unfortunately, ODS unzip it automatically.I just want an other URL pointing toward the same zip file… is it possible?Thank you Auto-translation 🪄BonjourJe souhaite publier un jeu de données au format ZIP. La source est une URL que je ne souhaite pas partager pour des raisons de sécurité/charge du serveur. Malheureusement, ODS le décompresse automatiquement. Je souhaite simplement une autre URL pointant vers le même fichier zip… est-ce possible ? Merci 

I created a custom visualization for a dataset which is a searchable table in our corporate style. When embedding this visualization through an iframe the details-area is sticking to the bottom of the frame.In the following example you can see the rather prominent details-area at the bottom of the element.Is there a possibility to suppress this element? At the beginning I thought I could do this with the url parameter “datasetcard” (see example link below). However, I must have misinterpreted this parameter as it does not influence the details-area.<iframe src="https://data.bl.ch/explore/embed/dataset/adressen-der-gemeindeverwaltungen-januar-2025-kopieren/webtabelle/?disjunctive.name&disjunctive.plz&disjunctive.ort&static=false&datasetcard=false" width="400" height="300" frameborder="0"></iframe>Any help would be greatly appreciated.Best,Johannes

Hi,we would like to use ODS API to implement CICD on the style sheet of our portal.We are waiting since severals years now for this feature to appear in automation, I guess it won’t happen.Anyway ODS made previously a GH repo with a snippet of how to use management api to update the style sheet :https://web.archive.org/web/20201013231909/https://github.com/opendatasoft/ods-portal-devkit#expandUnfortunatly this repo is now deleted and the files ont the repo are gone.Is anyone aware on how to use the management API for the domain_theme ?

HiI’m trying to join a couple of datasets spatially.In Dataset A I have a geopoint (lat/long)In Dataset B I have a list of attributes in a polygon (shape) I want to use the geopoint in Dataset A as the key for Dataset B and return one or more columns from Dataset B…  Thank you for any options :)

We have created some dashboards for students that are not yet publicly visible. The charts and KPIs on the dashboards are very aggregated, but the underlying datasets could be sensitive in terms of data protection. Is there a way that the datasets can only be used for the dashboards without a visitor to our ODS website being able to access the dataset itself?An alternative would be to hide some columns in the data set, but these are included again when exporting. Or is there a restriction option so that only the data that is visible on the ODS website can be exported?As an addendum: the dashboards were created with no-code-editor.

Hello!I am currently working on visualizing a table in a dashboard, and I would like to have a final row where I can freely sum or average the values in the table. The table is updated daily and evolves over time. The [totals] argument in ods-adv-table exists, but as far as I know, it only allows summing the column values.The only workaround we have found so far is to create a second table, removing the "group-by" per day and computing the sum/average where needed. However, this solution has a visual drawback: the legend remains, and the data in the second table is not perfectly aligned with the first one.Do you have any other ideas to improve the visualization? I would greatly appreciate your help :) 

Hi folks.Is there a way to proper case text with a processor i.e change biomass to Biomass?Sometimes our source is a little sloppy in their data management and I would like to correct it on publish. Thanks,

Dear ODS Community Is there a way to sort a stacked bar plot according to the total value of the individual bars. Looking at the example in the image, I would like the bar for “Wohnzonen” to be on top and the bar for “weitere_Bauzonen” to be at the bottom. Here is the code for the barplot: <ods-chart scientific-display="false" single-y-axis="true" labels-x-length=100 label-x="Hauptnutzung"> <ods-chart-query context="dvsareraum20250224" field-x="ch_hauptnutzung_name" reverse-stacks="true" stacked="normal" series-breakdown="standueberbauung_aggregiert" sort="serie1-1"> <ods-chart-serie expression-y="flaeche_ha" chart-type="bar" index="0" function-y="SUM" color="range-custom" display-values="true"

Hi, Im really struggling to get the JSON processor to work with https://api.carbonintensity.org.uk/regionalI think I have it pulling in correctly but when I try and extract using the JSON processor using Extract from JSON or Expand JSON array it isnt populating the field. I’ve re-read the academy docs and asked ChatGPT but nothing is working in the output. Many Thanks,

Hi,I can’t find clear information on any rate limit for the usage of the API on public dataset like geonames-postal-code.I see a quota in my profile but I’m not sure this applies to public dataset.We have a use case where we measured up to 7000 registrations a day and would like to add city autocompletion based on zip code, so possibly resulting in as many requests to the API, or probably more if users don’t find the city they’re looking for after the first 3 digits (the limit we plan on setting to start querying the API).Is it something that could be supported without risk of hitting a limit?Thanks

When you include a map widget in a custom view for a dataset you may notice that the height is not optimal for screens. You can change this with the following css in the Custom View tab of Visualisations in the backoffice. Adjust the min-height value to suit. .odswidget-map {    height:-webkit-fill-available;    min-height: 600px;}.odswidget-map__map {    height: 100%;    min-height: 600px;}