Hfrhyu

Getting extremely large arrows with tikzcd

Finding the reason behind the value of the integral.

How to show a landlord what we have in savings?

GFCI outlets - can they be repaired? Are they really needed at the end of a circuit?

My ex-girlfriend uses my Apple ID to login to her iPad, do I have to give her my Apple ID password to reset it?

How do conventional missiles fly?

What does the same-ish mean?

Could the museum Saturn V's be refitted for one more flight?

Are British MPs missing the point, with these 'Indicative Votes'?

How does a dynamic QR code work?

Notepad++ delete until colon for every line with replace all

How to coordinate airplane tickets?

Why didn't Boeing produce its own regional jet?

Collected fruit by Seine's banks

Why were 5.25" floppy drives cheaper than 8"?

How to calculate the right interval for a timelapse on a boat

Decidable problems for which no concrete decision procedure is known

What is required to make GPS signals available indoors?

Populating function inputs from lists

How badly should I try to prevent a user from XSSing themselves?

TikZ: Centering dash pattern between two nodes

Why is the sentence "Das ist eine Nase" correct?

What is the most common color to indicate the input-field is disabled?

What is this scratchy sound on the acoustic guitar called?

Creating CSV with geometry as WKT in QGIS (with choosing field delimiter)

How to extract geo data out of a polygon shapefile into CSV KWTHow to export Polygons to CSV with coordinates?Writing vector layer to CSV file with geometry using PyQGIS?export shp positions to csv pyqgisError adding a delimited text layer in QGISDisplay county for random pointsHow to read csv with WKT geometry in Arcmap?can Well Known Text tables be used effectively, stored in Access or Base?add wkt representation of the geometry as field in qgisHow to create WKT file readable by QGIS 2.4.0Exporting from Excel to csv and import in QGIS retaining encoding/special characters (with workaround)?QGIS add CSV - only shows 2 points on mapQGIS Cutting .csv FilesRead a CSV with two Polygons(WKT) with GDAL

12

7

Is there a way to choose the field delimiter when exporting a CSV with geometry as wkt in QGIS?

I have a shapefile with donut holes and I'd like to export it as a CSV. It's for a partner whose DB doesn't support spatial data.

I followed Greg Krakow's methodology to add a WKT field to my exported file (when exporting to csv, add GEOMETRY=AS_WKT in the "Layer" field, but the exported field delimiter is a comma:

The problem is that each coordinate pairs of my polygons (and I suspect it will be the same for lines) are separated by a comma too so I can't import the data back into QGIS

With point shapefile, it works like a charm.

Does anyone know if I can choose my field delimited when exporting to CSV? Choose a semicolon for instance?

I search on the web and QGIS's documentation but didn't find anything.

qgis export csv wkt

share|improve this question

edited Jan 9 at 8:00

Taras

2,3483727

asked Dec 4 '12 at 14:32

fgcartographixfgcartographix

87431122

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Have you checked the help page yet: gdal.org/ogr/drv_csv.html. It describes how to change the separator.
  
  – underdark♦
  Dec 4 '12 at 16:43
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I was looking for QGIS specifically... didn't think of looking for GDAL's help. Thanks!!
  
  – fgcartographix
  Dec 4 '12 at 18:36
  

  
  
  
  

add a comment | 

12

7

Is there a way to choose the field delimiter when exporting a CSV with geometry as wkt in QGIS?

I have a shapefile with donut holes and I'd like to export it as a CSV. It's for a partner whose DB doesn't support spatial data.

I followed Greg Krakow's methodology to add a WKT field to my exported file (when exporting to csv, add GEOMETRY=AS_WKT in the "Layer" field, but the exported field delimiter is a comma:

The problem is that each coordinate pairs of my polygons (and I suspect it will be the same for lines) are separated by a comma too so I can't import the data back into QGIS

With point shapefile, it works like a charm.

Does anyone know if I can choose my field delimited when exporting to CSV? Choose a semicolon for instance?

I search on the web and QGIS's documentation but didn't find anything.

qgis export csv wkt

share|improve this question

edited Jan 9 at 8:00

Taras

2,3483727

asked Dec 4 '12 at 14:32

fgcartographixfgcartographix

87431122

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Have you checked the help page yet: gdal.org/ogr/drv_csv.html. It describes how to change the separator.
  
  – underdark♦
  Dec 4 '12 at 16:43
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I was looking for QGIS specifically... didn't think of looking for GDAL's help. Thanks!!
  
  – fgcartographix
  Dec 4 '12 at 18:36
  

  
  
  
  

add a comment | 

Is there a way to choose the field delimiter when exporting a CSV with geometry as wkt in QGIS?

I have a shapefile with donut holes and I'd like to export it as a CSV. It's for a partner whose DB doesn't support spatial data.

I followed Greg Krakow's methodology to add a WKT field to my exported file (when exporting to csv, add GEOMETRY=AS_WKT in the "Layer" field, but the exported field delimiter is a comma:

The problem is that each coordinate pairs of my polygons (and I suspect it will be the same for lines) are separated by a comma too so I can't import the data back into QGIS

With point shapefile, it works like a charm.

Does anyone know if I can choose my field delimited when exporting to CSV? Choose a semicolon for instance?

I search on the web and QGIS's documentation but didn't find anything.

qgis export csv wkt

share|improve this question

edited Jan 9 at 8:00

Taras

2,3483727

asked Dec 4 '12 at 14:32

fgcartographixfgcartographix

87431122

share|improve this question

edited Jan 9 at 8:00

Taras

2,3483727

asked Dec 4 '12 at 14:32

fgcartographixfgcartographix

87431122

share|improve this question

edited Jan 9 at 8:00

Taras

2,3483727

asked Dec 4 '12 at 14:32

fgcartographixfgcartographix

87431122

edited Jan 9 at 8:00

Taras

2,3483727

edited Jan 9 at 8:00

Taras

2,3483727

asked Dec 4 '12 at 14:32

fgcartographixfgcartographix

87431122

asked Dec 4 '12 at 14:32

fgcartographixfgcartographix

87431122

2 Answers
2

active

oldest

votes

16

I was able to export to CSV, using other than a comma, by separating the layer creation options in the Save As.. dialog with linebreaks.

Neither comma, nor space-separating them (even when they were in quotes) worked, but the linebreaks did the trick. To emphasize..

THIS APPROACH WORKED (linebreak-separated):

GEOMETRY=AS_WKT
SEPARATOR=SEMICOLON
LINEFORMAT=CRLF

But these approaches did NOT work...

(space-separated options):

GEOMETRY=AS_WKT SEPARATOR=SEMICOLON

(comma-separated options):

GEOMETRY=AS_WKT, SEPARATOR=SEMICOLON

(quoted, and either space or comma-separated LCOs):

"GEOMETRY=AS_WKT", "SEPARATOR=SEMICOLON"

As @underdark noted, there are some additional options discussed on the OGR CSV driver page you may want to be aware of. Specifically, the SEPARATOR parameter will accept either SEMICOLON or TAB in addition to COMMA. Also, you may want to experiment with the LINEFORMAT parameter, which supports either CRLF (dos/windows) or LF (unix).

A picture says a thousand words, so here's a screen grab. :)

share|improve this answer

edited Dec 4 '12 at 18:26

answered Dec 4 '12 at 18:02

elrobiselrobis

