[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Regularly spaced address markers on alternating side of road
From:       Sandro Santilli <strk () kbt ! io>
Date:       2016-07-01 8:32:48
Message-ID: 20160701083248.GC24237 () localhost
[Download RAW message or body]

On Fri, Jul 01, 2016 at 12:50:51AM +0800, Dan Jacobson wrote:
> Dear PostGis list, I want to make pseudo-addresses every 25 meters along
> a road,
> 
> 21  23  25  27  29
> ==================
>   22  24  26  28

My recipe would involve:

 http://postgis.net/docs/manual-2.2/ST_OffsetCurve.html
 http://postgis.net/docs/manual-2.2/ST_Length.html
 http://postgis.net/docs/manual-2.2/ST_LineInterpolatePoint.html

Happy hacking !

--strk;
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]