Hello, I'm new to web2py and wanted to know if there is any way on web2py to render geometry types (i.e. add layers to maps as web feature service or web mapping service) from postgresql databases without using an external web mapping service (such as map server or geoserver). I come from a spatial analysis background and spend most of my time working with GIS and databases. The way I'm currently GIS web development is through a framework based on PostgreSQL+Postgis+GeoServer+OpenLayers, but I would like to know if web2py has a way to simplify GIS web development and be able to query both non spatial and spatial data (in tables and maps).
It occurs to me that one could get the geometry of a set of records in text format through a query and use Openlayers to render each of the record geometry features. If this were feasible, any hints on what steps I could follow to code the controller and view template? Any suggestion would be appreciated. Thanks in advance, Luis Carrasco --

