Convert Geometry from T-SQL to PostgreSQL

ruben00000
on Aug 08, 2021 11:17 PM
289 Views

how to convert geometry with float x and y sql server to postgress sql

declare 
@x float = 1067527872,
@y float = -234636443,
@p1  geometry
set @p1 = geometry::STGeomFromText('POINT(' + STR(@x,12,7) + ' ' + STR(@y,12,7) + ')',4326)
select @p1 as geom

Download FREE API for Word, Excel and PDF in ASP.Net: Download

dharmendr
on Aug 08, 2021 11:30 PM

Hi ruben00000,

Refer below link.

https://stackoverflow.com/questions/57286653/convert-geometry-from-t-sql-to-postgres

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

This site is started with intent to serve the ASP.Net Community by providing forums (question-answer) site where people can help each other. The content posted here is free for public and is the content of its poster. The site does not provide any warranties for the posted content. If you feel any content is violating any terms please contact.