Re: [OSM-dev] osmcoastline install question

2013-08-21 Thread Jeff Meyer
On Mon, Aug 19, 2013 at 1:30 AM, Jochen Topf joc...@remote.org wrote:

 On Sun, Aug 18, 2013 at 03:47:53PM -0700, Jeff Meyer wrote:
  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

 The osmcoastline README mentions the ubuntugis repository. Yes, it could


Aha! RTFR! Mea culpa!
Lame excuse: I had skipped that part, as installing GDAL is a dependency
for Osmium, and the Osmium README doesn't include that.


 probably be made clearer how to install this, but then I'd have to explain
 it for each and every distribution. Adding extra repositories is a rather
 drastic step, it is done differently in different distributions and it is
 not necessary in all distributions. Unfortunately there is a minimum of
 expertise and experience involved in compiling your own software.

 Feel free to add your experiences and build instructions to the wiki.


Will do!
___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev


Re: [OSM-dev] osmcoastline install question

2013-08-19 Thread Jochen Topf
On Sun, Aug 18, 2013 at 03:47:53PM -0700, Jeff Meyer wrote:
 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

The osmcoastline README mentions the ubuntugis repository. Yes, it could
probably be made clearer how to install this, but then I'd have to explain
it for each and every distribution. Adding extra repositories is a rather
drastic step, it is done differently in different distributions and it is
not necessary in all distributions. Unfortunately there is a minimum of
expertise and experience involved in compiling your own software.

Feel free to add your experiences and build instructions to the wiki.

 sudo add-apt-repository ppa:mapnik/v.2.2.0
 
 The mapnik repo has a more up-to-date build of boost.

This should not be necessary. Older versions of boost are fine.

Jochen
-- 
Jochen Topf  joc...@remote.org  http://www.jochentopf.com/  +49-721-388298

___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev


Re: [OSM-dev] osmcoastline install question

2013-08-19 Thread Sven Geggus
Jochen Topf joc...@remote.org wrote:

 The osmcoastline README mentions the ubuntugis repository. Yes, it could
 probably be made clearer how to install this, but then I'd have to explain
 it for each and every distribution.

I will second this. There are people (like me) which do not like to use
Ubuntu for a couple of resons.

 Adding extra repositories is a rather drastic step, it is done differently
 in different distributions and it is not necessary in all distributions.

E.g. not necessary for Debian stable.

 This should not be necessary. Older versions of boost are fine.

Works fine using libboost1.49-dev on debian stable.

What you should probably add to teh README is the Number of Warnings and
errors issued by a correct run of runtest.sh.

Sven

-- 
Whenever there is a conflict between human rights and property
rights, human rights must prevail. (Abraham Lincoln)

/me is giggls@ircnet, http://sven.gegg.us/ on the Web

___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev


Re: [OSM-dev] osmcoastline install question

2013-08-18 Thread Jeff Meyer
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 j...@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 joc...@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 j...@gwhat.org
  To: Jochen Topf joc...@remote.org
  Cc: dev@openstreetmap.org dev@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 joc...@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  joc...@remote.org  http://www.jochentopf.com/
 +49-721-388298
  
 
 
 
  --
  Jeff Meyer
  Global World History Atlas
  www.gwhat.org
  j...@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  joc...@remote.org  http://www.jochentopf.com/
 +49-721-388298




 --
 Jeff Meyer
 Global World

Re: [OSM-dev] osmcoastline install question

2013-08-12 Thread Jochen Topf
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  joc...@remote.org  http://www.jochentopf.com/  +49-721-388298

___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev


Re: [OSM-dev] osmcoastline install question

2013-08-12 Thread Jeff Meyer
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 joc...@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  joc...@remote.org  http://www.jochentopf.com/  +49-721-388298




-- 
Jeff Meyer
Global World History Atlas
www.gwhat.org
j...@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
___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev


Re: [OSM-dev] osmcoastline install question

2013-08-12 Thread Jochen Topf
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 j...@gwhat.org
 To: Jochen Topf joc...@remote.org
 Cc: dev@openstreetmap.org dev@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 joc...@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  joc...@remote.org  http://www.jochentopf.com/  +49-721-388298
 
 
 
 
 -- 
 Jeff Meyer
 Global World History Atlas
 www.gwhat.org
 j...@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  joc...@remote.org  http://www.jochentopf.com/  +49-721-388298

___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev


Re: [OSM-dev] osmcoastline install question

2013-08-12 Thread Jeff Meyer
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 joc...@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 j...@gwhat.org
  To: Jochen Topf joc...@remote.org
  Cc: dev@openstreetmap.org dev@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 joc...@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  joc...@remote.org  http://www.jochentopf.com/
 +49-721-388298
  
 
 
 
  --
  Jeff Meyer
  Global World History Atlas
  www.gwhat.org
  j...@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  joc...@remote.org  http://www.jochentopf.com/  +49-721-388298




-- 
Jeff Meyer
Global World History Atlas
www.gwhat.org
j...@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
___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev


[OSM-dev] osmcoastline install question

2013-08-11 Thread Jeff Meyer
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.

Thanks!
Jeff

-- 
Jeff Meyer
Global World History Atlas
www.gwhat.org
j...@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
___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev