Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Mastering Geospatial Analysis with Python Explore GIS processing and learn to work with GeoDjango, CARTOframes and MapboxGL-Jupyter

Product type Paperback

Published in Apr 2018

Publisher Packt

ISBN-13 9781788293334

Length 440 pages

Edition 1st Edition

Languages

Python

Tools

Anaconda

Concepts

Geospatial Analysis

Authors (3):

Silas Toms

Paul Crickard

Eric van Rees

View More author details

Table of Contents (18) Chapters

Preface

1. Package Installation and Management FREE CHAPTER

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

17. Other Books You May Enjoy

Leave a review - let other readers know what you think

Working with PostgreSQL and PostGIS using Python

To connect and manipulate your PostgreSQL database in Python, you will need a library to assist you. psyscopg2 is 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 specification and 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...

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

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 Toms

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

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