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 <[email protected]> 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
[email protected]
http://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
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
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/postgis-users
![https://www.mapbox.com/mapbox-gl-js/assets/radar.gif"](https://www.mapbox.com/mapbox-gl-js/assets/radar.gif"){kind=link}