Share Pastebin
Guest
Public paste!

Yancho

By: a guest | Mar 15th, 2008 | Syntax: SQL | Size: 0.72 KB | Hits: 290 | Expires: Never
This paste has a previous version, view the difference. Copy text to clipboard
  1. SELECT gid, astext(the_geom) AS wkt, the_geom , length(the_geom) AS length
  2.               FROM shootingstar_sp
  3.               ('streets',
  4.                 (
  5.                 SELECT gid FROM streets WHERE
  6.                 source = ( SELECT give_source((SELECT near_accident ('POINT(634320.5 241427.5)','firestations') ),1000,200) )
  7.                 LIMIT 1
  8.                 )
  9.               ,
  10.              
  11.                 (
  12.                 SELECT gid FROM streets WHERE
  13.                 target = ( SELECT give_target('POINT(634320.5 241427.5)',1000,200) )
  14.                 LIMIT 1
  15.      
  16.                 )
  17.               ,
  18.               5000,
  19.               'length',
  20.               true,
  21.               true
  22.               );