Hi Nicolas,

It is a table join. The common field is the name of the local government area 
(city/shire). They are common in both tables. I just noticed that one is in 
caps and the other isn't. I will try putting both the same case and see how 
that goes.

Phillip


Date: Wed, 20 Jul 2016 22:08:55 -0700
From: nicolas.cadi...@archeotec.ca
To: qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] Joining csv and shape files in QGIS

Hi,
I imagine you are doing a join using the local government field or is this a 
spacial join?
I imagine you are using a field.  Would you have an extra space before the 
commas?  That would through things off.
Try loading the shapefile and the csv data without the join?  Then, copy a 
government value from the shapefile then try to find it using a query or a 
filter in the csv.  If you know it's there and can't find it, then you could 
have a character or something throwing off the join.
Is the gov field a unique value field?
Nicolas 





On Jul 21, 2016 12:30 AM, "Phillip Money [via OSGeo.org]" <[hidden email]> 
wrote:


        


I am trying to join a csv file and shp file in QGIS. They both have common 
fields. I have imported the CSV file properly. It has two fields, a name (local 
government area) and an integer (total complaints per area). I have checked the 
properties in QGIS and they show string and int.

I want to display total complaints per local government area on a map When I 
join the CSV and shp files, I get null values under the total complaints field. 
I have tried lots of things, but without success so far.

Any help would be appreciated.

Phillip Money


                                          

_______________________________________________

Qgis-user mailing list

<a 
href="/user/SendEmail.jtp?type&#61;node&amp;node&#61;5277479&amp;i&#61;0">[hidden
 email]

List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

        
        
        
        

        

        
        
                If you reply to this email, your message will be added to the 
discussion below:
                
http://osgeo-org.1560.x6.nabble.com/Joining-csv-and-shape-files-in-QGIS-tp5277479.html
        
        
                To start a new topic under Quantum GIS - User, email 
ml-node+s1560n4125267...@n6.nabble.com 

                To unsubscribe from Quantum GIS - User, <a 
href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro&#61;unsubscribe_by_code&amp;node&#61;4125267&amp;code&#61;bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg&#61;&#61;";>click
 here.

                <a 
href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro&#61;macro_viewer&amp;id&#61;instant_html%21nabble%3Aemail.naml&amp;base&#61;nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&amp;breadcrumbs&#61;notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml";
 style="font:9px serif">NAML
        


        
        
        


View this message in context: Re: Joining csv and shape files in QGIS

Sent from the Quantum GIS - User mailing list archive at Nabble.com.

_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user                  
                  
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to