I updated osm2pgsql (SVN version 0.68-18373). It uses default.style, but still the "function asbinary() does not exist at character" and other errors. Output image is now even worse.
> Thanks guys. > Indeed sth wrong with PostgreSQL. Not looking at the size, I tried to open > the log file. KDE/kate did not like it. It was 7+Gig! > Anyhow, stopped PostgreSQL deleted the log, restarted PostgreSQL, and ran > generate_image.py. > Indeed masses of errors in the log. Now I know the cause... But reading > the log, I do not understand anything of it.... > I hope there is some one who does understand this. > See a fraction of the log below. > >> On Fri, Oct 30, 2009 at 10:03 AM, Wim de Vries <[email protected]> >> wrote: >>> Hi, >>> I installed Mapnik successfully. I downloaded and 'osm2pgsql -m >>> netherlands.osm.bz' (from geofabrik). >>> generate_image.py and generate_tiles.py gave no errors. >>> I played with the zoom level. Still, I can only get shape images with >>> some >>> vague lines, but no further details. >>> Did not find anything about this problem after googling for some hours. >>> Is there sth. wrong in the (generated) osm.xml? >>> Thanks. >> >> Look at your PostgreSQL error log. Perhaps you are using too old a >> version of mapnik or some other tools in the stack. > ----------------- > > 2009-10-30 13:36:16 CET ERROR: column "barrier" does not exist at > character 144 > 2009-10-30 13:36:16 CET STATEMENT: select asbinary(way) as > geom,"aerialway","amenity","disused","name","natural","railway","tourism" > from (select * from planet_osm_polygon where barrier IS NOT NULL or > amenity IS NOT NULL or tourism is NOT NULL or railway is NOT NULL or > "natural" is NOT NULL or highway is NOT NULL or aeroway is NOT NULL or > aerialway is NOT NULL or power_source is NOT NULL or man_made is NOT NULL) > as amenity where way && setSRID('BOX3D(451957.1326206906 > 6753233.31802053,556597.4539663679 6857873.639366206)'::box3d,900913) > 2009-10-30 13:36:17 CET ERROR: function asbinary() does not exist at > character 8 > 2009-10-30 13:36:17 CET HINT: No function matches the given name and > argument types. You might need to add explicit type casts. > 2009-10-30 13:36:17 CET STATEMENT: select asbinary() as > geom,"highway","length","name","ref" from > (select way,highway,aeroway,name,ref,char_length(ref) as length, > case when bridge in ('yes','true','1') then 'yes'::text else > bridge end as bridge > from planet_osm_line > where waterway IS NULL > and leisure IS NULL > and landuse IS NULL > and (name is not null or ref is not null) > ) as roads > where && setSRID('BOX3D(451957.1326206906 > 6753233.31802053,556597.4539663679 > 6857873.639366206)'::box3d,723529774) > 2009-10-30 13:36:17 CET ERROR: column "ele" does not exist at character > 174 > 2009-10-30 13:36:17 CET STATEMENT: select asbinary() as > geom,"ele","highway","military","name","natural","place","ref" from > (select > way,amenity,highway,leisure,landuse,man_made,"natural",place,tourism,ele,name,ref,military,aeroway,'yes'::text > as point > from planet_osm_point > where amenity is not null > or leisure is not null > or landuse is not null > or tourism is not null > or "natural" is not null > or man_made='lighthouse' > or place='island' > or highway='motorway_junction' > or military='danger_area' > or aeroway='gate' > ) as text > where && setSRID('BOX3D(451957.1326206906 > 6753233.31802053,556597.4539663679 > 6857873.639366206)'::box3d,1936090468) > 2009-10-30 13:36:17 CET ERROR: function asbinary() does not exist at > character 8 > 2009-10-30 13:36:17 CET HINT: No function matches the given name and > argument types. You might need to add explicit type casts. > 2009-10-30 13:36:17 CET STATEMENT: select asbinary() as > geom,"ele","highway","military","name","natural","place","ref" from > (select > way,aeroway,amenity,highway,leisure,landuse,man_made,"natural",place,tourism,NULL > as ele,name,ref,military,'no'::text as point > from planet_osm_polygon > where amenity is not null > or leisure is not null > or landuse is not null > or tourism is not null > or "natural" is not null > or man_made='lighthouse' > or place='island' > or military='danger_area' > ) as text > where && setSRID('BOX3D(451957.1326206906 > 6753233.31802053,556597.4539663679 > 6857873.639366206)'::box3d,723529774) > 2009-10-30 13:36:17 CET ERROR: function asbinary() does not exist at > character 8 > 2009-10-30 13:36:17 CET HINT: No function matches the given name and > argument types. You might need to add explicit type casts. > 2009-10-30 13:36:17 CET STATEMENT: select asbinary() as > geom,"name","way_area" from > (select way,way_area,name > from planet_osm_polygon > where name is not null > and (waterway is null or waterway <> 'riverbank') > order by z_order,way_area desc > ) as text > where && setSRID('BOX3D(451957.1326206906 > 6753233.31802053,556597.4539663679 > 6857873.639366206)'::box3d,723529774) > > > > > > > > > > > >> >> _______________________________________________ >> newbies mailing list >> [email protected] >> http://lists.openstreetmap.org/listinfo/newbies >> > > > > _______________________________________________ > newbies mailing list > [email protected] > http://lists.openstreetmap.org/listinfo/newbies > _______________________________________________ newbies mailing list [email protected] http://lists.openstreetmap.org/listinfo/newbies
