linear reference/dynamic segmentation

[Regina Obe]

Not sure what you mean by dynamic attributes.

 

If you need something to position points along a line, so that you can put
an info tip on each point, they you’ll want to use

 

https://postgis.net/docs/en/ST_LineInterpolatePoints.html

 

Something like below will give you a point every 20 percent along the
linestring

 

SELECT dp.geom

>From your_table, ST_DumpPoints(ST_LineInterpolatePoints(your_table.geom,
0.2, true)) AS dp

 

From: SERGIO ACOSTAYLARA <sergio.acostaylara at mtop.gub.uy> 
Sent: Wednesday, May 8, 2024 9:21 AM
To: postgis-users at lists.osgeo.org
Subject: linear reference/dynamic segmentation

 

Hi. Is there anybody in the list that has any experience using linear
reference/dynamic segmentation with postgis? We need to show dynamic
attributes in our geoportal/visualizer. Is this possible to do it with
postgis?

Thanks in advance

 

Sergio Acosta y Lara

Departamento de Geomática

Dirección Nacional de Topografía

Ministerio de Transporte y Obras Públicas

URUGUAY

(598)29157933 ints. 20329

http://geoportal.mtop.gub.uy/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240508/0fe6928b/attachment.htm>