[sqlalchemy] Re: connectionless queries with Spatial data (PostGIS)

2009-04-20 Thread Roy Hyunjin Han
Geospatial support is definitely an external project in any case. As soon as something goes in the core, it's now linked to our release process, I'm getting the tickets and complaints personally, etc., theres no way a huge subject like geo support belongs there. I agree with you that it has

[sqlalchemy] Re: connectionless queries with Spatial data (PostGIS)

2009-04-19 Thread Roy Hyunjin Han
Michael, Do you know if anyone is working on a PostGIS extension for SQLAlchemy? If not, I'd like to take a crack at it. RHH On Mon, Mar 16, 2009 at 1:47 PM, Michael Bayer mike...@zzzcomputing.com wrote: Roy H. Han wrote: On Feb 20, 6:52 pm, Michael Bayer mike...@zzzcomputing.com wrote:

[sqlalchemy] Re: connectionless queries with Spatial data (PostGIS)

2009-04-19 Thread Roy Hyunjin Han
Do you know if anyone is working on a PostGIS extension for SQLAlchemy?  If not, I'd like to take a crack at it. My suggestions regarding this are of course building off of the postgis.py example, and also perhaps, if its feasable (not sure if it is), building the whole thing as a plugin to

[sqlalchemy] Re: connectionless queries with Spatial data (PostGIS)

2009-04-19 Thread Michael Bayer
On Apr 19, 2009, at 4:05 PM, Roy Hyunjin Han wrote: Do you know if anyone is working on a PostGIS extension for SQLAlchemy? If not, I'd like to take a crack at it. My suggestions regarding this are of course building off of the postgis.py example, and also perhaps, if its feasable (not

[sqlalchemy] Re: connectionless queries with Spatial data (PostGIS)

2009-04-19 Thread Eric Lemoine
On Sun, Apr 19, 2009 at 10:17 PM, Michael Bayer mike...@zzzcomputing.com wrote: I dont know much about MapFish but it appears to have a client/server, calls itself a web applciation framework, and seems completely complicated compared to just we'd like to use PostGIS with SQLAlchemy.   I'm

[sqlalchemy] Re: connectionless queries with Spatial data (PostGIS)

2009-04-19 Thread Michael Bayer
On Apr 19, 2009, at 5:12 PM, Eric Lemoine wrote: On Sun, Apr 19, 2009 at 10:17 PM, Michael Bayer mike...@zzzcomputing.com wrote: I dont know much about MapFish but it appears to have a client/ server, calls itself a web applciation framework, and seems completely complicated compared

[sqlalchemy] Re: connectionless queries with Spatial data (PostGIS)

2009-04-19 Thread Eric Lemoine
On Sun, Apr 19, 2009 at 11:37 PM, Michael Bayer mike...@zzzcomputing.com wrote: how easily can the SQLAlchemy constructs be used independently of the Pylons/RESTful stuff ? By installing the package and only import mapfish.sqlalchemygeom. But a separate python package may make sense, and I

[sqlalchemy] Re: connectionless queries with Spatial data (PostGIS)

2009-03-16 Thread Roy H. Han
On Feb 20, 6:52 pm, Michael Bayer mike...@zzzcomputing.com wrote: Also I've built an ORM extension forpostgiswhich is incomplete but   demonstrates how to round trip and createPostGISexpressions in a   clean way, thats in the distribution in examples/postgis/postgis.py . Thanks for this

[sqlalchemy] Re: connectionless queries with Spatial data (PostGIS)

2009-03-16 Thread Michael Bayer
Roy H. Han wrote: On Feb 20, 6:52 pm, Michael Bayer mike...@zzzcomputing.com wrote: Also I've built an ORM extension forpostgiswhich is incomplete but   demonstrates how to round trip and createPostGISexpressions in a   clean way, thats in the distribution in examples/postgis/postgis.py .

[sqlalchemy] Re: connectionless queries with Spatial data (PostGIS)

2009-02-20 Thread Michael Bayer
the func. call is a SQL expression which can't be bound to a bind parameter. that has to stay in the values() clause. e.g. table.insert().values(location=f, id=97).execute(), or table.insert().values(location=f).execute(id=97). if you wanted everything inside of 'f'