A semi-automated sql script to remove map collars from FEMA FIRM Panel rasters.

remove-firm-collars.sql

/*
Removes map collars from FEMA FIRM Panel rasters.
=================================================
Output the query results to a batch file and run inside the directory
with the FIRM tiffs.  Assumes that the table with panel footprints has
been projected to the same coordinate system as the rasters.

The MIT License (MIT)
2015-08-26 Tom Arnold - Walker Associates, Inc.
*/
SELECT 
'gdal_translate -projwin ' ||
st_minx("Geometry") || ' ' ||
st_maxy("Geometry") || ' ' ||
st_maxx("Geometry") || ' ' ||
st_miny("Geometry") || ' ' ||
"FIRM_PAN" || '.tif ' || "FIRM_PAN" || '_NoCollar.tif'
AS "REM Remove map collars"
from s_firm_pan_26916
where "FIRM_PAN" like '01125%'
order by "FIRM_PAN"