1. Mike Gilligan
  2. geoalchemy



GIS Support for SQLAlchemy.


GeoAlchemy is an extension of SQLAlchemy. It provides support for Geospatial data types at the ORM layer using SQLAlchemy. It aims to support spatial operations and relations specified by the Open Geospatial Consortium (OGC). The project started under Google Summer of Code Program under the mentorship of Mark Ramm-Christensen.


Requires SQLAlchemy >= 0.5. Supported on python 2.5 and python 2.6. Should also work with python 2.4 but has not been tested. It also requires a supported spatial database.

Supported Spatial Databases

At present PostGIS, Spatialite and MySQL Spatial are supported.


GeoAlchemy is at an early stage of development. It does not yet have a mailing list of its own but support should be available on the SQLAlchemy Mailing List or IRC Channel. Also, feel free to email the author directly to send bugreports, feature requests, patches, etc.


To install type as usual:

$ easy_install GeoAlchemy

Or, download the package, change into geoalchemy dir and type:

$ python setup.py install


Documentation is available online at http://geo.turbogears.org/geoalchemy. You can also generate full documentation using sphinx by doing make html in the doc dir and pointing the browser to doc/_build/index.html.

Package Contents

Source code of the project.
Documentation index in rst-format, can be built using makefile included.
Unittests for GeoAlchemy.


GeoAlchemy is released under the MIT License.