join with dbf file
Richard Greenwood
richard.greenwood at GMAIL.COM
Sun May 13 19:46:00 PDT 2007
On 5/13/07, Fischer, Brian <bfischer at houstonengineeringinc.com> wrote:
> Hi Rich,
>
> Thanks for the reply. Everything is working fine for the "Parcel
> Selected" class. The problem I am having is in the "Multi-Interest
> Parcel" class. The parcels represent properties like condos where there
> are multiple owners associated with one polygon. I have a table that
> relates to those polygons and would like to display all the owners in
> the query template using a one-to-many join. When I do an nquery on one
> of those multi-owner polygons, it returns attributes from the data
> source in the layer, but nothing from the join .dbf file.
So you are not trying to draw a map highliting multiple parcel
polygons, you want to display attribute data (like owner name,
address, etc.) for multiple records associated with a single polygon.
Am I right? I have an application in which I am doing something like
this and I can say that it is pretty straight forward. Unfortunately,
the app where I'm doing it is not publicly accessible so you can not
easily see it, and I'm traveling, so I can not easily attach any code
snippets.
More generally, I've struggled wit the
condo-as-one-to-many-relationship issue for years, and basically, I
don't see condos as one-to-many, they are one-to-one. Put a spatial
object (either a point, or a small polygon) on the map for each record
in your table.
Rich
--
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com
More information about the MapServer-users
mailing list