Oracle Woes

[Christopher Condit]

Hi Fernando
Thanks very much for your response.  I added the USING RELATE operator
and dropped the projection definition from the layer, but still no
success.  Any thoughts?  The database already contained lat/lon in float
columns.  I create the spatial column with the following SQL:
alter table SPECIES add (shape mdsys.sdo_geometry);
update SPECIES 
  set shape =
MDSYS.SDO_GEOMETRY(2001,NULL,MDSYS.SDO_POINT_TYPE(latitude, longitude,
NULL),NULL,NULL)
  where latitude is not null and longitude is not null;
INSERT INTO USER_SDO_GEOM_METADATA 
  VALUES (
  'SPECIES',
  'SHAPE',
  MDSYS.SDO_DIM_ARRAY(   -- 1440x720 grid
    MDSYS.SDO_DIM_ELEMENT('X', 0, 1440, 0.005),
    MDSYS.SDO_DIM_ELEMENT('Y', 0, 720, 0.005)
     ),
  NULL   -- SRID
);
alter session set sort_area_size = 20000000;
create index shape_idx on SPECIES(shape) indextype is
mdsys.spatial_index;


Thanks,

Chris

-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of Fernando Simon
Sent: Thursday, December 22, 2005 12:54 PM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] Oracle Woes

Hi Christopher,
    How you added the data in your database? Using shp2sdo, if yes,
after the import did you execute the MIGRATE function?
    If are you trying to do query functions or modes like nquery,
query, querybyattribute... You need to specify the RELATE operator in
your data definition, in your case:
    DATA "SHAPE FROM (SELECT SHAPE, SCIENTIFICNAME FROM SPECIES WHERE
SCIENTIFICNAME ='Some name') USING RELATE"
    Are you already tried to execute the same operations without
projection definition?
    Best regards

------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
------------------------------------------


Citando Christopher Condit <condit at SDSC.EDU>:

> Hi All-
> 
> I'm having tremendous problems getting Oracle 10g Spatial support
> to
> work with MapServer 4.8 (or 4.6 for that matter).
> 
> I've tried both the native driver and the OGR driver and shp2img
> just
> seems to hang - no error message.
> 
> This table has about 2 million records, with SDO point geometry and
> a
> spatial index.  The query returns about 100 records.
> 
> Am I doing something obviously wrong?
> 
> Ogrinfo does work, however, but I can't find any documentation on
> how to
> add the select statement to an OGR layer in the mapfile.  Does
> anyone
> have any idea how to accomplish this?
> 
>  
> 
> Any help would be greatly appreciated!
> 
>  
> 
> Here's my layer definition:
> 
> LAYER #Test of Oracle points
> 
>   NAME oracletest
> 
>   METADATA
> 
>     "wfs_title"    "SimpleOracleTest" ## REQUIRED
> 
>     "wfs_geometry_element_name" "shape"
> 
>     "gml_include_items" "all" 
> 
>   END
> 
>   TYPE POINT
> 
>   STATUS DEFAULT
> 
>   CONNECTIONTYPE oraclespatial
> 
>   CONNECTION "user/password"
> 
> #  CONNECTIONTYPE ogr
> 
> #  CONNECTION "OCI:user/password"
> 
>   DATA "SHAPE FROM (SELECT SHAPE, SCIENTIFICNAME FROM SPECIES
> WHERE
> SCIENTIFICNAME ='Some name')"
> 
>   CLASS
> 
>     COLOR        232 0 0
> 
>     OUTLINECOLOR 0 255 0
> 
>   END
> 
>   DUMP TRUE
> 
>   PROJECTION
> 
>     "init=epsg:4326"
> 
>   END
> 
> END #end of layer
> 
>  
> 
> Thanks,
> 
>  
> 
> Chris
> 
> 




-------------------------------------------------
  Univali - Webmail - http://webmail.univali.br