Berlin Open Data strategy


Icons use case study city info

City

Berlin

Icons use case study main actors

Main actors

City Government, Private Sector, Research Institutes / Universities

Icons use case study project area

Project area

Metropolitan Area

Icons use case study duration

Duration

Ongoing since 2011/01

In 2011, the City of Berlin engaged in the development of an Open Data platform to foster transparency in public administration and the production of smart city apps. 

The Senate Department for Economics, Energy and Public Enterprises is responsible for the Open Data strategy adopted by the City of Berlin. It regularly organizes events, such as hackathons and Open Data days, to promote the potential of Open Data, connect stakeholders and foster innovation. Public administrations, universities, and the private sector are the primary stakeholders involved in the consultation, generation and dissemination of Open Data.

Developing a vibrant Open Data culture among city administrators and app developers, requires political will, regular communication with the community and practical instruments. Conceived as a decentralized tool to which all city administrators can contribute, the Berlin Open Data Portal was launched in 2011 and now has more than 1200 data sets online. The portal has supported the development of many data-based apps, such as, internet speed and the location of bathing places in the city. Efforts are being made to upscale the use of the Open Data Portal in the city administration and improve the accuracy of available (real-time) data. The development of an Open Data platform supports the emergence of a data-driven administration and contributes to open government and good governance.

Sustainable Development Goals

Promote sustained, inclusive and sustainable economic growth, full and productive employment and decent work for all
Build resilient infrastructure, promote inclusive and sustainable industrialization and foster innovation
Make cities and human settlements inclusive, safe, resilient and sustainable
Promote peaceful and inclusive societies for sustainable development, provide access to justice for all and build effective, accountable and inclusive institutions at all levels
City
Berlin, Germany

Size and population development
The population registered for the municipality of Berlin in 2017 was 3,613,500, making it the second most populous city in the European Union. The larger metropolitan area has around 5 million people living in 1,347 square kilometres, giving it a population density of around 15,000 people per square kilometre—similar to Mexico City or Tokyo.

Population composition
It has been estimated that up to 30 percent of Berlin’ s population are of foreign origin. The foreigners originate from other parts of Europe—such as Serbia, Croatia, Poland, Russia, Spain, Bosnian, Bulgarian, and Italian—as well as from countries outside of Europe, such as Turkey, Palestine, Iran, Syria, Egypt and Ghana. The largest non-native population comes from Turkey; in the year of 2010, there were more than 100,000 Turkish registered as inhabitants of Berlin.

Main functions
Berlin is the capital and largest city of Germany, as well as one of the nation’s 16 states. It is situated approximately 112 miles (180 km) south of the Baltic Sea and lies in the wide glacial valley of the Spree River, which runs through the centre of the city. The city extends over an area of 891.7 square kilometres and stands at an average altitude of 34 meters above sea level. After the reunification of the two Berlins in 1990, Germany began a process to centralize the capital to Berlin (replacing Bonn, the former capital of West Germany). Since then, Berlin is the place where the German House of Representatives and the German Bundestag hold elections. However, it wasn’t until 2001 that the Bundestag and the government of Berlin were fully established under the same roof. Berlin is also a city of great cultural significance, which is evident if one considers the amount of historical landmarks that tie the city’s history to its multiple overlapping pasts. Some of the most important landmarks include the Holocaust memorial (inaugurated in 2003), remnants of the Berlin Wall (taken down on the 9th of November 1989), the Reichstag Building (which dates to 1884). As the capital of Germany, Europe’s most populous and economically powerful country, Berlin is also the centre of, culture, politics, media and science in the country and serves as a European hub for air and rail traffic.

Main industries / business
As the 4th largest economy of the world, Germany participates of a wide array of industries with a famous efficiency. In Berlin one may find strong state-owned enterprises, like the Deustche Bahn (the railway), which employs the largest amount of general population (more than 20,000 people). Other companies that thrive in Berlin are: the Deustche Post (DHL), the technology company Siemens, the automotive manufacturer BMW, and the telecommunications company Deutsche Telekom. Hence, one may assume that Berlin specializes in the secondary and tertiary sectors of economy. Tourism brings more than 135 million visitors to the city (which include day-time visitors as well as overnight ones). Apart from other student cities in Germany like Köln and Munich, Berlin houses some of the most well-reputed universities in the world: the Freire Universität Berlin and the Humboldt Universität zu Berlin, with more than 30,000 students each.

