<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>RE: [Qgis-user] alternatives to join attributes</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>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?<BR>
<BR>
Thanks,<BR>
katie<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: David Fawcett [<A HREF="mailto:david.fawcett@gmail.com">mailto:david.fawcett@gmail.com</A>]<BR>
Sent: Thu 12/17/2009 9:57 AM<BR>
To: Carbonari, Katie (IS)<BR>
Cc: qgis-user@lists.osgeo.org<BR>
Subject: Re: [Qgis-user] alternatives to join attributes<BR>
<BR>
Have you thought about loading the data into PostGIS? You would load<BR>
the data into the db and then be able to query and display only the<BR>
data that you want at any time.<BR>
<BR>
David.<BR>
<BR>
On Thu, Dec 17, 2009 at 8:46 AM, Carbonari, Katie (IS)<BR>
<Katie.Carbonari@ngc.com> wrote:<BR>
> Good morning. I have a lot of data I need to visualize in QGIS (142 time<BR>
> steps, each with over 200,000 points). I need a way to quickly and easily<BR>
> load this data in QGIS. All of my data is in separate .csv files (one file<BR>
> per time step). I load each file via the csv plug-in and then use join<BR>
> attributes to connect my csv data to the polygon data that defines my grid.<BR>
> Join attributes takes forever (trying to do 4,000 points took an hour). Any<BR>
> one know of any other, faster way to do this? Or a way to speed up my join<BR>
> attributes? I know 200,000 points is a lot to ask and can easily cut that<BR>
> down a bit, but an hour to do 4000 points seems very slow. At that rate, it<BR>
> would take 3 weeks to load the entire time series into QGIS. I'm running the<BR>
> latest version of QGIS (Mimas) on a Mac OsX.<BR>
><BR>
> Thanks,<BR>
> Katie<BR>
><BR>
> _______________________________________________<BR>
> Qgis-user mailing list<BR>
> Qgis-user@lists.osgeo.org<BR>
> <A HREF="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</A><BR>
><BR>
><BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>