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

[Andy Colson]

On 11/27/2016 09:09 AM, Chris wrote:
> Yes, I'm not sure if I need to be true north all the times or not,
> since this is a image i'm overlaying is there a way to calculate the
> heading into the sql query so if its 12 degrees heading from north its
> accounted for?
> or should I shoot all my photos at 0 degrees north.
>
> On Sun, Nov 27, 2016 at 8:46 AM, Andy Colson <andy at squeakycode.net> wrote:
>> On 11/26/2016 09:00 AM, 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] ]
>>> }|
>>>
>>>
>>
>> So you are looking for some sql to generate a 180x135 box around a give
>> center point?
>>
>> -Andy
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>

As long as your happy with it being extended from the center point, I think a combination of http://postgis.net/docs/ST_Extent.html and http://postgis.net/docs/ST_Rotate.html should get you what you want.

-Andy