85

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?

locked by PolyGeo Oct 23 '17 at 6:06

This question's answers are a collaborative effort: if you see something that can be improved, just edit the answer to improve it! No additional answers can be added here

Read more about locked posts here.

56

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.


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.

(Update) - Workshops are available on the Boundless Connect site. You will find them by clicking Learn then Boundless Suite.

  • This is GREAT. Just what I was looking for. Thank you. – relima Nov 6 '10 at 17:04
  • Unfortunately it seems to be bitrotting. In the first paragraph "This workshop uses OpenGeo Suite" is a dead link. – Mateusz Konieczny Jun 23 '16 at 13:57
  • @MateuszKonieczny I contacted them multiple times for the DL link as well with no response. Good thing you can find it elsewhere! – GISKid Jun 27 '16 at 18:40
  • @GISKid, yes there was no response also to my message that I send to them :( – Mateusz Konieczny Jun 27 '16 at 19:32
31

Some starting points to consider:

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

  • The link to "Introduction to an Open Source Geostack" is broken. – drunkenwagoner May 15 '14 at 0:30
12

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

10

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)

7

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

7

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

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.

3

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

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.

3

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.

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