[postgis-users] Adding a position (direction) attribute to a point feature

[Brent Wood]

if you use relative to direction of travel, you'll need separate line features for each segment & direction to be able to work it out.

Instead of using direction of travel you can use degrees to angle relative to direction of linestring (which is pretty much fixed), so +-90, 90/180 and for points on the centreline you can use an artificial value of (say) -999

Or geographic (compass) direction, ie: degrees expressing NSEW relative to the road, which is totally fixed, being absolute & independent rather than relative..

Brent Wood

Programme leader: Environmental Information Delivery
NIWA
DDI:  +64 (4) 3860529


Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
+64-4-386-0529 | 301 Evans Bay Parade, Greta Point, Wellington | www.niwa.co.nz<http://www.niwa.co.nz>
[NIWA]<http://www.niwa.co.nz>
To ensure compliance with legal requirements and to maintain cyber security standards, NIWA's IT systems are subject to ongoing monitoring, activity logging and auditing. This monitoring and auditing service may be provided by third parties. Such third parties can access information transmitted to, processed by and stored on NIWA's IT systems.
________________________________________
From: postgis-users [postgis-users-bounces at lists.osgeo.org] on behalf of Zizi Jama [mazizi.jama at gmail.com]
Sent: Monday, November 13, 2017 03:13
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] Adding a position (direction) attribute to a point     feature

I have a a point feature (representing street signs).

I would like to do the following:

1. add street segment name to the point feature (I will create a buffer around my street segment and perform a spatial join)

2. add on which side of the street segment is the point feature located (options are left, right, centre), this is where I stuck - what would be the best approach to deal with my use case

[Inline image 1]
Thank you in advance for your suggestions.

Regards,

Zizi




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171112/4b777f41/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imagea23780.JPG
Type: image/jpeg
Size: 20819 bytes
Desc: imagea23780.JPG
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171112/4b777f41/attachment.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 11673 bytes
Desc: image.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171112/4b777f41/attachment.png>