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
