Oracle Spatial

[Bart van den Eijnden]

Hi Eric,

ogr2ogr can drop the third dimension, see:

http://xserve.flids.com/pipermail/gdal-dev/2004-March/005017.html

Best regards,
Bart

> 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 E
> ric 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
>>
>