Skip to main content
Question

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

  • 20 May 2024
  • 1 reply
  • 35 views

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

Badge +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