Raster/Oracle Spatial Layer Problems.

[Owens, Ryan J NWD02 CONTRACTOR]

Hi Fernando,

Thanks for responding.

We are running version 4.4.2.  And, we are using CGI.  My code is below, with
the metadata commented out.  Not sure what you mean by how I defined my
layers - I defined my raster as raster (duh), and I defined my Oracle Spatial
layer as a point layer.  Does this help to pin point a problem?

Ryan

MAP
 NAME  TNS_
 EXTENT  -535681 116823 1337533 1458918
 
 WEB
   log  "./test.log"
   TEMPLATE  "test_template.html"
   IMAGEPATH  "./tmp/"
   IMAGEURL  "http://[domain]////"
 END

 DEBUG ON

 OUTPUTFORMAT
   NAME  swf
   DRIVER  "SWF"
   MIMETYPE  "application/x-shockwave-flash"
   EXTENSION  "swf"
   IMAGEMODE  PC256
   FORMATOPTION  "OUTPUT_MOVIE=MULTIPLE"
 END

 IMAGETYPE swf

 SIZE  460 500
 SHAPEPATH  "data"
 SYMBOLSET symbols/symbol_mrric.sym
 IMAGECOLOR  255 255 255
 FONTSET fonts/fonts.list

 PROJECTION
#   "proj=laea"
#   "ellps=clrk66"
#   "lat_0=45"
#   "lon_0=-100"
  
 # Alternatively, you can specify an EPSG code.
 "init=epsg:80000"
 
 END

# Start of LAYER DEFINITIONS ---------------------------------------------
  
 LAYER
   NAME  "basin"
   DATA   basin_alb1000.JPG
   STATUS  DEFAULT
   TYPE  RASTER

  # PROJECTION
  # END
 END

 LAYER
   NAME  "river"
   DATA  missouri_river
   STATUS  DEFAULT
   TYPE  LINE

   METADATA
     "SWFDUMPATTRIBUTES" "NAME,LENGTH"
   END

   PROJECTION
     "init=epsg:80000"
   END

   CLASS
     COLOR  0 0 254
   END
 END

 LAYER
   NAME boatramps
   CONNECTIONTYPE oraclespatial
   CONNECTION [COMMENTED OUT] 
   DATA "ORA_GEOMETRY FROM (select c.ora_geometry, c.ramp_name, c.ramp_type,
c.bottom_ele, m.project from boatramps_011305_geo c, moriver_project_extents2
m where sdo_anyinteract(c.ora_geometry, m.ora_geometry)='TRUE') using SRID
8265" 
   FILTER 'BOTTOM_ELE IS NOT NULL'

   PROJECTION
    "proj=latlong"
    "ellps=GRS80"
    "init=epsg:4269"
   END

   TYPE point
   STATUS DEFAULT 

#   METADATA
#     "DESCRIPTION""RAMPS"
#     "RESULT_FIELDS" "RAMP_NAME" 
#     "SWFDUMPATTRIBUTES" "RAMP_NAME,RAMP_TYPE,BOTTOM_ELE,PROJECT"
#   END

   LABELMAXSCALE 1500000
   LABELITEM "RAMP_NAME"
   CLASSITEM "RAMP_TYPE"
   CLASS
     NAME "Boat Ramps - Shut Down"
     EXPRESSION ([BOTTOM_ELE]>=5000)
     SYMBOL 'rectangle'	
     COLOR 160 60 60
     SIZE 5
       OVERLAYSYMBOL 'rectangle'
       OVERLAYCOLOR 252 214 165    # 128 128 0
       OVERLAYSIZE 3
       
       LABEL
	 ANTIALIAS true
	 TYPE truetype
	 FONT "tahoma"
	 COLOR 180 80 0
	 SIZE 7
	 POSITION uc
       END
   END
	
   CLASS
     NAME "Boat Ramps - Operational"
     EXPRESSION ([BOTTOM_ELE]<5000)
     SYMBOL 'rectangle'
     COLOR 60 160 60
     SIZE 5
       OVERLAYSYMBOL 'rectangle'
       OVERLAYCOLOR 252 214 165    # 128 128 0
       OVERLAYSIZE 3
     
       LABEL
         ANTIALIAS true
         TYPE truetype
         FONT "tahoma"
         COLOR 80 180 0
         SIZE 7
         POSITION uc
       END
   END
 END

End of LAYER DEFINITIONS ---------------------------------------------

END # end of map file/object




-----Original Message-----
From: Fernando Simon [mailto:fsimon at univali.br] 
Sent: Friday, June 10, 2005 1:01 PM
To: Owens, Ryan J NWD02 CONTRACTOR
Cc: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] Raster/Oracle Spatial Layer Problems.

Hi,
What version are you using? Some problems can occur in 4.4.0 version, I 
recommend to use the last version (4.6 or 4.4.2).
How did you defined your layers (Raster and Oracle)? Are you using CGI 
or MapScript?
Thanks.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://g10.cttmar.univali.br - UNIVALI/CTTMAR
------------------------------------------------------------------------


Owens, Ryan J NWD02 CONTRACTOR wrote:

> Hello List,
>
> I'm having difficulty implementing a specific combination of a raster 
> and Oracle Spatial data layer.
>
> I have two layers: one raster layer and one oracle spatial point 
> layer. Both layers function properly, except for some projection 
> issues that I will fix later. When I go to add METADATA attributes to 
> the oracle spatial layer, I get an "internal server error". When I 
> comment out the raster layer, the oracle spatial layer functions 
> properly with the metadata. When I comment out the oracle spatial 
> layer along with the metadata, the raster layer functions properly. 
> But they do not work together. Does anyone have any idea what is 
> happening?
>
> Ryan
>