topic Re: ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743591#M331 <HTML><HEAD></HEAD><BODY><P>If you recreate the view it may pick up the records that you say are outside the initial extent.&nbsp;</P></BODY></HTML> Thu, 13 Dec 2018 14:50:18 GMT George_Thompson 2018-12-13T14:50:18Z ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743584#M324 <HTML><HEAD></HEAD><BODY><P>We have been at ArcSDE 10.3.1/Oracle 12c for almost 2 years and have a lot of spatial views. Recently we found a few spatial views in existing ArcMap files do not match ArcCatalog (verified in both ArcGIS Desktop 10.3.1 and 10.5.1) in feature count, and we have to drag the spatial views from ArcCatalog into ArcMap to validate the count.&nbsp;&nbsp;Anybody knows why?&nbsp;<SPAN>This behavior really looks like a bug to me.</SPAN></P></BODY></HTML> Wed, 12 Dec 2018 13:19:42 GMT https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743584#M324 AllenGuan2 2018-12-12T13:19:42Z Re: ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743585#M325 <HTML><HEAD></HEAD><BODY><P>Is the underlying data versioned?</P></BODY></HTML> Wed, 12 Dec 2018 14:21:08 GMT https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743585#M325 George_Thompson 2018-12-12T14:21:08Z Re: ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743586#M326 <HTML><HEAD></HEAD><BODY><P>One&nbsp;is registered as archived, the other one is not, and both cases we only look at the Default version.</P></BODY></HTML> Wed, 12 Dec 2018 17:43:13 GMT https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743586#M326 AllenGuan2 2018-12-12T17:43:13Z Re: ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743587#M327 <HTML><HEAD></HEAD><BODY><P>Is the one that is archived have more records than the other one?<BR /><BR />Is the view "removing" out the non-valid records in the archived feature class?</P><P></P><P>What is the feature count difference?</P></BODY></HTML> Wed, 12 Dec 2018 18:06:48 GMT https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743587#M327 George_Thompson 2018-12-12T18:06:48Z Re: ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743588#M328 <HTML><HEAD></HEAD><BODY><P>All records are valid. The count difference between ArcMap and ArcCatalog is small, usually 1 - 3 missing in ArcMap. When a spatial view is dragged into ArcMap, it asks for selecting an unique field, which is usually objectid, then it calculates the initial extent and add the data to the map. Seems to me the missing ones are the new features that fall outside the initial extent.</P></BODY></HTML> Wed, 12 Dec 2018 20:29:13 GMT https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743588#M328 AllenGuan2 2018-12-12T20:29:13Z Re: ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743589#M329 <HTML><HEAD></HEAD><BODY><P>What happens if you drop the view and re-create it? Do the # of records match then?</P></BODY></HTML> Thu, 13 Dec 2018 12:59:59 GMT https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743589#M329 George_Thompson 2018-12-13T12:59:59Z Re: ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743590#M330 <HTML><HEAD></HEAD><BODY><P>Not sure about the rational behind recreating the views.&nbsp;I am testing this in ArcSDE 10.5.1 where spatial views are registered with SDE. Got a feeling this issue&nbsp;would not occur in 10.5.1. ESRI made a big mistake when dropping SDE view support in 10.2 and 10.3,&nbsp; and glad it came back in 10.5.1.</P></BODY></HTML> Thu, 13 Dec 2018 14:39:12 GMT https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743590#M330 AllenGuan2 2018-12-13T14:39:12Z Re: ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743591#M331 <HTML><HEAD></HEAD><BODY><P>If you recreate the view it may pick up the records that you say are outside the initial extent.&nbsp;</P></BODY></HTML> Thu, 13 Dec 2018 14:50:18 GMT https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743591#M331 George_Thompson 2018-12-13T14:50:18Z Re: ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743592#M332 <HTML><HEAD></HEAD><BODY><P>Not recreate the view, but redrag the view into ArcMap to recalculate the extent. Better to specify a larger extent than using the default calculation.</P></BODY></HTML> Thu, 13 Dec 2018 17:04:39 GMT https://community.esri.com/t5/geodatabase-questions/arcsde-spatial-view-feature-count-in-arcmap-do-not/m-p/743592#M332 AllenGuan2 2018-12-13T17:04:39Z