<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta content="text/html;charset=UTF-8" http-equiv="Content-Type"></head><body ><div style='font-size:10pt;font-family:Verdana,Arial,Helvetica,sans-serif;'>Hi Richard,<br><br>> I would welcome the opportunity to join the hackathon. Is there any further details on this, Date, Time virtual access portal? Im afraid, I would have to virtually attend.<br>See: https://wiki.osgeo.org/wiki/FOSS4G_2016_Code_Sprint#GeoTools.2FGeoServer<br><br>20th and 21st of August. For virtual participation: - I'm not sure what venue they plan on using. Andrea may be able to advise (cc'd)<br><br>Cheers,<br>Jonathan<br><div class="zmail_extra"><div id="1"><br>---- On Tue, 19 Jul 2016 15:34:32 +0100 <b>Richard McDonnell<richard.mcdonnell@opw.ie></b> wrote ---- <br></div><blockquote style="border-left: 1px solid #0000FF; padding-left: 6px; margin:0 0 0 5px"><meta> <div> Ok,<br> Not quite sure what you are looking for, but If I have your gist. <br> I have done some work on a OSM Dataset for Ireland, both styled in QGIS and in Geoserver.<br> The dataset is stored as a PostGIS database and served on Geoserver. So I would have examples of how I replicated styling on both.<br> <br> I could provide a dump of the database, which also has the styling for QGIS saved as a table, and a copy of the SLD files for Geoserver.<br> <br> You may have some difficulty with the symbology though on the GeoServer Side, even though I used QGIS Symbols we have them served centrally so as they can be accessed by geoserver.<br> The SLD's for GeoServer where created a while ago, and I was still learning so they may be a little messy. I also have little to no experience in programming....<br> <br> I could also give examples of other issues I have come across, along with my solutions to these.<br> <br> As a topic of discussion though, the biggest issue at present is labels, QGIS SLD'd don't save labels, I found that to be the most tricky part of styling to date. Also the use of attributes in the styling, for example, having a text rotation and size attribute, I have examples of this also, but wont be able to provide data, as its commercially sensitive and we don't own the dataset ourselves.<br> <br> I would welcome the opportunity to join the hackathon. Is there any further details on this, Date, Time virtual access portal? Im afraid, I would have to virtually attend.<br> Regards,<br> <br> Richard.<br> <br> <br> <div>On 19/07/2016 13:46, Luigi Pirelli wrote:<br> </div> <blockquote> <div>Hi Richard <div><br> </div> <div>can you prepare a test case that have to be solved pusching somewhere? I mean</div> <div>a</div> <div>1) base layer</div> <div>2) a workflow to have it in geoserver and qgis (a qgs project)<br> </div> <div>3) the expected rendering in QGIS and/or Geoserver (images)</div> <div>4) specify versions for geoserver and qgis</div> <div>5) any additional data (e.g sld or qml) with workflow to replicate your experience</div> <div><br> </div> <div>in this way you can help to target punctual problems if a general solution can't be found.</div> <div><br> </div> <div>As Richard said, please feel free to join to the "hackaton" in Bonn, remotely or live.</div> <div><br> </div> <div>cheers</div> </div> <div><br> <div> <div>Luigi Pirelli<br> <br> **************************************************************************************************<br> * Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com<br> * LinkedIn: <a rel="noreferrer" href="https://www.linkedin.com/in/luigipirelli" target="_blank">https://www.linkedin.com/in/luigipirelli</a><br> * Stackexchange: <a rel="noreferrer" href="http://gis.stackexchange.com/users/19667/luigi-pirelli" target="_blank">http://gis.stackexchange.com/users/19667/luigi-pirelli</a><br> * GitHub: <a rel="noreferrer" href="https://github.com/luipir" target="_blank">https://github.com/luipir</a><br> * Mastering QGIS: <a rel="noreferrer" href="https://www.packtpub.com/application-development/mastering-qgis" target="_blank">https://www.packtpub.com/application-development/mastering-qgis</a><br> **************************************************************************************************</div> </div> <br> <div>On 19 July 2016 at 13:48, Richard McDonnell <span><<a subj="" mailid="richard.mcdonnell%40opw.ie" rel="noreferrer" href="mailto:richard.mcdonnell@opw.ie" target="_blank">richard.mcdonnell@opw.ie</a>></span> wrote:<br> <blockquote style="margin: 0 0 0 0.8ex;border-left: 1.0px rgb(204,204,204) solid;padding-left: 1.0ex;"> <div> <p class="MsoNormal"><big>Hello all,</big></p> <p class="MsoNormal"><big>Ok, I have been looking at this for a while, and I think I have it nailed down pretty well.<br> There has been some issues with using QGIS SLD's in Geoserver. <br> The following should enable you to utilise the styling power of QGIS and make it compatible with Geoserver<br> </big></p> <p class="MsoNormal"><big>In the main, this process only works for geometry, and will not work for styling text it may require some additional tweaking here and there also.</big></p> <big> </big> <p class="MsoNormal"><big>Firstly, style your layer the way you want.</big></p> <big> </big> <p class="MsoNormal"><big>Next save your style as a SLD.</big></p> <big> </big> <p class="MsoNormal"><big>Open the SLD in Notepad++ or other text editor</big></p> <big> </big> <p class="MsoNormal"><big>Create a new blank text document and use the following as a template:</big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><?xml version="1.0" encoding="ISO-8859-1"?></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><StyledLayerDescriptor version="1.0.0" </span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><span> </span>xsi:schemaLocation=<a rel="noreferrer" href="http://www.opengis.net/sldStyledLayerDescriptor.xsd" target="_blank"></a><a rel="noreferrer" href="http://www.opengis.net/sldStyledLayerDescriptor.xsd" target="_blank">"http://www.opengis.net/sld StyledLayerDescriptor.xsd"</a> </span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><span> </span>xmlns=<a rel="noreferrer" href="http://www.opengis.net/sld" target="_blank"></a><a rel="noreferrer" href="http://www.opengis.net/sld" target="_blank">"http://www.opengis.net/sld"</a> </span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><span> </span>xmlns:ogc=<a rel="noreferrer" href="http://www.opengis.net/ogc" target="_blank"></a><a rel="noreferrer" href="http://www.opengis.net/ogc" target="_blank">"http://www.opengis.net/ogc"</a> </span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><span> </span>xmlns:xlink=<a rel="noreferrer" href="http://www.w3.org/1999/xlink" target="_blank"></a><a rel="noreferrer" href="http://www.w3.org/1999/xlink" target="_blank">"http://www.w3.org/1999/xlink"</a> </span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><span> </span>xmlns:xsi=<a rel="noreferrer" href="http://www.w3.org/2001/XMLSchema-instance" target="_blank"></a><a rel="noreferrer" href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">"http://www.w3.org/2001/XMLSchema-instance"</a>></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><NamedLayer></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><Name>YourLayerName</Name></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><UserStyle></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><Title>YourLayerTitle</Title></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><FeatureTypeStyle><span> </span></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><span> </span><!-- Start --></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><!-- COPY AND PASTE QGIS SLD CODE BETWEEN <FeatureTypeStyle> and </FeatureTypeStyle> IN HERE--></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><span> </span><!-- End --> <span> </span><span> </span></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><span> </span></FeatureTypeStyle></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><span> </span></UserStyle></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><span> </span></NamedLayer></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big><b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"></StyledLayerDescriptor></span></i></b></big></p> <big> </big> <p class="MsoNormal"><big>Copy the code between but excluding <FeatureTypeStyle> and </FeatureTypeStyle> and paste it into the new document overwriting <b><i><span style="font-size: 8.0pt;line-height: 107.0%;color: rgb(0,112,192);"><!-- COPY AND PASTE QGIS SLD CODE BETWEEN <FeatureTypeStyle> and </FeatureTypeStyle> IN HERE--> </span></i></b></big></p> <big> </big> <p class="MsoNormal"><big>Find and replace the following:</big></p> <big> </big> <p><big><span style="font-family: Symbol;"><span>·<span style="font: 7.0pt 'Times New Roman';"> </span></span></span><b><i>se:</i></b> with nothing (effectively deleting it) so for example where you have <se:Rule> it becomes <Rule> </big></p> <big> </big> <p><big><span style="font-family: Symbol;"><span>·<span style="font: 7.0pt 'Times New Roman';"> </span></span></span><b><i><ogc:Filter xmlns:ogc=<a rel="noreferrer" href="http://www.opengis.net/ogc" target="_blank">"http://www.opengis.net/ogc"</a>> </i></b>with <b><i><ogc:Filter></i></b></big></p> <big> </big> <p><big><span style="font-family: Symbol;"><span>·<span style="font: 7.0pt 'Times New Roman';"> </span></span></span>Delete all instances of <b><i><Description>…..</Description></i></b> inclusive of everything in between (usually a Title)</big></p> <big> </big> <p><big><span style="font-family: Symbol;"><span>·<span style="font: 7.0pt 'Times New Roman';"> </span></span></span><b>SvgParameter </b>with </big><b><big>CssParameter</big><br> <br> </b></p> One other thing where you utilise Map units (meters, feet or pixel) in your styling you will have to use the following examples shown in the link below<br> <br> <a rel="noreferrer" href="http://docs.geoserver.org/latest/en/user/styling/sld-extensions/uom.html" target="_blank">http://docs.geoserver.org/latest/en/user/styling/sld-extensions/uom.html</a><br> <br> I would ask the question, would it be possible to create a simple Geoserver Style using what I have found above?? adding an option to save the QGIS style using the above rules?<br> <br> If anyone has any questions or needs any clarification let me know, If I can help I will.<br> <br> Regards,<br> <br> Richard McDonnell<br> <br> <br> <br> <div style="font-family: Arial;font-size: 8.0pt;"> OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart<br> OPW - Looking to the future - Caring for the past<br> <a rel="noreferrer" href="http://www.opw.ie/" target="_blank"><img min-height="76" width="494"></a><br> Email Disclaimer: <a rel="noreferrer" href="http://www.opw.ie/en/disclaimer/" target="_blank">http://www.opw.ie/en/disclaimer/</a> </div> </div> <br> _______________________________________________<br> Qgis-user mailing list<br> <a subj="" mailid="Qgis-user%40lists.osgeo.org" rel="noreferrer" href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br> List info: <a rel="noreferrer" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br> Unsubscribe: <a rel="noreferrer" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br> </blockquote> </div> <br> </div> </blockquote> <br> <div>-- <br> <b><u>Richard McDonnell</u></b><br> <b><small><small><small>GIS Specialist PgD GIS AssocSCSI</small></small></small></b><br> <b><small>OPW FRM Data Management</small></b><br> <b><small>52 Stephens Green, Dublin 2.</small></b><br> <small><small>TEL: 01 6476543</small></small></div> _______________________________________________<br>Qgis-user mailing list<br><a subj="" mailid="Qgis-user%40lists.osgeo.org" rel="noreferrer" href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>List info: <a rel="noreferrer" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a rel="noreferrer" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></div></blockquote><br></div><br></div></body></html>