I would like to get catchment areas using pgr_drivingdistance and
pgr_alphashape functions from postgis-pgrouting .How i could do that inside
SQL views Geoserver?.Thank you very much.
1.pgr_drivingdistance:
SELECT id, id1 AS node, id2 AS edge, cost, the_geom
INTO "20_10min_nodes"//In Geoserver don't work(not necessary)
FROM pgr_drivingdistance(
'SELECT id, source, target, time_min as cost FROM roads',
9798, 10, false, false
) as di
JOIN vertices_tmp pt
ON di.id1 = pt.id;
and ,
2.pgr_alphAShape
CREATE TABLE "20_10min_alpha" AS//In Geoserver don't work(not necessary)
SELECT ST_MakePolygon(ST_AddPoint(foo.openline,
ST_StartPoint(foo.openline)))::geometry, 2 as alphaPoly
from (select st_makeline(points order by id) as openline from
(SELECT st_makepoint(x,y) as points ,row_number() over() AS id
FROM pgr_alphAShape('SELECT id::integer, st_x(the_geom)::float as x,
st_y(the_geom)::float as y FROM "20_10min_nodes"')
) as a) as foo;
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Sql-functions-tp5179543.html
Sent from the GeoServer - Dev mailing list archive at Nabble.com.