Discussions

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

We are setting up a process to update the resources for our datasets using the Automation API. I am looking for best practice advice. Here is what we currently do, starting with a dataset_id and a file that we want to upload: Retrieve the dataset_uid using the endpoint /api/explore/v2.1/catalog/datasets/{dataset_id}. Retrieve the currently used resource_uid of the dataset using the endpoint /api/automation/v1.0/datasets/{dataset_uid}/resources, with the dataset_uid from step 1. Upload the file to the dataset using the endpoint /api/automation/v1.0/datasets/{dataset_uid}/resources/files, again using the dataset_uid from step 1. From the response I get the file_uid of the uploaded file. Update the dataset resource using the endpoint /api/automation/v1.0/datasets/{dataset_uid}/resources/{resource_uid}, with the dataset_uid from step 1, the resource_uid from step 2, and the file_uid from step 3. Republish the dataset using the endpoint /api/automation/v1.0/datasets/{dataset_uid}/pu

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

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

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

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 

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 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 :) 

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

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,