Sources for city budget
Berlin draws its budget for public expenditure largely from taxes, transfers received, fees, fines, and operating revenues. This money is federally approved and spent in such a way that it can also be used in the form of funding for companies, not only to comply with the provision of quality public services.

Political structure
Berlin serves both as a city with a local government and as capital of Germany. In regard to the latter, it houses the Bundesregierung (Federal government), the Bundestag (Federal parliament) and the Bundesrat (the States’ chamber of Parliament). Each of the 16 states of Germany has representation in Berlin. It is governed by the Berlin Senate which is comprised of 10 senators and the Governing Mayor. Also, the embassies of other countries from around the world are housed in the city. The 16 states (Laender) have a similar standing to the federal government in respect to most issues.

Administrative structure
Berlin is administrated by the Senate and its 12 districts or boroughs. The Senate is the city’s central administration, in charge of city planning, public policy, and regulation of public and private spheres. The district administrations decentralize some public functions, with reasonable difference between the various localities.

Open Data refers to data that is made freely available to the public without any restrictions for further use or dissemination. Personal data and other sensitive data (e.g. security or confidential data) are excluded from Open Data.

A city has many reasons to develop an Open Data platform: it encourages citizen participation and ensures the city administration is more transparent. It contributes to improving the exchange of information within government and encourages good governance and public debate.  Open Data fosters the emergence of new business sectors and associated applications.

The potential for running an Open Data platform in the City of Berlin was revealed in a preliminary study carried out by the Fraunhofer-Institute FOKUS in 2010. The institute presented three core recommendations:

  • Launch a platform to support the development of cloud-based Open Data
  •  Deliver a political statement for Open Government
  •  Begin with small-scale Open Data projects

Subsequently, the City administration commenced an online-voting system to define interesting data types and categories. Generally, data is relevant if easily accessible, machine-readable, non-discriminatory, complete and available in real-time.

In 2011, the project “Open Data Berlin” was launched and Open Government became part of the city government’s political guidelines. It included the definition of a legal framework as well as analyses, concepts, and an action plan. Simultaneously, an Open Data pilot portal was launched.

In the same year, the first “Berlin Open Data Day” (BODDy) was organized as a meeting between the city administration and the Open Data community. Initiated by the Senate Department for Economics, Energy and Public Enterprises, the aim of the meeting was to encourage the administration to publish data and to convince the Open Data community to use the published data.

The Berlin Open Data strategy was published in 2012. During that year, the Open Data Portal was further expanded to include approximately 100 data sets online.

Germany’s portal govdata.de was launched in 2013. Shortly after, the City of Berlin relaunched its own portal with about 250 data sets, including geo-data and new services. The city also strengthened the exchange of experiences with other countries.

In 2014 – 2015 -  additional Berlin Open Data Days were organized and the city also supported the “Hackdays” (Coding da Vinci, Energy Hack).

In 2016, the E-Government law was legislated. At this time the open-data portal comprised more than 1200 data sets, 50 applications and 22 categories, e.g. labor market, demography, tourism, health, etc. Decentralized data provision ensures more up-to-date information and less effort for data supervisors. Data providers include District Offices, Senate Administrations, Statistical Office, Berlin Partner for Business and Technology GmbH, Fraunhofer Institute for Open Communication Systems FOKUS, VBB Verkehrsverbund Berlin-Brandenburg GmbH, Robert Koch Institute, and Stromnetz Berlin GmbH.

The Open Data "ecosystem" includes many stakeholders who contribute their expertise to the strategy:

  • Berlin city administration as data publisher;
  • Technologiestiftung Berlin;
  • Stiftung Neue Verantwortung;
  • Open Knowledge Foundation;
  • OK-Labs;
  • private companies working with data;
  • activists and hobbyists.

The development of the Open Data Portal is entirely financed by the Senate Departement for Economics, Energy and Public Enterprises in Berlin.

The combination of high-quality data, a successful public-relations campaign and community commitment have facilitated many “success stories” of startups and other developers. Successful app services include:

Berlin Christmas markets: overview of 80 Christmas markets on a map with detailed information.

