[DebianGIS-dev] Bug#535221: Bug#535221: osm2pgsql: consider including 900913.sql in the package?

[Andreas Putzo]

Hello,

On Jun 30  22:57, Timo Juhani Lindfors wrote:
> Package: osm2pgsql
> Version: 0.66.20090526-1
> Severity: wishlist
> 
> http://wiki.openstreetmap.org/wiki/Mapnik
> 
> instructs that I should import some "900913.sql" which is "included
> with osm2pqsql". However, the debian package contains no such file.
> 
> Any idea how essential this is? I see the file in the source package,
> maybe it should be included in the binary package as well?

You are right, that file should be there
because standard postgis does not contain this projection and i guess
it would give weird results with mapnik. I will add this file as an example
in /usr/share/doc/osm2pgsql/examples/.

In case you not already extracted it from the source package, here is
the content until the updated package is available.

INSERT INTO spatial_ref_sys (srid, auth_name, auth_srid, srtext,
proj4text)VALUES (900913,'EPSG',900913,'PROJCS["WGS84 / Simple
Mercator",GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS_1984",
6378137.0, 298.257223563]],PRIMEM["Greenwich", 0.0],UNIT["degree",
0.017453292519943295],AXIS["Longitude", EAST],AXIS["Latitude",
NORTH]],PROJECTION["Mercator_1SP_Google"],PARAMETER["latitude_of_origin",
0.0],PARAMETER["central_meridian", 0.0],PARAMETER["scale_factor",
1.0],PARAMETER["false_easting", 0.0],PARAMETER["false_northing",
0.0],UNIT["m", 1.0],AXIS["x", EAST],AXIS["y",
NORTH],AUTHORITY["EPSG","900913"]]','+proj=merc +a=6378137 +b=6378137
+lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null
+no_defs');

> The wiki page links to
> 
> http://wiki.openstreetmap.org/wiki/Osm2pgsql
> 
> which says that osm2pgsl can be installed with apt-get. So if user
> should get "900913.sql" via some other means than apt-get I think we
> should document that in the wiki. (Yes I know bugs.debian.org is not
> for bugs in the openstreetmap wiki but...).

900913.sql is not essential for osm2pgsql to work, but it's still a bug
that is is missing from the package. So thanks for reporting it
here so that we can fix the package instead of 'reporting' it to 
the OSM wiki :)


Regards,
Andreas