Skip to main content
Solved

Creating SQL 2012 Spatial Geography Column from existing Geometry Column

  • March 7, 2013
  • 1 reply
  • 29 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
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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

Helpful Members This Week

Community Stats

31,313
Posts
118,740
Replies
38,900
Members

Latest FME

Terms & ConditionsCookie settings

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
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.