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 tables

To actually generate the tables, there are two methods that can be used. Table model classes have an internal __table__ method that has a create function, which can be used to create each table separately. There is also a drop function that can be called to drop a table.

In the script, we use try/except blocks to generate the tables. If an exception is incurred (that is, if the table already exists), the table is dropped and then created. Here is the State table creation statement as an example:

    # Generate the State table from the State class.    # If it already exists, drop it and regenerate it    try:        State.__table__.create(engine)    except:        State.__table__.drop(engine)        State.__table__.create(engine)

Alternatively, all database ...

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