[ gpsdrive ] Trying to get osmdata

[Jan-Benedict Glaw]

On Wed, 2008-12-03 19:08:46 +0100, Kaare Rasmussen <kaare at jasonic.dk> wrote:
> Trying to install italy (and denmark) on an OpenSuse 11 installation from 
> http://download.geofabrik.de/osm/europe/ but I'm stuck with this error
> 
> ./osm2pgsql -v ~/Desktop/denmark.osm.bz2
> osm2pgsql SVN version 0.55-20081203 $Rev$
> 
> Using projection SRS 900913 (Spherical Mercator)
> Setting up table: planet_osm_point
> SELECT AddGeometryColumn('planet_osm_point', 'way', 900913, 'POINT', 2 );
>  failed: ERROR:  AddGeometryColumns() - invalid SRID
> CONTEXT:  SQL statement "SELECT AddGeometryColumn('','', $1 , $2 , $3 , $4 , 
> $5 )"
> PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement
> 
> Error occurred, cleaning up
> 
> This is PostgreSQL 8.3.1 from OpenSuse, postgis from 
> http://download.opensuse.org/repositories/Application:/Geo/openSUSE_11.0 and 
> osm2pgsql from svn.
> 
> I would be happy if someone can guide me in the correct direction to solve 
> this error.

It's adding a column which contains a geographic object. These only
contain the coordinate values, but in itself, they don't carry the
information about their coordinate reference system. This information
is stored at column creation time (in a separate table), as the SRID,
a simple number.

However, this SRID references another table, in which it does not
exist. Once you imported the SQL from
http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/900913.sql,
the error will go away. This defines the needed coordinate reference
system.

MfG, JBG

-- 
      Jan-Benedict Glaw      jbglaw at lug-owl.de              +49-172-7608481
Signature of:                     Eine Freie Meinung in einem Freien Kopf
the second  :                   für einen Freien Staat voll Freier Bürger.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.gpsdrivers.org/pipermail/gpsdrive/attachments/20081204/8ba34eb0/attachment.bin>