https://community.esri.com/t5/developers-questions/srid-conversion-in-sql-server/m-p/1623090#M7533 <P>Is there a function in SQL Server (similar to Postgres) or a formula to convert Lat/Lon (SRID 4269, as shown on the right side of the screenshot) into SRID 2253<SPAN>&nbsp;</SPAN>STAsText<SPAN>&nbsp;</SPAN>(as shown on the left side of the image)?</P><P>The data on the right comes from a third-party app. I need to run a query to find the point that falls within certain boundaries (as shown in the table on the left) and update a specific field in the table via a trigger.</P><P>I would be grateful for any insights or ideas you can provide.</P><P>Thanks,<BR />Stan</P> Thu, 12 Jun 2025 15:55:01 GMT Stan 2025-06-12T15:55:01Z https://community.esri.com/t5/developers-questions/srid-conversion-in-sql-server/m-p/1623090#M7533 <P>Is there a function in SQL Server (similar to Postgres) or a formula to convert Lat/Lon (SRID 4269, as shown on the right side of the screenshot) into SRID 2253<SPAN>&nbsp;</SPAN>STAsText<SPAN>&nbsp;</SPAN>(as shown on the left side of the image)?</P><P>The data on the right comes from a third-party app. I need to run a query to find the point that falls within certain boundaries (as shown in the table on the left) and update a specific field in the table via a trigger.</P><P>I would be grateful for any insights or ideas you can provide.</P><P>Thanks,<BR />Stan</P> Thu, 12 Jun 2025 15:55:01 GMT https://community.esri.com/t5/developers-questions/srid-conversion-in-sql-server/m-p/1623090#M7533 Stan 2025-06-12T15:55:01Z https://community.esri.com/t5/developers-questions/srid-conversion-in-sql-server/m-p/1629095#M7560 <P>You would need a function like ST_Transform, which unfortunately Microsoft does not provide for its Geometry data type. You won't be able to do this at the sql level.</P> Tue, 01 Jul 2025 21:51:59 GMT https://community.esri.com/t5/developers-questions/srid-conversion-in-sql-server/m-p/1629095#M7560 ShannonShields 2025-07-01T21:51:59Z