Re: [pmapper-users] [Pmapper-users] Street intersection PLEASE !!

[Gabe <ga...@ag...>]

Where would we put this sql ?

in the mapfile layer object ?

or as a view in postgis ?


G


On 10/27/06, Gail Long <cod...@ho...> wrote:
>
> For post gis layers:
>
>
> select streetnameField,
> oid, xmin(box3d(p.the_geom)) AS minx, ymin(box3d(p.the_geom)) AS miny,
> xmax(box3d(p.the_geom)) AS maxx, ymax(box3d(p.the_geom)) AS maxy
> from streettable p, (select the_geom from streettable where
> upper(nameField)
> like 'street1%') a
> where intersects(a.the_geom,p.the_geom) and upper(nameField) like
> 'street2';
>
>
> --
> Things are only difficult while you don't understand them.
>
>
>
>
>
> >From: "Cristian Rougier" <cri...@la...>
> >To: <pma...@li...>
> >CC: pma...@fa...
> >Subject: [Pmapper-users] Street intersection PLEASE !!
> >Date: Wed, 25 Oct 2006 23:32:55 -0500
> >
> >Dears, this is very urgent for me.
> >
> >I have a shape with street lines with a name field.
> >
> >I can find a street well in search section , but i need to find the
> >intersection of 2 streets.
> >
> >Is this possible ?  Please any idea !!
> >
> >Thank in advance
> >
> >Cristian
> >
> >
> >La Info
> >Tecnolog=EDa y Programaci=F3n en Internet.
> >http://www.lainfo.com.mx <http://www.lainfo.com.mx/>
> >cri...@la...
> >Emails muy pesados a: cri...@gm...
> >Tel:(++5255) 8589-1554
> >Movil: 04455-1967-1907
> >
> >
> >
> >
>
>
> >_______________________________________________
> >Pmapper-users mailing list
> >Pma...@fa...
> >http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users
>
> _________________________________________________________________
> Get FREE company branded e-mail accounts and business Web site from
> Microsoft Office Live
> http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/
>
>
>
>
> _______________________________________________
> Pmapper-users mailing list
> Pma...@fa...
> http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users
>
>
>