[Tile-serving] [openstreetmap/osm2pgsql] Enhance with a datamodel option, using JSONB (#533)

[Peter]

Hi @pnorman , sorry about my non-contextual copy/pasted examples  (I am in holidays and not at my work computer), but the generic example was didactic... To contextualize with real tables  ideal is a consensual *big picture* of the "default" and "most used" output structures, that I suggesting in #671

-----

> is what I do with hstore, and then it gets cast with the COPY command. ...

We all can do *cast* with `hstore_to_jsonb_loose()` and work with PL/pgSQL functions, shell scripts, etc. But this proposal is to simplify this task and standardise for all *osm2pgsql* users a reliable JSONb adaptation. 

**... Let's split and simplify  _this issue_**,

* suggestion 1: simplify consumption of OSM data ...  ClearTables  is great! migrating this part of the issue to [ClearTables/issues/98](https://github.com/ClearTables/ClearTables/issues/98)

* suggestion 2: a new option to use JSONb instead hstore... See  #672.



-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/533#issuecomment-271745550
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170110/8f21b2c6/attachment-0001.html>