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

[Armin B. <arm...@gm...>]

if you need it dynamically adapted to a search value you either have to=20
modify via Mapscript the DATA tag with the complete SQL (adapting the=20
one below), or modify the FILTER tag with the WHERE part of the SQL.

armin

Gabe wrote:
> Where would we put this sql ?
>=20
> in the mapfile layer object ?
>=20
> or as a view in postgis ?
>=20
>=20
> G
>=20
>=20
> 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, securit=
y?
> 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 Geron=
imo
> 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
>=20
>=20