Re: [OSM-dev] osmcoastline install question
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
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
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
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
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
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
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
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
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