Oracle Spatial

[Eric Wright]

Thanks for the info Fernando.

You hit the nail on the head with that one, the layers that are not showing up in my map are the 300x ones. 

I used the Oracle shp2sdo tool to create the SQL and CTL files before running the sqlldr tool to load the layers. I then ran EXECUTE
SDO_MIGRATE.TO_CURRENT('TABLE','GEOMETRY_COLUMN'); on all the layers and then created indexes for each layer. 

I am unable to manualy update the layer as Oracle complains that the "Layer Dimensionality does not match geometry dimensions" it makes sense that it won't let me do this. 

I will have re-load the data from the shape files and drop the third dimension.
Do you or (anyone else) know if using the OGR tool ogr2ogr will load the layer in a format that is sutable for MapServer? (i.e. drop the z coordinate) If not I will have to write my own Oracle loader.

Thanks again. 

Eric W

----- Original Message -----
From: FERNANDO SIMON <simon at INF.UNIVALI.BR>
Date: Tuesday, September 7, 2004 5:00 pm
Subject: Re: [UMN_MAPSERVER-USERS] Oracle Spatial

> Hi Eric,
>   I belive 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 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 help 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
>