[pgrouting-users] Linestring query

Patrick Higgins PHiggins at pkc.gov.uk
Thu Nov 27 03:49:07 PST 2014


Could anyone please tell me if pgRouting has the facility to be able to place a point at a specified distance (e.g. 300m) along a linestring from a point of origin?

The problem summed up:  Which houses/properties are within a 300, or 600m walking distance from a play area, where the walking route follows the pavement/ sidewalk/ established path route, but not through private property?

In the past, a circle of 300/600m radius has been used, but this then includes properties which are in actual fact further than 300/600m walking distance.

The point of origin is a play park centroid.

The linestring could be a single linestring, such as a highway centre line, in which case there would be a single point at 300m along the linestring from the point of origin.

Alternatively, the linestring could be one which after 150m, meets another linestring, a junction heading west, in which case points would be placed on both the original linestring (at 300m) and on the westward one (at 150m + 150m).

It is envisaged that we will use this tool to generate walking distances from woodlands, ponds and so on.

Many thanks
Patrick Higgins

Securing the future... - Improving services - Enhancing quality of 
life - Making best use of public resources.

The information in this email is solely for the intended recipients. 

If you are not an intended recipient, you must not disclose, copy, 
or distribute its contents or use them in any way: please advise 
the sender immediately and delete this email.

Perth & Kinross Council, Live Active Leisure Limited and 
TACTRAN do not warrant that this email or any attachments are 
virus-free and does not accept any liability for any loss or damage 
resulting from any virus infection. Perth & Kinross Council may 
monitor or examine any emails received by its email system.

The information contained in this email may not be the views of 
Perth & Kinross Council, Live Active Leisure Limited or TACTRAN. 
It is possible for email to be falsified and the sender cannot be 
held responsible for the integrity of the information contained in it.

Requests to Perth & Kinross Council under the Freedom of 
Information (Scotland) Act should be directed to the Freedom of 
Information Team - email: foi at pkc.gov.uk

General enquiries to Perth & Kinross Council should be made to 
enquiries at pkc.gov.uk or 01738 475000.

General enquiries to Live Active Leisure Limited should be made 
enquiries at liveactive.co.uk or 01738 454600.

General enquiries to TACTRAN should be made to 
info at tactran.gov.uk or 01738 475775.

Securing the future... - Improving services - Enhancing quality of 
life - Making best use of public resources.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20141127/cf5cafc1/attachment.html>

More information about the Pgrouting-users mailing list