I have a feature class layer and a handful of non spatial plain tables in a 10.1 SDE geodatabase on MS SQL Server. What I want to achieve is to publish a feature service from ArcGIS Server so as for users to edit both features and attributes from the non spatial tables.

I tried to make a spatial view by joining the feature table with other non-spatial tables by referencing foreign keys. I was able to publish the spatial view as feature service but not to make any edits from the REST service (Add, Update, Delete).

Just wondering why this was not successful and if a spatial view cannot be edited through feature service? Any workaround to achieve my task?

Thanks in advance.

Cheers, Alex

closed as unclear what you're asking by Devdatta Tengshe, BERA, Evil Genius, whyzar, Andre Silva Jun 11 '18 at 18:31

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • I am not sure but according to me you can not edit spatial view from client side (it will change only through back end i.e. data base.) You can think procedure instead of view but procedure also not possible in ArcGIS 10.1 – Sunil Jul 5 '13 at 7:42
  • +1 if you need editing from both side then try WFS service (resources.arcgis.com/en/help/main/10.1/index.html#/WFS_services/…) – Sunil Jul 5 '13 at 7:46
  • How have you made the spatial View? If you are using a Select in the View statement, then, by definition, it is Read-Only View, and Editing is not possible, even from SQL. – Devdatta Tengshe Jun 11 '18 at 9:25