[Geomoose-users] Identify 1-M Relationships

[Tim Hennig]

Hi Michael,

The MapServer is setup to use shapefiles.  I would like to link Shapefile to a table (it's how I developed it...) and return a 1-M result.

For example: If I identify a Parcel that's related to a zoning table (based on ParcelID) would return a one or many zoning classification(s) within that parcel.

Are you saying you can setup the related information within a .map file and the identify.html (2.6.1 Demo Version) will produce a 1-M?


Thank You,

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

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


Message: 3
Date: Thu, 11 Apr 2013 14:34:46 +0000
From: "Reynolds, Michael J. (DOT)" <mike.reynolds at state.mn.us<mailto:mike.reynolds at state.mn.us>>
To: "geomoose-users at lists.osgeo.org<mailto:geomoose-users at lists.osgeo.org>" <geomoose-users at lists.osgeo.org<mailto:geomoose-users at lists.osgeo.org>>
Subject: Re: [Geomoose-users] Identify 1-M Relationships
Message-ID:
                <6E5F1F66B0B9D8489AED04F46BA564BC350B11 at 055-CH1MPN1-001.055d.mgd.msft.net<mailto:6E5F1F66B0B9D8489AED04F46BA564BC350B11 at 055-CH1MPN1-001.055d.mgd.msft.net>>

Content-Type: text/plain; charset="us-ascii"

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 01CE3697.CD6AE760]
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/83b9c5e3/attachment.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/83b9c5e3/attachment.png>

------------------------------

_______________________________________________
Geomoose-users mailing list
Geomoose-users at lists.osgeo.org<mailto:Geomoose-users at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/geomoose-users


End of Geomoose-users Digest, Vol 22, Issue 18
**********************************************


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20130412/1f696e6d/attachment-0001.html>