<p><a href="https://github.com/ppKrauss" class="user-mention">@ppKrauss</a></p>
<blockquote>
<p>It is about "user community", JSON community is bigger tham HStore.</p>
</blockquote>
<p>I think the similar issue will be in the future with:  <a href="https://en.wikipedia.org/wiki/Well-known_text">WKB</a>  vs  <a href="https://en.wikipedia.org/wiki/GeoJSON">GeoJSON</a></p>
<p>imho:      my quick & dirty solution  -  is  just creating  a  simple <code>view</code> :</p>
<div class="highlight highlight-source-sql"><pre><span class="pl-k">CREATE</span> <span class="pl-k">VIEW</span> <span class="pl-en">planet_osm_point_json</span>   <span class="pl-k">AS</span> <span class="pl-k">SELECT</span> hstore_to_json(tags) <span class="pl-k">as</span> json_tags , ST_AsGeoJSON(way) <span class="pl-k">as</span> osm_geojson,<span class="pl-k">*</span>  <span class="pl-k">FROM</span> planet_osm_point ;
<span class="pl-k">CREATE</span> <span class="pl-k">VIEW</span> <span class="pl-en">planet_osm_line_json</span>    <span class="pl-k">AS</span> <span class="pl-k">SELECT</span> hstore_to_json(tags) <span class="pl-k">as</span> json_tags , ST_AsGeoJSON(way) <span class="pl-k">as</span> osm_geojson,<span class="pl-k">*</span>  <span class="pl-k">FROM</span> planet_osm_line ;
<span class="pl-k">CREATE</span> <span class="pl-k">VIEW</span> <span class="pl-en">planet_osm_polygon_json</span> <span class="pl-k">AS</span> <span class="pl-k">SELECT</span> hstore_to_json(tags) <span class="pl-k">as</span> json_tags , ST_AsGeoJSON(way) <span class="pl-k">as</span> osm_geojson,<span class="pl-k">*</span>  <span class="pl-k">FROM</span> planet_osm_polygon ;
<span class="pl-k">CREATE</span> <span class="pl-k">VIEW</span> <span class="pl-en">planet_osm_roads_json</span>   <span class="pl-k">AS</span> <span class="pl-k">SELECT</span> hstore_to_json(tags) <span class="pl-k">as</span> json_tags , ST_AsGeoJSON(way) <span class="pl-k">as</span> osm_geojson,<span class="pl-k">*</span>  <span class="pl-k">FROM</span> planet_osm_roads ;</pre></div>
<p>And probably we can create a document about the best practices  (  <code>./docs/json_processing.md</code>  )</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/osm2pgsql/issues/672#issuecomment-274268877">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AD2-7ngxYl7JsnQsk7YkFDQpTsI7in-xks5rUiaRgaJpZM4Lf_WB">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AD2-7pR7aXP-oHBjtuW_QUKGj_UDd-OCks5rUiaRgaJpZM4Lf_WB.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
  <link itemprop="url" href="https://github.com/openstreetmap/osm2pgsql/issues/672#issuecomment-274268877"></link>
  <meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>

<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/openstreetmap/osm2pgsql","title":"openstreetmap/osm2pgsql","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/openstreetmap/osm2pgsql"}},"updates":{"snippets":[{"icon":"PERSON","message":"@ImreSamu in #672: @ppKrauss \r\n\u003e It is about \"user community\", JSON community is bigger tham HStore.\r\n\r\nI think the similar issue will be in the future with:  [WKB](https://en.wikipedia.org/wiki/Well-known_text)  vs  [GeoJSON](https://en.wikipedia.org/wiki/GeoJSON)    \r\n\r\nimho:      my quick \u0026 dirty solution  -  is  just creating  a  simple `view` :  \r\n```sql\r\nCREATE VIEW planet_osm_point_json   AS SELECT hstore_to_json(tags) as json_tags , ST_AsGeoJSON(way) as osm_geojson,*  FROM planet_osm_point ;\r\nCREATE VIEW planet_osm_line_json    AS SELECT hstore_to_json(tags) as json_tags , ST_AsGeoJSON(way) as osm_geojson,*  FROM planet_osm_line ;\r\nCREATE VIEW planet_osm_polygon_json AS SELECT hstore_to_json(tags) as json_tags , ST_AsGeoJSON(way) as osm_geojson,*  FROM planet_osm_polygon ;\r\nCREATE VIEW planet_osm_roads_json   AS SELECT hstore_to_json(tags) as json_tags , ST_AsGeoJSON(way) as osm_geojson,*  FROM planet_osm_roads ;\r\n```\r\n\r\nAnd probably we can create a document about the best practices  (  `./docs/json_processing.md`  )  \r\n\r\n\r\n"}],"action":{"name":"View Issue","url":"https://github.com/openstreetmap/osm2pgsql/issues/672#issuecomment-274268877"}}}</script>