New answers tagged oracle-spatial
Esri has no control over Oracle licensing policy, they just allow you to use the SDO_GEOMETRY datatype, as provided by Oracle. Some of the SDO accessor functions require more than just Locator. Your determination of what is sufficient should really be based on what SQL manipulation you require, since Esri doesn't use more than SDO_FILTER.
You mean you have a table that contains a mix of polygons (SDO_GTYPE 2003) and multi-polygons (SDO_GTYPE 2007) and your application cannot handle that mix, i.e. it requires the input to be all SDO_GTYPE 2007 ? Like Vince said, you need to fix your application. I see no reason for such a requirement. Otherwise, you can actually force the SDO_TYPE of the ...
Your only solution is to fix the application, unless corrupting the single-part geometries by adding tiny holes with tinier islands or adding an out-of-bounds part to all geometries holds allure.
This query will fail with ann error like this: ORA-29902: error in executing ODCIIndexStart() routine ORA-13207: incorrect use of the [SDO_ANYINTERACT] operator You need to write "= 'TRUE' " instead of " = 'True' " (notice the capitals). Apart from that, the query is also incorrectly written: since you lookup table A using a window from table B, then you ...
There is an option in FME Safe soft "Area on area overlayer transformer"
Your problem description is not clear. Also one thing you did not say, but appears in your code is that both TABLE_1 and TABLE_2 also share a CLIENT_ID attribute. Looks like you want to find geometries from table 2 that match the geometry of one particular store from table 1, having the same client id. If that is not what you expect, then explain your ...
That simply means that the view is based on a table that does not have any spatial index defined. Without a spatial index, no spatial queries are possible, including the simple FILTER queries used for panning and zooming. To do that you will first need to setup the proper "metadata" with bound, tolerance, SRID, ... then create the spatial index on the ...
You can disable the spatial filtering (which is what requires the spatial index) by using (See the USING NONE at the end of the query) DATA "the_geom from (SELECT SDO_GEOM.SDO_CENTROID(geometrie, 2) AS the_geom, id FROM ereignis) USING SRID 31468 NONE" This means that MapServer will query everything without applying a BBox filter. If you do want to use a ...
I'm almost certain Oracle didn't update the docs for 12c. I'm going to list out a few things that I got hung up on. For a pluggable database, you provide the name as the service name with the -sn switch. The docs has ojdbc5.jar in the class path. I didn't have this file in 12c, but I did have a ojdbc7.jar and that works. As for the actual issue that I ...
Top 50 recent answers are included