Skip to Content
Mastering Geospatial Analysis with Python
book

Mastering Geospatial Analysis with Python

by Silas Toms, Paul Crickard, Eric van Rees
April 2018
Beginner to intermediate content levelBeginner to intermediate
440 pages
11h 36m
English
Packt Publishing
Content preview from Mastering Geospatial Analysis with Python

Creating the database and data tables

To create our database and the tables that will hold the application data, we will use the SQLAlchemy and GeoAlchemy2 classes and methods. The following code is in the script called Chapter11_0.py. This code will allow us to connect to a PostgreSQL data server to create a database and data tables that will form the backend of the web application. Import these libraries:

from sqlalchemy import create_enginefrom sqlalchemy_utils import database_exists, create_database,                             drop_databasefrom sqlalchemy import Column, Integer, String, ForeignKey, Floatfrom sqlalchemy.orm import relationshipfrom geoalchemy2 import Geometryfrom sqlalchemy.ext.declarative import declarative_base

Connecting the database server to ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Learning Geospatial Analysis with Python

Learning Geospatial Analysis with Python

Joel Lawhead

Publisher Resources

ISBN: 9781788293334Supplemental Content