Classification of the district into containment zones

[Thejesh GN]

Team,

We have every district mapped to one containment zone -Red, Orange or Green. This will be used from May 3rd for governance.

https://github.com/datameet/covid19/blob/master/misc-docs-backup/2020-04-30-district-containment-zones.pdf

PDF is quite clean and can be converted easily into the sheet. Can someone work on converting it and send me a PR or xls?

We need to validate the district names so they match the official name. That way it can be mapped easily. Guneet has standardized district names here. https://fieldmaps.in/covid19/district-names.html we can use that.

So basically we will have three columns in the final sheet

- standardized state name

- standardized district name

- zone

BTW, Number of districts per zone
Red Zone 130
Orange Zone 284
Green Zone- 319

Regards

Thej
--
Thejesh GN ⏚ ತೇಜೇಶ್ ಜಿ.ಎನ್
http://thejeshgn.com
GPG ID :  0xBFFC8DD3C06DD6B0

[Sajjad Anwar]

PR for CSV https://github.com/datameet/covid19/pull/11

Haven't looked at the district names matching yet. 

Sajjad

--
Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org
---
You received this message because you are subscribed to the Google Groups "datameet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datameet+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAABnYsUF1Y%3DKkL5jFmJaXPwyQQZU92P-oAkNhKCXOOOUEDe93A%40mail.gmail.com.

[Thejesh GN]

Merged, Thank you.

Thej
--
Thejesh GN ⏚ ತೇಜೇಶ್ ಜಿ.ಎನ್
http://thejeshgn.com
GPG ID :  0xBFFC8DD3C06DD6B0

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CALQA-LWgK%3D%3D_3xstqeoSoUhKQLFj%2ByM%2BHT9Rrh-JwppmuwoRUA%40mail.gmail.com.

[shane johnson]

https://github.com/datameet/covid19/blob/master/misc-docs-backup/2020-04-30-district-containment-zones.pdf 

Link isn't working. Can you guys send me just a KML for the NCR?

[Thejesh GN]

We have not created kml. Pdf is at

https://github.com/datameet/covid19/tree/master/downloads/misc-docs-backup

Regards,
Thej

Thejesh GN ⏚ ತೇಜೇಶ್ ಜಿ.ಎನ್
http://thejeshgn.com

--

Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org
---
You received this message because you are subscribed to the Google Groups "datameet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datameet+u...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/76a8094d-4bf7-4c47-b2b7-7d1fd470f3d8%40googlegroups.com.

[Suhair Killiyath]

Hi,

How can I download CSV from this link https://github.com/datameet/covid19/blob/master/data/district-containment-zones-2020-04-30.csv 

Also, can we assign census codes for districts so that the data can be easily migrated to other datasets?

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAABnYsXgxzV4TDAhjxtD9j6L%2B-9MaCfqM5fNi0sBYcVQGAX33A%40mail.gmail.com.

--

Best,

KK

[Hemant Desai]

"raw" button just above the data.

rgds.

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAENQEXGb_%3DuvBwJNJhS_NmKRMmM3aUS30hsgmJYmhV8rvUhGyw%40mail.gmail.com.

[Sridhar]

Is this list released on a day-to-day basis or any other periodic (once in a week etc.) basis?

[Suhair Killiyath]

Thanks Hemant!

Can we club these districts with shrug or census codes? 

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CALg8DoDEekDV7Mdhhh45J1YkyegGps6j_BnBdxGpDqhj5SxDxg%40mail.gmail.com.

[Arun Ganesh]

On Wed, May 6, 2020 at 8:49 AM Suhair Killiyath <suhairk...@gmail.com> wrote:

Thanks Hemant!

Can we club these districts with shrug or census codes? 

The official coding scheme in use now by the government is the LGD codes https://lgdirectory.gov.in

If anyone would like to join them, the dump is here:  https://github.com/planemad/india-local-government-directory/blob/master/administrative/2-district.csv

[Sridhar]

There is no mention of lgd codes in the pdf report https://github.com/datameet/covid19/blob/master/downloads/misc-docs-backup/2020-04-30-district-containment-zones.pdf .
Sr. No is not matching to the lgd codes. For Adilabad, Sr. No is 592, lgd code for Adilabad is 501.

[Arun Ganesh]

On Wed, May 6, 2020 at 1:50 PM Sridhar <sri....@gmail.com> wrote:

There is no mention of lgd codes in the pdf report https://github.com/datameet/covid19/blob/master/downloads/misc-docs-backup/2020-04-30-district-containment-zones.pdf .
Sr. No is not matching to the lgd codes. For Adilabad, Sr. No is 592, lgd code for Adilabad is 501.

Unfortunately looks like the sr. no in the pdf is quite arbitrary and doesnt line up with any codes

[Arun Ganesh]

Here's the mapping of the containment CSV data to the LGD and census codes: https://observablehq.com/d/8a3cacb7ce2cfd8f

You can download the CSV from the bottom right of the table.

[Suhair Killiyath]

Hello Arun

This is great! thanks!!

On Thu, May 7, 2020 at 12:56 AM Arun Ganesh <arung...@gmail.com> wrote:

Here's the mapping of the containment CSV data to the LGD and census codes: https://observablehq.com/d/8a3cacb7ce2cfd8f

You can download the CSV from the bottom right of the table.

--

Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org
---
You received this message because you are subscribed to the Google Groups "datameet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datameet+u...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CA%2BGKQr3jwDmCeqvqA3LxuR3jkf-j-MtexyOSUhmhkiwoXhZAdQ%40mail.gmail.com.

--

Best,

KK

[Sridhar]

There is one discrepancy. Jhabua is mapped to Indore and Indore is mapped to Jhabua.

[Arun Ganesh]

On Fri, May 8, 2020 at 10:27 AM Sridhar <sri....@gmail.com> wrote:

There is one discrepancy. Jhabua is mapped to Indore and Indore is mapped to Jhabua.

Well spotted, made a mistake in manually matching them. Fixed now.