[OSM-talk] Street lines aren't rendering for me in my own Planet - PostGIS - mapnik map

2009-07-12 Thread Ævar Arnfjörð Bjarmason
Hi there, I'm trying to set up my own rendering with mapnik but the
resulting images/tiles don't show streets/polygons normally, see:

The OSM map: http://www.flickr.com/photos/avarab/3713947443/
My map: http://www.flickr.com/photos/avarab/3714745132/

And some tiles I generated with generate_tiles.py:

http://openstreetmap.is/not-rendering-correctly/

When you zoom in the streets are actually there, they just don't have
their normal colored casing.

This is what I did to import the database:

http://www.mediawiki.org/wiki/Extension:SlippyMap/Mapnik

The database itself looks fine as far as I can tell, it has ways in
that area at least:

gis= select osm_id, name from planet_osm_line where osm_id = 32669907;
  osm_id  |  name
--+-
 32669907 | Hornbrekkuvegur
(1 row)

___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk


Re: [OSM-talk] Street lines aren't rendering for me in my own Planet - PostGIS - mapnik map

2009-07-12 Thread Ævar Arnfjörð Bjarmason
On Sun, Jul 12, 2009 at 10:58 PM, Ævar Arnfjörð
Bjarmasonava...@gmail.com wrote:
 Hi there, I'm trying to set up my own rendering with mapnik but the
 resulting images/tiles don't show streets/polygons normally, see:

 The OSM map: http://www.flickr.com/photos/avarab/3713947443/
 My map: http://www.flickr.com/photos/avarab/3714745132/

 And some tiles I generated with generate_tiles.py:

 http://openstreetmap.is/not-rendering-correctly/

 When you zoom in the streets are actually there, they just don't have
 their normal colored casing.

 This is what I did to import the database:

 http://www.mediawiki.org/wiki/Extension:SlippyMap/Mapnik

 The database itself looks fine as far as I can tell, it has ways in
 that area at least:

Actually I get this in the pgsql error log:

2009-07-12 23:29:17 GMT ERROR:  function asbinary() does not exist at
character 8
2009-07-12 23:29:17 GMT HINT:  No function matches the given name and
argument types. You might need to add explicit type casts.
2009-07-12 23:29:17 GMT STATEMENT:  select asbinary() as
geom,military,name,waterway,way_area from
  (select way,amenity,military,way_area,waterway,name
   from planet_osm_polygon
   where name is not null
   order by z_order,way_area desc
  ) as text
   where   setSRID('BOX3D(-2078059.694145257
9895070.006294288,-2073879.013716863
9898363.641982334)'::box3d,-1218672940)

That function exists in the gis DB:

gis= \df asbinary
 List of functions
 Schema |   Name   | Result data type | Argument data types
+--+--+-
 public | asbinary | bytea| geometry
 public | asbinary | bytea| geometry, text
(2 rows)

But it's a bit odd, I'm getting roads-text, turning circles,
leisure=pitch, and some other small stuff, but nothing else basically.

___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk


Re: [OSM-talk] Street lines aren't rendering for me in my own Planet - PostGIS - mapnik map

2009-07-12 Thread Ævar Arnfjörð Bjarmason
On Sun, Jul 12, 2009 at 11:31 PM, Ævar Arnfjörð
Bjarmasonava...@gmail.com wrote:
 On Sun, Jul 12, 2009 at 10:58 PM, Ævar Arnfjörð
 Bjarmasonava...@gmail.com wrote:
 Hi there, I'm trying to set up my own rendering with mapnik but the
 resulting images/tiles don't show streets/polygons normally, see:

 The OSM map: http://www.flickr.com/photos/avarab/3713947443/
 My map: http://www.flickr.com/photos/avarab/3714745132/

 And some tiles I generated with generate_tiles.py:

 http://openstreetmap.is/not-rendering-correctly/

 When you zoom in the streets are actually there, they just don't have
 their normal colored casing.

 This is what I did to import the database:

 http://www.mediawiki.org/wiki/Extension:SlippyMap/Mapnik

 The database itself looks fine as far as I can tell, it has ways in
 that area at least:

 Actually I get this in the pgsql error log:

 2009-07-12 23:29:17 GMT ERROR:  function asbinary() does not exist at
 character 8
 2009-07-12 23:29:17 GMT HINT:  No function matches the given name and
 argument types. You might need to add explicit type casts.
 2009-07-12 23:29:17 GMT STATEMENT:  select asbinary() as
 geom,military,name,waterway,way_area from
              (select way,amenity,military,way_area,waterway,name
               from planet_osm_polygon
               where name is not null
               order by z_order,way_area desc
              ) as text
               where   setSRID('BOX3D(-2078059.694145257
 9895070.006294288,-2073879.013716863
 9898363.641982334)'::box3d,-1218672940)

 That function exists in the gis DB:

 gis= \df asbinary
                     List of functions
  Schema |   Name   | Result data type | Argument data types
 +--+--+-
  public | asbinary | bytea            | geometry
  public | asbinary | bytea            | geometry, text
 (2 rows)

 But it's a bit odd, I'm getting roads-text, turning circles,
 leisure=pitch, and some other small stuff, but nothing else basically.

Ldp on IRC helped me out with this, I was running mapnik
0.5.1-3ubuntu2 but 6.0 is required. I didn't think it was because it's
not mentioned in the wiki documentation.

But the wiki is always out of date eh:)

___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk