Thanks for the suggestions guys.
The following oracle query works:
select count(*) from sounding p where SDO_FILTER(
p.SHAPE,sdo_geometry(2003,8265,null,mdsys.sdo_elem_info_array(1,1003,3),mdsys.sdo_ordinate_array(-95,26.5,-94.75,26.75))
) = 'TRUE'
the GET request:
request=getFeature&service=wfs&version=1.0.0&typename=soundings&maxfeatures=10
times out, but the describefeaturetype request continues to work. It's
response seems to confirm that mapserver is actually connecting to oracle.
I haven't had much success w/ the mapserver debugging. I set "DEBUG on"
in both the MAP and LAYER section of the mapfile and defined the env
variables:
MS_ERRORFILE=/tmp/msErrors.txt
CPL_DEBUG=ON
PROJ_DEBUG=ON
I'm seeing debugging messages from PROJ, GDAL but not from Mapserver.
Any further ideas on how to proceed?
Thanks!
-- john
Pericles S. Nacionales wrote:
John,
Can you confirm that the SQL query works outside of MapServer? This could
well be a MapServer bug (and I suspect is related to PostGIS query problems
thaat some users are experiencing). You might have to enable the debugging
mode to get more info.
-Perry
On Thursday 20 April 2006 11:23, John Cartwright wrote:
Hi Bart,
yes, I did - same results:
<gml:Box srsName="epsg:4269">
<gml:coordinates>-95,26.5 -94.75,26.75</gml:coordinates>
</gml:Box>
"EPSG:4269" and "epsg:4269" produce the same results in the request, but
the mapfile seems to only recognize the lowercase representation.
from the mapfile:
DATA "SHAPE FROM BATHYUSER.SOUNDING USING SRID 8265"
PROJECTION
"init=epsg:4269"
END
Is there a way that I can see any more detail on how mapserver "sees"
the request?
Thanks!
-- john
Eijnden, B. van den (Bart) wrote:
Have you tried Perry's suggestion to use:
<gml:Box srsName="EPSG:4269">
<gml:coordinates>-95,26.5 -94.75,26.75</gml:coordinates>
</gml:Box>
?
What's does your LAYER's PROJECTION block look like?
Best regards,
Bart
