Postgraduate Course: Spatial Modelling (PGGE11092)
Course Outline
School | School of Geosciences |
College | College of Science and Engineering |
Credit level (Normal year taken) | SCQF Level 11 (Postgraduate) |
Availability | Available to all students |
SCQF Credits | 10 |
ECTS Credits | 5 |
Summary | This course provides a broad introduction to the methods of representing the real world and storing geospatial information. Lectures explain the theory behind storage models and structures, emphasising vector and raster models, with a review of the so-called 2.5-dimensional (layer-based), 3-D and temporal structures. The course introduces database management systems and database methods in the context of GIS and also introduces the concept of formal data modelling. A practical stream provides a robust introduction to SQL using the Oracle relational database management system and an exercise in digital terrain modelling. |
Course description |
Week 1
Representing Reality: An Introduction to Spatial Modelling
Week 2
Formal Data Modelling and Database Management
Practical: Introducing the Oracle Relational Database Management System and SQL
Week 3
Topology & Vector Data Models and Structures
Practical: SQL 2
Week 4
Raster and Hierarchical Data Models and Structures
Practical: SQL 3
Week 5
Adding Dimensions
Practical: Digital Terrain Modelling
|
Entry Requirements (not applicable to Visiting Students)
Pre-requisites |
|
Co-requisites | |
Prohibited Combinations | |
Other requirements | None |
Information for Visiting Students
Pre-requisites | None |
High Demand Course? |
Yes |
Course Delivery Information
Not being delivered |
Learning Outcomes
On completion of this course, the student will be able to:
- understand the range of methods used to store spatial and attribute data in the context of geographical information systems and appreciate the development of these storage models and structures, together with database methods, and the implications of their legacy on current implementations
- understand the concept of database management and its implications
- critically review the available models and technologies, assessing their merits and shortcomings
- understand the concepts of data modelling and be able to deconstruct real-world problems into appropriate models
- use Structured Query Language (SQL) for the manipulation of objects within a relational database management system
|
Reading List
Reading List (Extensive list on Course Outline and Course Web Page)
- Burrough, P.A. and Frank, A.U. (1996) Geographic Objects with Indeterminate Boundaries. Taylor & Francis, London
- Langran, G. (1992) Time in Geographic Information Systems. Taylor & Francis, London
- Laurini, R. and Thompson, D. (1992) Fundamentals of Spatial Information Systems. Academic Press, London
- Shekhar, S. and Chawla, S. (2002) Spatial Databases: A Tour. Prentice Hall.
- Workboys, M.F. and Duckham, M. (2004) GIS: A Computing Perspective. CRC Press, Second Edition
|
Additional Information
Course URL |
http://www.geos.ed.ac.uk/ |
Graduate Attributes and Skills |
Not entered |
Keywords | PGGE11092 Spatial Modelling,Data Modelling,Structured Query Language (SQL),Vector,Raster data mo |
Contacts
Course organiser | Mr Bruce Gittings
Tel: (0131 6)50 2558
Email: |
Course secretary | Mrs Karolina Galera
Tel: (0131 6)50 2572
Email: |
|
|