[Mapserver-users] Unable to display data stored in Oracle Spatial
Fernando S.
simon at inf.univali.br
Wed Mar 17 12:12:12 EST 2004
This is a multi-part message in MIME format.
--------------050001010808050300080501
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 8bit
Hi Jiri,
I don't know if I can help you. But I will try.
I need to do some questions to help you:
How you imported the data to Oracle?
Using shp2sdo? If yes, after you imported the data, did you
execute this function:
SDO_MIGRATE.TO_CURRENT(' TABLE ',' GEOMETRY_COLUMN ');
If you create a table with geometry columns, and populate it,
and try show it in the mapserv? It appeared in the image?
I don't know if I help you, sorry my poor english.
If you need some help, you can report me.
==================================================================
Fernando Simon - simon at cttmar.univali.br <mailto:simon at cttmar.univali.br>
==================================================================
DataBase Manager, Mapserver, OracleSpatial and PostGis Developer
G10 - Laboratório de Computaça~o Aplicada
Fone: 047 - 341 7960
http://g10.cttmar.univali.br
==================================================================
Jiri Potocny wrote:
>Dear MapServer experts,
>
>could you please help me with following problem?
>
>I'm trying to display data strored in Oracle Spatial, but I allways get a
>blank map.
>The map file is as follows:
>
>MAP
> IMAGETYPE PNG
> EXTENT -551051 -1288960 -548185 -1286773
> SIZE 800 600
> IMAGECOLOR 255 255 255
>
> LAYER
> NAME parcels
> DUMP TRUE
> STATUS DEFAULT
> TYPE POLYGON
>
> CONNECTIONTYPE oraclespatial
> CONNECTION username/password at netservisname
> DATA "BOUNDARY FROM PARCELS"
>
> CLASS
> COLOR 232 232 232
> OUTLINECOLOR 32 32 32
> END
> END
>
>END
>
>If I export the data from oracle into the shapefile and use following map
>file, everything is O.K.
>
>MAP
> IMAGETYPE PNG
> EXTENT -551051 -1288960 -548185 -1286773
> SIZE 800 600
> SHAPEPATH "data"
> IMAGECOLOR 255 255 255
>
> LAYER
> NAME parcely
> DUMP TRUE
> STATUS DEFAULT
> TYPE POLYGON
> DATA PARCELS
>
> CLASS
> COLOR 232 232 232
> OUTLINECOLOR 32 32 32
> END
> END
>
>END
>
>The only difference is in the data source, the data (attributes as well as
>geometries) are the same. I'm running MapServer 4.0.1 with Oracle Spatial
>support (downloaded from
>http://hypnos.cbs.umn.edu/projects/downloads/ms401_png_oracle.zip) and
>Oracle Database Server version 9.2.0.1.0 on Windows 2000 Professional SP 3.
>
>Could anybody get throught this problem.
>
>Much appreciated,
>Jirka
>
>_______________________________________________
>Mapserver-users mailing list
>Mapserver-users at lists.gis.umn.edu
>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
>
>
--------------050001010808050300080501
Content-Type: text/html; charset=ISO-8859-2
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-2" http-equiv="Content-Type">
<title></title>
</head>
<body>
Hi Jiri,<br>
I don't know if I can help you. But I will try.<br>
I need to do some questions to help you:<br>
How you imported the data to Oracle?<br>
Using shp2sdo? If yes, after you imported the data, did you
execute this function:<br>
SDO_MIGRATE.TO_CURRENT(' TABLE ',' GEOMETRY_COLUMN ');<br>
If you create a table with geometry columns, and populate it,
and try show it in the mapserv? It appeared in the image?<br>
<br>
I don't know if I help you, sorry my poor english.<br>
If you need some help, you can report me.<br>
<br>
<font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">==================================================================
<br>
Fernando Simon - <a href="mailto:simon at cttmar.univali.br">simon at cttmar.univali.br</a>
<br>
================================================================== <br>
DataBase Manager, Mapserver, OracleSpatial and PostGis Developer <br>
G10 - Laboratório de Computação Aplicada <br>
Fone: 047 - 341 7960 <br>
<a href="http://g10.cttmar.univali.br">http://g10.cttmar.univali.br</a>
<br>
==================================================================</span></font><br>
<br>
Jiri Potocny wrote:
<blockquote cite="mid007a01c40c38$100ff680$bc03a8c0 at twoflower"
type="cite">
<pre wrap="">Dear MapServer experts,
could you please help me with following problem?
I'm trying to display data strored in Oracle Spatial, but I allways get a
blank map.
The map file is as follows:
MAP
IMAGETYPE PNG
EXTENT -551051 -1288960 -548185 -1286773
SIZE 800 600
IMAGECOLOR 255 255 255
LAYER
NAME parcels
DUMP TRUE
STATUS DEFAULT
TYPE POLYGON
CONNECTIONTYPE oraclespatial
CONNECTION username/password at netservisname
DATA "BOUNDARY FROM PARCELS"
CLASS
COLOR 232 232 232
OUTLINECOLOR 32 32 32
END
END
END
If I export the data from oracle into the shapefile and use following map
file, everything is O.K.
MAP
IMAGETYPE PNG
EXTENT -551051 -1288960 -548185 -1286773
SIZE 800 600
SHAPEPATH "data"
IMAGECOLOR 255 255 255
LAYER
NAME parcely
DUMP TRUE
STATUS DEFAULT
TYPE POLYGON
DATA PARCELS
CLASS
COLOR 232 232 232
OUTLINECOLOR 32 32 32
END
END
END
The only difference is in the data source, the data (attributes as well as
geometries) are the same. I'm running MapServer 4.0.1 with Oracle Spatial
support (downloaded from
<a class="moz-txt-link-freetext" href="http://hypnos.cbs.umn.edu/projects/downloads/ms401_png_oracle.zip">http://hypnos.cbs.umn.edu/projects/downloads/ms401_png_oracle.zip</a>) and
Oracle Database Server version 9.2.0.1.0 on Windows 2000 Professional SP 3.
Could anybody get throught this problem.
Much appreciated,
Jirka
_______________________________________________
Mapserver-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Mapserver-users at lists.gis.umn.edu">Mapserver-users at lists.gis.umn.edu</a>
<a class="moz-txt-link-freetext" href="http://lists.gis.umn.edu/mailman/listinfo/mapserver-users">http://lists.gis.umn.edu/mailman/listinfo/mapserver-users</a>
</pre>
</blockquote>
<br>
</body>
</html>
--------------050001010808050300080501--
More information about the mapserver-users
mailing list