topic Re: Oracle Query Layer not Displaying in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/oracle-query-layer-not-displaying/m-p/343235#M13178 <HTML><HEAD></HEAD><BODY><SPAN>I believe a Query Layer requires ST_Geometry type.</SPAN></BODY></HTML> Fri, 07 Mar 2014 14:52:52 GMT MichaelVolz 2014-03-07T14:52:52Z Oracle Query Layer not Displaying https://community.esri.com/t5/arcgis-enterprise-questions/oracle-query-layer-not-displaying/m-p/343234#M13177 <HTML><HEAD></HEAD><BODY><SPAN>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');</SPAN><BR /><BR /><SPAN>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...</SPAN></BODY></HTML> Thu, 09 May 2013 13:14:24 GMT https://community.esri.com/t5/arcgis-enterprise-questions/oracle-query-layer-not-displaying/m-p/343234#M13177 CrystalCarreon 2013-05-09T13:14:24Z Re: Oracle Query Layer not Displaying https://community.esri.com/t5/arcgis-enterprise-questions/oracle-query-layer-not-displaying/m-p/343235#M13178 <HTML><HEAD></HEAD><BODY><SPAN>I believe a Query Layer requires ST_Geometry type.</SPAN></BODY></HTML> Fri, 07 Mar 2014 14:52:52 GMT https://community.esri.com/t5/arcgis-enterprise-questions/oracle-query-layer-not-displaying/m-p/343235#M13178 MichaelVolz 2014-03-07T14:52:52Z Re: Oracle Query Layer not Displaying https://community.esri.com/t5/arcgis-enterprise-questions/oracle-query-layer-not-displaying/m-p/343236#M13179 <HTML><HEAD></HEAD><BODY><SPAN>Have you tried validating the geometry in oracle?&nbsp; I'm not sure the SQL to do it off my head, but for instance, if you use SQL Developer, right click on the table and choose Spatial-&gt;Validate Geometry using Tolerance.&nbsp; I've had issues with SDO Geometry drawing, and that has fixed the issue some times.</SPAN></BODY></HTML> Mon, 17 Mar 2014 21:01:48 GMT https://community.esri.com/t5/arcgis-enterprise-questions/oracle-query-layer-not-displaying/m-p/343236#M13179 MikeBranchini 2014-03-17T21:01:48Z Re: Oracle Query Layer not Displaying https://community.esri.com/t5/arcgis-enterprise-questions/oracle-query-layer-not-displaying/m-p/343237#M13180 <HTML><HEAD></HEAD><BODY><SPAN>Your SDO metadata is formed incorrectly.&nbsp; The SRID should not be 4326 (use 8307 for WGS_1984), and the coordinate resolution should not be in angstroms (use 0.05 meters). -V</SPAN></BODY></HTML> Wed, 19 Mar 2014 00:32:34 GMT https://community.esri.com/t5/arcgis-enterprise-questions/oracle-query-layer-not-displaying/m-p/343237#M13180 VinceAngelo 2014-03-19T00:32:34Z