Oracle ORA-13282 for user defined coordinate system in 10.2.0.2

In 10.2.0.1 we created a user defined coordinate system which is similar to the predefined coordinate system 31294 with different false easting and false northing.The database was created by the Database Configuration Assistant as"Custom Database".The script for inserting the new CS_SRS and paramete ...

Oracle Help - Error -13282: ORA-13282:

Error -13282: ORA-13282: failure on initialization of coordinate transformationGetting this error when trying to Insert some spatial data. Totally new to spatial data processing. Had to look at this after the original developer quit the company.Here is the Insert statmentINSERT INTO table1 VALUES(se ...

Oracle The dreaded ORA-13282 error

I have a custom coordinate system created in 10g that otherwise seems to work fine (SRID=9000001). When I try this simple conversion:SELECT sdo_cs.transform(sdo_geometry(2001,8192,sdo_point_type(13.6,52.4,null),null,null),9000001)from dual;I am getting:ORA-13282: failure on initialization of coordin ...

Oracle ora-13282: failure on initialization of coordinate transformation

I am getting this error when the following query executes after the application has been running for an extended period of time:select station_id, mdsys.sdo_geom.sdo_length(mdsys.sdo_cs.transform(mdsys.sdo_geometry(2002, 8307, null,mdsys.sdo_elem_info_array(1,2,1),mdsys.sdo_ordinate_array(-104.65000 ...

Oracle ORA-13282: failure on initialization of coordinate transformation

I try to create an index with type spatial_index and get this errormessage:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-13282: failure on initialization of coordinate transformationORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10ORA-06512: at line 1The WKTEXT ist this ...

Oracle Another ORA-13282 error on user defined coordinate system

I have a created 2 custom coordinate systems in 10g. They are the same except #1 is defined with Meter units and #2 is defined with Millimeter units. To create #1 I had to:Insert some SDO_COORD_OP_PARAM_VALS recordsInsert a SDO_COORD_OPS recordInsert a SDO_COORD_REF_SYSTEM recordTo create #2 I had t ...

Oracle ORA-13282 on creating spatial index

HelloI want to create a Spatial Index on a GeoRaster Table.First i updated the USER_GEOM_METADATA table:Insert Into MDSYS.USER_SDO_GEOM_METADATAValues ('LGVHH05', 'GEORASTER.SPATIALEXTENT', SDO_DIM_ARRAY(SDO_DIM_ELEMENT('Rechtswert',3500000,3600000,1),SDO_DIM_ELEMENT('Hochwert',5900000,6000000,1) ) ...

Oracle Spatial Help - Error -13282: ORA-13282:

Error -13282: ORA-13282: failure on initialization of coordinate transformationGetting this error when trying to Insert some spatial data. Totally new to spatial data processing. Had to look at this after the original developer quit the company.Here is the Insert statmentINSERT INTO table1 VALUES(se ...

Oracle What is the difference between SRID 25832 and 83032?

My company will soon have Danish geodetic data delivered in the following coordinate system according to the provider, who works with MapInfo."UTM zone32 North EUREF89"From the information I have been able to dig up, EUREF89 is just another name for ETRS89, so when searching in CS_SRS for the right ...

Oracle ORA-13487: SRID not found for source coordinate system metadata

When executing the following DECLAREg SDO_GEORASTER;BEGINSELECT raster INTO g FROM CADRE_AWIFS_GEORASTERS WHERE row_id = 3 FOR UPDATE;SDO_GEOR.IMPORTFROM(g, 'SRID=8307','GEOTIFF','FILE','/Oracle2/usr/local/src/cadre/raster_import_orcl/BAND2.TIF' );UPDATE CADRE_AWIFS_GEORASTERS SET raster = gWHERE ro ...

Oracle Error running sdo_geom.sdo_area on polys with user-def SRID

I have encountered the following error message when I execute SDO_GEOM.SDO_AREA function :SQL> select sdo_geom.sdo_area(l.geom,0.00001) from tile_boundaries l;select sdo_geom.sdo_area(l.geom,0.00001) from tile_boundaries l*ERROR at line 1:ORA-13282: failure on initialization of coordinate transfo ...

Oracle SDO_GEOM.SDO_AREA error on polygon with user-defined SRID

we have encountered the following error message when we execute SDO_GEOM.SDO_AREA function:select sdo_geom.sdo_area(geometry,0.005) from gis_parcels where pid=4037022;select sdo_geom.sdo_area(geometry,0.005) from gis_parcels where pid=4037022;*ERROR at line 1:ORA-13282: failure on initialization of ...

Oracle Spatial Indexing with Oregon SRID's 2269 and 2913

I am attempting to create a spatial index om geometries with SRID's of either 2269 or 2913. Oracle 10G2 on my system errors out with ora-06512 and ora-13282 messages resulting in a ora-29855.Using other arbitrary coordinate SRID's such as 81948 ( whihc is nowhere near Oregon) spatially indexes OK.An ...

Oracle Where can I find a WKT for an SRID?

I want to transform a geometry from SRID 4327 (geographic 3d) to SRID 4328 (geocentric), but i get this errorError starting at line 1 in command:select sdo_cs.transform(sdo_geometry(3001, 4327, sdo_point_type(30, 50, 100), null, null), 4328) from dualError report:SQL Error: ORA-13282: Initialisierun ...

Oracle SRID Error

Any ideas why?select sdo_cs.transform(mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(-44.881922,-1.3040577,null),null,null),29101) from dual; Error starting at line 2 in command: select sdo_cs.transform(mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(-44.881922,-1.3040577,null),null,null),29101 ...

Add an SRID that Oracle does not have?

I am trying to import a 3D image file with SRID: 3401 however my Oracle Spatial db (11.1) does not have it. (ORA-13249: SRID 3401 does not exist in MDSYS.CS_SRS table).This is the SRID information: http://spatialreference.org/ref/epsg/3401/Is there a way to add this SRID and if so, could you offer a ...

Oracle failure on initialization of coordinate transformation

I am trying to define a "custom" projection for our local coordinate system. The local coordinate system is a shifted and rotated state plane. To begin, I inserted a row in the mdsys.cs_srs that uses the WKTEXT field from the record for State Plance SC-south, 3902 (SRID=41133). I then "added", after ...

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_cs.transform() issue on 10.2.1.0?

When we were on 10.1.0.2.0, we had a custom CS_SRS and were able to transform lat/long's to this custom SRS (Equal Area Conic). Now that we've upgraded to 10.2.1.0, we now get an ORA-13282 doing (basically) the same thing.I say 'basically' because we now use Oracle Spatial's built-in SRS (3005), as ...

Oracle Defining new CS SRS

I'm using 10.2 and I need to create a new equal area projection so I can load my grid data correctly (NLCD1992 grid). The new project is an Albers Conical equal area very similar to SRID 32775 but using NAD 83, not NAD 27. So I've tried many varieties of defining the new system by inserting a new re ...

Oracle import shapefile from Map Builder got errors

I imported shapefile from Map Builder.At the first time, I use 8307 as SRID (I don't what the value excatly is, so I pick 8307). Everything is fine.Now, I have a SRID value of 62696405 ( NAD83(deg) ). We need to test this value is correct or not. so I imported shapefile with this value.I got the fol ...

Oracle Lambert Conformal Conic CRS

I am trying to create a custom CRS for this WKT(from ESRI .prj file):PROJCS["WGS_1984_Lambert_Conformal_Conic",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAM ...

Oracle How to define Coordinate System

We are using Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prodand we load data from a GIS system using diffent Projected Coordinate system, We have some data in:Lambert Azimuthal Equal Area (based on gographic Coordinate System WGS84 ) with parameter: Latitude of natural Origin 0 , Lo ...

Oracle Custom Coordinate Reference System in 10gR2 Trouble

We are trying to migrate from Oracle 9i on a Sun box to Oracle 10gR2 on a Linux box.I am having trouble implementing a user-defined CRS in 10g.I followed the procedure described in ORACLE document NOTE:395171.1 "Example Adding A New Coordinate System in the 10.2 Release".Unfortunately the results we ...

Oracle SDO_CS.VALIDATE_WKT returns FALSE(-1)

When trying to transform a point from SRID 2868 to 4326, I get the following error:ORA-13282: failure on initialization of coordinate transformationORA-06512: at "MDSYS.SDO_CS", line 75ORA-06512: at "MDSYS.SDO_CS", line 112ORA-06512: at "MDSYS.SDO_CS", line 2678So I do SDO_CS.VALIDATE_WKT(2868) and ...

Oracle Error when creating spatial index in 10g

I have a problen when I try to create a spatial index. The strange thing is that the same commands always works fine in some machines, but if always fails in others. I tryed in diferent versiones of Oracle, but I have the error in al of them. The versions I have tryed are:- 10.2.0.1- 10.2.0.4The ope ...

Oracle coordinate transformation & accuracy

HelloI'm doing some tests on the use of the cs_transform functionality in SPATIAL 9.2.Specifically for the SRS from Belgium.The quality of these transformations are very poor.Since the parameters stored in Oracle spatial are incorrect for the Belgium systems (both Datum and Projection Parameters suc ...

Oracle Error creating spatial index

ORA-29855: si è verificato un errore durante l'esecuzione della routine ODCIINDEXCREATEORA-13249: internal error in Spatial index: [mdidxrbd]ORA-13249: Error in Spatial index: index build failedORA-13249: Error in spatial index: [mdrcrtxfergm]ORA-13249: Error in spatial index: [mdpridxtxfergm]ORA ...

Oracle failure on initialization of coordinate transformation

I'm using the latest version of Autodesk Mapguide to make a request to a 10g database.The SQL called is:SELECT MI_PRINX, GEOLOC, NAME FROM TABLE1 WHERE (MDSYS.SDO_FILTER(TABLE1.GEOLOC,SDO_CS.VIEWPORT_TRANSFORM(MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_A ...

Oracle problem with spatial index creation

We have setup an Oracle 10gR2 RAC environment on Solaris SunOS 5.8, two nodes in the cluster. We used the data pump to move tables from our 9i (9.2.0.5) database to 10gR2.The spatial indexes appear to be valid, at least they are listed as valid when looking at the tables with OEM. Using the Spatial ...

Oracle failure on initialization of coordinate transformation

when I call mapview.print() or mapview.addScaleBar() methods I get the following error, could any body advise?thanks06/06/02 14:55:56 Fri Jun 02 14:55:56 IDT 2006 ERROR oracle.lbs.mapserver.core.InfoWorker] java.sql.SQLException: ORA-13282: failure on initialization of coordinate transformationORA-0 ...

Oracle SOS, new projected Coordinate System

I try to create a new Coordinate System, the idea is transform UTM coordinates to Conic Lambert. This is the cs_srs: INSERT INTO mdsys.cs_srs VALUES ('Lambert Conformal Conic',1082378, 1082378, 'Oracle','PROJCS["Lambert Conformal Conic",GEOGCS ["NAD 83",DATUM ["NAD 83",SPHEROID ["Clarke 1866",637820 ...

Oracle SDO_RELATE

all i wanna do is to intersect a specific feature with another table and get the id that intersects with the other table.i have tried to use SDO_RELATE as a start but it gives the following errorselect SDO_RELATE(p.geometry,f.geometry ,'OVERLAPBDYINTERSECT') from pump p, farms f where p.id=1;ERROR a ...

Oracle Error in executing ODCIIndexStart() routine

Any help with next errors will be apreciate:ORA-29902: error in executing ODCIIndexStart() routineORA-13282: failure on initialization of coordinate transformationORA-06512: at"MDSYS.SDO_INDEX_METHOD_9I", line 368They are generated by a PL/SQL prodecure using SDO_RELATE in where clause.I have Oracle ...

Oracle SDO_RELATE to return rows where point is in polygon

Is it possible to return rows from a table where an input point geometry falls within the polygon sdo_geometry column stored in the row? I don't just want to return the geometry, but all columns in the row where the geometry "intersects".I'm trying this, but run into an error:SELECT * FROM COUNTY_PA ...

Oracle Ora 2309 - atomic NULL violation on SRID update

I'm trying to update an SRID value for a layer using:Update COUNTRY c set c.SHAPE.SDO_SRID = 8307;I get the following error :Error: ORA 2309Text: atomic NULL violation The value of SRID is NULL. Why this doesn't work for COUNTRY ? (and works for another table!) ...

Oracle Transform from SRID 2314 to SRID 4326 gives ORA-03113

When I perform the following query:SELECT SDO_CS.TRANSFORM(SDO_GEOMETRY(2001, 2314, SDO_POINT_TYPE(79, 37, NULL), NULL, NULL), 4326) FROM DUALI get an ORA-03113: end-of-file on communication channel I couldn't find what's wrong with SRID 2314 or any of it's transforms.Guess this is a bug? And the fo ...

Oracle ORA-13365: layer SRID does not match geometry SRID

When i am trying to create index on a spatial column it gives me the following error.ORA-13365: layer SRID does not match geometry SRID?how can i overcome this issue? Any help will be highly appretiated.Lee ...

Oracle ORA-13365: Layer SRID does not match geometry SRID

Have used FME to load shapefile to 9.0.1 object model, designating a common CS for destination. FME creates an entry in USER_SDO_GEOM_METADATA leaving SRID null, and by default leaves the SRID null in each geometry converted. When using 8.1.7 I would then update the SRID in USER_SDO_GEOM_METADATA on ...

Oracle Problem Creating Spatial Index, ORA-29835: ODCIGETINTERFACES

I'm having trouble creating a spatial index.I have a table called testtable with an integer column named ptnum (which is the primary key) and another column named pt whose type is MDSYS.SDO_GEOMETRY. I have one record in this table whose data is as follows:pt = 1ptnum = MDSYS.SDO_GEOMETRY(3001, NULL ...

Oracle ORA-13249 creating RTREE on 9.0.1.1.1 on NT

Attempting to create RTREE Spatial index as follows:create index usiwc1_sdxon usiwc (geom) indextype is mdsys.spatial_index;Receive following errors:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-13249: internal error in Spatial index: [mdidxrbd]ORA-13249: Error initializin ...

Oracle Errors ORA-29902, ORA-13357, ORA-06512 SDO_INDEX_9I ligne 232

I have a table 'SP_LINES_INDEX' with geometry column 'GEOM'in Oracle 9i spatial version 9.0.1.1, and filled it with about 1300 rows of MultilineString (all have GTYPE=3006). The geometry is defined as 3-D in millimetres (null srid). Correct entry is made in Spatial metaTable as follows:DELETE FROM U ...

Oracle Why ORA-13348: SDO_TOLERANCE wrong?

I can't understand why this polygon gets ORA-13348 validation error (polygon boundary is not closed). Note that the start and end Y values are different after 7 decimal places. I've tried adjusting SDO_TOLERANCE to a value with 5 leading zeros, both before insert and before validation. What am I mis ...

Oracle RTree index build fails with ORA-01578

I try to build RTree-Indexes on large spatial tables (between 6000000 and 26000000 records). Sometimes I get an error message ORA-01578: ORACLE data block corrupted (file # xx, block # xxxxxxx)during index creation. In most cases I can build the index after completing the following steps:drop index ...

Oracle Spatial Indexing with/without SRID (9i)

We're loading our first spatial data into 9i and trying to index a test table.The table has 3 records (a poly, a line and a point). The SRID is 8265 (NAD83).This is the error message:SQL> create index tm_rt1 on test_merge(geom)2 indextype is mdsys.spatial_index;create index tm_rt1 on test_merge(g ...

Oracle ORA-13000: dimension number is out of range

I trying to get familiar with Oracle Spatial. We have installed it and loaded some Oracle course data (USA states, counties, cities and interstates). I have created indexes on the tables and assigned an SRID to the metadata and the layers. When I try to perform the query below I always get the error ...

Oracle Simple spatial query with different SRID

Can anyone help me with just a real simple spatial query with different SRID. Here is the error i get when i perform the query: AND SDO_RELATE(A.geometrie_point, B.GEOMETRIE_POLYGONE, 'mask=anyinteract querytype=WINDOW') = 'TRUE'*ERROR at line 4:ORA-00604: error occurred at recursive SQL level 1ORA- ...

Oracle ORA-29902 and ORA-13208 doing window query (plus ORA-06512 and ORA-06512)

This probably has a really obvious answer... I'm getting some errors using below query:SELECT a.VLAKKEN_ID, a.AREA FROM WFSDATA a, WFSDATA g WHERE a.VLAKKEN_ID = g.VLAKKEN_ID AND ( ( sdo_relate(g.GEOM, mdsys.sdo_geometry(2003,NULL,NULL, mdsys.sdo_elem_info_array(1,1003,3),mdsys.sdo_ordinate_array(25 ...

Oracle Set alternate SRID for Mapviewer?

We are trying to get mapviewer to display our own data. It is no problem to display the sample data. We defined a new map, using the Map Definition tool. So far so good. But when we try to render a map, nothing is rendered and an error is displayed in the Oracle OC4J console. The error is: Ora-13208 ...

Oracle Error with update statement for SRID

Hi, i'm trying to update the SRID with the following statement but i receive an error :SQL> update TEST set GEO_TEST.sdo_srid=82652 where IDE_TEST=450000;update IIT.IIT_TROTR set GEO_TROTR.sdo_srid=8265*ERROR at line 1:ORA-00904: "GEO_TROTR"."SDO_SRID": invalid identifier Is the syntax of my stat ...