Changes

VC Database Rebuild (view source)

424 bytes added , 11:49, 24 July 2017

SELECT COUNT(*) FROM geo;

--43724

SELECT *, COUNT(*)

FROM (SELECT city, coname, startyear FROM geo)a

GROUP BY city, coname, startyear

HAVING COUNT(*) > 1;

If you look at the rows with duplicate keys you can see they are simply complete duplicates so let's create a table with just distinct rows.

DROP TABLE geo1;

CREATE TABLE geo1 AS

SELECT DISTINCT *

FROM geo;

--43662

We still have 11 keys that are not distinct. We'll need to clean those up.

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

220

edits