postgis

[Giuseppe Molinario]

Erensto thanks for the reply,

I am using postgresql 8.2.3.1, and Postgis 1.2.1.1

whereas my app was working fine before, i needed to try and see how
mapserver would deal with two "identical" points in the database.... well it
pretty much stops working when that layer is on now.

about the classes.

i simply need a postgis layer to have two classes, these need to contain
more that one expression value - not dynamically. example

layer x

class 1
EXPRESSION ([ID_specie_att]=2) and also EXPRESSION ([ID_specie_att]=3) and
EXPRESSION ([ID_specie_att]=4)

class 2
EXPRESSION ([ID_specie_att]=5)EXPRESSION ([ID_specie_att]=6)EXPRESSION
([ID_specie_att]=7)

i cant seem to get my head around a syntax to tell the EXPRESSION that it is
actually a list of values.


Thanks for the help,

Giuseppe

On 6/14/07, Ernesto Vega <ernesvega at gmail.com> wrote:
>
> Giuseppe :
>
> I´ve never been into the situation of having 2 points overlapped.
>
> For a better idea is useful to send which versions of postgresql and
> postgis your are using.
>
> For the class question:
>
> Are you planning to dynamically change your parameter ?
>
> If so, you must read the chapter dedicated on how to use parameters on
> mapserver site, otherwise you may have no choice because of what you
> want to alter within a class
>
> hope this helps.
>
> Ernesto Vega
>
> On 6/14/07, Giuseppe Molinario <g.molinario at gmail.com> wrote:
> > Hi everyone,
> >
> > I am working with a postgis point table that needs to be displayed in a
> > mapserver application (pmapper).
> >
> > my problems:
> >
> > 1. what happens when two points are in the same exact location? ( the
> rows
> > in my table can sometimes have the identical lat long coordinates and
> > therefore geometry column.)
> >
> > how can i set the mapfile to show me both points and labels? is this
> ever
> > possible? I realize this is a bit of werid question, but i am not asking
> > about topology...just nuts and bolt postgis/mapfile....
> > the query tool does not respond anymore. seems like having two identical
> > points prevents the query tool from working
> > this all worked prior to me having "overlapping" points2. different
> > question. Layer>class in mapfile: I have an EXPRESSION object that goes
> like
> > this  EXPRESSION ([ID_specie_att]=2) now how do i get the SAME class to
> > display both points that have value 2,3,4,5,6? Do i really have to make
> 5
> > different classes? I would rather not because i don't want them in my
> > legend.
> >
> >
> > thanks very much for any help.
> >
> > Giuseppe
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070614/f69fbc26/attachment.htm>