search

Open-Historical-Map-Labs / openhistoricaltiles

First iteration of vector tiles from OHM Planet data
BSD 2-Clause "Simplified" License
3 stars 0 forks source link

Building footprints lack name/date info #27

Closed gregallensworth closed 5 years ago

gregallensworth commented 6 years ago

Building footprints do not have a start/end date listed, nor do the osm_building_polygon and osm_building_multipolygon tables even have a name field. We would like for building footprints to have all three: a name, and start + end dates.

May need to backtrack and check out OMT's techniques for loading buildings... or even purge-and-reload if we need to go back to an initial import.

gregallensworth commented 6 years ago

Dates

I have reworked the SQL queries to create the tables and views, and building footprints now have start_date and end_date These views of Seattle show marked improvement:

https://openhistoricalmap.github.io/openhistoricaltiles/dateissues/#16.00/47.60207/-122.33303/

https://openhistoricalmap.github.io/openhistoricaltiles/datefilter/#16.00/47.60207/-122.33303/1500-01-01,2010-12-31/

Name

I confirmed that the buildings/mapping.yaml does not include a name attribute. This could be added, but would mean purge-and-reload of the OHM dataset. Need some info as to a new PBF (see also #26) and go-ahead.

gregallensworth commented 5 years ago

Here we go:

image