<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
@font-face
{font-family:"Arial Black";
panose-1:2 11 10 4 2 1 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
span.E-MailFormatvorlage21
{mso-style-type:personal-compose;
font-family:"Century Gothic",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="DE" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif">Hi Jamie,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Century Gothic",sans-serif">I presume, you did have a look at
<a href="https://docs.qgis.org/3.28/en/docs/user_manual/managing_data_source/opening_data.html#importing-a-delimited-text-file">
https://docs.qgis.org/3.28/en/docs/user_manual/managing_data_source/opening_data.html#importing-a-delimited-text-file</a> ?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Century Gothic",sans-serif">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Century Gothic",sans-serif">Do you get a map with points at all? If it is empty, QGIS does not understand your coordinate values.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="mso-ligatures:none;mso-fareast-language:DE">Von:</span></b><span style="mso-ligatures:none;mso-fareast-language:DE"> Jamie Gould <jgould@longshore.ca>
<br>
<b>Gesendet:</b> Donnerstag, 27. Juli 2023 15:35<br>
<b>An:</b> Frank Broniewski <broniewski@a-a.lu>; qgis-user@lists.osgeo.org<br>
<b>Betreff:</b> RE: Converting csv to shapefile issues<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-CA">Thank you, Frank. <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">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. <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Thank you,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Jamie<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="mso-ligatures:none;mso-fareast-language:EN-CA">From:</span></b><span lang="EN-US" style="mso-ligatures:none;mso-fareast-language:EN-CA"> Frank Broniewski <<a href="mailto:broniewski@a-a.lu">broniewski@a-a.lu</a>>
<br>
<b>Sent:</b> Wednesday, July 26, 2023 11:21 PM<br>
<b>To:</b> Jamie Gould <<a href="mailto:jgould@longshore.ca">jgould@longshore.ca</a>>;
<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
<b>Subject:</b> AW: Converting csv to shapefile issues<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif">HI Jamie,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Century Gothic",sans-serif">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Century Gothic",sans-serif">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Century Gothic",sans-serif">HTH,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Century Gothic",sans-serif">Frank<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="mso-ligatures:none;mso-fareast-language:DE">Von:</span></b><span style="mso-ligatures:none;mso-fareast-language:DE"> QGIS-User <<a href="mailto:qgis-user-bounces@lists.osgeo.org">qgis-user-bounces@lists.osgeo.org</a>>
<b>Im Auftrag von </b>Jamie Gould via QGIS-User<br>
<b>Gesendet:</b> Mittwoch, 26. Juli 2023 21:28<br>
<b>An:</b> <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
<b>Betreff:</b> [Qgis-user] Converting csv to shapefile issues<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-CA">Good afternoon,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">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.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA" style="mso-ligatures:none"><img border="0" width="517" height="339" style="width:5.3854in;height:3.5312in" id="Picture_x0020_2" src="cid:image001.png@01D9C0A2.986AA0A0"></span><span lang="EN-CA"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Does anyone have any other ideas of how I could go about this?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Thank you in advance,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-CA" style="font-size:10.0pt;font-family:"Arial Black",sans-serif;mso-fareast-language:EN-CA">Jamie</span></b><span lang="EN-CA" style="font-size:10.0pt;font-family:"Arial Black",sans-serif;color:#767171;mso-fareast-language:EN-CA">
</span><b><span lang="EN-CA" style="font-size:10.0pt;font-family:"Arial Black",sans-serif;color:#FF9900;mso-fareast-language:EN-CA">Gould</span></b><span lang="EN-CA" style="font-size:10.0pt;font-family:"Arial Black",sans-serif;color:#767171;mso-fareast-language:EN-CA">,
</span><b><span lang="EN-CA" style="font-size:10.0pt;font-family:"Arial Black",sans-serif;color:black;mso-fareast-language:EN-CA">C. Tech</span></b><span lang="EN-CA" style="font-size:10.0pt;font-family:"Arial Black",sans-serif;color:#767171;mso-fareast-language:EN-CA"><o:p></o:p></span></p>
</div>
</body>
</html>