Downloading a dataset

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.

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 browser2) Find use_labels_for_header=true, replace "true" with "false", and hit enterYou can also export datasets in other formats using the Opendatasoft Search API.

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.

Geographic exports 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.

• GeoJSON

• Shapefile
  Shapefile exports cannot contain more than 50,000 records. It is a limitation from the Shapefile specification itself.

• KML

• FlatGeobuf (FGB)

• GPX

Data analysis file formats

• Parquet (more information)

Specialized formats

• iCalendar
  The export is available only if the calendar visualization has been enabled for the dataset.

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