[OHM] Dev Update

[Tim Waters]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/historic/attachments/20140512/63739b69/attachment.html>