Mastering Geospatial Analysis with Python

Table properties

The name of the data table generated in the RDBMS database will correspond to the __tablename__ property of a model class. The primary key for each table is used for relationships and queries and must be defined using the keyword primary_key. The Column class and the String, Float and Integer type classes are called from SQLAlchemy and are used to define table columns to be generated within the underlying RDBMS (thus allowing the programmer to avoid crafting CREATE TABLE statements for each variety of SQL used by the major RDBMS).

For example, the Arena class will be used to manage a table that has four columns—a String name field, two Float fields (longitude and latitude), and a POINT geometry type with an SRID or EPSG spatial ...