<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">I can think of two ways. 1 do a save
as in qgis and select spatialite. 2 after loading the csv into
spatialite create a geometry column and update it with the
coordinates from the appropriate column(s).<br>
<br>
Number 1 is the easiest.<br>
<br>
On 10/28/2015 08:09 AM, Michael.Dodd wrote:<br>
</div>
<blockquote
cite="mid:52F173986979BD41AE31A411151FFF871719D76A@EX10-MBX-LIVE-B.open.ac.uk"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">I am trying to use spatialite with qgis but
can’t get spatialite to recognise geometry columns even though
qgis can display the same data when given a .csv or shapefile.
The data consist of a large spreadsheet including lat and long
columns, this reads and displays fine in qgis. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">When I put this into spatialite I can’t get
spatialite to recognise that two of the columns are lat and
long (I have only just started using spatialite).
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I can’t convert the full data in qgis into
a shapefile and import that into spatialite as spatialite
refuses to accept the shapefile saying it contains errors or
wrong kind of data. The actual shapefile seems fine as it
opens again in qgis.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I can chop the datafile down to just a few
columns containing the coordinates and a key, convert that to
shapefile and import that into spatialite. I can also import
the full spreadsheet into spatialite as a text file but I
can’t see a way of joining the two together so that the two
separate tables both have the geometry by linking on the key
column even though I can see the dialogue that deals with
links between tables.<o:p></o:p></p>
</div>
-- The Open University is incorporated by Royal Charter (RC
000391), an exempt charity in England & Wales and a charity
registered in Scotland (SC 038302). The Open University is
authorised and regulated by the Financial Conduct Authority.
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
</body>
</html>