<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Dear all<br>
<br>
I want to import multiple csv-files with coordinates (points) that
come from Excel/SPSS, having first row as header. These have
undefined labels of columns that need to be available in grass and
that might change in future. Running grass on dbf-backend, I used to
create shapefiles in R and import these with v.in.ogr. However, this
does not seem to be appropriate, when running grass on sqlite
(abbreviation of columnnames). There seem to be different solutions,
but I am what is the recommended approach. Hopefully you can give me
a hint.<br>
<br>
Thanks,<br>
Patrick<br>
<br>
##Current ideas:<br>
<i>#Version 0</i><br>
create shapefile in R
(<a class="moz-txt-link-freetext" href="http://gis.stackexchange.com/questions/30785/how-to-stop-writeogr-from-abbreviating-field-names-when-using-esri-shapefile-d">http://gis.stackexchange.com/questions/30785/how-to-stop-writeogr-from-abbreviating-field-names-when-using-esri-shapefile-d</a>)<br>
import shapefile with v.in.ogr<br>
<br>
<i>#Version1</i><br>
query csv and create file "coldef" with Column definition in SQL
style (in shell or R?)<br>
import in grass with v.in.ascii format=point skip=1 columns=coldef<br>
<br>
<i>#Version2</i><br>
create sqlite-file in R/OGR with SPATIALITE-extension (see
<a class="moz-txt-link-freetext" href="https://stat.ethz.ch/pipermail/r-sig-geo/2014-July/021313.html">https://stat.ethz.ch/pipermail/r-sig-geo/2014-July/021313.html</a>)<br>
import in grass with v.in.ogr (this post mentions problems
<a class="moz-txt-link-freetext" href="http://gis.stackexchange.com/questions/1733/how-to-import-spatialite-data-into-grass">http://gis.stackexchange.com/questions/1733/how-to-import-spatialite-data-into-grass</a>)<br>
<br>
</body>
</html>