As with traditional databases, a spatial database can only be as effective and functional as the quality and management of the data. A spatial database, however, also has additional issues that relates to its spatial character. Our course will consider relational-database structure, as well as the needs of spatial analysis to provide you with a foundation for your own spatial database development. You will develop a database and perform the kinds of spatial analysis that demonstrates why GIS is so powerful.
Topics
• GIS software package review
• Positional accuracy, scale and projection
• Introduce relational tabular structures
• Design relational structures
• Structure the spatial analysis database
• Data storage, content, source and age
• Repair flawed data structures
• Conduct a spatial analysis
• Conduct a logical analysis with Structured Query Language (SQL)
Course Participants Appreciate
• Working with access in the GIS environment to realize greater power over the data
• Applying what they learned to real-life scenarios and examples
• Switching between databases: Excel or Access to GIS
• Integrating Access with GIS software
• The "selection" analyst exercises
• Managing databases
• Lab work
• Logic-base site selection analysis using tabular data
|