[OSM-newbies] Mapnik local tiles are missing data

[Lennard]

On 6-8-2010 17:27, Trevan Richins wrote:

> I'm going through the mapnik debug logs to see if I missed anything and I noticed that every single postgis query is followed by a line:
>
> PostGIS: unknown type = geometry (oid: 16400)
>
> Is that supposed to happen?

No, and you should get 1 result from:

select * from spatial_ref_sys where srid = 4326;

If not, did you remember to load spatial_ref_sys.sql ?

Also try a real query. Something along the lines of:

select ST_AsText(way),amenity from planet_osm_point where amenity is not 
null limit 10;

Which should give you some results, like:

              st_astext              |     amenity
------------------------------------+------------------
  POINT(4.32584759999999 50.8364026) | place_of_worship
  POINT(4.32585730000001 50.5983521) | bank
  POINT(4.32602639999999 52.0805667) | parking

-- 
Lennard