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

[Yewondwossen Assefa]

Adrien

  You should be able to use the sld with filter. Looking at your sld, 
you should end up with several classes where the expressions in each 
class should be set to something like EXPRESSION ([color] = 1), 
EXPRESSION ([color] = 2). Would these expressions be valid in your case 
(with your data)?
  As a note, you can also check 
http://trac.osgeo.org/mapserver/ticket/2573  and 
http://trac.osgeo.org/mapserver/ticket/2635 that might give you hints on 
what is going on.

Y.A.

Adrien Ducos wrote:
> 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 
> <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
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users


-- 
----------------------------------------------------------------
Assefa Yewondwossen
Software Analyst

Email: assefa at dmsolutions.ca
http://www.dmsolutions.ca/

Phone: (613) 565-5056 (ext 14)
Fax:   (613) 565-0925
----------------------------------------------------------------