linear reference/dynamic segmentation

[SERGIO ACOSTAYLARA]

Thank you Regina for your response. I mean, for example, I have a roads layer that has many attributes (width, pavement type, maximum speed, etc.). Without dynamic segmentation I must have a new segment every time an attribute changes its value; with dynamic segmentation I don't need to do this. Regarding this I found the following: http://postgis.net/workshops/postgis-intro/linear_referencing.html. But I would like to know if there is someone who had already used it so as to ask him or her about how that experience.


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/
________________________________
De: Regina Obe <lr at pcorp.us>
Enviado: miércoles, 8 de mayo de 2024 11:56:04
Para: SERGIO ACOSTAYLARA; postgis-users at lists.osgeo.org
Asunto: RE: linear reference/dynamic segmentation

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/a9bf136e/attachment.htm>