Spatial Databases and
Geographic Information Systems

CSC 543 (901 & 910)

Marcus Schaefer

Latest additions

Final paper requirements are online

Homeworks and Examples

Assignments will be available through this webpage. Written homeworks are due at the beginning of class for in-class students (Section 901), and by midnight for online students (Section 910).  Late homeworks will not be accepted, but the lowest homework score will be dropped.



hw1 4/7
hw2 4/14
hw3 4/22
hw4 4/28
hw5 5/12
hw6 5/19
final paper 6/9
hw7 5/26
hw8 6/2
Notes and Code

Week 1: Intro, GoogleMapAPI
Examples: BasicMap (GMAP2, GLatLng), Marker (GMarker, GEvent), geodecode, geodecode2 (GClientGeocoder), distance (Haversine formula)

Week 2: Representation, Spatial ER Design, Maps

Week 3: Spatial Networks, How to get SQLDeveloper and set up your Oracle Account

Employee Tree
CTA (with geometry)

Week 4: OracleNetworkModel.pdf, LogicalModels.pdf, OracleSpatial.pdf

CTA as spatial network
My world

Week 5:  OracleSpatial2.pdf, Constraint Databases
constraint database

Week 7: Computational Geometry

Week 8: Computational Geometry, CG for SDBMS

Week 9: SAMS

Week 10: SAMS in Oracle, Query Processing

Questions and Answers

There is a page with useful links.


Classes and office hours

The in-class section meets Tu 5:45pm-9:00pm, Lewis 1009. This course is COL/OL.

Office hours are Tu 4-5:30pm. and MW 10:55-11:40am.

During that time you can find me in the CS&TC building, room 749.
If you want to set up an appointment at another time, or simply ask a question, 
send email to


Required text: Spatial Databases with Application to GIS, by Philippe Rigaux, Michel Scholl, Agnes Voisard; Morgan Kaufman, 2001.


The following is a very rough schedule, and we might depart from it.

Week 1 Introduction to Spatial Databases
Week 2 Representation of Geometric Data
Week 3/4 Logical Models and Query Languages

Week 5

Constraint Data Model
Week 6/7 Computational Geometry
Week 8 Spatial Access Method
Week 9 Query Processing
Week 10

Advanced topics (Commercial Systems, Trends)

 Official class syllabus.

Grades and exams

Homework, quizzes: 40%, Midterm: 30%, Final (project): 30%. I will use the following grading scheme:

Grade Percentage
A 95-100
A- 90-95
B+ 87-90
B 83-87
B- 80-83
C+ 77-80
C 73-77
C- 70-73
D+ 65-70
D 60-65
F <60

Throughout the quarter there will be extra credit problems; extra credit does not directly make up for points lost on homeworks or exams; instead it is added in with a weight to the final grade (i.e. not doing extra credit won't harm you, but doing it can move you up).

The midterm and final exams for the in-class section will take place during class. No make-up exams.

General Policies

Academic Honesty

The course adheres to the university Academic Integrity Policy, the following is an excerpt from the policy:

Cheating: Cheating is any action that violates university norms or instructor's guidelines for the preparation and submission of assignments. This includes but is not limited to unauthorized access to examination materials prior to the examination itself, use or possession of unauthorized materials during the examination or quiz; having someone take an examination in one's place-copying from another student; unauthorized assistance to another student; or acceptance of such assistance.

Plagiarism: Plagiarism is a major form of academic dishonesty involving the presentation of the work of another as one's own. Plagiarism includes but is not limited to the following:

Complicity: Complicity is any intentional attempt to facilitate any of the violations described above. This includes but is not limited to allowing another student to copy from a paper or test document; providing any kind of material—including one’s research, data, or writing—to another student if one believes it might be misrepresented to a teacher or university official; providing information about or answers to test questions.

A charge of cheating and/or plagiarism is always a serious matter.  If proven, it can result in an automatic F in the course and, in case of a repeated violation, possible expulsion.

For homework this means that while you can talk to other students about your homework, you cannot exchange any written materials or computer files. Any work you submit with your name on it, needs to have been done by yourself. If you do use someone else's work, you need to clearly mark this by placing quotations within quotation marks and citing any references you use. If you have questions on proper citation, you can visit DePaul's Writing Center.

Using materials prepared for other purposes (e.g., another course or work) needs the course instructor's prior permission for use.


An incomplete grade is given only for an exceptional reason such as a death in the family, a serious illness, etc. Any such reason must be documented. Any incomplete request must be made at least two weeks before the final, and approved by the Dean of CDM. Any consequences resulting from a poor grade for the course will not be considered as valid reasons for such a request.

Marcus Schaefer
Last updated: March 23rd, 2009.