[QGIS-trac] Re: [Quantum GIS] #121: join external tables to
geometries
Quantum GIS
qgis at qgis.org
Sun Nov 22 16:45:35 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 mlennert):
Replying to [comment:13 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.
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.
Moritz
--
Ticket URL: <https://trac.osgeo.org/qgis/ticket/121#comment:15>
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