Thanks - I can see that is going to be very useful
On 10/28/06, Armin Burger <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > >>> To: <pmapper-users@lists.sourceforge.net> > >>> CC: [EMAIL PROTECTED] > >>> 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ía y Programación en Internet. > >>> http://www.lainfo.com.mx <http://www.lainfo.com.mx/> > >>> [EMAIL PROTECTED] > >>> Emails muy pesados a: [EMAIL PROTECTED] > >>> Tel:(++5255) 8589-1554 > >>> Movil: 04455-1967-1907 > >>> > >>> > >>> > >>> > >> > >>> _______________________________________________ > >>> Pmapper-users mailing list > >>> [EMAIL PROTECTED] > >>> 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 > >> [EMAIL PROTECTED] > >> 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=lnk&kid=120709&bid=263057&dat=121642 > > _______________________________________________ > > pmapper-users mailing list > > pmapper-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/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=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
