Geoalchemy demo

[Sanjiv Singh]

Hi all,

I made some progress on geoalchemy during the last couple of weeks.
Apart from the basic data type support many of the OGC functions are
now supported. A demo TG2 app using the geoalchemy tip is hosted at
http://geo.turbogears.org/

Some code review at this stage would be very helpful for me :)

regards
Sanjiv

[Douglas Mayle]

You guys have a geoalchemy project? I had no idea... I've spent the
last two months or so working on something similar. It's a geo-based
project on pylons (not a base, but a lot of our solutions are
generalized), and I've been planning to blog about our solutions. I'd
be happy to help along... I've noticed that you don't support GeoJSON
as a data type (at least on the website). How can I help?

Doug

[Sanjiv Singh]

Hi Douglas,

tgext.geo started last year as an soc project. It uses mapfish for vector editing and tilecache for wms caching. This year it is being enhanced by adding gis support for sqlalchemy in a separate project. I intend to integrate feature server with geoalchemy too by the end of this summer so that we have:

(a) support for postgis, spatialite and mysql spatial databases
(b) support for most of the ogc geometry functions and relations at the orm layer
(c) feature server as a wsgi service for exposing the objects using WFS. If this does not work out we will continue to expose the objects using mapfish (which supports restful geo interface but not the WFS standard)

On Tue, Jun 23, 2009 at 1:55 AM, Douglas Mayle <dou...@mayle.org> wrote:

You guys have a geoalchemy project?  I had no idea...  I've spent the
last two months or so working on something similar.  It's a geo-based
project on pylons (not a base, but a lot of our solutions are
generalized), and I've been planning to blog about our solutions.  I'd
be happy to help along...  I've noticed that you don't support GeoJSON
as a data type (at least on the website).  How can I help?

GeoJSON is not supported at the orm layer right now as it was added in postgis-1.3.4 and the version available at webfaction is 1.3.3. However, it is supported at the service layer (mapfish) using shapely and geojson libraties from gispython.org.

I am sure my code needs a lot of improvement. You could check out the code from http://bitbucket.org/sanjiv/geoalchemy, review it and suggest improvements.

It is a mirror of the main repo. The main repo is protected ATM as the gsoc work is to be completed *solely* by the student :(
After the coding period ends (begining of August) everybody can contribute to it.

Thanks for your interest.
Sanjiv