Changes

VC Database Rebuild (view source)

243 bytes added , 10:40, 24 July 2017

==Cleaning geo table==

The geo table contains duplicate keys. Look at the different counts for select all keys and distinct keys from the table:

SELECT COUNT(*) FROM (SELECT DISTINCT city, coname, startyear FROM geo)a;

--43651

SELECT COUNT(*) FROM geo;

--43724

==Name Based Matching geo keys to companybase keys==

220

edits