WATERBOUNDARY_SURFACE The exterior shell of a WaterBody can be differentiated semantically using features of the type _WaterBoundarySurface. These features are stored in the WATERBOUNDARY_SURFACE table and can be distinguished by the OBJECTCLASS_ID attribute: '11' (WaterSurface) '12' (WaterGroundSurface) '13' (WaterClosureSurface) Since every _WaterBoundarySurface object must have at least one associated surface geometry, the foreign keys LODx_SURFACE_ID (with 2 ≤x ≤ 4, no MultiSurface here) are used to realise these relations. Figure 47: WaterBody database schema Sequences Figure 48 lists predefined sequences from which multiple users may generate unique integers for primary keys automatically. Sequences help to coordinate primary keys across multiple rows and tables. For instance, the ID values of the BUILDING table are generated from the CITYOBJECT_SEQ sequence. The sequences are defined to start with 1 and to be incremented by 1 when a sequence number is generated. It is highly recommended to generate ID values for all tables by using the predefined sequences only. The sequence GRID_COVERAGE_RDT_SEQ does not exist in the PostgreSQL version as the corresponding table does not exist. Figure 48: Tables for spatial information and sequences Definition of the CRS for a 3D City Database instance The definition of the CRS of a 3D City Database instance consists of two components: 1) a valid Spatial Reference Identifier (SRID) (EPSG code) and 2) an OGC GML conformant definition identifier for the CRS. Both components are defined during the database setup (see chapter 3.3) and are further stored in the table DATABASE_SRS (see Figure 48). The SRID is an integer value key pointing to spatial reference information within Oracle’s MDSYS.CS_SRS table or PostGIS’ SPATIAL_REF_SYS table. Both DBMSs are shipped with a large number of predefined spatial reference systems. At setup time, the SRID chosen as default value for the 3D City Database instance must already exist in the mentioned tables! The GML conformant CRS definition identifier is used as value for the gml:srsName attribute on GML geometry elements when exporting database contents to CityGML instance
Note: When using the created 3D City Database as a template database for new databases, the search path information is not transferred and thus has to be set again, e.g.: ALTER DATABASE new_citydb_v3 SET search_path TO citydb, citydb_pkg, public; The search path will be updated upon the next login, not within the same session. To change the reference system after setting up the 3D City Database, use the command (see Oracle version for a description of the input parameters): SELECT citydb_pkg.change_schema_srid( 32632, 'urn:ogc:def:crs,crs:EPSG::32632,crs:EPSG::4326', 1); To drop the 3D City Database with all data, execute the DROP_DB.sql script in the same way like CREATE_DB.sql. Simply dropping the schemas ‘citydb’ and ‘citydb_pkg’ in a cascading way will also do the job.
Figure 132: New Column dialog. From the left hand tree click on ADDRESS and then STREET. Click on f(x) button and choose FIRST. As a result the Column's Content should be equal to the column's content illustrated in Figure 132. Repeat the previous step to add HOUSE_NUMBER, and then click on EOL button to add new line and repeat it once again to add CITY. The Column's Content should be equal to the column's content illustrated in Figure 133.
Figure 136: Sample settings for Output. Figure 137: Console logs for a successful export and upload. Export Click on the Export button to start the export process. Look for relevant messages in the console. Figure 137 shows a snapshot of a successful export. (Optional) Change Sharing Settings: Click on the Sharing Settings icon (marked by 4 in Figure 129) to open the Sharing Settings dialog (Figure 138). Change the Visibility Option (marked by 1 in Figure 138) from Private - Only the people listed below can access to Anyone who has the link can view. Press the OK button. Click on the Link Copy icon (marked by 3 in Figure 129) to copy the link of your uploaded spreadsheet into the clipboard. Use a web-browser to see the link.