linear reference/dynamic segmentation

[SERGIO ACOSTAYLARA]

Thank you Simon. Sounds interesting. It'll be very good if you could share it


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: SPDBA <simon at spdba.com.au>
Enviado: jueves, 9 de mayo de 2024 8:52:35
Para: SERGIO ACOSTAYLARA
Cc: Regina Obe; postgis-users at lists.osgeo.org
Asunto: Re: linear reference/dynamic segmentation

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) <http://www.spdba.com.au> www.spdba.com.au<http://www.spdba.com.au>
On 9 May 2024, at 01:09, SERGIO ACOSTAYLARA <sergio.acostaylara at mtop.gub.uy<mailto: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/f39d2d1d/attachment.htm>