[Qgis-user] Converting csv to shapefile issues

[Frank Broniewski]

Hi Jamie,

I presume, you did have a look at https://docs.qgis.org/3.28/en/docs/user_manual/managing_data_source/opening_data.html#importing-a-delimited-text-file ?

In any case, editing CSV files in QGIS is not possible, you will have to convert it to a "real" geo-format beforehand, hence my proposition to edit the CSV in Excel. Do you have an example of the coordinate values? Is it WGS84, in decimal degrees, or in degrees, minutes, seconds? In addition, you can only use on pair of coordinates, either bottom hole or surface hole. You could add the CSV twice, and take the alternate coordinate pair to both.

Do you get a map with points at all? If it is empty, QGIS does not understand your coordinate values.

Von: Jamie Gould <jgould at longshore.ca>
Gesendet: Donnerstag, 27. Juli 2023 15:35
An: Frank Broniewski <broniewski at a-a.lu>; qgis-user at lists.osgeo.org
Betreff: RE: Converting csv to shapefile issues

Thank you, Frank.

Sorry I should have been more clear; SH is Surface Hole, and BH is the Bottom Hole.  I've tried specifying the Surface Hole Lat and Long columns and I've tried specifying the Bottom Hole Lat and Long columns, but it still results in the error.

I know in ArcGIS you can take that data and it'll calculate standard lat and long columns for you, which I was thinking may be the problem with my data and was hoping I could calculate those columns, but the Toggling Editing Mode Button is greyed out so I cannot add those columns and was wondering if that step has to be after the shapefile is made, which is a problem because I cannot seem to get my csv data to convert to a shapefile.  I made sure to take out special characters and spaces that I know a shapefile doesn't like.  Maybe I'll give the geopackage a shot and see if that works.

Thank you,
Jamie

From: Frank Broniewski <broniewski at a-a.lu<mailto:broniewski at a-a.lu>>
Sent: Wednesday, July 26, 2023 11:21 PM
To: Jamie Gould <jgould at longshore.ca<mailto:jgould at longshore.ca>>; qgis-user at lists.osgeo.org<mailto:qgis-user at lists.osgeo.org>
Subject: AW: Converting csv to shapefile issues

HI Jamie,

I do not know, what SH Lat/Long and BH Lat/Long are, but you can open your CSV with Calc or Excel, do your data manipulation there and then add the CSV to QGIS. During the import you can specify your Lat/Long columns, and once you have your points visible on the map, you should be able to export to Shapefile as well.
Just be aware that Shapefile has several limitations on length of column names, column content and so forth. You might be better of to use Geopackage, which is a more modern file format for geodata.

HTH,
Frank

Von: QGIS-User <qgis-user-bounces at lists.osgeo.org<mailto:qgis-user-bounces at lists.osgeo.org>> Im Auftrag von Jamie Gould via QGIS-User
Gesendet: Mittwoch, 26. Juli 2023 21:28
An: qgis-user at lists.osgeo.org<mailto:qgis-user at lists.osgeo.org>
Betreff: [Qgis-user] Converting csv to shapefile issues

Good afternoon,

I'm currently using geoSCOUT at the company I'm working at.  One cannot export out any attributes with a layer or shapefile out of geoSCOUT and you cannot view an attribute table within geoSCOUT either.  There are a couple of tasks I'd like to do that it would be beneficial to have those attributes.  So, I have exported out a UWI list and imported into an analytics program we subscribe to called EVA, from here I can export out a csv of the UWI plus data.  I have brought this csv into QGIS and want to convert it to a shapefile.  The csv does not export out of EVA with Lat and Long columns, but does give SH Lat, SH Long, BH Lat, and BH Long.

I thought perhaps I could add a column to the csv file within QGIS and calculate a lat/long column, but the Toggle Editing Mode Button is greyed out.  So, then I thought maybe I could create one shapefile with the SH data, and another with the BH data, then merge the two shapefiles and perform a points to path if necessary.  When I right click on the csv file to export as an ESRI shapefile, the export fails, and I get the below message.
[cid:image001.png at 01D9C0A2.986AA0A0]

Does anyone have any other ideas of how I could go about this?

Thank you in advance,

Jamie Gould, C. Tech
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230727/c23d73ce/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 9613 bytes
Desc: image001.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230727/c23d73ce/attachment.png>