[Geomoose-users] Identify 1-M Relationships

[Reynolds, Michael J. (DOT)]

Sorry about the typo.  I meant ..."can use sql to join a feature class and a table in a 1 to m."

From: geomoose-users-bounces at lists.osgeo.org [mailto:geomoose-users-bounces at lists.osgeo.org] On Behalf Of Reynolds, Michael J. (DOT)
Sent: Thursday, April 11, 2013 9:35 AM
To: geomoose-users at lists.osgeo.org
Subject: Re: [Geomoose-users] Identify 1-M Relationships

If the data is in postgres, oracle, personal geodatabases, and possibly file geodatabases, the .map file layer data line can use sql to join a feature class to a feature class and a table in a 1 to m.

Geomoose's identify on this layer would return a result for every geometry at the location click.

Is that what you are describing?

[cid:image001.png at 01CE36AF.DE9AD9B0]
Michael Reynolds
Data Management
Metro Traffic Engineering
Minnesota Department of Transportation
(651) 775-5915

From: geomoose-users-bounces at lists.osgeo.org<mailto:geomoose-users-bounces at lists.osgeo.org> [mailto:geomoose-users-bounces at lists.osgeo.org] On Behalf Of Tim Hennig
Sent: Thursday, April 11, 2013 8:19 AM
To: geomoose-users at lists.osgeo.org<mailto:geomoose-users at lists.osgeo.org>
Subject: [Geomoose-users] Identify 1-M Relationships

Hello,

Is it possible to identify a 1-M relationship regarding a feature (e.g. Bellevue has more than one zoning classification within a parcel) in GeoMoose?  Has anyone tried this? I've been searching on the web for a while and have not found any information regarding this.

Do I setup the relationship in MapServer .map file (JOIN ONE-TO-MANY) and would the identify.html see the relate when identified?


Thank You,

Tim
-----------------------------------------------------------------
Tim Hennig
GIS Coordinator

Community Development Department
Village of Bellevue
2828 Allouez Avenue
Bellevue, WI 54311


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20130411/4ba53b29/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 187 bytes
Desc: image001.png
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20130411/4ba53b29/attachment-0001.png>