[Mapserver-users] Fw: help on mygis

Thu Jul 29 05:47:43 PDT 2004

This is a multi-part message in MIME format.

------=_NextPart_000_001A_01C47551.18844960
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

----- Original Message -----=20
From: pablo_schmitt_=20
To: mapserver-users at lists.gis.umn.edu=20
Sent: Wednesday, July 28, 2004 6:59 PM
Subject: help on mygis

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

------=_NextPart_000_001A_01C47551.18844960
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> </DIV>
<DIV style=3D"FONT: 10pt arial">----- Original Message -----=20
<DIV style=3D"BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A=20
title=3Dpablo_schmitt_ at hotmail.com=20
href=3D"mailto:pablo_schmitt_ at hotmail.com">pablo_schmitt_</A> </DIV>
<DIV><B>To:</B> <A title=3Dmapserver-users at lists.gis.umn.edu=20
href=3D"mailto:mapserver-users at lists.gis.umn.edu">mapserver-users at lists.g=
is.umn.edu</A>=20
</DIV>
<DIV><B>Sent:</B> Wednesday, July 28, 2004 6:59 PM</DIV>
<DIV><B>Subject:</B> help on mygis</DIV></DIV>
<DIV><BR></DIV>
<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_001A_01C47551.18844960--