everything.study
11.523

Fundamentals of Spatial Database Management

2-2-2 units · Graduate

Develops technical skills necessary to design, build, and interact with spatial databases using the Structured Query Language (SQL) and its spatial extensions. Provides instruction in writing highly contextual metadata (data biographies). Prepares students to perform database maintenance, modeling, and digitizing tasks, and to critically evaluate and document data sources. Databases are implemented in PostgreSQL and PostGIS; students interface with these using QGIS.

Spring 2003 · Spatial Database Management and Advanced Geographic Information Systems

Topics

  • Metadata and MIT’s Geodata Tool
  • ESRI’s Spatial Database Engine
  • Serving Maps on the Web
  • On-site Visit and Meeting with Client
  • Meeting with Consultant
  • Project Work
  • On-site Work with Client
  • On-Site Project Presentation
  • Challenges, Opportunities, and Next Steps

Readings

  • Worboys, Michael F. GIS: A Computing Perspective. London: Taylor & Francis, 1995. (Paperback). Note: The book appears to have been repackaged in 1998 or 1999, but this appears to be the same book regardless as they have the same ISBN.
    Listed reading
  • Loney, Kevin, and George Koch. Oracle 8i: The Complete Reference. Berkeley: Osborne McGraw-Hill, 2000.
    Listed reading
  • Oracle 8: The Complete Reference. Berkeley: Osborne McGraw-Hill, 1997.
    Listed reading
  • Trimble, Harvey J., Jr., and David Chappell. A Visual Introduction to SQL. New York: John Wiley & Sons, 1989.
    Listed reading
  • Using ArcView Spatial Analyst. Redlands, CA: Environmental Systems Research Institute, 1996.
    Listed reading
  • Using ArcView 3D Analyst. Redlands, CA: Environmental Systems Research Institute, 1998.
    Listed reading

Prerequisites & course information

Prereq: 11.205 or permission of instructor G (Fall; first half of term) Not offered regularly; consult department 2-2-2 units

Sources