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.

4 years ago
November 12, 2020
2 replies
6 views

dblan
1 reply

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"

+14

alexlynch3450
Contributor
68 replies
4 years ago
January 15, 2021

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

dblan
Author
1 reply
4 years ago
January 15, 2021

Thanks, this will work.

Reply

Rich Text Editor, editor1

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

We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.

Basic
Functional

Normal
Functional + analytics

Complete
Functional + analytics + social media + embedded videos + marketing

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.