[mapserver-users] problem with join
Richard Greenwood
Rich@GreenwoodMap.com
Mon, 04 Mar 2002 21:53:54 -0700
--=====================_634324718==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
You can create a join in your map file. Here's an example:
Class
Join
from PIDN
name jointest
table "\Tc\DATA\assessor.DBF"
# TEMPLATE join_region.shp_query.html # required only for
one-to-many joins
to Pidn
type single
End # of Join Object
SYMBOL "Solid"
OUTLINECOLOR 0 0 0
END # of Class
This is pretty well documented. Be careful how much editing is done to the
dbf - adding or deleting records will break the join.
Also note that you can only use a join for queries, not labeling. If you
need to label features off the dbf you are out of luck. You will need to
create the join in ArcView or MapInfo, and save it out as a single, static
layer.
Rich
At 11:54 AM 3/4/2002 +0100, you wrote:
>hi,
>
>my (little) problem:
>
>i have a shape and i have ab big dbf-file.
>the polys in the shape have 1 (one!) item - the ID , all other dates are
>in the dbf (landuse, name, number, ........)
>i want to join both files to shade the poly in different views (first
>landuse, later name, ....)
>my users should only edit in the dbf-file!
>
>and now my problem: how must I join to shade different with datas from the
>joined dbf???
>who has an example for me (map-file?)
>
>great thanks.
>mikeE.:-)
Richard W. Greenwood, PLS
Greenwood Mapping, Inc.
Rich@GreenwoodMap.com
(307) 733-0203
http://www.GreenwoodMap.com
--=====================_634324718==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
You can create a join in your map file. Here's an example:<br><br>
Class<br>
Join<br>
from PIDN<br>
name jointest<br>
table
"\Tc\DATA\assessor.DBF"<br>
# TEMPLATE
join_region.shp_query.html # required only for one-to-many
joins<br>
to<x-tab> </x-tab>Pidn<br>
type single<br>
End # of Join Object<br>
SYMBOL
"Solid"<x-tab> </x-tab><x-tab> </x-tab><br>
OUTLINECOLOR 0 0 0<br>
END # of Class<br><br>
This is pretty well documented. Be careful how much editing is done to
the dbf - adding or deleting records will break the join.<br><br>
Also note that you can only use a join for queries, not labeling. If you
need to label features off the dbf you are out of luck. You will need to
create the join in ArcView or MapInfo, and save it out as a single,
static layer.<br><br>
Rich<br><br>
<br>
At 11:54 AM 3/4/2002 +0100, you wrote:<br>
<blockquote type=cite class=cite cite><font face="arial" size=2>hi,
</font><br>
<br>
<font face="arial" size=2>my (little) problem:</font><br>
<br>
<font face="arial" size=2>i have a shape and i have ab big
dbf-file.</font><br>
<font face="arial" size=2>the polys in the shape have 1 (one!) item
- the ID , all other dates are in the dbf (landuse, name, number,
........)</font><br>
<font face="arial" size=2>i want to join both files to shade the poly in
different views (first landuse, later name, ....)</font><br>
<font face="arial" size=2>my users should only edit in the
dbf-file!</font><br>
<br>
<font face="arial" size=2>and now my problem: how must I join to shade
different with datas from the joined dbf???</font><br>
<font face="arial" size=2>who has an example for me
(map-file?)</font><br>
<br>
<font face="arial" size=2>great thanks.</font><br>
<font face="arial" size=2>mikeE.:-)</blockquote>
<x-sigsep><p></x-sigsep>
<br>
Richard W. Greenwood, PLS<br>
Greenwood Mapping, Inc.<br>
Rich@GreenwoodMap.com<br>
(307) 733-0203<br>
<a href="http://www.greenwoodmap.com/" eudora="autourl">http://www.GreenwoodMap.com</a></font></html>
--=====================_634324718==_.ALT--