[Geomoose-users] Identify 1-M Relationships

Fri Apr 12 14:34:13 PDT 2013

Tim,

I'm not aware of a way to join shapefiles and table data using mapserver.

What might be a solution would be to customize the identify.php to do a little more work for you.  There you could use server side php to connect to the table and search for related records and return an html formatted table or list of records.

The geomoose developers might know of a better way to do this using geomoose extensions.

[cid:image001.png at 01CE379B.90D43D10]
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: Friday, April 12, 2013 4:22 PM
To: geomoose-users at lists.osgeo.org
Subject: Re: [Geomoose-users] Identify 1-M Relationships

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/d52685cd/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/20130412/d52685cd/attachment-0001.png>