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

2006-10-30 Thread Gabe 
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: 
> >>> 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 
> >>> [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

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 ?
> 
> 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: 
>>> 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 
>>> [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

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, 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: 
> >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 
> >[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

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]> wrote:
>
>
> 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
> [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
>
>
>


-- 
luca marletta
www.beopen.it

-
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