[postgis-users] Connecting points to lines within polygons

[Ahmed Dassouki]

Dear Mailing list,

I have a point table representing centroids, a line table representing
roads, and a polygon table representing zones.
I'd like to create X number of line(s) connecting each centroid to the
nearest roads such that these connections are within the zone.
The new lines will be saved to a new table that also includes the existing
lines. image: http://imgur.com/1tEaP.jpg

I'd like to create a script that does this point-to-line-within-polygon
connection and creates the new layer. Any ideas?

P.S I'm familiar with Python, C, and a bit of gdal/ogr.

Thank you,

-- 
Dassouki
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090420/f712d66f/attachment.html>