I am attempting to use SQLAlchemy with PostGIS (spatial extensions for
Postgres). I'm wondering if anyone out there has any experience with
this.
I was considering looking into the SQLAlchemy types and seeing if I
could hack together a geometry type. One thing that looks tricky is
that, as far as I can tell, the geometry column must be added after
the table is created. The PostGIS docs say to do this:
CREATE TABLE "raw"."portlandor" (
[normal columns here]
)
and then in a separate step:
SELECT
AddGeometryColumn('raw','portlandor','the_geom','2913','MULTILINESTRING',2);
A google search for postgis + sqlalchemy[1] doesn't turn up anything
useful that I can see. The 2nd item there is a post on my own site,
which just happens to mention both of postgis and sqlalchemy.
Any ideas?
[1]
<http://www.google.com/search?q=sqlalchemy+postgis&start=0&ie=utf-8&oe=utf-8&client=firefox&rls=org.mozilla:en-US:unofficial>
--
Wyatt Baldwin
byCycle.org
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
