[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Adding a position (direction) attribute to a point feature
From: Sandro Santilli <strk () kbt ! io>
Date: 2017-11-12 22:14:41
Message-ID: 20171112221441.fhvkkvzqore6g3tu () liz
[Download RAW message or body]
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
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic