No subject
Tue May 5 08:38:44 EST 2009
> ./osm2pgsql -l -d gis india.osm.bz2=20
According to both your suggestions, I droped the database "gis", and recrea=
ted it !
Now when I did execute the following command=20
____________________________________________________________
./osm2pgsql -l -E EPSG:4326 -d gis ~/mapnik-0.6.0/osmFiles/india.osm.bz2
It resulted in the following output:
____________________________________________________________
osm2pgsql SVN version 0.69-19270
Using projection SRS 4326 (Latlong)
Setting up table: planet_osm_point
NOTICE: table "planet_osm_point" does not exist, skipping
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
SELECT AddGeometryColumn('planet_osm_point', 'way', 4326, '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
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Then I executed the following command:
psql -f 900913.sql -d gis
It resulted in the following output:
INSERT 0 1
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Then I executed the following command=20
____________________________________________________________
./osm2pgsql -l -E EPSG:4326 -d gis ~/mapnik-0.6.0/osmFiles/india.osm.bz2
and again it resulted in the following output:
____________________________________________________________
osm2pgsql SVN version 0.69-19270
Using projection SRS 4326 (Latlong)
Setting up table: planet_osm_point
NOTICE: table "planet_osm_point" does not exist, skipping
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
SELECT AddGeometryColumn('planet_osm_point', 'way', 4326, '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
PLEASE HELP, IF YOU CAN !!
--=20
Regards,
Anisha Kaul
-------------------------------------
Hi-Tech Gears Limited, Gurgaon, India
More information about the Proj
mailing list