GEO ALCHEMY
Using SQLAlchemy with Spatial Databases


WHAT OUR HAPPY PROGRAMMER SAY
GeoAlchemy 2 provides extensions to SQLAlchemy for working with spatial databases.
GeoAlchemy 2 focuses on PostGIS. PostGIS 1.5 and PostGIS 2 are supported.
SpatiaLite is also supported, but using GeoAlchemy 2 with SpatiaLite requires some specific configuration on the application side. GeoAlchemy 2 works with SpatiaLite 4.3.0 and higher.
GeoAlchemy 2 aims to be simpler than its predecessor, GeoAlchemy. Simpler to use, and simpler to maintain.
Elena Miles
Latest Posts
- What are the advantages of using a creative agencyThe advantages of using a creative agency. When it comes to marketing and advertising, creativity is key. And that’s where creative agencies come in. They’re experts at coming up with innovative ideas that will capture attention and get results. 1. What are the advantages of using a creative agency A creative agency can bring a …
What are the advantages of using a creative agency Read More »
- Let us know about wedding rings in ThailandThailand is the country that fashionably represented culture. Particularly weddings in Thailand are more adorable. As other ornaments are bought by the wedding couples. The rings are also adorned on the fingers of the bride and groom. But here is a thing that thy rings for weddings are more special and unique than that of …
- 10 Mistakes that can ruin your Commercial Interiors DesignCommercial interior designers plan and design the interiors of offices, laboratories, retail spaces, and other places of business. The design is key to creating a pleasant workspace and ensuring the interiors align with the brand and overall business objectives. Below are ten common mistakes that can ruin the interior design of your commercial space. Photo …
10 Mistakes that can ruin your Commercial Interiors Design Read More »
- How to Turn Your Ideas into realityWhether they are business ideas, personal ambitions, or a long-held dream, almost everybody has had a brilliant idea at some point in their life. Although the path to success is different for everyone, empowering yourself with the necessary skills, dedication and perseverance can put you on the path to turning your ideas into reality. Whether …
- Car Insurance in Thailand, What You Need to KnowCompulsory Insurance All Thai cars must be insured. The coverage provides for the following Medical Expenses – up to ฿ 80,000 per person Loss of a Vital Organ – Between ฿ 200,000 and ฿ 500,000 Death and Permanent Disability – ฿ 500,000 per person Daily Compensation – ฿ 200 baht per day up to 20 …
Car Insurance in Thailand, What You Need to Know Read More »

FEATURED COURSE
What’s New in GeoAlchemy
- GeoAlchemy 2 supports PostGIS’
geometry
type, as well as thegeography
andraster
types. - The first series had its own namespace for spatial functions. With GeoAlchemy 2, spatial functions are called like any other SQLAlchemy function, using
func
, which is SQLAlchemy’s standard way of calling SQL functions. - GeoAlchemy 2 works with SQLAlchemy’s ORM, as well as with SQLAlchemy’s SQL Expression Language (a.k.a the SQLAlchemy Core). (This is thanks to SQLAlchemy’s new type-level comparator system.)
- GeoAlchemy 2 supports reflection of geometry and geography columns.
- GeoAlchemy 2 adds
to_shape
,from_shape
functions for a better integration with Shapely.
See the Migrate to GeoAlchemy 2 page for details on how to migrate a GeoAlchemy application to GeoAlchemy 2.


FRONT END
Requirements
GeoAlchemy 2 requires SQLAlchemy 0.8. GeoAlchemy 2 does not work with SQLAlchemy 0.7 and lower.

FRONT END
Installation
GeoAlchemy 2 is available on the Python Package Index. So it can be installed with the standard pip or easy_install tools.
TESTIMONIAL
Trusted by Thousands of Students and Tutors

EMMA HART

EDDIE JOHNSON

JONATHAN DOE
