Considering I have a proj4 string such as:

+proj=tmerc +lat_0=12 +lon_0=-12 +k=1 +x_0=0 +y_0=0 +datum=WGS84 +units=m

Is it possible to create a geometry given X and Y offset (in meters)? For example a point 100 meters away from the origin (lat:12,lon:-12) in the X axis:

ST_MakePoint(100, 0, '+proj=tmerc +lat_0=12 +lon_0=-12 +k=1 +x_0=0 +y_0=0 +datum=WGS84 +units=m')
  • If you want to use a projection, it must be present in the spatial_ref_sys table. – CL. Jul 20 '20 at 11:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.