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.acostayl...@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 <l...@pcorp.us> >Enviado: miércoles, 8 de mayo de 2024 11:56:04 >Para: SERGIO ACOSTAYLARA; postgis-users@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.acostayl...@mtop.gub.uy> >Sent: Wednesday, May 8, 2024 9:21 AM >To: postgis-users@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/
