Spatial Databases : DT249, DT211, DT228, Semester 2, and MSc 2015-16

Lecturer: Pat Browne

School of Computing, DIT Kevin Street

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)

In recent years there has been a tremendous growth in the use of geo-spatial data at personal, organizational, national and international levels. The focus of spatial data has moved beyond its traditional home in the spatial sciences to occupy a central role in the information society. Open initiatives, such as Open Street Map (OSM) and GeoNames ,Open Post Codes are introducing new approaches to map sharing, promoting the potential of spatial information to a wider audience. There are many new players, users, and technologies on the scene. Google Maps (G1, G2, G3) is a major application that allows us to find almost any location that we want. The web standards body (W3C) actively contribute to the increased growth in the use of spatial information. GIS is a major component of e-government and can be used in developing public policy and planning . The range of services, information, and initiatives is truly enormous. Click on the following links to get some idea of how much spatial data is used to manage our country. Biodiversity 1 ,Open Post Codes, Biodiversity 2, Ask-about-Ireland ( Map1, Map2 , Map3 , Map4), Health1 , Health2 , Health3 , School Maps , Genealogy , Marine , Historical Maps , Groundwater Maps , Central Statistics Office (CSO), Value of CSO data , Land Registration, Archeology, Anthropology, GeoDirectory Map, Geocoding: Loc8Code , GeoDirectory Glossary, GeoDirectory usage, Emergency Planning , Agriculture, Forestry, Geology , Environmental Protection , Local Authority 1 , Local Authority 2 , communications and energy , national user communities, European Standards , and Spatial Strategies . Several studies have been carried out to measure the economic value of spatial data (e.g. Australia and The Netherlands ). Spatial systems can be used for Location Based Decision Support (e.g. flood management ).

This course focuses on how spatial databases can be used as a major component in applications such as those listed above. We will study the popular free to use Google Maps (see API). Will will also use an open source equivalent to Google Maps based on GeoServer and OpenLayers . This open source approach allows us to provide Web Feature Services (WFS), simple client side programming can use JavaScript (e.g. distance calculation), Web Map Services ( WMS), and Web Processing Services ( WPS ) from the OGC . For our database, we use PostgreSQL with PostGIS spatial extensions. Other database extensions used include: routing , data mining , spatial data mining and statistical functions . Where possible we will use open source software and open source data.


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

UPDATE 29-Jan-2016: Lab0 focuses on installation for Windows 7. There is some advice for Windows 8+ and Mac users.

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

Technical Documents

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 Systems

Please 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

Useful books