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

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

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

This dataset lists all sidewalk café terraces authorized in 2021 on public land in the city of Strasbourg, France. It provides information such as the business name, street address location, surface area, and the identification number of the corresponding permit application file. It is published by the city of Strasbourg as part of its open data program and is useful for tracking commercial terrace occupancy of public space within the city.L'objectif du jeu de données est de recenser l'ensemble des terrasses autorisées en 2021 sur le domaine public de la ville de Strasbourg. Les informations disponibles sont le nom de l'enseigne, la localisation à l’adresse, la superficie et l’identifiant du dossier d’instruction. Cette donnée a ét...

⬇ 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)

villenom_enseignesuperficie_autoriseeurl_planidentifiantadresse_etablissement

Click a field to see example values.

Field	Type	Description
geo_point_2dGeo Point	geo_point_2d	Geographic centroid coordinates (latitude, longitude) of the terrace.Geographic centroid coordinates (latitude, longitude) of the terrace.
geo_shapeShape	geo_shape	Geometric shape (polygon) outlining the authorized terrace area.Geometric shape (polygon) outlining the authorized terrace area.
ville	text	City where the terrace is located, Strasbourg.City where the terrace is located, Strasbourg.
nom_enseigneNom de l'enseigne	text	Name of the business or establishment operating the terrace.
superficie_autoriseeSuperficie autorisée	int	Authorized surface area of the terrace, in square meters.Authorized surface area of the terrace, in square meters.
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.
identifiant	text	Unique identifier of the terrace authorization file.Unique identifier of the terrace authorization file.
adresse_etablissementAdresse	text	Street address of the establishment hosting the terrace.Street address of the establishment hosting the terrace.

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/2021/000958.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "MultiPolygon",
      "coordinates": [
        [
          [
            [
              7.7580215868517,
              48.58312568550973
            ],
            [
              7.758073151861281,
              48.58317309106717
            ],
            [
              7.758055517946756,
              48.58318147265443
            ],
            [
              7.758004012074326,
              48.58313411872587
            ],
            [
              7.7580215868517,
              48.58312568550973
            ]
          ]
        ]
      ]
    },
    "properties": {}
  },
  "identifiant": "000848",
  "geo_point_2d": {
    "lat": 48.58315359165186,
    "lon": 7.758038569289536
  },
  "nom_enseigne": "AU BISTROT DU QUAI",
  "superficie_autorisee": 10,
  "adresse_etablissement": "11 QUAI DES PECHEURS"
}

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

{
  "ville": "STRASBOURG",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2021/001237.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "MultiPolygon",
      "coordinates": [
        [
          [
            [
              7.747147470917085,
              48.58059377988951
            ],
            [
              7.747109760625175,
              48.58056793597036
            ],
            [
              7.74712054801928,
              48.58053685903887
            ],
            [
              7.747134276724354,
              48.58054414260135
            ],
            [
              7.747133690463156,
              48.580544633378246
            ],
            [
              7.747139153168649,
              48.58054751731293
            ],
            [
              7.7471399503697835,
              48.58054683100318
            ],
            [
              7.747142946211206,
              48.58054838484035
            ],
            [
              7.74713346726221,
              48.58055643081602
            ],
            [
              7.747162011698013,
              48.580571235799724
            ],
            [
              7.74717148162066,
              48.5805631851368
            ],
            [
              7.747176392693792,
              48.580565734491024
            ],
            [
              7.747175091896341,
              48.580566313589465
            ],
            [
              7.7471782368539435,
              48.580567716648005
            ],
            [
              7.747147470917085,
              48.58059377988951
            ]
          ]
        ]
      ]
    },
    "properties": {}
  },
  "identifiant": "011851",
  "geo_point_2d": {
    "lat": 48.58056752041692,
    "lon": 7.747137764593088
  },
  "nom_enseigne": "LES PROCAFEINISTES",
  "superficie_autorisee": 13,
  "adresse_etablissement": "16 RUE DES SERRURIERS"
}

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

{
  "ville": "STRASBOURG",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2021/000395.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "MultiPolygon",
      "coordinates": [
        [
          [
            [
              7.739242881837537,
              48.58279687936235
            ],
            [
              7.739350130163856,
              48.58288056332563
            ],
            [
              7.739329513318849,
              48.58289224429546
            ],
            [
              7.739222395084786,
              48.582808645101274
            ],
            [
              7.739242881837537,
              48.58279687936235
            ]
          ]
        ]
      ]
    },
    "properties": {}
  },
  "identifiant": "001802",
  "geo_point_2d": {
    "lat": 48.58284458615388,
    "lon": 7.7392862373709255
  },
  "nom_enseigne": "YUME SUSHI",
  "superficie_autorisee": 24,
  "adresse_etablissement": "2 PCE SAINT-PIERRE-LE-VIEUX"
}

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

{
  "ville": "STRASBOURG",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2021/000435.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "MultiPolygon",
      "coordinates": [
        [
          [
            [
              7.776240212492106,
              48.586231540022276
            ],
            [
              7.776313429950901,
              48.58629431068129
            ],
            [
              7.776297332704329,
              48.58630255077334
            ],
            [
              7.776224438271029,
              48.58623974879053
            ],
            [
              7.776240212492106,
              48.586231540022276
            ]
          ]
        ]
      ]
    },
    "properties": {}
  },
  "identifiant": "000938",
  "geo_point_2d": {
    "lat": 48.586267110385954,
    "lon": 7.776268940947917
  },
  "nom_enseigne": "PATISSERIE FRANCOIS",
  "superficie_autorisee": 13,
  "adresse_etablissement": "36 BD DE LA MARNE"
}

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

{
  "ville": "STRASBOURG",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2021/000155.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "MultiPolygon",
      "coordinates": [
        [
          [
            [
              7.75117989222576,
              48.58034954740572
            ],
            [
              7.751196562742363,
              48.58035723525282
            ],
            [
              7.751230903028328,
              48.58032451020902
            ],
            [
              7.751303095811348,
              48.580358009259236
            ],
            [
              7.7512178721252,
              48.58043933671387
            ],
            [
              7.751128844583916,
              48.5803982826202
            ],
            [
              7.75117989222576,
              48.58034954740572
            ]
          ]
        ]
      ]
    },
    "properties": {}
  },
  "identifiant": "000978",
  "geo_point_2d": {
    "lat": 48.58038144202104,
    "lon": 7.75121685966147
  },
  "nom_enseigne": "CAFE DE L'ILL",
  "superficie_autorisee": 82,
  "adresse_etablissement": "9 PCE DU MARCHE AUX COCHONS DE LAIT"
}

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

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-2021/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

600

Last upstream update

3 years ago

2023-08-18

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.