Re: [postgis-users] Line within range of another line?

2016-11-01 Thread Ahmet Temiz
Thank you, it was great help. particularly your section worked well and helpful ( since I am going to create geojson outcome from this sql for web app): --- And I would think you would want one record per road so the union should be done after, so the below would make more sense. SELECT road.

[postgis-users] Bug in BRIN support for PostGIS datatypes

2016-11-01 Thread Giuseppe Broccolo
Hi, We have just found a bug involving the recently added BRIN support for PostGIS datatype. When new entries are added in an already indexed field, the stored bounding box is updated if necessary, but the change is not then logged into the WALs: the resulting in memory updated index continue to

Re: [postgis-users] Late to the party: upgrading F23->F24, PostgreSQL 9.4.9->9.5.4, PostGIS 2.1.8->2.2.1

2016-11-01 Thread Robert Burgholzer
I am in the midst of a similar migration right now, though I am going from 9.3 to 9.5, and my OS is CentOS 6. I too have had some troubles, and could not find a reference that actually worked for me on CentOS, although I had succeeded with a nearly identical migration on Ubuntu! In the end, the s