[mapserver-users] Investigating OpenLayers -> MapServer (WMS) -> OGR -> db

[P Kishor]

I am experimenting with OpenLayers calling MapServer (WMS) using OGR
to extract data from a database. In a separate thread I asked about
logging what MapServer is up to. With Daniel Morissette's help, I am
now able to log the following --

[Fri Apr 18 08:46:54 2008].505608
msOGRLayerClose(/Users/punkish/Data/sqlitegis/wi.db).
[Fri Apr 18 08:46:54 2008].505626
msOGRFileClose(/Users/punkish/Data/sqlitegis/wi.db,-1).
[Fri Apr 18 08:46:54 2008].505647
msConnPoolRelease(sg_zip,/Users/punkish/Data/sqlitegis/wi.db,0x1126de0)
[Fri Apr 18 08:46:54 2008].505654
msConnPoolClose(/Users/punkish/Data/sqlitegis/wi.db,0x1126de0)
[Fri Apr 18 08:46:54 2008].506741 msDrawMap(): Layer 0 (sg_zip), 0.257s
[Fri Apr 18 08:46:54 2008].216458
msOGRFileOpen(/Users/punkish/Data/sqlitegis/wi.db)...
[Fri Apr 18 08:46:54 2008].228475 OGROPen(/Users/punkish/Data/sqlitegis/wi.db)
[Fri Apr 18 08:46:54 2008].231712
msConnPoolRegister(sg_zip,/Users/punkish/Data/sqlitegis/wi.db,0x1126de0)

yes, but I want the exact SQL statement being executed. See, in my
mapfile, I ask for

DATA "SELECT wkt_geometry FROM <table>"

But, OpenLayers sends a BBOX, so each SELECT should actually be something like

SELECT wkt_geometry FROM <table> WHERE <extent of features is in the BBOX>

That is what I want to investigate. What exactly is OGR/MapServer
executing? What is the form of "WHERE <extent of features in the
BBOX>"? How can I log this level of detail?



-- 
Puneet Kishor