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

Brought to you by: arminburger

pmapper-users

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

From: luca m. <luc...@gm...> - 2006-10-26 07:49:43

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 <cri...@la...> 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=EDa y Programaci=F3n en Internet.
> 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
>
>
>


--=20
luca marletta
www.beopen.it

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

From: Gabe <ga...@ag...> - 2006-10-28 01:31:54

Where would we put this sql ?

in the mapfile layer object ?

or as a view in postgis ?


G


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
>
>
>

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

From: Armin B. <arm...@gm...> - 2006-10-28 10:19:00

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

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

From: Gabe <ga...@ag...> - 2006-10-31 00:36:35

Thanks - I can see that is going to be very useful


On 10/28/06, Armin Burger <arm...@gm...> 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 <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,
> 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=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> > _______________________________________________
> > pmapper-users mailing list
> > pma...@li...
> > https://lists.sourceforge.net/lists/listinfo/pmapper-users
> >
> >
>