Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am having an issue with an Oracle query layer using SDO_Geometry not displaying.

I have created a polygon layer/table within oracle, registered the table with the SDO_GEOM_METADATA and created a spatial index...twice.

Unfortunately, I am still unable to see the polygons display in an ArcMap query layer. I am able to bring the data into ArcMap, open the table, select and identify it and actually see the shape flash, so I know it is there.

Also, I can export a shapefile and the shapes render perfectly fine, but for some reason they will not display from the query layer directly.

I have checked over the index parameters in the registry and nothing seems off, see:

INSERT INTO all_sdo_geom_metadata
            (owner,
             table_name,
             column_name,
             diminfo,
             srid)
     VALUES ('DB',
             'TABLE',
             'GEOM',
             MDSYS.sdo_dim_array (MDSYS.sdo_dim_element ('X',
            -180,180,5.0e-10), MDSYS.sdo_dim_element ('Y',-90,90,5.0e-10)),4326);
index creation:
CREATE  INDEX wm_dim_table_si ON TABLE (geom) INDEXTYPE IS MDSYS.spatial_index 
PARAMETERS ('tablespace=DB_INDEX03  layer_gtype=MULTIPOLYGON');

I've done everything, others have prescribed but I still can't view the data directly... Any hints as to what else I should try or should be looking at? Any help is greatly appreciated.

My nexts thoughts are that I should check and validate the geometry on the polygons. Also, there are about 30,000 polygons in this table, is there a threshold in ArcMap for query layers? It wouldn't seem so, however I am at a loss right now...

share|improve this question
1  
So a few things. In your metadata, you use 5.0e-10. For geographic coordinate systems that value is actually specified in meters. I think the minimum value is 0.05. Is your table really named table? Check the sde log files to see if there are any entries. You should be able to find them on the server SDE home dir if you are using three tier, or in the %temp% or desktop/etc dir. –  travis May 9 '13 at 19:20
    
Hi- Thanks for your response! By min value, you mean the tolerance can't be any less than .05? No, my table is not actually named table :-). Why are the sde log files important? This table is actually a separately defined oracle table not registered with sde.-Sorry I am very new to all this. esp. sde administration. –  Crystal Carreon May 14 '13 at 13:48
    
Yes, the tolerance shouldn't be less than 0.05. (section 1.5.5 docs.oracle.com/cd/E11882_01/appdev.112/e11830/…) I had to ask about the table name....I have seen some strange things. :) Even though the table isn't registered with SDE, SDE is still converting the SDO_Geometry object to something ArcMap can draw. Even so often SDE will encounter a shape that is valid to Oracle, but invalid to SDE. ArcMap should indicate that a layer failed to draw. This doesn't always happen, but SDE will always put a entry into the logfiles. Usually of type Load buffer error. –  travis May 14 '13 at 18:16

1 Answer 1

Faced the same problem. As travis pointed out: the problem is caused by different validation criterias Oracle/Esri are using. Hence there's no absolut correctness. You'll have to adapt to your target visualization system (ArcGIS in your case) Did you try to correct your geometries with ArcGIS repairGeometry function?

After that the Oracle Spatial Query Layer should display correctly in ArcMap.

share|improve this answer
    
I did repair the geometries and rectified the geometries in oracle with a .05 tolerance but I still have the same issue. These polygons can be multi part features so I wonder if that has an impact...I'll have to try this with single part features only and see if it works...I have given up on this project for now as it isn't as urgent as it was previously...Will get back to you once I get back on it. –  Crystal Carreon Sep 20 '13 at 12:16
    
in my case multi part features didn't have an impact, but Oracle's collections definitly had. –  stevo Oct 14 '13 at 11:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.