3D GEOSPATIAL DATABASE SCHEMA for ISTANBUL 3D CITY MODEL

Abstract

This paper describes the development of 3D database for Istanbul 3D city models. The schema is based on object-relational technology and also called spatially-enhanced relational database management system (SRDBMS). The 3D city models were generated based on LiDAR points cloud with other several typical GIS datasets like terrain, orthophoto, Point of Interests (POIs), and other attribute data. The database is based on PostGIS schema and CityGML schema (3DCityDB). Two major datasets, namely, terrain data (with several formats), and 3D city models were populated in the database. Terrain and attributes data retrieval are based on Web Feature Service (WFS) whereas 3D models were visualized via 3D Tiles format in Cesium platform. Two issues were also highlighted in the paper with respect to 3D attributes linkages and 3D complex objects.