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

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

Thanks - I can see that is going to be very useful


On 10/28/06, Armin Burger <arm...@gm...> wrote:
>
> if you need it dynamically adapted to a search value you either have to
> modify via Mapscript the DATA tag with the complete SQL (adapting the
> one below), or modify the FILTER tag with the WHERE part of the SQL.
>
> armin
>
> Gabe wrote:
> > 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
> >>
> >>
> >>
> >
> -------------------------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web services,
> security?
> > Get stuff done quickly with pre-integrated technology to make your job
> easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> > _______________________________________________
> > pmapper-users mailing list
> > pma...@li...
> > https://lists.sourceforge.net/lists/listinfo/pmapper-users
> >
> >
>