<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
1. I tried doing this with Join Attributes and selecting the CSV file.<br>
However I found that when QGIS reads in the CSV file, it casts all of<br>
the columns as Text, so I couldn't use the numerical values. I notice<br>
the Join Attributes from CSV feature is new in QGIS 1.5.0. Maybe there<br>
is a bug?<br>
<br>
</blockquote>
<br>
you can do Joins with dbf tables. New join features are being developed.<br>
<br>
<br>
</blockquote></div>
In case you're using Excel 2007, you no longer have support for the (important) dbf format. So get a copy of Openoffice.org and use that to export your tables to dbf. Then number columns will stay as numbers for the import to QGIS.<br>
If there's any problem with the numbers being exported as text, then rewrite the column headers in the Excel (OOo Calc) to explicitly make them numbers in dbf format. For example a column header like:<br>
Value,N,10<br>
will force the dbf column to be numeric with 10 digits.</blockquote><div><br></div><div>I am indeed using Excel 2007 and I am hoping for a workflow that goes directly from Excel to GIS since I do that very often. I tried the "Value,N,10" trick you describe above but I get an error that the field name is longer than 10 characters. I assume the CSV table join feature will be fixed in the next release of QGIS. Is there a way to report and track a bug like this?</div>
<div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
2. Eventually I will want to put my data into a database. I notice I<br>
can choose between SpatiaLite and PostGIS. Which is easier to use? Is<br>
there a performance difference?<br>
<br>
</blockquote>
<br>
among the others, Postgis is an extension of PostgreSQL, so is server<br>
based, spatialite is file based.<br>
<br>
<br>
</blockquote></div>
In addition, Spatialite is easy. PostGIS will perform better on huge tables.</blockquote><div><br></div><div>Thanks for your comments, I am going to try spatialite for now, but I might switch if my files get bigger.</div>
<div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
3. In ArcMap, I frequently used the capability to vary the thickness<br>
of line features according to a value in the attribute table. I notice<br>
that this capability is available in QGIS only for points ("drawing by<br>
field") but not for line features. Is there another way to accomplish<br>
variable thickness lines in QGIS? If not, is "drawing by field" for<br>
line features under development?<br>
<br>
</blockquote>
new symbology -> advanced -> size scale field<br>
<br>
<br>
</blockquote></div>
I can't seem to get this to work (1.5 on Ubuntu 10.04).<br></blockquote><div><br></div><div>It didn't work for me either (1.5.0 Windows 7 x64)</div><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
What you can do is categorize the lines then manually give each a different line width. In the Old Symbology, choose "Graduated symbol", select the line width column and click Classify. Then change the width of each line. Or, Using the "New Symbology" , choose "Classified", then again select the column and click Classify. Then double click on each symbol to change its width.<br>
</blockquote><div> </div><div>Yes I have tried this and it is very tedious, but sort of works. Not really the solution I was hoping for.</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Regards,<br>
Micha<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
cheers<br>
<br>
-- Giovanni --<br><br></blockquote></blockquote><div>I really appreciate you guys taking the time to think about my questions and I look forward to seeing continued development of QGIS.</div><div><br></div><div>Shalom and Ciao,</div>
<div><br></div><div>Mike</div><div> </div></div>
<html>
<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<table border="0" width="50%">
<tr>
<td width="628" colspan="2">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; ">
<span class="Apple-style-span" style="border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px; ">
<p class="MsoNormal" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">
<b><font size="3" color="blue" face="Arial">
<span style="font-size: 12pt; font-family: Arial; color: blue; font-weight: bold; ">
<a href="http://www.ascendworldwide.com/formula1/">Ascend</a></span></font><font color="blue" face="Arial"><a href="http://www.ascendworldwide.com/formula1/"><span style="font-family: Arial; color: blue; font-weight: bold; "><span class="Apple-converted-space"> </span>-
In partnership with Virgin Racing</span></a></font></b></p>
</span></span></td>
</tr>
<tr>
<td width="143"><font face="Arial">
<a moz-do-not-send="true" href="http://www.ascendworldwide.com/community.html">
<img moz-do-not-send="true" alt="" src="http://www.ascendworldwide.com/content/aviation2020-sig-icon.jpg" class="style65" width="42" height="42" border="0"></a><a moz-do-not-send="true" href="http://twitter.com/AscendAviation/"><img moz-do-not-send="true" alt="" src="http://www.ascendworldwide.com/content/twitter-sig-icon.jpg" class="style65" width="42" height="42" border="0"></a><a moz-do-not-send="true" href="http://www.linkedin.com/groups?gid=150064"><img moz-do-not-send="true" alt="" src="http://www.ascendworldwidecom/content/linkedin-sig-icon.jpg" class="style65" width="42" height="42" border="0"></a></font><p>
<font face="Arial" size="2"><a href="http://www.ascendworldwide.com">
ascendworldwide.com</a></font></td>
<td width="468">
<font face="Arial">
<a moz-do-not-send="true" href="http://www.ascendworldwide.com/formula1/"><img moz-do-not-send="true" alt="" src="http://www.ascendworldwide.com/content/bnr468x60-Ascend-VirginRacing-d1.gif" class="style65" border="0"></a></font></td>
</tr>
<tr>
<td width="628" colspan="2">
<p align="justify">
<font face="Arial"><span class="style72"><font class="style70">
<font size="1">THIS TRANSMISSION
IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO
WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS
PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER
APPLICABLE LAW. </font> </font></span><span class="style70">
<span class="style72"><font size="1">If you are not the intended recipient or
employee or agent responsible for delivering the transmission to
the intended recipient, please notify us by return. Any
distribution or copying of this document by anyone other than
the intended recipient is strictly prohibited. Ascend Worldwide
Limited cannot be held responsible for any alterations made to
this document, intentionally or otherwise after transmission.
Company Registration No. 06266443 </font> <u1:country-region w:st="on">
<font size="1">England and Wales.</font></u1:country-region></span></span></font></td>
</tr>
</table>
<p class="style76" style="width: 686px; margin-top: 0cm;">
</p>
</body>
</html>