On Sun, Nov 12, 2017 at 04:13:31PM +0200, Zizi Jama wrote: > 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
You could use ST_OffsetCurve and see how distance changes: https://postgis.net/docs/ST_OffsetCurve.html --strk; _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
