Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have been reading a lot about PostGIS, but I am struggling to find a good beginner's guide.

Which tutorials/books do you recommend?

share|improve this question
up vote 41 down vote accepted

Boundless' Introduction to PostGIS

Boundless (formerly opengeo) has a very very good workshop with a lot of exercises on the PostGIS database. I would start with this one.

share|improve this answer
    
This is GREAT. Just what I was looking for. Thank you. – relima Nov 6 '10 at 17:04
    
Excellent Tutorial – ziggy yesterday

Some starting points to consider:

Also, for general introduction to PostgreSQL I quite enjoyed 'Beginning Databases with PostreSQL' book by Matthew & Stones.

share|improve this answer
    
The link to "Introduction to an Open Source Geostack" is broken. – drunkenwagoner May 15 '14 at 0:30
    
@drunkenwagoner Thanks - it has been corrected. – radek May 15 '14 at 7:11
    
Thanks for an update Nathan! – radek Jun 10 '15 at 7:21

My way to find PostGIS was http://bostongis.org/?content_name=postgis_tut01#20

there is three parts of the tutorial. I really like it.

Then I have to mention: http://postgisonline.org

I have tried to build a way of trying spatial SQL queries online. There are a very few tutorials there: http://postgisonline.org/tutorials

anyone can write a tutorial and use it through the site. Look at http://postgisonline.org/doc There is still a lot to do with the site but there is not time enough. Anyone willing to contribute or give comments or ideas are very welcome.

/Nicklas

share|improve this answer

Take a look at Portable GIS:

provide beginners with a ready-installed and configured stack of open source GIS tools that would run in windows without the need for emulation or a live cdemulation or a live cd

i.e. You can have it up and running on a USB stick. Very handy for workplace environments.

It has on it:
PostgreSQL (version 8.4)/Postgis (version 1.4)

share|improve this answer

A good start can be the PostGIS Manual edited by Paul Ramsey.

document download URL: http://www.geoconnections.org/developersCorner/devCorner_devNetwork/meetings/2002.05.30/postgis.pdf

share|improve this answer
4  
The main site offers a more up-to-date version, postgis.org/docs – Paul Ramsey Nov 6 '10 at 5:40
1  
The url of today is postgis.net/documentation instead – Nicklas Avén May 15 '14 at 5:21

A course on spatial databases from Dublin Institute of Technology http://www.comp.dit.ie/pbrowne/Spatial%20Databases%20SDEV4005/Spatial%20Databases%20SDEV4005.htm

share|improve this answer

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

The PostGIS Wiki has list of tutorials as well. http://trac.osgeo.org/postgis/wiki/UsersWikiTutorials

share|improve this answer

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

Since this year (2014), we've got the excellent "PostGIS Cookbook" from Packt publishing [Paolo Corti, Stephen Vincent Mather, Thomas J Kraft, Bborie Park]

Here's the link: http://www.packtpub.com/postgis-to-store-organize-manipulate-analyze-spatial-data-cookbook/book

A lot of cases are explained with working instructions.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.