Oracle GEOM Line Questions

Is it possible to get the distance of a GEOM LINE ? How?Futhermore how I can get the first GEO Coordinate out from a GEOM Line?With following I get all entries:select * from table(select a.geom.sdo_ordinates from aut_Streets a where link_id = 55868112 ) best ...

Oracle ORA-06553: PLS-907: cannot load library unit MDSYS.SDO-3GL

I used MapBuilder to create styles, themes and basemaps. When the first time I preview the basemap, it is ok.Then I zoom in the preview map, I got the following errors:ERROR [oracle.sdovis.theme.pgtp] *** Exception while querying theme: TOLL_HWYERROR [oracle.sdovis.theme.pgtp] java.sql.SQLException: ...

Oracle Can mdsys.sdo_relate return FALSE?

I have the following query:SELECT MIN (dtczas) dtczasFROM sd_car_locationWHERE dyza_id = 2AND dtczas > '24-JUN-2002 11:06:48'AND mdsys.sdo_relate(geom,MDSYS.SDO_GEOMETRY( 2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3),MDSYS.SDO_ORDINATE_ARRAY( 3734329.56686484, 5567865.09443332, 3735261. ...

Oracle Query with mdsys.sdo_relate problem

I have a table with time and GPS positions of cars and I have an area. I need to find every time of entering the area by car and leaving it.The first is simple:SELECT MIN (dtczas) dtczasFROM sd_car_locationWHERE car_id = pcar_id --car idAND mdsys.sdo_relate (geom,pobszar, --area'mask=ANYINTERACT que ...

Oracle SDO_GEOM package violates function pragmas

I have a PL/SQL package which contains a function in the package specificaton (shown below) yet when I compile the body of function (also shown below) I receive an error informing me that I have violated my restrict_references pragma.I know for a fact that my code within the function doesn't violate ...

Oracle SDO_GEOM.SDO_DISTANCE()

my sdo_version is showing me the latest onehi guys is there anyissue for this sdo.geom package?? i need to use SDO_GEOM.SDO_DISTANCE() function alone.. many ...

Oracle ORA-29541 class xxx could not be resolved

I still suffer from anomalies of my 11gR2 database built from scratch. I need to use Spatial, for which I've run rdbms/admin/initdbj.sqljavavm/install/initjvma.sqlrdbms/admin/catjvm.sqlmd/admin/mdprivs.sqlmd/admin/catmd.sqlSome returned errors. However, this enabled me to use data types and some fun ...

Oracle SDO_WITHIN_DISTANCE error

This query:SELECT GEOM, MAPPABLE_OBJECT_IDFROM (SELECT * FROM GIS_DBA.COAST_SIMPLE)WHERE MDSYS.SDO_WITHIN_DISTANCE(GEOM, MDSYS.SDO_GEOMETRY(1, 32776,MDSYS.SDO_POINT_TYPE(0, 0, NULL),MDSYS.SDO_ELEM_INFO_ARRAY(1, 1, 1),MDSYS.SDO_ORDINATE_ARRAY(209035.60373068153, 1248656.907688716)) ,'distance=71504.2 ...

Oracle SDO_FILTER issue?

when I use following filter to select line strings:MDSYS.SDO_FILTER(geom.link, MDSYS.SDO_GEOMETRY(2003, 8307, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(-117.6875, 34.3125, -117.625, 34.375)), 'querytype=WINDOW') = 'TRUEI got following result:SDO_GEOMETRY(2002, 8307, NULL, ...

Oracle geodetic spatial queries - sdo_relate

The following script populates a spatial table with points on a query boundary and then queries that table using the query boundary. When using a srid of 8307 not all of the points are returned using sdo_relate. If the srid is NULL then all points 'on' the query boundary are returned.In https://meta ...

Oracle How to get from individual points to convexhull?

My goal is to create a convexhull to represent a splatering of points. My plan to accomplish this, I believe, is as follows.1. Grab the lat/lon's of my points and create a Multipoint geometry type object (gtype = 2005) using code as follows:insert into table1 values((mdsys.sdo_geometry(2005,null,nul ...

Oracle Spatial LRS Function Based Index

I am trying to create a function based index on derived segments of a line in Oracle 9iI get the following message on index create.Anybody got any ideas? I suspect that functions that don't operate on the core spatial tablemay not be able to be indexed.The following error has occurred:ORA-00904: "P_ ...

Oracle creating idx dinamicaly via PL/SQL

I want to create spatail index dinamicaly:lc_sql_stmt := 'create index '||lc_index_name ||' on '||pi_table_name||'('||pi_geo_column||') indextype is mdsys.spatial_index';EXECUTE IMMEDIATE lc_sql_stmt;When executing I get:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-13249: ...

Oracle SQL failure

I have a query that runs fine in 9i but fails in 10gR2. When I run it, I get a null geometry back. If I break the two SDO functions appart, they work fine, but together they fail. Any ideas? Thanks in advance. PeterThe sql is:SELECT COUNT(*) AS FEATURE_COUNT,DECODE(COUNT(*),0,NULL,MDSYS.SDO_CS.TRANS ...

Oracle problems with SDO_WITHIN_DISTANCE

please have a look at the SQL I have written to select all the buildings that are within a specified distance from a given building(as reference object).My spatial data come from an ESRI shapefile and have been imported into Oracle 8.1.5 using shp2sdo.exe. Here is the query:select * from fabbr87 whe ...

Oracle Update sdo_elem_info

I need to update the sdo_elem_info_array in several spatial tables.I am currently using the following sql to do it:CREATE or REPLACE FUNCTIONset_elem_info(geom mdsys.sdo_geometry)RETURN mdsys.sdo_geometry ISgeom_copy mdsys.sdo_geometry := geom;BEGINgeom_copy.sdo_elem_info(1) := 1;geom_copy.sdo_elem_ ...

Oracle Convert varchar to sdo_geometry

I have a table of linestrings - all coordinates have precision, which I want to remove.I am trying to do it in PL/SQL as below, but since the new geometry with the rounded coordinates is a varchar, I keep getting the error: PL/SQL: ORA-00932: inconsistent datatypes: expected UDT got CHARHas anyone g ...

Oracle SDO_NN

SDO_NN does not always return value, it returns for some points and doesnt for others ..SELECT a.TYPE_DESC, a.OBJECT_DESC,a.geom.sdo_point.x,a.geom.sdo_point.y from CTL_ONLINE_OBJECT_LOCATION WHERE COMP_ID='1000' AND TYPE_ID='30' AND TYPE_ID='100' AND MDSYS.SDO_NN(GEOM, MDSYS.SDO_GEOMETRY(2001, 9602 ...

Oracle SDO_FILTER performance problem

I have very big performance problem and I need some help.My table BOUNDARY contains 12500 records.I made a R-TREE indexThe next query returns 137 rows and takes about 12 sec SELECT BOUNDARYID,NAME_FR,NAME_EN,GEOID,BOUNDARYTYPEID,GEOM from boundary WHERE boundarytypeid = 6 AND (MDSYS.SDO_FILTER(GEOM, ...

Oracle Mapviwer 11 EA: Error in user_sdo_cached_map.definition

I'm trying to deploy my map over the Early Adopter version of MapViewer and am getting the following error:java.sql.SQLException: ORA-13282: failure on init of co-ord transformORA-06512: at &quot:MDSYS.SDO_CS&quot: line 75There's more error messages afterwards, but that's the gist of it.I ca ...

Oracle SDO_RELATE uses only one Spatial Index

another question about Spatial index.I have a table that contains cells defined as:CREATE TYPE "GRID_2D" AS OBJECT (id INTEGER,box MDSYS.SDO_GEOMETRY -- rectangular geometry)CREATE TABLE "GRIDS_2D"("GRID" "GRID_2D"); I defined an index on that table like this:INSERT INTO user_sdo_geom_metadata(TABLE ...

Oracle Mask doubts

I've a doubt about mask in sdo_relate, i can do an ORwith spatial operator with "+", but this don't work.I've a set of points and a set of polygons, when i query the polygons that contains a specified point if i set 'mask=contains' work, but with 'mask=contains+covers' i get an empty set!!But 'mask= ...

Oracle ORA-00939 - too many arguments for function

We're getting this problem querying with largegeometries, we've something like:SELECT MY_GEOM FROM MY_SPATIAL_TABLE WHERE mdsys.sdo_relate ( GEOM,MDSYS.SDO_GEOMETRY ( 2003, null, null, MDSYS.SDO_ELEM_INFO_ARRAY (1,1003,1,941,1003,1,977,1003,1,1015,1003,1,1049,1003,1,1081,1003,1,1099,1003,1,1127,1003 ...

Oracle Spatial Query

Can anyone tell me why following sql statement returns different results.Thank you. SELECT geom, id FROM (select a.geom,b.id from sdo_rect a, store bwhere a.store_id = b.store_id)WHERE MDSYS.SDO_RELATE(geom, apoint,'mask=ANYINTERACT querytype=WINDOW') = 'TRUE' select a.geom,b.id from sdo_rect a, sto ...

Oracle Building a variable

I've a wrapper that transform GML class to MDSYS.SDO_GEOMETRY, with large geomtries i get an errorORA-00939.Mr. David Penington take me a solution:"Build a variable of type MDSYS.SDO_ORDINATE_ARRAY, or MDSYS.SDO_GEOMETRY, and pass that into your statement."Maybe this is simple for a skilled user of ...

Oracle Problem updating levels to specific themes in specific areas

I have a problem when I try to zoom-in in a specific area in map.Major parts of my map this operation is ok. But in some specifics areas, and ever during query to theme XXA_MD_BR_SERVICE_BDY_V this mapview do not update my image (zoom-in or zoom-out). I must try two, or three zoom task to aim (in th ...

Oracle How to prevent setBoundingThemes returning null MBR when no data are found

I am using setBoundingThemes method in MapViewer bean to zoom in to query results in a JDBCTheme. It is possible however that the JDBCTheme doesn't contain any data when no rows match the criteria. The result is that the other themes are queried without a filter and the overall map size is used (as ...

Oracle Locator: spatial index 'not found' (cross schema query); ORA-13226

I have a big problem with locator functions in OracleXE.The situation is:- a sdo_geom table+ view "v_geom_udb_gw_ges" created by user 'OBJEKTDB'- metadata and index are available- granted select on view "v_geom_udb_gw_ges" to user 'cardogeom'when I run a simple filter query, it takes 0.2 sec as owne ...

Oracle XE: spatial index 'not found' from other users; ORA-13226

I have a big problem with locator functions in OracleXE (based on 10.2.).The situation is:- a sdo_geom table+ view "v_geom_udb_gw_ges" created by user 'OBJEKTDB'- metadata and index are available- granted select on view "v_geom_udb_gw_ges" to user 'cardogeom'when I run a simple filter query, it take ...

Oracle Find Points In A U-shaped Polygon

I have the following query to find all the points inside a polygon:select amenid from AMEN_CEN_TXT where mdsys.sdo_relate(GEOM,(select geom from AMEN_POLY where amenid = '1'),'mask=INSIDE') = 'TRUE'/AMEN_CEN_TXT table contains text points while AMEN_POLY contains polygons.The polygon with amenid 1 i ...

Oracle Is it possible to create a spatial view with paramete?

Is it possible to create a view with parameter like following:SELECT GEOM FROM INTERSTATES WHERE MDSYS.SDO_FILTER(GEOM, MDSYS.SDO_GEOMETRY(2003, 8307, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE' so that I can specify ???? at run ti ...

Oracle Problem in importing an own image

I am new to Mapbuilder. I need to use my own images as themes in my project. when I try to import a bmp or "gif" file by choosing Tools--> Import Image Option using MapBuilder, i am getting the error message "GeoRaster spatial extent update was not successful" in Dialogbox. In the Console the fol ...

Oracle Different Explain Plan

I have a query that has a different explain plan depending on who runs it. In 9i the explain plan was the same, in 10g it differs by the user who runs it. As the owner, the indexes are used properly and it results are returned quickly. As a user that have select privs on the tables it is not the cas ...

Oracle spatial query runs slow on view

I have two tables and one of them has geometry column. I created view to join those two tables based on id column which has been indexed for both tables.t1(id number(9),name varchar2(20))t2(id number(9),geom MDSYS.SDO_GEOMETRY) CREATE VIEW v1 (id,name,geom) ASSELECT /*+ FIRST_ROWS */ t1.id, t1.name, ...

Oracle Segmentation fault in __lock_get_internal_4006 while doing ldapsearch

I am receiving a segmentation fault when doing a ldapsearch. This is more likely a problem with Berkeley DB as I had no problem with Berkeley DB version 4.5.20 and OpenLdap 2.3.38The host is running under Vmware Fusion and I tried with both 64 and 32 bit solaris kernel.-bash-3.00$ uname -aSunOS unkn ...

Oracle Strange Query Behaviour

I've got a curious effect involving some spatial data in our 11g database, and a spatial query which doesn't seem to be behaving correctly.The 15 records are all bounded by (-115.45, 35.43, -107.66, 43.06), and have the following construct:SDO_GEOMETRY(2003, 4326, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, ...

Oracle MapViewer Log - Render foi data - performance

I have the following lines in the MapViewer log - All looks ok except for (what matches up with) the time taken for "Render foi data" which has a number of 2469or about 2 and a half seconds.What occurs during the "Render foi data"?I'm hopeful that by understanding I can improve the FOI performance. ...

Oracle Topology network data model - problem with validation

I'm not an expert on Oracle Spatial and designing network and topology data model and I have a huge problem understanding how this model should really look likel. :I have a very simple database, with only two tables pipes and junctions. They both have a geometry column ('geom') of type SDO_TOPO_GEOM ...

Oracle 'ORA-13199: APP-Load:CODE=-4098' error when using SEM_APIS.BULK_LOAD...

I am trying to load a bulk of several millions triples to our Oracle11g database.I created a staging table using the following DDL:CREATE TABLE "WIZRDF"."STAGE_TABLE"( "RDF$STC_SUB" VARCHAR2(4000 BYTE) NOT NULL ENABLE,"RDF$STC_PRED" VARCHAR2(4000 BYTE) NOT NULL ENABLE,"RDF$STC_OBJ" VARCHAR2(4000 BYT ...

Oracle Forcing one particular query to be rewritten to custom SQL

MapBuilder produces Queries that look like this SELECT ROWID, GEOM, 'C.AT_1410_GW_ROAD', null, 'null', -1, 'rule#0' FROM MYTABLE WHERE MDSYS.SDO_FILTER(GEOM, MDSYS.SDO_GEOMETRY(2003, 31468, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(:mvqboxxl, :mvqboxyl, :mvqboxxh, :mvqbox ...

Oracle Error 'MDSYS.SDO_GEOM_TRIG_INS1' while reentering the record in USER_SDO_GE

I am trying to use Georaster table with Oracle map viewer. I followed the instructions to “prepare Georaster Data for use with a Georaster theme”I created the Georaster table “gri_raster_sst “and the corresponding raster data table. After that I called the triggercall sdo_geor_utl.createDMLT ...

Oracle ISSUS IN MDSYS.SDO_GEOM.SDO_DISTANCE()

SQL> SELECT * FROM LOC_ZIP;COMP ZIPCD---- LOC(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES) c1 z1SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(100, 1, NULL), NULL, NULL)c1 z2SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(200, 2, NULL), NULL, NULL) SQL> SELECT * FROM SUPP_ZIP;COMP S ...

Oracle Encountered 'ON' mask for MDSYS.SDO_GEOM.RELATE

HelloWe are using Oracle 8.1.7.2.1.I am query between 2 layers using the MDSYS.SDO_GEOM.RELATEone layer stores segments and one layer stores polygon.The mask in use was 'INSIDE+COVEREDBY', but the result wasnot as expected as some segments were left out,so used the DETERMINE keyword to find the rela ...

Oracle Bug in function mdsys.sdo_geom.sdo_intersection() ?

I got a strange result from the spatial subprogramSDO_GEOM.SDO_INTERSECTION(geom1 IN SDO_GEOMETRY,dim1 IN SDO_DIM_ARRAY,geom2 IN SDO_GEOMETRY,dim2 IN SDO_DIM_ARRAY) RETURN SDO_GEOMETRY;I’m calling the function three times, passing each time the same geom1 and geom2 parameters. What changes it the ...

Oracle cannot insert null into - "MDSYS"."SDO_GEOM_METADATA_TABLE"."SDO_OWNER"

I'm getting this error when running a simple insert statement to copy some existing spatial metadata:insert into user_sdo_geom_metadataselect 'MAPCAPTURE', 'GEOLOC',diminfo,sridfrom user_sdo_geom_metadatawhere table_name = 'ROAD_NETWORK';results in the error :cannot insert null into "MDSYS"."SDO_GEO ...

Oracle Changing a mdsys.sdo_geom to a number column on a table

I want to create a view from a series of different tables so in a web application the page goes to width of each object displayed. If i create columns on the tables of e.g SDO_AREA or SDO_MAX_MBR_ORDINATE, it is a mdsys.sdo_geom column, and i need it to be a number column for the jsp. So do i duplic ...

Oracle About insert into MDSYS.SDO_GEOM_METADATA_TABLE

I'm newbie with Oracle Spatial.I would like to know what values can I define to columns SDO_LB and SDO_UBfor the dim element for SRID 8292 when I insert into table MDSYS.SDO_GEOM_METADATA_TABLE.I found the following example:INSERT INTO MDSYS.SDO_GEOM_METADATA_TABLE ( SDO_OWNER, SDO_TABLE_NAME, SDO_C ...

Oracle couldn´t fill mdsys_sdo_geom_metadata / spatial index error

if i create a spatial index i got the known error:ERROR at line 1:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-13203: failed to read USER_SDO_GEOM_METADATA tableORA-13203: failed to read USER_SDO_GEOM_METADATA tableORA-06512: at "MDSYS.SDO_INDEX_METHOD", line 7ORA-06512: ...

Oracle Plotting a Geometry-(mdsys_sdo_geom) from Database on Map.

Can we Plot a Geometry---any geometry value stored in a database table column of type mdsys_sdo.geom onto a mapXtreme Map Object(in ASP) direcly by using any method of MapXtreme with Oracle or do we have to resort to getting all the co-ordinates of the geometry from SDO_Ordinates Varray and then Plo ...

Oracle ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 391

while doing shortest route analysis we are gettingORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 391error in mapviewer log.how to resolve this? ...