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

[Brent Fraser]

I've done a join in the DATA statement and in an ogr vrt file, but I don't recall using the JOIN object in the map file.  Likely you need to be careful to use upper case for the DBF column names. GeoMoose 3 uses WMS/WFS to communicate with Mapserver; maybe the JOIN doesn't work with these protocols.

Did you set DEBUG 5 and check the contents of the log file?

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

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 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/20230105/0ff24c30/attachment-0001.htm>