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 <si...@spdba.com.au> Enviado: jueves, 9 de mayo de 2024 8:52:35 Para: SERGIO ACOSTAYLARA Cc: Regina Obe; postgis-users@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.acostayl...@mtop.gub.uy<mailto: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/