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.