Skip to main content
Question

How to view/access the Geometry attribute in MS SQL Spatial writer in FME DESKTOP 2020.1.1.1


I have added MS SQL Spatial writer in FME DESKTOP 2020.1.1.1 and I can view the table attribute other than geometry attribute. Can you please help how to view/access the Geometry field in MS SQL Spatial Writer

2 replies

rahulsharma
Safer
Forum|alt.badge.img+10

hi @naranawinkumar​ 

Can you clarify if you want to extract the geometry or you simply want to expose the geometry column?

If you simply want to expose the geometry column, you can use Microsoft SQL Server Non-Spatial (MSSQL_ADO) reader as explained in Option1.

Option 1: Read the Table with a non-spatial reader and it will get you a column GEOM with geometry values.Geom_nonSpatialOption 2: Use GeometryExtractor transformer with MS SQL Spatial Reader

Geom_Extractor


Hi @rahulsharma​ 

I need to extract and expose the geometry column.

 

Thanks a bunch!


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