<div dir="ltr">The next best thing that could happen... is to have osm2pgsql (and maybe similar other tools like imposm) to take advantage of augmented diffs produced by overpass-API.<div><br></div><div>These augmented diffs have 2 benefits:</div>
<div>- they are created thru your own query (so you can get them for any area, like the bbox of your choice)</div><div>- they are greatly self-contained*, making most of the awful slim tables** not required anymore</div>
<div>
<br></div><div>We simply need someone to implement their support... I expected to have a student doing that this summer, but it will not be the case.</div><div><div><br class="">This is on top of my "OSM dev wish list": <a href="https://cquest.hackpad.com/OSM-dev-wish-list-3OhxQgDuiEK">https://cquest.hackpad.com/OSM-dev-wish-list-3OhxQgDuiEK</a></div>
</div><div><br></div><div><br></div><div>* they contain ways related to modified nodes, as well as nodes related to ways... making the planet_osm_ways table useless for updated</div><div>** as a reminder: osm2pgsql "slim" tables... they take 250GB of space on a planet database, where you have around 150-200GB of useful point/line/roads/polygon data.</div>
<div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-07-03 17:11 GMT+02:00 Sachin Dole <span dir="ltr"><<a href="mailto:sdole@genvega.com" target="_blank">sdole@genvega.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">thanks sly, that was good info for me. and thanks Ilya for asking the question.</div><div class="gmail_extra">
<br><br><div class="gmail_quote"><div><div class="h5">On Thu, Jul 3, 2014 at 10:01 AM, sly (sylvain letuffe) <span dir="ltr"><<a href="mailto:liste2@letuffe.org" target="_blank">liste2@letuffe.org</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><u></u>
<div style="font-family:'Bitstream Charter';font-size:16pt;font-weight:400;font-style:normal"><div>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">On jeudi 3 juillet 2014, Ilya Zverev wrote:</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> If, with comments above, this</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> script is still not the best way to have regional minutely updates,</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> please point me to an alternative.</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"> </p>
</div><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">I wasn't saying that what you did is or isn't the best way ("best" beeing relative to a need) to have regional diffs, I was just pointing out, for you, or for anyone with a need of "subregional diffs" who might not know, that there exists those 2 alternatives I pointed out.</p>
<div>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"> </p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">-- </p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">sly, direct contact : <a href="mailto:sylvain@letuffe.org" target="_blank">sylvain@letuffe.org</a></p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><a href="http://wiki.openstreetmap.org/wiki/User:Sletuffe" target="_blank">http://wiki.openstreetmap.org/wiki/User:Sletuffe</a></p>
</div></div><br></div></div><div class="">_______________________________________________<br>
dev mailing list<br>
<a href="mailto:dev@openstreetmap.org" target="_blank">dev@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/dev" target="_blank">https://lists.openstreetmap.org/listinfo/dev</a><br>
<br></div></blockquote></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br>President | Genvega Inc. | <a href="http://www.genvega.com" target="_blank">www.genvega.com</a> |
tel: 630.290.2561
</font></span></div>
<br>_______________________________________________<br>
dev mailing list<br>
<a href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/dev" target="_blank">https://lists.openstreetmap.org/listinfo/dev</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">Christian Quest - OpenStreetMap France</div>
</div>