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

[Quantum GIS]

#121: join external tables to geometries
-----------------------------------------------------+----------------------
        Reporter:  mlennert@…                        |         Owner:               
            Type:  enhancement                       |        Status:  reopened     
        Priority:  major: does not work as expected  |     Milestone:  Version 1.6.0
       Component:  Data Provider                     |       Version:  Trunk        
      Resolution:                                    |      Keywords:               
Platform_version:                                    |      Platform:  All          
        Must_fix:  No                                |   Status_info:  0            
-----------------------------------------------------+----------------------
Changes (by mlennert):

  * status:  closed => reopened
  * resolution:  fixed =>


Comment:

 Replying to [comment:20 mhugent]:
 > 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 PostGIS
 tables without geometry (select the option to show geometryless tables in
 the postgres connection settings).

 Cool, never realised this was possible !

 However, the join seems to fail once you try to map data:[[BR]]


 1) Load a shape and a dbf file[[BR]]

 2) Join the dbf to the shapefile attribute table[[BR]]

 3) Go to symbology of shapefile and try to make graduated colors based on
 a joined attribute
 => all attribute values are set to NULL[[BR]]


 Better than words: [http://geog-pc40.ulb.ac.be/qgis/demo_join.gif http
 ://geog-pc40.ulb.ac.be/qgis/demo_join.gif]. In the test, I use a modified
 version of the censusblk_swwake file from the grass book demo data:
 [http://www.grassbook.org/data_menu3rd.php
 http://www.grassbook.org/data_menu3rd.php]. 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.

 Reopening the bug for now...

 Moritz

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