<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);">Thanks for the example code! That makes it a lot easier to adapt it.</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> Friday, January 6, 2023 1:31 PM<br>
<b>To:</b> Christopher Hughes <chughes@co.lincoln.or.us>; GeoMoose Users <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">If you want to pursue the joined table approach, I did some searching of my archived projects and found this method of doing a join in the DATA object (with some commented out experiments):</div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="box-sizing:border-box"> CONNECTIONTYPE OGR</div>
<div style="box-sizing:border-box"> CONNECTION 'T:/GeoData/Parcels/Alberta/t_505033.shp'<br id="x_isPasted" style="box-sizing:border-box">
DATA "SELECT * FROM t_505033 LEFT JOIN 'ODBC:Parcels_Rural,basic'.basic ON t_505033.PID=basic.PID"<br style="box-sizing:border-box">
## DATA "SELECT * FROM (t_505033 LEFT JOIN 'ODBC:Parcels_Rural'.basic ON t_505033.PID=basic.PID) LEFT JOIN 'ODBC:Parcels_Rural'.estate ON basic.LINC=estate.LINC"<br id="x_isPasted" style="box-sizing:border-box">
## DATA 'SELECT * FROM t_505033 LEFT JOIN "ODBC:Driver={Microsoft Access Driver (*.mdb)};Dbq=G\GeoData\Parcels\Alberta\t_505033.mdb".basic ON t_505033.PID=basic.PID'</div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="box-sizing:border-box">I used the ODBC driver because the other table was in an MS Access .mdb. You may need to do some experimenting to get the syntax for joining a shp file to a dbf.</div>
<div style="box-sizing:border-box"><span style="box-sizing:border-box"> </span></div>
<div style="box-sizing:border-box">Brent</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/6/23 2:11 PM<br style="box-sizing:border-box">
<strong style="box-sizing:border-box; font-weight:700">To</strong>: GeoMoose Users <geomoose-users@lists.osgeo.org>, "bfraser@geoanalytic.com" <bfraser@geoanalytic.com><br style="box-sizing:border-box">
<strong style="box-sizing:border-box; font-weight:700">Subject</strong>: Re: [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="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">
<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">Thanks for the suggestion! I hadn't thought of approaching it that way.</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">
<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">
<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">Chris</span></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 id="x_appendonsend" style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<hr tabindex="-1" style="display:inline-block; width:98%; box-sizing:border-box; clear:both; break-after:page">
<div dir="ltr" id="x_divRplyFwdMsg" style="box-sizing:border-box"><strong style="box-sizing:border-box; font-weight:700">From:</strong> GeoMoose-users <geomoose-users-bounces@lists.osgeo.org> on behalf of Brent Fraser <bfraser@geoanalytic.com><br style="box-sizing:border-box">
<strong style="box-sizing:border-box; font-weight:700">Sent:</strong> Friday, January 6, 2023 8:32 AM<br style="box-sizing:border-box">
<strong style="box-sizing:border-box; font-weight:700">To:</strong> GeoMoose Users <geomoose-users@lists.osgeo.org><br style="box-sizing:border-box">
<strong style="box-sizing:border-box; font-weight:700">Subject:</strong>Re: [GeoMoose-users] One to Many Join - GeoMoose 3
<div style="box-sizing:border-box"> </div>
</div>
<div style="box-sizing:border-box">
<div style="font-family:arial; font-size:14px; box-sizing:border-box">
<div id="x_x_isPasted" style="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">It's an interesting problem. Depending on how you want the user access and visualize the data, where could be other solutions. One solution would be to would be to write a server-side script (in Python, PHP, etc) to take
an ID parameter and return an HTML page of records of the join table. You could put a link in each of the GeoMoose result rows to reference the script, something like</div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="box-sizing:border-box"> <a href="https://myserver/getBuildings.php?parcel_id=2102" rel="noopener noreferrer" target="_blank" rel="noopener noreferrer" style="box-sizing:border-box; color:rgb(0,102,147); text-decoration:underline">
https://myserver/getBuildings.php?parcel_id=2102</a></div>
<div style="box-sizing:border-box"> <a href="https://myserver/getBuildings.php?parcel_id=2102" rel="noopener noreferrer" target="_blank" rel="noopener noreferrer" style="box-sizing:border-box; color:rgb(0,102,147); text-decoration:underline">
https://myserver/getBuildings.php?parcel_id=</a>4037</div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="box-sizing:border-box">Clicking on one of these would bring a list of "joined" records in a new page or popup.</div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="box-sizing:border-box">Brent</div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
<div style="box-sizing:border-box">
<div id="x_x_Signature" style="box-sizing:border-box">
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
</div>
</div>
<div style="box-sizing:border-box">
<div style="box-sizing:border-box">
<div style="box-sizing:border-box"><br style="box-sizing:border-box">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>