linear reference/dynamic segmentation

[SPDBA]

I did a presentation years ago on applying LRS and DS  to complex roads management. It was fir oracle but postgis has the necessary functionality.
I could try and dig it out if you are interested.

As am aside does anyone know of any interest/projects in architecting an integrated enterprise solution from FOSS4G components?

Simon


⁣39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
(P) 03 62 396 397
(M) 0418 396 381
(W) www.spdba.com.au​

On 9 May 2024, 01:09, at 01:09, SERGIO ACOSTAYLARA <sergio.acostaylara at mtop.gub.uy> wrote:
>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/20240509/1bd9de97/attachment.htm>