[pgrouting-users] Linestring query

[Gavin Fleming]

Linear referencing sounds like a good approach for this problem:

http://postgis.net/docs/manual-2.1/reference.html#Linear_Referencing

On 27/11/2014 13:49, Patrick Higgins wrote:
>
> Hello
>
>  
>
> 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
> to
> 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.
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users



-- 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20141127/95dd4990/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: email signature gavin.jpg
Type: image/jpeg
Size: 23835 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20141127/95dd4990/attachment-0001.jpg>