Posted by Yancho on Mon 26 Nov 16:52
report spam | download | new post
- ASTAR_SP_DELTA
- SELECT gid, AsText(the_geom)
- FROM astar_sp_delta(
- 'streets',
- (SELECT give_source('POINT(640905 225230)',1000,200)),
- (SELECT give_target('POINT(640982 225439)',1000,200)),
- 3000
- );
- First Row of Result :
- 40617;"MULTILINESTRING((640920.707155369 225441.381903503,640919.710413482 225419.024734874,640904.400352 225231.230885577))"
- SHOOTINGSTAR_SP
- SELECT gid, AsText(the_geom)
- FROM shootingstar_sp
- ('streets',
- (SELECT give_source('POINT(640905 225230)',1000,200)),
- (SELECT give_target('POINT(640982 225439)',1000,200)),
- 5000,
- 'length',
- true,
- true
- );
- First Row of Result :
- 791;"MULTILINESTRING((629357.137492173 222486.61416491,629357.137492172 222526.524103276))"
Submit a correction or amendment below (click here to make a fresh posting)
After submitting an amendment, you'll be able to view the differences between the old and new posts easily.