layer-buildings.xml.ent

<Style name="buildings">
  <Rule>
    <Filter>([building]!='' and not ([building]='residential' or [building]='hut')) or [man_made]='works' or [amenity]!='' or [railway]='station' or [aeroway]!='' or [military]!='' or [historic]='castle'</Filter>
    &maxscale_zoom13;
    <PolygonSymbolizer>
      <CssParameter name="fill">#333</CssParameter>
    </PolygonSymbolizer>
  </Rule>
  <Rule>
    <Filter>[building]='residential' or [building]='hut'</Filter>
    &maxscale_zoom15;
    <PolygonSymbolizer>
      <CssParameter name="fill">#666</CssParameter>
    </PolygonSymbolizer>
  </Rule>
  <Rule>
    <Filter>[man_made]='storage_tank' or [man_made]='silo' or [man_made]='water_tower'</Filter>
    &maxscale_zoom15;
    <PolygonSymbolizer>
      <CssParameter name="fill">#828282</CssParameter>
    </PolygonSymbolizer>
  </Rule>
  <Rule>
    &maxscale_zoom16;
    <LineSymbolizer>
      <CssParameter name="stroke">#000</CssParameter>
      <CssParameter name="stroke-width">0.5</CssParameter>
    </LineSymbolizer>
  </Rule>
</Style>

<Layer name="buildings" status="on" srs="&osm2pgsql_projection;">
  <StyleName>buildings</StyleName>
  <Datasource>
    <Parameter name="table">
    (select way,man_made,amenity,railway,aeroway,military,historic,
      case
        when building in ('house','detached','terrace','apartments','garage','garages') then 'residential'::text
        when building in ('cabin','pavilion','canopy') then 'hut'::text
        else building
      end as building
     from &prefix;_polygon
     where building is not null
        and building!='no'
        or man_made in ('works','storage_tank','silo','water_tower')
        or amenity in ('place_of_worship','public_building','townhall','courthouse')
        or railway='station'
        or aeroway in ('terminal','hangar')
        or military in ('barracks','bunker')
        or historic='castle'
     order by z_order,way_area desc) as buildings
    </Parameter>
    &datasource-settings;
  </Datasource>
</Layer>