Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 1 down vote favorite

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 armap for query layers? It wouldn't seem so, however I am at a loss right now...

share|improve this question
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 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 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 at 18:16

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.