search

guneetnarula / covid19-in

District-wise map of CoVID19 cases in India
https://covid19-in.guneetnarula.now.sh
9 stars 7 forks source link

New districts formed in 2019 #6

Open aadityadar opened 4 years ago

aadityadar commented 4 years ago

Duplicate of https://github.com/covid19india/CovidCrowd/issues/7

No of districts in js/districts_729.js is: 

-------------------------------
 properties/stname |      Freq.
-------------------+-----------
 andaman & nicobar |          3
    andhra pradesh |         13
 arunachal pradesh |         25
             assam |         34
             bihar |         38
        chandigarh |          1
      chhattisgarh |         27
dadra & nagar have |          1
       daman & diu |          2
             delhi |         11
               goa |          2
           gujarat |         34
           haryana |         22
  himachal pradesh |         12
   jammu & kashmir |         22
         jharkhand |         24
         karnataka |         30
            kerala |         14
            ladakh |          2
       lakshadweep |          1
    madhya pradesh |         52
       maharashtra |         36
           manipur |         16
         meghalaya |         11
           mizoram |          8
          nagaland |         11
            odisha |         30
        puducherry |          4
            punjab |         22
         rajasthan |         33
            sikkim |          4
        tamil nadu |         32
         telangana |         33
           tripura |          8
     uttar pradesh |         75
       uttarakhand |         13
       west bengal |         23
-------------------------------
aadityadar commented 4 years ago

so i took your list of 727 districts (after removing the 2 duplicates) and mapped them onto some key variables that i think should be helpful to keep like a two letter standardized state code, updated state numeric code (this resolves #7), district names that match those in local government directory/lgd, and three numeric district codes (one for 2020, 2011 and 2001 respectively; these also come from lgd). please use this file.

district_names_clean_with_lgdcodes.xlsx

guneetnarula commented 4 years ago

Thanks! This is great. I wasn't aware of the four new districts, let's try and look for officially notified administrative boundaries and see if we can map them manually. At this point though these haven't found their way into official directories or listings. The LG directory, NIC districts portal and the state websites do not include them consistently.

My suggestion is that we continue with 727 for now though. And consider the 4 new districts as part of their previous delimitations (to report cases)

Saitual -> Aizawl Hnahthial -> Lunglei Khawzawl -> Champhai Kallakurichi -> Villuppuram

What do you think?

aadityadar commented 4 years ago

Yeah I guess that's one way to go about it. Btw there are few more new districts in Tamil Nadu that got formed towards the end of 2019. One got even formed in 2020 taking the total to 38. LGD reports 34 but by the end of 2019 there were 37. I checked the state media bulletins for TN and they are also reporting data for the 37 districts. I think we should just have a cutoff date, 31 Dec 2019 and use boundaries on that date. (Census of India is also using the same cutoff for the 2021 census). I can share the new districts for TN in sometime, but if you need them sooner they aren't hard to find. Wikipedia has a good list and tnrd.gov.in has notifications on the bifurcations

guneetnarula commented 4 years ago

Yeah they are reporting for 37. But do we have any source for the boundaries? Chengalpattu was part of Kancheepuram and carved out in July 2019 it appears, but official district boundaries are not available anywhere yet. I did see this on wikimedia https://upload.wikimedia.org/wikipedia/commons/4/46/Chengalpattu_district_location_map.svg

aadityadar commented 4 years ago

yep, best bet seems to use wiki for now. i've opened an issue on justin's repo, see this https://github.com/justinelliotmeyers/India_Official_Boundaries_2019/issues/4

justinelliotmeyers commented 4 years ago

@guneetnarula and @aadityadar I want to make sure any updates or help i can provide go to you and the people of India. I dont mind closing shop on my repo to help update here.let me know your thoughts as I want the data and assistance to go to your efforts. Justin

aadityadar commented 4 years ago

my two cents: it will be good to keep the repo on 2019 district boundaries separate (so that it can be used beyond just covid) + you should get credit for all that work that you are doing. it's not easy to georeference and verify boundaries!

guneetnarula commented 4 years ago

@justinelliotmeyers we can put this up on datameet's git, and credit you?

justinelliotmeyers commented 4 years ago

@guneetnarula absolutely. I also told @thejeshgn they can do whatever they need. I am traveling now and will be home on Friday. Talk soon, thanks!