[Qgis-user] Table joins - CSV data

Lee muellerl at gmail.com
Wed Jul 20 07:46:09 PDT 2011


The + sign on table join, will only show layers which are also polygon
shapefiles. It does not load, for my selection, additional files. So in this
case, the csv file does not show up.

On Wed, Jul 20, 2011 at 10:38 AM, Micha Silver <tsvibar at gmail.com> wrote:

> **
> On 07/20/2011 05:29 PM, Lee wrote:
>
> I have a shapefile of parcels in a city with 'ParcelNumb' as my target
> field. In an alternate CSV database I have addresses and ownership
> information with 'PARCELNUMB' as the target field. I want to join these two
> files based on the parcel number.
>
> My first thought was to load the CSV as a vector file, and do a table join
> based on parcel numbers. Unfortunately, the csv file will only load as a
> point file. When I try to do a join, it won't let me select the csv file, as
> it is points and not a polygon.
>
>
> You should be able (in 1.7) to load a CSV file as a table using the "Add
> Vector Layer" as you mentioned. THen, open the properties of your polygon
> layer, and there's a "Join" tab. Click the '+' sign to add a join, select
> the appropriate columns from the table and the polygon layer, and you should
> be good to go.
>
> My second thought was to try the MMQGIS plugin. In this case, each time I
> try to append the file it spits out an error claiming it could not find the
> field I was interested in. I tried changing the name in the fields to both
> read 'ParcelNumb' to no success.
>
> Any ideas, alternative solutions, or comments on my misuse?
>
> --
> all the best,
> Lee
>
>
> This mail was received via Mail-SeCure System.
>
>
> _______________________________________________
> Qgis-user mailing listQgis-user at lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/qgis-user
>
> This mail was received via Mail-SeCure System.
>
>
>
>
>
> --
> Micha Silver
> Arava Development Co. +972-52-3665918http://surfaces.co.il
>
>


-- 
all the best,
Lee
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20110720/b6656e27/attachment.html>


More information about the Qgis-user mailing list