[Mapserver-users] Projection conversion
nicolas.fortin at ec.gc.ca
nicolas.fortin at ec.gc.ca
Fri Oct 31 11:22:14 EST 2003
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C39FCB.24D8C7B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Now I wonder if anybody here already try Mapserver 4.0 with Oracle =
Spatial
...
=20
Each time I ask a question...no answer. I search the archives and each =
time
someone ask a specific question about Oracle (other than compiling for =
older
version) ... no answer.
=20
The projection is not my only concern, I have problems with other =
features
(supported?) of mapserver not directly answered in the doc/archives.
=20
One of our Oracle table is BATHYMETRY with 113 000 000 rows. ( TYPE =
POINT )
=20
1) I want mapserver to FILTER the data depending on the zoom level or =
the
bounding box. How can I do this with mapserver ? Do I have to make =
multiple
layers with different FILTER ? I don't want this to be dynamically done
cause my ultimate goal is WMS.
=20
2) I want my bathymetry point to be of different color depending on Z =
value
(number(23,10)). I can do this with CLASSITEM and EXPRESSION in CLASS =
but
mapserver doesn't seem to understand my regex... It works fine with my
SHORELINE.DXFELEVATION fields (number(10)) but not with BATHYMETRY. =
Why??
=20
3) How can I make LINE wider or POINT bigger ? I tried using SIZE =
without
success.
=20
Thx,
=20
Nicolas Fortin=20
Math=E9maticien, Programmeur, Analyste de donn=E9es=20
SMC-Qu=E9bec Hydrologie, Environnement Canada=20
1141, Rte de l'=C9glise, Sainte-Foy(QC) G1V 4H5=20
(418)648-2516=20
nicolas.fortin at ec.gc.ca <mailto:nicolas.fortin at ec.gc.ca
<mailto:nicolas.fortin at ec.gc.ca> >=20
-----Message d'origine-----
De : nicolas.fortin at ec.gc.ca [mailto:nicolas.fortin at ec.gc.ca]=20
Envoy=E9 : Wednesday, October 29, 2003 2:27 PM
=C0 : mapserver-users at lists.gis.umn.edu
Objet : [Mapserver-users] Projection conversion
Hi,
=20
I'm new to mapserver and I'm making some tests to make it work with =
Oracle
spatial (very simple tests though).
=20
One of my test consist of two layers, one in Lambert Conformal Conic =
(LCC)
and the other in NAD83 MTM Zone 8.
=20
I wonder if I have to do something special to make Mapserver convert =
between
projection...
=20
For the mapfile below, only the LCC layer is visible in the bounding =
box.
=20
# BEGIN MAPFILE
# Mapserver test 3 for Oracle
# Nicolas Fortin, Env Can nicolas.fortin at ec.gc.ca
<mailto:nicolas.fortin at ec.gc.ca>=20
=20
NAME MS_ORA_TEST_3
EXTENT 7613000 1218000 7620000 1227000
#EXTENT 275000 5019000 280000 5027000
SIZE 350 450
PROJECTION
"init=3Depsg:102002"
END
=20
LAYER # Test table
NAME "PointTest"
TYPE POINT
CONNECTIONTYPE oraclespatial
CONNECTION "martins/****@bayfield <mailto:martins/****@bayfield> "
DATA "GEOLOC FROM MARTINS.CT_LCC_MI"
STATUS DEFAULT
DUMP TRUE
=20
PROJECTION
"init=3Depsg:102002"
END
=20
CLASS # PolyClass
NAME "Point"
COLOR 0 100 240
OUTLINECOLOR 0 0 0
END
=20
END # LAYER
=20
LAYER # Test table
NAME Shoreline
TYPE LINE
CONNECTIONTYPE oraclespatial
CONNECTION "usr_bathy/****@bayfield <mailto:usr_bathy/****@bayfield> =
"
DATA "GEOLOC FROM USR_BATHY.SHORELINE USING SRID 82196"
STATUS DEFAULT
DUMP TRUE
=20
PROJECTION
"init=3Depsg:2145"
END
=20
CLASS # PolyClass
NAME "Shoreline"
COLOR 0 0 0
#LABEL
# COLOR 0 0 0
#END # LABEL
END
=20
END # LAYER
=20
END
# END MAPFILE
Thx,
Nicolas Fortin=20
Math=E9maticien, Programmeur, Analyste de donn=E9es=20
SMC-Qu=E9bec Hydrologie, Environnement Canada=20
1141, Rte de l'=C9glise, Sainte-Foy(QC) G1V 4H5=20
(418)648-2516=20
nicolas.fortin at ec.gc.ca <mailto:nicolas.fortin at ec.gc.ca
<mailto:nicolas.fortin at ec.gc.ca> >=20
=20
------_=_NextPart_001_01C39FCB.24D8C7B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff size=3D2>Now I=20
wonder if anybody here already try Mapserver 4.0 with Oracle Spatial=20
...</FONT></SPAN></DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff size=3D2>Each=20
time I ask a question...no answer. I search the archives and each =
time=20
someone ask a specific question about Oracle (other than compiling for =
older=20
version) ... no answer.</FONT></SPAN></DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff size=3D2>The=20
projection is not my only concern, I have problems with other features=20
(supported?) of mapserver not directly answered in the=20
doc/archives.</FONT></SPAN></DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff size=3D2>One of=20
our Oracle table is BATHYMETRY with 113 000 000 rows. ( TYPE POINT=20
)</FONT></SPAN></DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff size=3D2>1) I=20
want mapserver to FILTER the data depending on the zoom level or the =
bounding=20
box. How can I do this with mapserver ? Do I have to make =
multiple layers=20
with different FILTER ? I don't want this to be dynamically done cause =
my=20
ultimate goal is WMS.</FONT></SPAN></DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff size=3D2>2) I=20
want my bathymetry point to be of different color depending on Z value=20
(number(23,10)). I can do this with CLASSITEM and EXPRESSION in CLASS =
but=20
mapserver doesn't seem to understand my regex... It works fine with my=20
SHORELINE.DXFELEVATION fields (number(10)) but not with =
BATHYMETRY.=20
Why??</FONT></SPAN></DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff size=3D2>3) How=20
can I make LINE wider or POINT bigger ? I tried using =
SIZE=20
without success.</FONT></SPAN></DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Thx,</FONT></SPAN></DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2><B><I><FONT face=3D"Bookman Old Style" color=3D#000080=20
size=3D2></FONT></I></B></FONT></SPAN> </DIV>
<DIV><SPAN class=3D199465915-31102003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2><B><I><FONT face=3D"Bookman Old Style" color=3D#000080 =
size=3D2>Nicolas=20
Fortin</FONT></I></B><I></I> <BR><B><FONT face=3DArial =
size=3D1>Math=E9maticien,=20
Programmeur, Analyste de donn=E9es</FONT></B> <BR><B><FONT face=3DArial =
size=3D1>SMC-Qu=E9bec Hydrologie, Environnement Canada</FONT></B> =
<BR><B><FONT=20
face=3DArial size=3D1>1141, Rte de l'=C9glise, Sainte-Foy(QC) G1V =
4H5</FONT></B>=20
<BR><B><FONT face=3DArial size=3D1>(418)648-2516</FONT></B> =
<BR><U><FONT face=3DArial=20
color=3D#0000ff size=3D1>nicolas.fortin at ec.gc.ca <<A=20
href=3D"mailto:nicolas.fortin at ec.gc.ca">mailto:nicolas.fortin at ec.gc.ca</=
A>></FONT></U>=20
</DIV></FONT></SPAN>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Dfr dir=3Dltr =
align=3Dleft><FONT face=3DTahoma=20
size=3D2>-----Message d'origine-----<BR><B>De :</B> =
nicolas.fortin at ec.gc.ca=20
[mailto:nicolas.fortin at ec.gc.ca] <BR><B>Envoy=E9 :</B> =
Wednesday, October=20
29, 2003 2:27 PM<BR><B>=C0 :</B>=20
mapserver-users at lists.gis.umn.edu<BR><B>Objet :</B> =
[Mapserver-users]=20
Projection conversion<BR><BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D805162019-29102003>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D805162019-29102003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D805162019-29102003>I'm =
new to=20
mapserver and I'm making some tests to make it work with Oracle =
spatial (very=20
simple tests though).</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D805162019-29102003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D805162019-29102003>One =
of my test=20
consist of two layers, one in Lambert Conformal Conic (LCC) and =
the other=20
in NAD83 MTM Zone 8.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D805162019-29102003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D805162019-29102003>I =
wonder if I have=20
to do something special to make Mapserver convert between=20
projection...</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D805162019-29102003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D805162019-29102003>For =
the mapfile=20
below, only the LCC layer is visible in the bounding =
box.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D805162019-29102003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D805162019-29102003># =
BEGIN=20
MAPFILE</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D805162019-29102003># =
Mapserver test 3=20
for Oracle<BR># Nicolas Fortin, Env Can <A=20
=
href=3D"mailto:nicolas.fortin at ec.gc.ca">nicolas.fortin at ec.gc.ca</A></SPA=
N></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D805162019-29102003>NAME=20
MS_ORA_TEST_3<BR>EXTENT 7613000 1218000 7620000 1227000<BR>#EXTENT =
275000=20
5019000 280000 5027000<BR>SIZE 350 450<BR>PROJECTION<BR> =20
"init=3Depsg:102002"<BR>END</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D805162019-29102003>LAYER # Test=20
table<BR> NAME "PointTest"<BR> TYPE POINT<BR> =
CONNECTIONTYPE=20
oraclespatial<BR> CONNECTION "<A=20
=
href=3D"mailto:martins/****@bayfield">martins/****@bayfield</A>"<BR>&nbs=
p; DATA=20
"GEOLOC FROM MARTINS.CT_LCC_MI"<BR> STATUS DEFAULT<BR> =
DUMP=20
TRUE<BR> <BR> PROJECTION<BR> =20
"init=3Depsg:102002"<BR> END<BR> <BR> CLASS #=20
PolyClass<BR> NAME "Point"<BR> =
COLOR 0 100=20
240<BR> OUTLINECOLOR 0 0 0<BR> =
END</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D805162019-29102003>END =
#=20
LAYER</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D805162019-29102003>LAYER # Test=20
table<BR> NAME Shoreline<BR> TYPE LINE<BR> =
CONNECTIONTYPE=20
oraclespatial<BR> CONNECTION "<A=20
=
href=3D"mailto:usr_bathy/****@bayfield">usr_bathy/****@bayfield</A>"<BR>=
=20
DATA "GEOLOC FROM USR_BATHY.SHORELINE USING SRID 82196"<BR> =
STATUS=20
DEFAULT<BR> DUMP TRUE<BR> <BR> =20
PROJECTION<BR> "init=3Depsg:2145"<BR> =
END<BR> =20
<BR> CLASS # PolyClass<BR> NAME=20
"Shoreline"<BR> COLOR 0 0 0<BR> =20
#LABEL<BR> # COLOR 0 0 =
0<BR> #END #=20
LABEL<BR> END<BR> <BR>END # LAYER</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D805162019-29102003>END</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D805162019-29102003># END=20
MAPFILE<BR></DIV></SPAN></FONT>
<DIV><SPAN class=3D805162019-29102003><FONT face=3DArial=20
size=3D2>Thx,</FONT></SPAN></DIV>
<P><B><I><FONT face=3D"Bookman Old Style" color=3D#000080 =
size=3D2>Nicolas=20
Fortin</FONT></I></B><I></I> <BR><B><FONT face=3DArial =
size=3D1>Math=E9maticien,=20
Programmeur, Analyste de donn=E9es</FONT></B> <BR><B><FONT =
face=3DArial=20
size=3D1>SMC-Qu=E9bec Hydrologie, Environnement Canada</FONT></B> =
<BR><B><FONT=20
face=3DArial size=3D1>1141, Rte de l'=C9glise, Sainte-Foy(QC) G1V =
4H5</FONT></B>=20
<BR><B><FONT face=3DArial size=3D1>(418)648-2516</FONT></B> =
<BR><U><FONT=20
face=3DArial color=3D#0000ff size=3D1>nicolas.fortin at ec.gc.ca <<A=20
=
href=3D"mailto:nicolas.fortin at ec.gc.ca">mailto:nicolas.fortin at ec.gc.ca</=
A>></FONT></U>=20
</P>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C39FCB.24D8C7B0--
More information about the mapserver-users
mailing list