Don't include deprecated WOF neigbourhoods (stale dump)

[nvkelso]

• What did you see? Tenderloin neighbourhood label is visible in NYC.
• What did you expect to see? This label shouldn't be visible, it's been deprecated in WOF upstream from 2018.
• What map location are you having problems with? Tenderloin label near Herald Square in New York City.
  • http://tangrams.github.io/bubble-wrap/#16/40.7518/-73.9849
• Screenshot?
  

[nvkelso]

[zerebubuth]

We do support the edtf:deprecated tag, so the problem could either be a bug or that the WOF dump we're using is older than the deprecation was added to the record.

[nvkelso]

Where is the WOF dump configured?

[zerebubuth]

It's just a static dump that we download and restore as part of tileops. Headers on the dump suggest it was last updated around 12 Apr 2018, although it's possible it might be older than that.

[nvkelso]

We should update the dump, then? Or really try for a "last good" distribution from WOF on DB setup?

Was it on a regular chron before, but then switching to RAWR tiles we just dump'd instead of doing a live load off the WOF distributions on DB setup?

See also:

• https://dist.whosonfirst.org/sqlite/
• https://dist.whosonfirst.org/sqlite/whosonfirst-data-latest.db.bz2

[zerebubuth]

Yes, we used to have an automatic update process for WOF which ran on a schedule, the same way we were updating with diffs from OSM. Setting up a database from scratch was still a manual and difficult process for both OSM and WOF. When we moved to the global build, we automated the OSM part of that, but left the WOF setup for later.

In the meantime, it looks like the WOF data has become much easier to consume, so we might want to look at automating the import of the latest data.

[nvkelso]

Yes, let's tackle automating WOF import as part of the build.

[nvkelso]

See also: tilezen/tilezen-tasks#4 and #1358

[nvkelso]

WOF = Who's On First for future SEO

[nvkelso]

Working.