What is a bundled database schema

The Berlin 3D city model


1 CREATE MANAGE PUBLISH Open Government Days 2014 The Berlin 3D City Model Automated, payment-free provision of complex geospatial data in target group-specific formats

2 Contents Introduction The Berlin 3D City Model Submission of data by 2014 Submission of data from 2014 Summary 2 Open Government Days Munich

3 Introduction Speaker Dr.-Ing. Lutz Ross (virtualcitysystems GmbH) as representative of Karin Teichmann (Berlin Partner) Berlin Partner Business and Technology Promotion Service agency for innovation, settlement, expansion and site security projects virtualcitysystems GmbH Supervision of the technical infrastructure of the Business Location Center (BLC, websites and showroom Berlin Partner ) 3 Open Government Days Munich

4 Contents of the lecture The Berlin 3D city model Development, scope and content Handling of the Berlin 3D data in flux Phase 1: Deliveries to research institutions, cooperation partners Phase 2: Marketing of the 3D data 3D city model shop Phase 3: 3D city model goes open Data data provision solution 3D city model as part of the Open Data Initiative Berlin 4 Open Government Days Munich

5 The Berlin 3D city model Development, use and continuation Current inventory 5 Open Government Days Munich

6 Development of different city models / 3D data in Berlin Architectural model inner city model Potsdamer Platz and the surrounding area Various project-related 3D data From approx. Ideas for merging the 3D data into a 3D city model Implementation of Berlin 3D city model EFRE project I EFRE project II 6 Open Government Days in Munich

7 ERDF project I Combination of architecture model (SenStadtUm) and presentation models (SenWTF) into one overall model Close cooperation between research institutions and companies TU Bonn, TU Berlin, HPI, KIT, 3DGeo, virtualcitysystems Primary result: Area-wide model of the inner S-Bahn ring in LoD1 with individual landmarks in LoD3 and LoD4 7 Open Government Days Munich

8 ERDF project I Secondary results: Further development of CityGML (since 2008 OGC standard, based on AdV profile 3D building model) Development of 3D City Database (open source database scheme) Further development of LandXplorer technology (later sold to Autodesk Inc.) Use of the model: 3D model in Showroom of the BLC Innovative, thematic geomedia products (DVD Berlin3D, Berlin Marathon,) 2007 Publication in Google Earth Newspaper articles and TV reports 8 Open Government Days Munich

9 ERDF Project II comprehensive LoD2 derivation and texturing from oblique aerial images Building reconstruction Berlin in two phases: East Berlin: March 2008-July 2008 West Berlin: November February 2009 Process / specifications Basics: Laser scan and floor plans Method: Semi-automatic derivation with BuildingReconstruction Data format: ESRI Shapefile, CityGML Level -of-Detail: LoD2, generalized number of buildings: Open Government Days Munich

10 Open Government Days Munich

11 Further development Since 2009 only project-related update and further development within the framework of use at Berlin Partner Integration of commercial properties, industry clusters, location information, etc. Berlin Solar Atlas Individual construction projects (Bikini Berlin, BER Airport, O2 Arena) Publication as 3D map application on the Internet, new flights and updates Ca buildings in LoD2 updated All LoD2 buildings newly textured 11 Open Government Days Munich

12 Current inventory Comprehensive textured buildings in LoD2 Approx. 370 special buildings in LoD3 3 buildings in LoD4 (interiors) S-Bahn trunk line, Holocaust memorial and other special objects also recorded street trees in the city center Combined with 2D maps and Google Street View as an economic atlas Berlin published on the Internet: 12 Open Government Days Munich

13 Berlin Economic Atlas 13 Open Government Days Munich

14 Data submission by 2014 Early phase Second phase: 3D city model shop 14 Open Government Days Munich

15 Data delivery Companies, research institutions and associations showed great interest in using the model at an early stage. Conditions for data delivery were subject to multiple changes. CityGML data format as a barrier, delivery as a shape file without textures. Data preparation as a manual process

16 Early interest from 2005 Interested parties: e.g. Games industry (virtual Berlin as a game world), architects / project developers (as an environment model for projects) Navigation industry But: Initially no consensus-based pricing model Discrepancies in pricing between SenWTF and SenStadt 3D model contains ALK data, terrain data, aerial images The accumulated price of these products is for the Interested parties unattractive data submission are limited to submission of the original data to partners and research institutions 16 Open Government Days Munich

