Re: [Geoserver-users] Projection with BBox for complex feature

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Senthil,

what SRID code is used in the geometries in your Oracle tables? We have 
seen reprojection problems in BBox queries caused by invalid SRID codes 
(this is an internal Oracle problem, discussed on geotools-devel). The 
solution we advise is to use EPSG codes.
http://osgeo-org.1803224.n2.nabble.com/How-to-handle-Oracle-SRID-problem-td5176644.html

Please tell us what your SRID values are.

Kind regards,
Ben.

On 16/07/10 03:48, Senthil wrote:
> Hi Rini
>
>    Yes. That problem still there.. If you can check my first mail in this thread and compare simple layer feature and complex feature request co-ordinates and co-ordinates used with SDO_FILTER search. Complex feature was not returning any results as wrong co-ordinates to check with database while simple feature returning results.
>
>     Last few days, i was tried to do some work on SQLView Layer to see any possibilities of using that. I may need to recheck on this complex feature again as some limitation with SQLView with Oracle on complex SQL statements.
>
> regards
> Senthil
>
> On Thu, Jul 15, 2010 at 10:16 PM,<Rin...@cs...>  wrote:
> Hi Senthil,
>
> Are you still having problems with this?
> Are the coordinates actually reprojected at all?
> If the coordinates are reprojected but only the srsName isn't updated, it's because of this bug: http://jira.codehaus.org/browse/GEOT-2707.
> You can ignore the logs as the query it was showing is the complex feature query form, and not passed on to the database in that form.
>
> Cheers
> Rini
>
> ________________________________
> From: Senthil [mailto:sen...@gm...<mailto:sen...@gm...>]
> Sent: Friday, 9 July 2010 6:20 PM
> To: Angreani, Rini (CESRE, Kensington); Caradoc-Davies, Ben (CESRE, Kensington); geo...@li...<mailto:geo...@li...>
> Subject: Re: Projection with BBox for complex feature
>
> Hi all
>
>    Today i was tried with 2.1 snapshot version too. Still issue there and from geotools logs, i was able to see correct SRID identified from database. Hope that logic of complex schema might be issue for conversion.
>
> 09 Jul 14:21:20 DEBUG [org.geotools.data.oracle.sdo] - Using layer SRID: 2193
>
> regards
> Senthil
>
> On Thu, Jul 8, 2010 at 8:47 PM, Senthil<sen...@gm...<mailto:sen...@gm...>>  wrote:
> Hi Ben&  Rini,
>
>     Here below logs shows WFS BBox query for Complex and Simple Feature, Both are using same database table.
>
>     The complex feature request co-ordinates were not projected to database table SRID before do database SQL call. I guess it could be due to SRID identification for complex feature, as it can't find meta data from Oracle table and need to find appropriate corresponding database table name to find metadata.
>
>     Pls update me if you found any issues/fixes for this issue recently. (after geo-server 2.0.2 release) and note that this request to MappedFeature. Not for GeologicalUnit.
>
> Complex Feature request
> -------------------------------------
>
> 06 Jul 08:28:34 DEBUG [org.geoserver.ows] - Raw XML request starts with:<wfs:GetFeature xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.1.0"
> xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
> <wfs:Query typeName="gsml:MappedFeature" srsName="EPSG:900913" xmlns:gsml="urn:cgi:xmlns:CGI:GeoSciML:2.0">
>   <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
>   <ogc:BBOX>
>    <ogc:PropertyName>gsml:shape</ogc:PropertyName>
>    <gml:Envelope xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:900913">
>      <gml:lowerCorner>17236855.624099 -6516103.7862895</gml:lowerCorner>
>      <gml:upperCorner>21150431.471599 -3580921.9006645</gml:upperCorner>
>    </gml:Envelope>
>   </ogc:BBOX>
>   </ogc:Filter>
> </wfs:Query></wfs:GetFeature>
> 06 Jul 08:28:35 DEBUG [org.vfny.geoserver.requests] - Query is net.opengis.wfs.impl.QueryTypeImpl@179d4fb (group: [], propertyName: [], function: null,
> filter: [ gsml:shape bbox POLYGON ((17236855.624099 -6516103.7862895, 17236855.624099 -3580921.9006645, 21150431.471599 -3580921.9006645, 21150431.471599 -6516103.7862895, 17236855.624099 -6516103.7862895)) ]
> , sortBy: [], featureVersion: null, handle: null, srsName: EPSG:900913, typeName: [{urn:cgi:xmlns:CGI:GeoSciML:2.0}MappedFeature])
>   To gt2: Query:
>     feature type: MappedFeature
>     filter: [ gsml:shape bbox POLYGON ((17236855.624099 -6516103.7862895, 17236855.624099 -3580921.9006645, 21150431.471599 -3580921.9006645, 21150431.471599 -6516103.7862895, 17236855.624099 -6516103.7862895)) ]
>     [properties:  ALL ]
>
>   ==================================================================================================
>
> Simple Feature
> ----------------------
> 06 Jul 08:39:53 DEBUG [org.geoserver.ows] - Raw XML request starts with:<wfs:GetFeature xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.1.0"
> xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
> <wfs:Query typeName="test:PART_TABLE" srsName="EPSG:900913" xmlns:test="http://test.co.nz/gis">
>   <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
>   <ogc:BBOX>
>    <ogc:PropertyName>LOCATION</ogc:PropertyName>
>    <gml:Envelope xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:900913">
>     <gml:lowerCorner>17236855.624099 -6516103.7862895</gml:lowerCorner>
>     <gml:upperCorner>21150431.471599 -3580921.9006645</gml:upperCorner>
>    </gml:Envelope>
>   </ogc:BBOX>
>   </ogc:Filter>
> </wfs:Query></wfs:GetFeature>
> 06 Jul 08:39:53 DEBUG [org.vfny.geoserver.requests] - Query is net.opengis.wfs.impl.QueryTypeImpl@1d0e98 (group: [], propertyName: [], function: null,
> filter: [ LOCATION bbox POLYGON ((17236855.624099 -6516103.7862895, 17236855.624099 -3580921.9006645, 21150431.471599 -3580921.9006645, 21150431.471599 -6516103.7862895, 17236855.624099 -6516103.7862895)) ], sortBy: [], featureVersion: null, handle: null, srsName: EPSG:900913, typeName: [{http://test.co.nz/gis}PART_TABLE<http://test.co.nz/gis%7DPART_TABLE>])
>   To gt2: Query:
>     feature type: PART_TABLE
>     filter: [ LOCATION bbox POLYGON ((-154768.4241380731 4257259.84132448, -154768.4241380731 6614572.798694815, 3240947.544118471 6614572.798694815, 3240947.544118471 4257259.84132448, -154768.4241380731 4257259.84132448)) ]
>     [properties:  ALL ]
>
>
>

-- 
Ben Caradoc-Davies <Ben...@cs...>
Software Engineering Team Leader
CSIRO Earth Science and Resource Engineering
Australian Resources Research Centre