Downloading datasets

Opendatasoft datasets can be downloaded in various formats. Flat file formats are always available for any dataset. Other formats may be available if the dataset contains geographical coordinates.

1. Go to the Export tab of the dataset.

2. Choose the file format to download.

3. Perform one of the following actions:

   • Click Whole dataset next to the desired format.

   • If the dataset is filtered and you want to export the filtered data only, click Only the selected records next to the desired format.

You can use the parameter use_labels_for_header=true in the exports links to use the labels instead of the technical identifiers of the fields as a header (not available in the Opendatasoft Search API v2).You can also export datasets in other formats using the Opendatasoft Search API v2.

In the Export tab of a dataset, the following formats can be available:

There are three possible flat file formats: CSV, JSON, and Excel.

1. CSV
   CSV uses the semicolon (;) as a separator.

2. JSON

3. Excel

The geographical coordinates of a dataset are expressed in WGS84 by default. When made available by the data producer, you can select additional geographical projections from the drop-down displayed above the export formats.

There are three possible geographic file formats: Shapefile, GeoJSON, and KML.

1. Shapefile

   Note that there are two limitations to Shapefile exports:1) 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.2) The export cannot contain more than 50,000 records.

2. GeoJSON

3. KML

The iCalendar format is also possible:

1. 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.

1. In the front office, go to the Images visualization tab of the dataset containing the image(s) to download.

2. Click the image to download.

3. At the bottom of the image's metadata, click Download image.

1. In the front office, go to the Export tab of the dataset containing the images to export.

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 image and retrieve them.