Packt+ | Advance your knowledge in tech

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Mastering Geospatial Analysis with Python

You're reading from Mastering Geospatial Analysis with Python

Product type Book

Published in Apr 2018

Publisher Packt

ISBN-13 9781788293334

Pages 440 pages

Edition 1st Edition

Languages

Concepts

Geospatial Analysis

Authors (3):

Silas Toms

Paul Crickard

Eric van Rees

View More author details

Table of Contents (23) Chapters

Title Page

Copyright and Credits

Packt Upsell

Contributors

Preface

1. Package Installation and Management

2. Introduction to Geospatial Code Libraries

3. Introduction to Geospatial Databases

4. Data Types, Storage, and Conversion

5. Vector Data Analysis

6. Raster Data Processing

7. Geoprocessing with Geodatabases

8. Automating QGIS Analysis

9. ArcGIS API for Python and ArcGIS Online

10. Geoprocessing with a GPU Database

11. Flask and GeoAlchemy2

12. GeoDjango

13. Geospatial REST API

14. Cloud Geodatabase Analysis and Visualization

15. Automating Cloud Cartography

16. Python Geoprocessing with Hadoop

1. Other Books You May Enjoy

Leave a review - let other readers know what you think

Index

Working with PostgreSQL and PostGIS using Python

To connect and manipulate your PostgreSQL database in Python, you will need a library to assist you. psyscopg2is that library. It provides a wrapper around the official libpq client library. In this section, we will cover how to install the library, how to connect to the database, and how to add a table and perform basic geospatial queries.

Connecting to PostgreSQL using psycopg2

pscycopg2 is the most popular library for working with PostgreSQL in Python. It fully implements the Python DB API 2.0 specificationand works with Python 3. In the following sections, you will learn how to install the library, make connections, execute queries, and read the results. You can read the full documentation here: http://initd.org/psycopg/docs/

Installing psycopg2

Installing most Python libraries requires you to open your console and type:

pip install psycopg2

If that doesn't work, and you are using an Anaconda Python distribution, you can run the conda command...

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 $15.99/month. Cancel anytime}

Authors (3)

Silas Toms

Silas Toms is a long-time geospatial professional and author who has previously published ArcPy and ArcGIS and Mastering Geospatial Analysis with Python. His career highlights include developing the real-time common operational picture used at Super Bowl 50, building geospatial software for autonomous cars, designing computer vision for next-gen insurance, and developing mapping systems for Zillow. He now works at Volta Charging, predicting the future of electric vehicle adoption and electric charging infrastructure.

See other products by Silas Toms

Paul Crickard

Paul Crickard authored a book on the Leaflet JavaScript module. He has been programming for over 15 years and has focused on GIS and geospatial programming for 7 years. He spent 3 years working as a planner at an architecture firm, where he combined GIS with Building Information Modeling (BIM) and CAD. Currently, he is the CIO at the 2nd Judicial District Attorney's Office in New Mexico.

See other products by Paul Crickard

Eric van Rees

Eric van Rees was first introduced to Geographical Information Systems (GIS) when studying Human Geography in the Netherlands. For 9 years, he was the editor-in-chief of GeoInformatics, an international GIS, surveying, and mapping publication and a contributing editor of GIS Magazine. During that tenure, he visited many geospatial user conferences, trade fairs, and industry meetings. He focuses on producing technical content, such as software tutorials, tech blogs, and innovative new use cases in the mapping industry.

See other products by Eric van Rees

Other recommended products

Related to this chapter

Hands-On Geospatial Analysis with R and QGIS

Hands-On Geospatial Analysis with R and QGIS

Managing spatial data has always been challenging and it’s getting more complex as the size of data increases. This book is your companion to understand, manage, and analyze spatial data effectively using R and QGIS. You’ll learn to use different statistical analyses with spatial data and automate spatial tasks. You’ll also learn to classify remote sensing data and use a machine learning approach to map landslide susceptibility.

Nov 2018 11 hours 48 minutes

Geospatial Data Science Quick Start Guide

Geospatial Data Science Quick Start Guide

This book will help you leverage the power of data analysis and apply it to location and geospatial data to gain interesting insights. It presents useful tools and location intelligence techniques in Python to implement geospatial analytics from scratch.

May 2019 5 hours 40 minutes

