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.rahko...@mmmtike.fi<mailto:jukka.rahko...@mmmtike.fi>> 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
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
