analyze historic addition/removal rates of boxes

[mikelmaron]

live data is from sept 2019. @nstory also scraped new data https://github.com/nstory/collection_boxes#2019-to-2020-added-and-removed @iandees as well at https://github.com/iandees/usps-collection-boxes/.

@nstory compared 2019 and 2020/08/15

$ # mailboxes removed (id only appears in old report)
$ comm -23 <( xsv select OUTLETID coll_report.csv | sed -e 1d | sed -e 's/^[0 ]//' | sort -u ) <( xsv select OUTLETID collection_boxes_2020-08-15.csv | sed -e 1d | sed -e 's/^[0 ]//' | sort -u ) | wc -l
4221
$ # mailboxes added (id only appears in new report)
$ comm -13 <( xsv select OUTLETID coll_report.csv | sed -e 1d | sed -e 's/^[0 ]//' | sort -u ) <( xsv select OUTLETID collection_boxes_2020-08-15.csv | sed -e 1d | sed -e 's/^[0 ]//' | sort -u ) | wc -l
967

However, the removed spreadsheet has 642 entries for DC -- almost every on street blue box, which is not accurate at all. So there may be an issue with DC data from the USPS site where data was scraped.

This doesn't appear to be new https://www.uspsoig.gov/blog/disappearing-collection-boxes

[mikelmaron]

Even more questions https://twitter.com/mikel/status/1295727907038470144

[mikelmaron]

May 15, 2020 Equipment reduction plan https://www.documentcloud.org/documents/7035434-USPS-Equipment-Reduction-Plan.html#document/p2 from https://www.vice.com/en_us/article/pkyv4k/internal-usps-documents-outline-plans-to-hobble-mail-sorting