Re: Running clustering queries

2024-05-08 Thread Greg Troxel
"Regina Obe" writes: > Paul and Sandro, > > Any thoughts on this. I know we went back and forth with "Why don't > we just populate spatial_ref_sys using postgis_srs_all or some other > such thing or why don't we just change spatial_ref_sys to a view that > relegates to reading these from

RE: Running clustering queries

2024-05-08 Thread Regina Obe
> "Regina Obe" writes: > > > Paul and Sandro, > > > > Any thoughts on this. I know we went back and forth with "Why don't > > we just populate spatial_ref_sys using postgis_srs_all or some other > > such thing or why don't we just change spatial_ref_sys to a view that > > relegates to reading

RE: Running clustering queries

2024-05-08 Thread Regina Obe
> > Which I can't find in our spatial_ref_sys table (guess our table needs > > an update), but you can add with the below as long as you are using > > PostGIS 2.5 or higher and PROJ 7 or higher, it's going to relegate all the > details to PROJ anyway So the other columns will not be needed except

Re: Running clustering queries

2024-05-08 Thread Daryl Herzmann
On Thu, Mar 28, 2024 at 9:05 AM Regina Obe wrote: > > > Depends where you got the data, but generally if they give you longitude > > latitude Columns, then 4326 is a safe assumption and looks like you created > > the geometry right too. > > > > To Gary's point, 4326 is degree based, so no wonder

Re: linear reference/dynamic segmentation

2024-05-08 Thread Bo Guo
Yes, Sergio! We use PostGIS LRS quite extensively, as reflected in some LRS-related videos https://www.youtube.com/linearbench. I am more than happy to have a screen session to share our experience with you. My email is: bo@gisticinc.com Bo On Wed, May 8, 2024 at 10:36 AM SERGIO

Re: linear reference/dynamic segmentation

2024-05-08 Thread SERGIO ACOSTAYLARA
Thank you Bo Guo. Did you use it? Do you know someone who uses it? Do you know of any use or success cases? 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/

Re: linear reference/dynamic segmentation

2024-05-08 Thread SERGIO ACOSTAYLARA
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

Re: linear reference/dynamic segmentation

2024-05-08 Thread Bo Guo
Yes, Sergio. Postgis has a complete and robust set of LRS functionalities. *Bo * On Wed, May 8, 2024 at 6:21 AM SERGIO ACOSTAYLARA < sergio.acostayl...@mtop.gub.uy> wrote: > Hi. Is there anybody in the list that has any experience using linear > reference/dynamic segmentation with postgis? We

RE: linear reference/dynamic segmentation

2024-05-08 Thread Regina Obe
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

linear reference/dynamic segmentation

2024-05-08 Thread SERGIO ACOSTAYLARA
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