[Mapserver-users] help on mygis

Wed Jul 28 14:59:26 PDT 2004

This is a multi-part message in MIME format.

------=_NextPart_000_0039_01C474D5.00FC0930
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

hello friends
i need some help from you

this is a brief description of my problem:

i have a grupos2002.shp file uploaded into mysql using the shp2mysql.lp, =
and it is working properly

this script generated the following tables geometry_columns, grupos2002, =
grupos2002_bin, grupos2002_num
, spatial_ref_sys

in the map file i have this definition for the connection and data:
CONNECTION "localhost:gisusr:gis:gisdb:bin:"
DATA "geometry from grupos2002 feature, grupos2002_bin geometry"
and it is working fine

my problem is:
i have a table zonas with the following fields:
1- f_Zona ( olso located in grupos2002 )
2- Description
3- Atributos

so, i need to use the field number 2 ( Description) as Label in the map =
and i need to apply some filters using the field number=20
3 (Atributos).

THE BIG CUESTION IS: how should i contruct my DATA definition in the map =
file ????

i hope you could understand me

thank you very much
by

pablo schmitt
municipalidad de malvinas argentinas
dep. inform=E1tica

=20

------=_NextPart_000_0039_01C474D5.00FC0930
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>hello friends</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>i need some help from you</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>this is a brief description of my=20
problem:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>i have a grupos2002.shp file uploaded =
into mysql=20
using the shp2mysql.lp, and it is working properly</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>this script generated the following =
tables=20
geometry_columns, grupos2002, grupos2002_bin, =
grupos2002_num</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>, spatial_ref_sys</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>in the map file i have this definition =
for the=20
connection and data:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>CONNECTION=20
"localhost:gisusr:gis:gisdb:bin:"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>DATA "geometry from grupos2002 feature, =

grupos2002_bin geometry"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>and it is working fine</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>my problem is:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>i have a table zonas with the following =

fields:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>1- f_Zona ( olso located in grupos2002=20
)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>2- Description</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>3- Atributos</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>so, i need to use the field number 2 ( =
Description)=20
as Label in the map and i need to apply some filters using the field =
number=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>3 (Atributos).</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>THE BIG CUESTION IS: how should i =
contruct my DATA=20
definition in the map file ????</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>i hope you could understand =
me</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>thank you very much</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>by</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>pablo schmitt</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>municipalidad de malvinas =
argentinas</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>dep. inform=E1tica</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>

------=_NextPart_000_0039_01C474D5.00FC0930--