<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@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:11.0pt;
font-family:"Calibri","sans-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.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.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]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Tim,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I’m not aware of a way to join shapefiles and table data using mapserver.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">What might be a solution would be to customize the identify.php to do a little more work for you. There you could use server side php to connect to the table and search for related records and return an html
formatted table or list of records.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">The geomoose developers might know of a better way to do this using geomoose extensions.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#1F497D"><img width="22" height="14" id="Picture_x0020_1" src="cid:image001.png@01CE379B.90D43D10"></span><b><span style="color:#1F497D"><o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="color:#1F497D">Michael Reynolds<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="color:#1F497D">Data Management<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Metro Traffic Engineering<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Minnesota Department of Transportation<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="color:#1F497D">(651) 775-5915<o:p></o:p></span></b></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><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""> geomoose-users-bounces@lists.osgeo.org [mailto:geomoose-users-bounces@lists.osgeo.org]
<b>On Behalf Of </b>Tim Hennig<br>
<b>Sent:</b> Friday, April 12, 2013 4:22 PM<br>
<b>To:</b> geomoose-users@lists.osgeo.org<br>
<b>Subject:</b> Re: [Geomoose-users] Identify 1-M Relationships<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi Michael, <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The MapServer is setup to use shapefiles. I would like to link Shapefile to a table (it’s how I developed it…) and return a 1-M result.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">For example: If I identify a Parcel that’s related to a zoning table (based on ParcelID) would return a one or many zoning classification(s) within that parcel.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Are you saying you can setup the related information within a .map file and the identify.html (2.6.1 Demo Version) will produce a 1-M?
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Thank You,<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:5.0pt;margin-right:0in;margin-bottom:5.0pt;margin-left:0in">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:5.0pt;margin-right:0in;margin-bottom:5.0pt;margin-left:0in">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">Tim<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">-----------------------------------------------------------------<br>
</span><b><i><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#76923C">Tim Hennig</span></i></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D"><br>
<b>GIS Coordinator</b><i><br>
</i><br>
Community Development Department<br>
Village of Bellevue<br>
2828 Allouez Avenue<br>
Bellevue, WI 54311</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Message: 3<o:p></o:p></p>
<p class="MsoNormal">Date: Thu, 11 Apr 2013 14:34:46 +0000<o:p></o:p></p>
<p class="MsoNormal">From: "Reynolds, Michael J. (DOT)" <<a href="mailto:mike.reynolds@state.mn.us">mike.reynolds@state.mn.us</a>><o:p></o:p></p>
<p class="MsoNormal">To: "<a href="mailto:geomoose-users@lists.osgeo.org">geomoose-users@lists.osgeo.org</a>" <<a href="mailto:geomoose-users@lists.osgeo.org">geomoose-users@lists.osgeo.org</a>><o:p></o:p></p>
<p class="MsoNormal">Subject: Re: [Geomoose-users] Identify 1-M Relationships<o:p></o:p></p>
<p class="MsoNormal">Message-ID:<o:p></o:p></p>
<p class="MsoNormal"> <<a href="mailto:6E5F1F66B0B9D8489AED04F46BA564BC350B11@055-CH1MPN1-001.055d.mgd.msft.net">6E5F1F66B0B9D8489AED04F46BA564BC350B11@055-CH1MPN1-001.055d.mgd.msft.net</a>><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Content-Type: text/plain; charset="us-ascii"<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If the data is in postgres, oracle, personal geodatabases, and possibly file geodatabases, the .map file layer data line can use sql to join a feature class to a feature class and a table in a 1 to m.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Geomoose's identify on this layer would return a result for every geometry at the location click.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Is that what you are describing?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">[<a href="cid:image001.png@01CE3697.CD6AE760">cid:image001.png@01CE3697.CD6AE760</a>]<o:p></o:p></p>
<p class="MsoNormal">Michael Reynolds<o:p></o:p></p>
<p class="MsoNormal">Data Management<o:p></o:p></p>
<p class="MsoNormal">Metro Traffic Engineering<o:p></o:p></p>
<p class="MsoNormal">Minnesota Department of Transportation<o:p></o:p></p>
<p class="MsoNormal">(651) 775-5915<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">From: <a href="mailto:geomoose-users-bounces@lists.osgeo.org">
geomoose-users-bounces@lists.osgeo.org</a> [<a href="mailto:geomoose-users-bounces@lists.osgeo.org">mailto:geomoose-users-bounces@lists.osgeo.org</a>] On Behalf Of Tim Hennig<o:p></o:p></p>
<p class="MsoNormal">Sent: Thursday, April 11, 2013 8:19 AM<o:p></o:p></p>
<p class="MsoNormal">To: <a href="mailto:geomoose-users@lists.osgeo.org">geomoose-users@lists.osgeo.org</a><o:p></o:p></p>
<p class="MsoNormal">Subject: [Geomoose-users] Identify 1-M Relationships<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hello,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Is it possible to identify a 1-M relationship regarding a feature (e.g. Bellevue has more than one zoning classification within a parcel) in GeoMoose? Has anyone tried this? I've been searching on the web for a while and have not found
any information regarding this.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Do I setup the relationship in MapServer .map file (JOIN ONE-TO-MANY) and would the identify.html see the relate when identified?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank You,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Tim<o:p></o:p></p>
<p class="MsoNormal">-----------------------------------------------------------------<o:p></o:p></p>
<p class="MsoNormal">Tim Hennig<o:p></o:p></p>
<p class="MsoNormal">GIS Coordinator<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Community Development Department<o:p></o:p></p>
<p class="MsoNormal">Village of Bellevue<o:p></o:p></p>
<p class="MsoNormal">2828 Allouez Avenue<o:p></o:p></p>
<p class="MsoNormal">Bellevue, WI 54311<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">-------------- next part --------------<o:p></o:p></p>
<p class="MsoNormal">An HTML attachment was scrubbed...<o:p></o:p></p>
<p class="MsoNormal">URL: <<a href="http://lists.osgeo.org/pipermail/geomoose-users/attachments/20130411/83b9c5e3/attachment.html">http://lists.osgeo.org/pipermail/geomoose-users/attachments/20130411/83b9c5e3/attachment.html</a>><o:p></o:p></p>
<p class="MsoNormal">-------------- next part --------------<o:p></o:p></p>
<p class="MsoNormal">A non-text attachment was scrubbed...<o:p></o:p></p>
<p class="MsoNormal">Name: image001.png<o:p></o:p></p>
<p class="MsoNormal">Type: image/png<o:p></o:p></p>
<p class="MsoNormal">Size: 187 bytes<o:p></o:p></p>
<p class="MsoNormal">Desc: image001.png<o:p></o:p></p>
<p class="MsoNormal">URL: <<a href="http://lists.osgeo.org/pipermail/geomoose-users/attachments/20130411/83b9c5e3/attachment.png">http://lists.osgeo.org/pipermail/geomoose-users/attachments/20130411/83b9c5e3/attachment.png</a>><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">------------------------------<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">_______________________________________________<o:p></o:p></p>
<p class="MsoNormal">Geomoose-users mailing list<o:p></o:p></p>
<p class="MsoNormal"><a href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a><o:p></o:p></p>
<p class="MsoNormal"><a href="http://lists.osgeo.org/mailman/listinfo/geomoose-users">http://lists.osgeo.org/mailman/listinfo/geomoose-users</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">End of Geomoose-users Digest, Vol 22, Issue 18<o:p></o:p></p>
<p class="MsoNormal">**********************************************<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>