[Geoserver-users] ZoomTo / Bounding Box Question -- Oracle

List …

Before my question I need to compliment the Geoserver team on the speed improvements that has been implemented for Oracle. I am using 1.6-Beta 3 at the moment.

My question related to integration with Orcale and VE, Google Mashups:

I have mashups to VE etc working from Oracle data …
The geoserver map is using epsg:900913.
The data sources are in different projections : e.g. 4236 , 81948 etc.
The functionality that I am prototyping finds objects from the database/data sources through a non-spatial query , which when selected then zooms the map to the object’s bounding box.

The question that I have is how do I get the bounding box/envelope for a specific entity in a specified projection - in this case 900913 - to use to drive openlayers.Zoomto functionality ?

WFS’s getFeature gives the objects envelope in the source SRS …

Any suggestions will be appreciated.

Thanks


Pierre le Roux
p. 256 604.0122
e. zpleroux@anonymised.com

There may be other ways to do it, but one way would be to do a WFS 1.1 GetFeature call. It can do reprojection, so I think if you request it in 900913 then you'll get the envelope back in that projection. You can also set a param, I think it's called resultType or something, to 'hits', and that just returns the number of features that would match the call and I believe also returns the envelope. I could be wrong about some of these, but it's probably worth checking out.

Chris

Pierre le Roux wrote:

List ...
Before my question I need to compliment the Geoserver team on the speed improvements that has been implemented for Oracle. I am using 1.6-Beta 3 at the moment.
My question related to integration with Orcale and VE, Google Mashups:
I have mashups to VE etc working from Oracle data ...
The geoserver map is using epsg:900913.
The data sources are in different projections : e.g. 4236 , 81948 etc.
The functionality that I am prototyping finds objects from the database/data sources through a non-spatial query , which when selected then zooms the map to the object's bounding box.
The question that I have is how do I get the bounding box/envelope for a specific entity in a specified projection - in this case 900913 - to use to drive openlayers.Zoomto functionality ?
WFS's getFeature gives the objects envelope in the source SRS ...
Any suggestions will be appreciated.
Thanks

--
Pierre le Roux
p. 256 604.0122
e. zpleroux@anonymised.com <mailto:zpleroux@anonymised.com>
!DSPAM:4005,4703d517180881030819293!

------------------------------------------------------------------------

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/

!DSPAM:4005,4703d517180881030819293!

------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,4703d517180881030819293!

Thanks Chris …

Will give that a whirl.

Pierre

On 10/3/07, Chris Holmes <cholmes@anonymised.com> wrote:

There may be other ways to do it, but one way would be to do a WFS 1.1
GetFeature call. It can do reprojection, so I think if you request it
in 900913 then you’ll get the envelope back in that projection. You can
also set a param, I think it’s called resultType or something, to
‘hits’, and that just returns the number of features that would match
the call and I believe also returns the envelope. I could be wrong
about some of these, but it’s probably worth checking out.

Chris

Pierre le Roux wrote:

List …

Before my question I need to compliment the Geoserver team on the speed
improvements that has been implemented for Oracle. I am using 1.6-Beta 3
at the moment.

My question related to integration with Orcale and VE, Google Mashups:

I have mashups to VE etc working from Oracle data …
The geoserver map is using epsg:900913.
The data sources are in different projections : e.g. 4236 , 81948 etc.
The functionality that I am prototyping finds objects from the
database/data sources through a non-spatial query , which when selected
then zooms the map to the object’s bounding box.

The question that I have is how do I get the bounding box/envelope for a
specific entity in a specified projection - in this case 900913 - to use
to drive openlayers.Zoomto functionality ?

WFS’s getFeature gives the objects envelope in the source SRS …

Any suggestions will be appreciated.

Thanks


Pierre le Roux
p. 256 604.0122
e. zpleroux@anonymised.com mailto:[zpleroux@anonymised.com](mailto:zpleroux@anonymised.com)
!DSPAM:4005,4703d517180881030819293!



This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/

!DSPAM:4005,4703d517180881030819293!



Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,4703d517180881030819293!


Pierre le Roux
p. 256 604.0122
e. zpleroux@anonymised.com

Chris …

Seems like your suggestion did the trick !

This is the request:
http://localhost:8080/geoserver/wfs?request=GetFeature&version=1.1.0&typename=topp:states&maxFeatures=1&SRSNAME=EPSG:900913

Thanks

Pierre

On 10/3/07, Pierre le Roux <zpleroux@anonymised.com> wrote:

Thanks Chris …

Will give that a whirl.

Pierre

On 10/3/07, Chris Holmes <cholmes@anonymised.com > wrote:

There may be other ways to do it, but one way would be to do a WFS 1.1
GetFeature call. It can do reprojection, so I think if you request it
in 900913 then you’ll get the envelope back in that projection. You can
also set a param, I think it’s called resultType or something, to
‘hits’, and that just returns the number of features that would match
the call and I believe also returns the envelope. I could be wrong
about some of these, but it’s probably worth checking out.

Chris

Pierre le Roux wrote:

List …

Before my question I need to compliment the Geoserver team on the speed
improvements that has been implemented for Oracle. I am using 1.6-Beta 3
at the moment.

My question related to integration with Orcale and VE, Google Mashups:

I have mashups to VE etc working from Oracle data …
The geoserver map is using epsg:900913.
The data sources are in different projections : e.g. 4236 , 81948 etc.
The functionality that I am prototyping finds objects from the
database/data sources through a non-spatial query , which when selected
then zooms the map to the object’s bounding box.

The question that I have is how do I get the bounding box/envelope for a
specific entity in a specified projection - in this case 900913 - to use
to drive openlayers.Zoomto functionality ?

WFS’s getFeature gives the objects envelope in the source SRS …

Any suggestions will be appreciated.

Thanks


Pierre le Roux
p. 256 604.0122
e. zpleroux@anonymised.com <mailto: zpleroux@anonymised.com>
!DSPAM:4005,4703d517180881030819293!



This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/

!DSPAM:4005,4703d517180881030819293!



Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,4703d517180881030819293!


Pierre le Roux
p. 256 604.0122
e. zpleroux@anonymised.com


Pierre le Roux
p. 256 604.0122
e. zpleroux@anonymised.com

Chris Holmes ha scritto:

There may be other ways to do it, but one way would be to do a WFS 1.1 GetFeature call. It can do reprojection, so I think if you request it in 900913 then you'll get the envelope back in that projection. You can also set a param, I think it's called resultType or something, to 'hits', and that just returns the number of features that would match the call and I believe also returns the envelope. I could be wrong about some of these, but it's probably worth checking out.

Wow, this is some neat out of the box thinking.
Anyways, may I chime in and observer this would be an easy job for a
RESTful WPS service to implement? :slight_smile:
Cheers
Andrea