Top products from r/QGIS
We found 3 product mentions on r/QGIS. We ranked the 2 resulting products by number of redditors who mentioned them. Here are the top 20.
We found 3 product mentions on r/QGIS. We ranked the 2 resulting products by number of redditors who mentioned them. Here are the top 20.
You'll need to learn PostgreSQL first. (You probably already know that PostGIS is an extension of PostgreSQL). You will need to get an instance of PostgreSQL running, and then create the database, users/roles, schemas, tables and views you want for your project, like you would with any other RDBMS. It's relatively straightforward to use PostGIS after that. The extension adds a few new field data types (geometry and geography) which can store spatial data features. It also adds a lot of new functions that operate on spatial data. These are what you use to do spatial queries. You can see the full list in chapter 8 of the PostGIS documentation:
​
Chapter 8. PostGIS Special Functions Index
​
When your database is set up, you'll need to learn how to add data spatial data to a PostGIS database. There are ways to do that with some tools that ship with PostGIS installations. You can also do it through QGIS. I would suggest, after you're comfortable with PostgreSQL, going through the PostGIS documentation itself. There is also a book that you could check out: PostGIS in Action.
​
Finally, I would suggest taking very good notes. Write down the SQL commands that you use to every step along the way to build up the database and keep a record of the SQL that you use to query spatial data. I still refer back to my original notes every time I set up a new PostGIS database.
I have not read the book, but you can get a pretty good idea of the content from amazon.com with the Look Inside https://www.amazon.com/dp/0998547743/