<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div dir="ltr"></div><div dir="ltr">I found this on line :</div><div dir="ltr"><pre class="lang-py s-code-block" style="color: var(--highlight-color); -webkit-text-size-adjust: auto; margin-top: 0px; margin-bottom: calc(var(--s-prose-spacing) + 0.4em); padding: var(--su12); border: 0px; font-family: var(--ff-mono); font-stretch: inherit; line-height: var(--lh-md); font-size: var(--fs-body1); vertical-align: baseline; box-sizing: inherit; width: auto; max-height: 600px; overflow: auto; border-radius: var(--br-md); overflow-wrap: normal;"><code class="hljs language-python" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: var(--fs-body1); vertical-align: baseline; box-sizing: inherit; white-space: inherit;"><span class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-keyword);"><br></span></code></pre><pre class="lang-py s-code-block" style="color: var(--highlight-color); -webkit-text-size-adjust: auto; margin-top: 0px; margin-bottom: calc(var(--s-prose-spacing) + 0.4em); padding: var(--su12); border: 0px; font-family: var(--ff-mono); font-stretch: inherit; line-height: var(--lh-md); font-size: var(--fs-body1); vertical-align: baseline; box-sizing: inherit; width: auto; max-height: 600px; overflow: auto; border-radius: var(--br-md); overflow-wrap: normal;"><code class="hljs language-python" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: var(--fs-body1); vertical-align: baseline; box-sizing: inherit; white-space: inherit;"><span class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-keyword);">import</span> glob, os
<span class="hljs-comment" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-comment);"># Define path to directory of your csv files</span>
path_to_csv = <span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-variable);">"C:/File Path/"</span>
<span class="hljs-comment" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-comment);"># Set current directory to path of csv files</span>
os.chdir(path_to_csv)
<span class="hljs-comment" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-comment);"># Find each .csv file and load them as vector layers</span>
<span class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-keyword);">for</span> fname <span class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-keyword);">in</span> glob.glob(<span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-variable);">"*.csv"</span>):
uri =<span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-variable);">"file:///"</span>+path_to_csv + fname+<span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-variable);">"encoding=%s&delimiter=%s&xField=%s&yField=%s&crs=%s"</span> % (<span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-variable);">"UTF-8"</span>,<span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-variable);">","</span>, <span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-variable);">"Long"</span>, <span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-variable);">"Lat"</span>,<span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-variable);">"epsg:4326"</span>)
name=fname.replace(<span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-variable);">'.csv'</span>, <span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-variable);">''</span>)
lyr = QgsVectorLayer(uri, name, <span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: 13px; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-variable);">'delimitedtext'</span>)
QgsProject.instance().addMapLayer(lyr)</code></pre><pre class="lang-py s-code-block" style="color: var(--highlight-color); -webkit-text-size-adjust: auto; margin-top: 0px; margin-bottom: calc(var(--s-prose-spacing) + 0.4em); padding: var(--su12); border: 0px; font-family: var(--ff-mono); font-stretch: inherit; line-height: var(--lh-md); font-size: var(--fs-body1); vertical-align: baseline; box-sizing: inherit; width: auto; max-height: 600px; overflow: auto; border-radius: var(--br-md); overflow-wrap: normal;"><code class="hljs language-python" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: var(--fs-body1); vertical-align: baseline; box-sizing: inherit; white-space: inherit;"><br></code></pre><pre class="lang-py s-code-block" style="color: var(--highlight-color); -webkit-text-size-adjust: auto; margin-top: 0px; margin-bottom: calc(var(--s-prose-spacing) + 0.4em); padding: var(--su12); border: 0px; font-family: var(--ff-mono); font-stretch: inherit; line-height: var(--lh-md); font-size: var(--fs-body1); vertical-align: baseline; box-sizing: inherit; width: auto; max-height: 600px; overflow: auto; border-radius: var(--br-md); overflow-wrap: normal;"><code class="hljs language-python" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-stretch: inherit; line-height: inherit; font-size: var(--fs-body1); vertical-align: baseline; box-sizing: inherit; white-space: inherit;">but it doesn’t work. I have csv files with lat long and value separated by space and without header </code></pre></div><div dir="ltr"><br><blockquote type="cite">Il giorno 15 nov 2022, alle ore 21:22, Hugh Kelley <hghklly@gmail.com> ha scritto:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><div dir="ltr">Awesome thanks very much. glad I asked, you learn something new every day.<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Nov 15, 2022 at 3:19 PM David Strip <<a href="mailto:qgis-user@stripfamily.net">qgis-user@stripfamily.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div>Starting with v2.1, ogr2ogr supports
args X_POSSIBLE_NAMES, Y_POSSIBLE_NAMES which are strings with
allowed wildcards (eg, Lon* ), or you can use field_1, field_2,
etc to explicitly give the position of lat/lon.<br>
It's explained on the <a href="https://gdal.org/drivers/vector/csv.html" target="_blank">driver page.</a>
This <a href="https://gis.stackexchange.com/a/276607/4449" target="_blank">StackExchange
</a>post shows csv to shapefile conversion and included Windows
command line syntax for looping over files in a directory.<br>
<br>
On 11/15/2022 12:58 PM, Hugh Kelley wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>David, this was my first thought when i saw this question
as well.</div>
<div><br>
</div>
<div>however, I didn't look for very long but I haven't seen a
way to tell ogr2ogr to read columns in a csv as the lat/lon
and write those as points to the shapefile. I generally write
a csv to postgres as a non-spatial table and then process the
lat lon columns with postgis. <br>
</div>
<div><br>
</div>
<div> Are there arguments for ogr2ogr that can do this?</div>
</div>
</blockquote>
<br>
</div>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr">Hugh Kelley <br><div><br></div></div></div></div></div></div></div></div>
</div></blockquote></body></html>