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

[Jiri Potocny]

Nicolas,

thank you for your help. I'll try to define a new spatial reference.

Regards,
Jirka


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



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