Skip to main content
  • EN

Hi all - Total FME noob here. I appreciate any assistance or advice you can offer... I am attempting to load a shapefile (https://healthyplacesindex.org/data-reports/) to SQL server. I can view this file in Data Inspector (uses CS_NAME: NAD83.CA/Teale). This file contains census data (with map polygons) for California (which I understand commonly has self-intersectors). I am getting errors when attempting to load this to a MS SQL (SSMS 18). The Writer throws many warnings but no errors. It appears to complete successfully, but no records are written to the SQL table it created.

 

Microsoft SQL Server Spatial Writer: Coordinate system `NAD83.CA/Teale' (EPSG:3310) unknown to SQL Server; Labeling features as LL-WGS84 instead

Microsoft SQL Server Spatial Writer: Failed to get the SQL Server native binary form for column 'GEOG'

 

I am currently looking into adding a transformation for Geometry Validator, but I am hesitant to "correct" content if I don't know what I am doing.

 

Thanks, again, for your patience and advice.

@grayw​ Check your SQL Server Spatial writer parameters that Spatial Type is set to Geometry not Geography

Embarrassingly, that was it. I had originally loaded like this, but I was receiving an unexpected SQL error when attempting to load the spatial data to Tableau. Based on that error, I attempted to reformat the load to SQL to be Geography instead of Geometry. I checked the spatial content in the Geometry load to SQL and it is valid and complete. That solves my issue! Thank you for your help!

Reply


Community Stats

30,184
Posts
114,566
Replies
37,846
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.