[Geoserver-devel] Oracle Bounding Box

Dirk_Wilhelm1 · October 12, 2004, 4:21am

Hello,

i'm trying to get geoserver to work with my oracle spatial layers.
Creating a store works fine. But when i try to create a new featuretype i
get some problems:

1. hitting the generate bbox button results in a bbox of

min long 0.0, min lat 0.0
max long -1.0, max lat -1.0

The bbox in my user_sdo_geom_metadata for the layer is 60000 to 100000 in
both dimensions.

2. When i tried to edit my newly created, submitted, apllied and saved
featuretype, i noticed that the bbox changed to

min long -1.0, min lat -1.0
max long 0.0, min lat 0.0

I tried all these bboxes in my GetMap request, but the result is always an
empty png.

Trying to get it as svg results in an internal server error:

java.lang.IllegalStateException: getOutputStream() has already been called
for this response
at
org.apache.coyote.tomcat4.CoyoteResponse.getWriter(CoyoteResponse.java:614)
at
org.apache.coyote.tomcat4.CoyoteResponseFacade.getWriter(CoyoteResponseFacad
e.java:173)
at
org.vfny.geoserver.servlets.AbstractService.send(AbstractService.java:606)
at
org.vfny.geoserver.servlets.AbstractService.sendError(AbstractService.java:6
62)
at
org.vfny.geoserver.servlets.AbstractService.sendError(AbstractService.java:6
46)
at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:4
34)
at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:235)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doResponse(WmsDispatcher.java:
137)
at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doGet(WmsDispatcher.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

What am I doing wrong?

Thanks for help,
Dirk

Chris_Holmes1 · October 12, 2004, 6:59am

I think xalan may be included in java 1.4. With 1.5 rc's the lack of
xalan would be a point of failure for geoserver. But they may have
included it in the real release.

I know in postgis it's sort of needed if you're doing wkb, since the wkb4j
jar uses it. I forget if the consequences are really bad, like not
working, but they were bad enough that I put the dependency in. It should
be tested.

Hmmm... That sounds like the geometry isn't being recognized. The best
thing to do to figure out the real bounding box is to use the WFS, which
will return what the features actually are, with all their attributes, as
well as a better bounds . at the top of the response it will have a
'boundedBy' section. Though I'm pretty sure it works the same way as
generate. But it will show you what the geometries that are actually
contained in the table you specified.

Also for the svg response could you check the logs? Since the error is
occurring during writing the real exception isn't getting thrown properly.

Chris

On Tue, 12 Oct 2004, Dirk Wilhelm wrote:

Hello,

i'm trying to get geoserver to work with my oracle spatial layers.
Creating a store works fine. But when i try to create a new featuretype i
get some problems:

1. hitting the generate bbox button results in a bbox of

min long 0.0, min lat 0.0
max long -1.0, max lat -1.0

The bbox in my user_sdo_geom_metadata for the layer is 60000 to 100000 in
both dimensions.

2. When i tried to edit my newly created, submitted, apllied and saved
featuretype, i noticed that the bbox changed to

min long -1.0, min lat -1.0
max long 0.0, min lat 0.0

I tried all these bboxes in my GetMap request, but the result is always an
empty png.

Trying to get it as svg results in an internal server error:

java.lang.IllegalStateException: getOutputStream() has already been called
for this response
at
org.apache.coyote.tomcat4.CoyoteResponse.getWriter(CoyoteResponse.java:614)
at
org.apache.coyote.tomcat4.CoyoteResponseFacade.getWriter(CoyoteResponseFacad
e.java:173)
at
org.vfny.geoserver.servlets.AbstractService.send(AbstractService.java:606)
at
org.vfny.geoserver.servlets.AbstractService.sendError(AbstractService.java:6
62)
at
org.vfny.geoserver.servlets.AbstractService.sendError(AbstractService.java:6
46)
at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:4
34)
at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:235)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doResponse(WmsDispatcher.java:
137)
at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doGet(WmsDispatcher.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

What am I doing wrong?

Thanks for help,
Dirk

-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--

Chris_Holmes1 · October 12, 2004, 7:22am

Please ignore the first two paragraphs, that was a copy and paste error,
messages meant for other lists. I'm not really schizophrenic.

Chris

On Tue, 12 Oct 2004, Chris Holmes wrote:

I think xalan may be included in java 1.4. With 1.5 rc's the lack of
xalan would be a point of failure for geoserver. But they may have
included it in the real release.

I know in postgis it's sort of needed if you're doing wkb, since the wkb4j
jar uses it. I forget if the consequences are really bad, like not
working, but they were bad enough that I put the dependency in. It should
be tested.

Hmmm... That sounds like the geometry isn't being recognized. The best
thing to do to figure out the real bounding box is to use the WFS, which
will return what the features actually are, with all their attributes, as
well as a better bounds . at the top of the response it will have a
'boundedBy' section. Though I'm pretty sure it works the same way as
generate. But it will show you what the geometries that are actually
contained in the table you specified.

Also for the svg response could you check the logs? Since the error is
occurring during writing the real exception isn't getting thrown properly.

Chris

On Tue, 12 Oct 2004, Dirk Wilhelm wrote:

> Hello,
>
> i'm trying to get geoserver to work with my oracle spatial layers.
> Creating a store works fine. But when i try to create a new featuretype i
> get some problems:
>
> 1. hitting the generate bbox button results in a bbox of
>
> min long 0.0, min lat 0.0
> max long -1.0, max lat -1.0
>
> The bbox in my user_sdo_geom_metadata for the layer is 60000 to 100000 in
> both dimensions.
>
>
> 2. When i tried to edit my newly created, submitted, apllied and saved
> featuretype, i noticed that the bbox changed to
>
> min long -1.0, min lat -1.0
> max long 0.0, min lat 0.0
>
> I tried all these bboxes in my GetMap request, but the result is always an
> empty png.
>
> Trying to get it as svg results in an internal server error:
>
> java.lang.IllegalStateException: getOutputStream() has already been called
> for this response
> at
> org.apache.coyote.tomcat4.CoyoteResponse.getWriter(CoyoteResponse.java:614)
> at
> org.apache.coyote.tomcat4.CoyoteResponseFacade.getWriter(CoyoteResponseFacad
> e.java:173)
> at
> org.vfny.geoserver.servlets.AbstractService.send(AbstractService.java:606)
> at
> org.vfny.geoserver.servlets.AbstractService.sendError(AbstractService.java:6
> 62)
> at
> org.vfny.geoserver.servlets.AbstractService.sendError(AbstractService.java:6
> 46)
> at
> org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:4
> 34)
> at
> org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:235)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.vfny.geoserver.servlets.wms.WmsDispatcher.doResponse(WmsDispatcher.java:
> 137)
> at
> org.vfny.geoserver.servlets.wms.WmsDispatcher.doGet(WmsDispatcher.java:106)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
> FilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> va:256)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>
>
> What am I doing wrong?
>
> Thanks for help,
> Dirk
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
> Use IT products in your business? Tell us what you think of them. Give us
> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
> http://productguide.itmanagersjournal.com/guidepromo.tmpl
> _______________________________________________
> Geoserver-devel mailing list
> Geoserver-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>

