See the X_POSSIBLE_NAMES and Y_POSSIBLE_NAMES open options of the CSV
driver mentioned at https://gdal.org/drivers/vector/csv.html#open-options
and the last example of https://gdal.org/drivers/vector/csv.html#examples
Even
Le 15/11/2022 à 20:58, Hugh Kelley via Qgis-user a écrit :
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?
On Tue, Nov 15, 2022 at 12:30 PM David Strip via Qgis-user
<[email protected]> wrote:
You might consider ogr2ogr as an alternative approach. You can run
this from the command line allowing you to use shell scripts to
iterate through all your .csv files. There are also python
bindings for ogr2ogr if you're more comfortable with python than
shell scripts.
On 11/15/2022 9:59 AM, Salvatore Mellino via Qgis-user wrote:
Hello,
thank you for your answer. I have many csv (about 100), so I need
an automatic procedure. Maybe a python script...
Il 15/11/2022 16:55, Nicolas Cadieux ha scritto:
Hi,
Yes, you can do that very easily using QGIS. Layer/add
layer/add delimited text layer. Then just export the layer in
the format of your choice. You may need to convert the
coordinates in decimal degrees (ex 75 05 30.4 ->
75.0917777777778000000 ).
You can do this in Excel using =(A6)+(B6/60)+(C6/3600)+(D6/3600)
A= Deg, B= Min, C=Sec, D= Decimal Sec. Then export to csv.
Nicolas
On 2022-11-15 10:08 a.m., Salvatore Mellino via Qgis-user wrote:
Hello,
I would like to know if it is possible to import multiple csv
files contained in a folder and to convert them in shapefiles
(1 for each csv). All csv files are structured as "lat long
value" separate by space and without any header line.
Thank you for your help! Regards,
Salvatore
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
--
Hugh Kelley
_______________________________________________
Qgis-user mailing list
[email protected]
List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
--
http://www.spatialys.com
My software is free, but my time generally not.
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
