Hi folks just a little bit of an update on some dev stuff:
I've tweaked the osm2pgsql scripts and styles which parses start_date and end_date and puts them into postgresql date type, and also creates a new column for the year only as a number column "start_date_year" etc The code is a bit scrappy at the moment and doesn't do a great job parsing out all the types of ways that people store dates, but it's a start :) Then within the Carto side of things, we create table views in the rendering database with a date or year query and update the project.mml files with the new table name. Seems easier to do it this way than it is to wrangle in the bits of a temporal query within the project.mml files each time. This means that we can begin a workflow to make map tiles for epochs, years and ranges! As a start I've recreated the 2008 and 2009 layers that Mikel did last year. This is coming from a static non replicated database currently. Example: Standard OHM showing two years of Burning Man festival: http://www.openhistoricalmap.org//#map=15/40.7776/-119.2180&layers=H 2008 http://www.openhistoricalmap.org//#map=15/40.7776/-119.2180&layers=8 2009 http://www.openhistoricalmap.org//#map=15/40.7776/-119.2180&layers=9 I'm also sparsely documenting things here: http://wiki.openstreetmap.org/wiki/OHM/Dev and code is on our repo: https://github.com/openhistoricalmap I'd love to have a couple of extra layers - what are some good years / range of years to use? Next steps: Improve the lua tag parsing to catch most of the dates. Switch to the replicated ohm_gis database. Create a couple of extra layers. Cheers, Tim
_______________________________________________ Historic mailing list [email protected] https://lists.openstreetmap.org/listinfo/historic
