Hi,
Have a look at SDO_ELEM_INFO of the dropped lines. I guess that the features are some sort of curves or compound line strings http://docs.oracle.com/cd/B19306_01/appdev.102/b14255/sdo_objrelschema.htm. I fear Geoserver does not support those.
-Jukka Rahkonen-
···
Praveen Rajendra Babu
Hi Jukka,
Thanks for the detailed response. I will look into your suggestions, esp. tracking down the SQL queries. I was trying to find out is there any sort of limitation of geoserver in rendering some sort of curved lines represented as SDO_GEOMETRY 2002(lines), which is what I could see missing.
Regards,
Praveen
On Wed, Nov 27, 2013 at 6:41 PM, Rahkonen Jukka <jukka.rahkonen@anonymised.com> wrote:
Hi,
It is impossible to say what happens by this information. I would begin by capturing the SQL select that is used for reading data from Oracle and studying that. You should be able to find it from Geoserver logs if you set the logging level to “geotools developer”. Or then the Oracle admin can gather and send log data for you. When you have the SQL in your hands, send it with SQL developer, SQL Plus or whatever tools you are using and check if all the linestrings get selected. If yes, you can consider that the data side is OK. If some lines are not selected, select the geometries by a handwritten SQL and try to find what is special in those. Check at least if the geometry type and SRID are the same as for other geometries.
If SQL selects all that you want to render then there can be something in the rendering rules that makes that some features are not painted even they are selected.
There are often some oddities in real world data. I would suggest to import first some simple demo datasets into your Oracle and play first with them. Once you can render them nicely you will trust that Geoserver works and you will be generally on a much better mood for facing the possible troubles with your own data.
When importing the demo data try to keep things simple:
-
Have a primary key in a column of type NUMBER
-
Don’t forget to insert a valid row into USER_SDO_GEOM_METADATA
-
Create a spatial index
-Jukka Rahkonen-
Praveen Rajendra Babu wrote:
Hi,
Absolutely new to GeoServer, but finding it very interesting by comparing to other map servers.
I am trying to serve line geometry from Oracle database. Some lines are rendered and some don’t.
Attaching a screen-shot of how it looks. What is the reason for this happening with GeoServer?
The SDO_GEOMETRY type is 2002 for both the rendered and unrendered lines.
Trying to use any other map servers (like MapGuide) the rendering is fine.
Appreciate some suggestions to try out.
Warm Regards,
Praveen