44 | | CREATE OR REPLACE VIEW ${COAST%%.gmt}_bufout AS |
45 | | SELECT gid, ST_Buffer(geom, ${buf}) FROM ${COAST%%.gmt}; |
46 | | CREATE OR REPLACE VIEW ${COAST%%.gmt}_bufin AS |
47 | | SELECT gid, ST_Buffer(st_buffer, -${buf}) FROM ${COAST%%.gmt}_bufout; |
| 44 | CREATE OR REPLACE VIEW ${COAST}_bufout AS |
| 45 | SELECT gid, ST_Buffer(geom, ${buf}) FROM ${COAST}; |
| 46 | CREATE OR REPLACE VIEW ${COAST}_bufin AS |
| 47 | SELECT gid, ST_Buffer(st_buffer, -${buf}) FROM ${COAST}_bufout; |
50 | | ogr2ogr -f GMT ${COAST%%.gmt}_bufout${buf}.gmt \ |
51 | | PG:"host=localhost user=username password=password dbname=gshhs" \ |
52 | | ${COAST%%.gmt}_bufout |
53 | | ogr2ogr -f GMT ${COAST%%.gmt}_bufin${buf}.gmt \ |
54 | | PG:"host=localhost user=username password=password dbname=gshhs" \ |
55 | | ${COAST%%.gmt}_bufin |
| 50 | ogr2ogr -f GMT ${COAST}_bufout${buf}.gmt \ |
| 51 | PG:"host=localhost user=sluque password=otariidae dbname=gshhs" \ |
| 52 | ${COAST}_bufout |
| 53 | ogr2ogr -f GMT ${COAST}_bufin${buf}.gmt \ |
| 54 | PG:"host=localhost user=sluque password=otariidae dbname=gshhs" \ |
| 55 | ${COAST}_bufin |