[mapserver-users] question about joining

Mark Volz MarkVolz at co.lyon.mn.us
Tue Oct 26 11:28:34 EDT 2010


Hello,

I have not used the Join shapefile to database function in mapserver before.
I just have a couple questions

*	The description explains that "It is important to understand that
JOINs are ONLY available once a query has been processed. You cannot use
joins to affect the look of a map."  Does that mean that we can only use the
joins for templates.  If possible, I would like to label using a field in a
joined table.
*	Is the following formatted correctly 

		#CLASSITEM 'PARC_CODE'
		JOIN #TEST
			NAME "MyJoin"
			TABLE "LyonCounty/Parcels/test.dbf" #location of the
dbf file
			FROM "PARCEL_ID"  #shapefile field
			TO "PIN"   #dbf field
			TYPE ONE-TO-ONE
		END #JOIN
		...
			TEXT ("Name" * [MyJoin_MYNAME])  #label using the
joined table

Thanks


Mark Volz
GIS Specialist
Lyon County, MN


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20101026/d5d7c8e6/attachment-0001.html


More information about the mapserver-users mailing list