[mapserver-users] Join to CSV

[Jeff McKenna]

Heather Wirth wrote:
> 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.
> 
> Benton County, MN

I think you should also include the ogrinfo '-summary' output for both 
your shp and your csv (as shown on the web page you referred to), so 
people on this list can see all field names.  I'm guessing that your csv 
contains a "PRIM TAXP NAME 2" field right?  Maybe those spaces in the 
column-name are causing trouble...I might try to see what happens if you 
rename the column with a simpler name without spaces.

-- 
Jeff McKenna
FOSS4G Consulting and Training Services
http://www.gatewaygeomatics.com/