Book Image

PostGIS Essentials

By : Angel Marquez
Book Image

PostGIS Essentials

By: Angel Marquez

Overview of this book

<p>PostGIS is one of the world's leading spatial databases, created as a geographic extension for PostgreSQL. With it, users are able to manipulate and visualize spatial data incredibly effectively and efficiently.</p> <p>PostGIS Essentials introduces you to the fundamentals of PostGIS, giving you easy access to one of the most popular and powerful spatial databases available today. You will begin by learning how to install and successfully set up PostGIS before covering how to create your first spatial database. The book will then help you to develop your skills further as you will learn how to insert GIS objects as well as how to select and filter GIS queries with clear and practical information. You will then learn how to display GIS data graphically and create effective visualizations. The book concludes with tips, tricks, and techniques to help you optimize PostGIS and improve the performance of your database.</p>
Table of Contents (16 chapters)
PostGIS Essentials
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Hands-on with QGIS


Now that we know the basis of QGIS, we can start to use it to see the data that is stored in our data tables. First, we will take a look inside the tbl_landmarks table; to do this, we will have to perform the following steps:

  1. In the Layers menu, select Add PostGIS Layers:

  2. Now, you can see a window where you will have to specify the necessary data in order to establish a connection with your PostGIS server:

  3. Click on the New button to create a new connection, and you will see the following window:

  4. Fill it with the appropriate data; you can click on the Test Connect button to check that the data is okay. If you are working from your personal machine or think it's secure enough to save your username and password on it, you can check those checkboxes to avoid QGIS from asking you for them every time you connect to the server. Click on the OK button to finish.

  5. You will see a warning dialog box if you choose to store the username and password; click on OK to continue.

  6. Now, you are...