Cyber City Spatial
Information system ( CC-SIS): A new concept for the management of
3-Databases city models in a hybrid GIS
Armin Gruen, Xinhua
Wnag Institute of Geodesy and Photogrammetry Swiss Federal
Institute of Technology ( ETH) Zurich ETH Honggerberg , CH-8093 Zurich
, Switzerland Tel: 41-1-6333038 Fax: 41-1-631101 E-mail: agruen@geod.ethz.ch, wang@geod.eth.ch
Abstract Usually, two important topics
are involved in 3-Databases urban information systems, i.e. data
acquisition, data management and handling. CyberCity-Modeler (CC-Modeler)
is a methodology and a software for the automatic generation of the
topology of an unstructured 3-Databases point cloud \, which has been
developed in order to generate structured data for city models from
photogrammetrically measured points. This paper aims at reporting about
the performance of CC-Modeler, but will mainly describe the status of the
development of our spatial information system CC-SIS, which is specially
designed for the handling of 3-Databases city data and the integration of
raster images and vector data in terms of a hybrid GIS.
Introduction The generation and management of
3-Databases city models became an important issue in the recent past due
to the increasing demands for a realistic presentation of the real world.
Though different applications may require different data types different
data types and manipulation function, the geometrical information to be
operated on in a 3-Databases city system usually includes tow types of
data : vector data and raster images. An appropriate data model should not
only represent the geometrical information, but also implicitly or
explicitly describe the topological relationship between geometrical
objects . in this case of texture mapping, it also must have the must have
the ability to manipulate raster images. The complexity of spatial objects
and the verity of data types. Especially 3-Databases objects and images as
tow completely different data types, makes it a challenging task develop a
3-Databases spatial model and data structure for the purpose at hand. At
the institute of Geodesy and Photogrammetry, ETH Zurich, two research
topics treated by our group are : (a) the generation of the topology of
3-Databases object by using Photogrammetric tools, and 9b) the
investigation of the data model and the development of a system t manage
the vector data and raster images based on relational data base
technology. A detailed technical description of the former problem is
addressed in Gruen, Wang, 1998 with our CC- Modeler ( CyberCity Modeler ).
Here , we will present a technology for the management of data, which is
implemented in our CC-SIS ( CyberCity Spatial Information system).
CC-Modeler Photogrammetry is an appropriate tool to
provide information about man-made objects, vegetate cover and the like.
Recently, many approaches for automated and semi-automated extraction of
buildings and roads from aerial images have been proposed ( Gruen et al.,
1997) Due to the complexity of natural scenes and the lack of performance
of image understanding algorithms, the fully automated methods cannot
grantee results stable and reliable enough for practical use ( Gruen et al
., 1997). Therefore, we have developed a semi-automated approach, which
gives the human operator strong computational support in order to generate
3-Databases city models from aerial images efficiently.
with CC-Modeler (
CyberCity Modeler ) were present a new method for fitting planar structure
to measured sets of point clouds. In CC- Modeler , the feature
identification and measurement is implemented in manual mode, on an a
Analytical Plotter or a Digital Station. During the data acquisition,
3-Databases points belonging to a single object are coded into two
different types according to their functionality and structure : boundary
points and interior points. CC-Modeler is an automatic topology generator
for 3-Databases objects . the main components of the system are shown in
figure 1. the first obligatory step is preprocessing. Which includes the
checking of the measurement order of the boundary points 9 BP), detection
of redundant points, and determination of the possible groups of faces,
based on sets of\adjacent ( BP) point pairs.
Table 1:
CC-Modeler statistics of projects
Project |
Total No. of Roof units |
Structured
interactively |
Structured
interactively |
Failures |
CPU time (sec) |
Zurich Center |
4729 |
4487 |
240 |
2 |
1493 |
Zuric standelhofen |
553 |
534 |
19 |
0 |
184 |
Orelikon |
7253 |
6971 |
279 |
3 |
2089 |
Melbourne university |
1136 |
1104 |
32 |
0 |
313 |
ETH Hoenggerberg |
172 |
170 |
2 |
0 |
53 |
Dretikon |
298 |
290 |
8 |
0 |
56 |
Regensdorf |
925 |
894 |
30 |
1 |
165 |
Giessen |
4157 |
4117 |
40 |
0 |
1213 |
Firenze center |
1544 |
1509 |
33 |
2 |
504 |
Total |
20767 |
20076 |
683 |
8 |
6070 |
The next step is to build the face model of the 3-Databases object,
i.e. to determine how many faces the 3-Databases object has\, which points
define an exact face and the spatial relations of the faces. This is
implemented through a consistent labeling algorithm by probabilistic
relaxation operations, in which two procedures are involved, the initial
probability determination and the relaxation processing. The result of
consistent labeling is the face definition for every face. Then, least
squares adjustment is performed for all faces simultaneously, fitting the
individual faces in an optimal way to the measured points and considering
the fact that individual points are usually members of more that one face.
This adjustment is amended by observation equations that model orthogonal
constraints of pairs of straight lines between boundary points. The
details of these algorithms are presented in Gruen, Wang, 1998. Finally, a
vector description of 3-Databases objects is obtained, which is
represented in a self-developed data structure ( V3D).
CC- Modeler has been
successfully implemented on workstations ( Sun SPARC) under X Windows and
OSF/ Motif, and has been tested in several projects. The statistics of
those data sets are presented in Table 1. ' Structured automatically "
refers to the number of roof units that CC-Modeler builds successfully
with full automatic processing, and " Structured interactively" refers to
the number of roof units that needed to the manually modified in some
faces. Obviously, the success rate of CC-Modeler's automatic processing is
better that 95% and almost al roof units can be constructed by using the
convenient editing tools. The main reason of CC-Modeler failing to process
an object is that the measured point cloud was incorrectly coded. The main
reasons for editing are measurement errors and ambiguities in topological
relations.
For the visualization and animation of the data sets we
use various software : AutoCAD Micro station, Inventor, and Polytrim.
Figure 2 Shows a view of the city model' Zurich Center " created with
Micro Station, including building, rivers, trees and DTM. For photo
realistic rendering were combine the vector data of the building and the
DTM with images raster data. The raster images are taken from aerial
images. Figure 3 shows the city model of " Tokyo Downtown " with the
result of mapping image data onto the DTM and some walls and roofs.
Data Structure V3D is a hybrid data structure. It not
only models 3-Databases objects, but also combines raster images and
attribute information for each object. The terrain objects are grouped
into four different geomatic object types : Point Objects , Line Objects,
Surface Objects and Body Objects in V3D, each special object is identified
by Type identifier Code ( TIC), referred to as PIC, LIC ,. SIC and BIC,
respectively. Tow data sets are attached to each object type: thematic
data and geometric data. The images data can be attached to the surface
object, body object and DTM object . in fact, the thematic data attributes
are built up in a separate data table. It is linked to the object type
with a related class label. The definition of the thematic data is
user-dependent.
The geometric data set contains the geometric
information of 3-Databases objects, i.e. the information of position,
shape, size, structure definition ,and image index. The diagram in Fig. 4
shows the logical data structure .
Figure 4: the logical data
structures of V3D
For the four object types, four geometrical
elements are designed . i.e. Point, Edge, facet and Entity, Point is the
basic geometric elements in the diagram. The Point can present a point
object. It also can be the begin or end point of an Edge. The edge is a
line segment which is an ordered connection between two points: begin
point and end point. Further, it can be a straight part of a line object
or lie on a facet. The facet is the intermediate geometrical element it is
completely described by the ordered edges that define the border of the
facet. One or more facts can be related to a surface object or Entity
geometrical element. Moreover , facet is related to an image patch. Entity
is the highest level geometrical element, and it can carry shape
information. An entity is completely defined by its bordering facts.
Images data and thematic data are two special data sets. Which are built
up in tow separated data tables. Each facet is always related to an image
patch through a corresponding link.
Once the attribute table is
attached and the TIC is labeled, a geometrical element becomes an object
type . the DTM is treated as a special data type. Which is described by a
series of facets.
Obviously, the topological relationships between
geometrical elements are implicitly defined by the data structure. A point
object is presented by a distinct Point element. The line object is
described by ordered Edges. The surface object is described by the facet
with the informations of image Patches. Similarly, the body object is
described by Entity that are defined by the facets. Thus the topological
relationships between Point and Edges. Edges and Facet, Facet and Entity
are registered by the links between the geometrical elements.
Implementation in A Relational Database In a relational
database the most common object to be manipulated is the relation table.
Other objects such as index, views, sequence, synonyms and data dictionary
are usually used for query and data access. " Table " is the basic storage
structure, which is a two -dimensional matrix consisting of columns and
rows of data elements. Each row in a table contains the information needed
to describe one instance of the entity , each column represents an
attribute of the entity. The data model shown in figure 4 is a logical
model, which can be implemented by relational data base technology. Figure
5 shows the relational model of the V3D data structure.
Each object type is
defined as a table , shown as the upper row. A point type table includes
three terms. The point Identification Code ( PIC) is an identification
code for a point type object. The attribute identification (AID) is coded
the relate an attribute table. Different types of objects may have
different attribute tables. For example the te attribute tables of " tree"
may have different thematic definitions than " pole ". The Name of Point
(NP) is the identification of a geometric point. Which is used to relate
it with a distinct element in a point geometric element. The point table
is the most basic geometrical element table , which defines the coordinate
position of the geometrical points.
The line type table has
similar content as the point type table. The difference is that a line
type object is identified by the Line identification Code ( LIC) which is
not directly linked with the geometric element table Edge, but linked with
an intermediate relational table LIC-NIL and then indexed to the Edge
table. The Edge table defines the geometrical element edge, in which each
edge ( NIL) is described by the beginning point ( BP) and the end point
(EP). The surface type table and body type table have similar terms as the
line type table. For each type of object a distinct identification code (
SIC or BIC) is labeled. . both ISC and BIC are linked with a merging
geometrical element table, Facet and Entity, Facet and Image are defined.
Facet-Entity-Image table has tow links; one is related to the Image table;
the other is related to the NIL-SID table. Image table is a basic table,
which describes all attributes of images, such as athe image name, format,
pixel, Camera parameters, orientation parameters etc. the NIL-SID table is
another intermediate table, which defines the corresponding relationships
between Facet and Edge. Its NIL column is related to the Edge table. The
DTM is treated as a special class, which is related to the NIL-SID table
through an intermediate table DID-SID-image.
Based on the
relational structure shown on the diagram in Figure 5, the query of a
geometrical description of a distinct object type is easily realized. For
example, the query " Select the geometrical description of an object with
the identification code BIC =202", will first index all Facet
identification in the Facet-Entity-Image table by its BIC, and then get
all edge name identification ( NIL ) , Finally index the position
information of structure points with the help of Edge table and Point
table.
The queries of topological relationships are divided into
tow types; relationships between the geometrical elements of an object and
those between objects themselves. The relationships between the
geometrical elements are implicitly defined in the above data structure.
Though the internal topology is not directly supplied, users can flexibly
deduce the relationships, such as joi8jnt, adjacency, left or right, etc.
the queries of topological relationships between objects are not
considered in the above data structure because they are
application-dependent.
Prototype System Based on the above data model
and structure, a spatial information system, CC-SIS, has been successfully
developed and implemented on a workstation ( Sun SPARC ) under X-window,
and ORACLE datable . the seven function units of CC-SIS are shown in the
Figure 6. it can directly handle the data file generated by CC- Modeler
and DXF. The edit function is used for graphic editing, which is to be
developed in the future. The view port, zooming, etc. further, three types
of rendering are also available , wireframe, shading and texture mapping.
The image function supplies the tools for interior orientation of the
images in order to map natural texture form image. An example of this
function is shown in figure. 7.
The manipulation of data
is supplied by the Data function. It includes tow sub-modules; one is used
for the operation on layers ; the other is to input the attributes for the
selected object . the Geo-query function includes tow tools: geometry
query and topology query and topology query. The former is used to query
the separated object by the point, line or entity selection ; the latter
is employed to query topological relationships between different objects .
figure 8 shows the geometric query of CC-SIS . the user can mark an object
( e.g building ) with a cursor . thus triggers and displays the
corresponding attributes an geometrical/topological information. The
operations on a database are defined in the Database function, including
database link and SQL- query. SQL-query is a sub-menu, in which standard
SQL queries are supplied.
Conclusion CC-Modeler is a powerful data
acquisition tool for the generation of 3-D city models. Our experiments
shows, that it is flexble, robust and accurate . in several projects we
have achieved a success rate of better that 95% percent in fully automated
structuring. Remaining problems are indicated and can be solved
interactively. We have developed our own data structure V3D wit interfaces
to a variety of CAD and visualization packages. CC-Modeler cannot only
reconstruct multiple kinds of 3-D objects such as buildings, waterways,
roads, trees, DTM, etc. but also map images onto these objects. This can
be combined with data from general land use, communication systems,
utilities, property and administrative boundaries, etc. to generate a
complete 3-D city model.
Given an efficient method for 3-D data
acquisition, the generation of a powerful 3-D spatial information system
becomes even more mandatory. Our prototype system CC-SIS ( CyberCity
Spatial information system ) has proven to represent a suitable concept
which is worth developing further.
Based on our proprietary V3D
vector data structure, a relational data base has been created. The data
to be operated on can be logically separated into vector data, image and
thematic information. I this paper the focus is on the geometrical part of
the database ( vector data and images. ) our pilot application show that
V3D is a suitable structure for the representation of 3-D objects, images
and thematic data. it is possible the answer most of the questions about
topology, position and shape of objects by means of geometric or SQL
queries.
References
- Gruen, A., Wang, X., 1998, " CC-Modeler: a topology generator for
3-D city models", int. Archives of Photogrammetry and Remote sensing,
Vol. 32, Part 4 , pp 188-196.
- Gruen, A., Baltsavias, E., Hericsson, O., ( eds), 1997. Automated
extraction of a man-made objects form aerial and space images (II).
Procedings of athe Monte Vertia Workshop, May 1997, Brikhause Verlag,
Basel.
|