<div dir="ltr">This is really a question for the GeoServer Users list, so you may wish to post there. But here's a rough reply:<div><br></div><div>1) I believe that in GeoServer shapefiles are somewhat faster, but if you already have the data in PostGIS for data management reasons it's probably better to access it there directly</div>
<div><br></div><div>2) Yes, this kind of thematic (chloropleth) styling is done in SLD. There are a couple of ways of doing this:</div><div>a) use SLD rules, as in this example: <a href="http://docs.geoserver.org/stable/en/user/styling/sld-cookbook/polygons.html#attribute-based-polygon">http://docs.geoserver.org/stable/en/user/styling/sld-cookbook/polygons.html#attribute-based-polygon</a></div>
<div>b) use the Categorize function in SLD, as shown here: <a href="http://docs.geoserver.org/stable/en/user/styling/sld-tipstricks/transformation-func.html#categorize">http://docs.geoserver.org/stable/en/user/styling/sld-tipstricks/transformation-func.html#categorize</a></div>
<div><br></div><div>An advantage of (a) is that you can then generate an appropriate legend too.</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Nov 18, 2013 at 6:05 AM, Diego Roberto <span dir="ltr"><<a href="mailto:diegorrborges@yahoo.com.br" target="_blank">diegorrborges@yahoo.com.br</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-size:12pt;font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif"><div>
<font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px">Hello ,</span></font></div><div><font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px">I am working on a project that shows statistical information about the state . Among these statistics need to show for instance the cities that stand out in an industry with percentage ranges . Example :</span></font></div>
<div><font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px">Agricultural sector in the state of Goiás in Brazil will have to show painted the municipalities of colors according to the percentage
.</span></font></div><div><ul><li><span style="line-height:16px;color:rgb(63,63,63);font-family:'Helvetica Neue',Helvetica,Arial,san-serif,Roboto;font-size:13px">100-81 % - Dark Blue</span><br></li><li><span style="line-height:16px;color:rgb(63,63,63);font-family:'Helvetica Neue',Helvetica,Arial,san-serif,Roboto;font-size:small">80-51 % - Light Blue</span><br>
</li><li><span style="line-height:16px;color:rgb(63,63,63);font-family:'Helvetica Neue',Helvetica,Arial,san-serif,Roboto;font-size:small">50-21 % - Gray</span><br></li><li><span style="line-height:16px;color:rgb(63,63,63);font-family:'Helvetica Neue',Helvetica,Arial,san-serif,Roboto;font-size:small">20-0 % - white</span><br>
</li></ul></div><div><font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px">Below is a picture showing more or less this:
<a href="http://www.4shared.com/download/Slpq6Wbr/mapa.jpg" target="_blank">http://www.4shared.com/download/Slpq6Wbr/mapa.jpg</a></span></font></div><div><font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px"><br>
</span></font></div><div><font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px">I have a shapefile from around the state with geographic information , as well as the same information in the database PostgreSQL + PostGIS .</span></font></div>
<div><font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px">I'm working with files with Geoserver SLD to paint municipalities .</span></font></div><div><font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px"><br>
</span></font></div><div><font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px">I have two questions to work with this information :</span></font></div><div><font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px">1 ) What is the best way to work in a matter of processing. A shapefile is imported into GeoServer or pointing a table from the database in GeoServer ?</span></font></div>
<div><font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px">2 ) This way of working to create the style SLD in GeoServer and assign eg dark blue if the municipality is within the range 100-81 % believe the correct way to work ?</span></font></div>
<div><font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px"><br></span></font></div><div><font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px">I thank you for your attention.</span></font></div>
<span class="HOEnZb"><font color="#888888"><div><font color="#3f3f3f" face="Helvetica Neue, Helvetica, Arial, san-serif, Roboto"><span style="line-height:16px">Diego.</span></font></div></font></span></div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.osgeo.org">Users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/openlayers-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/openlayers-users</a><br></blockquote></div><br></div>