DCityDBDocumentationv.doc

3D-Geo-Database for CityGML Version 2.0.1 Documentation April 24th 2009 Content Disclaimer 8 Introduction 9 1.1 Relation to previous version 9 1.2 Features 10 1.3 System and design decisions 12 2 Data modelling 15 2.1 UML diagram of the 3D city model 15 2.1.1 Simplifications compared to CityGML 1.0.0 / 0.4.0 15 Multiplicities, cardinalities and recursions 15 Data type adaptation 16 Project specific classes and class attributes 16 Simplified design of GML geometry classes 16 2.2 UML class diagram 16 Spatial Model 17 .1 Geometric-topological Model 17 .2 Implicit Geometry 19 Appearance Model 19 Thematic model 22 .1 Core Model 22 .2 Building model 24 .3 CityFurniture Model 27 .4 Digital terrain model 28 .5 Generic CityObject Model 29 .6 LandUse Model 30 .7 Transportation Model 31 .8 Vegetation Model 33 .9 WaterBodies Model 34 2.3 Relational database schema 36 2.3.1 Mapping rules, schema conventions 36 Mapping of classes onto tables 36 Explicit declaration of class affiliation 36 2.3.2 Database schema 36 Core Model 36 CITYOBJECT, CITYOBJECT_SEQ 36 CITYMODEL, CITYMODEL_SEQ 37 EXTERNAL_REFERENCE, EXTERNAL_REF_SEQ 37 CITYOBJECTGROUP, GROUP_TO_CITYOBJECT 37 Tables for geometry representation 39 SURFACE_GEOMETRY, SURFACE_GEOMETRY_SEQ 39 IS_XLINK 41 IS_REVERSE 42 Appearance Model 44 APPEARANCE, APPEARANCE_SEQ 44 SURFACE_DATA, APPEAR_TO_SURFACE_DATA 45 TEXTUREPARAM 45 OPENING 50 THEMATIC_SURFACE 50 BUILDING_INSTALLATION 52 ROOM 52 BUILDING_FURNITURE 52 ADDRESS, ADDRESS_TO_BUILDING, and ADDRESS_SEQ 52 CityFurniture Model 53 CITY_FURNITURE 53 Digital Terrain Model 54 RELIEF 54 Generic CityObject Model 55 GENERIC_CITYOBJECT 55 CITYOBJECT_GENERICATTRIB, CITYOBJECT_GENERICATT_SEQ 55 OBJECTCLASS 57 LandUse Model 58 LAND_USE 58 Orthophoto Model 59 ORTHOPHOTO and ORTHOPHOTO_IMP 59 ORTHOPHOTO_RDT 60 ORTHOPHOTO_IMP_RDT 60 ID sequences 60 Transportation Model 61 TRAFFIC_AREA 61 TRANSPORTATION_COMPLEX 61 0 Vegetation Model 62 SOLIT