I am using the following function that works quite well.
However, the center of the geometry (arrowhead) is moved to the center of
the geometry.
Is there someway of applying an offset so that the point of the arrow can be
moved so it is touching the boundary of the geometry??
Bob
Insert into temparrow (the_geom, process_id, orient)
Select st_translate (graphics.utilities_dgm.the_geom,
st_x (st_centroid (p_id.p_id.ithe_geom)) -
st_x (st_centroid (graphics.utilities_dgm.the_geom)),
st_y (st_centroid (p_id.p_id.ithe_geom))-
st_y (st_centroid (graphics.utilities_dgm.the_geom))),
(p_id.processes.process_id), (p_id.processes.ip_orient)
From graphics.utilities_dgm, p_id.p_id, p_id.processes, processes_count
where graphics.utilities_dgm.utilities_description = 'Arrow_Flow_Direction'
and graphics.utilities_dgm.orientation = p_id.processes.ip_orient
and p_id.processes.process_id = processes_count.process_id ;
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
