Fwd: Re: [Mapserver-users] Fw: help on mygis

[Lowell Filak]

The following message was sent by "pablo" <pablo_schmitt_ at hotmail.com>
on Wed, 4 Aug 2004 14:04:50 -0300.

> EXAMPLE:
> ===========
> PLEASE SEND EXAMPLE THIS IN MYSQL (MYGIS)
> por favor envieme un ejemplo de esto para mysql, o bien como tradusco
esto a
> mi MAP
> yo quise hacer esto y no pude no encuentro forma de hacerlo.
> 
> DATA "the_geom from
> (select nut3.the_geom,
> case when un3rt.unit > 16 then 1
> when un3rt.unit > 10 and un3rt.unit < 16 then 2
> when un3rt.unit > 5 and un3rt.unit < 10 then 3
> when un3rt.unit > 0 and un3rt.unit < 5 then 4
> else 5
> end as myclass
> from nut3,un3rt
> where nut3.nurgcd=un3rt.geo
> ) as foo"
> 
> 
> CLASSITEM myclass
> CLASS
> EXPRESSION 1
> COLOR 255 0 0
> END
> CLASS
> EXPRESSION 2
> COLOR 250 100 100
> END
> CLASS
> EXPRESSION 3
> COLOR 250 200 200
> END
> CLASS
> EXPRESSION 4
> COLOR 250 220 220
> END
> CLASS
> EXPRESSION 5
> COLOR 210 210 210
> END
> 
> 
> ----- Original Message ----- 
> From: "Lowell Filak" <lfilak at medinaco.org>
> To: "pablo" <pablo_schmitt_ at hotmail.com>
> Sent: Monday, August 02, 2004 10:36 AM
> Subject: Re: [Mapserver-users] Fw: help on mygis
> 
> 
> > Unfortunately the new list server doesn't appear to be working, however
> > you need to submit this to the list. I only have limited knowledge of
> > what your trying to accomplish. My original suggestion was to combine
> > all your attributes into a single MySQL table so you could work on the
> > labelling issues without the added complexity of relating two tables in
> > MySQL.
> >
> > HTH
> >
> > Lowell
> >
> > The following message was sent by "pablo" <pablo_schmitt_ at hotmail.com>
> > on Fri, 30 Jul 2004 18:00:33 -0300.
> >
> > > Hello again,
> > >
> > > This is a piece of my MAP FILE :
> > >
> > > LAYER
> > >     NAME "grupos2002"
> > >     STATUS ON
> > >     CONNECTIONTYPE mygis
> > >     CONECTION "localhost:gisusr:gis:gisdb:bin:"
> > >     DATA "geometry from grupos2002 feature, grupos2002_bin geometry"
> > >
> > >     CLASS
> > >         NAME "Zona Geo"
> > >         OUTLINECOLOR 60 60 60
> > >         COLOR 255 255 0
> > >         SYMBOL 0
> > >     END
> > > END
> > >
> > > LAYER
> > >     STATUS ON
> > >     CONNECTIONTYPE mygis
> > >     CONECTION "localhost:gisusr:gis:gisdb:bin:"
> > >     DATA ????????????????????????????????
> > >     TYPE ANNOTATION
> > >     LABELITEM ??????????????????????
> > >     CLASS
> > >         ANGLE AUTO
> > >         SIZE 8
> > >         COLOR 0 192 0
> > >         TYPE TRUETYPE
> > >         FONT ARIAL
> > >     END
> > > END
> > >
> > > I have a table zonas with the following fields:
> > > 1- f_Zona ( olso located in grupos2002 )
> > > 2- Description
> > > 3- Atributos
> > >
> > > Questions :
> > >
> > > - What do I have to do to link the f_zona field (Zonas Table) to
f_zona
> > > (Grupos2002 table)?. I need to use Description field (Zonas table) as
> > label
> > > of the LAYER ANNOTATION.
> > >
> > > - I don't know how to make the query that map server needs to link or
> join
> > > the data of  my zona table with the data of the map.
> > >
> > > - How should i write this query ?
> > >
> > > - Could I use a custom query to get the geometric data of  grupos2002,
> > > grupos2002.bin?
> > >     DATA "geometry from grupos2002 feature, grupos2002_bin
> > geometry"---- >>>
> > > Is it posible to write this in ANSI query( select xxx from xxx where
> > > ..etc.) ? Example please!!!
> > >
> > > - Do I need more extra fields in the zonas table to get this work
well?
> > >
> > > thank you very much!!!
> > > Pablo
> > >
> > >
> > > ----- Original Message ----- 
> > > From: "Lowell Filak" <lfilak at medinaco.org>
> > > To: "pablo_schmitt_" <pablo_schmitt_ at hotmail.com>;
> > > <mapserver-users at lists.gis.umn.edu>
> > > Sent: Thursday, July 29, 2004 11:09 AM
> > > Subject: Re: [Mapserver-users] Fw: help on mygis
> > >
> > >
> > > > I don't know mygis but as a quick fix you could join all the
> attributes
> > > > into the first layer so there is no relate required to do the
> > labelling.?
> > > >
> > > > Lowell
> > > >
> > > > The following message was sent by "pablo_schmitt_"
> > > > <pablo_schmitt_ at hotmail.com> on Thu, 29 Jul 2004 09:47:43 -0300.
> > > >
> > > > >
> > > > > ----- Original Message ----- 
> > > > > From: pablo_schmitt_
> > > > > To: mapserver-users at lists.gis.umn.edu
> > > > > 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
> > > > > 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ática
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> >
> >