nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Editing a SQL Server Spatial Type in ArcGIS Pro

MichaelTorbett

Can you edit a feature class with a SQL Server Spatial type in ArcGIS Pro without enabling the database as an Enterprise Geodatabase? I've read through the doc's and haven't been able to find a conclusive answer yet. I'd like to be able to create tables in both SQL Server and ArcGIS Pro with a SQL spatial type for editing in Pro. However, I want to avoid all of the additional tables created when enabling an Enterprise Geodatabase.

I've ran several tests following the help guide here : https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/sqlserver-spatial-types-and-arcgis.htm but keep getting a 9999999 error.

Thank you,

Michael

タグ付けされた投稿をもっと見る

Accepted answers

GdB_Admin

Sadly I have not found a way to Edit an SQL Native Database in ArcGIS Pro. Pro requires all of the A, D, I, etc. tables for each item. There is not a way for Pro to understand What everything is when you want to edit. You can view the data in Pro but editing is not an option. You will need to copy that data into an enterprise database. You can us the import tool to bring it into an enterprise database but what you are looking to do it not possible at this time.

All comments

MichaelTorbett

Thank you George. That's exactly what I was looking for.

MichaelTorbett

Thanks Scott! Being able to edit as a feature service would do the trick. I will give that a shot. These spatial types would be created in my agency's master sql database and I wanted to start small. As this grows, we will likely consider adding Enterprise Geodatabase Functionality.

MichaelTorbett

Thank you GdB_Admin for the reply. I think that answers my question. It does look like I can publish it as a service to my ArcGIS Server and edit from there. I have not tried it yet, but that would do what I need.

George Thompson

Here is the doc that references what you are looking for: https://pro.arcgis.com/en/pro-app/latest/help/data/databases/databases-and-arcgis.htm#ESRI_SECTION1_A188C2B1C8C54C7DA3233892FC742552

Scott_Tansley

If you have an ArcGIS Server available, then you could look to publish a query layer as a map/feature service combo. I believe you can then edit via the feature service.

Beyond that the Enterprise Geodatabase provides significant rigour relating to data editing and control. It's value should not be discounted, and that's why I believe that Esri want us to edit via the Enterprise Geodatabase models. Query Layers (no sde table) are ready only in 'Desktop GIS' like Pro:

https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/what-is-a-query-layer-.htm#:~:text=Query%20layers%20are%20read%20only%20when%20accessed%20directly%20from%20a%20database%20connection

GdB_Admin

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.