Using PostGIS I have a lat/lon point and want to add an east/west and north/south offset in metres to get a new point. Is that possible?
[GIS] How to add an offset to a lat/lon to get a new point using PostGIS
postgis
Related Question
- [GIS] How to get Lon/Lat values from the postgis raster type column
- [GIS] Using geometry or point for postgis
- [GIS] How to get all geometries within area using Google Maps API info
- PostGIS – Calculate Extreme Point of Geography (Polygon) Type
- PostGIS Geometry Creation – How to Create from Latitude/Longitude Array in Table
Best Answer
You can use ST_Translate:
Source: http://www.bostongis.com/postgis_translate.snippet
You'll have to transform lat/lon to meters first. You can use ST_Transform to achieve this:
Source: http://postgis.net/docs/ST_Transform.html