topic Spatial Views in ArcSDe 9.3.1 in Data Management Questions https://community.esri.com/t5/data-management-questions/spatial-views-in-arcsde-9-3-1/m-p/737864#M41665 <HTML><HEAD></HEAD><BODY><SPAN>We currently have 80 or so Spatial Views in SDE created in 9.0 &amp; 9.1 that have been upgraded for each new release. We are currently at 9.3.1 and have recently migrated to SQL Server 2008, Window Server 2008 R2 and 64-bit SDE. We need to add some new Spatial Views to our Database. When I create the view we have noticed not all records are returned. On further investigation we have noticed that only features that have had their Geometry modified after upgrade appear in the views. I've tested both Attribute and Geometry updates and have determined only changes to Geometry allow it to be updated in the View.</SPAN><BR /><BR /><SPAN>For example, an Address Point appears in a Feature Class and it has not been edited, Modified, etc for some time. We create a new simple Spatial View (using SDE Command Line) with no where cluase, etc, and the Address Point is not included. If I physically move the Point then Reconcile, Post &amp; Compress I then see that Point in the Spatial View. We have approx. 34k Points in this FC. Has anyone seen this behavior or know of a solution?</SPAN><BR /><BR /><SPAN>All previously created Views continue to be updated correctly, it is simply the newly (after our migration/upgrade to a new server) created Spatial Views exhibiting this behavior.</SPAN></BODY></HTML> Sat, 24 Apr 2010 17:23:30 GMT DanPajak 2010-04-24T17:23:30Z Spatial Views in ArcSDe 9.3.1 https://community.esri.com/t5/data-management-questions/spatial-views-in-arcsde-9-3-1/m-p/737864#M41665 <HTML><HEAD></HEAD><BODY><SPAN>We currently have 80 or so Spatial Views in SDE created in 9.0 &amp; 9.1 that have been upgraded for each new release. We are currently at 9.3.1 and have recently migrated to SQL Server 2008, Window Server 2008 R2 and 64-bit SDE. We need to add some new Spatial Views to our Database. When I create the view we have noticed not all records are returned. On further investigation we have noticed that only features that have had their Geometry modified after upgrade appear in the views. I've tested both Attribute and Geometry updates and have determined only changes to Geometry allow it to be updated in the View.</SPAN><BR /><BR /><SPAN>For example, an Address Point appears in a Feature Class and it has not been edited, Modified, etc for some time. We create a new simple Spatial View (using SDE Command Line) with no where cluase, etc, and the Address Point is not included. If I physically move the Point then Reconcile, Post &amp; Compress I then see that Point in the Spatial View. We have approx. 34k Points in this FC. Has anyone seen this behavior or know of a solution?</SPAN><BR /><BR /><SPAN>All previously created Views continue to be updated correctly, it is simply the newly (after our migration/upgrade to a new server) created Spatial Views exhibiting this behavior.</SPAN></BODY></HTML> Sat, 24 Apr 2010 17:23:30 GMT https://community.esri.com/t5/data-management-questions/spatial-views-in-arcsde-9-3-1/m-p/737864#M41665 DanPajak 2010-04-24T17:23:30Z Spatial Views in ArcSDE 9.3.1 https://community.esri.com/t5/data-management-questions/spatial-views-in-arcsde-9-3-1/m-p/737865#M41666 <HTML><HEAD></HEAD><BODY><SPAN>I believe this was a known issue -- possibly addressed by SP1 -- Spatial views weren't inheriting</SPAN><BR /><SPAN>the secondary coordref (for the initially encoded BASIC precision geometry).&nbsp; If SP1 doesn't fix this,</SPAN><BR /><SPAN>try updating the SDE.LAYERS table for the view to match the base table.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Sun, 25 Apr 2010 00:28:20 GMT https://community.esri.com/t5/data-management-questions/spatial-views-in-arcsde-9-3-1/m-p/737865#M41666 VinceAngelo 2010-04-25T00:28:20Z