# SDE ST_Transform gives wrong geometries from 3857 to 4326

2250
5
10-09-2015 12:47 AM
Highlighted
New Contributor III

Hi All,

I made a transformation of a circle with radius of 1000 mt. from 3857 (Web-Mercator) to 4326 (WGS84).

I issued a strange situation: the projected circle has a radius of around 0.7 meters.

What happens?

1 Solution

Accepted Solutions
Highlighted
New Contributor III

Thanx I think I solved.

I was measuring distance in Planar instead of Geodesic distance.

the tool is the one of arcgis atcmap 10.2.2

@neil i know that the shape is such an ellipse, but all the axis where wrong

5 Replies
Highlighted
MVP Frequent Contributor

4326 WGS84 is a geographic coordinate system based in degrees not metres.

Highlighted
New Contributor III

I know.
But my problem is different:
I insert a circle (radius = 1000 meters in EPSG:3857 Web Mercator, in Meters);

after I transform it in WGS84 (in degrees);

In ArcMap by a tool I measure the radius (the tool returns length in Meters, etc...) and radius is 700 meters, not 1000 m.

I think it's an issue of SDE.ST_Transform

Highlighted
MVP Frequent Contributor

I very much doubt that the projection is being handled incorrectly.

But what is your purpose for this?

And I ma surprised that your output is still a circle with a particular radius.

Depending on where it has been placed (high latitudes vs an equatorial location), I would expect that the Web Mercator version gets quished into some sort of ellipse in degrees.

Highlighted
Esri Esteemed Contributor

You'll need to provide exact details of the version of ArcGIS, the database product, the database product version, the geodatabase version (if not the same as ArcGIS), the exact SQL you are using, and the coordinate values associated with at least one feature. You'll also need to provide how you determined that the radius was sub-meter in WGS84.

- V

Highlighted
New Contributor III

Thanx I think I solved.

I was measuring distance in Planar instead of Geodesic distance.

the tool is the one of arcgis atcmap 10.2.2

@neil i know that the shape is such an ellipse, but all the axis where wrong