darksabersan Posted October 1, 2019 Report Share Posted October 1, 2019 (edited) Hi guys, I have the most stupid question for you. From one layer with thousand of points and I have generated buffers. The thing is that I would like to select only the ones that didn't touch or intersect each other. https://imgur.com/a/QtCCD0V Postgis query would be great or any other solution. Thanks in advance for your help Edited October 1, 2019 by darksabersan Quote Link to comment Share on other sites More sharing options...
Reyalino Posted October 2, 2019 Report Share Posted October 2, 2019 This may help you: link Quote Link to comment Share on other sites More sharing options...
darksabersan Posted October 2, 2019 Author Report Share Posted October 2, 2019 (edited) 16 hours ago, Reyalino said: This may help you: link OK, thanks. I will have look to it. Today, I am also facing another issue. When running my buffer over my points, I am loosing all columns in my table. Here is my query: SELECT st_buffer(geom, 50) INTO gis_osm_pois_buf FROM gis_osm_pois; Is there any way to keep them into the new table ? Thanks ! Edited October 2, 2019 by darksabersan Quote Link to comment Share on other sites More sharing options...
Reyalino Posted October 4, 2019 Report Share Posted October 4, 2019 SELECT *, st_buffer(geom,50) as geom INTO gis_osm_pois_buf FROM gis_osm_pois; add * in your query to include all your fields. As your new geom field is came from the st_buffer named it a geom/geometry/the_geom or as you prefer. 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.