[Fri Nov 20 12:42:06 2009].796180 msOracleSpatialLayerOpen called with: geom FROM ms_sites_onair_vw USING UNIQUE site_id SRID 8307 (Layer pointer 844eb28)
[Fri Nov 20 12:42:07 2009].55596 msOracleSpatialLayerOpen. Shared connection not available. Creating one.
[Fri Nov 20 12:42:07 2009].55660 msConnPoolRegister(on_air,username/password@HOST,844fe38)
[Fri Nov 20 12:42:07 2009].73734 msOracleSpatialLayerFreeItemInfo was called.
[Fri Nov 20 12:42:07 2009].73751 msOracleSpatialLayerGetItems was called.
[Fri Nov 20 12:42:07 2009].76026 msOracleSpatialLayerInitItemInfo was called.
[Fri Nov 20 12:42:07 2009].76062 msOracleSpatialLayerInitItemInfo was called.
[Fri Nov 20 12:42:07 2009].76104 msOracleSpatialLayerWhichShapes was called.
[Fri Nov 20 12:42:07 2009].76170 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT site_id, SITE_ID, INTERNAL_SITE_NAME, SWITCH_OF_HOMED_BTS, CELL_SITE_COMMON_NAME, CASCADE_ID, BTS_SWITCH_ID, BTS_TYPE, EVDO_IMPLEMENTED, DATE_EVDO_IMPLEMENTED, SITE_STATUS, BTS_ON_AIR_DATE, SITE_LINK, geom FROM ms_sites_onair_vw WHERE SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'
[Fri Nov 20 12:42:07 2009].76175 msOracleSpatialLayerWhichShapes. Bind values: srid:8307   minx:-85.660031   miny:44.581853  maxx:-85.299836   maxy:44.965704
[Fri Nov 20 12:42:07 2009].76283 msOracleSpatialLayerWhichShapes getting ordinate definition.
[Fri Nov 20 12:42:07 2009].79870 msOracleSpatialLayerWhichShapes converting to OCIColl.
[Fri Nov 20 12:42:07 2009].80124 msOracleSpatialLayerWhichShapes bind by name and object.
[Fri Nov 20 12:42:07 2009].80210 msOracleSpatialLayerWhichShapes name and object now bound.
[Fri Nov 20 12:42:07 2009].876736 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 0
[Fri Nov 20 12:42:07 2009].877068 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 1
[Fri Nov 20 12:42:07 2009].877104 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 2
[Fri Nov 20 12:42:07 2009].877119 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 3
[Fri Nov 20 12:42:07 2009].877135 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 4
[Fri Nov 20 12:42:07 2009].877150 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 5
[Fri Nov 20 12:42:07 2009].877164 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 6
[Fri Nov 20 12:42:07 2009].877178 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 7
[Fri Nov 20 12:42:07 2009].877191 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 8
[Fri Nov 20 12:42:07 2009].877205 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 9
[Fri Nov 20 12:42:07 2009].877220 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 10
[Fri Nov 20 12:42:07 2009].877234 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 11
[Fri Nov 20 12:42:07 2009].877249 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 12
[Fri Nov 20 12:42:07 2009].877264 msOracleSpatialLayerNextShape on layer 844eb28, row_num: 13
[Fri Nov 20 12:42:07 2009].878105 msOracleSpatialLayerNextShape on layer 844eb28, Fetched 0 more rows (13 total)
[Fri Nov 20 12:42:07 2009].884327 msOracleSpatialLayerClose was called. Layer: 844eb28, Layer name: on_air. Layer connection: username/password@HOST
[Fri Nov 20 12:42:07 2009].884446 msOracleSpatialLayerClose. Cleaning layerinfo handlers.
[Fri Nov 20 12:42:07 2009].884462 msOracleSpatialLayerClose. Release the Oracle Pool.
[Fri Nov 20 12:42:07 2009].884492 msConnPoolRelease(on_air,username/password@HOST,844fe38)
[Fri Nov 20 12:42:07 2009].884626 freeLayer(): freeing layer at 844eb28.
[Fri Nov 20 12:43:25 2009].605871 msQueryByShape(): Search returned no results. No matching record(s) found.
[Fri Nov 20 12:43:25 2009].606054 msQueryByShape(): Search returned no results. No matching record(s) found.
[Fri Nov 20 12:43:25 2009].668345 msQueryByShape(): Search returned no results. No matching record(s) found.
[Fri Nov 20 12:43:25 2009].668545 msQueryByShape(): Search returned no results. No matching record(s) found.
[Fri Nov 20 12:43:25 2009].668700 msQueryByShape(): Search returned no results. No matching record(s) found.
[Fri Nov 20 12:43:25 2009].668853 msQueryByShape(): Search returned no results. No matching record(s) found.
[Fri Nov 20 12:43:25 2009].669008 msQueryByShape(): Search returned no results. No matching record(s) found.
[Fri Nov 20 12:43:25 2009].669161 msQueryByShape(): Search returned no results. No matching record(s) found.
[Fri Nov 20 12:43:25 2009].669327 msQueryByShape(): Search returned no results. No matching record(s) found.
[Fri Nov 20 12:43:25 2009].669484 msQueryByShape(): Search returned no results. No matching record(s) found.
[Fri Nov 20 12:43:25 2009].669644 msQueryByShape(): Search returned no results. No matching record(s) found.
[Fri Nov 20 12:43:25 2009].669801 msQueryByShape(): Search returned no results. No matching record(s) found.
[Fri Nov 20 12:43:25 2009].706437 msOracleSpatialLayerOpen called with: geom FROM ms_sites_onair_vw USING UNIQUE site_id SRID 8307 (Layer pointer 8457198)
[Fri Nov 20 12:43:25 2009].706494 msConnPoolRequest(on_air,username/password@HOST) -> got 844fe38
[Fri Nov 20 12:43:25 2009].710470 msOracleSpatialLayerFreeItemInfo was called.
[Fri Nov 20 12:43:25 2009].710480 msOracleSpatialLayerGetItems was called.
[Fri Nov 20 12:43:25 2009].712307 msOracleSpatialLayerInitItemInfo was called.
[Fri Nov 20 12:43:25 2009].712319 msOracleSpatialLayerInitItemInfo was called.
[Fri Nov 20 12:43:25 2009].712324 msOracleSpatialLayerWhichShapes was called.
[Fri Nov 20 12:43:25 2009].712415 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT site_id, SITE_ID, INTERNAL_SITE_NAME, SWITCH_OF_HOMED_BTS, CELL_SITE_COMMON_NAME, CASCADE_ID, BTS_SWITCH_ID, BTS_TYPE, EVDO_IMPLEMENTED, DATE_EVDO_IMPLEMENTED, SITE_STATUS, BTS_ON_AIR_DATE, SITE_LINK, geom FROM ms_sites_onair_vw WHERE SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'
[Fri Nov 20 12:43:25 2009].712421 msOracleSpatialLayerWhichShapes. Bind values: srid:8307   minx:-85.531974   miny:44.701631  maxx:-85.421979   maxy:44.837646
[Fri Nov 20 12:43:25 2009].712455 msOracleSpatialLayerWhichShapes getting ordinate definition.
[Fri Nov 20 12:43:25 2009].713443 msOracleSpatialLayerWhichShapes converting to OCIColl.
[Fri Nov 20 12:43:25 2009].713542 msOracleSpatialLayerWhichShapes bind by name and object.
[Fri Nov 20 12:43:25 2009].713557 msOracleSpatialLayerWhichShapes name and object now bound.
[Fri Nov 20 12:43:26 2009].83514 msOracleSpatialLayerNextShape on layer 8457198, row_num: 0
[Fri Nov 20 12:43:26 2009].83609 msOracleSpatialLayerNextShape on layer 8457198, row_num: 1
[Fri Nov 20 12:43:26 2009].83624 msOracleSpatialLayerNextShape on layer 8457198, row_num: 2
[Fri Nov 20 12:43:26 2009].83638 msOracleSpatialLayerNextShape on layer 8457198, row_num: 3
[Fri Nov 20 12:43:26 2009].84510 msOracleSpatialLayerNextShape on layer 8457198, Fetched 0 more rows (3 total)
[Fri Nov 20 12:43:26 2009].85247 msOracleSpatialLayerOpen called with: geom FROM ms_sites_onair_vw USING UNIQUE site_id SRID 8307 (Layer pointer 8457198)
[Fri Nov 20 12:43:26 2009].85259 msOracleSpatialLayerFreeItemInfo was called.
[Fri Nov 20 12:43:26 2009].85267 msOracleSpatialLayerGetItems was called.
[Fri Nov 20 12:43:26 2009].87118 msOracleSpatialLayerInitItemInfo was called.
[Fri Nov 20 12:43:26 2009].87337 msOracleSpatialLayerGetShape was called. Using the record = 2216.
[Fri Nov 20 12:43:26 2009].87353 msOracleSpatialLayerGetShape. Sql: SELECT SITE_ID, INTERNAL_SITE_NAME, SWITCH_OF_HOMED_BTS, CELL_SITE_COMMON_NAME, CASCADE_ID, BTS_SWITCH_ID, BTS_TYPE, EVDO_IMPLEMENTED, DATE_EVDO_IMPLEMENTED, SITE_STATUS, BTS_ON_AIR_DATE, SITE_LINK, geom FROM ms_sites_onair_vw WHERE site_id = 2216
[Fri Nov 20 12:43:26 2009].105448 msOracleSpatialLayerGetShape was called. Using the record = 2216.
[Fri Nov 20 12:43:26 2009].105470 msOracleSpatialLayerGetShape. Sql: SELECT SITE_ID, INTERNAL_SITE_NAME, SWITCH_OF_HOMED_BTS, CELL_SITE_COMMON_NAME, CASCADE_ID, BTS_SWITCH_ID, BTS_TYPE, EVDO_IMPLEMENTED, DATE_E[Fri Nov 20 12:43:27 2009].737328 CGI Request 1 on process 15864
[Fri Nov 20 12:43:27 2009].738178 msOracleSpatialLayerOpen called with: geom FROM ms_sites_onair_vw USING UNIQUE site_id SRID 8307 (Layer pointer 81ef258)
[Fri Nov 20 12:43:28 2009].20336 msOracleSpatialLayerOpen. Shared connection not available. Creating one.
[Fri Nov 20 12:43:28 2009].20353 msConnPoolRegister(on_air,username/password@HOST,81e9c48)
[Fri Nov 20 12:43:28 2009].42020 msOracleSpatialLayerFreeItemInfo was called.
[Fri Nov 20 12:43:28 2009].42058 msOracleSpatialLayerGetItems was called.
[Fri Nov 20 12:43:28 2009].44713 msOracleSpatialLayerInitItemInfo was called.
[Fri Nov 20 12:43:28 2009].44728 msOracleSpatialLayerInitItemInfo was called.
[Fri Nov 20 12:43:28 2009].44745 msOracleSpatialLayerWhichShapes was called.
[Fri Nov 20 12:43:28 2009].44834 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT site_id, SITE_ID, INTERNAL_SITE_NAME, SWITCH_OF_HOMED_BTS, CELL_SITE_COMMON_NAME, CASCADE_ID, BTS_SWITCH_ID, BTS_TYPE, EVDO_IMPLEMENTED, DATE_EVDO_IMPLEMENTED, SITE_STATUS, BTS_ON_AIR_DATE, SITE_LINK, geom FROM ms_sites_onair_vw WHERE SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'
[Fri Nov 20 12:43:28 2009].44840 msOracleSpatialLayerWhichShapes. Bind values: srid:8307   minx:-85.535528   miny:44.698078  maxx:-85.418426   maxy:44.841200
[Fri Nov 20 12:43:28 2009].44987 msOracleSpatialLayerWhichShapes getting ordinate definition.
[Fri Nov 20 12:43:28 2009].48861 msOracleSpatialLayerWhichShapes converting to OCIColl.
[Fri Nov 20 12:43:28 2009].49151 msOracleSpatialLayerWhichShapes bind by name and object.
[Fri Nov 20 12:43:28 2009].49247 msOracleSpatialLayerWhichShapes name and object now bound.
[Fri Nov 20 12:43:28 2009].484656 msOracleSpatialLayerNextShape on layer 81ef258, row_num: 0
[Fri Nov 20 12:43:28 2009].484804 msOracleSpatialLayerNextShape on layer 81ef258, row_num: 1
[Fri Nov 20 12:43:28 2009].484820 msOracleSpatialLayerNextShape on layer 81ef258, row_num: 2
[Fri Nov 20 12:43:28 2009].484833 msOracleSpatialLayerNextShape on layer 81ef258, row_num: 3
[Fri Nov 20 12:43:28 2009].485737 msOracleSpatialLayerNextShape on layer 81ef258, Fetched 0 more rows (3 total)
[Fri Nov 20 12:43:28 2009].495468 msOracleSpatialLayerOpen called with: geom FROM ms_sites_onair_vw USING UNIQUE site_id SRID 8307 (Layer pointer b8a3f18)
[Fri Nov 20 12:43:28 2009].495570 msConnPoolRequest(on_air_copy,username/password@HOST) -> got 81e9c48
[Fri Nov 20 12:43:28 2009].499250 msOracleSpatialLayerFreeItemInfo was called.
[Fri Nov 20 12:43:28 2009].499259 msOracleSpatialLayerGetItems was called.
[Fri Nov 20 12:43:28 2009].501186 msOracleSpatialLayerInitItemInfo was called.
[Fri Nov 20 12:43:28 2009].501199 msOracleSpatialLayerInitItemInfo was called.
[Fri Nov 20 12:43:28 2009].501206 msOracleSpatialLayerWhichShapes was called.
[Fri Nov 20 12:43:28 2009].501275 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT site_id, evdo_implemented, bts_switch_id, geom FROM ms_sites_onair_vw WHERE SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'
[Fri Nov 20 12:43:28 2009].501281 msOracleSpatialLayerWhichShapes. Bind values: srid:8307   minx:-85.927119   miny:44.343262  maxx:-85.010276   maxy:45.115590
[Fri Nov 20 12:43:28 2009].501314 msOracleSpatialLayerWhichShapes getting ordinate definition.
[Fri Nov 20 12:43:28 2009].502227 msOracleSpatialLayerWhichShapes converting to OCIColl.
[Fri Nov 20 12:43:28 2009].502279 msOracleSpatialLayerWhichShapes bind by name and object.
[Fri Nov 20 12:43:28 2009].502294 msOracleSpatialLayerWhichShapes name and object now bound.
[Fri Nov 20 12:43:29 2009].651068 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 0
[Fri Nov 20 12:43:29 2009].651628 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 1
[Fri Nov 20 12:43:29 2009].651725 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 2
[Fri Nov 20 12:43:29 2009].651794 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 3
[Fri Nov 20 12:43:29 2009].651861 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 4
[Fri Nov 20 12:43:29 2009].651929 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 5
[Fri Nov 20 12:43:29 2009].651997 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 6
[Fri Nov 20 12:43:29 2009].652064 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 7
[Fri Nov 20 12:43:29 2009].652154 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 8
[Fri Nov 20 12:43:29 2009].652223 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 9
[Fri Nov 20 12:43:29 2009].652290 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 10
[Fri Nov 20 12:43:29 2009].652372 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 11
[Fri Nov 20 12:43:29 2009].652441 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 12
[Fri Nov 20 12:43:29 2009].652509 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 13
[Fri Nov 20 12:43:29 2009].652576 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 14
[Fri Nov 20 12:43:29 2009].652643 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 15
[Fri Nov 20 12:43:29 2009].652709 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 16
[Fri Nov 20 12:43:29 2009].652776 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 17
[Fri Nov 20 12:43:29 2009].652786 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 18
[Fri Nov 20 12:43:29 2009].652872 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 19
[Fri Nov 20 12:43:29 2009].652941 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 20
[Fri Nov 20 12:43:29 2009].653008 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 21
[Fri Nov 20 12:43:29 2009].653075 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 22
[Fri Nov 20 12:43:29 2009].653154 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 23
[Fri Nov 20 12:43:29 2009].653221 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 24
[Fri Nov 20 12:43:29 2009].653302 msOracleSpatialLayerNextShape on layer b8a3f18, row_num: 25
[Fri Nov 20 12:43:29 2009].654150 msOracleSpatialLayerNextShape on layer b8a3f18, Fetched 0 more rows (25 total)
[Fri Nov 20 12:43:29 2009].654158 msOracleSpatialLayerFreeItemInfo was called.
[Fri Nov 20 12:43:29 2009].654165 msOracleSpatialLayerClose was called. Layer: b8a3f18, Layer name: on_air_copy. Layer connection: username/password@HOST
[Fri Nov 20 12:43:29 2009].654233 msOracleSpatialLayerClose. Cleaning layerinfo handlers.
[Fri Nov 20 12:43:29 2009].654255 msOracleSpatialLayerClose. Release the Oracle Pool.
[Fri Nov 20 12:43:29 2009].654260 msConnPoolRelease(on_air_copy,username/password@HOST,81e9c48)
[Fri Nov 20 12:43:29 2009].654274 msOracleSpatialLayerResultGetShape was called. Using the record = 0 of 3. (shape: 2216 should equal pkey: 2216)
[Fri Nov 20 12:43:29 2009].654279 msOracleSpatialLayerResultGetShape: Fetching result from DB start: 0 end:-1 record: 0
[Fri Nov 20 12:43:29 2009].659954 msOracleSpatialLayerResultGetShape was called. Using the record = 1 of 3. (shape: 2218 should equal pkey: 2218)
[Fri Nov 20 12:43:29 2009].660044 msOracleSpatialLayerResultGetShape was called. Using the record = 2 of 3. (shape: 1977 should equal pkey: 1977)
[Fri Nov 20 12:43:29 2009].660119 msDrawMap(): Layer 2 (on_air), 1.165s
[Fri Nov 20 12:43:29 2009].764716 msOracleSpatialLayerClose was called. Layer: 81ef258, Layer name: on_air. Layer connection: username/password@HOST
[Fri Nov 20 12:43:29 2009].764784 msOracleSpatialLayerClose. Cleaning layerinfo handlers.
[Fri Nov 20 12:43:29 2009].764799 msOracleSpatialLayerClose. Release the Oracle Pool.
[Fri Nov 20 12:43:29 2009].764804 msConnPoolRelease(on_air,username/password@HOST,81e9c48)
[Fri Nov 20 12:43:29 2009].764812 msOracleSpatialLayerClose was called. Layer: b8a3f18, Layer name: on_air_copy. Layer connection: username/password@HOST
[Fri Nov 20 12:43:29 2009].765022 freeLayer(): freeing layer at 81ef258.
[Fri Nov 20 12:43:29 2009].765048 freeLayer(): freeing layer at b8a3f18.
[Fri Nov 20 12:43:29 2009].765096 msConnPoolClose(username/password@HOST,81e9c48)