Is the curves support issue only w.r.to the Oracle data store or is it
across all data store formats?
What is the workaround suggested in general in GeoServer?
-Praveen
Message: 2
Date: Wed, 27 Nov 2013 09:45:11 +0000
From: Rahkonen Jukka <jukka.rahkonen@anonymised.com>
Subject: Re: [Geoserver-users] Fwd: Missing line segments from Oracle
data
To: "'geoserver-users@lists.sourceforge.net'"
<geoserver-users@lists.sourceforge.net>
Message-ID:
<84446DEF76453C439E9E97E438E13A631F0A0AAB@anonymised.com>
Content-Type: text/plain; charset="us-ascii"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,
PraveenOn Wed, Nov 27, 2013 at 6:41 PM, Rahkonen Jukka <jukka.rahkonen@anonymised.com
<mailto: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-------------- next part --------------
An HTML attachment was scrubbed...------------------------------