Downloading a dataset

Patrick Smith Updated by Patrick Smith

Datasets can be downloaded in various formats. While flat file formats (CSV, JSON, Excel) are always available for any dataset, other formats may be available, depending on whether the dataset contains geographical coordinates or not.

Flat file formats and geographical file formats
  1. In a portal, go to the Export tab of the dataset and choose the file format to download
  2. Perform one of the following actions:
    • Click Whole dataset next to the desired format
    • If you have filtered the data and you want to export only the filtered data, instead click Only the selected records next to the desired format
When you download a dataset, by default the labels for the data will match those you see in the table view. If you prefer the download use the the technical labels (those visible in the dataset's schema), you can do so using the following steps.

1) Right-click on Whole dataset for the designed format, copy the URL, and paste it into your browser
2) Find use_labels_for_header=true, replace "true" with "false", and hit enter

You can also export datasets in other formats using the Opendatasoft Search API.

Available export formats

In a dataset's Export tab, the following formats are available:

Flat file formats
  • CSV (Uses a semicolon (;) as the separator)
  • JSON
  • Excel (.xlsx)
Geographic file formats
The geographical coordinates of a dataset are expressed in WGS84 by default. If provided by the data producer, additional geographical projections may be available in the drop-down menu displayed above the export formats.
  • GeoJSON
  • Shapefile
    There are two limitations in Shapefile exports: 1) The export cannot contain more than 50,000 records. 2) The export cannot contain more than one geographical shape type (point, polygon, linestring, etc.). If the dataset contains one geoshape field with multiple shape types, only the first type of the first non-empty record will be kept in the export.If the dataset contains multiple geographical fields (geoshape or geo_point_2d), only the first shape type of the first non-empty record will be kept in the export.
  • KML
  • FlatGeobuf (FGB)
  • GPX
Data analysis file formats
  • Parquet
Specialized formats

Exporting and downloading images

Images imported into the platform can only be downloaded or exported one by one. There is no way to download all the images of a dataset at the same time.

Downloading an image
  1. In the front office, go to the Images visualization tab of the dataset containing the image to download
  2. Click the image to download
  3. At the bottom of the image's metadata, click Download image
Exporting dataset to retrieve image URLs
  1. In the front office, go to the Export tab of the dataset containing the images
  2. Export the whole dataset, or only the selected records if the dataset is filtered
  3. Open the exported dataset in the spreadsheet software of your choice
  4. Find the field containing the URLs of the images and retrieve them

How did we do?

Introduction to the WFS API

Contact

Powered by HelpDocs (opens in a new tab)