I have points in WGS84 (x,y), radiuses in meters (rx, ry), rotation angle in degrees. I would like to create a new WGS84 geometry.
I've tried this but the major/minor distances seem to be off by a few hundred meters in some cases.
Ellipse (x,y,rx,ry,rotation,#of segments in 1/4 of ellipse)
SELECT
transform(
translate(
rotate(
scale(
buffer(
transform(setsrid(makepoint(0,0),4326),3395),
1,
$6),
$3,$4),
$5),
x(transform(setsrid(makepoint($1,$2),4326),3395)),
y(transform(setsrid(makepoint($1,$2),4326),3395))),4326)