<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body style="direction: ltr;" bidimailui-charset-is-forced="true"
bidimailui-detected-decoding-type="latin-charset" text="#000000"
bgcolor="#ffffff">
<p style="margin-bottom: 0cm; margin-top: 0pt;"><tt>On 28/04/2011
00:49, Hinkle, CJon wrote:<br>
</tt></p>
<blockquote
cite="mid:8889CC906C56E143A97C44748112CB6E04D5D0E7A7@EXCHVS7A.mx.state.mo.us"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 12 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Cambria;
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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;}
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";
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Cambria","serif";
color:blue;
font-weight:normal;
font-style:normal;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Cambria","serif";
color:green;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></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]-->
<div class="WordSection1">
<div>
<div style="border-right: medium none; border-width: 1pt
medium medium; border-style: solid none none; border-color:
rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color;
padding: 3pt 0in 0in;">
<p class="MsoNormal"><tt><b><span style="font-size: 10pt;
font-family:
"Tahoma","sans-serif"; color:
windowtext;">From:</span></b><span style="font-size:
10pt; font-family:
"Tahoma","sans-serif"; color:
windowtext;"> Micha Silver <br>
<b>Subject:</b> Re: [Qgis-user] newbie question:
grouping polygons in a shapefile<o:p></o:p></span></tt></p>
</div>
</div>
<p class="MsoNormal"><tt><o:p> </o:p></tt></p>
<tt><br>
</tt>
<p style="margin-right: 0in; margin-left: 0.5in; margin-bottom:
0.0001pt;"><tt>When you say "divide the counties" do you have
the geographic boundaries of the districts is the second
"table"?<span style="color: green;"><o:p></o:p></span></tt></p>
<p style="margin: 0in 0in 0.0001pt;"><tt><span
style="font-family: "Cambria","serif";
color: green;"><o:p> </o:p></span></tt></p>
<p style="margin: 0in 0in 0.0001pt;"><tt><span
style="font-family: "Cambria","serif";
color: green;">No, I don’t have boundaries for the
Districts, except as they include the individual
counties. Divide was a bad choice of terms. I actually
want to group the counties. That is Counties 1 – 15 are
District A, Counties 16 – 30 are District B etc. Of
course, they aren’t numbered, they are named.<o:p></o:p></span></tt></p>
<p class="MsoNormal"><tt><span style="font-size: 12pt;
font-family: "Times New
Roman","serif";"></span></tt></p>
</div>
</blockquote>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><tt><br>
</tt></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><tt>Ah, OK. So you
have a shapefile of counties and a table which looks like:</tt></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size: 13px;"><tt>County | District<br>
</tt></span><span style="font-size: 13px;"></span></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size: 13px;"><tt>1 | A<br>
</tt></span><span style="font-size: 13px;"></span></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size: 13px;"><tt>2 | A<br>
</tt></span><span style="font-size: 13px;"></span></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size: 13px;"><tt>3 | A<br>
</tt></span><span style="font-size: 13px;"></span></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size: 13px;"><tt>16 | B<br>
</tt></span><span style="font-size: 13px;"></span></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size: 13px;"><tt>17 | B<br>
</tt></span><span style="font-size: 13px;"></span></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size: 13px;"><tt>...<br>
</tt></span><span style="font-size: 13px;"></span></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size: 13px;"><tt><br>
</tt></span><span style="font-size: 13px;"></span></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><small><tt><big><span
style="font-size: 13px;">You can import the table into
QGIS using the Add Vector Layer button.</span> <small>The
table should be either in DBF or CSV format (or an sqlite
table). Then, in the properties window of the</small></big><small>
</small></tt><tt>counties layer go to the Join tab, and set up
a join (click the +) between the counties attrib table and the
Districts table. Both the Join field and the Target field
should be county name. Now you should have in your attrib
table an additional column of Districts. Next shift over to
the Symbology tab in the counties layer properties windows,
and set colors based on this column. Choose "Unique Value" for
the Classification and "District" for the field to set a color
for each District.</tt></small></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size: 12px;"><tt>Hope that's clear.</tt></span></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><small><tt>In
addition, you can export the joine<small><big>d</big> </small></tt><tt>layer
to a new shapefile to have the Districts permanently part of
the counties layer.</tt></small></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><br>
</p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size: 12px;"></span><span style="font-size: 12px;"></span></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size: 12px;"><tt>-- <br>
</tt></span><span style="font-size: 12px;"></span></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size: 12px;"><tt>Micha</tt></span><br>
</p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><br>
</p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><small><tt><span
style="font-size: 13px;"></span></tt></small></p>
<tt><span style="font-size: 12pt; font-family: "Times New
Roman","serif";"><br>
<o:p></o:p></span></tt>
<blockquote
cite="mid:8889CC906C56E143A97C44748112CB6E04D5D0E7A7@EXCHVS7A.mx.state.mo.us"
type="cite">
<div class="WordSection1">
<p class="MsoNormal" style="margin-left: 1in;"><tt><span
style="font-size: 12pt; font-family:
"Cambria","serif"; color: blue;">information
on each county, but does not contain the District
information. I have a different table that contains the
county name (identical to the original table) and the
District designation (A, B, C etc)</span><o:p></o:p></tt></p>
<p class="MsoNormal" style="margin-left: 1in;"><tt><span
style="font-size: 12pt; font-family:
"Cambria","serif"; color: blue;"> </span><o:p></o:p></tt></p>
<p class="MsoNormal" style="margin-left: 1in;"><tt><span
style="font-size: 12pt; font-family:
"Cambria","serif"; color: blue;">I
can’t find a way to import the second table into the
project and sync it with the first, so I can then color
District A red and District B green etc.</span><o:p></o:p></tt></p>
<p style="margin: 0in 0in 0.0001pt;"><tt><o:p> </o:p></tt></p>
<p style="margin-right: 0in; margin-left: 0.5in; margin-bottom:
0.0001pt;"><tt>Can you add just the districts and color them
all different colors?<span style="color: green;"><o:p></o:p></span></tt></p>
<p style="margin: 0in 0in 0.0001pt;"><tt><span
style="font-family: "Cambria","serif";
color: green;"><o:p> </o:p></span></tt></p>
<p style="margin: 0in 0in 0.0001pt;"><tt><span
style="font-family: "Cambria","serif";
color: green;">That’s what I’m trying to do. I could, for
instance, add the district designations in a new column in
the current DBF table, but my reading seems to indicate
that this is not a good idea.<o:p></o:p></span></tt></p>
<p style="margin: 0in 0in 0.0001pt;"><tt><span
style="font-family: "Cambria","serif";
color: green;"><o:p> </o:p></span></tt></p>
<p style="margin: 0in 0in 0.0001pt;"><tt><span
style="font-family: "Cambria","serif";
color: green;">Thanks for your response, CJon<o:p></o:p></span></tt></p>
<p style="margin: 0in 0in 0.0001pt;"><tt><o:p> </o:p></tt></p>
<pre><tt> <o:p></o:p></tt></pre>
</div>
<tt><br>
<br>
This mail was received via Mail-SeCure System.<br>
</tt>
</blockquote>
<tt><br>
<br>
</tt>
<div class="moz-signature"><tt>-- <br>
</tt>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<div class="moz-signature">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<title></title>
<p style="margin-bottom: 0cm; margin-top: 0pt; float: right;"><tt><img
alt="Hevra Logo"
src="cid:part1.09000809.02050003@arava.co.il" width="135"
border="0" height="59"></tt></p>
<p style="margin-bottom: 0cm; margin-top: 0pt; direction: ltr;"><tt>Micha
Silver</tt></p>
<p style="margin-bottom: 0cm; margin-top: 0pt; direction: ltr;"><tt>Arava
Development Co</tt></p>
<p style="margin-bottom: 0cm; margin-top: 0pt; direction: ltr;"><tt>052-3665918</tt></p>
<p style="margin-bottom: 0cm; margin-top: 0pt; direction: ltr;"><tt><a class="moz-txt-link-freetext" href="http://www.surfaces.co.il">http://www.surfaces.co.il</a></tt></p>
</div>
</div>
</body>
</html>