Working With Spatial Databases With GeoAlchemy

√Čric Lemoine (Camptocamp SA)

09:00 on Saturday 21st September (in Session 48, starting at 9 a.m., EMCC: Room 3)

Show in Timetable

Description: GeoAlchemy is a powerful toolkit for working with SQL spatial databases with Python. The latest version (2) will be presented, as well as integration with PostGIS and Shapely.

GeoAlchemy helps you use spatial databases from Python. GeoAlchemy provides extensions to SQLAlchemy, the Python SQL toolkit and ORM. GeoAlchemy builds on SQLAlchemy's extreme flexibility, and can be used for different types of applications, from simple scripts to complex web applications. In this talk we will present GeoAlchemy and SQLAlchemy. We will describe when and how SQLAlchemy and GeoAlchemy can be useful. We will demonstrate the power and flexibility of the tools. We will also present the new version of GeoAlchemy, namely GeoAlchemy 2. GeoAlchemy 2 enables leveraging PostGIS' new features. For example, GeoAlchemy 2 supports PostGIS's new raster type. Finally, we will demonstrate how GeoAlchemy integrates with other well-known Python tools, such as Shapely.