Skip to main content
Question

Convert from WGS84 to GDA94

  • May 21, 2018
  • 3 replies
  • 50 views
B

Hello everyone,

I have two software that accept geometry in two different format. Software A uses WGS84 and B uses GDA94. I need to translate geo data on the fly between two system (e.g. A SQL trigger exists that updates record in other system's database table when data is updated and vice versa).

I want to know how can I convert geo data from one format to other using *within SQL*. I cannot use FME Desktop and FME API since that would require solution to work outside SQL Server.

Any help is appreciated, thanks in advance.

Regards,

 

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

3 replies

stalknecht
Contributor
Forum|alt.badge.img+21
  • stalknechtContributor
  • Contributor
  • 305 replies
  • May 23, 2018

When the trigger is fired you can use xp_cmdshell to start an fme.exe process to do the conversion.

B
  • bhrugu82
  • Author
  • 1 reply
  • May 24, 2018

Hi @stalknecht, thanks for the response.  This is good alternative.  However, is there a chance to call CLR function from within SQL server? Something along the lines of below (not actual code)

SELECT FmeTransformFactory.Convert(WSG84_Geometry_Column, GDA94) as 'GDA94_Converted_Geometry'

I hope it makes sense.

Regards,

 

Bhargav
stalknecht
Contributor
Forum|alt.badge.img+21
  • stalknechtContributor
  • Contributor
  • 305 replies
  • May 24, 2018

Hi @stalknecht, thanks for the response.  This is good alternative.  However, is there a chance to call CLR function from within SQL server? Something along the lines of below (not actual code)

SELECT FmeTransformFactory.Convert(WSG84_Geometry_Column, GDA94) as 'GDA94_Converted_Geometry'

I hope it makes sense.

Regards,

 

Bhargav
Nope, it's not available.

 

 

Community Stats

32,086
Posts
121,845
Replies
39,727
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.