Import kleptogs coastline into postgres:


jburgess@tilegen:~/coastlines$ shp2pgsql -s 900913 -I -g way processed_p shoreline_a | psql -q gis
Shapefile type: Polygon
Postgis type: MULTIPOLYGON[2]
NOTICE:  CREATE TABLE will create implicit sequence "shoreline_a_gid_seq" for serial column "shoreline_a.gid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "shoreline_a_pkey" for table "shoreline_a"
                      addgeometrycolumn
-------------------------------------------------------------
 public.shoreline_a.way SRID:900913 TYPE:MULTIPOLYGON DIMS:2

(1 row)

gis=> alter table shoreline_a alter column way set not null;
ALTER TABLE
gis=> CLUSTER shoreline_a_way_gist on shoreline_a;
CLUSTER

gis=# grant select on shoreline_a to tile;


  <Style name="coast-poly">
    <Rule>
      <MaxScaleDenominator>600000</MaxScaleDenominator>
      <PolygonSymbolizer>
        <CssParameter name="fill">#f2efe9</CssParameter>
      </PolygonSymbolizer>
    </Rule>
  </Style>

...

  <Layer name="coast-poly" status="on" srs="+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over">
    <StyleName>coast-poly</StyleName>
    <Datasource>
      <Parameter name="type">postgis</Parameter>
      <Parameter name="dbname">gis</Parameter>
      <Parameter name="estimate_extent">false</Parameter>
      <Parameter name="table">(select way from shoreline_a) as "coast-poly"</Parameter>
      <Parameter name="extent">-20037508,-19929239,20037508,19929239</Parameter>
    </Datasource>
  </Layer>