[Geomoose-users] [Geomoose-developers] Retrieving Records from Database

[Fischer, Brian]

Jay,
 
You are somewhat limited here.  Currently mapserver only supports
joining a handful of tables to a shapefile.  Take a look at the
MapServer documentation.
http://mapserver.gis.umn.edu/docs/reference/mapfile/join
 
The only way you could get the attributes to show up in the info tab is
to:
1) put your data in one of the supported formats
(http://mapserver.gis.umn.edu/docs/reference/mapfile/join#supported-form
ats) and join the table to the shapefile using mapserver/query templates
2) Set the source of your parcel layer to a personal geodatabase.
Performance is not as good as shapefiles. Still there I am not sure if
you would have to have all the attributes in the same table or not.
3) Set your source of your parcel layer to an SDE layer.  Same caveat as
#2.
4) have all your fields you want to show up in the info tab as part of
the shapefile.
5) construct a link to an external page that shows more parcel info.
Ex.)
http://65.77.74.200/mcleodcounty/TaxBill.aspx?RollType=R&ParcelNumber=08
0190800&TaxYear=2008
6) Put all your data into PostGreSql/PostGIS
 
I usually do #4, 5 or 6.  We can talk about this more next week if you
want.  Hope this helps.
 
Brian Fischer
Houston Engineering, Inc.
Maple Grove, MN
(763) 493-4522
 

________________________________

From: Jay Kapalczynski [mailto:jkapalczynski at ci.maple-grove.mn.us] 
Sent: Friday, July 25, 2008 11:02 AM
To: Fischer, Brian
Subject: RE: [Geomoose-developers] Retrieving Records from Database



What I want to do is hit an Access Database and/or a Geodatabase with
the identify tool the same way the shapefiles work....

 

I click the tool and click a parcel and the info is returned in the Info
Tab...

 

I can do this right?  I think that's different that querying and
returning multiple records...

 

I think I just need to do something like my first email below and then
have an html template the show the fields right?

 

Thanks

 

From: Fischer, Brian [mailto:bfischer at houstonengineeringinc.com] 
Sent: Wednesday, July 16, 2008 1:39 PM
To: Jay Kapalczynski; geomoose-users at lists.sourceforge.net;
geomoose-developers at lists.sourceforge.net
Subject: RE: [Geomoose-developers] Retrieving Records from Database

 

Jay, I'm not sure I completely understand what you are tyring to do.
Are you trying do draw the layer on the map? Are you using the
select/identify tool to return the attributes to the info tab?

 

Brian Fischer

Houston Engineering, Inc.

Maple Grove, MN

(763) 493-4522

 

 

________________________________

From: geomoose-developers-bounces at lists.sourceforge.net
[mailto:geomoose-developers-bounces at lists.sourceforge.net] On Behalf Of
Jay Kapalczynski
Sent: Tuesday, July 15, 2008 4:29 PM
To: Jay Kapalczynski; geomoose-users at lists.sourceforge.net;
geomoose-developers at lists.sourceforge.net
Subject: Re: [Geomoose-developers] Retrieving Records from Database

I assume I have to add this as well in the ....demo.xml file 

 

                                                <map
title="Parcel_Points_db" data="true" popups="true" default="True">

 
<file>/ms4w/apps/GeoMOOSE/Maple_Grove_GeoMoose/parcels/parcels_8bit.map<
/file>

                                                </map>

 

I know this is not correct...does anyone know how to modify the code
above to read a database....

 

Am I even on the right path?

 

Thanks

 

From: geomoose-developers-bounces at lists.sourceforge.net
[mailto:geomoose-developers-bounces at lists.sourceforge.net] On Behalf Of
Jay Kapalczynski
Sent: Tuesday, July 15, 2008 4:19 PM
To: geomoose-users at lists.sourceforge.net;
geomoose-developers at lists.sourceforge.net
Subject: [Geomoose-developers] Retrieving Records from Database

 

If I am using this code below to try and retrieve records from a
database:  Does anyone know how to format the Template.html....

 

Can what I am trying to do be done?

 

I have tried but am not having any luck returning the records from the
database.

 

This should simply show up in the Info Tab correct?

 

 

                LAYER

                                NAME 'Parcels'

                                CONNECTIONTYPE OGR

                                CONNECTION 'SomeDatabase.mdb'

                                DATA 'TableName'

                                STATUS ON

                                TYPE LINE

                                #TOLERANCEUNITS FEET

                                TOLERANCE 0.3

                                TEMPLATE 'SomeTemplate.html'

                END

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20080725/57d86f23/attachment.html