Fwd: Re: [UMN_MAPSERVER-USERS] Blank Image OracleSpatial
Fernando Simon
fsimon at UNIVALI.BR
Thu Nov 23 10:53:26 EST 2006
Hi,
Did you have define any projection in your mapfile?
It is not a SRID problem bacause when occur SRID problem the Oracle
error related appear.
How did you call the Mapserver to generate this error? How it's your
map extent? Try to define the extent of your map with the extent (mbr)
of your layer, you can check it using this SQL:
select SDO_AGGR_MBR(shape) from RED_FERROCARRIL;
Best regards.
------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------
José Ramón López wrote:
>
> do you know how i could solve it?
>
> Thxs
> ---------- Forwarded message ----------
> From: *José Ramón López* < joseramonlopez at gmail.com
> <mailto:joseramonlopez at gmail.com>>
> Date: 23-nov-2006 13:53
> Subject: Re: Re: [UMN_MAPSERVER-USERS] Blank Image OracleSpatial
> To: "umn-ms at hydrotec.de <mailto:umn-ms at hydrotec.de>" <
> umn-ms at hydrotec.de <mailto:umn-ms at hydrotec.de>>
> Cc: mapserver-users at lists.umn.edu <mailto:mapserver-users at lists.umn.edu>
>
> I think that I don`t have any value assigned to srid
>
> SQL> select table_name,srid from user_sdo_geom_metadata where
> table_name='RED_FERROCARRIL';
>
> TABLE_NAME SRID
> -------------------------------- ----------
> RED_FERROCARRIL
>
>
>
> 2006/11/23, umn-ms at hydrotec.de <mailto:umn-ms at hydrotec.de>
> <umn-ms at hydrotec.de <mailto:umn-ms at hydrotec.de>>:
>
>
> What about the SRID? Is it set in Oracle-Metada?
> You may query it in SQL+ with
>
> select table_name,srid from user_sdo_geom_metadata where
> table_name='RED_FERROCARRIL'
> (or
> select "OWNER", table_name, srid from user_sdo_geom_metadata
> where table_name='RED_FERROCARRIL')
>
> UMN MapServer Users List <MAPSERVER-USERS at LISTS.UMN.EDU
> <mailto:MAPSERVER-USERS at LISTS.UMN.EDU>> schrieb am 23.11.2006
> 12:50:34:
>
>
> > if I execute that, it does not give back anything , and the
> following message;
> >
> > SQL> SELECT rownum, SHAPE FROM RED_FERROCARRIL WHERE SDO_FILTER(
> SHAPE, MDSYS.SDO_GEOMETRY(2003,
> > L,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),
> MDSYS.SDO_ORDINATE_ARRAY(-206.756757,-170,206.756757
> > ) ),'querytype=window') = 'TRUE;
> >
> > ninguna fila seleccionada
> > no selected row in english or something similar
> >
> > I supposed that it was for that reason, but either like
> correcting it;
> >
> > what can i do?
>
> > 2006/11/23, umn-ms at hydrotec.de <mailto:umn-ms at hydrotec.de> <
> umn-ms at hydrotec.de <mailto:umn-ms at hydrotec.de>>:
> >
> > Hi
> >
> > * Does the logged SQL-Statement produce any output if you
> > execute it in SQL+?
> > * Did you specify an SRID in Spatial-Metadata? Than you have to
> specify it
> > in the mapfile to.
> >
> > Benedikt
> >
> > UMN MapServer Users List <MAPSERVER-USERS at LISTS.UMN.EDU
> <mailto:MAPSERVER-USERS at LISTS.UMN.EDU>> schrieb am 23.11.2006
> 09:08:12:
> >
> >
> > > Hi People!
> > >
> > > I have installed MS4W for Windows, with maplab, chamaleon, php
> 4.4.2 ...
> > > I am with problems when I make a request on layer lodged in a
> oracle data base, because always shows a blank image.
> > > Im using Oracle 9i and Spatial. The dlls are in dlls their
> corresponding directories. If I make a request on a layer lodged
> in a data file, this is is correctly.
> > >
> > > Im using oraclespatial method , not by OCI.
> > >
> > > In error.log file it appears:
> > >
> > > [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerOpen called with: SHAPE FROM RED_FERROCARRIL
> USING VERSION 9i\r
> > > [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerOpen. Shared connection not available.
> Creating one.\r
> > > [error] [client 172.21.128.99 <http://172.21.128.99>]
> msConnPoolRegister(ferrocarriles,sde/sde at SDE,01912370)\r
> > > [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerFreeItemInfo was called.\r
> > > [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerWhichShapes was called.\r
> > > [[error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the
> data: SELECT rownum, SHAPE FROM RED_FERROCARRIL WHERE SDO_FILTER(
> SHAPE, MDSYS.SDO_GEOMETRY (2003, NULL,
> NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-206.756757,-170,206.756757,170)
> ),'querytype=window') = 'TRUE'\r
> > > [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerFreeItemInfo was called.\r
> > > [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerClose was called. Layer connection: sde/sde at SDE\r
> > > [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r
> > > [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerClose. Cleaning Oracle handlers.\r
> > > [error] [client 172.21.128.99 <http://172.21.128.99>]
> msConnPoolRelease(ferrocarriles, sde/sde at SDE,01912370)\r
> > > [error] [client 172.21.128.99 <http://172.21.128.99>]
> msConnPoolClose(sde/sde at SDE,01912370)\r
> > > [error] [client 172.21.128.99 <http://172.21.128.99>]
> msDrawMap(): Layer 2 (ferrocarriles), 0.218s\r
> > > [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerClose was called. Layer connection: sde/sde at SDE\r
> > >
> > > Thxs
> > > --
> > > José Ramón López
> >
> >
> >
> > --
> > José Ramón López
> > Tfno: 627 88 88 24
>
>
>
>
> --
> José Ramón López
> Tfno: 627 88 88 24
>
>
> --
> José Ramón López
> Tfno: 627 88 88 24
More information about the mapserver-users
mailing list