| Re: [udig-users] Detecting geometry type of Oracle views |
|
Frank,
sorry, you are right, I was a bit irritated by the layer symbol. The resulting geometry type is indeed “geometry” for the views and “polygon” for the original tables. Following the link in your answer, I set up a geometry metadata table and inserted the values for the views and it worked like a charm.
Thanks for your help, Hendrik
Von: frank.gasdorf@xxxxxxxxx [mailto:frank.gasdorf@xxxxxxxxx]
Im Auftrag von Frank Gasdorf
Hendrik, can you confirm that the Geometry Type for the resulting Layer is "Polygon". I'm wondering because Oracle JDBC datastore tries to read the type from Oracle Metadata and I guess nothing can be found for views. If this is the case the generic type "Geometry" is used for Geometry-Mapping (See here : https://github.com/geotools/geotools/blob/master/modules/plugin/jdbc/jdbc-oracle/src/main/java/org/geotools/data/oracle/OracleDialect.java#L211).
Not sure about the generator for default styling in uDIG if the type is Geoemtry. Maybe it guesses and uses LineStings as Default.. @Jody: could you jump in ?
HTH, - Frank
2013/9/4 Peilke, Hendrik <hendrik.peilke@xxxxxxxxx> Hi,
when I added a database view from an Oracle Spatial database as a layer to my map in uDig 1.4, I discovered that the geometry type of that layer wasn’t determined correctly (line instead of polygon). Adding the underlying table directly as a layer to the map gives the right layer type (polygon). This is not a single case scenario, but happened to me every time I tried to add a polygon view. Can I configure something inside the database to let uDig know the type of the view layer?
Regards, Hendrik Peilke
IBYKUS AG für Informationstechnologie, Erfurt / HRB 108616 - D-Jena / Vorstand: Helmut C. Henkel, Dr. Lutz Richter
IBYKUS AG für Informationstechnologie, Erfurt / HRB 108616 - D-Jena / Vorstand: Helmut C. Henkel, Dr. Lutz Richter Vorsitzender des Aufsichtsrates: Dr. Wolfgang Habel |