gistfile1.xml

LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:900913"
    END
    NAME "waterarea7"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=localhost dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=900913"
    MAXSCALEDENOM 5200128
    MINSCALEDENOM 2600064
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END



-----------------------



<?xml version="1.0" ?>
<StyledLayerDescriptor version="1.0.0" xmlns="http://www.opengis.net/sld" xmlns:gml="http://www.opengis.net/gml" xmlns:ogc="http://www.opengis.net/ogc" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/sld http://schemas.opengis.net/sld/1.0.0/StyledLayerDescriptor.xsd">
    <NamedLayer>
        <Name>waterarea7</Name>
        <UserStyle>
            <FeatureTypeStyle>
                <Rule>
                    <ogc:Filter>
                        <ogc:PropertyIsEqualTo>
                            <ogc:PropertyName>type</ogc:PropertyName>
                            <ogc:Literal>riverbank</ogc:Literal>
                        </ogc:PropertyIsEqualTo>
                    </ogc:Filter>
                    <MinScaleDenominator>2600064.000000</MinScaleDenominator>
                    <MaxScaleDenominator>5200128.000000</MaxScaleDenominator>
                    <PolygonSymbolizer>
                        <Fill>
                            <CssParameter name="fill">#99b3cc</CssParameter>
                        </Fill>
                    </PolygonSymbolizer>
                    <TextSymbolizer>
                        <Label>name</Label>
                        <LabelPlacement>
                            <PointPlacement>
                                <AnchorPoint>
                                    <AnchorPointX>0.5</AnchorPointX>
                                    <AnchorPointY>0.5</AnchorPointY>
                                </AnchorPoint>
                            </PointPlacement>
                        </LabelPlacement>
                        <Fill>
                            <CssParameter name="fill">#000000</CssParameter>
                        </Fill>
                    </TextSymbolizer>
                </Rule>
                <Rule>
                    <MinScaleDenominator>2600064.000000</MinScaleDenominator>
                    <MaxScaleDenominator>5200128.000000</MaxScaleDenominator>
                    <PolygonSymbolizer>
                        <Fill>
                            <CssParameter name="fill">#99b3cc</CssParameter>
                        </Fill>
                    </PolygonSymbolizer>
                    <TextSymbolizer>
                        <Label>name</Label>
                        <Font>
                            <CssParameter name="font-family">sc</CssParameter>
                            <CssParameter name="font-size">8.00</CssParameter>
                        </Font>
                        <LabelPlacement>
                            <PointPlacement>
                                <AnchorPoint>
                                    <AnchorPointX>0.5</AnchorPointX>
                                    <AnchorPointY>0.5</AnchorPointY>
                                </AnchorPoint>
                            </PointPlacement>
                        </LabelPlacement>
                        <Fill>
                            <CssParameter name="fill">#6b94b0</CssParameter>
                        </Fill>
                    </TextSymbolizer>
                </Rule>
            </FeatureTypeStyle>
        </UserStyle>
    </NamedLayer>
</StyledLayerDescriptor>