17 As of 2008, virtualcitysystems, as the technical operator BLC, takes over the data transfer to partners / research institutions Increasing demand for formats other than CityGML Complex manual conversion processes Inefficient and labor-intensive Development of automatic conversion workflows Resumption of negotiation of a sustainable price model for transfer to companies 17 Open Government Days Munich

18 From 2011: 3D city model shop virtualcitysystems receives the order to market the city model In the period of a few dozen tiles of the city model were purchased. Reasons: Data were no longer up to date Price / kmĀ² too expensive 2014 Cessation of the 3D city model shop and decision to open the 3D City model available free of charge! 18 Open Government Days Munich

19 How did it come about? The Open Data Initiative of the State of Berlin started in the third quarter of 2011. Extract coalition agreement for the 17th legislative period (Berlin): The coalition will continue and expand the State's Open Data Initiative. To this end, it advocates an examination of the extensive disclosure of public data (e.g. geographic information data) while safeguarding personal data protection. 19 Open Government Days Munich

20 How did it come about? Open data is not a legislative initiative, no open data law, no overall decision for the State of Berlin Separate decision / implementation for each department of the administration Department of Geoinformation Decision by State Secretary on June 24, 2013: Implementation of the open data initiative on October 1, 2013 for the official maps and other geographic information products. No Open-Data light 20 Open Government Days Munich

21 How did it come about? SenWTF, or Berlin Partner, as the main user and data holder of the Berlin 3D city model, joins the SenStadtUm position. All LoD2 buildings and the digital surface data collected for updating should be published as open data after the model update has been completed. virtualcitysystems, as the operator of the BLC and the 3D city model, receives the order to develop a deployment solution for 21 Open Government Days in Munich

22 Data submission from 2014 Berlin 3D download portal Terms of use 22 Open Government Days Munich

23 Berlin 3D as Open Data Provision of LoD2 building data from the Berlin 3D city model But how? Download CityGML + textures? with 65GB and insufficient software support for CityGML impractical Download CityGML textures in individual tiles? With over 900 tiles and insufficient software support for CityGML, it is impractical to prepare pre-assembled packages with different formats? Time-consuming and memory-intensive 23 Open Government Days Munich

24 The solution Provision of a download portal Interactive selection of the area, the target format and the content, as well as automated data processing and provision as a download link Additionally for power users, download of the original CityGML data as a ZIP archive Provision of the city model as WFS 24 Open Government Days Munich

25 Berlin 3D download portal 25 Open Government Days Munich

26 Licensing, usage costs State Secretaries' Committee on Administrative Modernization (in the State of Berlin), Decision June 2012: Establishment of a cross-departmental Open Data working group Goal: Development of recommendations / standards for data acquisition, description and provision Different approaches examined, including GeoNutzV2) and Creative Commons Result: Simplification of the conditions of use: Mission statement GeoNutzV Provision and use of online available geodata / products free of payment, e.g. abolition of prices and purchase conditions and publication of the new conditions of use by announcement in the Official Journal of Berlin on (OJ No. 42 /), entry into force of Open Government Days Munich

27 Terms of use Terms of use 1 Uses (1) Geodata and geodata services, including associated metadata, are made available free of charge for all currently known and for all future known commercial and non-commercial purposes, unless otherwise specified by special legal provisions or contractual or statutory rights Third parties do not oppose this. (2) Notwithstanding paragraph 1, fees are charged for the provision of data on machine-readable data carriers. (3) The provided geodata and metadata may in particular 1. be reproduced, printed out, presented, changed, processed and transmitted to third parties; 2. are merged with your own data and data of others and combined to form independent new data records; 3. be integrated into internal and external business processes, products and applications in public and non-public electronic networks. (4) The spatial data services provided may in particular 1. be merged with one's own services and those of others; 2. be integrated into internal and external business processes, products and applications in public and non-public electronic networks. 27 Open Government Days Munich

28 28 Open Government Days Munich Summary

29 Berlin 3D More than Open Data The development of the Berlin 3D city model has significantly influenced the development of the international OGC standard Contributed to the development of the open source database 3DCityDB End users have extensive rights to 29 Open Government Days in Munich