Oracle Spatial

[FERNANDO SIMON]

Hi Eric,
   I believe that I can help you, your problem can be with the type of your data
(SDO_GTYPE). THe Oracle Spatial driver for mapserver can't draw data if you
stored using 3D definition. You can check this when you execute one simple query
in sqlplus, if SDO_GTYPE return something like 300x try to redefine this value
to 200x.
   Only one question, how you import the data in Oracle, are you use the sqlldr?
If yes, after you import the data do you execute the function "EXECUTE
SDO_MIGRATE.TO_CURRENT('TABLE','GEOMETRY_COLUMN');" ? Are you create the spatial
index?
   When you execute your mapserver using only the cgi definition using only the
layer with oracle spatial connection what's happen? Ex:
http://localhost/cgi-bin/mapserv?map=yourmap.map&mode=map&imgsize=400+400&layers=oraclelayer
   You can see one example in this site:
http://g10novo.cttmar.univali.br/gtz/principal.php Everthing, polygons, lines
and points in this example are stored in Oracle Spatial.
   With the label I didn't see anything about this problem when you use Oracle
Spatial, are you define labelmaxscale in your layer? I saw something like as
when I used projection definition, the points disappear with wrong projection.
   I don't know if I helped you.
   If you need some help, you can report me.


-----------------------------------------------------------------------------------------------------
Fernando Simon - simon at inf.univali.br
Database Manager, Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada
http://g10.cttmar.univali.br
-----------------------------------------------------------------------------------------------------


Quoting Eric Wright <eric.linux at SHAW.CA>:

> Good morning,
>
> I am working on a project with MapServer and Oracle Spatial. Both are running
> under windows environments and I have noticed some odd behavior.
>
> Some of the data that I have loaded into Oracle Spatial layers does not get
> rendered by MapServer. I have run the Oracle test on the layers and they came
> back good and I am able to view the layers with the Oracle MapViewer but they
> are not showing up with MapServer. I am not getting an error back from
> MapServer and I have looked for the MapServer log but I cannot find them.
>
> Question: Where are the MapServer logs in a Windows/Apache install?
>
> Another thing that I find interesting is that some of the layers stop
> rendering at a certain scale. For example I have a layer that contains the
> cities of British Columbia (from one of the Oracle layers that is working).
> It has a Maximum scale of 1:5,000,000 yet at some point while zooming in the
> labels disappear and don't come back again until I zoom out. Is this
> normal?
>
>
> Thanks for your help
>
> Eric Wright
>




------------------------------------------------
Este e-mail foi enviado pelo webmail do curso de
       Ciência da Computação - UNIVALI