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