<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<title>RE: [Qgis-user] alternatives to join attributes</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#17771C;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#17771C'>Katie,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#17771C'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#17771C'>Your
foray into PostgreSQL and PostGIS will not be wasted if you plan to do more GIS
in the future. Even if you do it only for this project, it should help
you tremendously. I routinely plot 7K+ unique points as a PostGIS layer using
QGIS and the time to plot them is almost instantaneous. Furthermore, a
whole world of spatial capabilities will open to you with all of the PostGIS
functions available to do analysis on your data. I do have an iMac (at
work), but I run my setup on a Kubuntu machine (at home) so I might be able to
help you a little bit there.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#17771C'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#17771C'>Start
by installing PostgreSQL and getting some familiarity with it. It will
help if you know SQL and have worked with databases before (they are all
essentially the same from a user POV). The desktop tool pgAdmin will help
you guify PostgreSQL a bit, but you'll still need to do a few things manually
or from the command line. I checked and there is a Mac OS port for pgAdmin.
(I prefer using phpPgAdmin, but it would require that you have a web server and
PHP installed on your Mac.)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#17771C'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#17771C'>Good
luck!<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#17771C'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#17771C'>B<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#17771C'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#17771C'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#17771C'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
qgis-user-bounces@lists.osgeo.org [mailto:qgis-user-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Carbonari, Katie (IS)<br>
<b>Sent:</b> Thursday, December 17, 2009 9:11 AM<br>
<b>To:</b> David Fawcett<br>
<b>Cc:</b> qgis-user@lists.osgeo.org<br>
<b>Subject:</b> RE: [Qgis-user] alternatives to join attributes<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p style='margin-bottom:12.0pt'><span style='font-size:10.0pt'>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>
></span><o:p></o:p></p>
</div>
</body>
</html>