Oracle Spatial Filter problem

[Zhonghai Wang]

Hi Simon,

problem is solved,

the Filter must be formatted somehow like:

DATA "GEOLOC FROM E112_CELLS_GEO USING SRID 8307 FILTER"
FILTER "cell='BAMK5D'"

the SRID seems to be a must for the filter.

thanks again for your help.

zhonghai


On 6/26/06, Zhonghai Wang <zhonghaiw at gmail.com> wrote:
>
>  Hi Simon,
>
> how is everything? thanks for your hints.
>
> as you said, I set the Filter again like this:
>
> DATA "GEOLOC FROM E112_CELLS_GEO USING FILTER"
>  FILTER "cell='BAMK5D'"
>
> with the cell='BAMK5D' condition in the SQLPlus 12 elements will be
> selected, but with mapserverit returns still some error messages:
>
> msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-29902:
> error in executing ODCIIndexStart() routine
> ORA-13208: internal error  while evaluating [window SRID does not match
> layer SRID] operator
> ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 259
> ORA-06512: at line 1
>  . Query statement: SELECT rownum, GEOLOC FROM E112_CELLS_GEO WHERE
> cell='BAMK5D' AND SDO_FILTER( GEOLOC, MDSYS.SDO_GEOMETRY(2003, NULL, NULL,
> MDSYS.SDO_ELEM_INF
>
> O_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(5.95587,45.11214,10.49203,
> 48.51426) )
> ,'querytype=window') = 'TRUE' .
>  Check your data statement.
>
> It seems that I should specify certain SRID code, but in this case the
> SRID code is not necessary.
>
> BTW: the SRID is 8307
>
> thanks
>
> zhonghai
>
>
> On 6/26/06, Fernando Simon <fsimon at univali.br> wrote:
> >
> > Hi,
> >    Just remove the "WHERE" from FILTER parameter. Like: FILTER
> > "MI_PRINX =100"
> >    Best regards.
> >
> > Fernando Simon
> >
> > Zhonghai Wang wrote:
> > > Hi there,
> > >
> > > I am trying to render the map with oracle spatial database, and facing
> > > problems with the FILTER expression.
> > >
> > > at first I define the oracle spatial connection like:
> > >
> > > CONNECTIONTYPE ORACLESPATIAL
> > > CONNECTION "E110/E110 at PMCGIS2.WORLD <mailto: E110/E110 at PMCGIS2.WORLD>"
> > > DATA "GEOLOC FROM E112_CELLS_GEO USING UNIQUE MI_PRINX SRID 8307"
> > >
> > > and this one works fine, therefore I am sure that the mapfile
> > > definition is ok, and then I change the data connection to :
> > >
> > > CONNECTIONTYPE ORACLESPATIAL
> > > CONNECTION "E110/E110 at PMCGIS2.WORLD <mailto:E110/E110 at PMCGIS2.WORLD>"
> > > DATA "GEOLOC FROM E112_CELLS_GEO USING FILTER"
> > > FILTER "WHERE  MI_PRINX =100"
> > >
> > > to use the FILTER function for a specific selection, but this
> > > definition gives aan error instead of the map image:
> > >
> > > ERROR:
> > > msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error:
> > > ORA-00936: missing expression .
> > > Query statement: SELECT rownum, GEOLOC FROM E112_CELLS_GEO WHERE WHERE
> > > MI_PRI
> > > NX=100 AND SDO_FILTER( GEOLOC, MDSYS.SDO_GEOMETRY(2003, NULL,
> > > NULL,MDSYS.SDO_ELE
> > > M_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(5.95587
> > > ,45.11214,10.49203,48.514
> > > 26) ),'querytype=window') = 'TRUE' .
> > > Check your data statement.
> > >
> > > I can not figure out where the problem is. the MI_PRINX is the unique
> > > id of the table, if I make this query in the SQLPlus, the data will be
> > > returned, which means the where condition in the SQL is no problem.
> > >
> > > any ideas for this?
> > >
> > > kind regards
> > >
> > > zhonghai
> > >
> > >
> > >
> > >
> > >
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060626/40dba573/attachment.html