I am looking to find multiple lat/long points (N,S,E,W) that are 100 metres from an input lat/lon point I have stored in PostGIS.
Given a latitude and longitude I'd like to find the latitude and longitude point that is 100 metres North, 100 metres South etc.
I don't have anything but the input lat/lon values stored in the database, so SELECTing from PostGIS will not work in this case.
According to @ThingumaBob, there is a way to find these points with PostGIS.
How would I do this?