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

[Zizi Jama]

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

[image: 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/67116cbf/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 11673 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171112/67116cbf/attachment.png>