Skip to main content
Question

FME geometry wiring issues for AGOL feature service data loading in to SQL Server feature class

  • May 20, 2024
  • 1 reply
  • 44 views

muditagarwal100
Contributor
Forum|alt.badge.img

Hello, 

I want to read AGOL polygon feature service and write in SQL server feature class. Reading is not problem, I can see the geometry but writer is only writing attributes and not geom in SQL.

I am using feature writer (SQL Server Spatial) and want to understand how I can write geom in SQL table “GDB_GEOMATTR_DATA” column. 

Any help is appreciated. TIA

 

1 reply

trentatsafe
Safer
Forum|alt.badge.img+6

Hello @muditagarwal100 ,

 

Based on the geometry column you mentioned, and that you used the term ‘Feature class’ are you trying to write to an Enterprise Geodatabase(SDE)? If so, you should use the Esri Geodatabase (ArcSDE Geodb) format. This will allow you to write features to a Feature class that has been registered with the Geodatabase. Esri has some documentation regarding that field you mentioned listed here: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/sqlserver-spatial-types-and-arcgis.htm

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings