[OSM-dev] osmcoastline install question

Sun Aug 18 22:47:53 UTC 2013

Jochen -

I think I've cleared it up - standard Ubuntu packages won't work for the
install, but ppa:ubuntugis/ubuntugis-unstable works well. This is also why
I wasn't finding the libgeos++-dev in Ubuntu... it's not there without this
ppa.

I'd add these two items to the front of the install process and any
spatialite or boost issues should go away:

sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable
sudo add-apt-repository ppa:mapnik/v.2.2.0

The mapnik repo has a more up-to-date build of boost.

- Jeff

On Mon, Aug 12, 2013 at 8:38 AM, Jeff Meyer <jeff at gwhat.org> wrote:

> 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>
>
>
>
>

-- 
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/20130818/4990d68c/attachment.html>