4,6842044

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks! It's working. I don't know why though, but when I try to import my csv into QGIS, it says that it's not a valid layer and it can be added to the map...? I tried with a simple polygon (linestring and polygon) and it didn't work neither :( So I guess it's another question now... ;)
  
  – fgcartographix
  Dec 4 '12 at 18:29
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ...interesting. I'm not sure how to explain that. I tried adding the one I created to the map and it worked. Then I tried adding a new one, as it created it (i.e. via the "Add saved file to map" option), and it also worked. What version of QGIS? 1.8?
  
  – elrobis
  Dec 4 '12 at 18:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  1.8.0-Lisboa. It's working when I use the "Add saved file to map", not when I use the "Add delimited text layer" button. The semicolon delimiter is check as well as my field "WKT" selected for the geometry... It worked with a point layer earlier though...
  
  – fgcartographix
  Dec 4 '12 at 19:10
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Ahh.. try going through the "Add Vector Layer.." button (like you would to add a shapefile), then browse into the folder with your .csv. At the bottom of the "Open OGR Supported Vector Layer" dialog, set "Files of type:" to Comma Separated Value [OGR]. Then your .csv should appear, and I bet it'll work.
  
  – elrobis
  Dec 4 '12 at 19:15
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You bet right! It worked with the "Add delimited text layer" after I opened my csv in Excel and resaved it too... Strange, but if it's working with the "Add Vector Layer" button, I'm ok with that. Strange behavior though...
  
  – fgcartographix
  Dec 4 '12 at 19:22
  

  
  
  
  

add a comment | 

2

Settings for QGIS 3 using "Layer Options":

share|improve this answer

edited 2 days ago

pathmapper

47027

answered Sep 6 '18 at 18:44

gcamargogcamargo

1455

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f43129%2fcreating-csv-with-geometry-as-wkt-in-qgis-with-choosing-field-delimiter%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

16

I was able to export to CSV, using other than a comma, by separating the layer creation options in the Save As.. dialog with linebreaks.

Neither comma, nor space-separating them (even when they were in quotes) worked, but the linebreaks did the trick. To emphasize..

THIS APPROACH WORKED (linebreak-separated):

GEOMETRY=AS_WKT
SEPARATOR=SEMICOLON
LINEFORMAT=CRLF

But these approaches did NOT work...

(space-separated options):

GEOMETRY=AS_WKT SEPARATOR=SEMICOLON

(comma-separated options):

GEOMETRY=AS_WKT, SEPARATOR=SEMICOLON

(quoted, and either space or comma-separated LCOs):

"GEOMETRY=AS_WKT", "SEPARATOR=SEMICOLON"

As @underdark noted, there are some additional options discussed on the OGR CSV driver page you may want to be aware of. Specifically, the SEPARATOR parameter will accept either SEMICOLON or TAB in addition to COMMA. Also, you may want to experiment with the LINEFORMAT parameter, which supports either CRLF (dos/windows) or LF (unix).

A picture says a thousand words, so here's a screen grab. :)

share|improve this answer

edited Dec 4 '12 at 18:26

answered Dec 4 '12 at 18:02

elrobiselrobis

4,6842044

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks! It's working. I don't know why though, but when I try to import my csv into QGIS, it says that it's not a valid layer and it can be added to the map...? I tried with a simple polygon (linestring and polygon) and it didn't work neither :( So I guess it's another question now... ;)
  
  – fgcartographix
  Dec 4 '12 at 18:29
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ...interesting. I'm not sure how to explain that. I tried adding the one I created to the map and it worked. Then I tried adding a new one, as it created it (i.e. via the "Add saved file to map" option), and it also worked. What version of QGIS? 1.8?
  
  – elrobis
  Dec 4 '12 at 18:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  1.8.0-Lisboa. It's working when I use the "Add saved file to map", not when I use the "Add delimited text layer" button. The semicolon delimiter is check as well as my field "WKT" selected for the geometry... It worked with a point layer earlier though...
  
  – fgcartographix
  Dec 4 '12 at 19:10
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Ahh.. try going through the "Add Vector Layer.." button (like you would to add a shapefile), then browse into the folder with your .csv. At the bottom of the "Open OGR Supported Vector Layer" dialog, set "Files of type:" to Comma Separated Value [OGR]. Then your .csv should appear, and I bet it'll work.
  
  – elrobis
  Dec 4 '12 at 19:15
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You bet right! It worked with the "Add delimited text layer" after I opened my csv in Excel and resaved it too... Strange, but if it's working with the "Add Vector Layer" button, I'm ok with that. Strange behavior though...
  
  – fgcartographix
  Dec 4 '12 at 19:22
  

  
  
  
  

add a comment | 

16

I was able to export to CSV, using other than a comma, by separating the layer creation options in the Save As.. dialog with linebreaks.

Neither comma, nor space-separating them (even when they were in quotes) worked, but the linebreaks did the trick. To emphasize..

THIS APPROACH WORKED (linebreak-separated):

GEOMETRY=AS_WKT
SEPARATOR=SEMICOLON
LINEFORMAT=CRLF

But these approaches did NOT work...

(space-separated options):

GEOMETRY=AS_WKT SEPARATOR=SEMICOLON

(comma-separated options):

GEOMETRY=AS_WKT, SEPARATOR=SEMICOLON

(quoted, and either space or comma-separated LCOs):

"GEOMETRY=AS_WKT", "SEPARATOR=SEMICOLON"

As @underdark noted, there are some additional options discussed on the OGR CSV driver page you may want to be aware of. Specifically, the SEPARATOR parameter will accept either SEMICOLON or TAB in addition to COMMA. Also, you may want to experiment with the LINEFORMAT parameter, which supports either CRLF (dos/windows) or LF (unix).

A picture says a thousand words, so here's a screen grab. :)

share|improve this answer

edited Dec 4 '12 at 18:26

answered Dec 4 '12 at 18:02

elrobiselrobis

4,6842044

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks! It's working. I don't know why though, but when I try to import my csv into QGIS, it says that it's not a valid layer and it can be added to the map...? I tried with a simple polygon (linestring and polygon) and it didn't work neither :( So I guess it's another question now... ;)
  
  – fgcartographix
  Dec 4 '12 at 18:29
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ...interesting. I'm not sure how to explain that. I tried adding the one I created to the map and it worked. Then I tried adding a new one, as it created it (i.e. via the "Add saved file to map" option), and it also worked. What version of QGIS? 1.8?
  
  – elrobis
  Dec 4 '12 at 18:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  1.8.0-Lisboa. It's working when I use the "Add saved file to map", not when I use the "Add delimited text layer" button. The semicolon delimiter is check as well as my field "WKT" selected for the geometry... It worked with a point layer earlier though...
  
  – fgcartographix
  Dec 4 '12 at 19:10
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Ahh.. try going through the "Add Vector Layer.." button (like you would to add a shapefile), then browse into the folder with your .csv. At the bottom of the "Open OGR Supported Vector Layer" dialog, set "Files of type:" to Comma Separated Value [OGR]. Then your .csv should appear, and I bet it'll work.
  
  – elrobis
  Dec 4 '12 at 19:15
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You bet right! It worked with the "Add delimited text layer" after I opened my csv in Excel and resaved it too... Strange, but if it's working with the "Add Vector Layer" button, I'm ok with that. Strange behavior though...
  
  – fgcartographix
  Dec 4 '12 at 19:22
  

  
  
  
  

add a comment | 

I was able to export to CSV, using other than a comma, by separating the layer creation options in the Save As.. dialog with linebreaks.

Neither comma, nor space-separating them (even when they were in quotes) worked, but the linebreaks did the trick. To emphasize..

THIS APPROACH WORKED (linebreak-separated):

GEOMETRY=AS_WKT
SEPARATOR=SEMICOLON
LINEFORMAT=CRLF

But these approaches did NOT work...

(space-separated options):

GEOMETRY=AS_WKT SEPARATOR=SEMICOLON

(comma-separated options):

GEOMETRY=AS_WKT, SEPARATOR=SEMICOLON

(quoted, and either space or comma-separated LCOs):

"GEOMETRY=AS_WKT", "SEPARATOR=SEMICOLON"

As @underdark noted, there are some additional options discussed on the OGR CSV driver page you may want to be aware of. Specifically, the SEPARATOR parameter will accept either SEMICOLON or TAB in addition to COMMA. Also, you may want to experiment with the LINEFORMAT parameter, which supports either CRLF (dos/windows) or LF (unix).

A picture says a thousand words, so here's a screen grab. :)

share|improve this answer

edited Dec 4 '12 at 18:26

answered Dec 4 '12 at 18:02

elrobiselrobis

4,6842044

GEOMETRY=AS_WKT
SEPARATOR=SEMICOLON
LINEFORMAT=CRLF

share|improve this answer

edited Dec 4 '12 at 18:26

answered Dec 4 '12 at 18:02

elrobiselrobis

4,6842044

answered Dec 4 '12 at 18:02

elrobiselrobis

4,6842044

answered Dec 4 '12 at 18:02

elrobiselrobis

4,6842044

2

Settings for QGIS 3 using "Layer Options":

share|improve this answer

edited 2 days ago

pathmapper

47027

answered Sep 6 '18 at 18:44

gcamargogcamargo

1455

add a comment | 

2

Settings for QGIS 3 using "Layer Options":

share|improve this answer

edited 2 days ago

pathmapper

47027

answered Sep 6 '18 at 18:44

gcamargogcamargo

1455

add a comment | 

Settings for QGIS 3 using "Layer Options":

share|improve this answer

edited 2 days ago

pathmapper

47027

answered Sep 6 '18 at 18:44

gcamargogcamargo

1455

share|improve this answer

edited 2 days ago

pathmapper

47027

answered Sep 6 '18 at 18:44

gcamargogcamargo

1455

edited 2 days ago

pathmapper

47027

edited 2 days ago

pathmapper

47027

answered Sep 6 '18 at 18:44

gcamargogcamargo

1455

answered Sep 6 '18 at 18:44

gcamargogcamargo

1455