[DebianGIS-dev] Bug#535221: Bug#535221: osm2pgsql: consider including 900913.sql in the package?
andreas at putzo.net
Wed Jul 1 19:30:12 UTC 2009
On Jun 30 22:57, Timo Juhani Lindfors wrote:
> Package: osm2pgsql
> Version: 0.66.20090526-1
> Severity: wishlist
> 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 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
6378137.0, 298.257223563]],PRIMEM["Greenwich", 0.0],UNIT["degree",
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
> The wiki page links to
> 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 :)
More information about the Pkg-grass-devel