mapbox/osm-bright — Issue #30: PSQL datasource error
Author: jamesw05
Created: 2012-02-05 16:57:45+00:00
State: open

after osm2pgsql import and build, the project renders in Tilemill. When zooming in to level 10, i get a PSQL error:

Postgis Plugin: PSQL error:
ERROR: column "oneway" does not exist
LINE 1: SELECT ST_AsBinary("way") AS geom,"name","oneway","reflen","...
^
Full sql was: 'SELECT ST_AsBinary("way") AS geom,"name","oneway","reflen","type" from ( SELECT way, highway AS type, name, ref, CHAR_LENGTH(ref) AS reflen
FROM planet_osm_line
WHERE highway IN ('motorway', 'trunk')
AND (name <> '' OR ref <> '')
) AS data WHERE "way" && SetSRID('BOX3D(-8707706.262247277 4598451.621636204,-8590298.986801246 4715858.897082234)'::box3d, 900913)'

Viewing the DB, the column 'oneway' in table 'planet_osm_line' does exist. Could this be a bb issue, or a specific to the osm extract that i tried? I tried the DC extract: http://metro.teczno.com/#dc-baltimore