Re: [postgis-users] PostGIS case usages

2018-10-31 Thread Garret W
I just wanted to give my vote to some of the great ideas/projects that other people have all ready posted, that I would love to read more about. - stealing some data from some web endpoint - Anything dealing with using python to interact with your database is great. - line and parcel topology -

[postgis-users] auto update tables of a view with instead of trigger

2018-02-08 Thread Garret W
Hi guys, I know this is the postgis list, but I thought many of you might be able to help me out. Im trying to update my tables thru the views I've created using triggers. Most views contain 3 tables or more, so do not update without the use of a trigger. This would make it easier for my team to

Re: [postgis-users] topology - topogeo_id <> mylayer.mypk

2016-05-31 Thread Garret W
Ahh. I see. Then you very much for the help and clarification. Garret On May 31, 2016 3:31 AM, "Sandro Santilli" <s...@kbt.io> wrote: > On Mon, May 30, 2016 at 10:33:07PM -0500, Garret W wrote: > > > What I dont understand is why in some cases the relations

Re: [postgis-users] topology - topogeo_id <> mylayer.mypk

2016-05-27 Thread Garret W
geometry worked using the select statement above (the one from stackexchange). Hopefully that all makes sense. Garret On Fri, May 27, 2016 at 3:13 PM, Sandro Santilli <s...@kbt.io> wrote: > On Fri, May 27, 2016 at 02:34:24PM -0500, Garret W wrote: > > > After creating a topo

[postgis-users] split line at polygon edge

2016-03-19 Thread Garret W
Hi Ive been looking for a way to take several hundred lines and split them where they intersect a polygon while also giving them the ID of the polygon they fall in. Ive seen many posts on splitting polygons. But its been difficult for me to adapt those examples. Ive been able to get an output

Re: [postgis-users] split line at polygon edge

2016-03-19 Thread Garret W
with the result of your query using ST_Difference(). >> >> >> >> Regards, >> >> >> >> Hugues. >> >> >> >> *De :* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *De >> la part de* Garret W >> *Envoyé :* jeu