<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi Paul,</p>
<p>ogr2ogr usually doesn't care much about styling, unless you use ogr feature styles:</p>
<p><a href="https://svn.osgeo.org/gdal/trunk/gdal/ogr/ogr_feature_style.html">https://svn.osgeo.org/gdal/trunk/gdal/ogr/ogr_feature_style.html</a></p>
<p>Or you use QGIS 3.10* which has a nice GeoPDF export built in. But if you want to automate things, I understand that the automated solution might be better for your workflow.</p>
<p>*Disclaimer: QGIS 3.10 must be compiled with GDAL >= 3.0 and proj6, which as far as I know is currently not the case for QGIS Windows standalone builds. See also <a href="https://gis.stackexchange.com/questions/340030/create-geospatial-pdf-geopdf-is-greyed-out-in-pdf-export-options-in-qgis-3-10">https://gis.stackexchange.com/questions/340030/create-geospatial-pdf-geopdf-is-greyed-out-in-pdf-export-options-in-qgis-3-10</a></p>
<p>Greetings,</p>
<p>Andreas</p>
<p id="reply-intro">On 2019-11-11 08:28, paul.malm@lfv.se wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<div> </div>
</blockquote>
</blockquote>
<style type="text/css">@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
#replybody1 p.v1MsoNormal, #replybody1 li.v1MsoNormal, #replybody1 div.v1MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
#replybody1 a:link, #replybody1 span.v1MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
#replybody1 a:visited, #replybody1 span.v1MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
#replybody1 span.v1E-postmall17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
#replybody1 .v1MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
#replybody1 div.v1WordSection1
{page:WordSection1;}</style>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<div id="replybody1">
<div lang="SV">
<div class="v1WordSection1">
<p class="v1MsoNormal"><span>Hi list,</span></p>
<p class="v1MsoNormal"><span>I have a question on how to export a PDF file from PostGIS with a color on the lines instead of the default black lines. I have searched on the internet but have not reached all the way…</span></p>
<p class="v1MsoNormal"><span>I have 2 tables that I would like to export into test.pdf (rivers and roads)</span></p>
<p class="v1MsoNormal"><span>ogr2ogr -f "PDF" c:\Temp\test.pdf PG:"host=xxx.xxx.xxx.x user=yyyy dbname=testdb password=pwd" rivers roads</span></p>
<p class="v1MsoNormal"><span> </span></p>
<p class="v1MsoNormal"><span>I would, for instance set like to set line width to 1 px and color to 4040FF on rivers,</span></p>
<p class="v1MsoNormal"><span>Width 3 px and color FF4040 on roads.</span></p>
<p class="v1MsoNormal"><span> </span></p>
<p class="v1MsoNormal"><span>Thanks, </span></p>
<p class="v1MsoNormal"><span>Paul</span></p>
</div>
</div>
</div>
<br />
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">_______________________________________________<br />gdal-dev mailing list<br /><a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br /><a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a></div>
</blockquote>
<p><br /></p>
</body></html>