[GeoMoose-users] One to Many Join - GeoMoose 3

[Christopher Hughes]

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.

--
Chris Hughes

GIS Analyst
Lincoln County GIS Department
880 NE 7th St. l Newport, OR 97365
Tel: (541) 574 1283

________________________________
From: Brent Fraser <bfraser at geoanalytic.com>
Sent: Thursday, January 5, 2023 4:06 PM
To: Christopher Hughes <chughes at co.lincoln.or.us>; geomoose-users-osgeo <geomoose-users at lists.osgeo.org>
Subject: RE: [GeoMoose-users] One to Many Join - GeoMoose 3

Hi Chris,

  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.

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.

Best Regards,
Brent Fraser



________________________________
From: "Christopher Hughes" <chughes at co.lincoln.or.us>
Sent: 1/5/23 4:27 PM
To: geomoose-users-osgeo <geomoose-users at lists.osgeo.org>
Subject: [GeoMoose-users] One to Many Join - GeoMoose 3

Hello all,

I was curious if anyone's tried to do a join (in my case one-to-many) in GeoMoose 3.

I have a shapefile of parcels that I was trying to join to a dbf of related information for each parcel.
I was following the mapserver documentation for joins Here<https://mapserver.org/mapfile/join.html> 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.

Any feedback would be appreciated,

Chris


--
Chris Hughes

GIS Analyst
Lincoln County GIS Department
880 NE 7th St. l Newport, OR 97365
Tel: (541) 574 1283

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20230106/7aa8c3b4/attachment.htm>