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
![https://www.mapbox.com/mapbox-gl-js/assets/radar.gif"](https://www.mapbox.com/mapbox-gl-js/assets/radar.gif"){kind=link}