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"
Question
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.
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.
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.
+16- Contributor
csmapreprojector:change destination coordinate system value --> attributecreator:new attribute 'X', attribute value '@XValue()'; new attribute 'Y', attribute value '@YValue()'