[OSM-dev] osmcoastline install question

Jeff Meyer jeff at gwhat.org
Mon Aug 12 15:38:54 UTC 2013


Ah, ok... I think I had to use some non-Ubuntu flavors to make some other
packages work (PostGIS 2.0 comes to mind, but I installed that a ways
back...).

I'll try on a different box & see what happens.

Thanks!
Jeff



On Mon, Aug 12, 2013 at 8:27 AM, Jochen Topf <jochen at remote.org> wrote:

> Hi!
>
> it runs for me on a plain Ubuntu 12.04. Some library versions you have are
> different from what I have on that system. Did you install them yourself?
> Try using the versions supplied as Ubuntu packages. I think Osmium is the
> only library on that system that you need to install yourself, everything
> elseo should be okay out of the box.
>
> Jochen
>
> On Mon, Aug 12, 2013 at 08:18:47AM -0700, Jeff Meyer wrote:
> > Date: Mon, 12 Aug 2013 08:18:47 -0700
> > From: Jeff Meyer <jeff at gwhat.org>
> > To: Jochen Topf <jochen at remote.org>
> > Cc: "dev at openstreetmap.org" <dev at openstreetmap.org>
> > Subject: Re: [OSM-dev] osmcoastline install question
> >
> > I thought I was up to date, but perhaps some bindings or compile flags
> > weren't set properly?
> >
> > Kernel 3.2.0-38-generic
> > Ubuntu 12.04
> > (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
> >
> > gdal: 1.9.2
> > Boost is 1.49
> > Zlib is 1.28
> >
> > $ spatialite --version
> > SpatiaLite version ..: 4.1.1 Supported Extensions:
> > - 'VirtualShape' [direct Shapefile access]
> > - 'VirtualDbf' [direct DBF access]
> > - 'VirtualText' [direct CSV/TXT access]
> > - 'VirtualNetwork' [Dijkstra shortest path]
> > - 'RTree' [Spatial Index - R*Tree]
> > - 'MbrCache' [Spatial Index - MBR cache]
> > - 'VirtualSpatialIndex' [R*Tree metahandler]
> > - 'VirtualFDO' [FDO-OGR interoperability]
> > - 'SpatiaLite' [Spatial SQL - OGC]
> > PROJ.4 version ......: Rel. 4.8.0, 6 March 2012
> > GEOS version ........: 3.3.7-CAPI-1.7.7
> > 3.7.9 2011-11-01 00:52:41 c7c6050ef060877ebe77b41d959e9df13f8c9b5e
> >
> > What other libraries should I include?
> >
> > Thanks!
> > Jeff
> >
> >
> >
> >
> > On Mon, Aug 12, 2013 at 5:43 AM, Jochen Topf <jochen at remote.org> wrote:
> >
> > > On Sun, Aug 11, 2013 at 01:25:47PM -0700, Jeff Meyer wrote:
> > > > Does anyone have any experience with osmcoastline installations
> (Jochen,
> > > > obviously!)?
> > > >
> > > > I'm getting the following error from runtest.sh after setup:
> > > >
> > > > $ ./runtest.sh
> > > > Enabled debug option
> > > > [ 0:00] Using SRS 4326 for output. (Change with the --srs/s option.)
> > > > [ 0:00] Writing to output database 'testdata.db'. (Was set with the
> > > > --output-database/-o option.)
> > > > [ 0:00] Removing database output file (if it exists) (because you
> told me
> > > > to with --overwrite/-f).
> > > > [ 0:00] Will create geometry index. (If you do not want an index use
> > > > --no-index/-i.)
> > > > [12:54] Reading from file 'testdata.osm'.
> > > > [12:54] Reading ways (1st pass through input file)...
> > > > [12:54]   There are 19 nodes where the coastline is not closed.
> > > > [12:54]   There are 36 coastline rings (16 from a single way and 20
> from
> > > > multiple ways).
> > > > [12:54] Memory used currently: 205 MB (Peak was: 205 MB).
> > > > [12:54] Reading nodes (2nd pass through input file)...
> > > > ERROR 1: In CreateFeature(): sqlite3_prepare(INSERT INTO
> 'error_points'
> > > > ("GEOMETRY","osm_id","error") VALUES (?,?,?)):
> > > >   table error_points has no column named GEOMETRY
> > > > Failed to create feature on layer 'error_points'.
> > > > $
> > > >
> > > > spatialite> .schema error_points
> > > > CREATE TABLE 'error_points' (   OGC_FID INTEGER PRIMARY KEY, 'osm_id'
> > > > VARCHAR, 'error' VARCHAR);
> > > > spatialite>
> > > >
> > > > Not sure what's going on here, so thanks in advance for any help.
> > >
> > > Probably old spatialite and/or gdal lib. The spatialite format changed
> at
> > > some point and this leads to some confusion. You need GDAL 1.7 or
> later.
> > > If thats not the problem tell us something more about your setup (os
> > > version, lib versions etc.)
> > >
> > > Jochen
> > > --
> > > Jochen Topf  jochen at remote.org  http://www.jochentopf.com/
> +49-721-388298
> > >
> >
> >
> >
> > --
> > Jeff Meyer
> > Global World History Atlas
> > www.gwhat.org
> > jeff at gwhat.org
> > 206-676-2347
> >
> > OpenStreetMap: Mapping with a Human Touch
> > osm: Open Historical Map
> > (OHM)<http://wiki.openstreetmap.org/wiki/Open_Historical_Map>
> >  / my OSM user page <http://www.openstreetmap.org/user/jeffmeyer>
> > t: @GWHAThistory <https://twitter.com/GWHAThistory>
> > f: GWHAThistory <https://www.facebook.com/GWHAThistory>
>
> --
> Jochen Topf  jochen at remote.org  http://www.jochentopf.com/  +49-721-388298
>



-- 
Jeff Meyer
Global World History Atlas
www.gwhat.org
jeff at gwhat.org
206-676-2347

OpenStreetMap: Mapping with a Human Touch
osm: Open Historical Map
(OHM)<http://wiki.openstreetmap.org/wiki/Open_Historical_Map>
 / my OSM user page <http://www.openstreetmap.org/user/jeffmeyer>
t: @GWHAThistory <https://twitter.com/GWHAThistory>
f: GWHAThistory <https://www.facebook.com/GWHAThistory>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20130812/0db32fcc/attachment-0001.html>


More information about the dev mailing list