Berlin bathing places: various bathing facilities (natural bathing places, swimming pools, indoor swimming pools, dog bathing, etc.) are presented on a map and made easy to find.

City Cleaning: interactive map application showcasing cleaning frequency of every street in Berlin.

Broadband expansion: interactive visualization of internet speed offered in Berlin at house block level.

FlatMatch “virtual housing inspection”: offers a three-dimensional view of an apartment and its surroundings. Textures, geometries and sun exposure are reconstituted. 

Extending the database: Since Launching, the Berlin Open Data Portal has grown steadily in terms of available data. Deficits are due mainly to limited knowledge and lack of incentives to publish data within some authorities. The establishment of a central information and training center, comparable to the London Open Data Institute, could help to create more opportunities for the Data Portal.

Improving the currency of data: Different pilot projects already take place in Berlin to record data by sensors, such as, traffic or environmental data. The expansion of the availability of real-time data in the database would represent an incentive for the development of new innovative applications.

Improving data accessibility: The provision of easy-to-use tools and the preparation of administrative data in interactive graphs or "data dashboards" should be increased in the future.

Mainstreaming Open Data in the city administration: The employment of an Open Data representative in each Senate Department, the establishment of an Open Data working group, and the organization of Open Data training courses for the staff will upscale the use of the Open Data Portal in the city administration.

The Open Data landscape is diverse, with start-ups, hobbyists and public administrators representing different interests and working cultures. Regular communication helps them to better know each other and to understand their respective needs and limits. In Berlin, events like hackathons, meetups and regular development meetings in the "OK Labs" of the Open Knowledge Foundation contribute to strengthen the local network of stakeholders.

Successful community projects such as the OpenStreetMap or the WikiData project developed by Wikimedia in Berlin demonstrate that Open Data does not necessarily have to originate from public sources. On the contrary, "Citizen Science" (http://www.buergerschaffenwissen.de/citizen-science/was-ist-citizen-science) exemplifies how data collection by citizens can make a valuable contribution to scientific research. In regards to the importance of data protection, voluntary sharing of information is also an important aspect for building a comprehensive Open Data culture.

While public institutions can sometimes lack the foresight to maximize innovations derived from their own data, Open Data inspires many entrepreneurs to develop new applications. Targeted start-up support from the city government can trigger the development of a creative idea beyond its initial stages. Public administration also benefits from an open data culture where a data-driven administration is characterized by an enhanced exchange of information, a more efficient allocation of resources and evidence-based decision making processes.

- Open Data Berlin - Berlin.de, https://daten.berlin.de 

- Fraunhofer FOKUS im Auftrag der Senatsverwaltung für Wirtschaft, Technologie und Forschung in Berlin, Dr. Wolfgang Both (Hrsg.) Prof. Dr. Ina Schieferdecker (Hrsg.) Kurzfassung der Studie Berliner Open Data-Strategie, Berlin, Januar 2012, http://www.berlin.de/projektzukunft/fileadmin/user_upload/pdf/sonstiges/Berliner_Open_Data_Strategie_2012_kurz.pdf 

- Open Data in der Praxis, Bereitsteller und Anwender offener Daten in Berlin, Benjamin Seibel, Januar 2016, https://www.technologiestiftung-berlin.de/fileadmin/daten/media/publikationen/160128_TSB_OpenDataBerlin.pdf 

On the Map

Map placeholder

Want to know more about this project?

Sebastian Askar
Berlin, Germany

Sebastian Askar

Individual | Referent

Photo gallery

Related case studies

Utrecht Smart Solar Charging project
Award
Utrecht, Netherlands

Utrecht Smart Solar Charging project

The city of Utrecht has capitalised on the high take-up by residents of electric cars and solar panels to develop the Smart Solar Charging project.

Helsinki Climate Street project
Award
Greater Helsinki, Finland

Helsinki Climate Street project

The Climate Street project involves public agencies, residents and businesses working together to convert sustainable ideas into practical, replicable and scalable actions.

Modern facility for transforming cassava into attiéké in the Songon Kassemblé
Award
Abidjan, Ivory Coast

Modern facility for transforming cassava into a...

A pilot project to improve the living conditions of women and young people in the District of Abidjan