bb_map.xml

<?xml version="1.0" encoding="utf-8"?>

<!DOCTYPE Map[
  <!-- projections -->
  <!ENTITY srs900913 '+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 +wktext +no_defs'>
  <!ENTITY srs4326 '+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs'>
]>
  
<Map>

  <Datasource name="gis">
    <Parameter name="type">postgis</Parameter>
    <Parameter name="host">localhost</Parameter>
    <Parameter name="port">5433</Parameter>
    <Parameter name="user">gis</Parameter>
    <Parameter name="password">gis</Parameter>
    <Parameter name="dbname">gis</Parameter>
    <Parameter name="estimate_extent">true</Parameter>
    <Parameter name="geometry_field">the_geom</Parameter>
    <Parameter name="srid">900913</Parameter>'>
  </Datasource>

  <Style name="downtier">
    <Rule>
      <MaxScaleDenominator>100000000</MaxScaleDenominator>
      <Filter>[downtier] = '3'</Filter>
      <PolygonSymbolizer fill="#f00" fill-opacity="0.6" />
    </Rule>
    <Rule>
      <MaxScaleDenominator>100000000</MaxScaleDenominator>
      <Filter>[downtier] = '4'</Filter>
      <PolygonSymbolizer fill="#f80" fill-opacity="0.6" />
    </Rule>
    <Rule>
      <MaxScaleDenominator>100000000</MaxScaleDenominator>
      <Filter>[downtier] = '5'</Filter>
      <PolygonSymbolizer fill="#ff0" fill-opacity="0.6" />
    </Rule>
    <Rule>
      <MaxScaleDenominator>100000000</MaxScaleDenominator>
      <Filter>[downtier] = '6'</Filter>
      <PolygonSymbolizer fill="#8f0" fill-opacity="0.6" />
    </Rule>
    <Rule>
      <MaxScaleDenominator>100000000</MaxScaleDenominator>
      <Filter>[downtier] = '7'</Filter>
      <PolygonSymbolizer fill="#0f8" fill-opacity="0.6" />
    </Rule>
    <Rule>
      <MaxScaleDenominator>100000000</MaxScaleDenominator>
      <Filter>[downtier] = '8'</Filter>
      <PolygonSymbolizer fill="#0ff" fill-opacity="0.6" />
    </Rule>
    <Rule>
      <MaxScaleDenominator>100000000</MaxScaleDenominator>
      <Filter>[downtier] = '9'</Filter>
      <PolygonSymbolizer fill="#08f" fill-opacity="0.6" />
    </Rule>
    <Rule>
      <MaxScaleDenominator>100000000</MaxScaleDenominator>
      <Filter>[downtier] = '10'</Filter>
      <PolygonSymbolizer fill="#00f" fill-opacity="0.6" />
    </Rule>
    <Rule>
      <MaxScaleDenominator>100000000</MaxScaleDenominator>
      <Filter>[downtier] = '11'</Filter>
      <PolygonSymbolizer fill="#80f" fill-opacity="0.6" />
    </Rule>
  </Style>

  <Layer name="bb_blocks" srs="&srs900913;">
    <StyleName>downtier</StyleName>
    <Datasource base="gis">
      <Parameter name="table"><![CDATA[(
        SELECT blkidfp00,downtier,the_geom
          FROM tl_2009_tabblock00
          WHERE downtier IS NOT NULL
         ) AS bb_block ]]>
      </Parameter>
    </Datasource>
  </Layer>

</Map>