[pgrouting-users] Linestring query

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

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@pkc.gov.uk

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

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

General enquiries to TACTRAN should be made to
info@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

--

email signature gavin.jpg