[Qgis-user] Table joins - CSV data

[Lee]

I was using the wrong designation for the file. Much simpler when you use
the right one.

Thanks for the help.

On Wed, Jul 20, 2011 at 10:46 AM, Lee <muellerl at gmail.com> wrote:

> 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
>
>


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