<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:"Arial Black";
panose-1:2 11 10 4 2 1 2 2 2 4;}
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 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.EmailStyle21
{mso-style-type:personal-compose;
font-family:"Calibri",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="EN-CA" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Thank you, Frank. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you,<o:p></o:p></p>
<p class="MsoNormal">Jamie<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></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 <broniewski@a-a.lu>
<br>
<b>Sent:</b> Wednesday, July 26, 2023 11:21 PM<br>
<b>To:</b> Jamie Gould <jgould@longshore.ca>; qgis-user@lists.osgeo.org<br>
<b>Subject:</b> AW: 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="DE" style="font-size:10.0pt;font-family:"Century Gothic",sans-serif">HI Jamie,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" 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 lang="DE" style="mso-ligatures:none;mso-fareast-language:DE">Von:</span></b><span lang="DE" 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"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal">Good afternoon,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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></p>
<p class="MsoNormal"><span 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@01D9C05C.8DDE7170"></span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Does anyone have any other ideas of how I could go about this?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you in advance,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial Black",sans-serif;mso-fareast-language:EN-CA">Jamie</span></b><span style="font-size:10.0pt;font-family:"Arial Black",sans-serif;color:#767171;mso-fareast-language:EN-CA">
</span><b><span style="font-size:10.0pt;font-family:"Arial Black",sans-serif;color:#FF9900;mso-fareast-language:EN-CA">Gould</span></b><span style="font-size:10.0pt;font-family:"Arial Black",sans-serif;color:#767171;mso-fareast-language:EN-CA">,
</span><b><span style="font-size:10.0pt;font-family:"Arial Black",sans-serif;color:black;mso-fareast-language:EN-CA">C. Tech</span></b><span 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>