search

MycroftAI / selene-backend

Microservices and web apps to support Mycroft devices
GNU Affero General Public License v3.0
144 stars 53 forks source link

Remove duplicate cities from database #252

Closed chrisveilleux closed 3 years ago

chrisveilleux commented 3 years ago

Description

Script and SQL to delete duplicate city records from the geography.city table

How to test

Bootstrap a database and run the script against it.

Contributor license agreement signed?

CLA [Y]

chrisveilleux commented 3 years ago

You are right. I only delete a duplicate if it has the same country and region.