Transcript 3D Data Management - Geospatial World Forum

1
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
ORACLE
PRODUCT
LOGO
Mastering the Challenges of
3D Data Management
2
Hans Viehmann
Product Manager EMEA
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Specific challenges for 3D data
• large amounts of data (acquisition & storage)
• expertise and specific tooling required for data
processing
• data models and standards
• adequate visualization tools
• data dissemination
3
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
How do we fit in?
• Data Storage
• Data Lifecycle
Management
• Data Analysis
• for all variations of
spatial data
• Vector, Raster, Point
Clouds, TINs,
Networks, Topologies,
...
4
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Visualization
Storage
Capture
Data
Analysis
Why use a database?!
•
Moving Spatial data into IT infrastructure allows to
– Lower data management cost
– Simplify application development
– Integrate with other enterprise data
•
Enable development teams to focus on business context, not infrastructure
services
– Database and Application Server manage deployment infrastructure
• Security
• Scalability
• Standards Compliance
• Load Balancing • Failover
• HW/SW Dependencies
– Support multiple application models with common data model
• Java
• GML
• Future …
• .Net
• Web Services/SOA
5
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Data acquisition in 3D
• large volumes of point data acquired by sensors
– LIDAR (Light Detection and Ranging)
– Seismic sensors
• millions of points to model a scene
• data type to efficiently manage this data
– SDO_PC: can handle billions of points
• Triangulated Irregular Network: create surfaces
from point data sets
– SDO_TIN: scalable storage
6
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
General 3D processing flow
LiDAR Files
Convert to
Geometries
LiDAR loader
Query and Clip
SDO_PC tables
Generate TIN
Load point
cloud
Flat files
7
Point Tables
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
TIN tables
Query and Clip
Convert to
Geometries
Data loading using libLAS
• available from http://liblas.org/
• for Windows, download and install pre-build binaries in the OSGeo4W
package http://trac.osgeo.org/osgeo4w/
– A packaging of a number of open source tools: libraries, desktop GIS (Quantum,
Grass, …), servers (UMN Mapserver, …)
• main tools (see http://liblas.org/docs.html for details)
–
–
–
–
–
8
lasinfo = returns information about a LAS file
las2oci = loads a LAS file into Oracle
las2las = copy and transform a LAS file
las2txt = converts a LAS file to a text format
txt2las = the reverse
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Management of 3D data
• correct, integral usage of height information („z“)
– 3D indexing and query
– coordinate system support
• ability to model 3D objects
– points, lines, polygons with „z“
– solids, surfaces
– point clouds
• need for higher-level data models
– eg. support for CityGML data model
9
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Constructing 3D objects
• Simple Surfaces
– Face = 3D Polygon
• Composite Surface
– Multiple connected faces
• Simple Solid
– Closed composite
surface
• Composite Solid
– Multiple connected
simple solids
10
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
• Extrusion
– Generating solids from
2D polygons
Data models for City Modelling
3DCityDB (open source data model) is widely used
LOD1 Building
•
•
•
•
11
LOD2 Building
LOD3 Building
LOD4 Building
Structures at multiple levels of detail
Textures and facades
Orthophotos
Versioning
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Images courtesy of: Research Center Karlsruhe
City of Berlin – 3D City Model
Implemented by TU Berlin
• 550000 buildings,
reconstructed from
2D cadastre and
LIDAR data
• Textures extracted
from oblique aerial
photography
• Stored in 3DCityDB
• 2012 Oracle Spatial
Excellence Award
12
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Images courtesy of: TU Berlin, Institute for Geodesy and Geoinformation
Engineering & Construction - Crossrail
13
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Publish KML in the XDB Repository
14
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
View in Google Earth
15
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Summary
• integrated storage and management of all relevant data
types
• scalability to huge amounts of data and large numbers of
users
• comprehensive tooling and partner solution portfolio
• leveraging key features of Oracle Database
16
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upcoming Events
• Oracle Spatial and Graph Users Conference 2013
• Washington, DC, May 22
• in conjunction with Location Intelligence 2013, May 21
• new: attend by Webcast, „live“ or „on-demand“
• see http://www.locationintelligence.net/dc/registration/
17
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
18
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
19
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.