<div style="font-family: arial; font-size: 14px;"><div fr-original-style="" style="box-sizing: border-box;">Hi Chris,</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" 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 fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" 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 fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">Best Regards,</div><div fr-original-style="" style="box-sizing: border-box;">Brent Fraser</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;" contenteditable="false"><span fr-original-style="" style="box-sizing: border-box;"> </span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><hr id="previousmessagehr" fr-original-style="" style="box-sizing: border-box; clear: both; user-select: none;"><div fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">From</strong>: "Christopher Hughes" <chughes@co.lincoln.or.us><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Sent</strong>: 1/5/23 4:27 PM<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">To</strong>: geomoose-users-osgeo <geomoose-users@lists.osgeo.org><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Subject</strong>: [GeoMoose-users] One to Many Join - GeoMoose 3</span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-class="elementToProof" fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" 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 fr-original-class="elementToProof" fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" 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 fr-original-style="" style="box-sizing: border-box;"></span></div><div fr-original-class="elementToProof" fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" 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 fr-original-class="elementToProof" fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" 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 fr-original-style="" style="box-sizing: border-box;"></span></div><div fr-original-class="elementToProof" fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" 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 fr-original-class="elementToProof" fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" 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 fr-original-style="" href="https://mapserver.org/mapfile/join.html" id="LPNoLPOWALinkPreview" style="box-sizing: border-box; color: rgb(0, 102, 147); text-decoration: underline; user-select: auto;" title="https://mapserver.org/mapfile/join.html" target="_blank" rel="noopener noreferrer">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 fr-original-class="elementToProof" fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" 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 fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-class="elementToProof" fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" 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 fr-original-class="elementToProof" fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" 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 fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-class="elementToProof" fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" 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 fr-original-class="_Entity _EType_OWALinkPreview _EId_OWALinkPreview _EReadonly_1" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-class="elementToProof" fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" id="Signature" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); box-sizing: border-box;"><span fr-original-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;" 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; box-sizing: border-box;">--</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); box-sizing: border-box;" fr-original-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" fr-original-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);" 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); box-sizing: border-box;"><div dir="ltr" fr-original-style="margin:0px;" style="margin: 0px; box-sizing: border-box;">Chris Hughes<div fr-original-style="font-size:12.79px;margin:0px;" style="font-size: 12.79px; margin: 0px; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="font-size:12.79px;margin:0px;" style="font-size: 12.79px; margin: 0px; box-sizing: border-box;">GIS Analyst</div><div fr-original-style="font-size:12.79px;margin:0px;" style="font-size: 12.79px; margin: 0px; box-sizing: border-box;">Lincoln County GIS Department </div><div fr-original-style="margin:0px;" style="margin: 0px; box-sizing: border-box;"><span fr-original-style="font-family:Roboto, arial, sans-serif;margin:0px;" style="font-family: Roboto, arial, sans-serif; margin: 0px; box-sizing: border-box;">880 NE 7th S</span><span fr-original-style="font-family:Roboto, arial, sans-serif;margin:0px;" style="font-family: Roboto, arial, sans-serif; margin: 0px; box-sizing: border-box;">t</span>. l Newport, OR 97365</div><div fr-original-style="font-size:12.79px;margin:0px;" style="font-size: 12.79px; margin: 0px; box-sizing: border-box;">Tel: (541) 574 1283</div></div></div><br fr-original-style="" style="box-sizing: border-box;"></div></div></div></div></div>