https://issues.qgis.org/https://issues.qgis.org/favicon.ico2014-05-24T06:58:39ZQGIS Issue TrackingQGIS Application - Bug report #10335: PostGIS layers extent in QGIS vector metadata seems wronghttps://issues.qgis.org/issues/10335?journal_id=510232014-05-24T06:58:39ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Crashes QGIS or corrupts data</strong> set to <i>No</i></li><li><strong>Project</strong> changed from <i>78</i> to <i>QGIS Application</i></li><li><strong>Category</strong> deleted (<del><i>61</i></del>)</li><li><strong>Affected QGIS version</strong> set to <i>2.2.0</i></li></ul> QGIS Application - Bug report #10335: PostGIS layers extent in QGIS vector metadata seems wronghttps://issues.qgis.org/issues/10335?journal_id=510242014-05-24T07:01:50ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Resolution</strong> set to <i>invalid</i></li><li><strong>Affected QGIS version</strong> changed from <i>2.2.0</i> to <i>master</i></li><li><strong>Priority</strong> changed from <i>High</i> to <i>Normal</i></li><li><strong>Assignee</strong> deleted (<del><i>Victor Olaya</i></del>)</li><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li><li><strong>Category</strong> set to <i>44</i></li></ul><p>The same happens with the "original" tool, the one in the vector menu. But anyway there is no issue as the tool does exactly what is expected.</p>
<p>You can see in "vector properties -> metadata" that the same vector when imported in postgis has a slightly different extent, ex:</p>
<p>postgis:<br />xMin,yMin 1553648.00,4677080.50 : xMax,yMax 1772750.12,4926008.50</p>
<p>shape:<br />xMin,yMin 1554732.66,4678313.00 : xMax,yMax 1771665.41,4924775.96</p> QGIS Application - Bug report #10335: PostGIS layers extent in QGIS vector metadata seems wronghttps://issues.qgis.org/issues/10335?journal_id=510592014-05-25T12:42:09ZHarrissou Santanna
<ul><li><strong>Status</strong> changed from <i>Closed</i> to <i>Reopened</i></li></ul><p>Hi,<br />I understand what you say but you can't ignore that there's an issue somewhere. For the same data, you can't get two different extents.<br />And after checking, you'll see that the extent displayed by QGIS in the metadata is not the same you got in Postgis with an "select box2d(st_union(geom))". In my case, i have a table in Postgis whose extent in Postgis is <br />xMin,yMin 371168.64,6659251.65 : xMax,yMax 492180.20,6753998.33 (also displayed in DB Manager metadata).</p>
<p>When i open this table in QGIS (through DBManager), its extent displayed in "Properties > metadata" becomes <br />xMin,yMin 370563.56,6658778.00 : xMax,yMax 492785.28,6754472.00</p>
<p>When i save as shp this table, its extent is <br />xMin,yMin 371168.64,6659251.66 : xMax,yMax 492180.20,6753998.34, the same one I obtained in Postgis.</p>
<p>With "Polygon from layer Extent" on these layers, I obtain a layer that matches the information shown in Properties > metadata, that's why the geometries are different.</p>
<p>Reimporting the shp above into Postgis shows <br />xMin,yMin 371168.64,6659251.66 : xMax,yMax 492180.20,6753998.34 in DBManager.</p>
<p>It seems that when a postgis table is opened in QGIS, it doesn't get it's exact extent.</p> QGIS Application - Bug report #10335: PostGIS layers extent in QGIS vector metadata seems wronghttps://issues.qgis.org/issues/10335?journal_id=510972014-05-26T02:47:59ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Resolution</strong> deleted (<del><i>invalid</i></del>)</li><li><strong>Category</strong> changed from <i>44</i> to <i>Vectors</i></li></ul> QGIS Application - Bug report #10335: PostGIS layers extent in QGIS vector metadata seems wronghttps://issues.qgis.org/issues/10335?journal_id=510982014-05-26T02:48:58ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Subject</strong> changed from <i>Polygon from layer Extent : output doesn't match the bounding box of the postgis data</i> to <i>PostGIS layers extent in QGIS vector metadata seems wrong</i></li></ul> QGIS Application - Bug report #10335: PostGIS layers extent in QGIS vector metadata seems wronghttps://issues.qgis.org/issues/10335?journal_id=782932017-04-30T23:08:17ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Easy fix?</strong> set to <i>No</i></li><li><strong>Regression?</strong> set to <i>No</i></li></ul> QGIS Application - Bug report #10335: PostGIS layers extent in QGIS vector metadata seems wronghttps://issues.qgis.org/issues/10335?journal_id=1024182019-03-09T15:04:54ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Reopened</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>end of life</i></li></ul><p><strong>End of life notice: QGIS 2.18 LTR</strong>
<strong><br />Source:</strong><br /><a class="external" href="http://blog.qgis.org/2019/03/09/end-of-life-notice-qgis-2-18-ltr/">http://blog.qgis.org/2019/03/09/end-of-life-notice-qgis-2-18-ltr/</a></p>