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. – Ilja Zverev Jun 4 '14 at 10:27

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) – Richard.Mauser Jun 3 '14 at 9:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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