https://issues.qgis.org/https://issues.qgis.org/favicon.ico2006-05-19T08:09:29ZQGIS Issue TrackingQGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129312006-05-19T08:09:29Zanonymous -anonymous@foo.bar
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>In Progress</i></li></ul> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129322008-02-21T01:36:54ZMarkus Neteler
<ul></ul><p>I am also interested...</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129332008-02-26T15:58:47ZGiovanni Allegrigiohappy@gmail.com
<ul></ul><p>It's a wish coming from many collegues of mine. It would be useful to support join and then export to a new shapefile with the enlarged attributes table.</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129342008-03-12T15:17:41ZJürgen Fischerjef@norbit.de
<ul><li><strong>Status</strong> changed from <i>In Progress</i> to <i>Open</i></li></ul> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129352008-07-14T00:23:37ZTim Suttontim@linfiniti.com
<ul></ul><p>On second thoughts this is probably handled using the enhancement type and not a fake milestone. Returning to 1.0.1 milestone, please ignore last milestone change</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129362008-09-12T20:35:15ZPaolo Cavallinicavallini@faunalia.it
<ul></ul><p>This is available through a plugin by Carson Farmer <a class="external" href="http://www.geog.uvic.ca/spar/carson/cfarmerQgisRepo.xml">http://www.geog.uvic.ca/spar/carson/cfarmerQgisRepo.xml</a><br />It must be upgraded to 1.0 API though</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129372008-09-13T00:55:45Zmlennert -mlennert@foo.bar
<ul></ul><p>Replying to [comment:9 pcav]:</p>
<blockquote>
<p>This is available through a plugin by Carson Farmer <a class="external" href="http://www.geog.uvic.ca/spar/carson/cfarmerQgisRepo.xml">http://www.geog.uvic.ca/spar/carson/cfarmerQgisRepo.xml</a><br />It must be upgraded to 1.0 API though</p>
</blockquote>
<p>This is already a good start, but IIUC, it creates a new shapefile everytime to join some data. Not really ideal IMHO. Would be nice to have this more 'on-the-fly', i.e. that you can join data from another data source (dbf, RDBMS, etc) to your map within the project, without creating any new files.</p>
<p>Moritz</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129382009-11-20T20:53:24ZAlex Mandeltech@wildintellect.com
<ul></ul><p>It just occurred to me that I might know any easy(relatively) fast way to do this. If every vector layer attribute table when loaded, queried or joined (last 2 might be best) was loaded to an in::memory sqlite database. Then we could just use sqlite syntax for doing table joins. These wouldn't be persistent unless we recorded them in the project file on save (which could be done) but they would be really fast to query and would provide robust left, and inner joining. Note, I'm specifically only talking about the attribute tables which should make it easier.</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129392009-11-22T12:45:33Zmlennert -mlennert@foo.bar
<ul></ul><p>Replying to [comment:13 wildintellect]:</p>
<blockquote>
<p>It just occurred to me that I might know any easy(relatively) fast way to do this. If every vector layer attribute table when loaded, queried or joined (last 2 might be best) was loaded to an in::memory sqlite database. Then we could just use sqlite syntax for doing table joins. These wouldn't be persistent unless we recorded them in the project file on save (which could be done) but they would be really fast to query and would provide robust left, and inner joining. Note, I'm specifically only talking about the attribute tables which should make it easier.</p>
</blockquote>
<p>Sounds interesting. But why limit this to attribute tables only ? I would think that the general use case is linking an attribute table to another table, not linking two attribute tables.</p>
<p>Moritz</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129402011-03-02T07:07:53ZPaolo Cavallinicavallini@faunalia.it
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>fixed</i></li></ul><p>Table join now added in trunk. Please test.</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129412011-03-03T05:56:49Zmlennert -mlennert@foo.bar
<ul></ul><p>Replying to [comment:18 pcav]:</p>
<blockquote>
<p>Table join now added in trunk. Please test.</p>
</blockquote>
<p>I imagine that this is the Joins tab in the layer properties ?</p>
<p>A (very) quick test shows it works nicely, but we'll have to test it more thoroughly.</p>
<p>However, as I said in an earlier comment: what we are really looking for is the possibility of joining a layer attribute table to other data tables, not (only) to other layer attribute data tables. And IIUC, it is impossible at this stage to import a simple data table (e.g. dbf or csv) without geometries, and then join it to an existing layer attribute table, or ?</p>
<p>Moritz</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129422011-03-03T07:25:57ZMarco Hugentoblermarco.hugentobler@sourcepole.ch
<ul></ul><p>It is possible to load geometryless tables. This includes dbfs and csvs via OGR (set Filter to 'all Files' in the dialog) as well as <a class="wiki-page new" href="https://issues.qgis.org/projects/qgis/wiki/PostGIS">PostGIS</a> tables without geometry (select the option to show geometryless tables in the postgres connection settings).</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129432011-03-07T01:21:19Zmlennert -mlennert@foo.bar
<ul><li><strong>Status</strong> changed from <i>Closed</i> to <i>Feedback</i></li><li><strong>Resolution</strong> deleted (<del><i>fixed</i></del>)</li></ul><p>Replying to [comment:20 mhugent]:</p>
<blockquote>
<p>It is possible to load geometryless tables. This includes dbfs and csvs via OGR (set Filter to 'all Files' in the dialog) as well as <a class="wiki-page new" href="https://issues.qgis.org/projects/qgis/wiki/PostGIS">PostGIS</a> tables without geometry (select the option to show geometryless tables in the postgres connection settings).</p>
</blockquote>
<p>Cool, never realised this was possible !</p>
<p>However, the join seems to fail once you try to map data:</p>
<p>1) Load a shape and a dbf file</p>
<p>2) Join the dbf to the shapefile attribute table</p>
<p>3) Go to symbology of shapefile and try to make graduated colors based on a joined attribute<br />=> all attribute values are set to NULL</p>
<p>Better than words: <a href="http://geog-pc40.ulb.ac.be/qgis/demo_join.gif" class="external">http://geog-pc40.ulb.ac.be/qgis/demo_join.gif</a>. In the test, I use a modified version of the censusblk_swwake file from the grass book demo data: <a href="http://www.grassbook.org/data_menu3rd.php" class="external">http://www.grassbook.org/data_menu3rd.php</a>. I copied the censusblk_swwake.dbf to censusblk_data.dbf and erased most attributes from censusblk_swwake.dbf via OObase. I'll attach the files here.</p>
<p>Reopening the bug for now...</p>
<p>Moritz</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129442011-03-07T01:24:02Zmlennert -mlennert@foo.bar
<ul></ul><p>Replying to [comment:21 mlennert]:</p>
<blockquote>
<p>I copied the censusblk_swwake.dbf to censusblk_data.dbf and erased most attributes from censusblk_swwake.dbf via OObase. I'll attach the files here.</p>
</blockquote>
<p>Actually too big to attach, so here it is:</p>
<p><a href="http://geog-pc40.ulb.ac.be/qgis/demo_data.zip" class="external">http://geog-pc40.ulb.ac.be/qgis/demo_data.zip</a></p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129452011-03-07T04:08:38ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><blockquote>
<p>However, as I said in an earlier comment: what we are really looking for is the possibility of joining a layer attribute table to other data tables, not (only) to other layer attribute data tables. And IIUC, it is impossible at this stage to import a simple data table (e.g. dbf or csv) without geometries, and then join it to an existing layer attribute table, or ?</p>
</blockquote>
<p>I agree, the new Join implementation to e complete needs to allow Join also external data tables (dbf, as ftools already does, csv, etc.). It works already fine with geometryless postgres tables.</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129462011-03-07T04:09:52ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>Replying to [comment:20 mhugent]:</p>
<blockquote>
<p>It is possible to load geometryless tables. This includes dbfs and csvs via OGR (set Filter to 'all Files' in the dialog) as well as <a class="wiki-page new" href="https://issues.qgis.org/projects/qgis/wiki/PostGIS">PostGIS</a> tables without geometry (select the option to show geometryless tables in the postgres connection settings).</p>
</blockquote>
<p>sorry, I didn't see this either (I'm browsing the trac mailing lists mails...).</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129472011-03-08T07:33:44ZMarco Hugentoblermarco.hugentobler@sourcepole.ch
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>fixed</i></li></ul><p>Thank you for the good example data. The issue should be fixed with .</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129482011-03-10T06:28:09Zmlennert -mlennert@foo.bar
<ul><li><strong>Status</strong> changed from <i>Closed</i> to <i>Feedback</i></li><li><strong>Resolution</strong> deleted (<del><i>fixed</i></del>)</li></ul><p>Replying to [comment:25 mhugent]:</p>
<blockquote>
<p>Thank you for the good example data. The issue should be fixed with .</p>
</blockquote>
<p>Yes, great !</p>
<p>However, I've found another issue:</p>
<p>1) Load a shape and a dbf file (e.g. the attached demo data)<br />2) Join the two<br />3) Save the project<br />4) Close QGIS<br />5) Open QGIS<br />6) Load project</p>
<p>=> The join is still active. Perfect !</p>
<p>But:</p>
<p>1) Load a shape and a dbf file (e.g. the attached demo data)<br />2) Join the two<br />3) Map an indicator using Graduated symbol (e.g. Median age)<br />4) Save the project<br />5) Close QGIS<br />6) Open QGIS<br />7) Load project</p>
<p>=> "Handle bad layers" window opens, but I just can't get the shape file to load anymore</p>
<p>This only happens when I use the old symbology, not the new.</p>
<p>Reopening the bug as I believe that this is an integrate part of the feature that needs to work.<br />Feel free to close again if you don't believe so.</p>
<p>Moritz</p> QGIS Application - Feature request #121: join external tables to geometrieshttps://issues.qgis.org/issues/121?journal_id=129492011-03-12T06:49:12ZMarco Hugentoblermarco.hugentobler@sourcepole.ch
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>fixed</i></li></ul><p>The old symbology issue should be fixed in <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/489e34bc705931a8e7edbc572591ffa61f24e523" title="Fix loading of joined layers with old symbology, #121 git-svn-id: http://svn.osgeo.org/qgis/trun...">489e34bc</a> (SVN r15451). Please reopen the ticket in case of further problems.</p>