topic Re: Spatial View Not Updating in Geodatabase Questions

Spatial View Not Updating

CurtPope — Tue, 16 Feb 2016 19:53:27 GMT

I have a Spatial view of a relationship between a not spatial table and a feature class. I was able to get the to join based on the correct field. I had a number of discrepancies between the two tables so i start editing the tables as need so the data would join up. It worked on my first pass through the data but then i had to do some research to fix the discrepancies. Now when i edit the data in either table its not reflected in the view. I have tried deleting and rebuilding the view a number of times with no luck. I did a spatial join in ArcMap to see if my data was line up and that worked just fine so now i am stumped. Has anyone else encountered this Problem

Re: Spatial View Not Updating

George_Thompson — Tue, 16 Feb 2016 20:11:13 GMT

Hi Curt,

Is the data versioned?

What RDBMS are you using?

What is the version of your geodatabase?

-George

Re: Spatial View Not Updating

CurtPope — Tue, 16 Feb 2016 20:16:16 GMT

Oh it was versioned i thought i had unregistered the data. And that Seemed to fix the problem you are a life saver.

Re: Spatial View Not Updating

DanPatterson_Retired — Tue, 16 Feb 2016 20:20:22 GMT

Not sure about what you mean by updating the view, but have you tried getting out of edit mode and toggling on and off the layer? or opening and closing the table (I swear there is a refresh somewhere)

Re: Spatial View Not Updating

AndresCastillo — Thu, 24 May 2018 13:04:18 GMT

I would think if the data were versioned, you would have to use a versioned view.

See:

http://desktop.arcgis.com/en/arcmap/10.4/manage-data/using-sql-with-gdbs/read-sqlserver-versioned-data-with-sql.htm