[postgis-users] Bounding Box form center using lat long and meters.

[Chris]

 SELECT ST_AsEWKT(ST_Expand(ST_GeomFromEWKT('SRID=4326;POINT(-88.33 
36.33)'),100));
I don't think something is right want max and min lat long of the 100 meter 
buffer.

On Saturday, November 26, 2016 at 9:00:23 AM UTC-6, Chris wrote:
>
> I'm wanting to be able to generate the bounding cords from the data, I've 
> tried to figure out the query but haven't had much luck using PostGIS. 
> The center coordinates of the image is 35.1495343, -90.0490665 lat long 
> The box should be 180 Meters wide and 135 Meters high my Heading is 12 
> Degrees.
> Image width and height are as follows if its needed 4000 W, 3000 H. If 
> something else would be more suitable like gdal please let me know. 
> I want to "automate" the geo-referencing on these single images with out 
> using something like QGIS" where I can use it in mapbox.
>
>   "overlay": {
>             "type": "image",
>             "url": "https://www.mapbox.com/mapbox-gl-js/assets/radar.gif",
>             "coordinates": [
>                 [-80.425, 46.437],
>                 [-71.516, 46.437],
>                 [-71.516, 37.936],
>                 [-80.425, 37.936]
>             ]
>         }
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161128/7c6ca060/attachment.html>