Authorized Sidewalk Cafés/Terraces in 2023Terrasses autorisées en 2023

Terrasses autorisées en 2023Authorized Sidewalk Cafés/Terraces in 2023

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

This API provides a dataset listing all outdoor café and restaurant terraces authorized in 2023 on the public land of the city of Strasbourg, France. For each terrace, it includes the establishment's name, its address location, the surface area in square meters, and the identifier of the corresponding permit application file. The dataset is published by the city of Strasbourg as part of its open data initiative and can be used to monitor public space occupation by commercial terraces.L'objectif du jeu de données est de recenser l'ensemble des terrasses autorisées en 2023 sur le domaine public de la ville de Strasbourg. Les informations disponibles sont le nom de l'enseigne, la localisation à l’adresse, la superficie en m² et l’identifiant du dossier d’instruction. Cette donné...

⬇ Export CSV List records Select & filter Run verified request Read the docs

Trust score

How is this computed?

fair

Weighted across five axes. Tap a ring for what it measures.

Data schema (8 fields)

Filterable via the API (6)

adresse_etablissementnom_enseignevilleidentifianturl_plansuperficie_autorisee

Click a field to see example values.

Field	Type	Description
geo_point_2dGeo Point	geo_point_2d	Geographic coordinates (latitude, longitude) of the terrace location.Geographic coordinates (latitude, longitude) of the terrace location.
geo_shapeShape	geo_shape	Polygon geometry outlining the authorized terrace area.Polygon geometry outlining the authorized terrace area.
adresse_etablissementAdresse	text	Street address of the establishment with the terrace.Street address of the establishment with the terrace.
nom_enseigneNom de l'enseigne	text	Name or brand of the establishment operating the terrace.Name or brand of the establishment operating the terrace.
ville	text	City where the terrace is located.City where the terrace is located.
identifiant	text	Unique identifier of the terrace authorization case file.Unique identifier of the terrace authorization case file.
url_planAccès au plan détaillé	text	Link to the detailed map plan of the terrace.Link to the detailed map plan of the terrace.
superficie_autoriseeSuperficie autorisée	int	Authorized terrace surface area in square meters.Authorized terrace surface area in square meters.

Schema captured from opendatasoft 2 days ago.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

Where=

Sort by

Sample data (5 records)

Record 1ville: STRASBOURG · url_plan: https://sig.strasbourg.eu/datastrasbourg

{
  "ville": "STRASBOURG",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2023/000804.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Polygon",
      "coordinates": [
        [
          [
            7.75487574,
            48.5834213328
          ],
          [
            7.7548501148,
            48.5834474338
          ],
          [
            7.7548384858,
            48.583442795
          ],
          [
            7.7548643837,
            48.5834164235
          ],
          [
            7.75487574,
            48.5834213328
          ]
        ]
      ]
    },
    "properties": {}
  },
  "identifiant": "010920",
  "geo_point_2d": {
    "lat": 48.583431993100106,
    "lon": 7.754857170183076
  },
  "nom_enseigne": "WOK THAI",
  "superficie_autorisee": 3,
  "adresse_etablissement": "11 PCE SAINT-ETIENNE"
}

Record 2ville: STRASBOURG · url_plan: https://sig.strasbourg.eu/datastrasbourg

{
  "ville": "STRASBOURG",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2023/000266.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "MultiPolygon",
      "coordinates": [
        [
          [
            [
              7.7415801564,
              48.5770782269
            ],
            [
              7.7415907525,
              48.577088669
            ],
            [
              7.741455843,
              48.5771448991
            ],
            [
              7.7414410808,
              48.5771296536
            ],
            [
              7.7415801564,
              48.5770782269
            ]
          ]
        ],
        [
          [
            [
              7.7414794029,
              48.5771706692
            ],
            [
              7.7414741113,
              48.5771654433
            ],
            [
              7.7416094188,
              48.5771050164
            ],
            [
              7.7416147097,
              48.5771102332
            ],
            [
              7.7414794029,
              48.5771706692
            ]
          ]
        ]
      ]
    },
    "properties": {}
  },
  "identifiant": "000010",
  "geo_point_2d": {
    "lat": 48.57711963816879,
    "lon": 7.741522175286503
  },
  "nom_enseigne": "BRASSERIE DES GLACIERES",
  "superficie_autorisee": 28,
  "adresse_etablissement": "6 RUE KIRSCHLEGER"
}

