[Geomoose-users] Identify 1-M Relationships

Tim Hennig timhbellevue at gmail.com
Fri Apr 12 14:22:00 PDT 2013


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>

To: "geomoose-users at lists.osgeo.org" <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>

                

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] On Behalf Of Tim Hennig

Sent: Thursday, April 11, 2013 8:19 AM

To: 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/83b9c5
e3/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/83b9c5
e3/attachment.png>

 

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

 

_______________________________________________

Geomoose-users mailing list

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/81af50ad/attachment.html>


More information about the Geomoose-users mailing list