Packt+ | Advance your knowledge in tech

You're reading from Python Geospatial Development - Second Edition If you're experienced in Python here's an opportunity to get deep into Geospatial development, linking data to global locations. No prior knowledge required ‚Äì this book takes you through it all, step by step.

Product type Paperback

Published in May 2013

Publisher Packt

ISBN-13 9781782161523

Length 508 pages

Edition 2nd Edition

Languages

Python

Tools

PostGIS

Concepts

Geospatial Analysis

Author (1):

Erik Westra

View More author details

Table of Contents (18) Chapters

Python Geospatial Development

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

1. Geospatial Development Using Python FREE CHAPTER

2. GIS

3. Python Libraries for Geospatial Development

4. Sources of Geospatial Data

5. Working with Geospatial Data in Python

6. GIS in the Database

7. Working with Spatial Data

8. Using Python and Mapnik to Generate Maps

9. Putting It All Together – a Complete Mapping System

10. ShapeEditor – Implementing List View, Import, and Export

11. ShapeEditor – Selecting and Editing Features

Index

Open source spatially-enabled databases

If you wish to use an open source database for your geospatial development work, you currently have three main options: MySQL, PostGIS and SpatiaLite. Each has its own advantages and disadvantages, and no one database is the ideal choice in every situation. Let's take a closer look at each of these spatially-enabled databases.

MySQL

MySQL is the world's most popular open source database, and is generally an extremely capable database. It is also spatially-enabled, though with some limitations, which we will get to in a moment.

The MySQL database server can be downloaded from http://mysql.com/downloads for a variety of operating systems, including MS Windows, Mac OS X, and Linux. Click on the MySQL Community Server link to download the server.

Once downloaded, running the installer will set up everything you need, and you can access MySQL directly from the command line:

% mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection...

The rest of the chapter is locked

You're reading from Python Geospatial Development - Second Edition If you're experienced in Python here's an opportunity to get deep into Geospatial development, linking data to global locations. No prior knowledge required ‚Äì this book takes you through it all, step by step.

Table of Contents (18) Chapters

Open source spatially-enabled databases

MySQL

Authors (1)

Personalised recommendations for you

You're reading from Python Geospatial Development - Second Edition If you're experienced in Python here's an opportunity to get deep into Geospatial development, linking data to global locations. No prior knowledge required ‚Äì this book takes you through it all, step by step.

Table of Contents (18) Chapters

Open source spatially-enabled databases

MySQL

Unlock this book and the full library FREE for 7 days

Authors (1)

Personalised recommendations for you