Re: [postgis-users] Upgrade 12->13 stuck due to postgis / raster issue

2023-01-23 Thread Roxanne Reid-Bennett
Jim, I did a search on this phrase: raster procs from "2.5.2 r17328" need upgrade I found a post from Regina from 2020 moving from 2.5.2 to 3. It might illumine a bit. https://lists.osgeo.org/pipermail/postgis-users/2020-May/044225.html And this one for someone who had 100%

Re: [postgis-users] Help with ST_Within query issue...

2023-01-11 Thread Roxanne Reid-Bennett
We upgraded AWS RDS hosted 9.3 or something like that to 12. If you are on AWS - I can give you pointers to get thru with. They may or may not help in another environment- so private messaging. Roxanne Just another DBA/dev… Sent from my iPhone > On Jan 11, 2023, at 2:08 PM, Jeffrey Peacock

Re: [postgis-users] PostGIS case usages

2018-11-04 Thread Roxanne Reid-Bennett
We've used PostGIS to support agriculture for the last 7 years. Our use cases are pretty straight forward * ST_Intersects, Union for Polygons and  MultiPolygons * Generation of Poly's from Area around Linestrings * Generation of Poly's from Area around Points turned into a Unioned Poly *

Re: [postgis-users] Help with SQL query?

2015-11-23 Thread Roxanne Reid-Bennett
On 11/23/2015 12:41 PM, Darrel Maddy wrote: Dear Pierre, I was not looking for a total solution and I am grateful for the suggestion. Although it may not look like it, I did consult the documentation and also I have Regina’s book beside me. Unfortunately, for me at least, both documents

Re: [postgis-users] TopologyException: geom is invalid

2015-02-26 Thread Roxanne Reid-Bennett
On 2/26/2015 1:40 PM, Joseph Spenner wrote: I ran the following against all 4 of my GeoJSON files: SELECT ST_IsSimple(ST_GeomFromGeoJSON('@poly')) SELECT ST_IsValid(ST_GeomFromGeoJSON('@poly')) SELECT ST_IsValidDetail(ST_GeomFromGeoJSON('@poly')) SELECT

Re: [postgis-users] TopologyException: geom is invalid

2015-02-26 Thread Roxanne Reid-Bennett
*From:* Roxanne Reid-Bennett r...@tara-lu.com *To:* postgis-users@lists.osgeo.org *Sent:* Thursday, February 26, 2015 1:16 PM *Subject:* Re: [postgis-users] TopologyException: geom is invalid On 2/26/2015 1:40 PM, Joseph Spenner wrote: I ran the following against all

Re: [postgis-users] Creating trajectory/lines from millions of points[PostGIS]

2014-11-25 Thread Roxanne Reid-Bennett
On 11/25/2014 11:48 AM, Oliver Burgfeld wrote: I also tried that and it works but it does not give me those two columns in my new table. There are only id and status inside. From the quer below change SELECT id, status, (ST_Dump(mylines)).geom to SELECT id, status, (ST_Dump(mylines)).geom,

Re: [postgis-users] polygons to linestrings

2014-05-25 Thread Roxanne Reid-Bennett
On 5/24/2014 7:04 PM, Richard Greenwood wrote: @Roxanne, thanks for your interest in my problem, sorry that I didn't explain better. When you draw polygon layers with dashed or dotted line styles they can look very bad because lines from adjacent polygons are drawn over top of each other and

Re: [postgis-users] polygons to linestrings

2014-05-22 Thread Roxanne Reid-Bennett
On 5/22/2014 12:28 PM, Richard Greenwood wrote: I have a polygon table that I want to convert to linestrings without any duplicated (overlapping) linestrings. I'm doing this simply to improve cartography so I'm looking for a quick and dirty approach, avoiding topology if possible. I'm not