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
