Re: [Qgis-user] Detecting Geometry Type For Oracle Object

2017-01-31 Thread Jürgen E . Fischer
Hi Simon, On Tue, 31. Jan 2017 at 16:13:47 -0700, Simon Greener wrote: > How does one request this rownum<1000 number to be changed or implemented as > a option? 2.18 doesn't do that anymore with UseEstimatedMetadata and a requested geometry type. It also has some other improvements on detection

Re: [Qgis-user] Detecting Geometry Type For Oracle Object

2017-01-31 Thread Simon Greener
Jurgen, Thanks again. How does one request this rownum<1000 number to be changed or implemented as a option? After all all the sdo_geometry types I deal with with customers are homogeneous based on polygon, line or point with multi... (Oracle users equate multipolygon with polygons and store them

Re: [Qgis-user] Detecting Geometry Type For Oracle Object

2017-01-31 Thread Jürgen E . Fischer
Hi Simon, On Sun, 29. Jan 2017 at 22:42:22 -0700, Simon Greener wrote: > QGIS, when querying Oracle to determine the geometry type in a table's > sdo_geometry column executes the following SQL: > > SELECT DISTINCT gtype FROM (SELECT t."GEOMETRY".sdo_gtype AS gtype FROM > ""."" t WHERE t."GEOMETRY