[OSM-dev] Which SRID in PostGIS for Mapnik rendering is needed?

[Ivo Brodien]

hi,

for some reason it suddenly works, no idea what I changed.

I found a lot of this in the Logs. I guess I can ignore it? Eg it says
no column barrier found and it is true, there is none. Why is it in
the statement?

thanks and bye
Ivo

the Logs:

STATEMENT:  select asbinary(way) as
geom,"barrier","man_made","natural" from (select
way,barrier,highway,landuse,"natural",man_made,waterway,name,ref,char_length(ref)
as length from planet2_line where waterway IS NULL and leisure IS NULL
and landuse IS NULL) as roads where way &&
setSRID('BOX3D(1492891.599437777 6889040.048258077,1493197.347550918
6889345.796371222)'::box3d,900913)
ERROR:  column "construction" does not exist at character 59
STATEMENT:  select asbinary(way) as
geom,"aeroway","bicycle","bridge","construction","foot","highway","horse","railway","route","tunnel"
from (select * from planet2_line order by z_order) as roads where way
&& setSRID('BOX3D(1492891.599437777
6889040.048258077,1493197.347550918 6889345.796371222)'::box3d,900913)
ERROR:  column "construction" does not exist at character 71
STATEMENT:  select asbinary(way) as
geom,"aerialway","aeroway","bicycle","bridge","construction","foot","highway","horse","railway","route","tunnel"
from (select * from planet2_line order by z_order) as roads where way
&& setSRID('BOX3D(1492891.599437777
6889040.048258077,1493197.347550918 6889345.796371222)'::box3d,900913)
ERROR:  column "barrier" does not exist at character 99
STATEMENT:  select asbinary(way) as geom,"aerialway","name","railway"
from (select * from planet2_point 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) as amenity where way &&
setSRID('BOX3D(1492891.599437777 6889040.048258077,1493197.347550918
6889345.796371222)'::box3d,900913)
ERROR:  column "barrier" does not exist at character 163
STATEMENT:  select asbinary(way) as
geom,"aerialway","barrier","highway","man_made","name","natural","power","power_source","railway"
from (select * from planet2_point 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) as amenity where way &&
setSRID('BOX3D(1492891.599437777 6889040.048258077,1493197.347550918
6889345.796371222)'::box3d,900913)
ERROR:  column "barrier" does not exist at character 194
STATEMENT:  select asbinary(way) as
geom,"aerialway","amenity","barrier","highway","man_made","name","natural","power","power_source","railway","religion","tourism"
from (select * from planet2_point 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) as amenity where way &&
setSRID('BOX3D(1492891.599437777 6889040.048258077,1493197.347550918
6889345.796371222)'::box3d,900913)
ERROR:  column "addr:interpolation" does not exist at character 30
STATEMENT:  select asbinary(way) as geom,"addr:interpolation" from
(select * from planet2_line order by z_order) as interpolation where
way && setSRID('BOX3D(1492891.599437777
6889040.048258077,1493197.347550918 6889345.796371222)'::box3d,900913)
ERROR:  column "addr:housenumber" does not exist at character 30
STATEMENT:  select asbinary(way) as geom,"addr:housenumber","building"
from (select * from planet2_polygon order by z_order,way_area desc) as
node_numbers where way && setSRID('BOX3D(1492891.599437777
6889040.048258077,1493197.347550918 6889345.796371222)'::box3d,900913)
ERROR:  column "addr:housenumber" does not exist at character 30
STATEMENT:  select asbinary(way) as geom,"addr:housenumber" from
planet2_point where way && setSRID('BOX3D(1492891.599437777
6889040.048258077,1493197.347550918 6889345.796371222)'::box3d,900913)
ERROR:  column "barrier" does not exist at character 68
STATEMENT:  select asbinary(way) as geom,"man_made","natural" from
(select way,barrier,highway,landuse,"natural",man_made,waterway,name,ref,char_length(ref)
as length from planet2_line where waterway IS NULL and leisure IS NULL
and landuse IS NULL) as roads where way &&
setSRID('BOX3D(1492891.599437775 6888887.174201505,1493197.347550921
6889192.922314651)'::box3d,900913)
ERROR:  column "barrier" does not exist at character 78
STATEMENT:  select asbinary(way) as
geom,"barrier","man_made","natural" from (select
way,barrier,highway,landuse,"natural",man_made,waterway,name,ref,char_length(ref)
as length from planet2_line where waterway IS NULL and leisure IS NULL
and landuse IS NULL) as roads where way &&
setSRID('BOX3D(1492891.599437775 6888887.174201505,1493197.347550921
6889192.922314651)'::box3d,900913)
ERROR:  column "construction" does not exist at character 59
STATEMENT:  select asbinary(way) as
geom,"aeroway","bicycle","bridge","construction","foot","highway","horse","railway","route","tunnel"
from (select * from planet2_line order by z_order) as roads where way
&& setSRID('BOX3D(1492891.599437775
6888887.174201505,1493197.347550921 6889192.922314651)'::box3d,900913)

On Thu, Mar 19, 2009 at 7:02 PM, sly (sylvain letuffe)
<liste at letuffe.org> wrote:
>> My osm tables use Google Mercartor (SRID= 900913) What is mapnik
>> expecting? 3395 ?
>
> No it's good. If you've used osm2pgsql to populate the db, and if you use a
> copy of the osm.xml
> ( starting with :
> <Map bgcolor="#b5d0d0" srs="+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0
> +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over">
> )
>
> Then everything should be fine.
>
> Access restrictions at postgres level ?
> Turn on the logs of postgres and try some custom basic queries to see if the
> data is here.
>
> select * from planet_osm_roads limit 1;
>
>
> --
> sly
> Sylvain Letuffe liste at letuffe.org
> qui suis-je : http://slyserv.dyndns.org
>
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>



-- 
Ivo Brodien