not exactly what you are looking for, but i'm storing geo points for shapes on google app engine, and then rendering delivery zones on a google map for http://www.diginn.com/order/ (enter an address in New York, NY USA....during "business hours" in the EST and it will bring up the locations map). in this case i store a list of points in the DB (as a list of formatted strings), and use the javascript google maps API to draw the layer.
if any of this is applicable to you i can share some of the relevant code. On Thursday, December 6, 2012 2:54:51 PM UTC-8, Luis wrote: > > 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 >>> >> --
