[OSM-newbies] Mapnik local tiles are missing data

[Trevan Richins]

Sorry I haven't replied back in a while.  I decided to rerun the osm2pgsql command with the -l parameter.  It has finally finished and now the maps are generating correctly.  So, it looks like there might be a bug with the -E 4326 option.

Thanks for all the help.
Trevan

-----Original Message-----
From: newbies-bounces at openstreetmap.org [mailto:newbies-bounces at openstreetmap.org] On Behalf Of Lennard
Sent: Friday, August 06, 2010 11:39 AM
To: newbies at openstreetmap.org
Subject: Re: [OSM-newbies] Mapnik local tiles are missing data

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

_______________________________________________
newbies mailing list
newbies at openstreetmap.org
http://lists.openstreetmap.org/listinfo/newbies

The information in this e-mail and in any attachments is confidential and may be privileged.  If you are not the intended recipient, please destroy this message, delete any copies held on your systems and notify the sender immediately.  You should not retain copy or use this e-mail for any purpose, nor disclose all or any part of its content to any other person.