Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Mastering QGIS

You're reading from Mastering QGIS Go beyond the basics and unleash the full power of QGIS with practical, step-by-step examples

Product type Paperback

Published in Sep 2016

Publisher Packt

ISBN-13 9781786460370

Length 486 pages

Edition 2nd Edition

Tools

QGIS

Concepts

Geospatial Analysis

Authors (5):

John Van Hoesen, GISP

Kurt Menke, GISP

Paolo Corti

Richard Smith Jr., GISP

Luigi Pirelli

+1 more

View More author details

Table of Contents (13) Chapters

Preface

1. A Refreshing Look at QGIS FREE CHAPTER

2. Creating Spatial Databases

3. Styling Raster and Vector Data

4. Preparing Vector Data for Processing

5. Preparing Raster Data for Processing

6. Advanced Data Creation and Editing

7. Advanced Data Visualization

8. The Processing Toolbox

9. Automating Workflows with the Graphical Modeler

10. Creating QGIS Plugins with PyQGIS and Problem Solving

11. PyQGIS Scripting

Index

Fundamental database concepts

A database is a structured collection of data. Databases provide multiple benefits over data stored in a flat file format, such as a shapefile or KML. These benefits include complex queries, complex relationships, scalability, security, data integrity, and transactions, to name a few. Using databases to store geospatial data is relatively easy, considering the aforementioned benefits.

Note

There are multiple types of database; however, the most common type of database, and the type of database that this chapter will cover, is the relational database.

Describing database tables

A relational database stores data in tables. A table is composed of rows and columns, where each row is a single data record and each column stores a field value associated with each record. A table can have any number of records; however, each field is uniquely named and stores a specific type of data.

A data type restricts the information that can be stored in a field, and it is very important...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

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 (5)

Corti

Corti

Paolo Corti is an environmental engineer with 20 years of experience in the GIS field, currently working as a Geospatial Engineer Fellow at the Center for Geographic Analysis at Harvard University. He is an advocate of open source geospatial technologies and Python, an OSGeo Charter member, and a member of the pycsw and GeoNode Project Steering Committees. He is a coauthor of the first edition of this book and the reviewer for the first and second editions of the Mastering QGIS book by Packt.

See other products by Corti

Kurt Menke, 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

Van Hoesen, GISP

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

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

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

Personalised recommendations for you

Based on your interests and search pattern

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Mastering Python Design Patterns

Mastering Python Design Patterns

Unlock the power of design patterns to build maintainable and scalable software and applications using Python. Authored by Python veterans, this book is your guide to mastering design patterns in Python.

May 2024 9h 52m

Mastering Python Design Patterns

Mastering Python Design Patterns

Unlock the power of design patterns to build maintainable and scalable software and applications using Python. Authored by Python veterans, this book is your guide to mastering design patterns in Python.

May 2024 9h 52m