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

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

Hi Ben & Rini,

  I just compared simple feature layer call logs with complex feature and
both refers same table. Simple feature logs i was able to see co-ordinates
were changed and complex feature not. i just copied again below.  And
database table data SRID is 2913 as i was able to project that table alone
as simple feature layer. I will send the mapping configuration soon

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 ]

Thanks both of you

regards
Senthil

On Fri, Jul 16, 2010 at 4:48 PM, <Rin...@cs...> wrote:

>  Senthil,
>
> The query you see in the logs for complex features are not passed on to the
> database directly.
> It gets translated (and coordinates reprojected) before it gets passed on
> to the database.
> Therefore, we can't tell what coordinates were queried from the logs.
> Perhaps if you can send me your MappedFeature mapping/configuration file I
> can help identify the problem.
>
> Cheers
> Rini
> ------------------------------
> *From:* Senthil [mailto:sen...@gm...]
> *Sent:* Friday, 16 July 2010 3:49 AM
>
> *To:* Angreani, Rini (CESRE, Kensington)
> *Cc:* Caradoc-Davies, Ben (CESRE, Kensington);
> geo...@li...
>
> *Subject:* Re: Projection with BBox for complex feature
>
> 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 featurequery
>>  form, and not passed on to the database in that form.
>>
>> Cheers
>> Rini
>>
>>  ------------------------------
>> *From:* Senthil [mailto:sen...@gm...]
>> *Sent:* Friday, 9 July 2010 6:20 PM
>> *To:* Angreani, Rini (CESRE, Kensington); Caradoc-Davies, Ben (CESRE,
>> Kensington); 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...> 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 ]
>>>
>>
>>
>