Oracle Spatial / ArcSDE connection

Fernando S. simon at INF.UNIVALI.BR
Mon Dec 13 05:38:58 PST 2004


Hi,
    Try to define your layer data attribute as:
        DATA "GEOMETRY FROM (SELECT ID, GEOMETRY FROM RABA_10042003_SDO)
USING UNIQUE ID FILTER"
    It's a definition for 4.4 version. Sorry, I need to update the docs.

    Just one question, why 2 geom columns?
    You can try define without projection.
    Thanks.

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


Sašo Celarc wrote:

>This is definition of my layer:
>
>LAYER # Meje poligonov za naselja
>  NAME         raba
>  TYPE POLYGON
>  CONNECTIONTYPE oraclespatial
>  CONNECTION "uname/pwd at lucka"
>  DATA "GEOMETRY FROM (SELECT GEOMETRY FROM RABA_10042003_SDO)"
>  DUMP TRUE
>  STATUS       OFF    #Če je off, sloj ni viden na začetku
>
>  PROJECTION
>    "init=epsg:32603"
>  END
>  CLASS
>    NAME   'Raba'
>    OUTLINECOLOR 0 0 0
>    COLOR 0 128 128
>  END
>END #Raba KZ
>
>Table is:
>
>SQL> desc RABA_10042003_SDO
> Name                                      Null?    Type
> ----------------------------------------- -------- ----------------------------
> ID                                        NOT NULL NUMBER(38)
> GEOMETRY                                           MDSYS.SDO_GEOMETRY
> POLY                                               NUMBER(11)
> RABA                                               NUMBER(11)
> AREA                                               NUMBER(16)
> PERIMETER                                          NUMBER(16)
> HECTARES                                           NUMBER(16)
> VALID                                              VARCHAR2(100)
> ROUND_GEOMETRY                                     MDSYS.SDO_GEOMETRY
>
>Regards,
>Sašo Celarc
>
>
>



More information about the MapServer-users mailing list