You are here:GeoTux»Geo-Blogs»Geographic databases»Tutorial: Introduction to the DE-9IM in PostGIS


Invitados: 75
Usuarios registrados: 3271
Usuarios en línea:
Registrados hoy:



Blogs and News:
Recibe las actualizaciones en Geo-Noticias y Geo-Blogs

Get them by e-mail
Recibir Geo-Noticias y Geo-Blogs por e-mail

¿What is this about?

Saturday, 14 May 2011 06:00

Tutorial: Introduction to the DE-9IM in PostGIS

Written by  German Carrillo
Rate this item
(0 votes)

I have written an introductory tutorial of the Dimensionally Extended 9-Intersection Model (DE-9IM) in PostGIS for a Qualitative Spatial Knowledge class. I share it in this post.

The tutorial comprises the next sections:


1. Connecting pgAdmin to the server
2. Creating your spatial database
3. Introducing PostgreSQL databases
4. Introducing PostGIS
5. Creating tables
6. Adding spatial capabilities to the table
7. Adding spatial data to the table
8. Create line and polygon data
9. Displaying your spatial data (Optional step)
10. Topological predicates (from DE-9IM)
10.a. The DE-9IM matrix
11. Spatial operators (Getting new geometries)
12. Creating spatial tables from spatial operators
13. Using topological predicates in WHERE clauses

The tutorial uses the PostGIS-viewer plug-in for displaying the geometries in pgAdmin (but it is optional):

PostGIS viewer plug-in

Download the tutorial: Descargar tutorial

License: This tutorial is under license "Attribution 2.5 Colombia", look it at:



Last modified on Monday, 27 February 2012 23:13

Add comment

Security code


On-line users