Hi ahmet, you can use something like that (and easily write a function):
here, the point is (0 0) : ST_makepoint(0,0) ,azimuth is 45 and distance is 50. select st_makeline(st_makepoint(0,0),st_makepoint(xx,yy)) as the_geom FROM ( select ST_x(st_makepoint(0,0)) + (50 * (sin(45))) as xx, ST_y(st_makepoint(0,0)) + (50 * (cos(45))) as yy ) as foo Fred. On Tue, Jul 20, 2010 at 12:26 PM, ahmet temiz <[email protected]>wrote: > hello > > I want to make a linestring from a known point and known direction (as > azimuth) with > certain length. > > how can I do that ? > > regards > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
