Re: [OSM-talk] mapnik does not display symbols
On Thursday 12 March 2009 23:26:14 Jon Burgess wrote: On Thu, 2009-03-12 at 18:15 +0530, Kenneth Gonsalves wrote: looks like the problem is missing columns in the lenny install. I checked and find the fedora10 install has 52 columns whereas the lenny one has only 41. I cannot find the file which contains the create table statement - if I can get my hands on that, I could check and manually add the missing columns. btw, the fedora10 install does not have a 'construction' column, but still works. Any idea where this create table statement is and where does it get a list of columns? The create table command is generated by osm2pgsql. The list of columns is defined in the default.style I mentioned earlier in this email chain. ok. reinstalled everything - default.style has kicked in and I am getting all the columns including the 'construction' column. When I run generate_image.py, I am getting a perfect image. But when using renderd and mod_tile, I get a good image upto about zoom level 12, higher zooms are giving a b0rked image. You can see this here: http://greenchilly.in -- regards Kenneth Gonsalves Associate NRC-FOSS http://nrcfosshelpline.in/web/ ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] mapnik does not display symbols
On Thu, 2009-03-12 at 18:15 +0530, Kenneth Gonsalves wrote: looks like the problem is missing columns in the lenny install. I checked and find the fedora10 install has 52 columns whereas the lenny one has only 41. I cannot find the file which contains the create table statement - if I can get my hands on that, I could check and manually add the missing columns. btw, the fedora10 install does not have a 'construction' column, but still works. Any idea where this create table statement is and where does it get a list of columns? The create table command is generated by osm2pgsql. The list of columns is defined in the default.style I mentioned earlier in this email chain. Jon ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] mapnik does not display symbols
On Tue, 2009-03-10 at 16:25 +0530, Kenneth Gonsalves wrote: On Tuesday 10 March 2009 14:20:41 you wrote: On Tue, 2009-03-10 at 06:26 +0530, Kenneth Gonsalves wrote: On Tuesday 10 March 2009 00:19:03 you wrote: The most likely problem is that you have not used an up to date copy of default.style when running the osm2pgsql import. If so, you may be missing some of the columns in the DB tables and Mapnik will silently fail to render any layer which references the missing data. I did not see any mention anywhere of default.style when running the import - could you elaborate please. osm2pgsql has the following option: -S|--style Location of the style file. Defaults to ./default.style The default.style file has a list of the keys which it will import into the postgresql database like: node,way admin_level text linear node,way aerialwaytext linear node,way aeroway text polygon node,way amenity text nocache,polygon There is a better description of this file in the comments [1]. As new fields are added into the osm.xml, each new column must be added into the default.style too. To use the latest osm.xml you also need to use the latest default.style when importing the data. I do not have access to the server to try this out, but the problem appears more complex. I have the same set up on fedora10 (local machine) and lenny (remote server). The rendering on the local machine is perfect. On the remote machine it is defective - not only missing symbols, but even the roads are the wrong colour. The osm.xml files are the same and the india.osm file imported into the db is the same - and the same syntax was used with osm2pgsql to import it. I am attaching two screenshots to show the difference. I *must* be missing something in the lenny install I think I know the cause. I just saw the very similar looking tiles when doing some local rendering after picking up the latest osm.xml file. You are probably missing the column named construction in your database. See whether executing the following commands in your DB fixes it: $ psql gis ... gis= alter table planet_osm_point add column construction text; ALTER TABLE Time: 284.689 ms gis= alter table planet_osm_line add column construction text; ALTER TABLE Time: 76.898 ms gis= alter table planet_osm_roads add column construction text; ALTER TABLE Time: 9.854 ms gis= alter table planet_osm_polygon add column construction text; ALTER TABLE Time: 34.955 ms If you update the osm2pgsql SVN to the latest version you should see the default.style now has a construction column (since r13945). Whenever you pick up a new osm.xml style it is important to note if there are any changes in the osm2pgsql default.style file. If there are, then you probably need to re-import your rendering DB. Alternatively a tweak like the commands above will add the new column, which should fix the rendering, but the data in the new column will just be empty until you run the import again. Jon ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] mapnik does not display symbols
On Tue, 2009-03-10 at 06:26 +0530, Kenneth Gonsalves wrote: On Tuesday 10 March 2009 00:19:03 you wrote: The most likely problem is that you have not used an up to date copy of default.style when running the osm2pgsql import. If so, you may be missing some of the columns in the DB tables and Mapnik will silently fail to render any layer which references the missing data. I did not see any mention anywhere of default.style when running the import - could you elaborate please. osm2pgsql has the following option: -S|--style Location of the style file. Defaults to ./default.style The default.style file has a list of the keys which it will import into the postgresql database like: node,way admin_level text linear node,way aerialwaytext linear node,way aeroway text polygon node,way amenity text nocache,polygon There is a better description of this file in the comments [1]. As new fields are added into the osm.xml, each new column must be added into the default.style too. To use the latest osm.xml you also need to use the latest default.style when importing the data. Jon 1: http://trac.openstreetmap.org/browser/applications/utils/export/osm2pgsql/default.style ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] mapnik does not display symbols
On Tue, 2009-03-10 at 16:25 +0530, Kenneth Gonsalves wrote: I do not have access to the server to try this out, but the problem appears more complex. I have the same set up on fedora10 (local machine) and lenny (remote server). The rendering on the local machine is perfect. On the remote machine it is defective - not only missing symbols, but even the roads are the wrong colour. The osm.xml files are the same and the india.osm file imported into the db is the same - and the same syntax was used with osm2pgsql to import it. I am attaching two screenshots to show the difference. I *must* be missing something in the lenny install These tiles definitely look odd. Is this with a standard Lenny install plus SVN mapnik, mod_tile, osm2pgsql? Are there any other non-lenny packages for postgresql, boost, gcc etc? Are you running on a 32 or 64 bit host? I think I'll need to create a kvm instance with a lenny install to try to reproduce it. You may want to raise a bug on http://trac.mapnik.org since it lokos to be a mapnik related problem, not something directly due to OSM data itself. Jon ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] mapnik does not display symbols
On Mon, 2009-03-09 at 16:47 +0530, Kenneth Gonsalves wrote: I have set up mapnik and mod_tile to display my own slippy map. I used the cloudmade osm file for my country. The map displays, but no symbols (like hospital or ATM) are being displayed. The symbols are loading, but not displaying - any idea where to look to debug this? What zoom are you looking at? Some features like ATMs only appear on zooms 17 18. The most likely problem is that you have not used an up to date copy of default.style when running the osm2pgsql import. If so, you may be missing some of the columns in the DB tables and Mapnik will silently fail to render any layer which references the missing data. Jon ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] mapnik does not display symbols
On Tuesday 10 March 2009 00:19:03 you wrote: I have set up mapnik and mod_tile to display my own slippy map. I used the cloudmade osm file for my country. The map displays, but no symbols (like hospital or ATM) are being displayed. The symbols are loading, but not displaying - any idea where to look to debug this? What zoom are you looking at? Some features like ATMs only appear on zooms 17 18. I have upto 19 The most likely problem is that you have not used an up to date copy of default.style when running the osm2pgsql import. If so, you may be missing some of the columns in the DB tables and Mapnik will silently fail to render any layer which references the missing data. I did not see any mention anywhere of default.style when running the import - could you elaborate please. -- regards Kenneth Gonsalves Associate NRC-FOSS http://nrcfosshelpline.in/web/ ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk