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

[Christopher Hughes]

Thanks for the suggestion! I hadn't thought of approaching it that way.

Chris

--
Chris Hughes

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

________________________________
From: GeoMoose-users <geomoose-users-bounces at lists.osgeo.org> on behalf of Brent Fraser <bfraser at geoanalytic.com>
Sent: Friday, January 6, 2023 8:32 AM
To: GeoMoose Users <geomoose-users at lists.osgeo.org>
Subject: Re: [GeoMoose-users] One to Many Join - GeoMoose 3

Chris,

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

  https://myserver/getBuildings.php?parcel_id=2102
  https://myserver/getBuildings.php?parcel_id=<https://myserver/getBuildings.php?parcel_id=2102>4037

Clicking on one of these would bring a list of "joined" records in a new page or popup.

Brent



________________________________
From: "Christopher Hughes" <chughes at co.lincoln.or.us>
Sent: 1/6/23 9:15 AM
To: James Klassen <klassen.js at gmail.com>, "bfraser at geoanalytic.com" <bfraser at geoanalytic.com>
Cc: geomoose-users-osgeo <geomoose-users at lists.osgeo.org>
Subject: Re: [GeoMoose-users] One to Many Join - GeoMoose 3

The main reason I was looking at the mapserver join was because there were pretty good examples of how to return html results for a one-to-many join. Checked apache logs, auto identify results, and DEBUG 5 and didn't get anything that would indicate the joined table was being included.

Just wanted to make sure there wasn't something I was missing, like config options in the mapbook.

Thanks!


--
Chris Hughes

GIS Analyst
Lincoln County GIS Department
880 NE 7th St. l Newport, OR 97365
Tel: (541) 574 1283
https://lists.osgeo.org/mailman/listinfo/geomoose-users

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