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:
-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
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:
-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
On Wed, Nov 27, 2013 at 10:28 AM, Praveen Rajendra Babu <
praveen.rajendrababu@anonymised.com> wrote:
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.
Ah, curves, as in arcs or circles, beizers and the like? Yes, GeoServer
does not support them yet, it only handles lines made of straight segments.
Cheers
Andrea
--
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------