Blank Image OracleSpatial
Fernando Simon
fsimon at UNIVALI.BR
Fri Nov 24 02:10:30 PST 2006
Hi José,
Can you try to don't use projection for your Mapfile and layer? The
global projection of the Mapfile is the same of the you layer?
Try to define the map extent as 195210,089 4075810,31 533545,364
4261747,98 and apply this request:
http://localhost:81/cgi-bin/mapserver?map=<path to your
mapfile>&mode=map&layers=ferrocarriles
Best regards.
Fernando Simon
José Ramón López wrote:
>
>
> ---------- Forwarded message ----------
> From: *José Ramón López* <joseramonlopez at gmail.com
> <mailto: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 <mailto: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
> <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
> <mailto: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>
> > <mailto: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> <mailto:
> umn-ms at hydrotec.de <mailto:umn-ms at hydrotec.de>>" <
> > umn-ms at hydrotec.de <mailto:umn-ms at hydrotec.de>
> <mailto: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> <mailto:
> 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>
> <mailto:umn-ms at hydrotec.de <mailto:umn-ms at hydrotec.de>>
> > < umn-ms at hydrotec.de <mailto:umn-ms at hydrotec.de>
> <mailto: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>
> > <mailto: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>
> <mailto:umn-ms at hydrotec.de <mailto:umn-ms at hydrotec.de>> <
> > umn-ms at hydrotec.de <mailto:umn-ms at hydrotec.de>
> <mailto: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>
> > <mailto: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>
> <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> <
> http://172.21.128.99>]
> > msOracleSpatialLayerOpen. Shared connection not available.
> > Creating one.\r
> > > > [error] [client 172.21.128.99 <http://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> <
> http://172.21.128.99>]
> > msOracleSpatialLayerFreeItemInfo was called.\r
> > > > [error] [client 172.21.128.99 <http://172.21.128.99>
> <http://172.21.128.99>]
> > msOracleSpatialLayerWhichShapes was called.\r
> > > > [[error] [client 172.21.128.99 <http://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> <
> http://172.21.128.99>]
> > msOracleSpatialLayerFreeItemInfo was called.\r
> > > > [error] [client 172.21.128.99 <http://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>
> <http://172.21.128.99>]
> > msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r
> > > > [error] [client 172.21.128.99 <http://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>
> <http://172.21.128.99>]
> > msConnPoolRelease(ferrocarriles, sde/sde at SDE,01912370)\r
> > > > [error] [client 172.21.128.99 <http://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> <
> http://172.21.128.99>]
> > msDrawMap(): Layer 2 (ferrocarriles), 0.218s\r
> > > > [error] [client 172.21.128.99 <http://172.21.128.99>
> <http://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
More information about the MapServer-users
mailing list