Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Mastering Geospatial Development with QGIS 3.x An in-depth guide to becoming proficient in spatial data analysis using QGIS 3.4 and 3.6 with Python

Product type Paperback

Published in Mar 2019

Publisher Packt

ISBN-13 9781788999892

Length 466 pages

Edition 3rd Edition

Languages

Python

Tools

QGIS

Concepts

Data Analysis

Authors (6):

Luigi Pirelli

Richard Smith Jr., GISP

Kurt Menke, GISP

Shammunul Islam

John Van Hoesen, GISP

Simon Miles

+2 more

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Introduction FREE CHAPTER

2. A Refreshing Look at QGIS

3. Section 2: Getting Started

4. Styling Raster and Vector Data

5. Creating Spatial Databases

6. Preparing Vector Data for Processing

7. Preparing Raster Data for Processing

8. Section 3: Diving Deeper

9. Advanced Data Creation and Editing

10. Advanced Data Visualization

11. Section 4: Becoming a Master

12. The Processing Toolbox

13. Automating Workflows with the Graphical Modeler

14. Creating QGIS Plugins with PyQGIS and Problem Solving

15. PyQGIS Scripting

16. Other Books You May Enjoy

Leave a review - let other readers know what you think

Creating queries and views

Unfortunately, in QGIS 3.2, the functionality to run SQL queries against GeoPakages has not been fully developed as of yet in the DBManager. To carry on exploring SQL queries, we are going to focus on SpatiaLite. To do this, we first need to connect to a SpatiaLite database, which can be found in your Chapter 3, Creating Spatial Databases, samples download.

In the Browser panel tab, right-click on SpatiaLite and choose New Connection. Navigate to open_data.sqlite from the Chapter 3, Creating Spatial Databases, samples.

Once connected, you can expand the open_data database and see the layers and tables stored within it.

Using select statements

Open the DBManager (Database | DBManager...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (6)

Islam

Shammunul Islam is a consulting spatial data scientist at the Institute of Remote Sensing, Jahangirnagar University, and a senior consultant at ERI, Bangladesh. He develops applications for automating geospatial and statistical analysis in different domains such as in the fields of the environment, climate, and socio-economy. He also consults as a survey statistician and provides corporate training on data science to businesses. He holds an MA in Climate and Society from Columbia University, an MA in development studies, and a BSc in statistics.

See other products by Islam

Miles

Simon Miles is a GIS developer working for the Royal Borough of Windsor and Maidenhead, and has been working in the GIS industry since 2003. He always works using open source technologies. His main kit includes QGIS, PostGIS, Python, GDAL, Leaflet, JavaScript, and PHP. His main focus is on digital delivery/transformation, chiefly through the consolidation of data, applications, and legacy systems, and replacing these with APIs and web applications. In 2013, He helped to establish the UK QGIS user group, which holds regional meetings two or three times a year.

See other products by Miles

Van Hoesen, GISP

John Van Hoesen, GISP, is an associate professor of geology and environmental studies at Green Mountain College in rural west-central Vermont, USA. He has an MS and a Ph.D. in geology from the University of Nevada, Las Vegas. He is a certified GISP with a broad background in the geosciences and has used some flavor of GIS to evaluate and explore geological processes and environmental issues. John has taught graduate, undergraduate, and continuing education courses using some variants of FOSS GIS since 2003.

See other products by Van Hoesen, GISP

Pirelli

Luigi Pirelli is a QGIS developer and software analyst with a degree in computer science from Bari University. He has worked in the Satellite Ground Segment and Direct Ingestion for the European Space Agency. He is involved in GFOSS world, contributing in QGIS, GRASS, & MapServer core, and developing QGIS plugins. Luigi is the founder of the OSGEO Italian local GFOSS chapter. He has taught PyQGIS, delivered training from basic to advanced levels, and supported companies to develop their own QGIS plugins. He founded a local hackerspace group-Bricolabs.cc. He likes training groups on conflict resolution. He contributed to the Lonely Planet guide Cycling Italy.

See other products by Pirelli

Smith Jr., GISP

Richard Smith Jr., GISP, is an asst. professor of geographic information science in the School of Engineering and Computing Sciences at Texas A&M University, Corpus Christi. He has a Ph.D. in geography from the University of Georgia, MSc in computer science, and BSc in geographic information science from Texas A&M University, Corpus Christi. He researches in cartography, systems integration, and the use of geospatial technology for disaster response. He is an advocate for FOSS4G and building a FOSS4G curriculum. He is a co-author of the FOSS4G Academy.

See other products by Smith Jr., GISP

Kurt Menke, GISP

Kurt Menke, a certified GIS Professional (GISP), has been working in the GIS field since 1997. Prior to this, he worked as a professional archaeologist for 10 years in the American Southwest. He earned a master's degree (MA) in Geography from the University of New Mexico in 2000. That same year, he founded Bird's Eye View (www.BirdsEyeViewGIS.com) to apply his expertise with the GIS technology to the World's mounting ecological and social problems. Towards this end, Mr. Menke's work focuses largely on wildlife conservation and public health. His specialties are spatial analysis, modeling, and cartography. He is a longtime advocate of FOSS4G. He began writing MapServer applications in 2001 and has been using QGIS since 2007. He is one of the coauthors of the curriculum at the FOSS4G Academy

See other products by Kurt Menke, GISP