Community

Recently active
Help others
Categories

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

256

1 day ago

Johannes HoolBeginner

Managing data portal

Best Practice for Updating Dataset Resources with the Automation API

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

120

1 day ago

yvonneBeginner

Gather data

Get ODS to take at least the first value (lat/lon)

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.

111

5 days ago

chris_dixonBeginner

Share data

Highlighting the choropleth tile when refining with an HTML table

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

100

6 days ago

pauline.planckeODS Team

Parquet export format is available by default on all Opendatasoft portals 🚀News

🔎 What is Parquet export?Parquet export is one of the fastest data storage formats to read and load. Its hybrid storage format (by column and by row) optimizes reading performance. ✨ What are the advantages of the Parquet export format?Ultra-fast loading, ideal for large datasets Optimized storage, up to 7 times lighter than GeoJSON export Facilitated analysis, thanks to column organization Free and universal format, available in Open Source and compatible with a multitude of tools, including data science tools, Python, and the Opendatasoft Studio no-code via an extension.👉 Try out data export in the Parquet file format now!Head to your portal, or any Opendatasoft portal (including the Data Hub) Select a dataset Go to the “Export” tab Download the dataset in the Parquet format Start exploring the data To learn moreDon't hesitate to read Opendatasoft or Parquet documentation.

672

6 days ago

opd_2025Beginner

Managing data portal

"Invalid value for sum of offset + limit API parameter" error with exports endpoint

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

Barry enwlBeginner

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?

221

9 days ago

rwadkinsBeginner

Additional Supported LanguagesOpen

We have a large segment of our population that is Asian-Indian and their primary language is Hindi. Does ODS have any plans to add more supported languages, specifically Hindi?

12 days ago

RyanMember

Organize data

Editing geopoint schema

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

161

16 days ago

sarahcBeginner

Analyze usage

Word component search result

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

321

22 days ago

Eva BerryBeginner

Analyze usage

Automation of dataset usage Statistics

256

1 day ago

Johannes HoolBeginner

Managing data portal

Best Practice for Updating Dataset Resources with the Automation API

120

1 day ago

yvonneBeginner

Gather data

Get ODS to take at least the first value (lat/lon)

111

5 days ago

chris_dixonBeginner

Share data

Highlighting the choropleth tile when refining with an HTML table

Barry enwlBeginner

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?

221

9 days ago

RyanMember

Organize data

Editing geopoint schema

161

16 days ago

sarahcBeginner

Analyze usage

Word component search result

321

22 days ago

Domi SchusterBeginner

Share data

Series breakdown: unselect some facet values per default

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

26 days ago

GabriellabrowneBeginner

Managing data portal

Optimizing Opendatasoft Dashboards for High-Performance Data Visualizations

Hello Opendatasoft Community,I've been exploring the capabilities of Opendatasoft for creating dynamic dashboards and interactive data visualizations. The platform's flexibility in handling diverse datasets and its user-friendly interface have been impressive. However, as I delve deeper into more complex data representations, I'm curious about best practices to ensure optimal performance and responsiveness.Specifically, I'm interested in strategies for: Efficiently managing large datasets to prevent lag in visualizations. Implementing real-time data updates without compromising dashboard speed. Utilizing Opendatasoft's API features to enhance data interactivity. Given the platform's robust features , I'm confident there are effective methods to achieve these goals.On a related note, I've been considering hardware upgrades to support more intensive data processing tasks. Would investing in an i5 gaming laptop provide the necessary performance boost for handling complex data visualiz

130

29 days ago

TMSBeginner

Share data

Indents in bullet list

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:

1 month ago

Discussions

Ask for help or share an insight.

Gather data

13 topics

Organize data

15 topics

Share data

42 topics

Analyze usage

10 topics

Managing data portal

30 topics

The world of data

19 topics

News and announcements

Keep track of new features, product updates, customer stories, and event replays.

New resources

5 topics

Replays

1 topic

Awarded Badges widget

Nicolas Terpolillihas earned the badge Pioneer
Rémyhas earned the badge Influencer
Lydiahas earned the badge Curious
Anthony Pépinhas earned the badge Curious
Digital Hub Adminhas earned the badge Curious

Show all badges

Explore the community

Join conversations, learn and grow with people who get community like you

Discussions

Gather data

Organize data

Share data

Analyze usage

Managing data portal

The world of data

News and announcements

New resources

Replays

Awarded Badges widget

Most helpful members this week

Community

Explore the community

Join conversations, learn and grow with people who get community like you

Awarded Badges widget

Most helpful members this week

Sign up

Already have an Opendatasoft account ?

Login to the community

Already have an Opendatasoft account ?

Scanning file for viruses.

This file cannot be downloaded