[GIS] Getting started with PostGIS

Question

This question's answers are a community effort. Edit existing answers to improve this post. It is not currently accepting new answers or interactions.

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?

Answer 1

This question has been converted to Community Wiki and wiki locked because it is an example of a question that seeks a list of answers and appears to be popular enough to protect it from closure. It should be treated as a special case and should not be viewed as the type of question that is encouraged on this, or any Stack Exchange site, but if you wish to contribute more content to it then feel free to do so by editing this answer.

---

A good start can be the PostGIS Manual edited by Paul Ramsey. 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.

Some starting points to consider:

• PostGIS in Action (Second Edition) should be your first resource

• Materials from BostonGIS webpage

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