Geoscience Reference
In-Depth Information
Table 2
Format and method of storing solid geometry in Oracle Spatial (Liu
2013
)
Attribute
Value
Description
SDO_GTYE
3008 3D
Solid data
SDO_SRID
Null
No geo-reference
SDO_POINT
Null
No point features
SDO_ELEM_INFO
(1, 1007, 1, 1, 1006, n, 1, 1003, 1,
n, 1003, 1, …)
• (1007,1)— one simple solid
• (1006, n)—one external surface
consisting of n polygons
• (1003,1)—simple polygon with
straight line segments
• n—indicates the start value for the
second polygon in the SDO_
ORDINATE array
SDO_ORDINATE
(X
1
, Y
1
, Z
1
… X
n
, Y
n
, Z
n
, X
1
, Y
1
,
Z
1
, …)
• (X
1
, Y
1
,Z
1
)—The coordinates of
the starting point in the point list
of the first polygon;
• (X
n
, Y
n
,Z
n
)—the coordinates of the
penultimate point in the point list
of the first polygon
• In order to close the polygon, the
last point should be specified
exactly the same as the first one
Preliminary Results
In our case, FME Data Inspector, ArcGIS ArcScene, and GoogleEarth were
used in order to visualise the 3D models created in Oracle Spatial. In our case,
FME Data Inspector, ArcGIS ArcScene, and GoogleEarth were used in order
to visualise the 3D models created in Oracle Spatial. As an example, Fig.
13
depicts visualisation results in GoogleEarth viewer for the case study 6's arch-
building (represented in grey). 3D spatial data can be visualised in Google
Earth after transforming their format into Google Earth KML and converting
the original coordinate system (in our case, Datum 73-IPCC) into WGS 84.
Based on GoogleEarth functionalities, users can navigate GoogleEarth viewer
in several different ways. Also users are allowed to change the view to ground,
street, and terrain level (Google 2013). By double clicking the object's name
in the places window (on the left-hand side), it is possible to zoom into the
selected object and its attributes will pop-up in a small floating window
(Fig.
14
).
In terms of 3D modelling results, we shall refer to case study 6 where more
interesting 3D modelling issues arose. According to the Portuguese cadastral legis-
lation, spaces underneath and above manmade infrastructures belong (in principle)
to the infrastructures' owner(s). In case study 6 there are however exceptions to
the general law above. According to the general rule above, subterranean space
underneath and airspace above the building infrastructure (in yellow dashed-lines,
Fig.
15
) constitute private domain belonging to the owner(s) of the infrastructure.
