[Geomoose-users] Linking/Joining

[Fischer, Brian]

Jay, this is not a GeoMOOSE thing it is a MapServer thing.  Currently
with MapServer your only option for joining file to a spatial file is as
a .dfb.  It is fairly easy to do this and good documentation on
GeoMOOSE.  Another option is to nightly just setup a process that joins
your data to the shapefile and use the shapefile.

Yet another option is to use PostGIS were you can do the joining on the
fly. There has been some discussion on the MapServer developer list
about extending the data formats you can join but I have not seen
anything concrete.

I usually either join the fields to the shapefile or setup a separate
script to generate a little report from the data in a database and
construct a hyperlink in GeoMOOSE to it.

Hope that helps,
Brian

-----Original Message-----
From: geomoose-users-bounces at lists.sourceforge.net
[mailto:geomoose-users-bounces at lists.sourceforge.net] On Behalf Of Mark
Volz
Sent: Monday, June 23, 2008 3:36 PM
To: geomoose-users at lists.sourceforge.net
Cc: jkapalczynski at ci.maple-grove.mn.us
Subject: Re: [Geomoose-users] Linking/Joining

Jay,

Although I have not done this myself yet Mapserver has documentation for
this
already under the "Mapfile Reference"
http://mapserver.gis.umn.edu/docs/reference/mapfile/html2pdf


Let me know if you need any assistance.

Mark Volz
GIS Specialist
Lyon County, MN
(507) 532-8218


   4. Linking/joining (Jay Kapalczynski)
Message: 4
Date: Fri, 20 Jun 2008 14:19:04 -0500
From: "Jay Kapalczynski" <jkapalczynski at ci.maple-grove.mn.us>
Subject: [Geomoose-users] Linking/joining
To: <geomoose-users at lists.sourceforge.net>,
	<geomoose-developers at lists.sourceforge.net>
Message-ID:
	
<A1124B79D79DED4C94FAAA6FEB9AE646021422E1 at mg-ex2k.ci.maple-grove.mn.us>
	
Content-Type: text/plain; charset="us-ascii"

If I have a Parcels Shapefile and want to join to a database (by PID
number) how do I do this in GeoMoose?

Where I can select a parcel and all the data shows up from both tables
(dbf and database)....I guess what I need to know how to do is set up
the join/relate so the extra fields are available to be displayed in the
Info tab..

 

Thoughts?
Thanks
Jay
City of Maple Grove

Jason Kapalczynski

GIS / IS

Office 763.494.6282

Fax:   763.494.6419
jkapalczynski at ci.maple-grove.mn.us
<mailto:jkapalczynski at ci.maple-grove.mn.us> 

 


------------------------------------------------------------------------
-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Geomoose-users mailing list
Geomoose-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geomoose-users