This repository was archived by the owner on May 7, 2025. It is now read-only.
This repository was archived by the owner on May 7, 2025. It is now read-only.
duplicate adm2's #1
Metadata
Metadata
Assignees
Labels
No labels
Type
Fields
Give feedbackNo fields configured for issues without a type.
list of duplicate adm2's:
select title, adm2_code, count(adm2_code)
from site
group by adm2_code, title, adm0_code
having count(adm2_code) > 1
order by count(adm2_code) desc