"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
> "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
> > 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
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
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
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/
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
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
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 youll want to use
https://postgis.net/docs/en/ST_LineInterpolatePoints.html
Something like below will give you a point every 20
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
10 matches
Mail list logo