Learning Geospatial Analysis with Python

Learning Geospatial Analysis with Python

Geospatial Analysis is used in almost every field you can think of from medicine to defense, to farming. Learning Geospatial Analysis with Python, Third Edition would be a helpful guide to Geographic Information Systems and Remote Sensing Analysis using Python 3.7 without overwhelming the reader.

Sep 2019 15 hours 12 minutes

PostGIS Cookbook

PostGIS Cookbook

PostGIS is a spatial database that integrates the advanced storage and analysis of vector and raster data, and is remarkably flexible and powerful. If you want to explore the complete range of PostGIS techniques and expose the related extensions, then this book is for you.

Mar 2018 19 hours 28 minutes

QGIS Quick Start Guide

QGIS Quick Start Guide

QGIS is a user friendly, open source geographic information system (GIS). The popularity of open source GIS and QGIS, in particular, has been growing rapidly over the last few years. This book is designed to help beginners learn about all the tools required to use QGIS 3.4.

Jan 2019 5 hours 28 minutes

ArcPy and ArcGIS

ArcPy and ArcGIS

ArcGIS allows for complex analyses of spatial data. The ArcPy module is used to create custom ArcGIS tools, providing automation of geospatial analysis and map book production. The second edition of the book focuses on new Python offerings by Esri for ArcGIS for Server, ArcGIS Online and ArcGIS Pro, including the ArcGIS API for Python. Using Python, this book will guide you from basic Python scripting to advanced ArcPy script tools and automated data management.

Jun 2017 9 hours 4 minutes

QGIS Python Programming Cookbook

QGIS Python Programming Cookbook

QGIS is a desktop geographic information system that facilitates data viewing, editing, and analysis. Based on version QGIS 2.18, this book will teach you how to write Python code that works with spatial data to automate geoprocessing tasks in QGIS.

Mar 2017 15 hours 28 minutes

Mastering PostGIS

Mastering PostGIS

PostGIS is an open source spatial database system that offers a wider array of spatial analysis function and representation of geometric data types to databases. This book offers a tailored approach to practice common and most complex geo-processing tasks experts do with ease to design efficient GIS systems. Through the course of the book, not only will you learn what are the different data types, spatial querying, indexing and other complex operations on data, but also learn to create an end to end GIS solution. This book aims to teach you how to get maximum out of PostGIS and integrate it with other platforms like Geoserver, Opelayers, Javascript libraries to create a fully analytical GIS application.

May 2017 10 hours 56 minutes

Mastering Geospatial Development with QGIS 3.x

Mastering Geospatial Development with QGIS 3.x

This book is a guide for professionals looking to master the open source QGIS software. This book will take you all the way through to learning advanced techniques like illuminated contours and dynamic masking. You will learn about the advanced topics like the creation of GeoPackages, the Processing Toolbox, and the creation of plugins using PyQGIS.

Mar 2019 15 hours 32 minutes

Jupyter Cookbook

Jupyter Cookbook

Jupyter has garnered a strong interest in the data science community of late, as it makes common data processing and analysis tasks much simpler. This book is for data science professionals who want to master various tasks related to Jupyter to create efficient, easy-to-share applications related to data analysis and visualization.

Apr 2018 7 hours 56 minutes

QGIS 3.4 is a user-friendly open source geographic information system (GIS) that runs on Linux, Unix, Mac OS X, and Windows. The book will take you on a journey from firing up QGIS for the first time to developing your own processing pathway. We’ll look at the fundamentals of GIS: data creation, data display, creating maps and spatial analysis.

Nov 2018 9 hours 4 minutes

Building Web and Mobile ArcGIS Server Applications with JavaScript

Building Web and Mobile ArcGIS Server Applications with JavaScript

ArcGIS Server is the leading software for developing both web and mobile GIS applications. The ArcGIS API for JavaScript is the preferred way of developing your custom applications for ArcGIS Server since it can be used for both web and mobile application development. It's easy to use and doesn't require the use of a browser plugin. This practical guide provides you with hands-on experience in developing custom web and mobile ArcGIS Server applications with step-by-step style exercises.

Oct 2017 10 hours 48 minutes

Personalised recommendations for you

Based on your interests and search pattern

C++ Programming for Linux Systems

C++ Programming for Linux Systems

