[Mapserver-users] Unable to display data stored in Oracle Spatial

[Fortin,Nicolas [SteFoy]]

Hi Jiri,

Always forward to the list to have better chance of answer...

For what I'va seen for now with my data, Oracle layers need a SRID set in the SDO table and in the DATA element (USING SRID XXXXX).  I can't help you more for this cause I'm not the one who deal with Oracle spatial here but we also have a Coord Syst that was not in the mdsys.cs_srs (custom LCC) and our spatial guy add manually the SRID to the table (see my example in previous mail with SRID=3000000 and the custom LCC definition).

You can also try to set a PROJECTION for the map too.

Regards,
Nicolas



-----Message d'origine-----
De : Jiri Potocny [mailto:potocny at espace.cz] 
Envoyé : Thursday, March 18, 2004 7:28 AM
À : Fortin,Nicolas [SteFoy]
Objet : Re: [Mapserver-users] Unable to display data stored in Oracle Spatial


Nicolas

thank you for your advice.

I was unable to find appropriate coordinate system in mdsys.cs_srs, so all features in MDSYS.SDO_GEOM_METADATA_TABLE have SR_ID set to Null.

I tryed to define PROJECTION by parameters or through "init=epsg:4818", but the result is still the same. See the mapfile, please:

MAP
  IMAGETYPE      PNG
  EXTENT -551051 -1288960 -548185 -1286773
  SIZE           800 600
  SHAPEPATH      "data"
  IMAGECOLOR     255 255 255

  LAYER
    NAME           "parcely"
    DUMP           TRUE
    STATUS         DEFAULT
    TYPE           POLYGON

    CONNECTIONTYPE oraclespatial
    CONNECTION     uid/pwd at srvcname
    DATA           "BOUNDARY FROM GR_PARCELY"

    PROJECTION
     "proj=krovak"
     "lat_0=49.5"
     "lon_0=24.83333333333333"
     "alpha=30.28813972222222"
     "k=0.9999"
     "x_0=0"
     "y_0=0"
     "ellps=bessel"
     "pm=ferro"
     "units=m"
      #"init=epsg:4818"
    END

    CLASS
      NAME "parcely"
      COLOR        232 232 232
      OUTLINECOLOR 32 32 32
    END
  END

END

Regards,
Jirka

----- Original Message -----
From: "Fortin,Nicolas [SteFoy]" <nicolas.fortin at ec.gc.ca>
To: "Jiri Potocny" <potocny at espace.cz>; <mapserver-users at lists.gis.umn.edu>
Sent: Wednesday, March 17, 2004 5:44 PM
Subject: RE : [Mapserver-users] Unable to display data stored in Oracle Spatial


>
> Hi Jiri,
>
> You should use a PROJECTION element in your mapfile for this layer or 
> you
should add USING SRID XXXXX at the end of your DATA request.
>
> Example:
>
> LAYER
>   NAME "3"
>   TYPE POLYGON
>   CONNECTIONTYPE oraclespatial
>   CONNECTION "uid/pwd at dbname"
>   DATA "GEOLOC FROM USR_WATERSHED.VWTRSD_LCC USING SRID 3000000"
>   STATUS OFF
>   DUMP TRUE
>
>   PROJECTION
>     "proj=lcc"
>     "ellps=GRS80"
>     "lat_0=63"
>     "lon_0=-91.8666"
>     "lat_1=49"
>     "lat_2=77"
>     "x_0=6200000"
>     "y_0=2958000"
>     "datum=NAD83"
>     "units=m"
>   END
>
>   CLASS
>     NAME "Watershed"
>     SYMBOL 'CIRCLE'
>     SIZE 2
>     COLOR 255 255 255
>     OUTLINECOLOR 0 204 0
>   END
> END # Watershed
>
> Nicolas
>
> -----Message d'origine-----
> De : Jiri Potocny [mailto:potocny at espace.cz]
> Envoyé : Wednesday, March 17, 2004 10:54 AM
> À : mapserver-users at lists.gis.umn.edu
> Objet : [Mapserver-users] Unable to display data stored in Oracle 
> Spatial
>
>
> Dear MapServer experts,
>
> could you please help me with following problem?
>
> I'm trying to display data strored in Oracle Spatial, but I allways 
> get a
blank map. The map file is as follows:
>
> MAP
>   IMAGETYPE      PNG
>   EXTENT -551051 -1288960 -548185 -1286773
>   SIZE           800 600
>   IMAGECOLOR     255 255 255
>
>   LAYER
>     NAME           parcels
>     DUMP           TRUE
>     STATUS         DEFAULT
>     TYPE           POLYGON
>
>     CONNECTIONTYPE oraclespatial
>     CONNECTION     username/password at netservisname
>     DATA           "BOUNDARY FROM PARCELS"
>
>     CLASS
>       COLOR        232 232 232
>       OUTLINECOLOR 32 32 32
>     END
>   END
>
> END
>
> If I export the data from oracle into the shapefile and use following 
> map
file, everything is O.K.
>
> MAP
>   IMAGETYPE      PNG
>   EXTENT -551051 -1288960 -548185 -1286773
>   SIZE           800 600
>   SHAPEPATH      "data"
>   IMAGECOLOR     255 255 255
>
>   LAYER
>     NAME           parcely
>     DUMP           TRUE
>     STATUS         DEFAULT
>     TYPE           POLYGON
>     DATA          PARCELS
>
>     CLASS
>       COLOR        232 232 232
>       OUTLINECOLOR 32 32 32
>     END
>   END
>
> END
>
> The only difference is in the data source, the data (attributes as 
> well as
> geometries) are the same. I'm running MapServer 4.0.1 with Oracle Spatial
support (downloaded from
> http://hypnos.cbs.umn.edu/projects/downloads/ms401_png_oracle.zip) and
Oracle Database Server version 9.2.0.1.0 on Windows 2000 Professional SP 3.
>
> Could anybody get throught this problem.
>
> Much appreciated,
> Jirka
>
> _______________________________________________
> Mapserver-users mailing list Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users