stepps00
commented
5 years ago Per @missinglink, here are "latest" public dist counts for each repo, plus expected dist counts:
admin-rs
Counts on current "latest" dist file
sqlite> SELECT placetype, COUNT(*) as cnt FROM spr WHERE country='RS' GROUP BY placetype ORDER BY placetype;| placetype | cnt |
|---|---|
| borough | 13 |
| campus | 1 |
| county | 17 |
| localadmin | 61 |
| locality | 8182 |
| neighbourhood | 218 |
| region | 31 |
Expected
sqlite> SELECT placetype, COUNT(*) as cnt FROM spr WHERE country='RS' GROUP BY placetype ORDER BY placetype;| placetype | cnt |
|---|---|
| borough | 15 |
| campus | 1 |
| country | 1 |
| county | 172 |
| localadmin | 165 |
| locality | 9458 |
| macroregion | 2 |
| neighbourhood | 362 |
| region | 51 |
admin-us
Counts on current "latest" dist file
sqlite> SELECT placetype, COUNT(*) as cnt FROM spr WHERE country='US' GROUP BY placetype ORDER BY placetype;| placetype | cnt |
|---|---|
| county | 605 |
| locality | 2014 |
| neighbourhood | 1071 |
Expected
sqlite> SELECT placetype, COUNT(*) as cnt FROM spr WHERE country='US' GROUP BY placetype ORDER BY placetype;| placetype | cnt |
|---|---|
| borough | 9 |
| campus | 8110 |
| country | 1 |
| county | 3147 |
| dependency | 7 |
| localadmin | 43200 |
| locality | 161500 |
| macrohood | 115 |
| marketarea | 210 |
| microhood | 819 |
| neighbourhood | 56941 |
| region | 51 |
https://dist.whosonfirst.org/sqlite/
whosonfirst-data-admin-us-latest.db.bz2
whosonfirst-data-admin-rs-latest.db.bz2
Both the US and RS per-country repos have been updated over the last month, but it looks like these repos' SQLite distribution files have not been updated since the 23rd of August.
Perhaps a data issue or size of commit(s) is causing this?