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

2006-10-28 Thread Armin Burger
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 ?

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

2006-10-27 Thread Gabe
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,

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

2006-10-26 Thread luca marletta
It's not a question related to pmapper because it doesn't do it. My suggestion is to import shape into postgis and prepare a query for searching intersections. You can easily do there such. So the right pace to ask is postgis or mapserver ML. luca On 10/26/06, Cristian Rougier [EMAIL PROTECTED]