https://issues.qgis.org/https://issues.qgis.org/favicon.ico2013-07-21T04:53:54ZQGIS Issue TrackingQGIS Application - Bug report #8333: DB Manager's "Import vector layer"'s SRID confirmation dialog has unclear purposehttps://issues.qgis.org/issues/8333?journal_id=434142013-07-21T04:53:54ZAren Cambrearen@arencambre.com
<ul></ul><p>Here's the Shapefile: <a class="external" href="http://osmdata.thinkgeo.com/openstreetmap-data/north-america/us/texas.zip">http://osmdata.thinkgeo.com/openstreetmap-data/north-america/us/texas.zip</a></p> QGIS Application - Bug report #8333: DB Manager's "Import vector layer"'s SRID confirmation dialog has unclear purposehttps://issues.qgis.org/issues/8333?journal_id=434162013-07-21T04:57:35ZAren Cambrearen@arencambre.com
<ul></ul><p>Don't know if this matters, but it appears the projection is in fact in 4326 despite what <a class="external" href="http://wiki.openstreetmap.org/wiki/Mercator">http://wiki.openstreetmap.org/wiki/Mercator</a> says. The roads.prj file is identical to <a class="external" href="http://spatialreference.org/ref/epsg/4326/prj/">http://spatialreference.org/ref/epsg/4326/prj/</a>.</p> QGIS Application - Bug report #8333: DB Manager's "Import vector layer"'s SRID confirmation dialog has unclear purposehttps://issues.qgis.org/issues/8333?journal_id=434192013-07-21T06:40:44ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>Aren Cambre wrote:</p>
<blockquote>
<p>Don't know if this matters, but it appears the projection is in fact in 4326 despite what <a class="external" href="http://wiki.openstreetmap.org/wiki/Mercator">http://wiki.openstreetmap.org/wiki/Mercator</a> says. The roads.prj file is identical to <a class="external" href="http://spatialreference.org/ref/epsg/4326/prj/">http://spatialreference.org/ref/epsg/4326/prj/</a>.</p>
</blockquote>
<p>The shapefiles from OSM are in WGS84, not in google mercator.</p> QGIS Application - Bug report #8333: DB Manager's "Import vector layer"'s SRID confirmation dialog has unclear purposehttps://issues.qgis.org/issues/8333?journal_id=434202013-07-21T06:51:20ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>invalid</i></li></ul><p>Actually that "srid confirmation dialog" it seems that makes a lot of sense, in fact it shows when you choose an unknown (to qgis) SRID in the import vector layer dialog. In your case you are trying to use 900913, that does not exist anymore, as it has been replaced (as code) by 3857. But as I said, you should anyway choose WGS84 as input srid from your osm data.</p> QGIS Application - Bug report #8333: DB Manager's "Import vector layer"'s SRID confirmation dialog has unclear purposehttps://issues.qgis.org/issues/8333?journal_id=434242013-07-21T13:33:53ZAren Cambrearen@arencambre.com
<ul><li><strong>Resolution</strong> deleted (<del><i>invalid</i></del>)</li><li><strong>Status</strong> changed from <i>Closed</i> to <i>Reopened</i></li></ul><p>The problem is it doesn't tell me which of the two SRIDs is unknown.</p>
<p>Both SRIDs I entered were known to my PostGIS: 3081 is obviously known, and the query at <a class="external" href="http://wiki.openstreetmap.org/wiki/Mercator#PostGIS_.2F_SQL">http://wiki.openstreetmap.org/wiki/Mercator#PostGIS_.2F_SQL</a> to add 900913 failed with this because that SRID was already in the <strong>spatial_ref_sys</strong> table:</p>
<blockquote>
<p>ERROR: duplicate key value violates unique constraint "spatial_ref_sys_pkey" <br />DETAIL: Key (srid)=(900913) already exists.</p>
</blockquote>
<p><strong>UPDATE:</strong> Sorry, just saw that you mentioned that the SRID is unknown to QGIS. That's fine, but the problem remains that the GUI does not tell me which of the two SRIDs it is asking me about.</p> QGIS Application - Bug report #8333: DB Manager's "Import vector layer"'s SRID confirmation dialog has unclear purposehttps://issues.qgis.org/issues/8333?journal_id=434882013-07-22T05:19:23ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Operating System</strong> deleted (<del><i>Windows 7 x64</i></del>)</li><li><strong>Status</strong> changed from <i>Reopened</i> to <i>Feedback</i></li></ul><p>Aren Cambre wrote:</p>
<blockquote>
<p><strong>UPDATE:</strong> Sorry, just saw that you mentioned that the SRID is unknown to QGIS. That's fine, but the problem remains that the GUI does not tell me which of the two SRIDs it is asking me about.</p>
</blockquote>
<p>That's easy to understand, just enable one between source srid or target srid -> you will notice that the "srid confirmation dialog" will show only when the "source srid" is unknown to <strong>qgis</strong>. In this case the source srid will be applied also for the target srid.</p>
<p>If you enable just the target srid then if the srid is unknown to qgis then the original srid of the vector is applied (silently, and this is probably the real issue) for both the source and target srid.</p>
<p>If you agree to this description then the subject of this ticket should be rephrased. Not even sure if this can be considered a bug of the tool, maybe it would be just enough to add a not to the documentation.</p> QGIS Application - Bug report #8333: DB Manager's "Import vector layer"'s SRID confirmation dialog has unclear purposehttps://issues.qgis.org/issues/8333?journal_id=434902013-07-22T05:47:22ZAren Cambrearen@arencambre.com
<ul></ul><blockquote>
<p>the "srid confirmation dialog" will show only when the "source srid" is unknown to qgis.</p>
</blockquote>
<blockquote>
<p>if the srid is unknown to qgis then the original srid of the vector is applied</p>
</blockquote>
<p>The UI needs to explain both of these. That's why I filed as a bug: the UI is not informing the user of something that can be critical for the user to know.</p> QGIS Application - Bug report #8333: DB Manager's "Import vector layer"'s SRID confirmation dialog has unclear purposehttps://issues.qgis.org/issues/8333?journal_id=434912013-07-22T05:51:00ZPaolo Cavallinicavallini@faunalia.it
<ul></ul><p>Please suggest text for popup</p> QGIS Application - Bug report #8333: DB Manager's "Import vector layer"'s SRID confirmation dialog has unclear purposehttps://issues.qgis.org/issues/8333?journal_id=434962013-07-22T06:38:19ZAren Cambrearen@arencambre.com
<ul></ul><p>If qgis does not recognize <em>either</em> value, it should simply indicate that and request that a new value be entered. It also should not fill in target SRID with source SRID if target SRID is not understood.</p>
<p>Suggested text: <strong>QGIS does not understand the source SRID. Please choose from this list.</strong></p>
<p>(change <strong>source</strong> to <strong>target</strong> if the target SRID is not understood)</p>
<p>Note that I did not use "invalid". There appear to be valid SRIDs that QGIS does not understand, and QGIS not understanding something does not make it invalid.</p> QGIS Application - Bug report #8333: DB Manager's "Import vector layer"'s SRID confirmation dialog has unclear purposehttps://issues.qgis.org/issues/8333?journal_id=479732014-01-30T22:40:37ZPaolo Cavallinicavallini@faunalia.it
<ul><li><strong>Target version</strong> changed from <i>Version 2.0.0</i> to <i>Future Release - High Priority</i></li></ul> QGIS Application - Bug report #8333: DB Manager's "Import vector layer"'s SRID confirmation dialog has unclear purposehttps://issues.qgis.org/issues/8333?journal_id=528622014-06-21T12:43:52ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Open</i></li></ul> QGIS Application - Bug report #8333: DB Manager's "Import vector layer"'s SRID confirmation dialog has unclear purposehttps://issues.qgis.org/issues/8333?journal_id=785262017-04-30T23:09:16ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Regression?</strong> set to <i>No</i></li><li><strong>Easy fix?</strong> set to <i>No</i></li></ul> QGIS Application - Bug report #8333: DB Manager's "Import vector layer"'s SRID confirmation dialog has unclear purposehttps://issues.qgis.org/issues/8333?journal_id=1023762019-03-09T15:04:42ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Resolution</strong> set to <i>end of life</i></li><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</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>