Mastering the challenges of 3d data management
This presentation is the property of its rightful owner.
Sponsored Links
1 / 19

Mastering the Challenges of 3D Data Management PowerPoint PPT Presentation


  • 114 Views
  • Uploaded on
  • Presentation posted in: General

ORACLE PRODUCT LOGO. Mastering the Challenges of 3D Data Management. Hans Viehmann Product Manager EMEA. Specific challenges for 3D data. large amounts of data (acquisition & storage) expertise and specific tooling required for data processing data models and standards

Download Presentation

Mastering the Challenges of 3D Data Management

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


ORACLE

PRODUCT

LOGO

Mastering the Challenges of3D Data Management

Hans ViehmannProduct Manager EMEA


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


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, ...


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


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


General 3D processing flow

Convert to Geometries

LiDAR Files

LiDAR loader

Query and Clip

TIN tables

Generate TIN

SDO_PC tables

Load point cloud

Query and Clip

Convert to Geometries

Flat files

Point Tables


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)

    • 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


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


Constructing 3D objects

  • Simple Surfaces

    • Face = 3D Polygon

  • Composite Surface

    • Multiple connected faces

  • Simple Solid

    • Closed composite surface

  • Composite Solid

    • Multiple connected simple solids

  • Extrusion

    • Generating solids from 2D polygons


Data models for City Modelling

  • Structures at multiple levels of detail

  • Textures and facades

  • Orthophotos

  • Versioning

  • 3DCityDB (open source data model) is widely used

LOD1 Building

LOD2 Building

LOD3 Building

LOD4 Building

Images courtesy of: Research Center Karlsruhe


City of Berlin – 3D City Model

  • 550000 buildings, reconstructed from 2D cadastre and LIDAR data

  • Textures extracted from oblique aerial photography

  • Stored in 3DCityDB

  • 2012 Oracle Spatial Excellence Award

  • Implemented by TU Berlin

Images courtesy of: TU Berlin, Institute for Geodesy and Geoinformation


Engineering & Construction - Crossrail


Publish KML in the XDB Repository


View in Google Earth


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


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/


  • Login