Editable GeoCSV QGIS Plugin: Unterschied zwischen den Versionen
Aus Geoinformation HSR
Stefan (Diskussion | Beiträge) K (→Installation) |
Stefan (Diskussion | Beiträge) K |
||
Zeile 14: | Zeile 14: | ||
This plugin allows files in CSV format to be loaded, edited and saved in QGIS including geometry. This allows to integrate QGIS with spreadsheet programs like LibreOffice [http://www.libreoffice.org/] or Kettle (see [[GeoKettle]]). | This plugin allows files in CSV format to be loaded, edited and saved in QGIS including geometry. This allows to integrate QGIS with spreadsheet programs like LibreOffice [http://www.libreoffice.org/] or Kettle (see [[GeoKettle]]). | ||
+ | |||
+ | These are some features and advantages of this plugin: | ||
+ | * Allow to edit a CSV text layer (which built-in "Add delimited text layer..." can't). | ||
+ | * Supports attribute names longer than 10 characters (unlike Shapefiles). | ||
+ | * Supports all OGC geometry types (WKT) (unlike Shapefiles which supports only Point, Linestring, Polygon and Multipoint). | ||
+ | * Manages data types, stored in .csvt (unlike Shapefiles). | ||
+ | * Manages the coordinate reference system, which are stored in .prj file (like Shapefiles). | ||
== Help == | == Help == | ||
Zeile 20: | Zeile 27: | ||
;Why not just use Shapefiles? What's the difference and what's common?: Shapefiles 1. is a binary file format cluttered over three mandatory files (.shp,.dbf,.shx), 2. allows only 10 characters per attibute/field and 3. knows only Point, Linestring, Polygon and MultiPoint. GeoCSV combines a well-known IT text format with geometry encoded as well-known text (WKT) or longitude/latitude. GeoCVS can be directly written and read by common software, like text spreadsheets and text editors. | ;Why not just use Shapefiles? What's the difference and what's common?: Shapefiles 1. is a binary file format cluttered over three mandatory files (.shp,.dbf,.shx), 2. allows only 10 characters per attibute/field and 3. knows only Point, Linestring, Polygon and MultiPoint. GeoCSV combines a well-known IT text format with geometry encoded as well-known text (WKT) or longitude/latitude. GeoCVS can be directly written and read by common software, like text spreadsheets and text editors. | ||
+ | |||
+ | ;Why not just use built-in "Add delimited text layer..."?: The built-in CSV reader does'nt allow to edit a CSV text layer, it does'nt store the coordinate reference system nor the data types, among others. | ||
;How can I install this plugin for QGIS?: See the [[Editable GeoCSV QGIS Plugin#Installation|installation]] steps. | ;How can I install this plugin for QGIS?: See the [[Editable GeoCSV QGIS Plugin#Installation|installation]] steps. | ||
+ | |||
+ | ;how can I create a new GeoCSV file?: There's no menu command but there's a template in the Python plugins directory at path .../test/. | ||
;I have a problem with the CSV file; which software do you recommend to edit the CSV file?: Use a good text editor like Notepad++ (Windows) or Sublime (Mac) to do a Search&Replace or save the file as UTF-8. | ;I have a problem with the CSV file; which software do you recommend to edit the CSV file?: Use a good text editor like Notepad++ (Windows) or Sublime (Mac) to do a Search&Replace or save the file as UTF-8. |
Version vom 4. Juni 2015, 11:04 Uhr
Load, edit and save GeoCSV files in QGIS in order to integrate with spreadsheet programs like LibreOffice or Kettle.
- A project by Geometa Lab HSR
- Project Lead: Stefan Keller
- Project status: experimental
- Official QGIS Plugins Directory: http://plugins.qgis.org/plugins/editablegeocsv/
- Tracker: https://github.com/geometalab/Editable-GeoCSV-QGIS-Plugin/issues
- Code Repository: https://github.com/geometalab/Editable-GeoCSV-QGIS-Plugin
About
This plugin allows files in CSV format to be loaded, edited and saved in QGIS including geometry. This allows to integrate QGIS with spreadsheet programs like LibreOffice [1] or Kettle (see GeoKettle).
These are some features and advantages of this plugin:
- Allow to edit a CSV text layer (which built-in "Add delimited text layer..." can't).
- Supports attribute names longer than 10 characters (unlike Shapefiles).
- Supports all OGC geometry types (WKT) (unlike Shapefiles which supports only Point, Linestring, Polygon and Multipoint).
- Manages data types, stored in .csvt (unlike Shapefiles).
- Manages the coordinate reference system, which are stored in .prj file (like Shapefiles).
Help
- What is GeoCSV?
- It's the very common CSV text file format (originally ) plus a geometry attibute/field. See the GeoCSV specification.
- Why not just use Shapefiles? What's the difference and what's common?
- Shapefiles 1. is a binary file format cluttered over three mandatory files (.shp,.dbf,.shx), 2. allows only 10 characters per attibute/field and 3. knows only Point, Linestring, Polygon and MultiPoint. GeoCSV combines a well-known IT text format with geometry encoded as well-known text (WKT) or longitude/latitude. GeoCVS can be directly written and read by common software, like text spreadsheets and text editors.
- Why not just use built-in "Add delimited text layer..."?
- The built-in CSV reader does'nt allow to edit a CSV text layer, it does'nt store the coordinate reference system nor the data types, among others.
- How can I install this plugin for QGIS?
- See the installation steps.
- how can I create a new GeoCSV file?
- There's no menu command but there's a template in the Python plugins directory at path .../test/.
- I have a problem with the CSV file; which software do you recommend to edit the CSV file?
- Use a good text editor like Notepad++ (Windows) or Sublime (Mac) to do a Search&Replace or save the file as UTF-8.
- I have problems opening and saving CSV - which spreadsheet program do you recommend?
- We recommend LibreOffice and we recommend to avoid Excel.
- I got the following error when opening a GeoCSV file "An error occured while trying to update the CSVT file according to the new attribute types. Please update the csvt file manually."
- See the CSVT specification.
- I got the following error when opening a GeoCSV file "CSVT file contains incorrect geo attributes. Please set manually."
- See the CSVT specification.
- I got the following error when opening a GeoCSV file "CSVT file contains too many geo attributes. Please set manually."
- See the CSVT specification.
- I got the following error when opening a GeoCSV file "Erroneous delimiter detected. The delimiter should be a ';'."
- Use a text editor or another CSV tool to set the field delimiter to ';'. GeoCSV has chosen ';' because it's less used in free text than ',' and visible as opposite to 'tab'.
Installation
Prerequisites: You need internet access.
Installation steps:
- Install QGIS locally - or download "QGIS Portable" e.g. on a USB stick - and start QGIS.
- Enable experimental plugins in QGIS: Goto menu "Plugins > Manage and install plugins".
- In the QGIS "Plugins" dialog, goto tab "Settings" and check "Show also experimental plugins".
- In the QGIS "Plugins" dialog search for CSV or "Editable GeoCSV", then click "Install" on the plugin description to install it.
- Ready! Now you should see an entry "Editable QGIS > Add GeoCSV layer..." in the QGIS menu bar "Plugins" as well as this icon
in the icon bar ("green document icon with a plus").