Hi,
This is regarding Shivangi's question titled "State-->District-->Village
level data".
*DTName* column is same as district column "*DID,C,254*" in the census data.
*SDTName* column is same as taluka column "*TID,C,254*" in the census data.
State code is the same in both. (for e.g. 27 for Maharashtra)
Districts are numbered from 1 to 35 exactly as they appear in the census
file and those numbers are used in the shape file.
Talukas are also numbered from 1 to x (x being the number of talukas in
each district). The sequence is same in both the files.
Here is the python code for district and taluka:
census = pd.read_csv("census.CSV")
census = census.apply(lambda s: s.str.replace("'", ""))
census = census[census["DTName"] != "MAHARASHTRA"]
ndf = census[census["SDTCode"] == "00000"]
ndf["mapindex"] = np.arange(1, len(ndf) + 1)
ndf[["DTCode", "Name", "mapindex"]]
taluka = census[census["TVCode"] == "000000"]
taluka = taluka[taluka["SDTCode"] != "00000"]
taluka["sno"] = (taluka.groupby(["DTName"]).cumcount()+ 1)
The full code is available here...
https://github.com/shantanuo/stack_question/blob/master/state_district_village_data.ipynb
I have tested with Maharashtra data but the same logic can be applied to
other states.
-- Shantanu
On Thursday, 26 August 2021 at 03:36:27 UTC Shivangi wrote:
> Thanks Naraina, I will look into it.
>
> Regards,
> Shivangi
>
> On Wed, Aug 25, 2021 at 12:00 PM Naraina Damle <cadv...@gmail.com> wrote:
>
>> Found it.
>>
>> Download local government Directory from this site.
>>
>> https://lgdirectory.gov.in/
>>
>> This is one of the best and easiest dat ato download. Its
>> LOCALBODYMAPPING file has both 2001 and 2011 numbers with their own new
>> numbers for villages added after 2011
>>
>>
>>
>>
>> On Wednesday, August 25, 2021 at 11:55:17 AM UTC+5:30 Naraina Damle wrote:
>>
>>> There is a difference in the Village numbering in 2001 and 2011. Let me
>>> check what is the solution.
>>>
>>> On Tuesday, July 27, 2021 at 11:12:51 AM UTC+5:30 Shivangi wrote:
>>>
>>>> Thanks Sayeed.
>>>>
>>>> But somehow i cannot find the linkage between the district and village
>>>> codes given in the shape files at
>>>> https://sedac.ciesin.columbia.edu/data/set/india-india-village-level-geospatial-socio-econ-1991-2001/
>>>> and the census data from
>>>> https://www.censusindia.gov.in/2011census/Listofvillagesandtowns.aspx
>>>>
>>>> The district code and village codes dont match. In the spatial data all
>>>> district and village codes for states restart from 0 while in the census
>>>> data they have code which is unique across the country.
>>>>
>>>> Has anyone else faced this issue?
>>>>
>>>> Thanks & Regards
>>>> Shivangi
>>>>
>>>> On Mon, Jul 26, 2021 at 12:33 PM Mohd. Sayeed Ul Hasan <
>>>> saye...@gmail.com> wrote:
>>>>
>>>>> U can get data from NASA sedac village boundary shapefile.
>>>>>
>>>>> On Mon, Jul 26, 2021, 12:00 Shivangi Desai <shivang...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Hey All,
>>>>>>
>>>>>> I am trying to get village information for all states in India.
>>>>>> I found the district, subdistrict and village data from the 2001
>>>>>> census. But could not find coordinates of the same.
>>>>>>
>>>>>> Can you please point me to any API or website that I can use to get
>>>>>> this information?
>>>>>> For villages the coordinates would be enough.
>>>>>> Also wanted to figure if there is any specific code that is
>>>>>> maintained per village?
>>>>>>
>>>>>> Thanks
>>>>>> Shivangi
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> 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/CAB%3DRKFsAYSd3ko8gmGO0OZRRHnUhTZy_G7F7fo6aT0iaCesxhg%40mail.gmail.com
>>>>>>
>>>>>> <https://groups.google.com/d/msgid/datameet/CAB%3DRKFsAYSd3ko8gmGO0OZRRHnUhTZy_G7F7fo6aT0iaCesxhg%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>>> .
>>>>>>
>>>>> --
>>>>> 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/CAMc3Z%3D_AWdW72k2o_znvAGqF8R_M6-PVJDgVd_3e-_gKS236oA%40mail.gmail.com
>>>>>
>>>>> <https://groups.google.com/d/msgid/datameet/CAMc3Z%3D_AWdW72k2o_znvAGqF8R_M6-PVJDgVd_3e-_gKS236oA%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>> .
>>>>>
>>>> --
>> 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/d54d9d9b-b6fe-4111-8427-9a1d9371d521n%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/datameet/d54d9d9b-b6fe-4111-8427-9a1d9371d521n%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/datameet/16cac82c-b9e1-42da-b9a1-75c15877e67cn%40googlegroups.com.
