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/
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
