Skip to main content
Solved

Creating SQL 2012 Spatial Geography Column from existing Geometry Column

  • March 7, 2013
  • 1 reply
  • 37 views
G
Hello. I am new to using FME/ESRI Data Interoperability tools, so please forgive me for my inexperience with FME translations.

 

 

I am working with the Data Interop Extension for ArcGIS , and am attempting to use a custom ETL tool to assist with the translation. I have a SQL 2012 database that contains a table of our crime data. The table has an X and Y coordinate field, which is based off NAD83 Illinois State Plane West system. Using the X and Y fields, I created a GEOMETRY column in the table in SQL Server managment studio (set the SRID in SQL to 4326 when creating the column). However, in order to use Bing tiled map services, I need to have data stored in a Geography column. I am trying to use the FME tool (ESRIReprojector) to import the SQL Server Spatial table, reproject it from NAD83 to WGS84, and then output the result to the empty GEOGRAPHY column. The workspace will run, but there is Not any data populated to the new GEOGRAPHY ) column in the SQL table and I am unsure of where I am going wrong. Any insight you might be able to provide would be greatly appreciated. Thank you.

Best answer by david_r

Hi,

 

 

not sure if I understood half of that ;-) but you might need something like a 2DPointReplacer to convert your X,Y values to a geometry, and then perhaps a Reprojector to get it to LL84 before you write it to your output table.

 

 

Good luck!

 

 

David
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • March 8, 2013
Hi,

 

 

not sure if I understood half of that ;-) but you might need something like a 2DPointReplacer to convert your X,Y values to a geometry, and then perhaps a Reprojector to get it to LL84 before you write it to your output table.

 

 

Good luck!

 

 

David

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.