[mapserver-users] Join shapefile to csv

[Heather Wirth]

I am trying to join my parcel shapefile to tax information stored as a
.csv file.  I have follwed the instructions at
http://mapserver.gis.umn.edu/docs/reference/mapfile/join with no
success.

Here is the Layer object from the mapfile:

LAYER
	NAME 'Parcels'
	DATA './Parcels.shp'
	STATUS DEFAULT
	TYPE LINE
	JOIN
		NAME "TaxInfo"
		TABLE "./20081008.csv"
		FROM "TaxPIN"
		TO "PIN"
		TYPE ONE-TO-ONE
	END
	CLASS
		NAME 'Parcel Boundary'
		TYPE LINE
		STYLE
		     COLOR 3 3 3
		     OUTLINECOLOR 0 0 0
		     WIDTH 1
		END
	END
END

Here is the html identify template:

<tr BGCOLOR="969696">
<td colspan="2"><u><b>Parcel Information</b></u></td>
</tr>
<tr>
<td><em>Parcel ID:</em></td><td>[TaxPIN]</td>
</tr>
<tr>
<td><em>Owner Name:</em></td><td>[TaxInfo_PRIM TAXP NAME]",
"[TaxInfo_PRIM TAXP NAME 2]</td>
</tr>

Here is what is an example of what is returned when I identify the
parcels:

Parcel Information 
Parcel ID: 040023800 
Owner Name: [TaxInfo_PRIM TAXP NAME]", "[TaxInfo_PRIM TAXP NAME 2] 

Using the tool does not cause any sort of an error.  I'm hoping that
there is something simple I am missing.  Any help would be much
appreciated.

Heather Wirth
Benton County, MN