[Sun Aug 14 15:04:30 2011].366506 msOracleSpatialLayerOpen called with: SHAPE from metar.marine_traffic_view using UNIQUE OBJECTID SRID 8265 (Layer pointer 0x1fab4bc0)
[Sun Aug 14 15:04:30 2011].366513 msOracleSpatialLayerFreeItemInfo was called.
[Sun Aug 14 15:04:30 2011].366521 msOracleSpatialLayerFreeItemInfo was called.
[Sun Aug 14 15:04:30 2011].366530 msOracleSpatialLayerGetItems was called.
[Sun Aug 14 15:04:30 2011].366920 msOracleSpatialLayerInitItemInfo was called.
[Sun Aug 14 15:04:30 2011].366936 msOracleSpatialLayerInitItemInfo was called.
[Sun Aug 14 15:04:30 2011].367425 msOracleSpatialLayerWhichShapes was called.
[Sun Aug 14 15:04:30 2011].367489 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT OBJECTID, NAME, SPEED, FLAG, SHIP_DETAILS, DESCRIPTION, STYLE, CRAFT_TYPE, DIRECTION, rownum, SHAPE FROM metar.marine_traffic_view WHERE SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'
[Sun Aug 14 15:04:30 2011].367496 msOracleSpatialLayerWhichShapes. Bind values: srid:8265   minx:-127.359077   miny:29.502911  maxx:-110.589659   maxy:39.353618 
[Sun Aug 14 15:04:30 2011].367594 msOracleSpatialLayerWhichShapes getting ordinate definition.
[Sun Aug 14 15:04:30 2011].368610 msOracleSpatialLayerWhichShapes converting to OCIColl.
[Sun Aug 14 15:04:30 2011].368771 msOracleSpatialLayerWhichShapes bind by name and object.
[Sun Aug 14 15:04:30 2011].368835 msOracleSpatialLayerWhichShapes name and object now bound.
[Sun Aug 14 15:04:30 2011].445335 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 0
[Sun Aug 14 15:04:30 2011].447371 KmlRenderer - 3::add coordinates:	-118.49150000,33.87000000
[Sun Aug 14 15:04:30 2011].447400 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 1
[Sun Aug 14 15:04:30 2011].448693 KmlRenderer - 3::add coordinates:	-118.45370000,33.91418000
[Sun Aug 14 15:04:30 2011].448718 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 2
[Sun Aug 14 15:04:30 2011].449053 KmlRenderer - 3::add coordinates:	-118.45390000,33.91427000
[Sun Aug 14 15:04:30 2011].449079 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 3
[Sun Aug 14 15:04:30 2011].450204 KmlRenderer - 3::add coordinates:	-118.44970000,33.97207000
[Sun Aug 14 15:04:30 2011].450232 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 4
[Sun Aug 14 15:04:30 2011].451396 KmlRenderer - 3::add coordinates:	-119.20440000,34.14780000
[Sun Aug 14 15:04:30 2011].451416 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 5
[Sun Aug 14 15:04:30 2011].451695 KmlRenderer - 3::add coordinates:	-119.20520000,34.14867000
[Sun Aug 14 15:04:30 2011].451711 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 6
[Sun Aug 14 15:04:30 2011].451778 KmlRenderer - 3::add coordinates:	-119.20750000,34.14783000
[Sun Aug 14 15:04:30 2011].451792 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 7
[Sun Aug 14 15:04:30 2011].452493 KmlRenderer - 3::add coordinates:	-120.30410000,33.68667000
[Sun Aug 14 15:04:30 2011].452507 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 8
[Sun Aug 14 15:04:30 2011].452648 KmlRenderer - 3::add coordinates:	-119.66490000,34.40513000
[Sun Aug 14 15:04:30 2011].452656 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 9
[Sun Aug 14 15:04:30 2011].453282 KmlRenderer - 3::add coordinates:	-119.69260000,34.40460000
[Sun Aug 14 15:04:30 2011].453292 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 10
[Sun Aug 14 15:04:30 2011].453350 KmlRenderer - 3::add coordinates:	-119.69130000,34.40621000
.......
[Sun Aug 14 15:04:30 2011].469249 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 300
[Sun Aug 14 15:04:30 2011].469294 KmlRenderer - 3::add coordinates:	-117.92350000,33.61119000
[Sun Aug 14 15:04:30 2011].469300 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 301
[Sun Aug 14 15:04:30 2011].469329 KmlRenderer - 3::add coordinates:	-117.90440000,33.61253000
[Sun Aug 14 15:04:30 2011].469335 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 302
[Sun Aug 14 15:04:30 2011].469384 KmlRenderer - 3::add coordinates:	-117.91330000,33.61426000
[Sun Aug 14 15:04:30 2011].469390 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 303
[Sun Aug 14 15:04:30 2011].469427 KmlRenderer - 3::add coordinates:	-117.91370000,33.61439000
[Sun Aug 14 15:04:30 2011].469433 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, row_num: 304
[Sun Aug 14 15:04:30 2011].470117 msOracleSpatialLayerNextShape on layer 0x1fab4bc0, Fetched 304 more rows (304 total)
[Sun Aug 14 15:04:30 2011].470123 msOracleSpatialLayerFreeItemInfo was called.
[Sun Aug 14 15:04:30 2011].470129 msOracleSpatialLayerClose was called. Layer: 0x1fab4bc0, Layer name: ship_locations. Layer connection: ms/ms@gold1
[Sun Aug 14 15:04:30 2011].471424 msOracleSpatialLayerClose. Cleaning layerinfo handlers.
[Sun Aug 14 15:04:30 2011].471552 msOracleSpatialLayerClose. Release the Oracle Pool.
[Sun Aug 14 15:04:30 2011].471556 msConnPoolRelease(ship_locations,ms/ms@gold1,0x1fb53de0)
[Sun Aug 14 15:04:30 2011].471729 msDrawMap(): Layer 312 (ship_locations), 0.181s
[Sun Aug 14 15:04:30 2011].944044 msOracleSpatialLayerClose was called. Layer: 0x1fab4bc0, Layer name: ship_locations. Layer connection: ms/ms@gold1
[Sun Aug 14 15:04:30 2011].944547 freeLayer(): freeing layer at 0x1f6ea8a0.
[Sun Aug 14 15:04:30 2011].953279 msConnPoolClose(ms/ms@gold1,0x1fb53de0)
[Sun Aug 14 15:04:50 2011].456223 msOracleSpatialLayerOpen called with: SHAPE from metar.marine_traffic_view using UNIQUE OBJECTID SRID 8265 (Layer pointer 0x1524bc0)
[Sun Aug 14 15:04:50 2011].531521 msOracleSpatialLayerOpen. Shared connection not available. Creating one.
[Sun Aug 14 15:04:50 2011].531541 msConnPoolRegister(ship_locations,ms/ms@gold1,0x15c3de0)
[Sun Aug 14 15:04:50 2011].538252 msOracleSpatialLayerFreeItemInfo was called.
[Sun Aug 14 15:04:50 2011].538274 msOracleSpatialLayerFreeItemInfo was called.
[Sun Aug 14 15:04:50 2011].538284 msOracleSpatialLayerGetItems was called.
[Sun Aug 14 15:04:50 2011].539437 msOracleSpatialLayerInitItemInfo was called.
[Sun Aug 14 15:04:50 2011].539467 msOracleSpatialLayerInitItemInfo was called.
[Sun Aug 14 15:04:50 2011].539492 msOracleSpatialLayerOpen called with: SHAPE from metar.marine_traffic_view using UNIQUE OBJECTID SRID 8265 (Layer pointer 0x1524bc0)
[Sun Aug 14 15:04:50 2011].539500 msOracleSpatialLayerFreeItemInfo was called.
[Sun Aug 14 15:04:50 2011].539508 msOracleSpatialLayerFreeItemInfo was called.
[Sun Aug 14 15:04:50 2011].539513 msOracleSpatialLayerGetItems was called.
[Sun Aug 14 15:04:50 2011].539905 msOracleSpatialLayerInitItemInfo was called.
[Sun Aug 14 15:04:50 2011].539925 msOracleSpatialLayerInitItemInfo was called.
[Sun Aug 14 15:04:50 2011].540102 msOracleSpatialLayerWhichShapes was called.
[Sun Aug 14 15:04:50 2011].540155 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT OBJECTID, NAME, SPEED, FLAG, SHIP_DETAILS, DESCRIPTION, STYLE, CRAFT_TYPE, DIRECTION, rownum, SHAPE FROM metar.marine_traffic_view WHERE SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'
[Sun Aug 14 15:04:50 2011].540162 msOracleSpatialLayerWhichShapes. Bind values: srid:8265   minx:-119.103102   miny:33.157723  maxx:-116.827378   maxy:34.507158 
[Sun Aug 14 15:04:50 2011].540245 msOracleSpatialLayerWhichShapes getting ordinate definition.
[Sun Aug 14 15:04:50 2011].541268 msOracleSpatialLayerWhichShapes converting to OCIColl.
[Sun Aug 14 15:04:50 2011].541421 msOracleSpatialLayerWhichShapes bind by name and object.
[Sun Aug 14 15:04:50 2011].541484 msOracleSpatialLayerWhichShapes name and object now bound.
[Sun Aug 14 15:04:50 2011].597059 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 0
[Sun Aug 14 15:04:50 2011].599117 KmlRenderer - 3::add coordinates:	-118.49150000,33.87000000
[Sun Aug 14 15:04:50 2011].599178 KmlRenderer - 3::add coordinates:	-110.49150000,25.87000000
[Sun Aug 14 15:04:50 2011].599196 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 1
[Sun Aug 14 15:04:50 2011].600455 KmlRenderer - 3::add coordinates:	-118.45370000,33.91418000
[Sun Aug 14 15:04:50 2011].600486 KmlRenderer - 3::add coordinates:	-110.45370000,25.91418000
[Sun Aug 14 15:04:50 2011].600511 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 2
[Sun Aug 14 15:04:50 2011].600841 KmlRenderer - 3::add coordinates:	-118.45390000,33.91427000
[Sun Aug 14 15:04:50 2011].600866 KmlRenderer - 3::add coordinates:	-110.45390000,25.91427000
[Sun Aug 14 15:04:50 2011].600891 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 3
[Sun Aug 14 15:04:50 2011].602081 KmlRenderer - 3::add coordinates:	-118.44970000,33.97207000
[Sun Aug 14 15:04:50 2011].602109 KmlRenderer - 3::add coordinates:	-110.44970000,25.97207000
[Sun Aug 14 15:04:50 2011].602132 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 4
[Sun Aug 14 15:04:50 2011].602398 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 5
[Sun Aug 14 15:04:50 2011].602458 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 6
[Sun Aug 14 15:04:50 2011].602513 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 7
[Sun Aug 14 15:04:50 2011].602756 KmlRenderer - 3::add coordinates:	-117.88320000,33.59941000
[Sun Aug 14 15:04:50 2011].602788 KmlRenderer - 3::add coordinates:	-109.88320000,25.59941000
[Sun Aug 14 15:04:50 2011].602811 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 8
[Sun Aug 14 15:04:50 2011].602950 KmlRenderer - 3::add coordinates:	-117.90080000,33.60413000
[Sun Aug 14 15:04:50 2011].602976 KmlRenderer - 3::add coordinates:	-109.90080000,25.60413000
[Sun Aug 14 15:04:50 2011].602989 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 9
[Sun Aug 14 15:04:50 2011].603057 KmlRenderer - 3::add coordinates:	-117.92640000,33.61115000
[Sun Aug 14 15:04:50 2011].603077 KmlRenderer - 3::add coordinates:	-109.92640000,25.61115000
[Sun Aug 14 15:04:50 2011].603089 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 10
......
[Sun Aug 14 15:04:50 2011].617492 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 120
[Sun Aug 14 15:04:50 2011].617551 KmlRenderer - 3::add coordinates:	-117.90440000,33.61253000
[Sun Aug 14 15:04:50 2011].617561 KmlRenderer - 3::add coordinates:	-109.90440000,25.61253000
[Sun Aug 14 15:04:50 2011].617567 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 121
[Sun Aug 14 15:04:50 2011].617606 KmlRenderer - 3::add coordinates:	-117.91330000,33.61426000
[Sun Aug 14 15:04:50 2011].617625 KmlRenderer - 3::add coordinates:	-109.91330000,25.61426000
[Sun Aug 14 15:04:50 2011].617631 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 122
[Sun Aug 14 15:04:50 2011].617676 KmlRenderer - 3::add coordinates:	-117.91370000,33.61439000
[Sun Aug 14 15:04:50 2011].617686 KmlRenderer - 3::add coordinates:	-109.91370000,25.61439000
[Sun Aug 14 15:04:50 2011].617692 msOracleSpatialLayerNextShape on layer 0x1524bc0, row_num: 123
[Sun Aug 14 15:04:50 2011].618307 msOracleSpatialLayerNextShape on layer 0x1524bc0, Fetched 123 more rows (123 total)