[Geoserver-users] Problem of projection for data stored in Oracle Locator

Good afternoon

I am currently working on reprojecting geographical data which are set in
GeoServer with SRS:4326 into different projections such as antarctic
stereographic plor projection
(SRS:3031:http://nsidc.org/data/atlas/epsg_3031.html)

This is the URL built by my client:
http://localhost:8080/geoserver/wms?service=WMS&version=1.1.1&request=GetMap&srs=EPSG:3031&format=image/gif&width=1000&height=1000&bbox=-12400000,-12400000,12400000,12400000&layers=fifao:ln1

When the layer listed in the URL correponds to a shapefile datastore in
Geoserver, the pojection is correct.

But when i load the same shapefile into an Oracle table in my database and
make the URL pointing to the featuretype in Geoserver corresponding to this
table in Oracle, i obtain a white map.

In that case, the features can not be reprojected. Even by specifying the
SRS 3031 in Geoserver for that featuretype, it can not be projected
according to that SRS.

Could it be a Geoserver bug?Or is it on Oracle side?

I use GS 1.6.3 and Oracle Locator 10.2.

Thanks for your help.

Sylvain
--
View this message in context: http://www.nabble.com/Problem-of-projection-for-data-stored-in-Oracle-Locator-tp17536770p17536770.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

I wrote a bug report that might apply to the problem:
http://jira.codehaus.org/browse/GEOS-1961

springrider wrote:

Good afternoon

I am currently working on reprojecting geographical data which are set in
GeoServer with SRS:4326 into different projections such as antarctic
stereographic plor projection
(SRS:3031:http://nsidc.org/data/atlas/epsg_3031.html)

This is the URL built by my client:
http://localhost:8080/geoserver/wms?service=WMS&version=1.1.1&request=GetMap&srs=EPSG:3031&format=image/gif&width=1000&height=1000&bbox=-12400000,-12400000,12400000,12400000&layers=fifao:ln1

When the layer listed in the URL correponds to a shapefile datastore in
Geoserver, the pojection is correct.

But when i load the same shapefile into an Oracle table in my database and
make the URL pointing to the featuretype in Geoserver corresponding to
this table in Oracle, i obtain a white map.

In that case, the features can not be reprojected. Even by specifying the
SRS 3031 in Geoserver for that featuretype, it can not be projected
according to that SRS.

Could it be a Geoserver bug?Or is it on Oracle side?

I use GS 1.6.3 and Oracle Locator 10.2.

Thanks for your help.

Sylvain

--
View this message in context: http://www.nabble.com/Problem-of-projection-for-data-stored-in-Oracle-Locator-tp17536770p17555348.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Thanks Reinhard

I made some additional tests and effectively i obtain this white map only
when the data is stored within a database. It is ok in the case of a
shapefile.

This is my log in case. Sorry for the length:

30 May 17:07:58 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=-8000000,-8000000,-1600000,-1600000&WIDTH=256&HEIGHT=256"
"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.14) Gecko/20080404
Firefox/2.0.0.14"
"http://figis02:8282/figis/Web_maps/test/openlayers_projection_web.html"
30 May 17:07:58 DEBUG [geoserver.global] - getting type fifao:CONTINENTS_LN1
30 May 17:07:58 DEBUG [geoserver.ows] - Getting layers and styles from
LAYERS and STYLES
30 May 17:07:58 DEBUG [geotools.styling] - number of fts set 1
30 May 17:07:58 DEBUG [geoserver.ows] - establishing Continent_style style
for fifao:CONTINENTS_LN1
30 May 17:07:58 DEBUG [wms.responses] - setting up map
30 May 17:07:58 DEBUG [wms.map] - setting up 256x256 image
30 May 17:07:58 DEBUG [renderer.shape] - Affine Transform is
AffineTransform[[4.0E-5, 0.0, 320.0], [0.0, -4.0E-5, -64.0]]
30 May 17:07:58 DEBUG [geotools.styling] - number of fts set 1
30 May 17:07:58 DEBUG [geotools.rendering] - processing 1 stylers for
CONTINENTS_LN1
30 May 17:07:58 DEBUG [geotools.rendering] - creating rules for scale
denominator - 89,285,714.286
30 May 17:07:58 DEBUG [geotools.rendering] - Expanding rendering area by 1
pixels to consider stroke width
30 May 17:07:58 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=-1600000,-8000000,4800000,-1600000&WIDTH=256&HEIGHT=256"
"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.14) Gecko/20080404
Firefox/2.0.0.14"
"http://figis02:8282/figis/Web_maps/test/openlayers_projection_web.html"
30 May 17:07:58 DEBUG [geoserver.global] - getting type fifao:CONTINENTS_LN1
30 May 17:07:58 DEBUG [geoserver.ows] - Getting layers and styles from
LAYERS and STYLES
30 May 17:07:58 DEBUG [geotools.styling] - number of fts set 1
30 May 17:07:58 DEBUG [geoserver.ows] - establishing Continent_style style
for fifao:CONTINENTS_LN1
30 May 17:07:58 DEBUG [wms.responses] - setting up map
30 May 17:07:58 DEBUG [wms.map] - setting up 256x256 image
30 May 17:07:58 DEBUG [renderer.shape] - Affine Transform is
AffineTransform[[4.0E-5, 0.0, 64.0], [0.0, -4.0E-5, -64.0]]
30 May 17:07:58 DEBUG [geotools.styling] - number of fts set 1
30 May 17:07:58 DEBUG [geotools.rendering] - processing 1 stylers for
CONTINENTS_LN1
30 May 17:07:58 DEBUG [geotools.rendering] - creating rules for scale
denominator - 89,285,714.286
30 May 17:07:58 DEBUG [geotools.rendering] - Expanding rendering area by 1
pixels to consider stroke width
30 May 17:07:58 DEBUG [geotools.rendering] - Querying layer CONTINENTS_LN1
with bbox: ReferencedEnvelope[-168.89616656336395 : -101.1038334366361,
-69.7061782334264 : -4.950263495371922]
30 May 17:07:58 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:07:58 DEBUG [geotools.rendering] - Querying layer CONTINENTS_LN1
with bbox: ReferencedEnvelope[-180.0 : 180.0, -75.52615093325792 :
-15.83925426512563]
30 May 17:07:58 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:07:58 DEBUG [data.jdbc] - calling sql builder with filter [
GEOMETRY bbox POLYGON ((-168.89616656336395 -69.7061782334264,
-168.89616656336395 -4.950263495371922, -101.1038334366361
-4.950263495371922, -101.1038334366361 -69.7061782334264,
-168.89616656336395 -69.7061782334264)) ]
30 May 17:07:58 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:07:58 TRACE [geotools.core] - ENTRY 4
30 May 17:07:58 DEBUG [filter.SQLEncoderOracle] - Visiting a Geometry filter
30 May 17:07:58 DEBUG [geotools.filter] - exporting ExpressionAttribute
30 May 17:07:58 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:07:58 DEBUG [data.jdbc] - calling sql builder with filter [
GEOMETRY bbox POLYGON ((-180 -75.52615093325792, -180 -15.83925426512563,
180 -15.83925426512563, 180 -75.52615093325792, -180 -75.52615093325792)) ]
30 May 17:07:58 TRACE [geotools.core] - ENTRY 4
30 May 17:07:58 DEBUG [filter.SQLEncoderOracle] - Visiting a Geometry filter
30 May 17:07:58 DEBUG [geotools.filter] - exporting ExpressionAttribute
30 May 17:07:58 DEBUG [filter.SQLEncoderOracle] - Using layer SRID: 999999
30 May 17:07:58 DEBUG [data.jdbc] - sql is SELECT "GEOMETRY" FROM
"CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-168.89616656336395,-69.7061782334264,-101.1038334366361,-4.950263495371922)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:58 DEBUG [data.jdbc] - SELECT "GEOMETRY" FROM "CONTINENTS_LN1"
WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-168.89616656336395,-69.7061782334264,-101.1038334366361,-4.950263495371922)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:58 DEBUG [data.jdbc] - About to execute query: SELECT
"GEOMETRY" FROM "CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-168.89616656336395,-69.7061782334264,-101.1038334366361,-4.950263495371922)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:58 DEBUG [filter.SQLEncoderOracle] - Using layer SRID: 999999
30 May 17:07:58 DEBUG [data.jdbc] - sql is SELECT "GEOMETRY" FROM
"CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-180.0,-75.52615093325792,180.0,-15.83925426512563)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:58 DEBUG [data.jdbc] - SELECT "GEOMETRY" FROM "CONTINENTS_LN1"
WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-180.0,-75.52615093325792,180.0,-15.83925426512563)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:58 DEBUG [data.jdbc] - About to execute query: SELECT
"GEOMETRY" FROM "CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-180.0,-75.52615093325792,180.0,-15.83925426512563)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:58 DEBUG [data.oracle] - About to create Geometry convertor for
CONTINENTS_LN1.GEOMETRY
30 May 17:07:58 DEBUG [data.oracle] - About to create Geometry convertor for
CONTINENTS_LN1.GEOMETRY
30 May 17:07:59 DEBUG [geotools.rendering] - Setting fill:
java.awt.Color[r=136,g=136,b=85]
30 May 17:07:59 DEBUG [geotools.rendering] - Setting fill:
java.awt.Color[r=136,g=136,b=85]
30 May 17:07:59 DEBUG [geotools.rendering] - Style cache hit ratio: 0.0 ,
hits 0, requests 1
30 May 17:07:59 DEBUG [renderer.shape] - Style cache hit ratio: NaN , hits
0, requests 0
30 May 17:07:59 DEBUG [wms.responses] - asking delegate for write to
org.geoserver.ows.DispatcherOutputStream@anonymised.com
30 May 17:07:59 DEBUG [geotools.image] - Encoding input image to write out
as JPEG.
30 May 17:07:59 DEBUG [geotools.image] - Getting a JPEG writer and
configuring it.
30 May 17:07:59 DEBUG [geotools.rendering] - Style cache hit ratio: 0.0 ,
hits 0, requests 1
30 May 17:07:59 DEBUG [renderer.shape] - Style cache hit ratio: NaN , hits
0, requests 0
30 May 17:07:59 DEBUG [geotools.image] - Writing out...
30 May 17:07:59 DEBUG [wms.responses] - asking delegate for write to
org.geoserver.ows.DispatcherOutputStream@anonymised.com
30 May 17:07:59 DEBUG [geotools.image] - Encoding input image to write out
as JPEG.
30 May 17:07:59 DEBUG [geotools.image] - Getting a JPEG writer and
configuring it.
30 May 17:07:59 DEBUG [geotools.image] - Writing out...
30 May 17:07:59 INFO [geoserver.filters] - Not compressing output for
mimetype: image/jpeg
30 May 17:07:59 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=-8000000,-8000000,-1600000,-1600000&WIDTH=256&HEIGHT=256"
took 351ms
30 May 17:07:59 INFO [geoserver.filters] - Not compressing output for
mimetype: image/jpeg
30 May 17:07:59 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=-1600000,-8000000,4800000,-1600000&WIDTH=256&HEIGHT=256"
took 344ms
30 May 17:07:59 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=4800000,-8000000,11200000,-1600000&WIDTH=256&HEIGHT=256"
"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.14) Gecko/20080404
Firefox/2.0.0.14"
"http://figis02:8282/figis/Web_maps/test/openlayers_projection_web.html"
30 May 17:07:59 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=4800000,-1600000,11200000,4800000&WIDTH=256&HEIGHT=256"
"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.14) Gecko/20080404
Firefox/2.0.0.14"
"http://figis02:8282/figis/Web_maps/test/openlayers_projection_web.html"
30 May 17:07:59 DEBUG [geoserver.global] - getting type fifao:CONTINENTS_LN1
30 May 17:07:59 DEBUG [geoserver.ows] - Getting layers and styles from
LAYERS and STYLES
30 May 17:07:59 DEBUG [geotools.styling] - number of fts set 1
30 May 17:07:59 DEBUG [geoserver.ows] - establishing Continent_style style
for fifao:CONTINENTS_LN1
30 May 17:07:59 DEBUG [geoserver.global] - getting type fifao:CONTINENTS_LN1
30 May 17:07:59 DEBUG [geoserver.ows] - Getting layers and styles from
LAYERS and STYLES
30 May 17:07:59 DEBUG [geotools.styling] - number of fts set 1
30 May 17:07:59 DEBUG [geoserver.ows] - establishing Continent_style style
for fifao:CONTINENTS_LN1
30 May 17:07:59 DEBUG [wms.responses] - setting up map
30 May 17:07:59 DEBUG [wms.map] - setting up 256x256 image
30 May 17:07:59 DEBUG [wms.responses] - setting up map
30 May 17:07:59 DEBUG [wms.map] - setting up 256x256 image
30 May 17:07:59 DEBUG [renderer.shape] - Affine Transform is
AffineTransform[[4.0E-5, 0.0, -192.0], [0.0, -4.0E-5, -64.0]]
30 May 17:07:59 DEBUG [geotools.styling] - number of fts set 1
30 May 17:07:59 DEBUG [geotools.rendering] - processing 1 stylers for
CONTINENTS_LN1
30 May 17:07:59 DEBUG [geotools.rendering] - creating rules for scale
denominator - 89,285,714.286
30 May 17:07:59 DEBUG [geotools.rendering] - Expanding rendering area by 1
pixels to consider stroke width
30 May 17:07:59 DEBUG [renderer.shape] - Affine Transform is
AffineTransform[[4.0E-5, 0.0, -192.0], [0.0, -4.0E-5, 192.0]]
30 May 17:07:59 DEBUG [geotools.styling] - number of fts set 1
30 May 17:07:59 DEBUG [geotools.rendering] - processing 1 stylers for
CONTINENTS_LN1
30 May 17:07:59 DEBUG [geotools.rendering] - creating rules for scale
denominator - 89,285,714.286
30 May 17:07:59 DEBUG [geotools.rendering] - Expanding rendering area by 1
pixels to consider stroke width
30 May 17:07:59 DEBUG [geotools.rendering] - Querying layer CONTINENTS_LN1
with bbox: ReferencedEnvelope[97.98713127344811 : 149.24669533879563,
-45.94318095497626 : 6.303429029339396]
30 May 17:07:59 DEBUG [geotools.rendering] - Querying layer CONTINENTS_LN1
with bbox: ReferencedEnvelope[44.70158718000511 : 108.79416530447249,
-47.9534391891417 : -0.7006802423827015]
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:07:59 DEBUG [data.jdbc] - calling sql builder with filter [
GEOMETRY bbox POLYGON ((97.98713127344811 -45.94318095497626,
97.98713127344811 6.303429029339396, 149.24669533879563 6.303429029339396,
149.24669533879563 -45.94318095497626, 97.98713127344811
-45.94318095497626)) ]
30 May 17:07:59 TRACE [geotools.core] - ENTRY 4
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - Visiting a Geometry filter
30 May 17:07:59 DEBUG [geotools.filter] - exporting ExpressionAttribute
30 May 17:07:59 DEBUG [data.jdbc] - calling sql builder with filter [
GEOMETRY bbox POLYGON ((44.70158718000511 -47.9534391891417,
44.70158718000511 -0.7006802423827015, 108.79416530447249
-0.7006802423827015, 108.79416530447249 -47.9534391891417, 44.70158718000511
-47.9534391891417)) ]
30 May 17:07:59 TRACE [geotools.core] - ENTRY 4
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - Visiting a Geometry filter
30 May 17:07:59 DEBUG [geotools.filter] - exporting ExpressionAttribute
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - Using layer SRID: 999999
30 May 17:07:59 DEBUG [data.jdbc] - sql is SELECT "GEOMETRY" FROM
"CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(97.98713127344811,-45.94318095497626,149.24669533879563,6.303429029339396)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:59 DEBUG [data.jdbc] - SELECT "GEOMETRY" FROM "CONTINENTS_LN1"
WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(97.98713127344811,-45.94318095497626,149.24669533879563,6.303429029339396)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:59 DEBUG [data.jdbc] - About to execute query: SELECT
"GEOMETRY" FROM "CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(97.98713127344811,-45.94318095497626,149.24669533879563,6.303429029339396)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - Using layer SRID: 999999
30 May 17:07:59 DEBUG [data.jdbc] - sql is SELECT "GEOMETRY" FROM
"CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(44.70158718000511,-47.9534391891417,108.79416530447249,-0.7006802423827015)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:59 DEBUG [data.jdbc] - SELECT "GEOMETRY" FROM "CONTINENTS_LN1"
WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(44.70158718000511,-47.9534391891417,108.79416530447249,-0.7006802423827015)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:59 DEBUG [data.jdbc] - About to execute query: SELECT
"GEOMETRY" FROM "CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(44.70158718000511,-47.9534391891417,108.79416530447249,-0.7006802423827015)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:59 DEBUG [data.oracle] - About to create Geometry convertor for
CONTINENTS_LN1.GEOMETRY
30 May 17:07:59 DEBUG [data.oracle] - About to create Geometry convertor for
CONTINENTS_LN1.GEOMETRY
30 May 17:07:59 DEBUG [geotools.rendering] - Setting fill:
java.awt.Color[r=136,g=136,b=85]
30 May 17:07:59 DEBUG [geotools.rendering] - Setting fill:
java.awt.Color[r=136,g=136,b=85]
30 May 17:07:59 DEBUG [geotools.rendering] - Style cache hit ratio: 0.0 ,
hits 0, requests 1
30 May 17:07:59 DEBUG [renderer.shape] - Style cache hit ratio: NaN , hits
0, requests 0
30 May 17:07:59 DEBUG [wms.responses] - asking delegate for write to
org.geoserver.ows.DispatcherOutputStream@anonymised.com
30 May 17:07:59 DEBUG [geotools.image] - Encoding input image to write out
as JPEG.
30 May 17:07:59 DEBUG [geotools.image] - Getting a JPEG writer and
configuring it.
30 May 17:07:59 DEBUG [geotools.rendering] - Style cache hit ratio: 0.0 ,
hits 0, requests 1
30 May 17:07:59 DEBUG [renderer.shape] - Style cache hit ratio: NaN , hits
0, requests 0
30 May 17:07:59 DEBUG [wms.responses] - asking delegate for write to
org.geoserver.ows.DispatcherOutputStream@anonymised.com
30 May 17:07:59 DEBUG [geotools.image] - Encoding input image to write out
as JPEG.
30 May 17:07:59 DEBUG [geotools.image] - Getting a JPEG writer and
configuring it.
30 May 17:07:59 DEBUG [geotools.image] - Writing out...
30 May 17:07:59 DEBUG [geotools.image] - Writing out...
30 May 17:07:59 INFO [geoserver.filters] - Not compressing output for
mimetype: image/jpeg
30 May 17:07:59 INFO [geoserver.filters] - Not compressing output for
mimetype: image/jpeg
30 May 17:07:59 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=4800000,-8000000,11200000,-1600000&WIDTH=256&HEIGHT=256"
took 841ms
30 May 17:07:59 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=4800000,-1600000,11200000,4800000&WIDTH=256&HEIGHT=256"
took 841ms
30 May 17:07:59 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=-8000000,-1600000,-1600000,4800000&WIDTH=256&HEIGHT=256"
"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.14) Gecko/20080404
Firefox/2.0.0.14"
"http://figis02:8282/figis/Web_maps/test/openlayers_projection_web.html"
30 May 17:07:59 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=-1600000,-1600000,4800000,4800000&WIDTH=256&HEIGHT=256"
"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.14) Gecko/20080404
Firefox/2.0.0.14"
"http://figis02:8282/figis/Web_maps/test/openlayers_projection_web.html"
30 May 17:07:59 DEBUG [geoserver.global] - getting type fifao:CONTINENTS_LN1
30 May 17:07:59 DEBUG [geoserver.global] - getting type fifao:CONTINENTS_LN1
30 May 17:07:59 DEBUG [geoserver.ows] - Getting layers and styles from
LAYERS and STYLES
30 May 17:07:59 DEBUG [geoserver.ows] - Getting layers and styles from
LAYERS and STYLES
30 May 17:07:59 DEBUG [geotools.styling] - number of fts set 1
30 May 17:07:59 DEBUG [geotools.styling] - number of fts set 1
30 May 17:07:59 DEBUG [geoserver.ows] - establishing Continent_style style
for fifao:CONTINENTS_LN1
30 May 17:07:59 DEBUG [geoserver.ows] - establishing Continent_style style
for fifao:CONTINENTS_LN1
30 May 17:07:59 DEBUG [wms.responses] - setting up map
30 May 17:07:59 DEBUG [wms.responses] - setting up map
30 May 17:07:59 DEBUG [wms.map] - setting up 256x256 image
30 May 17:07:59 DEBUG [wms.map] - setting up 256x256 image
30 May 17:07:59 DEBUG [renderer.shape] - Affine Transform is
AffineTransform[[4.0E-5, 0.0, 64.0], [0.0, -4.0E-5, 192.0]]
30 May 17:07:59 DEBUG [renderer.shape] - Affine Transform is
AffineTransform[[4.0E-5, 0.0, 320.0], [0.0, -4.0E-5, 192.0]]
30 May 17:07:59 DEBUG [geotools.styling] - number of fts set 1
30 May 17:07:59 DEBUG [geotools.styling] - number of fts set 1
30 May 17:07:59 DEBUG [geotools.rendering] - processing 1 stylers for
CONTINENTS_LN1
30 May 17:07:59 DEBUG [geotools.rendering] - processing 1 stylers for
CONTINENTS_LN1
30 May 17:07:59 DEBUG [geotools.rendering] - creating rules for scale
denominator - 89,285,714.286
30 May 17:07:59 DEBUG [geotools.rendering] - creating rules for scale
denominator - 89,285,714.286
30 May 17:07:59 DEBUG [geotools.rendering] - Expanding rendering area by 1
pixels to consider stroke width
30 May 17:07:59 DEBUG [geotools.rendering] - Expanding rendering area by 1
pixels to consider stroke width
30 May 17:07:59 DEBUG [geotools.rendering] - Querying layer CONTINENTS_LN1
with bbox: ReferencedEnvelope[-164.44696217868642 : 175.28278386417796,
-90.0 : -32.39929464804183]
30 May 17:07:59 DEBUG [geotools.rendering] - Querying layer CONTINENTS_LN1
with bbox: ReferencedEnvelope[-135.89517371021108 : -18.07797039218973,
-75.52615093325792 : -15.83925426512563]
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:07:59 DEBUG [data.jdbc] - calling sql builder with filter [
GEOMETRY bbox POLYGON ((-164.44696217868642 -90, -164.44696217868642
-32.39929464804183, 175.28278386417796 -32.39929464804183,
175.28278386417796 -90, -164.44696217868642 -90)) ]
30 May 17:07:59 TRACE [geotools.core] - ENTRY 4
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - Visiting a Geometry filter
30 May 17:07:59 DEBUG [data.jdbc] - calling sql builder with filter [
GEOMETRY bbox POLYGON ((-135.89517371021108 -75.52615093325792,
-135.89517371021108 -15.83925426512563, -18.07797039218973
-15.83925426512563, -18.07797039218973 -75.52615093325792,
-135.89517371021108 -75.52615093325792)) ]
30 May 17:07:59 DEBUG [geotools.filter] - exporting ExpressionAttribute
30 May 17:07:59 TRACE [geotools.core] - ENTRY 4
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - Visiting a Geometry filter
30 May 17:07:59 DEBUG [geotools.filter] - exporting ExpressionAttribute
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - Using layer SRID: 999999
30 May 17:07:59 DEBUG [filter.SQLEncoderOracle] - Using layer SRID: 999999
30 May 17:07:59 DEBUG [data.jdbc] - sql is SELECT "GEOMETRY" FROM
"CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-164.44696217868642,-90.0,175.28278386417796,-32.39929464804183)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:59 DEBUG [data.jdbc] - SELECT "GEOMETRY" FROM "CONTINENTS_LN1"
WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-164.44696217868642,-90.0,175.28278386417796,-32.39929464804183)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:59 DEBUG [data.jdbc] - sql is SELECT "GEOMETRY" FROM
"CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-135.89517371021108,-75.52615093325792,-18.07797039218973,-15.83925426512563)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:59 DEBUG [data.jdbc] - SELECT "GEOMETRY" FROM "CONTINENTS_LN1"
WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-135.89517371021108,-75.52615093325792,-18.07797039218973,-15.83925426512563)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:59 DEBUG [data.jdbc] - About to execute query: SELECT
"GEOMETRY" FROM "CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-164.44696217868642,-90.0,175.28278386417796,-32.39929464804183)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:07:59 DEBUG [data.jdbc] - About to execute query: SELECT
"GEOMETRY" FROM "CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-135.89517371021108,-75.52615093325792,-18.07797039218973,-15.83925426512563)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:08:00 DEBUG [data.oracle] - About to create Geometry convertor for
CONTINENTS_LN1.GEOMETRY
30 May 17:08:00 DEBUG [data.oracle] - About to create Geometry convertor for
CONTINENTS_LN1.GEOMETRY
30 May 17:08:00 DEBUG [geotools.rendering] - Setting fill:
java.awt.Color[r=136,g=136,b=85]
30 May 17:08:00 DEBUG [geotools.rendering] - Setting fill:
java.awt.Color[r=136,g=136,b=85]
30 May 17:08:00 DEBUG [geotools.rendering] - Style cache hit ratio: 0.0 ,
hits 0, requests 1
30 May 17:08:00 DEBUG [renderer.shape] - Style cache hit ratio: NaN , hits
0, requests 0
30 May 17:08:00 DEBUG [wms.responses] - asking delegate for write to
org.geoserver.ows.DispatcherOutputStream@anonymised.com
30 May 17:08:00 DEBUG [geotools.image] - Encoding input image to write out
as JPEG.
30 May 17:08:00 DEBUG [geotools.image] - Getting a JPEG writer and
configuring it.
30 May 17:08:00 DEBUG [geotools.image] - Writing out...
30 May 17:08:00 DEBUG [geotools.rendering] - Style cache hit ratio: 0.0 ,
hits 0, requests 1
30 May 17:08:00 DEBUG [renderer.shape] - Style cache hit ratio: NaN , hits
0, requests 0
30 May 17:08:00 DEBUG [wms.responses] - asking delegate for write to
org.geoserver.ows.DispatcherOutputStream@anonymised.com
30 May 17:08:00 DEBUG [geotools.image] - Encoding input image to write out
as JPEG.
30 May 17:08:00 DEBUG [geotools.image] - Getting a JPEG writer and
configuring it.
30 May 17:08:00 DEBUG [geotools.image] - Writing out...
30 May 17:08:00 INFO [geoserver.filters] - Not compressing output for
mimetype: image/jpeg
30 May 17:08:00 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=-8000000,-1600000,-1600000,4800000&WIDTH=256&HEIGHT=256"
took 311ms
30 May 17:08:00 INFO [geoserver.filters] - Not compressing output for
mimetype: image/jpeg
30 May 17:08:00 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=-1600000,-1600000,4800000,4800000&WIDTH=256&HEIGHT=256"
took 312ms
30 May 17:08:00 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=4800000,4800000,11200000,11200000&WIDTH=256&HEIGHT=256"
"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.14) Gecko/20080404
Firefox/2.0.0.14"
"http://figis02:8282/figis/Web_maps/test/openlayers_projection_web.html"
30 May 17:08:00 DEBUG [geoserver.global] - getting type fifao:CONTINENTS_LN1
30 May 17:08:00 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=-1600000,4800000,4800000,11200000&WIDTH=256&HEIGHT=256"
"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.14) Gecko/20080404
Firefox/2.0.0.14"
"http://figis02:8282/figis/Web_maps/test/openlayers_projection_web.html"
30 May 17:08:00 DEBUG [geoserver.ows] - Getting layers and styles from
LAYERS and STYLES
30 May 17:08:00 DEBUG [geotools.styling] - number of fts set 1
30 May 17:08:00 DEBUG [geoserver.ows] - establishing Continent_style style
for fifao:CONTINENTS_LN1
30 May 17:08:00 DEBUG [geoserver.global] - getting type fifao:CONTINENTS_LN1
30 May 17:08:00 DEBUG [geoserver.ows] - Getting layers and styles from
LAYERS and STYLES
30 May 17:08:00 DEBUG [geotools.styling] - number of fts set 1
30 May 17:08:00 DEBUG [geoserver.ows] - establishing Continent_style style
for fifao:CONTINENTS_LN1
30 May 17:08:00 DEBUG [wms.responses] - setting up map
30 May 17:08:00 DEBUG [wms.map] - setting up 256x256 image
30 May 17:08:00 DEBUG [renderer.shape] - Affine Transform is
AffineTransform[[4.0E-5, 0.0, -192.0], [0.0, -4.0E-5, 448.0]]
30 May 17:08:00 DEBUG [geotools.styling] - number of fts set 1
30 May 17:08:00 DEBUG [geotools.rendering] - processing 1 stylers for
CONTINENTS_LN1
30 May 17:08:00 DEBUG [wms.responses] - setting up map
30 May 17:08:00 DEBUG [geotools.rendering] - creating rules for scale
denominator - 89,285,714.286
30 May 17:08:00 DEBUG [wms.map] - setting up 256x256 image
30 May 17:08:00 DEBUG [geotools.rendering] - Expanding rendering area by 1
pixels to consider stroke width
30 May 17:08:00 DEBUG [renderer.shape] - Affine Transform is
AffineTransform[[4.0E-5, 0.0, 64.0], [0.0, -4.0E-5, 448.0]]
30 May 17:08:00 DEBUG [geotools.styling] - number of fts set 1
30 May 17:08:00 DEBUG [geotools.rendering] - processing 1 stylers for
CONTINENTS_LN1
30 May 17:08:00 DEBUG [geotools.rendering] - creating rules for scale
denominator - 89,285,714.286
30 May 17:08:00 DEBUG [geotools.rendering] - Expanding rendering area by 1
pixels to consider stroke width
30 May 17:08:00 DEBUG [geotools.rendering] - Querying layer CONTINENTS_LN1
with bbox: ReferencedEnvelope[23.04440418101947 : 66.95559581898054,
-32.90420814065323 : 14.249305822083562]
30 May 17:08:00 DEBUG [geotools.rendering] - Querying layer CONTINENTS_LN1
with bbox: ReferencedEnvelope[-18.794165304472486 : 45.29841281999489,
-47.9534391891417 : -0.7006802423827015]
30 May 17:08:00 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:08:00 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:08:00 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:08:00 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:08:00 DEBUG [data.jdbc] - calling sql builder with filter [
GEOMETRY bbox POLYGON ((23.04440418101947 -32.90420814065323,
23.04440418101947 14.249305822083562, 66.95559581898054 14.249305822083562,
66.95559581898054 -32.90420814065323, 23.04440418101947 -32.90420814065323))
]
30 May 17:08:00 TRACE [geotools.core] - ENTRY 4
30 May 17:08:00 DEBUG [data.jdbc] - calling sql builder with filter [
GEOMETRY bbox POLYGON ((-18.794165304472486 -47.9534391891417,
-18.794165304472486 -0.7006802423827015, 45.29841281999489
-0.7006802423827015, 45.29841281999489 -47.9534391891417,
-18.794165304472486 -47.9534391891417)) ]
30 May 17:08:00 DEBUG [filter.SQLEncoderOracle] - Visiting a Geometry filter
30 May 17:08:00 DEBUG [geotools.filter] - exporting ExpressionAttribute
30 May 17:08:00 TRACE [geotools.core] - ENTRY 4
30 May 17:08:00 DEBUG [filter.SQLEncoderOracle] - Visiting a Geometry filter
30 May 17:08:00 DEBUG [geotools.filter] - exporting ExpressionAttribute
30 May 17:08:00 DEBUG [filter.SQLEncoderOracle] - Using layer SRID: 999999
30 May 17:08:00 DEBUG [data.jdbc] - sql is SELECT "GEOMETRY" FROM
"CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(23.04440418101947,-32.90420814065323,66.95559581898054,14.249305822083562)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:08:00 DEBUG [data.jdbc] - SELECT "GEOMETRY" FROM "CONTINENTS_LN1"
WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(23.04440418101947,-32.90420814065323,66.95559581898054,14.249305822083562)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:08:00 DEBUG [data.jdbc] - About to execute query: SELECT
"GEOMETRY" FROM "CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(23.04440418101947,-32.90420814065323,66.95559581898054,14.249305822083562)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:08:00 DEBUG [filter.SQLEncoderOracle] - Using layer SRID: 999999
30 May 17:08:00 DEBUG [data.jdbc] - sql is SELECT "GEOMETRY" FROM
"CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-18.794165304472486,-47.9534391891417,45.29841281999489,-0.7006802423827015)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:08:00 DEBUG [data.jdbc] - SELECT "GEOMETRY" FROM "CONTINENTS_LN1"
WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-18.794165304472486,-47.9534391891417,45.29841281999489,-0.7006802423827015)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:08:00 DEBUG [data.jdbc] - About to execute query: SELECT
"GEOMETRY" FROM "CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-18.794165304472486,-47.9534391891417,45.29841281999489,-0.7006802423827015)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:08:00 DEBUG [data.oracle] - About to create Geometry convertor for
CONTINENTS_LN1.GEOMETRY
30 May 17:08:00 DEBUG [data.oracle] - About to create Geometry convertor for
CONTINENTS_LN1.GEOMETRY
30 May 17:08:00 DEBUG [geotools.rendering] - Setting fill:
java.awt.Color[r=136,g=136,b=85]
30 May 17:08:00 DEBUG [geotools.rendering] - Setting fill:
java.awt.Color[r=136,g=136,b=85]
30 May 17:08:00 DEBUG [geotools.rendering] - Style cache hit ratio: 0.0 ,
hits 0, requests 1
30 May 17:08:00 DEBUG [renderer.shape] - Style cache hit ratio: NaN , hits
0, requests 0
30 May 17:08:00 DEBUG [wms.responses] - asking delegate for write to
org.geoserver.ows.DispatcherOutputStream@anonymised.com
30 May 17:08:00 DEBUG [geotools.image] - Encoding input image to write out
as JPEG.
30 May 17:08:00 DEBUG [geotools.image] - Getting a JPEG writer and
configuring it.
30 May 17:08:00 DEBUG [geotools.rendering] - Style cache hit ratio: 0.0 ,
hits 0, requests 1
30 May 17:08:00 DEBUG [renderer.shape] - Style cache hit ratio: NaN , hits
0, requests 0
30 May 17:08:00 DEBUG [wms.responses] - asking delegate for write to
org.geoserver.ows.DispatcherOutputStream@anonymised.com
30 May 17:08:00 DEBUG [geotools.image] - Encoding input image to write out
as JPEG.
30 May 17:08:00 DEBUG [geotools.image] - Writing out...
30 May 17:08:00 DEBUG [geotools.image] - Getting a JPEG writer and
configuring it.
30 May 17:08:00 DEBUG [geotools.image] - Writing out...
30 May 17:08:00 INFO [geoserver.filters] - Not compressing output for
mimetype: image/jpeg
30 May 17:08:00 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=4800000,4800000,11200000,11200000&WIDTH=256&HEIGHT=256"
took 342ms
30 May 17:08:00 INFO [geoserver.filters] - Not compressing output for
mimetype: image/jpeg
30 May 17:08:00 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=-1600000,4800000,4800000,11200000&WIDTH=256&HEIGHT=256"
took 342ms
30 May 17:08:00 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=-8000000,4800000,-1600000,11200000&WIDTH=256&HEIGHT=256"
"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.14) Gecko/20080404
Firefox/2.0.0.14"
"http://figis02:8282/figis/Web_maps/test/openlayers_projection_web.html"
30 May 17:08:00 DEBUG [geoserver.global] - getting type fifao:CONTINENTS_LN1
30 May 17:08:00 DEBUG [geoserver.ows] - Getting layers and styles from
LAYERS and STYLES
30 May 17:08:00 DEBUG [geotools.styling] - number of fts set 1
30 May 17:08:00 DEBUG [geoserver.ows] - establishing Continent_style style
for fifao:CONTINENTS_LN1
30 May 17:08:00 DEBUG [wms.responses] - setting up map
30 May 17:08:00 DEBUG [wms.map] - setting up 256x256 image
30 May 17:08:00 DEBUG [renderer.shape] - Affine Transform is
AffineTransform[[4.0E-5, 0.0, 320.0], [0.0, -4.0E-5, 448.0]]
30 May 17:08:00 DEBUG [geotools.styling] - number of fts set 1
30 May 17:08:00 DEBUG [geotools.rendering] - processing 1 stylers for
CONTINENTS_LN1
30 May 17:08:00 DEBUG [geotools.rendering] - creating rules for scale
denominator - 89,285,714.286
30 May 17:08:00 DEBUG [geotools.rendering] - Expanding rendering area by 1
pixels to consider stroke width
30 May 17:08:00 DEBUG [geotools.rendering] - Querying layer CONTINENTS_LN1
with bbox: ReferencedEnvelope[-59.24669533879565 : -7.987131273448091,
-45.94318095497626 : 6.303429029339396]
30 May 17:08:00 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:08:00 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
30 May 17:08:00 DEBUG [data.jdbc] - calling sql builder with filter [
GEOMETRY bbox POLYGON ((-59.24669533879565 -45.94318095497626,
-59.24669533879565 6.303429029339396, -7.987131273448091 6.303429029339396,
-7.987131273448091 -45.94318095497626, -59.24669533879565
-45.94318095497626)) ]
30 May 17:08:00 TRACE [geotools.core] - ENTRY 4
30 May 17:08:00 DEBUG [filter.SQLEncoderOracle] - Visiting a Geometry filter
30 May 17:08:00 DEBUG [geotools.filter] - exporting ExpressionAttribute
30 May 17:08:00 DEBUG [filter.SQLEncoderOracle] - Using layer SRID: 999999
30 May 17:08:00 DEBUG [data.jdbc] - sql is SELECT "GEOMETRY" FROM
"CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-59.24669533879565,-45.94318095497626,-7.987131273448091,6.303429029339396)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:08:00 DEBUG [data.jdbc] - SELECT "GEOMETRY" FROM "CONTINENTS_LN1"
WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-59.24669533879565,-45.94318095497626,-7.987131273448091,6.303429029339396)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:08:00 DEBUG [data.jdbc] - About to execute query: SELECT
"GEOMETRY" FROM "CONTINENTS_LN1" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-59.24669533879565,-45.94318095497626,-7.987131273448091,6.303429029339396)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
30 May 17:08:00 DEBUG [data.oracle] - About to create Geometry convertor for
CONTINENTS_LN1.GEOMETRY
30 May 17:08:00 DEBUG [geotools.rendering] - Setting fill:
java.awt.Color[r=136,g=136,b=85]
30 May 17:08:00 DEBUG [geotools.rendering] - Style cache hit ratio: 0.0 ,
hits 0, requests 1
30 May 17:08:00 DEBUG [renderer.shape] - Style cache hit ratio: NaN , hits
0, requests 0
30 May 17:08:00 DEBUG [wms.responses] - asking delegate for write to
org.geoserver.ows.DispatcherOutputStream@anonymised.com
30 May 17:08:00 DEBUG [geotools.image] - Encoding input image to write out
as JPEG.
30 May 17:08:00 DEBUG [geotools.image] - Getting a JPEG writer and
configuring it.
30 May 17:08:00 DEBUG [geotools.image] - Writing out...
30 May 17:08:00 INFO [geoserver.filters] - Not compressing output for
mimetype: image/jpeg
30 May 17:08:00 INFO [geoserver.filters] - 168.202.106.33 "GET
/geoserver/wms?version=1.1.1&LAYERS=fifao%3ACONTINENTS_LN1&SERVICE=WMS&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&FORMAT=image%2Fjpeg&SRS=EPSG%3A3031&BBOX=-8000000,4800000,-1600000,11200000&WIDTH=256&HEIGHT=256"
took 243ms

