I am not expert in this. The Database Abstraction Layer has API to use PostGIS and Spatialite. In the posrgesql case specifically the DAL supports field types "geometry" and "geography" and field functions st_asgeojson, st_astext, st_contained, st_contains, st_distance, st_equals, st_intersects, st_overlaps, st_simplify, st_touches, st_within.
I cannot give you more details because this feature is still undocumented. Anyway, this sounds like what you are looking for I will try write some usage examples. Massimo On Thursday, 6 December 2012 08:12:04 UTC-6, Luis wrote: > > 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 > --
