This is a companion module to SDEV4004: Geographic Information Systems . Whereas it is not essential that students take both modules, they do compliment each other.
|Google Maps||Open source software (OpenLayers) and open source data (OpenStreetMap)|
Course Day Time Room DT249 Wednesday 6.30-9.30 Lab A306 Annex DT211,DT228 Thursday, 12.00-13.00 Lectures 3-023 Annex DT211,DT228 Friday, 11.00-12.00 Lab A117 Annex DT211,DT228 Friday, 12.00-13.00 Lectures A117 (or G-027) Annex
Please note that the Ordnance Survey maps used on this course are only for academic use. It is a violation of the license to use these maps for any purpose outside of this course.
Lecture 0 Introduction to the course
Lecture 1 Based on Chapter 3 of Spatial Databases: A Tour
Lecture 2 Spatial Joins, Spatial databases, OGC, Themes, Indexing, Spatial Database Architecture, PostGIS
Lecture 3 More PostGIS, Networks, Accuracy. See OSI accuracy data
Lecture 4 Spatial Models, Object Orientation
Lecture 5 More on Spatial Models, See OSI PRIME-2
Lecture 6 Dijkstra’s Shortest Path, Routing, and Location Based Services
Lecture 7 Introduction to R
Lecture 8 Moran's I
Lab0 :( PDF ) : Installation of software.
Lab1 :( PDF ) : SQL revision.
Lab2 :( PDF ) : Studying Spatial Operations
Lab3 :( PDF ) : Studying Spatial Predicates
Lab4 :( PDF ) : Using Map Data
Lab5 :( PDF ) : PL/pgSQL and more SQL
Lab6 :( PDF ) : Install and run pgRouting
Lab7 : PostGIS20 Topology
Lab8 :( PDF ) Introduction to R Regression, Correlation, and Kmeans
Lab9 :( PDF ) Maps and pie charts
Lab10 Moran's I and Local Moran's in R. This zip file contains the Map1 and Map2 data
Lab11 :( PDF ) Geographically Weighted Regression
It is important that you read the supporting technical documents The technical documents include:
OGCs Specification for Simple Features for SQL and the PostGIS Manual
OpenGIS Web Map Service (WMS)
OpenGIS Web Feature Service (WFS)
OpenGIS Web Processing Service (WPS)
GeoDirectory Technical Guide
EPSG Geodetic Parameter Dataset
You could try the examples from Boston Geographic Information SystemsPlease read the PostGIS 1.5 Manual and OGC standard on which PostGIS is based.
Much of the theoretical content of this course was drawn from:
Spatial Database a Tour by Shashi Shekhar and Sanjay Chawla
Spatial Databases: With Application to GIS by Philippe Rigaux, Michel Scholl, Agnes Voisard
Sample GIS projects:
Here are some sample final year projects that used spatial databases: Sample1, Sample2, Sample3. Sample4