I made a PostgreSQL with PosGIS Extension DB with the pgsnapshot_schema and loaded an .osm.pbf-file with OSMOSIS into it. Now i connected it to TileMill, but if i look up into the table i just see columns with the datatype of integer(id, version, User_id,changset_id). But i would like to use Tilemill with the hstore column to select the data and use it for the labels!

In TileMill i wrote into the Table or subquery: ways; Geometry field: linestring

Does anyone know, how i can fix it easily?

This is how it looks like

  • Should that window even display hstore? You should be able use it in PostGIS layer query, regardless of what this window shows. Jun 4, 2014 at 10:27

1 Answer 1


Hstore is extension of postgresql so maybe it is not enabled?


Create extension hstore;
  • I checked out in my PostGIS DB i can see the column, so hstore is enabled. And the command says the same thanks! I readed i have to do a Typecast, something like CAST(layer AS INTEGER) Jun 3, 2014 at 9:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.