Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • I have a SQL spatial table extracted from our GIS that contains a GEOM field in projection NAD27. I need to generate an XY for these values from this GEOM. Everything I’ve tried, I don’t get the output I need. Please advise.

Here is the SQL query that I use in SSMS that gets me the XY but I have not been able to translate the query into FME to get the same results.

"select RiserObjectID, Premise, GEOM.STX as X, GEOM.STY as Y from RiserPrem_NAD27"

csmapreprojector:change destination coordinate system value --> attributecreator:new attribute 'X', attribute value '@XValue()'; new attribute 'Y', attribute value '@YValue()'

Thanks, this will work.

Reply


Community Stats

30,163
Posts
114,500
Replies
37,813
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.