March 2018
Beginner to intermediate
584 pages
14h 31m
English
book
PostGIS Cookbook - Second Edition
by Stephen Vincent Mather, Pedro Wightman, Bborie Park, Thomas Kraft, Mayra Zurbarán, Paolo Corti
Content preview from PostGIS Cookbook - Second Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
How it works...
Connecting to a PostGIS database (see the Adding PostGIS layers – QGIS recipe in this chapter) allows you to utilize the DB Manager plugin. Once DB Manager was enabled, we were able to toggle between the Info, Table, and Preview tabs to efficiently view metadata, tabular data, and data visualization.
Next, we made changes to the database through the query window, running on the table lines of schema chp11 in order to transform the projection. Note the autocomplete feature in the SQL Window, which makes writing queries a breeze.
Changes to the database were made visible in DB Manager by refreshing the database connection.