Sags uns Anliegenmanagement Koeln Open311 API
Die Stadt Köln stellt anonymisiert alle Informationen zu Anliegen und Kategorien, die über diese Plattform eingehen und dargestellt werden, als Open Government Data unter der Datenlizenz Deutschland – Namensnennung – Version 2.0utschland Lizenz zur Verfügung. Hierbei nutzen wir den internationalen Standard Open311 und stellen ein so genanntes Georeport v2 API zur Verfügung. Über diese Schnittstelle können unsere Anliegen- und Dienstleistungskategorien (Services) und die eingebrachten Anliegen (Requests) maschinell ausgewertet werden. In zukünftigen Versionen öffnen wir die Schnittstelle auch, um Beiträge in diese Plattform einzustellen [via Method POST]. Die folgende Spezifikation stammt in großen Teilen von Open311.org, angepasst auf die lokale Bedingungen der Stadt Köln. Services
Purpose Provide a list of acceptable 311 service request types and their associated service codes. These request types can be unique to the city/jurisdiction.
URL https://sags-uns.stadt-koeln.de/georeport/v2/services.[format]
Sample URL https://sags-uns.stadt-koeln.de/georeport/v2/services.xml
Formats XML / JSON
HTTP Method GET
Requires API Key No
Requests
Purpose Query the current status of multiple requests
URL https://sags-uns.stadt-koeln.de/georeport/v2/requests.[format]
Sample URL https://sags-uns.stadt-koeln.de/georeport/v2/requests.json?start_date=2014-1-22...
Formats XML, JSON
HTTP Method GET
Requires API Key No
Optionale Parameter
Field Name Description Notes & Requirements
service_code
Specify the service type by calling the unique ID of the service_code. This defaults to all service codes when not declared; can be declared multiple times, comma delimited
start_date
Earliest datetime to include in search. When provided with end_date, allows one to search for requests which have a requested_datetime that matches a given range, but may not span more than 90 days. When not specified, the range defaults to most recent 90 days. Must use w3 format, eg 2010-01-01T00:00:00Z.
end_date
Latest datetime to include in search. When provided with start_date, allows one to search for requests which have a requested_datetime that matches a given range, but may not span more than 90 days. When not specified, the range defaults to most recent 90 days. Must use w3 format, eg 2010-01-01T00:00:00Z.
status
Allows one to search for requests which have a specific status. This defaults to all statuses; can be declared multiple times, comma delimited; Options: open , closed
page One page shows 50 requests 0-n
Single Request
Purpose Query the current status of an individual request
URL https://sags-uns.stadt-koeln.de/georeport/v2/requests/#ID.[format]
Sample URL https://sags-uns.stadt-koeln.de/georeport/v2/requests/1d8d-0.json
Formats XML, JSON
HTTP Method GET
Requires API Key No
There are no views created for this resource yet.
Additional Information
| Field | Value |
|---|---|
| Data last updated | unknown |
| Metadata last updated | May 30, 2025 |
| Created | unknown |
| Format | http://publications.europa.eu/resource/authority/file-type/XML |
| License | Datenlizenz Deutschland – Zero – Version 2.0 |
| Conforms to | ["https://www.dcat-ap.de/def/dcatde/1.1/spec/specification.pdf"] |
| Created | 2 weeks ago |
| Issued | 2015-11-18T11:47:30+01:00 |
| Language | ["http://publications.europa.eu/resource/authority/language/DEU"] |
| Modified | 2022-07-26T11:47:05+02:00 |
| Rights | https://www.govdata.de/dl-de/zero-2-0 |
| Uri | https://offenedaten-koeln.de/dataset/sags-uns-anliegenmanagement-koeln/resource/63b26493-81c1-4e26-81c9-244e4d6b5ea6 |
| Access url | https://offenedaten-koeln.de/dataset/sags-uns-anliegenmanagement-koeln/resource/63b26493-81c1-4e26-81c9-244e4d6b5ea6 |
| Distribution ref | https://offenedaten-koeln.de/dataset/sags-uns-anliegenmanagement-koeln/resource/63b26493-81c1-4e26-81c9-244e4d6b5ea6 |
| Documentation | ["https://offenedaten-koeln.de/dataset/sags-uns-anliegenmanagement-koeln/resource/63b26493-81c1-4e26-81c9-244e4d6b5ea6"] |
| Id | 7527f28e-5873-4179-890e-34516043425d |
| License | http://dcat-ap.de/def/licenses/dl-zero-de/2.0 |
| License infos | Datenlizenz Deutschland – Zero – Version 2.0;https://www.govdata.de/dl-de/zero-2-0 |
| Package id | 5505c999-5d1a-4291-9f71-2e737de081bb |
| Plannedavailability | http://dcat-ap.de/def/plannedAvailability/stable |
| State | active |
| Status | http://purl.org/adms/status/Completed |