Record 3ville: STRASBOURG · url_plan: https://sig.strasbourg.eu/datastrasbourg

{
  "ville": "STRASBOURG",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2023/001477.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Polygon",
      "coordinates": [
        [
          [
            7.7505183037,
            48.5803959618
          ],
          [
            7.7505270973,
            48.5803990408
          ],
          [
            7.7504779862,
            48.5804601393
          ],
          [
            7.750437337,
            48.5804457564
          ],
          [
            7.7504765912,
            48.5804109307
          ],
          [
            7.7504855653,
            48.5804063277
          ],
          [
            7.7504966106,
            48.5804032646
          ],
          [
            7.7505074313,
            48.5803999069
          ],
          [
            7.7505183037,
            48.5803959618
          ]
        ]
      ]
    },
    "properties": {}
  },
  "identifiant": "000517",
  "geo_point_2d": {
    "lat": 48.580428523732834,
    "lon": 7.750482185328318
  },
  "nom_enseigne": "ZEHNERGLOCK",
  "superficie_autorisee": 20,
  "adresse_etablissement": "4 RUE DU VIEIL-HOPITAL"
}

Record 4ville: STRASBOURG · url_plan: https://sig.strasbourg.eu/datastrasbourg

{
  "ville": "STRASBOURG",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2023/001045.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Polygon",
      "coordinates": [
        [
          [
            7.7466158509,
            48.5821940239
          ],
          [
            7.7466788838,
            48.5822015353
          ],
          [
            7.7466742818,
            48.5822197714
          ],
          [
            7.7466889947,
            48.5822378105
          ],
          [
            7.7466738241,
            48.5822917466
          ],
          [
            7.7465901919,
            48.5822820097
          ],
          [
            7.7466158509,
            48.5821940239
          ]
        ]
      ]
    },
    "properties": {}
  },
  "identifiant": "000786",
  "geo_point_2d": {
    "lat": 48.58224497072724,
    "lon": 7.746641492925648
  },
  "nom_enseigne": "LE BISTROT DES COCOTTES",
  "superficie_autorisee": 58,
  "adresse_etablissement": "5 RUE DU SAUMON"
}

Record 5ville: STRASBOURG · url_plan: https://sig.strasbourg.eu/datastrasbourg

{
  "ville": "STRASBOURG",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2023/000853.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Polygon",
      "coordinates": [
        [
          [
            7.7588623714,
            48.5787492593
          ],
          [
            7.7589088954,
            48.5787030754
          ],
          [
            7.7589179033,
            48.5787070669
          ],
          [
            7.7588882916,
            48.5787607564
          ],
          [
            7.7588623714,
            48.5787492593
          ]
        ]
      ]
    },
    "properties": {}
  },
  "identifiant": "001603",
  "geo_point_2d": {
    "lat": 48.578734070286885,
    "lon": 7.75889129284105
  },
  "nom_enseigne": "ALGORYTHME",
  "superficie_autorisee": 10,
  "adresse_etablissement": "64 RUE DE ZURICH"
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Configuration

Base URL: https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/terrasses-autorisees-en-2023

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/terrasses-autorisees-en-2023/records?limit=20' -H 'Accept: application/json'

First 20 records of the dataset as JSON.

Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.

Full API documentation ↗

Rate limits

2 000 000 req/day

per ipmeasured

observed 2 days ago

Dataset

Volume & freshness

Records

670

Last upstream update

3 years ago

2023-12-21

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.