[Qgis-user] alternatives to join attributes

[Scott Rollins]

Further to the same question: is there a really good "PostGIS for Dummies"
type of explanation of how to get information into a PostGIS database?
Google's bringing up some hits, but not one good reference that has the
information I'm looking for.

Scott

On Thu, Dec 17, 2009 at 10:10 AM, Carbonari, Katie (IS) <
Katie.Carbonari at ngc.com> wrote:

>  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<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
> >
> >
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>


-- 
Scott Rollins, Virginia Beach, VA
<organist at gmail.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20091217/13662af5/attachment.html>