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.
------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