This book covers the essential system programming tools and helps you explore the features of C++20. It emphasizes important details to maintain code quality and tackle everyday challenges of developing software for high performance, optimization, and more.

Sep 2023 9 hours 36 minutes

Discover advanced programming techniques, the latest features of C++17 and C++20, and best practices for memory management, debugging, testing, and large-scale application design with Expert C++. Ideal for experienced developers advancing to proficient programmers and building professional-grade C++ applications.

Aug 2023 20 hours 8 minutes

iOS 17 Programming for Beginners

iOS 17 Programming for Beginners

iOS 17 Programming for Beginners, Eighth Edition is your comprehensive guide to learning the art of iOS app development. Whether you dream of creating the next chart-topping app or simply want to enhance your programming skills, this book is your trusted companion on this exciting journey.

Oct 2023 20 hours 8 minutes

Developer Career Masterplan

Developer Career Masterplan

Written by industry experts that have spent the last 20+ years helping developers grow their career path towards senior developer positions and beyond. This book provides a comprehensive guide, sharing examples and stories from their global careers. By the end, you’ll have the knowledge to create a clear career progression plan as a technical professional.

Sep 2023 10 hours 20 minutes

Refactoring with C#

Refactoring with C#

In Refactoring with C#, you’ll explore the process of safely refactoring modern .NET code using Visual Studio features, advanced unit tests, AI assistance, and custom Roslyn analyzers.

Nov 2023 14 hours 28 minutes

Python Real-World Projects

Python Real-World Projects

Amplify your developer journey by curating a dynamic project portfolio that outshines traditional resumes. Delve into the Python realm through immersive projects, mastering core concepts while constructing comprehensive modules and applications. From data acquisition prowess to impactful data visualization, Python Real-World Projects arms you with essential skills to beat the competition.

Sep 2023 15 hours 56 minutes

The MVVM Pattern in .NET MAUI

The MVVM Pattern in .NET MAUI

The MVVM Pattern in .NET MAUI enables developers to master MVVM principles and effectively apply them to .NET MAUI. This book uses real-life examples and covers complex problems to help you successfully apply MVVM with .NET MAUI to confidently develop robust and high-performing cross-platform apps.

Nov 2023 12 hours 52 minutes

Extending Microsoft Business Central with Power Platform

Extending Microsoft Business Central with Power Platform

Extending Business Central with the Power Platform is a step-by-step guide for Business Central professionals to create solutions that automate business processes, explain complex workflow approvals, and integrate with hundreds of other systems, without traditional development. It’ll guide you in customizing Business Central with Power Platform.

Aug 2023 15 hours 16 minutes

Extending Microsoft Business Central with Power Platform

Extending Microsoft Business Central with Power Platform

Extending Business Central with the Power Platform is a step-by-step guide for Business Central professionals to create solutions that automate business processes, explain complex workflow approvals, and integrate with hundreds of other systems, without traditional development. It’ll guide you in customizing Business Central with Power Platform.

Aug 2023 15 hours 16 minutes

Quantum Computing Algorithms

Quantum Computing Algorithms

The book emphasizes intuitive ideas behind quantum algorithms in ways that other books don’t cover, striking a careful balance between no math and too much math. To get the most from this book, you should be comfortable with basic algebra and writing simple computer code. No prior understanding of quantum physics is needed to get started.

Sep 2023 11 hours 24 minutes

Python – Complete Python, Django, Data Science and ML Guide

Python – Complete Python, Django, Data Science and ML Guide

Unlock Python's full potential with this 50+ hour course! From programming to web and game development, data manipulation, and machine learning, gain the skills required to succeed in various Python-related careers. With practical tasks, hands-on experience, and a strong foundation in Python, you'll be ready to tackle real-world challenges and take advantage of the many opportunities this versatile language offers.

Nov 2023 50 hours 30 minutes

Python – Complete Python, Django, Data Science and ML Guide

Python – Complete Python, Django, Data Science and ML Guide

Unlock Python's full potential with this 50+ hour course! From programming to web and game development, data manipulation, and machine learning, gain the skills required to succeed in various Python-related careers. With practical tasks, hands-on experience, and a strong foundation in Python, you'll be ready to tackle real-world challenges and take advantage of the many opportunities this versatile language offers.

Nov 2023 50 hours 30 minutes