<div dir="ltr">I thought I was up to date, but perhaps some bindings or compile flags weren't set properly?<div><br></div><div><div>Kernel 3.2.0-38-generic</div><div>Ubuntu 12.04 </div><div>(uname -a: Linux hackercoop 3.2.0-38-generic #61-Ubuntu SMP Tue Feb 19 12:18:21 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux</div>
<div><br></div><div>gdal: 1.9.2</div><div><div>Boost is 1.49</div><div>Zlib is 1.28</div></div><div><br></div><div>$ spatialite --version</div><div>SpatiaLite version ..: 4.1.1<span class="" style="white-space:pre"> </span>Supported Extensions:</div>
<div><span class="" style="white-space:pre"> </span>- 'VirtualShape'<span class="" style="white-space:pre"> </span>[direct Shapefile access]</div><div><span class="" style="white-space:pre"> </span>- 'VirtualDbf'<span class="" style="white-space:pre"> </span>[direct DBF access]</div>
<div><span class="" style="white-space:pre"> </span>- 'VirtualText'<span class="" style="white-space:pre"> </span>[direct CSV/TXT access]</div><div><span class="" style="white-space:pre"> </span>- 'VirtualNetwork'<span class="" style="white-space:pre"> </span>[Dijkstra shortest path]</div>
<div><span class="" style="white-space:pre"> </span>- 'RTree'<span class="" style="white-space:pre"> </span>[Spatial Index - R*Tree]</div><div><span class="" style="white-space:pre"> </span>- 'MbrCache'<span class="" style="white-space:pre"> </span>[Spatial Index - MBR cache]</div>
<div><span class="" style="white-space:pre"> </span>- 'VirtualSpatialIndex'<span class="" style="white-space:pre"> </span>[R*Tree metahandler]</div><div><span class="" style="white-space:pre"> </span>- 'VirtualFDO'<span class="" style="white-space:pre"> </span>[FDO-OGR interoperability]</div>
<div><span class="" style="white-space:pre"> </span>- 'SpatiaLite'<span class="" style="white-space:pre"> </span>[Spatial SQL - OGC]</div><div>PROJ.4 version ......: Rel. 4.8.0, 6 March 2012</div><div>GEOS version ........: 3.3.7-CAPI-1.7.7</div>
<div>3.7.9 2011-11-01 00:52:41 c7c6050ef060877ebe77b41d959e9df13f8c9b5e</div></div><div><br></div><div>What other libraries should I include? </div><div><br></div><div>Thanks!</div><div>Jeff</div><div><br></div><div><br></div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Aug 12, 2013 at 5:43 AM, Jochen Topf <span dir="ltr"><<a href="mailto:jochen@remote.org" target="_blank">jochen@remote.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On Sun, Aug 11, 2013 at 01:25:47PM -0700, Jeff Meyer wrote:<br>
> Does anyone have any experience with osmcoastline installations (Jochen,<br>
> obviously!)?<br>
><br>
> I'm getting the following error from runtest.sh after setup:<br>
><br>
> $ ./runtest.sh<br>
> Enabled debug option<br>
> [ 0:00] Using SRS 4326 for output. (Change with the --srs/s option.)<br>
> [ 0:00] Writing to output database 'testdata.db'. (Was set with the<br>
> --output-database/-o option.)<br>
> [ 0:00] Removing database output file (if it exists) (because you told me<br>
> to with --overwrite/-f).<br>
> [ 0:00] Will create geometry index. (If you do not want an index use<br>
> --no-index/-i.)<br>
> [12:54] Reading from file 'testdata.osm'.<br>
> [12:54] Reading ways (1st pass through input file)...<br>
> [12:54] There are 19 nodes where the coastline is not closed.<br>
> [12:54] There are 36 coastline rings (16 from a single way and 20 from<br>
> multiple ways).<br>
> [12:54] Memory used currently: 205 MB (Peak was: 205 MB).<br>
> [12:54] Reading nodes (2nd pass through input file)...<br>
> ERROR 1: In CreateFeature(): sqlite3_prepare(INSERT INTO 'error_points'<br>
> ("GEOMETRY","osm_id","error") VALUES (?,?,?)):<br>
> table error_points has no column named GEOMETRY<br>
> Failed to create feature on layer 'error_points'.<br>
> $<br>
><br>
> spatialite> .schema error_points<br>
> CREATE TABLE 'error_points' ( OGC_FID INTEGER PRIMARY KEY, 'osm_id'<br>
> VARCHAR, 'error' VARCHAR);<br>
> spatialite><br>
><br>
> Not sure what's going on here, so thanks in advance for any help.<br>
<br>
</div></div>Probably old spatialite and/or gdal lib. The spatialite format changed at<br>
some point and this leads to some confusion. You need GDAL 1.7 or later.<br>
If thats not the problem tell us something more about your setup (os<br>
version, lib versions etc.)<br>
<span class="HOEnZb"><font color="#888888"><br>
Jochen<br>
--<br>
Jochen Topf <a href="mailto:jochen@remote.org">jochen@remote.org</a> <a href="http://www.jochentopf.com/" target="_blank">http://www.jochentopf.com/</a> <a href="tel:%2B49-721-388298" value="+49721388298">+49-721-388298</a><br>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><font size="1">Jeff Meyer<br>Global World History Atlas<br><a href="http://www.gwhat.org" target="_blank">www.gwhat.org</a><br><a href="mailto:jeff@gwhat.org" target="_blank">jeff@gwhat.org</a><br>
206-676-2347</font><div><font size="1"><br></font></div><div><span style="font-size:x-small">OpenStreetMap: Mapping with a Human Touch</span><font size="1"><br></font><div><span style="font-size:x-small">osm: <a href="http://wiki.openstreetmap.org/wiki/Open_Historical_Map" target="_blank">Open Historical Map (OHM)</a> / <a href="http://www.openstreetmap.org/user/jeffmeyer" target="_blank">my OSM user page</a></span></div>
<div><font size="1">t: <a href="https://twitter.com/GWHAThistory" target="_blank">@GWHAThistory</a></font></div><div></div><div><font size="1">f: <a href="https://www.facebook.com/GWHAThistory" target="_blank">GWHAThistory</a></font></div>
<div><br></div><div><font size="1"><br></font><br></div></div></div>
</div>