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

[Wim de Vries]

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 <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
>>
>
>
>
> _______________________________________________
> newbies mailing list
> newbies at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/newbies
>