Yancho
By: a guest | Mar 15th, 2008 | Syntax:
SQL | Size: 0.72 KB | Hits: 290 | Expires: Never
SELECT gid, astext(the_geom) AS wkt, the_geom , length(the_geom) AS length
FROM shootingstar_sp
('streets',
(
SELECT gid FROM streets WHERE
source = ( SELECT give_source((SELECT near_accident ('POINT(634320.5 241427.5)','firestations') ),1000,200) )
LIMIT 1
)
,
(
SELECT gid FROM streets WHERE
target = ( SELECT give_target('POINT(634320.5 241427.5)',1000,200) )
LIMIT 1
)
,
5000,
'length',
true,
true
);