0

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):

Kurt Menke, GISP

Corti

Smith Jr., GISP

Pirelli

Van Hoesen, GISP

+1 more

View More author details

Table of Contents (13) Chapters

Preface

1. A Refreshing Look at QGIS

2. Creating Spatial Databases FREE CHAPTER

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

Importing data into a SpatiaLite database

Importing data into a SpatiaLite database is easy using the DB Manager. SpatiaLite supports the following commonly-used formats, as well as many other formats, for importing files:

Shapefile (.shp)
dBase (.dbf)
Text (.txt), Commas Separate Values (.csv), and Excel spreadsheets (.xls/.xlsx)
AutoCAD DXF (.dxf)
Geography Markup Language (.gml)
Keyhole Markup Language (.kml)
Geometry JavaScript Object Notation (.geojson)
Scalable Vector Graphics (.svg)

Let's use DB Manager to import data in a few different formats into our GiffordPinochet.sqlite database.

Importing KML into SpatiaLite

To import a KML file into a SpatiaLite database, complete the following steps:

Open DB Manager by clicking on DB Manager under Database. Expand SpatiaLite and select GiffordPinochet.sqlite on the Tree panel.
Navigate to Table | Import layer/file to open the Import vector layer dialog.
Click on the ellipsis button at the right-hand side of the Input drop-down box. Choose Keyhole...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Mastering QGIS

You have been reading a chapter from

Mastering QGIS - Second Edition

Published in: Sep 2016

Publisher: Packt

ISBN-13: 9781786460370

© 2016 Packt Publishing Limited All Rights Reserved

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)

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

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

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

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

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

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

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

System Programming Essentials with Go

System Programming Essentials with Go

From file operations to process management and network programming, this hands-on guide equips software engineers with the skills to build efficient, reliable applications and optimize their performance.

Jun 2024 13h 36m

Modern Python Cookbook

Modern Python Cookbook

The new edition of Modern Python Cookbook provides over 130 recipes for solving real-world problems with Python. Updated for Python 3.12 with new recipes and chapters. This practical guide will enhance your skills and teach you advanced techniques.

Jul 2024 27h 16m

The Ultimate Zoom Cookbook

The Ultimate Zoom Cookbook

This cookbook is an in-depth guide to using Zoom effectively. You'll be able to follow each recipe easily to harness the power of the communication and collaboration tools in Zoom.

May 2024 11h 20m

Enterprise Architecture with .NET

Enterprise Architecture with .NET

This book will help you create applications that integrate correctly into complex and ever-changing information systems. You'll execute this by using industry standards that reduce the app's technical debt and elevate software development practices.

May 2024 25h 44m

Salesforce B2C Solution Architect's Handbook

Salesforce B2C Solution Architect's Handbook

Discover how Salesforce Customer 360 unifies Marketing Cloud, B2C Commerce, Data Cloud, and Service Cloud into one solution, and learn the capabilities, integration options, limitations, and workflows to create value for your organization.

May 2024 15h 28m

Systems Programming with C# and .NET

Systems Programming with C# and .NET

Unlock the full potential of C# and .NET Core in systems programming to secure, deploy, and maintain robust applications. With this book, you'll focus on low-level APIs, memory management, and performance optimization.

Jul 2024 15h 48m

Technical Program Manager's Handbook

Technical Program Manager's Handbook

Unlock the full potential of your career as a TPM with this comprehensive guide, featuring new chapters on AI and more. Learn advanced techniques and gain insights from industry leaders. Elevate your skills and thrive in the Big Five tech companies.

Sep 2024 12h 16m

Microsoft Power Pages in Action

Microsoft Power Pages in Action

Packed with real-world examples, low-code coding techniques, and insights into crafting responsive pages, automating apps, and enhancing virtual agents, Microsoft Power Pages in Action is a valuable resource for building feature-rich web apps.

Jun 2024 11h 40m