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/
