2025-03-02     2025-03-03     2025-03-04

BD all ADM3 from geoname also for provider bbs_gov_bd

number of errors=2
number of warnings=0
country=BD

select geonameid,name,ansiname,featurecode,countrycode,admincode1,admincode2,admincode3,admincode4,admincode5 from geoname where countrycode='BD' and featurecode='ADM3' and not exists (select 1 from countrysubdiv_code where validtill is null and countrysubdiv_code.countrycode='BD' and countrysubdiv_code.featurecode='ADM3' and geoname.admincode1=countrysubdiv_code.admincode1 and geoname.admincode2=countrysubdiv_code.admincode2 and geoname.admincode3=countrysubdiv_code.admincode3) order by admincode1,admincode2,admincode3,admincode4,admincode5

491 from bbs_gov_bd

geonameid	name	ansiname	featurecode	countrycode	admincode1	admincode2	admincode3	admincode4	admincode5	
9252711	DNCC (Dhaka)	DNCC (Dhaka)	ADM3	BD	81	3026	9252711	null	null	
9257621	DSCC (Dhaka)	DSCC (Dhaka)	ADM3	BD	81	3026	9257621	null	null