join with dbf file

Richard Greenwood richard.greenwood at GMAIL.COM
Mon May 14 07:14:06 PDT 2007


On 5/14/07, Fischer, Brian <bfischer at houstonengineeringinc.com> wrote:
> Rich,
>
> You are correct, I am just trying to display attribute data from the
> join table.
>
> -Brian

I don't know if this will help, but here is an example of displaying
attribute data from a one-to-many relationship:


LAYER
	NAME  "join"
	GROUP "ownership"
	STATUS ON
	TYPE POLYGON
	PROJECTION
		"init=epsg:2241" # NAD83 / Idaho East (ftUS)
	END
	DATA  "join"
	HEADER "attribute_header.html"
	FOOTER "attribute_footer.html"
	TEMPLATE "attribute_display.html"
	JOIN	# JOIN no longer lives inside of CLASS or inside a QUERY object
		NAME "cats"
		TABLE "/Inetpub/wwwroot/mapserver/fc/data/cat.DBF"
		FROM DESCRIPTOR
		TO	PIDN
		TYPE  one-to-many # multiple
		TEMPLATE  cat.html	# required only for one-to-many joins
	END # of JOIN Object
	CLASSITEM "CLERK_REC"
	CLASS
		Name "Lot and Parcel Lines"
		SYMBOL "Solid"
		OUTLINECOLOR 0 0 0
		SIZE 2
	END  # class
END  # layer join

cat.html:

<TR><TD>[cats_ACRES] </TD><TD>Acres </TD><TD>[cats_CATEGORY]</TD></TR>


-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com



More information about the MapServer-users mailing list