Advertisement

Database Design for High-Resolution LIDAR Topography Data

  • Viswanath Nandigam
  • Chaitan Baru
  • Christopher Crosby
Part of the Lecture Notes in Computer Science book series (LNCS, volume 6187)

Abstract

The advent of high-resolution mapping technologies such as airborne Light Detection and Ranging (LIDAR) has revolutionized the study of processes acting on the earth’s surface. However, the massive volumes of data produced by LIDAR technology pose significant technical challenges in terms of the management and web-based distribution of these datasets. This paper provides a case study in the use of relational database technology for serving large airborne LIDAR “point cloud” datasets, as part of the National Science Foundation funded OpenTopography facility. We have experimented with the use of spatial extensions in the database as well as implementation solutions from a single partition database on a supercomputer resource to a multi-partition implementation on a shared-nothing commodity cluster for management of these terabyte scale datasets. We also describe future directions being pursued to support binary data formats and for scaling to larger system configurations.

Keywords

Lidar Data Spatial Index Point Cloud Data Spatial Query Query Window 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Carter, W.E., Shrestha, R.L., Tuell, G., Bloomquist, D., Sartori, M.: Airborne Laser Swath Mapping Shines New Light on Earth’s Topography. Eos, Transactions, American Geophysical Union 82, 549–550, 555 (2001)CrossRefGoogle Scholar
  2. 2.
    Sallenger, A.H., Krabill, W., Swift, R., Brock, J., List, J., Hansen, M., Holman, R.A., Manizade, S., Sontag, J., Meredith, A., Morgan, K., Yunkel, J.K., Frederick, E., Stockdon, H.: Evaluation of airborne scanning lidar for coastal change applications. J. Coastal Research 19(1), 125–133 (2003)Google Scholar
  3. 3.
    Prentice, C.S., Crosby, C.J., Whitehill, C.S., Arrowsmith, J.R., Furlong, K.P., Phillips, D.A.: Illuminating Northern California Active Faults. Eos 90(7), 55–56 (2009)CrossRefGoogle Scholar
  4. 4.
    Keller, R., Seber, D., Sinha, A.K., Baru, C.: The Geosciences Network (GEON): one step towards building cyberinfrastructure for the geosciences,European Geophysical Union, Vienna (November 2004), http://www.geongrid.org
  5. 5.
    Carter, W.E., Shrestha, R., Slatton, K.C.: Geodetic Laser Scanning. Physics Today 60(12), 41–47 (2007)CrossRefGoogle Scholar
  6. 6.
    American Society for Photogrammetry & Remote Sensing, LAS 1.3 Specification, http://www.asprs.org/society/committees/standards/lidar_exchange_format.html
  7. 7.
    Crosby, C.J., Nandigam, V., Arrowsmith, J.R., Blair, J.L.: Visualization of High-Resolution LiDAR Topography in Google Earth. In: American Geophysical Union, Fall Meeting 2009, abstract IN33A-1034 (2009)Google Scholar
  8. 8.
    Northern San Andreas Dataset, OpenTopography Facility, http://www.opentopography.org/data
  9. 9.
    Snyder, J.P.: Map Projections - A Working Manual. U.S. Geological Survey Professional Paper 1395. United States Government Printing Office, Washington, D.C (1987)Google Scholar
  10. 10.
    USGS National Mapping Program Technical Instructions, Standards for Digital Orthophotos: http://rockyweb.cr.usgs.gov/nmpstds/acrodocs/doq/2DOQ1296.PDF
  11. 11.
    DB2 Spatial Extender for Linux, UNIX and Windows, http://www-01.ibm.com/software/data/spatial/db2spatial/
  12. 12.
    Adler, D.W.: DB2 Spatial Extender - Spatial data within the RDBMS. In: Proceedings of the 27th International Conference on Very Large Data Bases, September 11-14, pp. 687–690 (2001)Google Scholar
  13. 13.
    DB2 Spatial Extender User’s Guide and Reference, ftp://ftp.software.ibm.com/ps/products/db2/info/vr8/pdf/letter/db2sbe80.pdf
  14. 14.
    Personal communications with David Adler, IBM Spatial Database TechnologyGoogle Scholar
  15. 15.
  16. 16.
  17. 17.

Copyright information

© Springer-Verlag Berlin Heidelberg 2010

Authors and Affiliations

  • Viswanath Nandigam
    • 1
  • Chaitan Baru
    • 1
  • Christopher Crosby
    • 1
  1. 1.San Diego Supercomputer CenterUniversity of California San Diego 

Personalised recommendations