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 +nadgri...@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 _______________________________________________ Pkg-grass-devel mailing list Pkgemail@example.com http://lists.alioth.debian.org/mailman/listinfo/pkg-grass-devel