<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.apple-style-span
{mso-style-name:apple-style-span;}
span.E-MailFormatvorlage20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:419758323;
mso-list-template-ids:869432100;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:565801276;
mso-list-type:hybrid;
mso-list-template-ids:-1305840872 134676481 134676483 134676485 134676481 134676483 134676485 134676481 134676483 134676485;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DE-CH link="#0563C1" vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Hallo Wolfgang<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Perfekt, vielen Dank!<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Oder <o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Nochmals für Dummies wie mich:<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><ul style='margin-top:0cm' type=disc><li class=MsoListParagraph style='margin-left:0cm;mso-list:l1 level1 lfo3'><span style='mso-fareast-language:EN-US'>Zuerst Layer in QGIS laden aus einem Verktorfile<o:p></o:p></span></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l1 level1 lfo3'><span style='mso-fareast-language:EN-US'>Allenfalls Layer umbenennen<o:p></o:p></span></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l1 level1 lfo3'><span style='mso-fareast-language:EN-US'>Layer in die Postgres DB ziehen. Dann findet man dort den Layer mit dem spezifischen Namen<o:p></o:p></span></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l1 level1 lfo3'><span style='mso-fareast-language:EN-US'>Diesen Layer aus Postgres DB laden<o:p></o:p></span></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l1 level1 lfo3'><span style='mso-fareast-language:EN-US'>Dem geladenen Layer den Stil von urspünglichen Layer mit kopieren und einfügen dem Postgres-Layer zuweisen.<o:p></o:p></span></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l1 level1 lfo3'><span style='mso-fareast-language:EN-US'>Nun den Stil vom in QGIS geladenen Postgres-Layer exportieren. Nun findet man eine Möglichkeit den Stil mit genau dem Namen des Layers in die Postgres DB zu speichern.<o:p></o:p></span></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l1 level1 lfo3'><span style='mso-fareast-language:EN-US'>Nun alle damit verbunden Layer löschen und den Layer neu aus der Postgres DB laden.<o:p></o:p></span></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l1 level1 lfo3'><span style='mso-fareast-language:EN-US'>Dann sollte der Layer mit dem Stil daherkommen.<o:p></o:p></span></li></ul><p class=MsoListParagraph><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Und dann habe ich noch eine Vektorkarte mit über 60 Layern. Auch diese würde ich gerne mit den Stylen in der Postgres DB speichern. <o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Hat jemand einen schnelleren Weg?<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Liebe Grüsse<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Peter<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=DE>Von:</span></b><span lang=DE> wmeinolf@telecomconsult.de <wmeinolf@telecomconsult.de> <br><b>Gesendet:</b> Freitag, 4. April 2025 15:00<br><b>An:</b> peter.berger@bluewin.ch<br><b>Cc:</b> lizmap-de@lists.osgeo.org<br><b>Betreff:</b> AW: [Lizmap-de] Vektorlayer Styles in Postgis speichern: Nachtrag<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'>Hallo Peter,<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'>hab’s grade den Layer in meine Postgis DB geladen. Danach wie vorhin beschrieben, den Style auch in Postgis gespeichert. Layer gelöscht und nochmal aus Postgis geladen. Er hatte direkt den richtigen Stil. In der Datenbank gibt’s dann im Schema einen neuen Eintrag namens layer_styles. Da werden anscheinend alle Styles abgelegt.<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'>Ich hoffe, das hilft!<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'>Beste Grüße und ein schönes Wochenende<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'>Wolfgang<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=DE>Von:</span></b><span lang=DE> Wolfgang Meinolf <<a href="mailto:wmeinolf@telecomconsult.de">wmeinolf@telecomconsult.de</a>> <br><b>Gesendet:</b> Freitag, 4. April 2025 11:40<br><b>An:</b> <a href="mailto:peter.berger@bluewin.ch">peter.berger@bluewin.ch</a><br><b>Cc:</b> <a href="mailto:lizmap-de@lists.osgeo.org">lizmap-de@lists.osgeo.org</a><br><b>Betreff:</b> Re: [Lizmap-de] Vektorlayer Styles in Postgis speichern<o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=DE><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='color:black;background:white'>Moin,</span><span lang=DE><o:p></o:p></span></p><div><p class=MsoNormal><span lang=DE style='color:black;background:white'>Jetzt nochmal mit komplettem Verteiler </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=DE><o:p> </o:p></span></p><div><p class=MsoNormal><span lang=DE>Style kann man aus Qgis einfach per Export/Als QGIS-Layerstildatei speichern…in DB speichern. Im popup Fenster oben dann „in Datenquellendatenbank“ wählen und als Stilname den Layernamen eingeben. Wichtig ist, dass der Name genau dem Layernamen entspricht. <o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=DE>Beste Grüße <o:p></o:p></span></p><div><p class=MsoNormal><span lang=DE>Wolfgang Meinolf<o:p></o:p></span></p><div><p class=MsoNormal><span lang=DE><o:p> </o:p></span></p><div><p class=MsoNormal><span lang=DE>Send from my <span class=apple-style-span>Phone</span><o:p></o:p></span></p><div><p class=MsoNormal><span class=apple-style-span><span lang=DE>+49 151 1142 7451</span></span><span lang=DE><o:p></o:p></span></p></div></div></div></div></div><div><p class=MsoNormal><span lang=DE>Wolfgang Meinolf<o:p></o:p></span></p><div><p class=MsoNormal><span lang=DE><o:p> </o:p></span></p><div><p class=MsoNormal><span lang=DE>Send from my <span class=apple-style-span>Phone</span><o:p></o:p></span></p><div><p class=MsoNormal><span class=apple-style-span><span lang=DE>+49 151 1142 7451</span></span><span lang=DE><o:p></o:p></span></p></div></div></div></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=DE><o:p> </o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=DE>Am 04.04.2025 um 10:55 schrieb peter.berger--- via Lizmap-de <<a href="mailto:lizmap-de@lists.osgeo.org">lizmap-de@lists.osgeo.org</a>>:<o:p></o:p></span></p></blockquote></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal><span lang=DE><o:p></o:p></span></p><p class=MsoNormal><span lang=DE>Hallo<o:p></o:p></span></p><p class=MsoNormal><span lang=DE> <o:p></o:p></span></p><p class=MsoNormal><span lang=DE>Bin gerade am Postpass-Tool, das mich beim Vortrag in Münster sehr fasziniert hat, am Ausprobieren. Frederik Ramm hat nach meinen Kommentaren bereits eine extreme Verbesserung der Performance erreicht. Grossartiges Tool aber noch «work in progress».<o:p></o:p></span></p><p class=MsoNormal><span lang=DE> <o:p></o:p></span></p><p class=MsoNormal><span lang=DE>Und nun möchte ich wieder mal meine Styles in Postgis speichern. Wie man Verktorlayer dort speichert weiss ich. Kann man das und wie macht man es? Und wie holt man Styles wieder zurück?<o:p></o:p></span></p><p class=MsoNormal><span lang=DE> <o:p></o:p></span></p><p class=MsoNormal><span lang=DE>Gruss, Peter<o:p></o:p></span></p><p class=MsoNormal><span lang=DE> <o:p></o:p></span></p><p class=MsoNormal><span lang=DE>N.B.<o:p></o:p></span></p><p class=MsoNormal><span lang=DE> <o:p></o:p></span></p><p class=MsoNormal><span lang=DE>Postpass Beispiel nach dem Wert «sac_scale» im .hstore von OSM, ganze Schweiz zu durchforsten:<o:p></o:p></span></p><p class=MsoNormal><span lang=DE> <o:p></o:p></span></p><p class=MsoNormal><span lang=FR-CH>curl -o sacscale.geojson -g <a href="http://postpass.geofabrik.de/api/0.2/interpreter">http://postpass.geofabrik.de/api/0.2/interpreter</a> --data-urlencode "data= <o:p></o:p></span></p><p class=MsoNormal><span lang=FR-CH> SELECT wege.geom, wege.tags->>'highway' as highway,wege.tags->>'sac_scale' as sac_scale<o:p></o:p></span></p><p class=MsoNormal><span lang=FR-CH> </span><span lang=DE>FROM postpass_line wege, postpass_polygon schweiz<o:p></o:p></span></p><p class=MsoNormal><span lang=DE> WHERE wege.tags?'highway' AND wege.tags?'sac_scale'<o:p></o:p></span></p><p class=MsoNormal><span lang=DE> AND schweiz.osm_id=51701 and schweiz.osm_type='R'<o:p></o:p></span></p><p class=MsoNormal><span lang=DE> AND st_contains(schweiz.geom, wege.geom)"<o:p></o:p></span></p><p class=MsoNormal><span lang=DE> <o:p></o:p></span></p><p class=MsoNormal><span lang=DE> <o:p></o:p></span></p><p class=MsoNormal><span lang=FR-CH>-- <br>Lizmap-de mailing list<br></span><span lang=DE><a href="mailto:Lizmap-de@lists.osgeo.org"><span lang=FR-CH>Lizmap-de@lists.osgeo.org</span></a></span><span lang=FR-CH><br></span><span lang=DE><a href="https://lists.osgeo.org/mailman/listinfo/lizmap-de"><span lang=FR-CH>https://lists.osgeo.org/mailman/listinfo/lizmap-de</span></a></span><span lang=FR-CH><o:p></o:p></span></p></div></blockquote></div></div></body></html>