shrug-l: multiple joins/displaying bar graphs in 8.x

Mayo, Michele Michele.Mayo@dep.state.fl.us
Mon, 11 Oct 2004 10:25:30 -0400 

This is a multi-part message in MIME format.

------_=_NextPart_001_01C4AF9E.290AFFE8
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

=20

Matt,

=20

ArcMap 8.x does have trouble symbolizing on related fields.  I think the
simplest solution would be to export the shapefile with its two joined =
tables
so that the related fields will be permanent, then use the output in =
your
ArcMap document.

=20

If you find a more elegant solution, I'd be interested to know what it =
is.

=20

Hope this helps,

Michele

=20

-----Original Message-----
From: Lake, Matt=20
Sent: Sunday, October 10, 2004 11:14 AM
To: shrug-l@lists.dep.state.fl.us
Cc: Abron, Johnnie; Paulsen, Janis; Brandt, Holli; Hughes, Ronald;
McClenahan, Tricia
Subject: shrug-l: multiple joins/displaying bar graphs in 8.x

=20

All,=20

I am attempting to display the contaminant results for a single =
geographical
point from two .dbf's using bar graphs in ArcMap 8.x.

I am able to successfully join the two .dbf's to the shapefile, and can
successfully display an attribute from one joined field in the bar graph
(Symbology>Charts>Bar/Column). =20

And I am able to select any field from the joins in the dialog box, yet =
when
I try to display data from two fields originally from separate .dbf's it
fails (successful if pulling from fields originally in the same .dbf).

It does display it correctly (two bars parallel to each other) in =
ArcMap's
Table of Contents and in my inserted legend in layout view, but that
shapefile ends up not being displayed on the map.

Your suggestions are greatly appreciated,=20

Matt=20

Matt Lake=20
Environmental Specialist III=20
Watershed Monitoring & Data Management=20
Division of Water Resource Management=20
Florida Department of Environmental Protection=20
matt.lake@dep.state.fl.us=20
850.245.8540=20


------_=_NextPart_001_01C4AF9E.290AFFE8
Content-Type: text/html;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html>

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<title>multiple joins/displaying bar graphs in 8.x</title>

<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:"Comic Sans MS";
	panose-1:3 15 7 2 3 3 2 2 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
p
	{margin-right:0in;
	margin-left:0in;
	font-size:12.0pt;
	font-family:"Times New Roman";}
span.EmailStyle18
	{font-family:Tahoma;
	color:blue;
	font-weight:normal;
	font-style:normal;
	text-decoration:none none;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>&nbsp;</span></font></p>

<!-- Converted from text/rtf format -->

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>Matt,</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>ArcMap 8.x does have trouble =
symbolizing
on related fields.&nbsp; I think the simplest solution would be to =
export the
shapefile with its two joined tables so that the related fields will be
permanent, then use the output in your ArcMap =
document.</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>If you find a more elegant =
solution, I&#8217;d
be interested to know what it is.</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>Hope this helps,</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>Michele</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>&nbsp;</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Lake, Matt <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Sunday, October 10, =
2004
11:14 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
shrug-l@lists.dep.state.fl.us<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> Abron, Johnnie; =
Paulsen,
Janis; Brandt, Holli; Hughes, Ronald; McClenahan, Tricia<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> shrug-l: =
multiple
joins/displaying bar graphs in 8.x</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'>&nbsp;</span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>All,</span></font> </p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>I am attempting to display the contaminant =
results
for a single geographical point from two .dbf's using bar graphs in =
ArcMap 8.x.</span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>I am able to successfully join the two .dbf's =
to the
shapefile, and can successfully display an attribute from one joined =
field in
the bar graph (Symbology&gt;Charts&gt;Bar/Column).&nbsp; =
</span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>And I am able to select any field from the =
joins in
the dialog box, yet when I try to display data from two fields =
originally from
separate .dbf's it fails (successful if pulling from fields originally =
in the
same .dbf).</span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>It does display it correctly (two bars =
parallel to
each other) in ArcMap's Table of Contents and in my inserted legend in =
layout
view, but that shapefile ends up not being displayed on the =
map.</span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Your suggestions are greatly =
appreciated,</span></font>
</p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Matt</span></font> </p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dnavy face=3D"Comic =
Sans MS"><span
style=3D'font-size:10.0pt;font-family:"Comic Sans MS";color:navy'>Matt =
Lake</span></font>
<br>
<font size=3D2 color=3Dnavy face=3D"Comic Sans MS"><span =
style=3D'font-size:10.0pt;
font-family:"Comic Sans MS";color:navy'>Environmental Specialist =
III</span></font>
<br>
<font size=3D2 color=3Dnavy face=3D"Comic Sans MS"><span =
style=3D'font-size:10.0pt;
font-family:"Comic Sans MS";color:navy'>Watershed Monitoring &amp; Data
Management</span></font> <br>
<font size=3D2 color=3Dnavy face=3D"Comic Sans MS"><span =
style=3D'font-size:10.0pt;
font-family:"Comic Sans MS";color:navy'>Division of Water Resource =
Management</span></font>
<br>
<font size=3D2 color=3Dnavy face=3D"Comic Sans MS"><span =
style=3D'font-size:10.0pt;
font-family:"Comic Sans MS";color:navy'>Florida Department of =
Environmental
Protection</span></font> <br>
<font size=3D2 color=3Dnavy face=3D"Comic Sans MS"><span =
style=3D'font-size:10.0pt;
font-family:"Comic Sans =
MS";color:navy'>matt.lake@dep.state.fl.us</span></font>
<br>
<font size=3D2 color=3Dnavy face=3D"Comic Sans MS"><span =
style=3D'font-size:10.0pt;
font-family:"Comic Sans MS";color:navy'>850.245.8540</span></font> </p>

</div>

</body>

</html>

------_=_NextPart_001_01C4AF9E.290AFFE8--