Thank you Massimo, I think the st_astext and st_geojson functions will set me in the right direction.
Luis On Thursday, December 6, 2012 4:26:50 PM UTC-5, Massimo Di Pierro wrote: > > 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 >> > --
