Question

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

N

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

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

N

Hi @rahulsharma​ 

I need to extract and expose the geometry column.

 

Thanks a bunch!

Reply


Community Stats

28,724
Posts
109,518
Replies
36,564
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.