[mapserver-users] Using SLD and WMS with data comming from postgres

[Adrien Ducos]

Hi I would like to use an SLD file linked to a wms layer comming from a
postgres query (using postgis).

In the SLD file I have rules that puts polygon colors according to an
attribute in my table the attribute data can be equal to 1,2,3,4,5,6,7 or 8.
and according to the value the polygon would be 1=red, 2=yellow, 1=blue etc.

I use a mapfile to retrieve the query:

Here is the layer part of the mapfile

 LAYER
    NAME "buildings"
    TYPE POLYGON
    STATUS OFF
    CONNECTION "dbname=... user=... password=... host=..."
    CONNECTIONTYPE postgis
    DATA "the_geom_polygon from (select id_imm, max(the_geom_polygon) as
the_geom_polygon, MAX(id_building_type) as color FROM imm_type group by
id_imm) as t USING UNIQUE id_imm USING SRID = -1"
    METADATA
        "wms_name" "buildings"
        "wms_server_version" "1.1.0"
        "wms_format" "image/png"
        "wms_exceptions_format" "application-vnd.ogc.se_inimage"
        "wms_transparent" "false"
    END
    PROJECTION
        "init=epsg:27582"
    END
END


Then I call this layer via a webservice with the link of the sld :

http://www.mysite/wmsExportMap.php?REQUEST=GetMap&VERSION=1.1.0&SERVICE=WMS&LAYERS=fond_wms,buildings&SLD=http://www.mysite/sld/buildings.sld&bbox=600477.507312,2424357.1016,605865.696562,2426763.76972&width=450&height=260

in wmsExportMap.php I use $request = ms_newowsrequestobj(); to get a WMS map
via a web service.

When I do this query I get the map I want except the the SLD does not work

the sld looks like :

<?xml version="1.0" encoding="UTF-8"?>
<sld:StyledLayerDescriptor version="1.0.0" xmlns:sld="
http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc"
xmlns:gml="http://www.opengis.net/gml" 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">
  <sld:NamedLayer>
    <sld:Name>buildings</sld:Name>
    <sld:UserStyle>
      <sld:Name>Default Styler</sld:Name>
      <sld:Title>Default Styler</sld:Title>
      <sld:Abstract/>
      <sld:IsDefault>1</sld:IsDefault>
      <sld:FeatureTypeStyle>
        <sld:Name>testStyleName</sld:Name>
        <sld:Title>title</sld:Title>
        <sld:Abstract>abstract</sld:Abstract>
        <sld:FeatureTypeName>Feature</sld:FeatureTypeName>

<sld:SemanticTypeIdentifier>generic:geometry</sld:SemanticTypeIdentifier>
        <sld:Rule>
          <sld:Name>color1</sld:Name>
          <sld:Title>title</sld:Title>
          <sld:Abstract>Abstract</sld:Abstract>
          <ogc:Filter>
            <ogc:PropertyIsEqualTo>
              <ogc:PropertyName>color</ogc:PropertyName>
              <ogc:Literal>1</ogc:Literal>
            </ogc:PropertyIsEqualTo>
          </ogc:Filter>
          <sld:PolygonSymbolizer>
            <sld:Fill>
              <sld:CssParameter name="fill">#ff0f13</sld:CssParameter>
            </sld:Fill>
          </sld:PolygonSymbolizer>
        </sld:Rule>
        <sld:Rule>
          <sld:Name>color2</sld:Name>
          <sld:Title>title</sld:Title>
          <sld:Abstract>Abstract</sld:Abstract>
          <ogc:Filter>
            <ogc:PropertyIsEqualTo>
              <ogc:PropertyName>color</ogc:PropertyName>
              <ogc:Literal>2</ogc:Literal>
            </ogc:PropertyIsEqualTo>
          </ogc:Filter>
          <sld:PolygonSymbolizer>
            <sld:Fill>
              <sld:CssParameter name="fill">#ff9900</sld:CssParameter>
            </sld:Fill>
          </sld:PolygonSymbolizer>
        </sld:Rule>
        <sld:Rule>
...



If I set no condition parameters in my sld, however it works fine (but then
the buildings on my map are all of the same color) so I know the sld file is
well linked to the WMS file. in addition, then I link with the above sld, I
can see that postgres asks for the color field which is the propertyName I
want to use, but still the buildings don't get the desired color.

Does someone have some problems like this? Is it possible to do this kink of
things via mapserver?

Thanks in advance
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080529/88540745/attachment.htm>