Spatial Databases

Catalog description

Offers students an opportunity to develop skills in acquiring and building spatial data and maintaining spatial databases. Emphasizes Personal, Workgroup, and Enterprise ArcSDE geodatabases, topology, and versioned editing. Analyzes fundamental theoretical knowledge about information systems and the unique demands created by geographic information. Material includes data modeling and knowledge representation for spatial data, database schemas and models, and architectural principles for GIS. Students use database documentation (metadata) and SQL tools to query and update database attributes. Requires a final project to create a complete geodatabase representative of a spatial database used to support a real-world application. Software: ArcGIS Desktop Advanced; ArcSDE/Microsoft SQL Server enterprise geodatabase; OSQL application to query and create data in a Microsoft SQL Server database.