Martijn van Oosterhout wrote:ections, generate_image.py and OSM-data On Sat, Mar 22, 2008 at 2:53 PM, Rahkonen Jukka wrote:
>> So I ought to be doing just the right thing when giving >> bbox = Envelope(3376400,6672200,3377400,6673200)? >> However, obviously something goes wrong before the database is queried. >> Have I ane way to debug is further by myself? Can I somehow check what gets >> feeded into bbox, or is it anything human readable at all? > Actually, there's another option. I just committed a patch to > osm2pgsql which allows you to select any EPSG projection for the > database. It is often advisable to store the bulk of you data in the > same projection as the output for performance reasons. Even though > what you're doing should work it might offer you a way out. Well, as I told in the beginning of this thread, I am just a regular GIS user and also stuck with Windows. I can use only osm2pgsql.exe Windows executable and Mapnik that comes from Windows installer. On the other hand, changing projection in the database is no problem, I am doing it regularly anyway either by update: update osm_point set way=transform(way,2393); update geometry_columns set srid=2393 where f_table_name='osm_point'; or by creating new tables with query: DROP TABLE osm_primary; CREATE TABLE osm_primary WITH OIDS TABLESPACE pg_default AS (SELECT osm_id, way, highway, ref, name FROM osm_line WHERE highway='primary' OR highway='primary_link'); I have also other reasons for running the latter. When used through Mapserver and Geoserver the PostGIS tables must have primary key and something unique. Tables created with osm2pgsql.exe are not usable as it, because they do not have any column with unique values and thus usable as primary key. osm_id is close to that, but at least osm_line table has double values which come if OSM way is not contiguous. Osm2pgsql splits it to several geometries with same osm_id. Thank you for all the help so far. I will make some further trials with osm data projected to epsg:2393 in the database. -Jukka Rahkonen- _______________________________________________ Mapnik-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/mapnik-users
