[postgis-users] Regularly spaced address markers on alternating side of road

[Sandro Santilli]

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;