--

Dirk_Wilhelm1 · October 12, 2004, 7:55am

Hmmm... That sounds like the geometry isn't being recognized.
The best
thing to do to figure out the real bounding box is to use the
WFS, which
will return what the features actually are, with all their
attributes, as
well as a better bounds . at the top of the response it will have a
'boundedBy' section. Though I'm pretty sure it works the same way as
generate. But it will show you what the geometries that are actually
contained in the table you specified.

I tryed that. The WFS Request returns a bbox of 0,0 -1,-1

Chris_Holmes1 · October 12, 2004, 2:09pm

On Tue, 12 Oct 2004, Dirk Wilhelm wrote:

> Hmmm... That sounds like the geometry isn't being recognized.
> The best
> thing to do to figure out the real bounding box is to use the
> WFS, which
> will return what the features actually are, with all their
> attributes, as
> well as a better bounds . at the top of the response it will have a
> 'boundedBy' section. Though I'm pretty sure it works the same way as
> generate. But it will show you what the geometries that are actually
> contained in the table you specified.

I tryed that. The WFS Request returns a bbox of 0,0 -1,-1

Yeah, but do the features returned have geometries that are valid? That's
more my question. And is ALL_SDO_GEOM_METADATA also the same for the
layer? That's what we are using now, perhaps it is picking up the same
name from another user? (if so we should probably switch back to user).

Chris

-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--

Dirk_Wilhelm1 · October 19, 2004, 3:08am

> I tryed that. The WFS Request returns a bbox of 0,0 -1,-1

Yeah, but do the features returned have geometries that are
valid? That's
more my question. And is ALL_SDO_GEOM_METADATA also the same for the
layer? That's what we are using now, perhaps it is picking
up the same
name from another user? (if so we should probably switch
back to user).

USER_SDO_GEOM_METADATA is just a view on the ALL_SDO_GEOM_METADATA, so the
information is the same.

I did a little more testing with some polygons, with and without holes. At
first oracle told me that they are not valid because they weren't oriented
correct (clockwise and counterclockwise), so i changed that.

These are the polygons i used in my test:

Rectangle without hole:

SDO_GEOMETRY(2003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1),
SDO_ORDINATE_ARRAY(
72282,8016, 77532,2921,
72282,8016, 77350,8979,
72432,4261, 77350,8979,
72432,4261, 77532,2921,
72282,8016, 77532,2921))

Polygon with hole:

SDO_GEOMETRY(2003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1, 19, 2003, 1),
SDO_ORDINATE_ARRAY(
72222,2585, 77563,973,
72220,682, 77455,1392,
72225,294, 77188,0393,
72304,6044, 77200,6587,
72462,2326, 77223,0987,
72457,437, 77341,0332,
72465,866, 77369,4472,
72475,074, 77561,7889,
72222,2585, 77563,973,
72256,4206, 77418,301, <- hole starts here
72382,2364, 77418,0947,
72388,8194, 77370,6901,
72389,0094, 77279,9123,
72259,9317, 77284,728,
72256,4206, 77418,301))

A feturetype with only the rectangle in the table works correct, the
bounding box generate button will generate the correct bbox. Everything
works fine.

When i added the polygon with the hole to my table, the bbox button will
generate a bbox of 0,0 -1,-1.

So i think that there is a problem with the interpretation of polygons with
holes.
I looked at the geotools issues tracker and there is an entry that polygons
with holes lead to an exception. I tried the 2.1.x nighly build of Oct. 19.
but it didn't help, the error is still the same.

cu,
Dirk