[Qgis-user] multiple csv file import

[Hugh Kelley]

Awesome thanks very much. glad I asked, you learn something new every day.

On Tue, Nov 15, 2022 at 3:19 PM David Strip <qgis-user at stripfamily.net>
wrote:

> 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.
> It's explained on the driver page.
> <https://gdal.org/drivers/vector/csv.html>  This StackExchange
> <https://gis.stackexchange.com/a/276607/4449>post shows csv to shapefile
> conversion and included Windows command line syntax for looping over files
> in a directory.
>
> On 11/15/2022 12:58 PM, Hugh Kelley wrote:
>
> David, this was my first thought when i saw this question as well.
>
> 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.
>
>  Are there arguments for ogr2ogr that can do this?
>
>
>

-- 
Hugh Kelley
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20221115/e2a6e25a/attachment.htm>