Sub localities within cities are added as cities

[HashirLabs]

First of all, highly appreciate the efforts to build this data set.

There are too many occurrences of sub localities (which are areas within City) of cities/districts/metropolitan regions presented as City in Cities database, which is like cities within city

Here is an excerpt (some entries ) that are sub localities of Mumbai city, however represented as city within Maharashtra State.
Also noticed duplications in data. According to me, either we add these entries in a separate file named sub-localities having foreign key relationship with city as these are city sub localities, OR just remove them from Cities.

Mumbai City

(133024,'Mumbai',4008,'MH',101,'IN',19.07283000,72.88261000,'2019-10-06 01:08:47','2019-10-06 01:08:47',1,'Q1156'),

Mumbai city sub localities marked as cities

(57978,'Bhayandar',4008,'MH',101,'IN',19.30157000,72.85107000,'2019-10-06 00:23:45','2019-10-06 00:23:45',1,'Q4901615'),
(58082,'Borivli',4008,'MH',101,'IN',19.23496000,72.85976000,'2019-10-06 00:33:48','2019-10-06 00:33:48',1,'Q4945504'),

(133025,'Mumbai Suburban',4008,'MH',101,'IN',19.12636000,72.84897000,'2019-10-06 01:08:47','2019-10-06 01:08:47',1,'Q2341660'),
(133484,'Powai',4008,'MH',101,'IN',19.11640000,72.90471000,'2019-10-06 01:08:53','2019-10-06 01:08:53',1,'Q13118508'),
(147680,'Andheri',4008,'MH',101,'IN',19.11916667,72.84694444,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q12413015'),
(147694,'Ballard Estate',4008,'MH',101,'IN',18.95000000,72.84000000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q4851507'),
(147697,'Bandra',4008,'MH',101,'IN',19.05444444,72.84055556,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q257622'),
(147715,'Borivali',4008,'MH',101,'IN',19.23000000,72.86000000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q4945504'),
(147717,'Breach Candy',4008,'MH',101,'IN',18.96700000,72.80500000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q4959100'),
(147719,'Byculla',4008,'MH',101,'IN',18.98000000,72.83500000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q5003979'),
(147723,'Chembur',4008,'MH',101,'IN',19.05871111,72.89969444,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q251170'),
(147727,'Chinchpokli',4008,'MH',101,'IN',18.98333333,72.83333333,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q5100316'),
(147728,'Colaba',4008,'MH',101,'IN',18.91000000,72.81000000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q3632559'),
(147737,'Dharavi',4008,'MH',101,'IN',19.05000000,72.86667000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q649632'),
(147742,'Dongri',4008,'MH',101,'IN',19.28333333,72.78333333,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q5296011'),
(147744,'Fort',4008,'MH',101,'IN',18.93500000,72.83590000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q5470698'),
(147747,'Ghatkopar',4008,'MH',101,'IN',19.08000000,72.91000000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q3309774'),
(147748,'Girgaon',4008,'MH',101,'IN',18.95300000,72.81300000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q1931371'),
(147750,'Gorai',4008,'MH',101,'IN',19.25005700,72.78202100,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q4932603'),
(147767,'Jogeshwari',4008,'MH',101,'IN',19.12000000,72.85000000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q5456464'),
(147768,'Juhu',4008,'MH',101,'IN',19.10000000,72.83000000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q674362'),
(147806,'Mahim',4008,'MH',101,'IN',19.03500000,72.84000000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q674501'),
(147807,'Malabar Hill',4008,'MH',101,'IN',18.95000000,72.79500000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q6373912'),
(147808,'Malad',4008,'MH',101,'IN',19.18611111,72.84861111,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q6740929'),
(147815,'Mankhurd',4008,'MH',101,'IN',19.05000000,72.93000000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q4856120'),
(147820,'Matunga',4008,'MH',101,'IN',19.01798056,72.84476389,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q5226775'),
(147821,'Mazagaon',4008,'MH',101,'IN',18.97000000,72.85000000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q5121900'),
(147830,'Mulund',4008,'MH',101,'IN',19.17168056,72.95600000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q6935217'),
(147835,'Nala Sopara',4008,'MH',101,'IN',19.41540000,72.86130000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q12435629'),
(147842,'Nariman Point',4008,'MH',101,'IN',18.92000000,72.83000000,'2021-06-06 14:47:48','2021-06-06 14:47:48',1,'Q3632268'),
(147855,'Parel',4008,'MH',101,'IN',18.99000000,72.84000000,'2021-06-06 14:47:49','2021-06-06 14:47:49',1,'Q4856263'),
(147868,'Prabhadevi',4008,'MH',101,'IN',19.01690500,72.82864900,'2021-06-06 14:47:49','2021-06-06 14:47:49',1,'Q5456385'),
(147895,'Sewri',4008,'MH',101,'IN',19.00000000,72.86000000,'2021-06-06 14:47:49','2021-06-06 14:47:49',1,'Q4933909'),
(147904,'Sion Mumbai',4008,'MH',101,'IN',19.04000000,72.86000000,'2021-06-06 14:47:49','2022-08-29 12:30:58',1,'Q7525343'),
(147914,'Tardeo',4008,'MH',101,'IN',18.97000000,72.81000000,'2021-06-06 14:47:49','2021-06-06 14:47:49',1,'Q7685715'),
(147916,'Trombay',4008,'MH',101,'IN',19.00000000,72.90000000,'2021-06-06 14:47:49','2021-06-06 14:47:49',1,'Q3595610'),
(147928,'Vikhroli',4008,'MH',101,'IN',19.11000000,72.94000000,'2021-06-06 14:47:49','2021-06-06 14:47:49',1,'Q5383080'),
(147929,'Vile Parle',4008,'MH',101,'IN',19.10000000,72.83000000,'2021-06-06 14:47:49','2021-06-06 14:47:49',1,'Q3558400'),
(147932,'Wadala',4008,'MH',101,'IN',19.02163056,72.86458889,'2021-06-06 14:47:49','2021-06-06 14:47:49',1,'Q4856518'),
(147939,'Worli',4008,'MH',101,'IN',19.00000000,72.81500000,'2021-06-06 14:47:49','2021-06-06 14:47:49',1,'Q1934607'),

Please revert if we can fix this data and how.

Thanks

[dr5hn]

@HashirLabs Thanks 🙏

Yes, I am aware of this issue.

We can introduce one more table for sub-localities. It would be great if you can contribute to segregating the sub-localities. I know it would be difficult to find other sub-localities apart from Mumbai. Please let me know if you can do so.

Otherwise, you can simply refer to https://github.com/dr5hn/countries-states-cities-database/blob/master/.github/CONTRIBUTING.md and if you can try to remove the duplicate cities/localities that will be appreciated.