[Qgis-user] alternatives to join attributes

[Carbonari, Katie (IS)]

I tried doing that at one point, but I've never used databases before and didn't get how to include them into QGIS. I tried going under "Add PostGIS Table" but wasn't really sure how to connect to my database. I have my dbf files stored locally on my machine, yet the gui wants me to make a "PostgreSQL Connection"; what exactly is that and is there a more simple way to access my dbf files? 

Thanks,
katie


-----Original Message-----
From: David Fawcett [mailto:david.fawcett at gmail.com]
Sent: Thu 12/17/2009 9:57 AM
To: Carbonari, Katie (IS)
Cc: qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] alternatives to join attributes
 
Have you thought about loading the data into PostGIS?  You would load
the data into the db and then be able to query and display only the
data that you want at any time.

David.

On Thu, Dec 17, 2009 at 8:46 AM, Carbonari, Katie (IS)
<Katie.Carbonari at ngc.com> wrote:
> Good morning. I have a lot of data I need to visualize in QGIS (142 time
> steps, each with over 200,000 points). I need a way to quickly and easily
> load this data in QGIS. All of my data is in separate .csv files (one file
> per time step). I load each file via the csv plug-in and then use join
> attributes to connect my csv data to the polygon data that defines my grid.
> Join attributes takes forever (trying to do 4,000 points took an hour). Any
> one know of any other, faster way to do this? Or a way to speed up my join
> attributes? I know 200,000 points is a lot to ask and can easily cut that
> down a bit, but an hour to do 4000 points seems very slow. At that rate, it
> would take 3 weeks to load the entire time series into QGIS. I'm running the
> latest version of QGIS (Mimas) on a Mac OsX.
>
> Thanks,
> Katie
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20091217/53dfc38d/attachment.html>