Blank Image OracleSpatial
José Ramón López
joseramonlopez at GMAIL.COM
Fri Nov 24 02:34:48 EST 2006
---------- Forwarded message ----------
From: José Ramón López <joseramonlopez at gmail.com>
Date: 23-nov-2006 17:26
Subject: Re: [UMN_MAPSERVER-USERS] Fwd: Re: [UMN_MAPSERVER-USERS] Blank
Image OracleSpatial
To: Fernando Simon <fsimon at univali.br>
This is the definition of the layer:
LAYER
NAME ferrocarriles
TYPE line
CONNECTIONTYPE oraclespatial
CONNECTION "sde/sde at SDE "
DATA "SHAPE FROM RED_FERROCARRIL USING VERSION 9i"
DUMP TRUE
DEBUG ON
TRANSPARENCY 0
PROJECTION
"init=epsg:4326"
END
CLASS
NAME 'Red Ferrocarriles'
COLOR 0 0 255
END
METADATA
"wms_title" "Red Ferrocarriles"
"wms_abstract" "Red Ferrocarriles"
"wms_keywordlist" "WMS Red Ferrocarriles"
"wms_srs" "EPSG:4326"
END
And this is the call to Mapserver
http://localhost:81/cgi-bin/mapserver?SERVICE=WMS&VERSION=1.1.0&REQUEST=GetMap&Layers=ferrocarriles
If i execute this in SQL+
SQL> select SDO_AGGR_MBR(shape) from RED_FERROCARRIL;
SDO_AGGR_MBR(SHAPE)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO,
SDO_
--------------------------------------------------------------------------------
SDO_GEOMETRY(2003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3),
SDO_ORDINATE_ARR
AY(195210,089, 4075810,31, 533545,364, 4261747,98))
Thanks for all
2006/11/23, Fernando Simon <fsimon at univali.br>:
>
> 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
>
--
José Ramón López
Tfno: 627 88 88 24
--
José Ramón López
Tfno: 627 88 88 24
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20061124/4bfe4e21/attachment.html
More information about the mapserver-users
mailing list