<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hey Julierme,<div class=""><br class=""></div><div class="">am I correct that you´re using the geoserver css extension?</div><div class="">Can you supply the generated sld?</div><div class=""><br class=""></div><div class="">Further the output of:</div><div class=""><br class=""></div><div class="">$ ll ./geoserver/data/styles/sunny.svg</div><div class=""><br class=""></div><div class="">Further I think the mime type in sld for svg is</div><div class=""><Format>image/svg+xml" </Format></div><div class=""><br class=""></div><div class="">your could try</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>mark-mime: "image/svg+xml"</div><div class="">(unsure about this just a shot in the dark)</div><div class=""><br class=""></div><div class="">Cheers, </div><div class="">Toni</div><div class=""><br class=""><div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class="">-----------------------------------------------</div><div class="">CSGIS</div><div class=""><br class=""></div><div class="">-----------------------------------------------</div><div class=""><div class="" style="orphans: 2; widows: 2;">Kolonnadenstraße 1</div><div class="" style="orphans: 2; widows: 2;">04109 Leipzig</div></div><div class="">-----------------------------------------------</div><div class="">Tel <span class="Apple-tab-span" style="white-space: pre;"> </span>+49/ (0) 341 24 04 738</div><div class="">Fax <span class="Apple-tab-span" style="white-space: pre;"> </span>+49/ (0) 341 24 04 739</div><div class="">Web<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="http://csgis.de" class="">http://csgis.de</a></div><div class="">-----------------------------------------------</div><div class=""><br class=""></div><div class="">Hinweis gemäß § 33 BDSG</div><div class="">Daten der Verfahrensbeteiligten werden gespeichert. Dieses Dokument ist ausschließlich für den </div><div class="">Adressaten bestimmt. Der Inhalt der E-Mail ist vertraulich. Falls Sie diese E-Mail versehentlich </div><div class="">erhalten haben, rufen Sie uns unter obiger Rufnummer umgehend an und löschen Sie diese Nachricht </div><div class="">von Ihrem Computer. Jegliche Art von Reproduktionen, Verbreitung, Vervielfältigung, Veränderung, </div><div class="">Verteilung und/oder Veröffentlichung dieser E-Mail ist verboten.</div></div></div></div></div></div></div>
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">Am 21.01.2019 um 16:51 schrieb Julierme Pinheiro <<a href="mailto:juliermeopensourcedeveloper@gmail.com" class="">juliermeopensourcedeveloper@gmail.com</a>>:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div class="">Dear Jorge and Toni,</div><div class=""><br class=""></div><div class="">Thank you very much for your reply. <br class=""></div><div class=""><br class=""></div><div class="">I have a table (db_brasilia_weather) in postgis. The table db_brasilia_weather has two attributes: weather and url_image. weather attribute has integer values of weather status and url_image attribute: the path for the weather images cloudy.svg, thunder.svg, sunny.svg, rainy.svg.</div><div class=""><br class=""></div><div class="">db_brasilia_weather</div><div class=""><br class=""></div><div class="">id weather url_image</div><div class="">1 0 sunny.svg<br class=""></div><div class="">2 5 thunder.svg</div><div class="">3 1 rainy.svg</div><div class=""><br class=""></div><div class="">*.svg images are stored in /webapps/geoserver/data/styles</div><div class=""><br class=""></div><div class="">Based on the information, Creating Point Styles in [1] and Item 3.4.2 about Graphic in [2], I created the following CSS (geonode.css) file:</div><div class=""><br class=""></div><div class="">* {<br class=""> mark: symbol('circle');<br class=""> mark-size: 5;<br class="">}<br class=""><br class="">:mark {<br class=""> fill: cyan;<br class=""> stroke: darkblue;<br class="">}<br class=""><br class="">[weather = 0] {<br class=""> mark: url(./geoserver/data/styles/sunny.svg);<br class=""> mark-mime: "image/svg";<br class=""> mark-size: 100;<br class="">}<br class=""></div><div class="">I have tried mark: url(sunny.svg), url("./geoserver/data/styles/sunny.svg"), but none of these configuration have been successful.</div><div class=""><br class=""></div><div class="">Any additional comment on this matter will be very appreciated.</div><div class=""><br class=""></div><div class="">Thank you very much for your time in advance.</div><div class=""><br class=""></div><div class="">Kind Regards</div><div class=""><br class=""></div><div class="">Julierme<br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">[1] <a href="http://docs.geonode.org/en/master/tutorials/advanced/adv_data_mgmt/pretty_maps/css.html#creating-point-styles" class="">http://docs.geonode.org/en/master/tutorials/advanced/adv_data_mgmt/pretty_maps/css.html#creating-point-styles</a><br class=""></div><div class="">[2] <a href="https://docs.geoserver.org/stable/en/user/styling/workshop/css/point.html" class="">https://docs.geoserver.org/stable/en/user/styling/workshop/css/point.html</a></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div></div></div></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail-m_-883359080895201821gmail_attr">On Sun, Jan 20, 2019 at 5:53 AM Toni Schönbuchner <<a href="mailto:toni.schoenbuchner@csgis.de" target="_blank" class="">toni.schoenbuchner@csgis.de</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Julierme,<br class="">
<br class="">
I don´t think you can access a postgis entity directly from SLD.<br class="">
The Point Symbolizer allows external graphics as mark or ressource.<br class="">
<a href="https://docs.geoserver.org/stable/en/user/styling/sld/reference/pointsymbolizer.html#externalgraphic" rel="noreferrer" target="_blank" class="">https://docs.geoserver.org/stable/en/user/styling/sld/reference/pointsymbolizer.html#externalgraphic</a><br class="">
Where an external ressource could also be identified as URL.<br class="">
<br class="">
Means you could add the SVG to your static root or in some other public<br class="">
directory or even dropbox and use it as symbol. As alternative it should work<br class="">
to specific a relative path outside of the data dir where tomcat is allowed to read <br class="">
from. With second linking to the file gets harder. <br class="">
<br class="">
May I ask you why the svg should be stored in the database? – unsure if there<br class="">
is some better way but for sure you could just create a django view to output<br class="">
the svg from postgres and use it like this in your sld. <br class="">
<br class="">
Cheers,<br class="">
<br class="">
Toni<br class="">
<br class="">
> Today's Topics:<br class="">
> <br class="">
> 1. Re: GeoNode Layer Style Weather Symbols and Web Links<br class="">
> (Julierme Pinheiro)<br class="">
> <br class="">
> <br class="">
> ----------------------------------------------------------------------<br class="">
> <br class="">
> Message: 1<br class="">
> Date: Fri, 18 Jan 2019 18:59:40 -0200<br class="">
> From: Julierme Pinheiro <<a href="mailto:juliermeopensourcedeveloper@gmail.com" target="_blank" class="">juliermeopensourcedeveloper@gmail.com</a>><br class="">
> To: geonode-users <<a href="mailto:geonode-users@lists.osgeo.org" target="_blank" class="">geonode-users@lists.osgeo.org</a>><br class="">
> Subject: Re: [GeoNode-users] GeoNode Layer Style Weather Symbols and<br class="">
> Web Links<br class="">
> Message-ID:<br class="">
> <CAKTKyJK9dtC9MX_QHHH+bJvswgBzcC=<a href="mailto:BPOwodR840KZLPoZ0aA@mail.gmail.com" target="_blank" class="">BPOwodR840KZLPoZ0aA@mail.gmail.com</a>><br class="">
> Content-Type: text/plain; charset="utf-8"<br class="">
> <br class="">
> Hi GeoNode users,<br class="">
> <br class="">
> Regarding my previous email, looking at GeoServer documentation<br class="">
> <<a href="https://docs.geoserver.org/stable/en/user/styling/sld/extensions/pointsymbols.html#external-graphics" rel="noreferrer" target="_blank" class="">https://docs.geoserver.org/stable/en/user/styling/sld/extensions/pointsymbols.html#external-graphics</a>>,<br class="">
> I got the piece of SLD bellow, but burg02.svg is being retrieved from<br class="">
> $GEOSERVER_DATA_DIR/styles.<br class="">
> <br class="">
> I would like to have:<br class="">
> 1 - burg02.svg being retrieved from a postgres table;<br class="">
> 2 - make a webpage link on burg02.svg through the SLD file<br class="">
> <br class="">
> <br class="">
> <PointSymbolizer><br class="">
> <Graphic><br class="">
> <ExternalGraphic><br class="">
> <OnlineResource xlink:type="simple" xlink:href="burg02.svg" /><br class="">
> <Format>image/svg+xml</Format><br class="">
> </ExternalGraphic><br class="">
> <Size>20</Size><br class="">
> </Graphic><br class="">
> </PointSymbolizer><br class="">
> <br class="">
> <br class="">
> Any hint on that will be very appreciated.<br class="">
> <br class="">
> Kind regards<br class="">
> <br class="">
> Julierme<br class="">
<br class="">
</blockquote></div>
</div></blockquote></div><br class=""></div></body></html>