[Mapserver-users] Unable to display points from Oracle Spatial
Jiri Potocny
potocny at espace.cz
Mon Mar 22 07:07:21 EST 2004
This is a multi-part message in MIME format.
------=_NextPart_000_0097_01C4100E.9C412C80
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable
Dear All,
I'm trying to display polygons and points stored in Oracle Spatial. I =
succeeded to display polygons, but failed to display points. Could =
anybody help me to sort this problem out?
Sample data from the table containing point geometries:
GR_ID SYMBOL
---------- ----------
NODE(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, =
SDO_ORDINATES)
=
-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
----
1 1501000040
SDO_GEOMETRY(2001, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 0, 6000, 4, 1, =
1), SDO_ORDINATE_ARRAY(1, 0, 0, -550006, -1280004))
2 1501000432
SDO_GEOMETRY(2001, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 0, 6000, 4, 1, =
1), SDO_ORDINATE_ARRAY(1, 0, 0, -550016, -1280004))
3 1201000023
SDO_GEOMETRY(2001, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 0, 6000, 4, 1, =
1), SDO_ORDINATE_ARRAY(,157142295, ,987575971, 0, -550004, -1280009))
Used map file:
# First test of UMN Map Server on Oracle Spatial
MAP
NAME "UMNORA1"
STATUS ON
SIZE 800 600
EXTENT -550022 -1280012 -549998 -1279998
UNITS METERS
IMAGECOLOR 255 255 255
FONTSET "fonts/fonts.list"
IMAGETYPE PNG
# Projection definition
PROJECTION
"init=3Depsg:4818" =20
END
# Symbol definitions
SYMBOL
NAME "circle"
TYPE ELLIPSE
POINTS 1 1 END
FILLED TRUE
END
# Web interface definition
WEB
LOG "/inetpub/wwwroot/tmp/_OraTest.log"
END
# Start of layer definitions
LAYER
NAME "parcels"
TYPE POLYGON
STATUS DEFAULT
CONNECTIONTYPE oraclespatial
CONNECTION "umn/umn at kataster"
DUMP TRUE
DATA "BOUNDARY from GRPARCELS"
PROJECTION
"init=3Depsg:4818" =20
END
CLASS
OUTLINECOLOR 0 0 0
END
END
LAYER
NAME "symboly"
TYPE POINT
STATUS DEFAULT
CONNECTIONTYPE oraclespatial
CONNECTION "umn/umn at kataster"
DUMP TRUE
DATA "NODE from GRSYMBOLS"
PROJECTION
"init=3Depsg:4818" =20
END
CLASS
NAME "Symboly"
STYLE
COLOR 255 0 0
SYMBOL "circle"
SIZE 10
END
END
END
END
Much appreciated,
Jirka
------=_NextPart_000_0097_01C4100E.9C412C80
Content-Type: text/html;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-2">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#d7d7d7>
<DIV><FONT face=3DArial size=3D2>Dear All,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to display polygons and =
points stored in=20
Oracle Spatial. I succeeded to display polygons, but failed to display =
points.=20
Could anybody help me to sort this problem out?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Sample data from the table =
containing point=20
geometries:</FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV><FONT face=3D"Courier New" size=3D1> =20
GR_ID SYMBOL<BR>----------=20
----------<BR>NODE(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), =
SDO_ELEM_INFO,=20
=
SDO_ORDINATES)<BR>-------------------------------------------------------=
-------------------------------------------------------------------------=
----------------------<BR>  =
;=20
1 1501000040<BR>SDO_GEOMETRY(2001, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, =
0, 6000,=20
4, 1, 1), SDO_ORDINATE_ARRAY(1, 0, 0, -550006, -1280004))</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV>
<DIV><FONT face=3D"Courier New"=20
size=3D1> 2=20
1501000432<BR>SDO_GEOMETRY(2001, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 0, =
6000,=20
4, 1, 1), SDO_ORDINATE_ARRAY(1, 0, 0, -550016, -1280004))</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV>
<DIV><FONT face=3D"Courier New"=20
size=3D1> 3=20
1201000023<BR>SDO_GEOMETRY(2001, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 0, =
6000,=20
4, 1, 1), SDO_ORDINATE_ARRAY(,157142295, ,987575971, 0, -550004,=20
-1280009))<BR></FONT></DIV></BLOCKQUOTE>
<DIV><FONT face=3DArial size=3D2>Used map file:</FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV><FONT face=3D"Courier New" size=3D1><BR># First test of UMN Map =
Server on=20
Oracle Spatial<BR>MAP<BR> =
NAME =20
"UMNORA1"<BR> STATUS ON<BR> =20
SIZE 800 600<BR> =20
EXTENT -550022 -1280012 -549998=20
-1279998<BR> UNITS =
METERS<BR> =20
IMAGECOLOR 255 255 255<BR> FONTSET =
"fonts/fonts.list"</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D1> IMAGETYPE =20
PNG</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D1> # Projection =
definition<BR> =20
PROJECTION<BR> "init=3Depsg:4818" <BR> =20
END</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D1> # Symbol =
definitions<BR> =20
SYMBOL<BR> NAME "circle"<BR> TYPE=20
ELLIPSE<BR> POINTS 1 1 END<BR> =
FILLED=20
TRUE<BR> END</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D1> # Web interface=20
definition<BR> WEB<BR> LOG=20
"/inetpub/wwwroot/tmp/_OraTest.log"<BR> END</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D1> # Start of layer=20
definitions<BR> LAYER<BR> NAME=20
"parcels"<BR> TYPE POLYGON<BR> =
STATUS=20
DEFAULT<BR> CONNECTIONTYPE=20
oraclespatial<BR> CONNECTION "</FONT><A=20
href=3D"mailto:umn/umn at kataster"><FONT face=3D"Courier New"=20
size=3D1>umn/umn at kataster</FONT></A><FONT face=3D"Courier New"=20
size=3D1>"<BR> DUMP TRUE<BR> DATA =
"BOUNDARY=20
from GRPARCELS"</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D1> =20
PROJECTION<BR> "init=3Depsg:4818" =20
<BR> END</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D1> =20
CLASS<BR> OUTLINECOLOR 0 0=20
0<BR> END</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1> END</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D1> =
LAYER<BR> NAME=20
"symboly"<BR> TYPE POINT<BR> =
STATUS=20
DEFAULT<BR> CONNECTIONTYPE=20
oraclespatial<BR> CONNECTION "</FONT><A=20
href=3D"mailto:umn/umn at kataster"><FONT face=3D"Courier New"=20
size=3D1>umn/umn at kataster</FONT></A><FONT face=3D"Courier New"=20
size=3D1>"<BR> DUMP TRUE<BR> DATA =
"NODE from=20
GRSYMBOLS"<BR></FONT><FONT face=3D"Courier New" size=3D1></FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1> =20
PROJECTION<BR> "init=3Depsg:4818" =20
<BR> END</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D1> =20
CLASS<BR> NAME=20
"Symboly"<BR> =20
STYLE<BR> COLOR 255 0=20
0<BR> SYMBOL=20
"circle"<BR> SIZE=20
10<BR> END<BR> =20
END</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1> END</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D1>END</FONT></DIV></BLOCKQUOTE>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Much appreciated,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jirka</DIV></FONT></BODY></HTML>
------=_NextPart_000_0097_01C4100E.9C412C80--
More information about the mapserver-users
mailing list