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

[Brent Fraser]

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=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/b1486c14/attachment.htm>