[postgis-users] error adding data into ArcGIS

Hello, All the sudden I am getting an error loading data into ArcGIS: One or more layers failed to draw: lyongis.public.parcels: The specified coordinate exceeds the valid coordinate range The script (below) that I used in the past always had worked fine. So I am not sure where to begin.

Re: [postgis-users] error adding data into ArcGIS

Mark, I ran into this recently, but can't remember what caused it. I will look back and see if I can remember. Maybe wrong SRS, null geometries? David On Jun 8, 2015, at 4:29 PM, Mark Volz markv...@co.lyon.mn.us wrote: Hello, All the sudden I am getting an error loading data into

[postgis-users] Problem creating a trigger using ST_Union?

Hi All, I'd like to create a trigger that will update the dissolve layer when there is any change on a polygon layer. I need a dissolve layer (big polygon) to get the boundary of all small polygons layer. But not able to get it successfully yet. My PGSQL trigger code is as below.

[postgis-users] Get only the main river. Smoothline???

Hi everyone, I have a multilinestring with a river and all its afluents as you can see in this image http://sigserver4.udg.edu/apps/geometries.png I got geometry A using St_StraithSkeleton. Is there a way to go from geometry A to geometry B?? Maybe something similar to SmoothLine??? --

Re: [postgis-users] Get only the main river. Smoothline???

if you have start and end point of geom B, you can get the river path with a shortest path method (one liner using python, can be done in few hours using plpgsql). The idea is that you cut your geom into segments(pairs of points) , the length of the segment is the weight of this edge , and you