[OSM-newbies] only getting shapes; no roads, no names etc.

[Wim de Vries]

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 <wsvries at xs4all.nl> 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
> newbies at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/newbies
>