<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">In this case my join is one-to-many. For each parcel I have multiple results in the table
I'm trying to join. The issue is that I only get results for the initial layer, not for the table I'm trying to join to the initial layer. I've tried auto="true", which works except it only gives me the values for the parcel layer, not the table I'm trying
to join in the mapfile. I wasn't sure if there was a way of setting the join parameters in the mapbook map-source rather than in mapfile layer.</span></div>
<div class="elementToProof">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px; text-align: start; background-color: rgb(255, 255, 255); display: inline !important;">--</span><br style="font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px; text-align: start; background-color: rgb(255, 255, 255);">
<div dir="ltr" style="font-size: 15px; font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; margin: 0px; text-align: start; background-color: rgb(255, 255, 255);">
<div dir="ltr" style="margin:0px"><font size="4">Chris Hughes</font>
<div style="font-size:12.79px;margin:0px"><br>
</div>
<div style="font-size:12.79px;margin:0px">GIS Analyst</div>
<div style="font-size:12.79px;margin:0px"><font size="1">Lincoln County GIS Department </font></div>
<div style="margin:0px"><font size="1"><span style="font-family:Roboto, arial, sans-serif;margin:0px">880 NE 7th S</span><span style="font-family:Roboto, arial, sans-serif;margin:0px">t</span>. l Newport, OR 97365</font></div>
<div style="font-size:12.79px;margin:0px"><font size="1">Tel: (541) 574 1283</font></div>
</div>
</div>
<br>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Brent Fraser <bfraser@geoanalytic.com><br>
<b>Sent:</b> Thursday, January 5, 2023 4:06 PM<br>
<b>To:</b> Christopher Hughes <chughes@co.lincoln.or.us>; geomoose-users-osgeo <geomoose-users@lists.osgeo.org><br>
<b>Subject:</b> RE: [GeoMoose-users] One to Many Join - GeoMoose 3</font>
<div> </div>
</div>
<div>
<div style="font-family:arial; font-size:14px">
<div style="box-sizing:border-box">Hi Chris,</div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="box-sizing:border-box"> Usually what I do is in the mapbook set <template name="identify" auto="true" /> and do an Identify on a parcel to what Mapserver sends back via GML format. You can then tune your GeoMoose template using the property
names shown in the Identify results.</div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="box-sizing:border-box">Should your join be a one-to-one? Have a look in the mapserver error log to see if there any problems on the Mapserver side.</div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="box-sizing:border-box">Best Regards,</div>
<div style="box-sizing:border-box">Brent Fraser</div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="box-sizing:border-box"><span style="box-sizing:border-box"> </span></div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<hr id="x_previousmessagehr" style="box-sizing:border-box; clear:both">
<div style="box-sizing:border-box"><span style="box-sizing:border-box"><strong style="box-sizing:border-box; font-weight:700">From</strong>: "Christopher Hughes" <chughes@co.lincoln.or.us><br style="box-sizing:border-box">
<strong style="box-sizing:border-box; font-weight:700">Sent</strong>: 1/5/23 4:27 PM<br style="box-sizing:border-box">
<strong style="box-sizing:border-box; font-weight:700">To</strong>: geomoose-users-osgeo <geomoose-users@lists.osgeo.org><br style="box-sizing:border-box">
<strong style="box-sizing:border-box; font-weight:700">Subject</strong>: [GeoMoose-users] One to Many Join - GeoMoose 3</span></div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="box-sizing:border-box"><span style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box">Hello all,</span></div>
<div style="box-sizing:border-box"><span style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box"><br style="box-sizing:border-box">
</span></div>
<div style="box-sizing:border-box"><span style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box">I was curious if anyone's tried to do a join (in my case one-to-many)
in GeoMoose 3.</span></div>
<div style="box-sizing:border-box"><span style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box"><br style="box-sizing:border-box">
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box">
I have a shapefile of parcels that I was trying to join to a dbf of related information for each parcel.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box">
I was following the mapserver documentation for joins <a href="https://mapserver.org/mapfile/join.html" id="LPNoLPOWALinkPreview" title="https://mapserver.org/mapfile/join.html" target="_blank" rel="noopener noreferrer" style="box-sizing:border-box; color:rgb(0,102,147); text-decoration:underline">
Here</a> but I couldn't figure out how to convert the mapserver format where the templates and joins are specified in the mapfile to the GeoMoose 3 format where the templates are set in the mapbook.xml. I couldn't get results to reflect the JOIN parameters
that were set in the mapfile.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box">
<br style="box-sizing:border-box">
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box">
Any feedback would be appreciated,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box">
<br style="box-sizing:border-box">
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box">
Chris</div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="box-sizing:border-box">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); box-sizing:border-box">
<br style="box-sizing:border-box">
</div>
<div id="x_Signature" style="box-sizing:border-box">
<div style="box-sizing:border-box">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); box-sizing:border-box">
<span style="font-size:15px; text-align:start; background-color:rgb(255,255,255); display:inline!important; box-sizing:border-box">--</span><br style="font-size:15px; text-align:start; background-color:rgb(255,255,255); box-sizing:border-box">
<div dir="ltr" style="font-size:15px; margin:0px; text-align:start; background-color:rgb(255,255,255); box-sizing:border-box">
<div dir="ltr" style="margin:0px; box-sizing:border-box">Chris Hughes
<div style="font-size:12.79px; margin:0px; box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="font-size:12.79px; margin:0px; box-sizing:border-box">GIS Analyst</div>
<div style="font-size:12.79px; margin:0px; box-sizing:border-box">Lincoln County GIS Department </div>
<div style="margin:0px; box-sizing:border-box"><span style="font-family:Roboto,arial,sans-serif; margin:0px; box-sizing:border-box">880 NE 7th S</span><span style="font-family:Roboto,arial,sans-serif; margin:0px; box-sizing:border-box">t</span>. l Newport,
OR 97365</div>
<div style="font-size:12.79px; margin:0px; box-sizing:border-box">Tel: (541) 574 1283</div>
</div>
</div>
<br style="box-sizing:border-box">
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>