andrewharvey/osm-hybrid-carto — Issue #1: Australia.osm.pbf data
Author: ns-1m
Created: 2011-10-10 02:13:50+00:00
State: open

Hi Andrew,

I am trying to use Australia.osm.pbf from geofabrik and import to my PostGIS using Osm2pgsql.

http://download.geofabrik.de/osm/australia-oceania/

I was not be to view the polygons in TileMill. The postgis supplying the data in Tilemill as I can see it in the view data in various layers but no display any map (i.e. layers).

I got these errors (below) in the various layers.

I am very interested to get Victoria OSM data with your osm-hybrid-carto theme in TileMill.

Do you know any idea why? I am using Mac OS X and TileMill 0.5.1.

Thanks in advance

################

Error: : ERROR: column "tags" does not exist LINE 9: tags->'cycleway' as cycleway ^ Full sql was: 'SELECT * FROM ( SELECT way, highway, access, bridge, tunnel, name, tags->'cycleway' as cycleway FROM planet_osm_line WHERE highway in ('cycleway') ) AS cycleway LIMIT 0'

Error: : ERROR: column "tags" does not exist LINE 7: tags->'cuisine' as cuisine, ^ Full sql was: 'SELECT * FROM ( ( SELECT way, amenity, shop, tags->'cuisine' as cuisine, name FROM planet_osm_point WHERE ( shop IS NOT null OR amenity IN ('fast_food') ) ) UNION ( SELECT ST_Centroid(way) as way, amenity, shop, tags->'cuisine' as cuisine, name FROM planet_osm_line WHERE ( shop IS NOT null OR amenity IN ('fast_food') ) ) ) AS shoppoi LIMIT 0'

Error: : ERROR: column "tags" does not exist LINE 11: tags->'school:level' as school_level, ^ Full sql was: 'SELECT * FROM ( ( SELECT way, amenity, man_made, tourism, leisure, barrier, building, tags->'school:level' as school_level, name FROM planet_osm_point WHERE (amenity IS NOT null OR man_made IS NOT null OR tourism IS NOT null OR leisure IS NOT null OR barrier IS NOT null OR building IS NOT null) ) UNION ( SELECT ST_Centroid(way) as way, amenity, man_made, tourism, leisure, barrier, null, tags->'school:level' as school_level, name FROM planet_osm_line WHERE (amenity IS NOT null OR man_made IS NOT null OR tourism IS NOT null OR leisure IS NOT null OR barrier IS NOT null) ) ) AS amenity_poi LIMIT 0'

Error: : ERROR: column "tags" does not exist LINE 9: tags->'footway' as footway, ^ Full sql was: 'SELECT * FROM ( SELECT way, highway, access, bridge, tunnel, name, tags->'footway' as footway, tags->'sidewalk' as sidewalk FROM planet_osm_line WHERE highway in ('footway', 'steps') ) AS highway LIMIT 0'