Authorized Terraces in 2019Terrasses autorisées en 2019

Terrasses autorisées en 2019Authorized Terraces in 2019

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

This dataset inventories all café and restaurant terraces authorized in 2019 on public land within the city of Strasbourg. It includes the establishment's name, its address-level location, the terrace's surface area, and the identifier of the corresponding administrative permit file. The data is published by the city of Strasbourg as part of its open data initiative and can be used to analyze the distribution and extent of authorized outdoor seating on public space across the city.L'objectif du jeu de données est de recenser l'ensemble des terrasses autorisées en 2019 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 (11 fields)

Filterable via the API (9)

villenombis_teradressesuperficiecpidentifiantndeg_rueurl_plan

Click a field to see example values.

Fill	Field	Type	Description
—	geo_point_2dGeo Point	geo_point_2d	Geographic coordinates (latitude/longitude) of the terrace.Geographic coordinates (latitude/longitude) of the terrace.
—	geo_shapeShape	geo_shape	Geometric shape (polygon) outlining the terrace area.Geometric shape (polygon) outlining the terrace area.
—	ville	text	Name of the city, typically Strasbourg.Name of the city, typically Strasbourg.
—	nomNom de l'enseigne	text	Name of the business or establishment operating the terrace.Name of the business or establishment operating the terrace.
—	bis_terBis ter	text	Address suffix indicating duplicate street numbering (bis/ter).Address suffix indicating duplicate street numbering (bis/ter).
—	adresse	text	Street name where the terrace is located.Street name where the terrace is located.
—	superficieSuperficie autorisée	int	Authorized surface area of the terrace, in square metres.Authorized surface area of the terrace, in square metres.
—	cpCode postal	text	Postal code of the terrace's location.Postal code of the terrace's location.
—	identifiant	text	Identifier of the authorization case file.Identifier of the authorization case file.
—	ndeg_rueNuméro rue	text	Street number of the terrace's address.Street number of the terrace's address.
100%	url_planAccès au plan détaillé	text	Link to the detailed site plan of the terrace.Link to the detailed site plan of the terrace.

Schema captured from opendatasoft 1 day 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 1cp: 67000 · nom: L'EDEN SANS GLUTEN

{
  "cp": "67000",
  "nom": "L'EDEN SANS GLUTEN",
  "ville": "STRASBOURG",
  "adresse": "PCE ARNOLD",
  "bis_ter": null,
  "ndeg_rue": "6",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2019/000828.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "MultiPolygon",
      "coordinates": [
        [
          [
            [
              7.770452356810401,
              48.585092948456825
            ],
            [
              7.770595169516433,
              48.58511398718484
            ],
            [
              7.770576252269664,
              48.585170970433474
            ],
            [
              7.770433298712478,
              48.58515004854025
            ],
            [
              7.770452356810401,
              48.585092948456825
            ]
          ]
        ]
      ]
    },
    "properties": {}
  },
  "superficie": 70,
  "identifiant": "000828",
  "geo_point_2d": {
    "lat": 48.58513198786926,
    "lon": 7.770514240883049
  }
}

Record 2cp: 67000 · nom: CASE METISSE

{
  "cp": "67000",
  "nom": "CASE METISSE",
  "ville": "STRASBOURG",
  "adresse": "RUE DE LA KRUTENAU",
  "bis_ter": null,
  "ndeg_rue": "46",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2019/011088.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "MultiPolygon",
      "coordinates": [
        [
          [
            [
              7.757503251626868,
              48.580245188041026
            ],
            [
              7.75751548566923,
              48.58024905832584
            ],
            [
              7.757492420406969,
              48.58027450971041
            ],
            [
              7.757481159915146,
              48.58027024258368
            ],
            [
              7.757503251626868,
              48.580245188041026
            ]
          ]
        ]
      ]
    },
    "properties": {}
  },
  "superficie": 3,
  "identifiant": "011088",
  "geo_point_2d": {
    "lat": 48.58025967255777,
    "lon": 7.75749817680084
  }
}

Record 3cp: 67000 · nom: S'KAECHELE

{
  "cp": "67000",
  "nom": "S'KAECHELE",
  "ville": "STRASBOURG",
  "adresse": "RUE DE L'ARGILE",
  "bis_ter": null,
  "ndeg_rue": "8",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2019/000425.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "MultiPolygon",
      "coordinates": [
        [
          [
            [
              7.74276333129585,
              48.58231217611771
            ],
            [
              7.742775671113002,
              48.582340071408325
            ],
            [
              7.742699256774976,
              48.58235468204835
            ],
            [
              7.742686901997297,
              48.582326625182354
            ],
            [
              7.74276333129585,
              48.58231217611771
            ]
          ]
        ]
      ]
    },
    "properties": {}
  },
  "superficie": 19,
  "identifiant": "000425",
  "geo_point_2d": {
    "lat": 48.58233339684043,
    "lon": 7.742731256464272
  }
}

Record 4cp: 67000 · nom: LA CIGOGNE

{
  "cp": "67000",
  "nom": "LA CIGOGNE",
  "ville": "STRASBOURG",
  "adresse": "PCE DE LA CATHEDRALE",
  "bis_ter": null,
  "ndeg_rue": "11",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2019/000461.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "MultiPolygon",
      "coordinates": [
        [
          [
            [
              7.74987453258292,
              48.58175427072458
            ],
            [
              7.749764341480437,
              48.581710090306856
            ],
            [
              7.749790265204517,
              48.58168161162055
            ],
            [
              7.749900469796132,
              48.581725791460435
            ],
            [
              7.74987453258292,
              48.58175427072458
            ]
          ]
        ]
      ]
    },
    "properties": {}
  },
  "superficie": 35,
  "identifiant": "000461",
  "geo_point_2d": {
    "lat": 48.58171794139048,
    "lon": 7.749832403866216
  }
}

Record 5cp: 67000 · nom: CONTE DE THES

{
  "cp": "67000",
  "nom": "CONTE DE THES",
  "ville": "STRASBOURG",
  "adresse": "RUE DU VIEUX MARCHE AUX VINS",
  "bis_ter": null,
  "ndeg_rue": "23",
  "url_plan": "https://sig.strasbourg.eu/datastrasbourg/occupation_domaine_public/terrasse/2019/011222.pdf",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "MultiPolygon",
      "coordinates": [
        [
          [
            [
              7.741665362996297,
              48.58399770248594
            ],
            [
              7.741666277233904,
              48.58397522823438
            ],
            [
              7.741706925635349,
              48.583975956112816
            ],
            [
              7.741707680968299,
              48.583998460260624
            ],
            [
              7.741665362996297,
              48.58399770248594
            ]
          ]
        ]
      ]
    },
    "properties": {}
  },
  "superficie": 8,
  "identifiant": "011222",
  "geo_point_2d": {
    "lat": 48.583986912200196,
    "lon": 7.74168656144195
  }
}

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

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-2019/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 1 day ago

Dataset

Volume & freshness

Records

587

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.