How do I create a point 1000 meters away from a reference point?
The ST_Translate only supports geometry type.
I also tried using ST_GeomFromText but that returns a unit and not in meters.
Here is my sample query:
SELECT ST_AsText ( ST_Translate ( ST_GeogFromText('SRID=4326;POINT(-70.01 43.27)'), 1000, 0 ) );
Is there a way that I can convert the output of ST_Translate into meters?