Sylvain

ReinhardF wrote:

I wrote a bug report that might apply to the problem:
http://jira.codehaus.org/browse/GEOS-1961

springrider wrote:

Good afternoon

I am currently working on reprojecting geographical data which are set in
GeoServer with SRS:4326 into different projections such as antarctic
stereographic plor projection
(SRS:3031:http://nsidc.org/data/atlas/epsg_3031.html)

This is the URL built by my client:
http://localhost:8080/geoserver/wms?service=WMS&version=1.1.1&request=GetMap&srs=EPSG:3031&format=image/gif&width=1000&height=1000&bbox=-12400000,-12400000,12400000,12400000&layers=fifao:ln1

When the layer listed in the URL correponds to a shapefile datastore in
Geoserver, the pojection is correct.

But when i load the same shapefile into an Oracle table in my database
and make the URL pointing to the featuretype in Geoserver corresponding
to this table in Oracle, i obtain a white map.

In that case, the features can not be reprojected. Even by specifying the
SRS 3031 in Geoserver for that featuretype, it can not be projected
according to that SRS.

Could it be a Geoserver bug?Or is it on Oracle side?

I use GS 1.6.3 and Oracle Locator 10.2.

Thanks for your help.

Sylvain

--
View this message in context: http://www.nabble.com/Problem-of-projection-for-data-stored-in-Oracle-Locator-tp17536770p17561687.html
Sent from the GeoServer - User mailing list archive at Nabble.com.