1,797
Views
0
CrossRef citations to date
0
Altmetric
Articles

A star-based data structure to store efficiently 3D topography in a database

&
Pages 256-266 | Received 22 Mar 2013, Accepted 19 Jul 2013, Published online: 19 Dec 2013

Figures & data

Figure 1. (a) 2D polygons representing buildings footprints, and their constrained Delaunay triangulation. (b) 3D representation of the same buildings (polyhedra in this case, obtained by extruding the footprints in (a)) and their CDT (for clarity only the tetrahedra inside the polyhedra are shown here, but the whole convex hull in 3D is partitioned into tetrahedra).

Figure 1. (a) 2D polygons representing buildings footprints, and their constrained Delaunay triangulation. (b) 3D representation of the same buildings (polyhedra in this case, obtained by extruding the footprints in (a)) and their CDT (for clarity only the tetrahedra inside the polyhedra are shown here, but the whole convex hull in 3D is partitioned into tetrahedra).

Figure 2. The Schönhardt polyhedron is impossible to tetrahedralize without adding extra vertices.

Figure 2. The Schönhardt polyhedron is impossible to tetrahedralize without adding extra vertices.

Figure 3. The star and the link of a vertex v in 2D (a) and 3D (b).

Figure 3. The star and the link of a vertex v in 2D (a) and 3D (b).

Figure 4. The link of the edge ab in 3D is formed by the bold dashed polyline cde f ghc.

Figure 4. The link of the edge ab in 3D is formed by the bold dashed polyline cde f ghc.

Figure 5. A set of eight vertices yields a tetrahedralization with six tetrahedra. Out of the total 19 edges the six REs are stored (and shown in bold): <1, 3>,<1, 5>,<1, 7>,<2, 4>,<2, 6>,<2, 8>.

Figure 5. A set of eight vertices yields a tetrahedralization with six tetrahedra. Out of the total 19 edges the six REs are stored (and shown in bold): <1, 3>,<1, 5>,<1, 7>,<2, 4>,<2, 6>,<2, 8>.

Table 1. The three tables for the data-set shown in Figure .

Figure 6. Walking in a 2D triangulation, starting from a given triangle to the query point q. In 3D, the principle is the same: the walk is performed from tetrahedron to tetrahedron.

Figure 6. Walking in a 2D triangulation, starting from a given triangle to the query point q. In 3D, the principle is the same: the walk is performed from tetrahedron to tetrahedron.

Figure 7. The UML diagram of the data model for our star-based data structure.

Figure 7. The UML diagram of the data model for our star-based data structure.

Figure 8. (a) Two adjacent 3D features (both triangular prisms) sharing a surface (in grey). (b) The two features tetrahedralized with the seven REs in bold black.

Figure 8. (a) Two adjacent 3D features (both triangular prisms) sharing a surface (in grey). (b) The two features tetrahedralized with the seven REs in bold black.

Figure 9. Part of the footprints of the data-sets (a) campus, (b) kvz, and (c) engelen. In (d) a view on the kvz data-set tetrahedralized; notice that the ‘air’ tetrahedra are not shown.

Figure 9. Part of the footprints of the data-sets (a) campus, (b) kvz, and (c) engelen. In (d) a view on the kvz data-set tetrahedralized; notice that the ‘air’ tetrahedra are not shown.

Table 2. Details concerning the data-sets used for the experiments.

Table 3. Details of the stars.

Table 4. Size of the PostgreSQL/PostGIS tables.

Reprints and Corporate Permissions

Please note: Selecting permissions does not provide access to the full text of the article, please see our help page How do I view content?

To request a reprint or corporate permissions for this article, please click on the relevant link below:

Academic Permissions

Please note: Selecting permissions does not provide access to the full text of the article, please see our help page How do I view content?

Obtain permissions instantly via Rightslink by clicking on the button below:

If you are unable to obtain permissions via Rightslink, please complete and submit this Permissions form. For more information, please visit our Permissions help page.