https://issues.qgis.org/https://issues.qgis.org/favicon.ico2018-02-03T22:41:56ZQGIS Issue TrackingQGIS Application - Bug report #18038: Select by Location not working when data is in PostGIShttps://issues.qgis.org/issues/18038?journal_id=865222018-02-03T22:41:56ZNyall Dawson
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>Do you have issues with any other selection by location tools and this layer? E.g. using the "select by polygon" map tool? Maybe there's a spatial index error in the layer.</p> QGIS Application - Bug report #18038: Select by Location not working when data is in PostGIShttps://issues.qgis.org/issues/18038?journal_id=865272018-02-04T14:29:34ZRandal Halerjhale@northrivergeographic.com
<ul></ul><p>So I did a few other tests. Apologies - I didn't see your reply until this morning.</p>
<ul>
<li>Select by polygon 'lasso' works fine. </li>
<li>I rebuilt the index on the buildings layer and the estates layer - same result as before . </li>
<li>Went to a different database I hadn't touched in a while and did the same "select by location" exercise and same result (polygon selecting points - still had a very short runtime also - .07 seconds - nothing selected (with an easier to deal with projection EPSG:2274)). </li>
<li>ran a st_within from dbmanager and that worked.</li>
</ul>
<p>It could be on my end - I'm not an export on Postgis by any stretch and I could have something set up wrong. I don't think I do - but I defer to someone higher up on the foodchain.</p>
<p>Let me get qgis 2.99 installed on my windows 10 box and I'll test it against the database.</p> QGIS Application - Bug report #18038: Select by Location not working when data is in PostGIShttps://issues.qgis.org/issues/18038?journal_id=868342018-02-16T05:34:00ZTudor Bărăscutudorbarascu@yahoo.com
<ul></ul><p>Indeed, I'm also getting this.<br />I have a point and a polygon layer and I'm trying to select all points from a specific polygon.<br />Nothing is selected. Debian Buster, latest master.</p> QGIS Application - Bug report #18038: Select by Location not working when data is in PostGIShttps://issues.qgis.org/issues/18038?journal_id=868452018-02-17T05:57:08Zgoogle feudfeudproject@gmail.com
<ul></ul><p>classic MapQuest driving directions, Route Planner, mileage Driving is the easiest and most efficient way to travel between two points – but only if you're really good with directions. Most of us aren't and thus end up circling around the neighborhood or lost in the countryside. Luckily, with Google driving directions getting lost is no longer an option. Apart from showing you the exact classic MapQuest driving directions, Route Planner, mileage mapping category, recently announced the relaunch of its popular Route Planner, a patented technology that simplifies the process of creating, optimizing and manipulating complex routes with multiple stops classic MapQuest driving directions, Route Planner, mileage <a href="https://www.map-quest.co/" class="external">mapquest</a></p> QGIS Application - Bug report #18038: Select by Location not working when data is in PostGIShttps://issues.qgis.org/issues/18038?journal_id=891592018-04-09T00:41:22ZRandal Halerjhale@northrivergeographic.com
<ul></ul><p>I went back and did some more testing. If I run the test with the current 2.18.17 (windows/linux) it works fine - select by location performs as intended. On 3.0.1 (windows/linux) it doesn't return anything buyt doesn't produce an error. If the dataset is removed from postgis and moved to geopackage it performs as intended on 3.0.1</p> QGIS Application - Bug report #18038: Select by Location not working when data is in PostGIShttps://issues.qgis.org/issues/18038?journal_id=891602018-04-09T00:52:18ZNyall Dawson
<ul></ul><p>Can you provide a sql dump of the postgis tables used?</p> QGIS Application - Bug report #18038: Select by Location not working when data is in PostGIShttps://issues.qgis.org/issues/18038?journal_id=891782018-04-10T01:09:30ZRandal Halerjhale@northrivergeographic.com
<ul><li><strong>File</strong> <a href="/attachments/download/12588/test.sql">test.sql</a> added</li></ul><p>OK - finally got a file to upload. I had to use some stuff that wasn't client sensitive. The data was something I made - it's in EPSG:2274. I dumped from my database by pg_dump -h computer -d testnrgs > test.sql. You should be able to psql -d database -f test.sql. I did test with qgis 2.18 and qgis 3.0 and I hope (I mean I don't hope) you find the select by location doesn't quite work right.</p> QGIS Application - Bug report #18038: Select by Location not working when data is in PostGIShttps://issues.qgis.org/issues/18038?journal_id=891802018-04-10T05:53:05ZNyall Dawson
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>In Progress</i></li><li><strong>Assignee</strong> changed from <i>Victor Olaya</i> to <i>Nyall Dawson</i></li></ul> QGIS Application - Bug report #18038: Select by Location not working when data is in PostGIShttps://issues.qgis.org/issues/18038?journal_id=891812018-04-10T05:57:56ZNyall Dawson
<ul><li><strong>Pull Request or Patch supplied</strong> changed from <i>No</i> to <i>Yes</i></li></ul><p><a class="external" href="https://github.com/qgis/QGIS/pull/6775">https://github.com/qgis/QGIS/pull/6775</a></p> QGIS Application - Bug report #18038: Select by Location not working when data is in PostGIShttps://issues.qgis.org/issues/18038?journal_id=891822018-04-10T06:55:20ZNyall Dawson
<ul><li><strong>% Done</strong> changed from <i>0</i> to <i>100</i></li><li><strong>Status</strong> changed from <i>In Progress</i> to <i>Closed</i></li></ul><p>Applied in changeset <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/1357a4716ab14168c72a7ba1d41685f6dea11877" title="[processing] Fix Select/Extract by Location algs with PostGIS layers Fixes #18038">qgis|1357a4716ab14168c72a7ba1d41685f6dea11877</a>.</p>