Raster/Oracle Spatial Layer Problems.

[Fernando Simon]

Hi,
    The problem can be with filter option. Sometimes I had problems with 
filter and query functions, can you define your filter option inside of 
DATA parameter?
    Another hint, can try to define the UNIQUE paramater for your DATA? 
Like: (I already defined the "filter" inside the data)
        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' and c.bottom_ele is not null) using UNIQUE 
<unique_id> SRID 8265"
    The <unique_id> is the column (number) that store the unique 
identifier for your table (usually the primary key).
    Can you test these hints?
    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:

>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
>>
>>    
>>
>
>  
>