<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Right on. Can we tweak osm2pgsql style to add start_date/end_date columns? Would then need to recreate the whole db once, not the minutely updates; but not a big deal since the db is still pretty small?<br></span></div><div></div><div> </div><div>* Mikel Maron * +14152835207 @mikel s:mikelmaron<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Jeff Meyer <jeff@gwhat.org><br> <b><span style="font-weight: bold;">To:</span></b> Mikel Maron
<mikel_maron@yahoo.com> <br><b><span style="font-weight: bold;">Cc:</span></b> "historic@openstreetmap.org" <historic@openstreetmap.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, April 30, 2013 8:26 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [OHM] Burning Man 2008 & 2009<br> </font> </div> <div class="y_msg_container"><br><div id="yiv4025232474"><div dir="ltr">Awesome... and you were so nice not to mention that renderd appeared to be pooped out... it's now restarted. : ) [1]<div><br></div><div style="">Quick answers (as best I can...):</div><div style=""><br></div><div style="">
For Planet_dump, I'm not sure what you mean, but minutely updates off of the ohm planet are being cranked out by a cron under www-data and then pumped into ohm tiles on a separate cron (that needs to be fixed).</div><div style="">
<br></div><div style="">More to follow, but I love where you're headed!</div><div style=""><br></div><div style="">- Jeff</div><div style=""><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div>
<br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div>[1]</div><div><br></div><div><br></div></div><div class="yiv4025232474gmail_extra">
<br><br><div class="yiv4025232474gmail_quote">On Tue, Apr 30, 2013 at 2:47 PM, Mikel Maron <span dir="ltr"><<a rel="nofollow" ymailto="mailto:mikel_maron@yahoo.com" target="_blank" href="mailto:mikel_maron@yahoo.com">mikel_maron@yahoo.com</a>></span> wrote:<br><blockquote class="yiv4025232474gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif;"><div><span>Hey</span></div><div style="font-style:normal;font-size:16.363636016845703px;background-color:transparent;">
<span><br></span></div><div style="font-style:normal;font-size:16.363636016845703px;background-color:transparent;"><span>I just uploaded Burning Man 2008 and 2009 to OpenHistoricalMap</span></div>
<div style="font-style:normal;font-size:16.363636016845703px;background-color:transparent;"><span><br></span></div><div style="font-style:normal;font-size:16.363636016845703px;background-color:transparent;">
<span><a rel="nofollow" target="_blank" href="https://twitter.com/mikel/status/329350866102517760">https://twitter.com/mikel/status/329350866102517760</a><br></span></div><div style="font-style:normal;font-size:16.363636016845703px;background-color:transparent;">
<span><br></span></div><div style="font-style:normal;font-size:16.363636016845703px;background-color:transparent;"><span><a rel="nofollow" target="_blank" href="http://www.openhistoricalmap.org/browse/changeset/45">http://www.openhistoricalmap.org/browse/changeset/45</a></span></div>
<div style="font-style:normal;font-size:16.363636016845703px;background-color:transparent;"><a rel="nofollow" target="_blank" href="http://www.openhistoricalmap.org/browse/changeset/47">http://www.openhistoricalmap.org/browse/changeset/47</a><br>
</div><div></div><div><br></div><div>This was already in OSM.org. Loaded the area, and filtered on start_date/end_date tags. Copy/pasted into a new layer. Changed the API end point setting. Uploaded.</div><div><br></div><div>
MapBox has a nice tutorial on using filters. To manage editing with <a rel="nofollow" target="_blank" href="http://osm.org/">osm.org</a> and <a rel="nofollow" target="_blank" href="http://ohm.org/">ohm.org</a>, probably a good practice to create some shortcuts which load different preferences files.</div>
<div><a rel="nofollow" target="_blank" href="http://mapbox.com/blog/2012-08-15-using-filters-josm/">http://mapbox.com/blog/2012-08-15-using-filters-josm/</a><br></div><div><a rel="nofollow" target="_blank" href="http://josm.openstreetmap.de/wiki/Help/CommandLineOptions">http://josm.openstreetmap.de/wiki/Help/CommandLineOptions</a><br>
</div><div><br></div><div>Next, I want to create two tile sets, one for 2008, another 2009.</div><div><br></div><div>First, involves using osm2pgsql with a style
file that includes start_date/end_date. How is planet dump and osm2pgsql being handled currently? On cron or manually?</div><div>Then, want to generate mapnik xml which will add the date filter to every query. Maybe start off by just two static mapnik xml (or more, for whatever other time frames we all are testing with). And configure mod_tile and the osm_website app to make have those tiles available in the layer chooser.</div>
<div>Later, set up mod_tile to pass along start_date and end_date parameters from request.</div><div><br></div><div>-Mikel</div><div><br></div><div><br></div><div><br></div><div>* Mikel Maron * <a rel="nofollow" href="">+14152835207</a> @mikel s:mikelmaron</div>
</div></div><br>_______________________________________________<br>
Historic mailing list<br>
<a rel="nofollow" ymailto="mailto:Historic@openstreetmap.org" target="_blank" href="mailto:Historic@openstreetmap.org">Historic@openstreetmap.org</a><br>
<a rel="nofollow" target="_blank" href="http://lists.openstreetmap.org/listinfo/historic">http://lists.openstreetmap.org/listinfo/historic</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><font size="1">Jeff Meyer<br>Global World History Atlas<br><a rel="nofollow" target="_blank" href="http://www.gwhat.org/">www.gwhat.org</a><br><a rel="nofollow" ymailto="mailto:jeff@gwhat.org" target="_blank" href="mailto:jeff@gwhat.org">jeff@gwhat.org</a><br>
206-676-2347</font><div><font size="1"><br></font></div><div><span style="font-size:x-small;">OpenStreetMap: Mapping with a Human Touch</span><font size="1"><br></font><div><font size="1"><a rel="nofollow" target="_blank" href="http://www.openstreetmap.org/user/jeffmeyer"><img src="http://wiki.openstreetmap.org/w/images/thumb/7/79/Public-images-osm_logo.svg/24px-Public-images-osm_logo.svg.png"></a> </font><span style="font-size:x-small;">osm: <a rel="nofollow" target="_blank" href="http://wiki.openstreetmap.org/wiki/Open_Historical_Map">Open Historical Map (OHM)</a> / <a rel="nofollow" target="_blank" href="http://www.openstreetmap.org/user/jeffmeyer">my OSM user page</a></span></div>
<div><img src="http://lincs.ed.gov/sites/default/files/twitter-icon-24x24.png"> <font size="1">t: <a rel="nofollow" target="_blank" href="https://twitter.com/GWHAThistory">@GWHAThistory</a></font></div><div></div><div><img src="http://external.ak.fbcdn.net/safe_image.php?d=AQCki9dbi3qyfa_g&w=155&h=114&url=http%3A%2F%2Fsocialmediachapter.com%2Fimages%2F09825d933fd5044ce4ae18101982a012_u1mq.png"> <font size="1">f: <a rel="nofollow" target="_blank" href="https://www.facebook.com/GWHAThistory">GWHAThistory</a></font></div>
<div><br></div><div><font size="1"><br></font><br></div></div>
</div></div><br><br></div> </div> </div> </blockquote></div> </div></body></html>