Re: [Qgis-user] Converting csv to shapefile issues
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 Gesendet: Donnerstag, 27. Juli 2023 15:35 An: Frank Broniewski ; qgis-user@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 mailto:broniew...@a-a.lu>> Sent: Wednesday, July 26, 2023 11:21 PM To: Jamie Gould mailto:jgo...@longshore.ca>>; qgis-user@lists.osgeo.org<mailto:qgis-user@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 mailto:qgis-user-boun...@lists.osgeo.org>> Im Auftrag von Jamie Gould via QGIS-User Gesendet: Mittwoch, 26. Juli 2023 21:28 An: qgis-user@lists.osgeo.org<mailto:qgis-user@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@01D9C0A2.986AA0A0] Does anyone have any other ideas of how I could go about this? Thank you in advance, Jamie Gould, C. Tech ___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] 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 Sent: Wednesday, July 26, 2023 11:21 PM To: Jamie Gould ; qgis-user@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 mailto:qgis-user-boun...@lists.osgeo.org>> Im Auftrag von Jamie Gould via QGIS-User Gesendet: Mittwoch, 26. Juli 2023 21:28 An: qgis-user@lists.osgeo.org<mailto:qgis-user@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@01D9C05C.8DDE7170] Does anyone have any other ideas of how I could go about this? Thank you in advance, Jamie Gould, C. Tech ___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] 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 Im Auftrag von Jamie Gould via QGIS-User Gesendet: Mittwoch, 26. Juli 2023 21:28 An: qgis-user@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@01D9C05A.D5B3F2B0] Does anyone have any other ideas of how I could go about this? Thank you in advance, Jamie Gould, C. Tech ___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[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@01D9BFB1.F647D680] Does anyone have any other ideas of how I could go about this? Thank you in advance, Jamie Gould, C. Tech ___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
