[QGIS-trac] Re: [Quantum GIS] #121: join external tables to geometries

Quantum GIS qgis at qgis.org
Sat Nov 21 00:53:31 EST 2009


#121: join external tables to geometries
-----------------------------------------------------+----------------------
        Reporter:  mlennert at club.worldonline.be      |         Owner:               
            Type:  enhancement                       |        Status:  new          
        Priority:  major: does not work as expected  |     Milestone:  Version 1.4.0
       Component:  Data Provider                     |       Version:  HEAD         
      Resolution:                                    |      Keywords:               
Platform_version:                                    |      Platform:  All          
        Must_fix:  No                                |   Status_info:  0            
-----------------------------------------------------+----------------------
Comment (by wildintellect):

 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.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/121#comment:13>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats


More information about the QGIS-trac mailing list