#Import Libraries
import numpy as np
import pandas as pd
import geopandas as gpd
from shapely.geometry import Point, Polygon
import json
import requests
import math
import os
import time
import datetime
import itertools

# Import folders
data_folder = os.path.abspath('data')
# Set Output Folder
output_folder = os.path.abspath("output")
if not os.path.exists(output_folder):
    os.makedirs(output_folder)

# Helping Functions
def remove_consecutive_duplicates(x):
    if x is not None:
        x = str(x)
        return ''.join(i for i, _ in itertools.groupby(x))
    else:
        return None

# Read Constituency Data
ac_gdf = None
ac_filepath = os.path.join(data_folder, "AC", "India_AC.shp")
ac_gdf = gpd.read_file(ac_filepath)
ac_gdf

# Read Constituency Data
ac_file = os.path.join(data_folder, "General_Later_Ashoka_alldata.csv")
acdf = pd.read_csv(ac_file)
acdf['state_name'] = acdf['state_name'].str.replace("_", " ")
#acdf = acdf[['state_name', 'constituency_no', 'constituency_name', 'year', 'month']]
acdf = acdf.drop_duplicates(subset=None, keep="first", inplace=False).reset_index(drop=True)
acdf.loc[acdf['newstate_code'] == 36, 'newstate_code'] = 28 #Telangana  Fix
acdf = acdf[['state_name', 'state_code', 'constituency_no', 'year', 'month']]
acdf['day'] = 1
acdf['dyear'] = 0
acdf.loc[(acdf['month'] > 9) | (acdf['year'] == 2008), 'dyear'] = 1
acdf['dyear'] = acdf['year'] + acdf['dyear']
acdf['datetime'] = pd.to_datetime(acdf[['year', 'month', 'day']])
acdf = acdf.drop_duplicates().reset_index(drop=True)
acdf = pd.merge(acdf, ac_gdf,  how='inner', left_on=['state_code', 'constituency_no'], right_on = ['ST_CODE','AC_NO'])#[['ST_CODE', 'ST_NAME','DT_CODE', 'DIST_NAME', 'AC_NO', 'AC_NAME', 'PC_NO', 'PC_NAME']]
acdf = acdf[acdf.columns[:-5]]
acdf

# Read Village shapefile
vil_gdf = None
vil_filepath = os.path.join(data_folder, "Census Villages.shp")
vil_gdf = gpd.read_file(vil_filepath)
vil_gdf['longitude'] = vil_gdf.geometry.x
vil_gdf['latitude'] = vil_gdf.geometry.y
vil_gdf['dtname_y'] = vil_gdf['dtname'].str.upper().str.replace('([^A-Za-z]+)', '').apply(remove_consecutive_duplicates)
vil_gdf['sdtname_y'] = vil_gdf['sdtname'].str.upper().str.replace('([^A-Za-z]+)', '').apply(remove_consecutive_duplicates)
vil_gdf['vilname_y'] = vil_gdf['vilname'].str.upper().str.replace('([^A-Za-z]+)', '').apply(remove_consecutive_duplicates)
vil_gdf

# Read all records
scrapped_folder = os.path.join(data_folder, 'scrapped')
scrapped_files = os.listdir(scrapped_folder)
scrapped_files = [file for file in scrapped_files if file.split('.')[-1] == 'csv']
df_list = []
for file in scrapped_files:
    filepath = os.path.join(scrapped_folder, file)
    df = pd.read_csv(filepath)
    df_list.append(df)
# Merge all files
df = pd.concat(df_list)
scrapped_df = df.reset_index().drop(columns = 'index')
df = None
scrapped_df['district_y'] = scrapped_df['District'].str.upper().str.replace('([^A-Za-z]+)', '').apply(remove_consecutive_duplicates)
scrapped_df['block_y'] = scrapped_df['Block'].str.upper().str.replace('([^A-Za-z]+)', '').apply(remove_consecutive_duplicates)
scrapped_df['habitation_y'] = scrapped_df['Habitation Name'].str.upper().str.replace('([^A-Za-z]+)', '').apply(remove_consecutive_duplicates)
scrapped_df

C:\Users\sandyjones\AppData\Local\conda\conda\envs\geo\lib\site-packages\IPython\core\interactiveshell.py:2785: DtypeWarning: Columns (8,12,13) have mixed types. Specify dtype option on import or set low_memory=False.
  interactivity=interactivity, compiler=compiler, result=result)

# Filter NON Matching habitations
merged_df = pd.merge(scrapped_df, vil_gdf, how='left', left_on=['habitation_y', 'block_y', 'district_y'], right_on=['vilname_y', 'sdtname_y', 'dtname_y'])
#togeocode_df = merged_df[merged_df['latitude'].isnull()][['Habitation Name', 'Block', 'District']].drop_duplicates(subset=None, keep='first', inplace=False)
#togeocode_df.to_csv(os.path.join(output_folder, "Non-Geocoded_df.csv"), encoding='utf-8', index=False)
nongeocoded_df = merged_df[merged_df['latitude'].isnull()]
nongeocoded_df

# Filter Matching habitations
geocoded_df = merged_df[merged_df['latitude'].notnull()]
geocoded_df = geocoded_df[list(geocoded_df.columns[:-24]) + list(geocoded_df.columns[-5:-3])]
geocoded_df

# Read Geocoded Habitations
google_geocoded_folder = os.path.join('google geocoding', 'output')
google_geocoded_files = os.listdir(google_geocoded_folder)
df_list = []
for file in google_geocoded_files:
    filepath = os.path.join(google_geocoded_folder, file)
    df = pd.read_csv(filepath, encoding ='latin1')
    df_list.append(df)
# Merge
google_geocoded_df = pd.concat(df_list)
google_geocoded_df = google_geocoded_df[list(google_geocoded_df.columns[1:4]) + list(google_geocoded_df.columns[9:11])]
google_geocoded_df.columns = list(google_geocoded_df.columns[0:3]) + ['latitude', 'longitude']
google_geocoded_df

# Geocode Non Matching Habitations
nongeocoded_df = nongeocoded_df[nongeocoded_df.columns[:27]]
nongeocoded_df = pd.merge(nongeocoded_df, google_geocoded_df, how='inner', on=['Habitation Name', 'Block', 'District'])
nongeocoded_df

# Merge df to one
df = pd.concat([geocoded_df, nongeocoded_df]).reset_index()
#Change dataframe to geospatial
geometry = [Point(xy) for xy in zip(df.longitude, df.latitude)]
crs = {'init': 'epsg:4326'}
geo_df = gpd.GeoDataFrame(df, crs=crs, geometry=geometry)
geo_df

C:\Users\sandyjones\AppData\Local\conda\conda\envs\geo\lib\site-packages\ipykernel_launcher.py:2: FutureWarning: Sorting because non-concatenation axis is not aligned. A future version
of pandas will change to not sort by default.

To accept the future behavior, pass 'sort=False'.

To retain the current behavior and silence the warning, pass 'sort=True'.

# Spatial Join
joined_df = gpd.sjoin(geo_df, ac_gdf, how='inner', op='within')
joined_df = joined_df[joined_df.columns[:-3]]
joined_df

# Output to CSV
joined_df.to_csv(os.path.join(output_folder, "Geocoded_Scrapped_Data_with_AC_Data.csv"), encoding='utf-8', index=False)
# Output to SHP
out_file = os.path.join(output_folder, "Geocoded_Scrapped_Data_with_AC_Data.shp")
joined_df.to_file(driver='ESRI Shapefile', filename=out_file)

	state_name	state_code	constituency_no	year	month	day	dyear	datetime	OBJECTID	ST_CODE	ST_NAME	DT_CODE	DIST_NAME	AC_NO	AC_NAME	PC_NO	PC_NAME
0	Jammu & Kashmir	1	1	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1	KUPWARA	1	KARNAH	1	BARAMULLA
1	Jammu & Kashmir	1	1	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1	KUPWARA	1	KARNAH	1	BARAMULLA
2	Jammu & Kashmir	1	2	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1	KUPWARA	2	KUPWARA	1	BARAMULLA
3	Jammu & Kashmir	1	2	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1	KUPWARA	2	KUPWARA	1	BARAMULLA
4	Jammu & Kashmir	1	3	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1	KUPWARA	3	LOLAB	1	BARAMULLA
5	Jammu & Kashmir	1	3	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1	KUPWARA	3	LOLAB	1	BARAMULLA
6	Jammu & Kashmir	1	4	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1	KUPWARA	4	HANDWARA	1	BARAMULLA
7	Jammu & Kashmir	1	4	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1	KUPWARA	4	HANDWARA	1	BARAMULLA
8	Jammu & Kashmir	1	5	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	1	KUPWARA	5	LANGATE	1	BARAMULLA
9	Jammu & Kashmir	1	5	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	1	KUPWARA	5	LANGATE	1	BARAMULLA
10	Jammu & Kashmir	1	6	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	6	URI	1	BARAMULLA
11	Jammu & Kashmir	1	6	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	6	URI	1	BARAMULLA
12	Jammu & Kashmir	1	7	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	7	RAFIABAD	1	BARAMULLA
13	Jammu & Kashmir	1	7	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	7	RAFIABAD	1	BARAMULLA
14	Jammu & Kashmir	1	8	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	8	SOPORE	1	BARAMULLA
15	Jammu & Kashmir	1	8	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	8	SOPORE	1	BARAMULLA
16	Jammu & Kashmir	1	9	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	9	GUREZ	1	BARAMULLA
17	Jammu & Kashmir	1	9	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	9	GUREZ	1	BARAMULLA
18	Jammu & Kashmir	1	10	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	10	BANDIPORA	1	BARAMULLA
19	Jammu & Kashmir	1	10	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	10	BANDIPORA	1	BARAMULLA
20	Jammu & Kashmir	1	11	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	11	SONAWARI	1	BARAMULLA
21	Jammu & Kashmir	1	11	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	11	SONAWARI	1	BARAMULLA
22	Jammu & Kashmir	1	12	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	12	SANGRAMA	1	BARAMULLA
23	Jammu & Kashmir	1	12	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	12	SANGRAMA	1	BARAMULLA
24	Jammu & Kashmir	1	13	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	13	BARAMULA	1	BARAMULLA
25	Jammu & Kashmir	1	13	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	13	BARAMULA	1	BARAMULLA
26	Jammu & Kashmir	1	14	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	14	GULMARG	1	BARAMULLA
27	Jammu & Kashmir	1	14	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	14	GULMARG	1	BARAMULLA
28	Jammu & Kashmir	1	15	2008	12	1	2009	2008-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	15	PATTAN	1	BARAMULLA
29	Jammu & Kashmir	1	15	2014	12	1	2015	2014-12-01	1	1	JAMMU & KASHMIR	2	BARAMULA	15	PATTAN	1	BARAMULLA
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
8328	Puducherry	34	16	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	16	Orleampeth	1	PONDICHERRY
8329	Puducherry	34	16	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	16	Orleampeth	1	PONDICHERRY
8330	Puducherry	34	17	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	17	Nellithope	1	PONDICHERRY
8331	Puducherry	34	17	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	17	Nellithope	1	PONDICHERRY
8332	Puducherry	34	18	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	18	Mudaliarpet	1	PONDICHERRY
8333	Puducherry	34	18	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	18	Mudaliarpet	1	PONDICHERRY
8334	Puducherry	34	19	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	19	Ariankuppam	1	PONDICHERRY
8335	Puducherry	34	19	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	19	Ariankuppam	1	PONDICHERRY
8336	Puducherry	34	20	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	20	Manavely	1	PONDICHERRY
8337	Puducherry	34	20	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	20	Manavely	1	PONDICHERRY
8338	Puducherry	34	21	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	21	Embalam (SC)	1	PONDICHERRY
8339	Puducherry	34	21	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	21	Embalam (SC)	1	PONDICHERRY
8340	Puducherry	34	22	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	22	Nettapakkam (SC)	1	PONDICHERRY
8341	Puducherry	34	22	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	22	Nettapakkam (SC)	1	PONDICHERRY
8342	Puducherry	34	23	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	23	Bahour	1	PONDICHERRY
8343	Puducherry	34	23	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	2	PONDICHERRY	23	Bahour	1	PONDICHERRY
8344	Puducherry	34	24	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4	KARAIKAL	24	Nedungadu (SC)	1	PONDICHERRY
8345	Puducherry	34	24	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4	KARAIKAL	24	Nedungadu (SC)	1	PONDICHERRY
8346	Puducherry	34	25	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4	KARAIKAL	25	Thirunallar	1	PONDICHERRY
8347	Puducherry	34	25	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4	KARAIKAL	25	Thirunallar	1	PONDICHERRY
8348	Puducherry	34	26	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4	KARAIKAL	26	Karaikal North	1	PONDICHERRY
8349	Puducherry	34	26	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4	KARAIKAL	26	Karaikal North	1	PONDICHERRY
8350	Puducherry	34	27	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4	KARAIKAL	27	Karaikal South	1	PONDICHERRY
8351	Puducherry	34	27	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4	KARAIKAL	27	Karaikal South	1	PONDICHERRY
8352	Puducherry	34	28	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	4	KARAIKAL	28	Neravy- T.R. Pattin	1	PONDICHERRY
8353	Puducherry	34	28	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	4	KARAIKAL	28	Neravy- T.R. Pattin	1	PONDICHERRY
8354	Puducherry	34	29	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	3	MAHE	29	Mahe	1	PONDICHERRY
8355	Puducherry	34	29	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	3	MAHE	29	Mahe	1	PONDICHERRY
8356	Puducherry	34	30	2011	5	1	2011	2011-05-01	1	34	PUDUCHERRY	1	YANAM	30	Yanam	1	PONDICHERRY
8357	Puducherry	34	30	2016	5	1	2016	2016-05-01	1	34	PUDUCHERRY	1	YANAM	30	Yanam	1	PONDICHERRY

	objectid	vilnam_soi	stcode11	dtcode11	sdtcode11	vilcode11	stname	dtname	sdtname	vilname	...	STVIL	LOC_STAT_1	layer	path	geometry	longitude	latitude	dtname_y	sdtname_y	vilname_y
0	99001	Shibala	27	510	04093	543821	MAHARASHTRA	Yavatmal	Zari-Jamani	Shibala	...	27543821	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (78.68135137148188 19.97390142196515 0)	78.681351	19.973901	YAVATMAL	ZARIJAMANI	SHIBALA
1	99002	OLHAN	21	387	03068	410097	ODISHA	Puri	Gadisagada	Olhan	...	21410097	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (85.56859137533506 19.96825170304859 0)	85.568591	19.968252	PURI	GADISAGADA	OLHAN
2	99003	Sonari	27	516	04154	551208	MAHARASHTRA	Nashik	Sinnar	Sonari	...	27551208	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (73.94799623712801 19.79323642810365 0)	73.947996	19.793236	NASHIK	SINAR	SONARI
3	99004	JHADU PUR	21	385	03031	406607	ODISHA	Nayagarh	Odagaon	Jadupur	...	21406607	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (85.01110267449967 19.98067204840583 0)	85.011103	19.980672	NAYAGARH	ODAGAON	JADUPUR
4	99005	Butte Wadgaon	27	515	04140	549210	MAHARASHTRA	Aurangabad	Gangapur	Butte Wadgaon	...	27549210	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (75.00441332870804 19.84683478356678 0)	75.004413	19.846835	AURANGABAD	GANGAPUR	BUTEWADGAON
5	99006	Loni Bk.	27	502	04000	531363	MAHARASHTRA	Washim	Risod	Loni Bk.	...	27531363	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (76.62140934546377 19.9141291482056 0)	76.621409	19.914129	WASHIM	RISOD	LONIBK
6	99007	Borkhedi	27	514	04127	547533	MAHARASHTRA	Jalna	Jalna	Borkhedi	...	27547533	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (75.99483401617549 19.8901815998534 0)	75.994834	19.890182	JALNA	JALNA	BORKHEDI
7	99008	JEEPUR	21	387	03064	409621	ODISHA	Puri	Satyabadi	Jeepur	...	21409621	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (85.75190574422575 19.96400933681409 0)	85.751906	19.964009	PURI	SATYABADI	JEPUR
8	99009	Karmari	22	722	03355	448517	CHATTISGARH	Kondagaon	Keskal	Karmari	...	22448517	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (81.42902183260549 20.01018358873267 0)	81.429022	20.010184	KONDAGAON	KESKAL	KARMARI
9	99010	DANGSARGI	21	395	03162	422908	ODISHA	Kalahandi	Lanjigarh	Dengasargi	...	21422908	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (83.50303997223889 20.00372701917869 0)	83.503040	20.003727	KALAHANDI	LANJIGARH	DENGASARGI
10	99011	Jamthi bk	27	512	04111	545798	MAHARASHTRA	Hingoli	Sengaon	Jamthi bk	...	27545798	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (76.99149724567263 19.92713457053208 0)	76.991497	19.927135	HINGOLI	SENGAON	JAMTHIBK
11	99012	Marangpuri	22	722	03356	448628	CHATTISGARH	Kondagaon	Bade Rajpur	Marangpuri	...	22448628	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (81.85847072658919 20.01136719659118 0)	81.858471	20.011367	KONDAGAON	BADERAJPUR	MARANGPURI
12	99013	MANKARGUDA	22	720	03337	422248	CHATTISGARH	Gariaband	Mainpur	Mankarguda	...	22422248	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (82.55517347691011 20.01041056994538 0)	82.555173	20.010411	GARIABAND	MAINPUR	MANKARGUDA
13	99014	SANA GOBINDA PUR	21	386	03051	408021	ODISHA	Khordha	Nirakarpur	Sanagobindapur	...	21408021	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (85.56125233080496 19.96891445995952 0)	85.561252	19.968914	KHORDHA	NIRAKARPUR	SANAGOBINDAPUR
14	99015	Kandsar	22	720	03337	445494	CHATTISGARH	Gariaband	Mainpur	Kandsar	...	22445494	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (82.3524945018338 20.01110884903634 0)	82.352495	20.011109	GARIABAND	MAINPUR	KANDSAR
15	99016	Yedampayli Kh	27	508	04057	539084	MAHARASHTRA	Gadchiroli	Gadchiroli	Yedampayli Kh	...	27539084	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (80.27671048815088 20.00159245248895 0)	80.276710	20.001592	GADCHIROLI	GADCHIROLI	YEDAMPAYLIKH
16	99017	CHITRA	21	387	03062	409279	ODISHA	Puri	Gop	Chitra	...	21409279	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (86.08091980761213 19.95571374805459 0)	86.080920	19.955714	PURI	GOP	CHITRA
17	99018	Kapurkheda	27	512	04112	545849	MAHARASHTRA	Hingoli	Hingoli	Kapurkheda	...	27545849	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (77.23481253850215 19.93540022837633 0)	77.234813	19.935400	HINGOLI	HINGOLI	KAPURKHEDA
18	99019	CHHELI BERUHAN	21	387	03059	409171	ODISHA	Puri	Kakatpur	Chheliberuhan	...	21409171	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (86.17836938290839 19.9530429586677 0)	86.178369	19.953043	PURI	KAKATPUR	CHELIBERUHAN
19	99020	BALIPADA	21	387	03068	410099	ODISHA	Puri	Gadisagada	Balipada	...	21410099	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (85.57088427569043 19.96894024762039 0)	85.570884	19.968940	PURI	GADISAGADA	BALIPADA
20	99021	UPULA	21	387	03062	409296	ODISHA	Puri	Gop	Upula	...	21409296	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (86.13555752070852 19.95436091191312 0)	86.135558	19.954361	PURI	GOP	UPULA
21	99022	AMURLPADAR	21	395	03167	423878	ODISHA	Kalahandi	Golamunda	Amurlapadar	...	21423878	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (82.78547279122884 20.00971723833214 0)	82.785473	20.009717	KALAHANDI	GOLAMUNDA	AMURLAPADAR
22	99023	Vashind	27	732	04161	552003	MAHARASHTRA	Palghar	Mokhada	Vashind	...	27552003	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (73.38647726632998 19.76257168506569 0)	73.386477	19.762572	PALGHAR	MOKHADA	VASHIND
23	99024	Murnarkhurd	22	413	03353	448084	CHATTISGARH	Uttar Bastar Kanker	Antagarh	Murnarkhurd	...	22448084	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (81.23547208811367 20.00983774790337 0)	81.235472	20.009838	UTARBASTARKANKER	ANTAGARH	MURNARKHURD
24	99025	GUDURUGUMA	21	395	03167	423861	ODISHA	Kalahandi	Golamunda	Guduruguma	...	21423861	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (82.7355320282916 20.00998586492782 0)	82.735532	20.009986	KALAHANDI	GOLAMUNDA	GUDURUGUMA
25	99026	SANDHAKUPA	21	390	03126	417582	ODISHA	Kandhamal	Raikia	Sandhakupa	...	21417582	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (84.22653127484969 19.99517671821366 0)	84.226531	19.995177	KANDHAMAL	RAIKIA	SANDHAKUPA
26	99027	NUAGAR	21	386	03051	408005	ODISHA	Khordha	Nirakarpur	Nuagarh	...	21408005	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (85.49154266680364 19.9709338355765 0)	85.491543	19.970934	KHORDHA	NIRAKARPUR	NUAGARH
27	99028	KAUDIA PUR	21	387	03068	410089	ODISHA	Puri	Gadisagada	Kaudiapur	...	21410089	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (85.61229483970894 19.96808167489219 0)	85.612295	19.968082	PURI	GADISAGADA	KAUDIAPUR
28	99029	Malvakad	27	510	04087	543083	MAHARASHTRA	Yavatmal	Mahagaon	Malvakad	...	27543083	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (77.8093353165372 19.95299042735866 0)	77.809335	19.952990	YAVATMAL	MAHAGAON	MALVAKAD
29	99030	Manusdhari	27	510	04089	543328	MAHARASHTRA	Yavatmal	Ghatanji	Manusdhari	...	27543328	Census Village	query-100	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (78.18699905179517 19.96324591855385 0)	78.186999	19.963246	YAVATMAL	GHATANJI	MANUSDHARI
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
580704	8971	Pudur	33	610	05750	634845	TAMILNADU	Erode	Bhavani	Pudur	...	33634845	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (77.68364546563782 11.72052891197745 0)	77.683645	11.720529	ERODE	BHAVANI	PUDUR
580705	8972	Mattigaikurichi	33	607	05734	633437	TAMILNADU	Viluppuram	Kallakkurichi	Mattigaikurichi	...	33633437	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (78.91236703564583 11.75235416412657 0)	78.912367	11.752354	VILUPURAM	KALAKURICHI	MATIGAIKURICHI
580706	8973	KUNDAKERE	29	578	05576	619555	KARNATAKA	Chamarajanagar	Gundlupet	Kundakere	...	29619555	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (76.78766705171191 11.69129371238183 0)	76.787667	11.691294	CHAMARAJANAGAR	GUNDLUPET	KUNDAKERE
580707	8974	Siruvathur	33	617	05788	636570	TAMILNADU	Cuddalore	Panruti	Siruvathur	...	33636570	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (79.51971991175226 11.76491338137471 0)	79.519720	11.764913	CUDALORE	PANRUTI	SIRUVATHUR
580708	8975	Koilputhur	33	608	05743	634238	TAMILNADU	Salem	Attur	Koilputhur	...	33634238	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (78.58752820785104 11.74587727849368 0)	78.587528	11.745877	SALEM	ATUR	KOILPUTHUR
580709	8976	Tadanur	33	608	05740	633967	TAMILNADU	Salem	Salem	Tadanur	...	33633967	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (78.26225888221929 11.73777616503322 0)	78.262259	11.737776	SALEM	SALEM	TADANUR
580710	8977	Kannamuchi	33	608	05736	633770	TAMILNADU	Salem	Mettur	Kannamoochi	...	33633770	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (77.71400491640352 11.72244749412836 0)	77.714005	11.722447	SALEM	METUR	KANAMOCHI
580711	8978	M.cheetipatti	33	608	05737	633860	TAMILNADU	Salem	Omalur	M.Chettipatti	...	33633860	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (78.00671999323146 11.73115737482174 0)	78.006720	11.731157	SALEM	OMALUR	MCHETIPATI
580712	8979	Puliyampatti	33	608	05737	633859	TAMILNADU	Salem	Omalur	Puliyampatti	...	33633859	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (78.06112695158927 11.73286105402313 0)	78.061127	11.732861	SALEM	OMALUR	PULIYAMPATI
580713	8980	Tiruvamur	33	617	05788	636575	TAMILNADU	Cuddalore	Panruti	Tiruvamur	...	33636575	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (79.47835750821278 11.76539442883406 0)	79.478358	11.765394	CUDALORE	PANRUTI	TIRUVAMUR
580714	8981	Sadaiyampattu	33	607	05734	633435	TAMILNADU	Viluppuram	Kallakkurichi	Sadaiyampattu	...	33633435	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (78.9194259836737 11.75466161791892 0)	78.919426	11.754662	VILUPURAM	KALAKURICHI	SADAIYAMPATU
580715	8982	Deviyanandal	33	607	05735	633649	TAMILNADU	Viluppuram	Ulundurpettai	Deviyanandal	...	33633649	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (79.42950512970077 11.76482430161162 0)	79.429505	11.764824	VILUPURAM	ULUNDURPETAI	DEVIYANANDAL
580716	8983	Kondur	33	617	05789	636682	TAMILNADU	Cuddalore	Cuddalore	Kondur (CT)	...	33636682	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (79.73323389686507 11.77072978835821 0)	79.733234	11.770730	CUDALORE	CUDALORE	KONDURCT
580717	8984	Periyerippatti	33	608	05737	633847	TAMILNADU	Salem	Omalur	Periyerippatti	...	33633847	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (77.97944007326093 11.73221986850045 0)	77.979440	11.732220	SALEM	OMALUR	PERIYERIPATI
580718	8985	Dasagappatti	33	608	05736	633789	TAMILNADU	Salem	Mettur	Dasagappatti	...	33633789	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (77.89464713778546 11.73070260755651 0)	77.894647	11.730703	SALEM	METUR	DASAGAPATI
580719	8986	Pa. Killanur	33	607	05735	633661	TAMILNADU	Viluppuram	Ulundurpettai	Pa. Killanur	...	33633661	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (79.32695685788734 11.76491793777335 0)	79.326957	11.764918	VILUPURAM	ULUNDURPETAI	PAKILANUR
580720	8987	Palamalai	33	608	05736	633773	TAMILNADU	Salem	Mettur	Palamalai	...	33633773	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (77.73588940026741 11.72631357290595 0)	77.735889	11.726314	SALEM	METUR	PALAMALAI
580721	8988	Varakalpattu	33	617	05789	636647	TAMILNADU	Cuddalore	Cuddalore	Varakalpattu	...	33636647	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (79.70417165020058 11.77148310476963 0)	79.704172	11.771483	CUDALORE	CUDALORE	VARAKALPATU
580722	8989	Kuttiadi	32	591	05638	627351	KERALA	Kozhikode	Vadakara	Kuttiadi	...	32627351	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (75.75465352748054 11.65359439478676 0)	75.754654	11.653594	KOZHIKODE	VADAKARA	KUTIADI
580723	8990	Nattapattu	33	617	05789	636639	TAMILNADU	Cuddalore	Cuddalore	Nattapattu	...	33636639	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (79.72478783595248 11.77210261350435 0)	79.724788	11.772103	CUDALORE	CUDALORE	NATAPATU
580724	8991	Kariakoilvalavu	33	608	05743	634239	TAMILNADU	Salem	Attur	Kariakoilvalavu	...	33634239	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (78.63610249939214 11.75071198319809 0)	78.636102	11.750712	SALEM	ATUR	KARIAKOILVALAVU
580725	8992	Chittarasur	33	617	05788	636545	TAMILNADU	Cuddalore	Panruti	Chittarasur	...	33636545	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (79.6297206395021 11.77078493359356 0)	79.629721	11.770785	CUDALORE	PANRUTI	CHITARASUR
580726	8993	Erukkambattu	33	607	05733	633376	TAMILNADU	Viluppuram	Sankarapuram	Erukkambattu	...	33633376	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (78.67449451205358 11.75193707204424 0)	78.674495	11.751937	VILUPURAM	SANKARAPURAM	ERUKAMBATU
580727	8994	Kunjaram	33	607	05735	633670	TAMILNADU	Viluppuram	Ulundurpettai	Kunjaram	...	33633670	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (79.17364085564571 11.76320494906749 0)	79.173641	11.763205	VILUPURAM	ULUNDURPETAI	KUNJARAM
580728	8995	Kuppanur	33	608	05740	633973	TAMILNADU	Salem	Salem	Kuppanur	...	33633973	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (78.28491854569799 11.74291874257921 0)	78.284919	11.742919	SALEM	SALEM	KUPANUR
580729	8996	Tottappattu	33	617	05789	636645	TAMILNADU	Cuddalore	Cuddalore	Tottappattu	...	33636645	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (79.72296406458454 11.77319603927724 0)	79.722964	11.773196	CUDALORE	CUDALORE	TOTAPATU
580730	8997	Ka. Mamanandal	33	607	05734	633434	TAMILNADU	Viluppuram	Kallakkurichi	Ka. Mamanandal	...	33633434	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (78.95762670818024 11.75916507482552 0)	78.957627	11.759165	VILUPURAM	KALAKURICHI	KAMAMANANDAL
580731	8998	Amarakundhi	33	608	05737	633843	TAMILNADU	Salem	Omalur	Amarakundhi	...	33633843	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (77.96749321300744 11.73495462020889 0)	77.967493	11.734955	SALEM	OMALUR	AMARAKUNDHI
580732	8999	Velampatti	33	608	05742	634170	TAMILNADU	Salem	Vazhapadi	Velampatti	...	33634170	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (78.32450960265123 11.74468896133735 0)	78.324510	11.744689	SALEM	VAZHAPADI	VELAMPATI
580733	9000	Kalamarudur	33	607	05735	633663	TAMILNADU	Viluppuram	Ulundurpettai	Kalamarudur	...	33633663	Census Village	query-9	E:/Scrape GIS data/webgis.nic.in/data/Census V...	POINT Z (79.31177452828851 11.76691892997114 0)	79.311775	11.766919	VILUPURAM	ULUNDURPETAI	KALAMARUDUR

	Sr.No.	Packages	Sanctioned Year	Road Name	Upgrade / New	Surface Type	Length	Pavement Cost	No. of CD Works	CD Work Cost	...	Population	SC/ST Population	Block	District	State	index_value	financial_year	district_y	block_y	habitation_y
0	1.0	AN03DGP01	2000-2001	L039-Kalighat Village Road	New Connectivity	-	2.000	150.00	4.0	20.00	...	2063.0	0.0	Diglipur	North and Middle Andaman	Andaman And Nicobar Islands	0	2000	NORTHANDMIDLEANDAMAN	DIGLIPUR	KALIGHATRV
1	1.0	AN03MB21	2000-2001	L043-Karmatang - 10 Village Road	New Connectivity	-	2.000	100.00	1.0	17.00	...	226.0	0.0	Mayabunder	North and Middle Andaman	Andaman And Nicobar Islands	0	2000	NORTHANDMIDLEANDAMAN	MAYABUNDER	PAIKETBAYEFA
2	2.0	AN3DG	2000-2001	L026-Kamalapur Village Road	New Connectivity	-	1.200	58.00	1.0	10.00	...	241.0	0.0	Mayabunder	North and Middle Andaman	Andaman And Nicobar Islands	1	2000	NORTHANDMIDLEANDAMAN	MAYABUNDER	KAMALAPUR
3	1.0	AN01PB03	2000-2001	L039-Havelock Village Road	New Connectivity	-	3.000	180.00	1.0	21.00	...	992.0	0.0	Port Blair	South Andaman	Andaman And Nicobar Islands	0	2000	SOUTHANDAMAN	PORTBLAIR	BEJOYNAGAR
4	2.0	AN01PB04	2000-2001	L040-Havelock Village Road	New Connectivity	-	0.650	38.00	1.0	5.00	...	250.0	0.0	Port Blair	South Andaman	Andaman And Nicobar Islands	1	2000	SOUTHANDAMAN	PORTBLAIR	RADHANAGARVILAGE
5	3.0	AN01PB05	2000-2001	L041-Chidyatapu to Bada balu Road	New Connectivity	-	4.200	327.00	1.0	20.00	...	7.0	0.0	Port Blair	South Andaman	Andaman And Nicobar Islands	2	2000	SOUTHANDAMAN	PORTBLAIR	BADANALAHAORBADABALUEFA
6	3.0	AN01PB05	2000-2001	L041-Chidyatapu to Bada balu Road	New Connectivity	-	4.200	327.00	1.0	20.00	...	55	0	Port Blair	South Andaman	Andaman And Nicobar Islands	3	2000	SOUTHANDAMAN	PORTBLAIR	CHIDIYATAPUWLS
7	4.0	AN01PB06	2000-2001	L042-Burmanallah, Maccapahad, Pema Village Road	New Connectivity	-	5.527	70.00	1.0	10.00	...	288.0	0.0	Port Blair	South Andaman	Andaman And Nicobar Islands	4	2000	SOUTHANDAMAN	PORTBLAIR	RANGACHANG
8	1.0	AP0206	2000-2001	Kodihalli to Hanumanapalli	Upgradation	Gravel	2.000	9.00	0.0	0.00	...	0.0	0.0	Agali	Anantapur	Andhra Pradesh	0	2000	ANANTAPUR	AGALI
9	1.0	AP0206	2000-2001	Valasa to V.Agraharam	Upgradation	Gravel	6.000	14.90	0.0	0.00	...	2858.0	375.0	Amarapuram	Anantapur	Andhra Pradesh	0	2000	ANANTAPUR	AMARAPURAM	VAGRAHARAM
10	1.0	AP0201	2000-2001	Anantapur-Kadiri road to Pulakunta via upparap...	Upgradation	Gravel	5.000	35.11	0.0	0.00	...	2444.0	361.0	Anantapur	Anantapur	Andhra Pradesh	0	2000	ANANTAPUR	ANANTAPUR	UPARAPALI
11	2.0	AP0201	2000-2001	Anantapur-Kadiri road to Mannila	Upgradation	Gravel	1.500	11.94	0.0	0.00	...	1860.0	357.0	Anantapur	Anantapur	Andhra Pradesh	1	2000	ANANTAPUR	ANANTAPUR	MANILA
12	3.0	AP0201	2000-2001	Anantapur-Uravakonda road to N.N.Kunta Via Kodimi	Upgradation	Gravel	3.000	29.17	0.0	0.00	...	1258.0	140.0	Anantapur	Anantapur	Andhra Pradesh	2	2000	ANANTAPUR	ANANTAPUR	KODIMI
13	4.0	AP0201	2000-2001	Anantapur Kalyandurg road to Kamarupalli	New Connectivity	-	2.200	17.99	0.0	0.00	...	1168.0	152.0	Anantapur	Anantapur	Andhra Pradesh	3	2000	ANANTAPUR	ANANTAPUR	KAMARUPALI
14	1.0	AP0203	2000-2001	Malyavantham to Cheemalanagepalli Via M.Cherlo...	Upgradation	Gravel	3.500	19.20	0.0	0.00	...	206.0	0.0	Bathalapalle	Anantapur	Andhra Pradesh	0	2000	ANANTAPUR	BATHALAPALE	CHEMALANAGEPALI
15	1.0	AP0203	2000-2001	Malyavantham to Cheemalanagepalli Via M.Cherlo...	Upgradation	Gravel	3.500	19.20	0.0	0.00	...	732	0	Bathalapalle	Anantapur	Andhra Pradesh	1	2000	ANANTAPUR	BATHALAPALE	MCHERLOPALE
16	1.0	AP0204	2000-2001	Upparahal cross to singanahalli via Sridhara g...	Upgradation	WBM	4.500	21.50	0.0	0.00	...	1256.0	0.0	Bommanahal	Anantapur	Andhra Pradesh	0	2000	ANANTAPUR	BOMANAHAL	SINGANAHALI
17	1.0	AP0204	2000-2001	Upparahal cross to singanahalli via Sridhara g...	Upgradation	WBM	4.500	21.50	0.0	0.00	...	1272	0	Bommanahal	Anantapur	Andhra Pradesh	1	2000	ANANTAPUR	BOMANAHAL	SRIRANGAPURAM
18	1.0	AP0203	2000-2001	Approach road to Sugepalli	Upgradation	Gravel	3.000	20.00	0.0	0.00	...	717.0	187.0	Brahmasamudram	Anantapur	Andhra Pradesh	0	2000	ANANTAPUR	BRAHMASAMUDRAM	SUGEPALI
19	1.0	AP0208	2000-2001	Rasimpalli to Yerlampalli via Kothakota	Upgradation	WBM	4.400	25.00	0.0	0.00	...	1625.0	341.0	Bukkapatnam	Anantapur	Andhra Pradesh	0	2000	ANANTAPUR	BUKAPATNAM	KOTHAKOTA
20	2.0	AP0208	2000-2001	Pamudurthy-Reddipalli road to Reddyvaripalli t...	Upgradation	Gravel	5.500	22.40	0.0	0.00	...	249	11	Bukkapatnam	Anantapur	Andhra Pradesh	1	2000	ANANTAPUR	BUKAPATNAM	RASIMPALI
21	2.0	AP0208	2000-2001	Pamudurthy-Reddipalli road to Reddyvaripalli t...	Upgradation	Gravel	5.500	22.40	0.0	0.00	...	410	27	Bukkapatnam	Anantapur	Andhra Pradesh	2	2000	ANANTAPUR	BUKAPATNAM	YARLAMPALE
22	2.0	AP0208	2000-2001	Pamudurthy-Reddipalli road to Reddyvaripalli t...	Upgradation	Gravel	5.500	22.40	0.0	0.00	...	385.0	385.0	Bukkapatnam	Anantapur	Andhra Pradesh	3	2000	ANANTAPUR	BUKAPATNAM	MADIREBAILUTHANDA
23	2.0	AP0208	2000-2001	Pamudurthy-Reddipalli road to Reddyvaripalli t...	Upgradation	Gravel	5.500	22.40	0.0	0.00	...	282	254	Bukkapatnam	Anantapur	Andhra Pradesh	4	2000	ANANTAPUR	BUKAPATNAM	REDIVARIPALETHANDA
24	3.0	AP0208	2000-2001	Krishnapuram village to Gopalapuram	Upgradation	Gravel	3.400	25.00	0.0	0.00	...	2197.0	423.0	Bukkapatnam	Anantapur	Andhra Pradesh	5	2000	ANANTAPUR	BUKAPATNAM	KRISHNAPURAM
25	2.0	AP0208	2000-2001	Pamudurthy-Reddipalli road to Reddyvaripalli t...	Upgradation	Gravel	5.500	22.40	0.0	0.00	...	266	126	Bukkapatnam	Anantapur	Andhra Pradesh	6	2000	ANANTAPUR	BUKAPATNAM	VENUGOPALAPURAM
26	1.0	AP0201	2000-2001	B.K.Samudram -Narpala road to K.K.Agraharam	Upgradation	WBM	2.600	30.00	0.0	0.00	...	2337.0	738.0	Bukkarayasamudram	Anantapur	Andhra Pradesh	0	2000	ANANTAPUR	BUKARAYASAMUDRAM	KAGRAHARAM
27	1.0	AP0205	2000-2001	K.D. road to Ontikonda via Medapuram	Upgradation	Gravel	3.000	10.60	0.0	0.00	...	5150.0	682.0	Chenne Kothapalle	Anantapur	Andhra Pradesh	0	2000	ANANTAPUR	CHENEKOTHAPALE	MEDAPURAM
28	2.0	AP0205	2000-2001	C.K.Palli to Hariyancheruvu via Chinnapalli	Upgradation	Gravel	1.000	5.40	0.0	0.00	...	497.0	42.0	Chenne Kothapalle	Anantapur	Andhra Pradesh	1	2000	ANANTAPUR	CHENEKOTHAPALE	CHENAMPALI
29	3.0	AP0205	2000-2001	N.S. Gate-Dharmavaram road to Basinepalli	Upgradation	Gravel	1.250	4.10	0.0	0.00	...	968	0	Chenne Kothapalle	Anantapur	Andhra Pradesh	2	2000	ANANTAPUR	CHENEKOTHAPALE	HARIYANCHERUVU
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
337164	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	618	231	Mori	Uttarkashi	Uttarakhand	4	2018	UTARKASHI	MORI	OSALA
337165	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	196	36	Mori	Uttarkashi	Uttarakhand	5	2018	UTARKASHI	MORI	PAWANI
337166	5.0	UT1384	2018-2019	L027-Mori to Salara	New Connectivity	-	16.550	530.50	43	338.55	...	437	234	Mori	Uttarkashi	Uttarakhand	6	2018	UTARKASHI	MORI	MAUTAR
337167	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	667	259	Mori	Uttarkashi	Uttarakhand	7	2018	UTARKASHI	MORI	SALRA
337168	6.0	UT1387	2018-2019	L030-Naitwar to Nuranu	New Connectivity	-	12.075	231.49	77	197.10	...	322	67	Mori	Uttarkashi	Uttarakhand	8	2018	UTARKASHI	MORI	NURANU
337169	7.0	UT1389	2018-2019	L048-Hadwari to Sewa Motor Road	New Connectivity	-	12.900	239.37	69	130.92	...	362	163	Mori	Uttarkashi	Uttarakhand	9	2018	UTARKASHI	MORI	SEWA
337170	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	322	212	Mori	Uttarkashi	Uttarakhand	10	2018	UTARKASHI	MORI	WARI
337171	8.0	UT1373	2018-2019	L028-Netwara to Hatwari	New Connectivity	-	23.750	848.40	101	192.46	...	859	259	Mori	Uttarkashi	Uttarakhand	11	2018	UTARKASHI	MORI	BHITRI
337172	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	410	81	Mori	Uttarkashi	Uttarakhand	12	2018	UTARKASHI	MORI	HALYWARI
337173	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	598	184	Mori	Uttarkashi	Uttarakhand	13	2018	UTARKASHI	MORI	KHANYASANI
337174	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	262	26	Mori	Uttarkashi	Uttarakhand	14	2018	UTARKASHI	MORI	PUJELI
337175	1.0	UT1372	2018-2019	L034-Chakra Gaon to Kansera	New Connectivity	-	9.250	392.43	5	9.76	...	637	70	Naugaon	Uttarkashi	Uttarakhand	0	2018	UTARKASHI	NAUGAON	KANSERU
337176	2.0	UT1333	2018-2019	L056-Nagangaon to Kursil Motor Road (VR56)	New Connectivity	-	10.380	403.83	8	11.65	...	430	12	Naugaon	Uttarkashi	Uttarakhand	1	2018	UTARKASHI	NAUGAON	KURSIL
337177	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	519	100	Naugaon	Uttarkashi	Uttarakhand	2	2018	UTARKASHI	NAUGAON	SYALAB
337178	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	240	148	Naugaon	Uttarkashi	Uttarakhand	3	2018	UTARKASHI	NAUGAON	KHAND
337179	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	457	53	Naugaon	Uttarkashi	Uttarakhand	4	2018	UTARKASHI	NAUGAON	MASALGAON
337180	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	831	89	Naugaon	Uttarkashi	Uttarakhand	5	2018	UTARKASHI	NAUGAON	NAGARGAON
337181	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	269	21	Naugaon	Uttarkashi	Uttarakhand	6	2018	UTARKASHI	NAUGAON	THAN
337182	4.0	UT1365	2018-2019	L022-Ranachatti to Nisari	New Connectivity	-	6.300	117.23	35	62.88	...	317	58	Naugaon	Uttarkashi	Uttarakhand	7	2018	UTARKASHI	NAUGAON	DANGURGAON
337183	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	319	15	Naugaon	Uttarkashi	Uttarakhand	8	2018	UTARKASHI	NAUGAON	NISARI
337184	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	354	13	Naugaon	Uttarkashi	Uttarakhand	9	2018	UTARKASHI	NAUGAON	PINDKIMADESH
337185	5.0	UT1363	2018-2019	L031-Pujar Gaon to Pali	New Connectivity	-	4.150	78.93	23	47.96	...	684	175	Naugaon	Uttarkashi	Uttarakhand	10	2018	UTARKASHI	NAUGAON	PALI
337186	6.0	UT1367	2018-2019	L025-Syalna to Bhumsari	New Connectivity	-	10.400	140.08	73	177.96	...	498	92	Naugaon	Uttarkashi	Uttarakhand	11	2018	UTARKASHI	NAUGAON	BHANSARI
337187	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	680	165	Naugaon	Uttarkashi	Uttarakhand	12	2018	UTARKASHI	NAUGAON	SYALNA
337188	7.0	UT1380	2018-2019	L046-Naugaon Purola Mr Km 2 to Thali	New Connectivity	-	10.375	230.47	71	155.54	...	404	102	Naugaon	Uttarkashi	Uttarakhand	13	2018	UTARKASHI	NAUGAON	THALI
337189	8.0	UT1388	2018-2019	L058-NH 94 Kharadi - Nagan Gaon M.R. Km 9 to B...	New Connectivity	-	4.300	47.48	26	50.82	...	373	134	Naugaon	Uttarkashi	Uttarakhand	14	2018	UTARKASHI	NAUGAON	BACHARGAON
337190	1.0	UT1344	2018-2019	L029-Hundoli Pani Gaon to kantari	New Connectivity	-	5.775	198.57	14	22.62	...	259	117	Purola	Uttarkashi	Uttarakhand	0	2018	UTARKASHI	PUROLA	BINAI
337191	2.0	UT1366	2018-2019	L026-Rama to Syaluk	New Connectivity	-	7.750	190.66	54	189.56	...	676	192	Purola	Uttarkashi	Uttarakhand	1	2018	UTARKASHI	PUROLA	KANTARI
337192	2.0	UT1366	2018-2019	L026-Rama to Syaluk	New Connectivity	-	7.750	190.66	54	189.56	...	117	46	Purola	Uttarkashi	Uttarakhand	2	2018	UTARKASHI	PUROLA	DOKHARIYANI
337193	2.0	UT1366	2018-2019	L026-Rama to Syaluk	New Connectivity	-	7.750	190.66	54	189.56	...	291	52	Purola	Uttarkashi	Uttarakhand	3	2018	UTARKASHI	PUROLA	SYALUKA

	Sr.No.	Packages	Sanctioned Year	Road Name	Upgrade / New	Surface Type	Length	Pavement Cost	No. of CD Works	CD Work Cost	...	STVIL	LOC_STAT_1	layer	path	geometry	longitude	latitude	dtname_y	sdtname_y	vilname_y
0	1.0	AN03DGP01	2000-2001	L039-Kalighat Village Road	New Connectivity	-	2.000	150.00	4.0	20.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1	1.0	AN03MB21	2000-2001	L043-Karmatang - 10 Village Road	New Connectivity	-	2.000	100.00	1.0	17.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2	2.0	AN3DG	2000-2001	L026-Kamalapur Village Road	New Connectivity	-	1.200	58.00	1.0	10.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
3	1.0	AN01PB03	2000-2001	L039-Havelock Village Road	New Connectivity	-	3.000	180.00	1.0	21.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
4	2.0	AN01PB04	2000-2001	L040-Havelock Village Road	New Connectivity	-	0.650	38.00	1.0	5.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
5	3.0	AN01PB05	2000-2001	L041-Chidyatapu to Bada balu Road	New Connectivity	-	4.200	327.00	1.0	20.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
6	3.0	AN01PB05	2000-2001	L041-Chidyatapu to Bada balu Road	New Connectivity	-	4.200	327.00	1.0	20.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
7	4.0	AN01PB06	2000-2001	L042-Burmanallah, Maccapahad, Pema Village Road	New Connectivity	-	5.527	70.00	1.0	10.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
8	1.0	AP0206	2000-2001	Kodihalli to Hanumanapalli	Upgradation	Gravel	2.000	9.00	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9	1.0	AP0206	2000-2001	Valasa to V.Agraharam	Upgradation	Gravel	6.000	14.90	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
10	1.0	AP0201	2000-2001	Anantapur-Kadiri road to Pulakunta via upparap...	Upgradation	Gravel	5.000	35.11	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
13	4.0	AP0201	2000-2001	Anantapur Kalyandurg road to Kamarupalli	New Connectivity	-	2.200	17.99	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
14	1.0	AP0203	2000-2001	Malyavantham to Cheemalanagepalli Via M.Cherlo...	Upgradation	Gravel	3.500	19.20	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
15	1.0	AP0203	2000-2001	Malyavantham to Cheemalanagepalli Via M.Cherlo...	Upgradation	Gravel	3.500	19.20	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
17	1.0	AP0204	2000-2001	Upparahal cross to singanahalli via Sridhara g...	Upgradation	WBM	4.500	21.50	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
18	1.0	AP0203	2000-2001	Approach road to Sugepalli	Upgradation	Gravel	3.000	20.00	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
20	2.0	AP0208	2000-2001	Pamudurthy-Reddipalli road to Reddyvaripalli t...	Upgradation	Gravel	5.500	22.40	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
21	2.0	AP0208	2000-2001	Pamudurthy-Reddipalli road to Reddyvaripalli t...	Upgradation	Gravel	5.500	22.40	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
22	2.0	AP0208	2000-2001	Pamudurthy-Reddipalli road to Reddyvaripalli t...	Upgradation	Gravel	5.500	22.40	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
23	2.0	AP0208	2000-2001	Pamudurthy-Reddipalli road to Reddyvaripalli t...	Upgradation	Gravel	5.500	22.40	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
25	2.0	AP0208	2000-2001	Pamudurthy-Reddipalli road to Reddyvaripalli t...	Upgradation	Gravel	5.500	22.40	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
26	1.0	AP0201	2000-2001	B.K.Samudram -Narpala road to K.K.Agraharam	Upgradation	WBM	2.600	30.00	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
28	2.0	AP0205	2000-2001	C.K.Palli to Hariyancheruvu via Chinnapalli	Upgradation	Gravel	1.000	5.40	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
29	3.0	AP0205	2000-2001	N.S. Gate-Dharmavaram road to Basinepalli	Upgradation	Gravel	1.250	4.10	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
30	3.0	AP0205	2000-2001	N.S. Gate-Dharmavaram road to Basinepalli	Upgradation	Gravel	1.250	4.10	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
31	1.0	AP0206	2000-2001	K.D road to Korlakunta	New Connectivity	-	2.200	12.30	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
37	1.0	AP0203	2000-2001	Regatipalli to Seetharampalli	Upgradation	Gravel	4.800	28.63	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
38	1.0	AP0207	2000-2001	Gandlapenta to Poreddipalli to meet Malameedap...	Upgradation	Gravel	1.900	25.00	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39	2.0	AP0207	2000-2001	Kodimi - Industrial state to Budduvelugula	Upgradation	Gravel	1.000	11.00	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
40	2.0	AP0207	2000-2001	Kodimi - Industrial state to Budduvelugula	Upgradation	Gravel	1.000	11.00	0.0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
341878	2.0	UT1181	2018-2019	L038-Bikol to Bhandarki	New Connectivity	-	12.025	555.38	47	180.90	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341879	2.0	UT1181	2018-2019	L038-Bikol to Bhandarki	New Connectivity	-	12.025	555.38	47	180.90	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341880	2.0	UT1181	2018-2019	L038-Bikol to Bhandarki	New Connectivity	-	12.025	555.38	47	180.90	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341881	3.0	UT1108	2018-2019	L044-Jwarna Kansyud MR	New Connectivity	-	18.500	671.41	26	166.58	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341882	2.0	UT1181	2018-2019	L038-Bikol to Bhandarki	New Connectivity	-	12.025	555.38	47	180.90	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341883	2.0	UT1181	2018-2019	L038-Bikol to Bhandarki	New Connectivity	-	12.025	555.38	47	180.90	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341884	4.0	UT1182	2018-2019	L050-Chamba Dharasu Motor Road Km 64.00 to Naw...	New Connectivity	-	6.250	203.87	34	72.73	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341885	2.0	UT1181	2018-2019	L038-Bikol to Bhandarki	New Connectivity	-	12.025	555.38	47	180.90	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341888	2.0	UT1378	2018-2019	L045-Gangnani To Bhangeli Motor Road	New Connectivity	-	2.300	108.33	10	21.09	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341905	2.0	UT1361	2018-2019	L033-Jakhol to Liwari	New Connectivity	-	0.000	0.00	0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341906	3.0	UT1382	2018-2019	L037-Kharsari to Jeewanu	New Connectivity	-	0.000	0.00	0	0.00	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341919	1.0	UT1372	2018-2019	L034-Chakra Gaon to Kansera	New Connectivity	-	9.250	392.43	5	9.76	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341920	2.0	UT1333	2018-2019	L056-Nagangaon to Kursil Motor Road (VR56)	New Connectivity	-	10.380	403.83	8	11.65	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341921	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341922	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341923	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341924	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341925	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341926	4.0	UT1365	2018-2019	L022-Ranachatti to Nisari	New Connectivity	-	6.300	117.23	35	62.88	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341927	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341928	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341929	5.0	UT1363	2018-2019	L031-Pujar Gaon to Pali	New Connectivity	-	4.150	78.93	23	47.96	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341930	6.0	UT1367	2018-2019	L025-Syalna to Bhumsari	New Connectivity	-	10.400	140.08	73	177.96	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341931	3.0	UT1371	2018-2019	L030-NH 94 Km 188 kharadi to Nagangaon-Bacharg...	New Connectivity	-	9.300	296.62	13	44.95	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341932	7.0	UT1380	2018-2019	L046-Naugaon Purola Mr Km 2 to Thali	New Connectivity	-	10.375	230.47	71	155.54	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341933	8.0	UT1388	2018-2019	L058-NH 94 Kharadi - Nagan Gaon M.R. Km 9 to B...	New Connectivity	-	4.300	47.48	26	50.82	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341934	1.0	UT1344	2018-2019	L029-Hundoli Pani Gaon to kantari	New Connectivity	-	5.775	198.57	14	22.62	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341935	2.0	UT1366	2018-2019	L026-Rama to Syaluk	New Connectivity	-	7.750	190.66	54	189.56	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341936	2.0	UT1366	2018-2019	L026-Rama to Syaluk	New Connectivity	-	7.750	190.66	54	189.56	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
341937	2.0	UT1366	2018-2019	L026-Rama to Syaluk	New Connectivity	-	7.750	190.66	54	189.56	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

	Sr.No.	Packages	Sanctioned Year	Road Name	Upgrade / New	Surface Type	Length	Pavement Cost	No. of CD Works	CD Work Cost	...	Habitation Name	Population	SC/ST Population	Block	District	State	index_value	financial_year	longitude	latitude
11	2.0	AP0201	2000-2001	Anantapur-Kadiri road to Mannila	Upgradation	Gravel	1.500	11.94	0.0	0.00	...	Mannila	1860.0	357.0	Anantapur	Anantapur	Andhra Pradesh	1	2000	77.688387	14.561644
12	3.0	AP0201	2000-2001	Anantapur-Uravakonda road to N.N.Kunta Via Kodimi	Upgradation	Gravel	3.000	29.17	0.0	0.00	...	Kodimi	1258.0	140.0	Anantapur	Anantapur	Andhra Pradesh	2	2000	77.548963	14.709472
16	1.0	AP0204	2000-2001	Upparahal cross to singanahalli via Sridhara g...	Upgradation	WBM	4.500	21.50	0.0	0.00	...	Singanahalli	1256.0	0.0	Bommanahal	Anantapur	Andhra Pradesh	0	2000	77.010968	14.901521
19	1.0	AP0208	2000-2001	Rasimpalli to Yerlampalli via Kothakota	Upgradation	WBM	4.400	25.00	0.0	0.00	...	Kothakota	1625.0	341.0	Bukkapatnam	Anantapur	Andhra Pradesh	0	2000	77.940510	14.240095
24	3.0	AP0208	2000-2001	Krishnapuram village to Gopalapuram	Upgradation	Gravel	3.400	25.00	0.0	0.00	...	Krishnapuram	2197.0	423.0	Bukkapatnam	Anantapur	Andhra Pradesh	5	2000	77.911692	14.345388
27	1.0	AP0205	2000-2001	K.D. road to Ontikonda via Medapuram	Upgradation	Gravel	3.000	10.60	0.0	0.00	...	Medapuram	5150.0	682.0	Chenne Kothapalle	Anantapur	Andhra Pradesh	0	2000	77.713098	14.335782
32	2.0	AP0208	2000-2001	K.D road to Madirepalli via Koduru	Upgradation	Gravel	4.000	15.50	0.0	0.00	...	Kodur	1731.0	873.0	Chilamathur	Anantapur	Andhra Pradesh	1	2000	77.729704	13.871114
33	1.0	AP0204	2000-2001	Bellary - Bangalore R&B road to Meet lakshmipu...	Upgradation	Gravel	5.000	24.00	0.0	0.00	...	Lakshmipuram	134.0	19.0	D Hirehal	Anantapur	Andhra Pradesh	0	2000	76.789890	14.985333
34	2.0	AP0204	2000-2001	Somalapuram to Khanapuram in k.m.0/0 to 5/4	New Connectivity	-	4.600	33.00	0.0	0.00	...	Madenahalli	800	0	D Hirehal	Anantapur	Andhra Pradesh	1	2000	76.810270	14.988287
35	2.0	AP0204	2000-2001	Somalapuram to Khanapuram in k.m.0/0 to 5/4	New Connectivity	-	4.600	33.00	0.0	0.00	...	Somalapuram	1486.0	266.0	D Hirehal	Anantapur	Andhra Pradesh	2	2000	76.872691	14.913011
36	1.0	AP0203	2000-2001	Regatipalli to Seetharampalli	Upgradation	Gravel	4.800	28.63	0.0	0.00	...	Regatipalle	1808.0	401.0	Dharmavaram	Anantapur	Andhra Pradesh	0	2000	77.678747	14.401817
42	2.0	AP0202	2000-2001	NBB road to P.Gajulapalli	Upgradation	WBM	3.300	47.00	0.0	0.00	...	Mamadur	1254	412	Gooty	Anantapur	Andhra Pradesh	1	2000	77.587042	15.048776
52	2.0	AP0205	2000-2001	H.B road to Thumukunta	Upgradation	Gravel	1.000	4.00	0.0	0.00	...	Thumukunta	1985.0	351.0	Hindupur	Anantapur	Andhra Pradesh	1	2000	77.487757	13.718834
57	3.0	AP0208	2000-2001	A.P.road to Patnam	Upgradation	WBM	1.200	12.00	0.0	0.00	...	Patnam	2967.0	71.0	Kadiri	Anantapur	Andhra Pradesh	2	2000	78.094893	14.234594
59	3.0	AP0205	2000-2001	Thogarakunta to C.N. Kota via Thumucherla	Upgradation	WBM	1.000	3.00	0.0	0.00	...	Narasampalle	1210	220	Kanaganapalle	Anantapur	Andhra Pradesh	1	2000	77.432635	14.421211
62	3.0	AP0205	2000-2001	Thogarakunta to C.N. Kota via Thumucherla	Upgradation	WBM	1.000	3.00	0.0	0.00	...	Thogarakunta	3099	600	Kanaganapalle	Anantapur	Andhra Pradesh	4	2000	77.460447	14.489019
63	3.0	AP0205	2000-2001	Thogarakunta to C.N. Kota via Thumucherla	Upgradation	WBM	1.000	3.00	0.0	0.00	...	Thumucherla	3182	520	Kanaganapalle	Anantapur	Andhra Pradesh	5	2000	77.450832	14.534511
65	1.0	AP0201	2000-2001	Anantapur-Bellary road to Kammur	Upgradation	WBM	2.200	24.00	0.0	0.00	...	Kammuru	1886.0	415.0	Kudair	Anantapur	Andhra Pradesh	0	2000	77.483648	14.745821
67	1.0	AP0205	2000-2001	Approach road to Mydugolam	Upgradation	Gravel	1.600	7.00	0.0	0.00	...	Mydugolam	1435.0	383.0	Lepakshi	Anantapur	Andhra Pradesh	0	2000	77.626589	13.742150
69	3.0	AP0206	2000-2001	Chalivendula to Kondur	Upgradation	Gravel	3.500	14.20	0.0	0.00	...	Kondur	2751.0	573.0	Lepakshi	Anantapur	Andhra Pradesh	2	2000	77.609664	13.850544
77	1.0	AP0207	2000-2001	A.P.road to K.Pulakunta	Upgradation	WBM	4.000	29.50	0.0	0.00	...	Kadiripulakunta	1795.0	81.0	Nallacheruvu	Anantapur	Andhra Pradesh	0	2000	78.158101	13.988648
80	1.0	AP0207	2000-2001	KH road to Inagalur	Upgradation	Gravel	1.000	30.00	0.0	0.00	...	Inagalur	1085.0	256.0	Obuladevaracheruvu	Anantapur	Andhra Pradesh	0	2000	78.039584	14.045617
81	1.0	AP0202	2000-2001	R&B road to Vankarajukalva	Upgradation	WBM	1.500	12.00	0.0	0.00	...	Vankarajukalva	1134.0	199.0	Pamidi	Anantapur	Andhra Pradesh	0	2000	77.548650	14.919690
84	3.0	AP0205	2000-2001	Approach road to Moda	Upgradation	WBM	1.000	8.00	0.0	0.00	...	Moda	2338.0	747.0	Parigi	Anantapur	Andhra Pradesh	2	2000	77.441698	13.825899
88	7.0	AP0205	2000-2001	Approach road to Vittapalli	Upgradation	Gravel	1.600	6.00	0.0	0.00	...	Vittapalle	1276.0	256.0	Parigi	Anantapur	Andhra Pradesh	6	2000	77.463259	13.939104
90	1.0	AP0202	2000-2001	Chinthalacheruvu to Ravuludiki	Upgradation	Gravel	2.000	12.00	0.0	0.00	...	Ravuludiki	1241.0	205.0	Peddavadugur	Anantapur	Andhra Pradesh	0	2000	77.795869	15.008336
92	1.0	AP0205	2000-2001	Penukonda-Madakasira road to Nagalur (Upto Man...	Upgradation	WBM	1.100	10.60	0.0	0.00	...	Nagalur	1374	359	Penu Konda	Anantapur	Andhra Pradesh	1	2000	77.519747	14.010949
93	1.0	AP0205	2000-2001	Kothagadikunta to Nasanakota via Venkatapuram	Upgradation	WBM	2.200	13.10	0.0	0.00	...	Nasanakota	1191.0	250.0	Ramagiri	Anantapur	Andhra Pradesh	0	2000	77.445027	14.353947
96	2.0	AP0205	2000-2001	N.P. road to Polepalli	Upgradation	Gravel	1.000	11.70	0.0	0.00	...	Polepalle	1552	157	Ramagiri	Anantapur	Andhra Pradesh	3	2000	77.558249	14.303884
99	1.0	AP0201	2000-2001	NH7 to Hampapuram	Upgradation	WBM	1.000	11.99	0.0	0.00	...	Hampapuram	1942.0	411.0	Raptadu	Anantapur	Andhra Pradesh	0	2000	77.639533	14.557943
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
341886	1.0	UT1370	2018-2019	L021-Gyansu to Gyanja	New Connectivity	-	4.600	174.11	2	8.04	...	Gyanja	483	0	Bhatwari	Uttarkashi	Uttarakhand	0	2018	78.413877	30.754982
341887	2.0	UT1378	2018-2019	L045-Gangnani To Bhangeli Motor Road	New Connectivity	-	2.300	108.33	10	21.09	...	Sald Urph Maja Gaon	708	167	Bhatwari	Uttarkashi	Uttarakhand	1	2018	78.408133	30.757909
341889	1.0	UT1376	2018-2019	L024-Dharasu Chinayal Rd to Bankot	New Connectivity	-	3.010	99.01	4	7.73	...	Bankot	506	24	Chinyalisaur	Uttarkashi	Uttarakhand	0	2018	78.407010	30.558020
341890	2.0	UT1374	2018-2019	L036-Banchora Mt Rd to Jokni	New Connectivity	-	4.195	129.49	1	1.10	...	Jokhoni	550	206	Chinyalisaur	Uttarkashi	Uttarakhand	1	2018	78.230446	30.626543
341891	3.0	UT1372	2018-2019	L035-Barethi to Chiloth	New Connectivity	-	3.330	99.24	3	6.25	...	Chiloth	614	252	Chinyalisaur	Uttarkashi	Uttarakhand	2	2018	78.286578	30.629910
341892	4.0	UT1390	2018-2019	L025-Dharasu Chiniyal Mt to Jogat Malla	New Connectivity	-	6.700	202.42	9	16.24	...	Jogat Malla	919	18	Chinyalisaur	Uttarkashi	Uttarakhand	3	2018	78.414828	30.517160
341893	1.0	UT1368	2018-2019	L024-Nakauri to Singoth	New Connectivity	-	4.080	139.02	5	26.87	...	Singot	568	60	Dunda	Uttarkashi	Uttarakhand	0	2018	78.319728	30.761364
341894	2.0	UT1369	2018-2019	L027-Bandarkot to Panjiyala	New Connectivity	-	6.760	197.48	3	7.91	...	Genwala	623	131	Dunda	Uttarkashi	Uttarakhand	1	2018	78.300078	30.700085
341895	2.0	UT1369	2018-2019	L027-Bandarkot to Panjiyala	New Connectivity	-	6.760	197.48	3	7.91	...	Genwala	623	131	Dunda	Uttarkashi	Uttarakhand	1	2018	78.363835	30.750944
341896	2.0	UT1369	2018-2019	L027-Bandarkot to Panjiyala	New Connectivity	-	6.760	197.48	3	7.91	...	Jugaldi	575	90	Dunda	Uttarkashi	Uttarakhand	2	2018	78.365890	30.769859
341897	2.0	UT1369	2018-2019	L027-Bandarkot to Panjiyala	New Connectivity	-	6.760	197.48	3	7.91	...	Panjyala	697	205	Dunda	Uttarkashi	Uttarakhand	3	2018	78.368008	30.775817
341898	3.0	UT1377	2018-2019	L025-Nakuri to Barjati Manglijera	New Connectivity	-	7.950	240.43	25	70.54	...	Barsali	745	387	Dunda	Uttarkashi	Uttarakhand	4	2018	78.337649	30.733600
341899	2.0	UT1369	2018-2019	L027-Bandarkot to Panjiyala	New Connectivity	-	6.760	197.48	3	7.91	...	Kunsi	322	158	Dunda	Uttarkashi	Uttarakhand	5	2018	78.324087	30.737880
341900	2.0	UT1369	2018-2019	L027-Bandarkot to Panjiyala	New Connectivity	-	6.760	197.48	3	7.91	...	Manglisera	160	43	Dunda	Uttarkashi	Uttarakhand	6	2018	78.320391	30.754015
341901	4.0	UT1383	2018-2019	L041-MDRS to Huldiyana	New Connectivity	-	3.900	165.87	7	16.35	...	Huldiyana	551	32	Dunda	Uttarkashi	Uttarakhand	7	2018	78.521873	30.538452
341902	5.0	UT1391	2018-2019	L028-Barethi to Kanwa	New Connectivity	-	5.600	238.15	14	34.89	...	Kanwa	503	171	Dunda	Uttarkashi	Uttarakhand	8	2018	78.389017	30.788455
341903	2.0	UT1369	2018-2019	L027-Bandarkot to Panjiyala	New Connectivity	-	6.760	197.48	3	7.91	...	Kharwan	271	77	Dunda	Uttarkashi	Uttarakhand	9	2018	78.394331	30.763126
341904	1.0	UT1386	2018-2019	L031-Kot Gaon to Kalab	New Connectivity	-	15.000	289.12	87	196.60	...	Kalap	426	75	Mori	Uttarkashi	Uttarakhand	0	2018	78.146081	31.096989
341907	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	Gangar	432	106	Mori	Uttarkashi	Uttarakhand	3	2018	78.312092	31.107819
341908	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	Osala	618	231	Mori	Uttarkashi	Uttarakhand	4	2018	78.343235	31.118007
341909	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	Pawani	196	36	Mori	Uttarkashi	Uttarakhand	5	2018	78.329043	31.117704
341910	5.0	UT1384	2018-2019	L027-Mori to Salara	New Connectivity	-	16.550	530.50	43	338.55	...	Mautar	437	234	Mori	Uttarkashi	Uttarakhand	6	2018	78.027332	31.025663
341911	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	Salra	667	259	Mori	Uttarkashi	Uttarakhand	7	2018	78.020329	31.064475
341912	6.0	UT1387	2018-2019	L030-Naitwar to Nuranu	New Connectivity	-	12.075	231.49	77	197.10	...	Nuranu	322	67	Mori	Uttarkashi	Uttarakhand	8	2018	78.066090	31.084444
341913	7.0	UT1389	2018-2019	L048-Hadwari to Sewa Motor Road	New Connectivity	-	12.900	239.37	69	130.92	...	Sewa	362	163	Mori	Uttarkashi	Uttarakhand	9	2018	78.075500	31.172365
341914	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	Wari	322	212	Mori	Uttarkashi	Uttarakhand	10	2018	78.082063	31.155143
341915	8.0	UT1373	2018-2019	L028-Netwara to Hatwari	New Connectivity	-	23.750	848.40	101	192.46	...	Bhitri	859	259	Mori	Uttarkashi	Uttarakhand	11	2018	78.095580	31.126035
341916	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	Halywari	410	81	Mori	Uttarkashi	Uttarakhand	12	2018	78.067705	31.138329
341917	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	Khanyasani	598	184	Mori	Uttarkashi	Uttarakhand	13	2018	78.100767	31.110689
341918	4.0	UT1364	2018-2019	L021-Saur to Osala	New Connectivity	-	28.100	467.07	162	339.03	...	Pujeli	262	26	Mori	Uttarkashi	Uttarakhand	14	2018	78.086901	31.104746

	Habitation Name	Block	District	latitude	longitude
0	Kalighat RV	Diglipur	North and Middle Andaman	13.211572	92.978828
1	Paiket Bay EFA	Mayabunder	North and Middle Andaman	12.913057	92.897743
2	Kamalapur	Mayabunder	North and Middle Andaman	12.913057	92.897743
3	Bejoy Nagar	Port Blair	South Andaman	11.623377	92.726483
4	Rangachang	Port Blair	South Andaman	11.583965	92.734986
5	Chidiyatapu WLS	Port Blair	South Andaman	11.556536	92.729871
6	Bada Nallaha or Bada Balu EFA	Port Blair	South Andaman	11.623377	92.726483
7	Radha Nagar Village	Port Blair	South Andaman	11.984455	92.950845
8	Kamarupalli	Anantapur	Anantapur	14.661702	77.475933
9	-	Agali	Anantapur	13.785969	77.052848
10	V.Agraharam	Amarapuram	Anantapur	14.254401	77.953163
11	Upparapalli	Anantapur	Anantapur	14.649817	77.640010
12	Cheemalanagepalli	Bathalapalle	Anantapur	14.515619	77.766665
13	M Cherlopalle	Bathalapalle	Anantapur	14.515619	77.766665
14	Srirangapuram	Bommanahal	Anantapur	17.092913	79.904577
15	Sugepalli	Brahmasamudram	Anantapur	14.527064	77.024464
16	Reddivaripalle thanda	Bukkapatnam	Anantapur	14.200208	77.800987
17	Rasimpalli	Bukkapatnam	Anantapur	14.200208	77.800987
18	Madire Bailu thanda	Bukkapatnam	Anantapur	14.200208	77.800987
19	Yarlam Palle	Bukkapatnam	Anantapur	14.200208	77.800987
20	K K Agraharam	Bukkarayasamudram	Anantapur	14.254401	77.953163
21	CHENNAMPALLI	Chenne Kothapalle	Anantapur	13.599939	79.542781
22	Hariyancheruvu	Chenne Kothapalle	Anantapur	14.234584	77.831010
23	VenuGopalapuram	Bukkapatnam	Anantapur	18.138143	83.401639
24	BASINEPALLE	Chenne Kothapalle	Anantapur	15.161629	77.602057
25	Korlakunta	Chilamathur	Anantapur	13.827005	77.629628
26	Seetharampalli	Dharmavaram	Anantapur	14.413745	77.712619
27	Malmeedapalle	Gandlapenta	Anantapur	14.095966	78.271627
28	Poreddivaripalli	Gandlapenta	Anantapur	14.095966	78.271627
29	Eswarapalle	Gooty	Anantapur	15.035518	77.553344
...	...	...	...	...	...
15148	Kund	Jaunpur	Tehri	25.749003	82.698700
15149	Mendu Sindwal Gaon	Bhailgana	Tehri	30.548285	78.824107
15150	Ragar Gaon	Jaunpur	Tehri	30.313041	78.206312
15151	Ghena	Jaunpur	Tehri	30.383278	78.182093
15152	Bhutsi	Jaunpur	Tehri	30.395427	78.206312
15153	Bhuyasari	Jaunpur	Tehri	30.513090	78.189217
15154	Musmola	Kirti Nagar	Tehri	30.321947	78.853835
15155	Banoli Malli	Narendra Nagar	Tehri	30.157783	78.289824
15156	Bansyul	Thauldhar	Tehri	30.507204	78.311672
15157	Talai	Narendra Nagar	Tehri	30.159975	78.290324
15158	Bhandarki	Thauldhar	Tehri	30.496879	78.323056
15159	Kastal	Thauldhar	Tehri	30.373861	78.432481
15160	Lawani	Thauldhar	Tehri	30.515458	78.324479
15161	Malogi	Thauldhar	Tehri	30.496107	78.314518
15162	Manjhkot	Thauldhar	Tehri	30.451710	78.325902
15163	Manj Kot	Thauldhar	Tehri	30.502814	78.325902
15164	Sainsari	Thauldhar	Tehri	30.520615	78.334438
15165	Nawa Gaon	Thauldhar	Tehri	30.373861	78.432481
15166	Bangeli	Bhatwari	Uttarkashi	30.818273	78.618594
15167	-	Mori	Uttarkashi	31.018785	78.047362
15168	Nisari	Naugaon	Uttarkashi	30.789213	78.140765
15169	Dangur Gaon	Naugaon	Uttarkashi	30.789213	78.140765
15170	Pindki Madesh	Naugaon	Uttarkashi	30.926621	78.421190
15171	Pali	Naugaon	Uttarkashi	30.789213	78.140765
15172	Bhansari	Naugaon	Uttarkashi	30.789213	78.140765
15173	Syalna	Naugaon	Uttarkashi	30.789213	78.140765
15174	Bachar Gaon	Naugaon	Uttarkashi	30.789213	78.140765
15175	Thali	Naugaon	Uttarkashi	30.789213	78.140765
15176	Dokhariyani	Purola	Uttarkashi	30.938439	78.163569
15177	Syaluka	Purola	Uttarkashi	30.943865	78.176394

	index	Block	CD Work Cost	Completed Length	District	Expenditure Till Date	Habitation Name	LSB Cost	LSB State Cost	Length	...	State	Surface Type	Total Cost	Upgrade / New	View	financial_year	index_value	latitude	longitude	geometry
0	11	Anantapur	0.00	1.50	Anantapur	13.20	Mannila	0.00	0.0	1.500	...	Andhra Pradesh	Gravel	11.94	Upgradation	-	2000	1	14.561644	77.688387	POINT (77.68838653475555 14.56164408555297)
1	12	Anantapur	0.00	3.00	Anantapur	29.17	Kodimi	0.00	0.0	3.000	...	Andhra Pradesh	Gravel	29.17	Upgradation	-	2000	2	14.709472	77.548963	POINT (77.54896328830161 14.70947219647509)
2	16	Bommanahal	0.00	4.20	Anantapur	22.01	Singanahalli	0.00	0.0	4.500	...	Andhra Pradesh	WBM	21.50	Upgradation	-	2000	0	14.901521	77.010968	POINT (77.01096773268756 14.9015207295848)
3	19	Bukkapatnam	0.00	4.40	Anantapur	34.77	Kothakota	0.00	0.0	4.400	...	Andhra Pradesh	WBM	25.00	Upgradation	-	2000	0	14.240095	77.940510	POINT (77.94051003532134 14.24009473898244)
4	24	Bukkapatnam	0.00	3.40	Anantapur	25.01	Krishnapuram	0.00	0.0	3.400	...	Andhra Pradesh	Gravel	25.00	Upgradation	-	2000	5	14.345388	77.911692	POINT (77.91169236128114 14.34538768551392)
5	27	Chenne Kothapalle	0.00	3.00	Anantapur	10.60	Medapuram	0.00	0.0	3.000	...	Andhra Pradesh	Gravel	10.60	Upgradation	-	2000	0	14.335782	77.713098	POINT (77.7130981910917 14.33578200114229)
6	32	Chilamathur	0.00	4.00	Anantapur	8.01	Kodur	0.00	0.0	4.000	...	Andhra Pradesh	Gravel	15.50	Upgradation	-	2000	1	13.871114	77.729704	POINT (77.72970415278654 13.87111431982821)
7	33	D Hirehal	0.00	5.00	Anantapur	22.01	Lakshmipuram	0.00	0.0	5.000	...	Andhra Pradesh	Gravel	24.00	Upgradation	-	2000	0	14.985333	76.789890	POINT (76.78989025717428 14.98533331017328)
8	34	D Hirehal	0.00	5.00	Anantapur	29.55	Madenahalli	0.00	0.0	4.600	...	Andhra Pradesh	-	33.00	New Connectivity	-	2000	1	14.988287	76.810270	POINT (76.81026968833977 14.98828700795483)
9	35	D Hirehal	0.00	5.00	Anantapur	29.55	Somalapuram	0.00	0.0	4.600	...	Andhra Pradesh	-	33.00	New Connectivity	-	2000	2	14.913011	76.872691	POINT (76.87269127193203 14.91301112588115)
10	36	Dharmavaram	0.00	4.68	Anantapur	29.05	Regatipalle	0.00	0.0	4.800	...	Andhra Pradesh	Gravel	30.89	Upgradation	-	2000	0	14.401817	77.678747	POINT (77.67874726321061 14.40181673560448)
11	42	Gooty	0.00	3.30	Anantapur	46.72	Mamadur	0.00	0.0	3.300	...	Andhra Pradesh	WBM	47.00	Upgradation	-	2000	1	15.048776	77.587042	POINT (77.58704177365752 15.04877587115779)
12	52	Hindupur	0.00	1.00	Anantapur	4.01	Thumukunta	0.00	0.0	1.000	...	Andhra Pradesh	Gravel	6.00	Upgradation	-	2000	1	13.718834	77.487757	POINT (77.48775716032303 13.71883379352888)
13	57	Kadiri	0.00	1.20	Anantapur	12.01	Patnam	0.00	0.0	1.200	...	Andhra Pradesh	WBM	18.00	Upgradation	-	2000	2	14.234594	78.094893	POINT (78.09489348136057 14.23459373264753)
14	59	Kanaganapalle	0.00	1.00	Anantapur	3.00	Narasampalle	0.00	0.0	1.000	...	Andhra Pradesh	WBM	3.00	Upgradation	-	2000	1	14.421211	77.432635	POINT (77.4326351726435 14.42121080211772)
15	62	Kanaganapalle	0.00	1.00	Anantapur	3.00	Thogarakunta	0.00	0.0	1.000	...	Andhra Pradesh	WBM	3.00	Upgradation	-	2000	4	14.489019	77.460447	POINT (77.46044696353421 14.4890193301411)
16	63	Kanaganapalle	0.00	1.00	Anantapur	3.00	Thumucherla	0.00	0.0	1.000	...	Andhra Pradesh	WBM	3.00	Upgradation	-	2000	5	14.534511	77.450832	POINT (77.45083236691349 14.53451108464911)
17	65	Kudair	0.00	2.20	Anantapur	24.00	Kammuru	0.00	0.0	2.200	...	Andhra Pradesh	WBM	25.69	Upgradation	-	2000	0	14.745821	77.483648	POINT (77.48364782334406 14.74582146469184)
18	67	Lepakshi	0.00	1.60	Anantapur	7.01	Mydugolam	0.00	0.0	1.600	...	Andhra Pradesh	Gravel	7.00	Upgradation	-	2000	0	13.742150	77.626589	POINT (77.62658886526411 13.74214952362404)
19	69	Lepakshi	0.00	3.50	Anantapur	14.21	Kondur	0.00	0.0	3.500	...	Andhra Pradesh	Gravel	22.60	Upgradation	-	2000	2	13.850544	77.609664	POINT (77.60966372406398 13.85054394580163)
20	77	Nallacheruvu	0.00	4.00	Anantapur	33.29	Kadiripulakunta	0.00	0.0	4.000	...	Andhra Pradesh	WBM	29.50	Upgradation	-	2000	0	13.988648	78.158101	POINT (78.15810057249854 13.98864773019608)
21	80	Obuladevaracheruvu	0.00	1.00	Anantapur	33.00	Inagalur	0.00	0.0	1.000	...	Andhra Pradesh	Gravel	30.00	Upgradation	-	2000	0	14.045617	78.039584	POINT (78.0395840422307 14.04561740590086)
22	81	Pamidi	0.00	1.40	Anantapur	11.71	Vankarajukalva	0.00	0.0	1.500	...	Andhra Pradesh	WBM	12.00	Upgradation	-	2000	0	14.919690	77.548650	POINT (77.54864976638596 14.9196900100473)
23	84	Parigi	0.00	1.00	Anantapur	8.01	Moda	0.00	0.0	1.000	...	Andhra Pradesh	WBM	13.00	Upgradation	-	2000	2	13.825899	77.441698	POINT (77.44169758204558 13.82589945833578)
24	88	Parigi	0.00	1.60	Anantapur	6.01	Vittapalle	0.00	0.0	1.600	...	Andhra Pradesh	Gravel	8.00	Upgradation	-	2000	6	13.939104	77.463259	POINT (77.46325934255039 13.93910440571377)
25	90	Peddavadugur	0.00	2.00	Anantapur	12.00	Ravuludiki	0.00	0.0	2.000	...	Andhra Pradesh	Gravel	12.00	Upgradation	-	2000	0	15.008336	77.795869	POINT (77.79586904132056 15.0083363169456)
26	92	Penu Konda	0.00	1.10	Anantapur	10.59	Nagalur	0.00	0.0	1.100	...	Andhra Pradesh	WBM	10.60	Upgradation	-	2000	1	14.010949	77.519747	POINT (77.5197470344648 14.01094937977668)
27	93	Ramagiri	0.00	2.20	Anantapur	12.94	Nasanakota	0.00	0.0	2.200	...	Andhra Pradesh	WBM	13.10	Upgradation	-	2000	0	14.353947	77.445027	POINT (77.44502742480142 14.35394697408207)
28	96	Ramagiri	0.00	1.00	Anantapur	11.00	Polepalle	0.00	0.0	1.000	...	Andhra Pradesh	Gravel	11.70	Upgradation	-	2000	3	14.303884	77.558249	POINT (77.558248752982 14.3038836272379)
29	99	Raptadu	0.00	1.00	Anantapur	11.99	Hampapuram	0.00	0.0	1.000	...	Andhra Pradesh	WBM	11.99	Upgradation	-	2000	0	14.557943	77.639533	POINT (77.63953305850227 14.55794329825276)
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
339156	276163	Jaunpur	221.15	0.00	Tehri	0.00	Kund	0.00	0.0	8.125	...	Uttarakhand	-	497.91	New Connectivity	-	2018	0	25.749003	82.698700	POINT (82.69870019999998 25.7490034)
339157	276164	Jaunpur	301.56	0.00	Tehri	0.00	Ragar Gaon	0.00	0.0	15.675	...	Uttarakhand	-	985.51	New Connectivity	-	2018	1	30.313041	78.206312	POINT (78.20631230000001 30.31304089999999)
339158	276165	Jaunpur	77.45	0.00	Tehri	0.00	Ghena	0.00	0.0	3.325	...	Uttarakhand	-	197.91	New Connectivity	-	2018	2	30.383278	78.182093	POINT (78.1820931 30.3832778)
339159	276166	Jaunpur	183.58	0.00	Tehri	0.00	Bhutsi	0.00	0.0	7.550	...	Uttarakhand	-	453.54	New Connectivity	-	2018	3	30.395427	78.206312	POINT (78.20631230000001 30.395427)
339160	276167	Jaunpur	184.59	0.00	Tehri	0.00	Bhuyasari	0.00	0.0	8.450	...	Uttarakhand	-	545.36	New Connectivity	-	2018	6	30.513090	78.189217	POINT (78.189217 30.5130904)
339161	276168	Kirti Nagar	102.63	0.00	Tehri	0.00	Musmola	0.00	0.0	5.400	...	Uttarakhand	-	456.48	New Connectivity	-	2018	1	30.321947	78.853835	POINT (78.8538353 30.3219475)
339162	276169	Narendra Nagar	241.77	0.00	Tehri	0.00	Banoli Malli	0.00	0.0	12.000	...	Uttarakhand	-	761.68	New Connectivity	-	2018	2	30.157783	78.289824	POINT (78.28982350000003 30.1577829)
339163	276170	Narendra Nagar	241.77	0.00	Tehri	0.00	Talai	0.00	0.0	12.000	...	Uttarakhand	-	761.68	New Connectivity	-	2018	3	30.159975	78.290324	POINT (78.29032389999998 30.15997460000001)
339164	276171	Thauldhar	180.90	0.00	Tehri	0.00	Bansyul	0.00	0.0	12.025	...	Uttarakhand	-	935.24	New Connectivity	-	2018	3	30.507204	78.311672	POINT (78.311672 30.5072038)
339165	276172	Thauldhar	180.90	0.00	Tehri	0.00	Bhandarki	0.00	0.0	12.025	...	Uttarakhand	-	935.24	New Connectivity	-	2018	4	30.496879	78.323056	POINT (78.3230559 30.4968794)
339166	276173	Thauldhar	180.90	0.00	Tehri	0.00	Kastal	0.00	0.0	12.025	...	Uttarakhand	-	935.24	New Connectivity	-	2018	6	30.373861	78.432481	POINT (78.4324809 30.3738609)
339167	276174	Thauldhar	180.90	0.00	Tehri	0.00	Lawani	0.00	0.0	12.025	...	Uttarakhand	-	935.24	New Connectivity	-	2018	7	30.515458	78.324479	POINT (78.32447879999999 30.5154577)
339168	276175	Thauldhar	180.90	0.00	Tehri	0.00	Malogi	0.00	0.0	12.025	...	Uttarakhand	-	935.24	New Connectivity	-	2018	8	30.496107	78.314518	POINT (78.3145181 30.49610749999999)
339169	276176	Thauldhar	180.90	0.00	Tehri	0.00	Manj Kot	0.00	0.0	12.025	...	Uttarakhand	-	935.24	New Connectivity	-	2018	9	30.502814	78.325902	POINT (78.32590159999999 30.5028137)
339170	276177	Thauldhar	180.90	0.00	Tehri	0.00	Manjhkot	0.00	0.0	12.025	...	Uttarakhand	-	935.24	New Connectivity	-	2018	10	30.451710	78.325902	POINT (78.32590159999999 30.4517105)
339171	276178	Thauldhar	72.73	0.00	Tehri	0.00	Nawa Gaon	0.00	0.0	6.250	...	Uttarakhand	-	391.41	New Connectivity	-	2018	14	30.373861	78.432481	POINT (78.4324809 30.3738609)
339172	276179	Thauldhar	180.90	0.00	Tehri	0.00	Sainsari	0.00	0.0	12.025	...	Uttarakhand	-	935.24	New Connectivity	-	2018	15	30.520615	78.334438	POINT (78.33443849999998 30.520615)
339173	276180	Bhatwari	21.09	0.00	Uttarkashi	0.00	Bangeli	0.00	0.0	2.300	...	Uttarakhand	-	161.44	New Connectivity	-	2018	2	30.818273	78.618594	POINT (78.6185941 30.818273)
339174	276181	Mori	0.00	0.00	Uttarkashi	0.00	-	345.25	0.0	0.000	...	Uttarakhand	-	345.25	New Connectivity	-	2018	1	31.018785	78.047362	POINT (78.04736170000001 31.0187848)
339175	276182	Mori	0.00	0.00	Uttarkashi	0.00	-	198.13	0.0	0.000	...	Uttarakhand	-	198.13	New Connectivity	-	2018	2	31.018785	78.047362	POINT (78.04736170000001 31.0187848)
339176	276183	Naugaon	62.88	0.00	Uttarkashi	0.00	Dangur Gaon	0.00	0.0	6.300	...	Uttarakhand	-	380.16	New Connectivity	-	2018	7	30.789213	78.140765	POINT (78.1407651 30.7892129)
339177	276184	Naugaon	44.95	0.00	Uttarkashi	0.00	Nisari	0.00	0.0	9.300	...	Uttarakhand	-	520.77	New Connectivity	-	2018	8	30.789213	78.140765	POINT (78.1407651 30.7892129)
339178	276185	Naugaon	44.95	0.00	Uttarkashi	0.00	Pindki Madesh	0.00	0.0	9.300	...	Uttarakhand	-	520.77	New Connectivity	-	2018	9	30.926621	78.421190	POINT (78.4211897 30.9266205)
339179	276186	Naugaon	47.96	0.00	Uttarkashi	0.00	Pali	0.00	0.0	4.150	...	Uttarakhand	-	278.51	New Connectivity	-	2018	10	30.789213	78.140765	POINT (78.1407651 30.7892129)
339180	276187	Naugaon	177.96	0.00	Uttarkashi	0.00	Bhansari	0.00	0.0	10.400	...	Uttarakhand	-	625.16	New Connectivity	-	2018	11	30.789213	78.140765	POINT (78.1407651 30.7892129)
339181	276188	Naugaon	44.95	0.00	Uttarkashi	0.00	Syalna	0.00	0.0	9.300	...	Uttarakhand	-	520.77	New Connectivity	-	2018	12	30.789213	78.140765	POINT (78.1407651 30.7892129)
339182	276189	Naugaon	155.54	0.00	Uttarkashi	0.00	Thali	0.00	0.0	10.375	...	Uttarakhand	-	623.03	New Connectivity	-	2018	13	30.789213	78.140765	POINT (78.1407651 30.7892129)
339183	276190	Naugaon	50.82	0.00	Uttarkashi	0.00	Bachar Gaon	0.00	0.0	4.300	...	Uttarakhand	-	227.58	New Connectivity	-	2018	14	30.789213	78.140765	POINT (78.1407651 30.7892129)
339184	276191	Purola	189.56	0.00	Uttarkashi	0.00	Dokhariyani	0.00	0.0	7.750	...	Uttarakhand	-	616.96	New Connectivity	-	2018	2	30.938439	78.163569	POINT (78.16356879999999 30.9384392)
339185	276192	Purola	189.56	0.00	Uttarkashi	0.00	Syaluka	0.00	0.0	7.750	...	Uttarakhand	-	616.96	New Connectivity	-	2018	3	30.943865	78.176394	POINT (78.17639369999998 30.94386519999999)

	index	Block	CD Work Cost	Completed Length	District	Expenditure Till Date	Habitation Name	LSB Cost	LSB State Cost	Length	...	OBJECTID	ST_CODE	ST_NAME	DT_CODE	DIST_NAME	AC_NO	AC_NAME	PC_NO	PC_NAME	PC_ID
0	11	Anantapur	0.00	1.500	Anantapur	13.20	Mannila	0.0	0.0	1.500	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
5	27	Chenne Kothapalle	0.00	3.000	Anantapur	10.60	Medapuram	0.0	0.0	3.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
14	59	Kanaganapalle	0.00	1.000	Anantapur	3.00	Narasampalle	0.0	0.0	1.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
15	62	Kanaganapalle	0.00	1.000	Anantapur	3.00	Thogarakunta	0.0	0.0	1.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
16	63	Kanaganapalle	0.00	1.000	Anantapur	3.00	Thumucherla	0.0	0.0	1.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
27	93	Ramagiri	0.00	2.200	Anantapur	12.94	Nasanakota	0.0	0.0	2.200	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
28	96	Ramagiri	0.00	1.000	Anantapur	11.00	Polepalle	0.0	0.0	1.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
29	99	Raptadu	0.00	1.000	Anantapur	11.99	Hampapuram	0.0	0.0	1.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
2910	20180	Anantapur	0.60	0.750	Anantapur	7.72	Chiyyedu	0.0	0.0	0.750	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
24639	124437	Atmakur	5.86	11.200	Anantapur	186.35	Goridindla	0.0	0.0	11.200	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
31625	162546	Chenne Kothapalle	15.21	9.880	Anantapur	285.77	Ganginepalle	0.0	0.0	9.875	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
31626	162547	Chenne Kothapalle	3.84	1.300	Anantapur	39.64	Veldurthi	0.0	0.0	1.300	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
31627	162550	Chenne Kothapalle	7.60	2.400	Anantapur	67.02	POLETIPALLE	0.0	0.0	2.400	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
31655	162703	Ramagiri	21.30	3.250	Anantapur	101.64	Ganthimarri	0.0	0.0	3.250	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
31656	162706	Ramagiri	11.55	2.000	Anantapur	58.98	SESHADRIBHATRA HALLI	0.0	0.0	2.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
63004	11	Anantapur	0.00	5.000	Anantapur	35.10	Upparapalli	0.0	0.0	5.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
63005	12	Anantapur	0.00	2.200	Anantapur	17.99	Kamarupalli	0.0	0.0	2.200	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
63040	47	Kanaganapalle	0.00	3.000	Anantapur	10.00	Bhadrapuram	0.0	0.0	3.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
63041	48	Kanaganapalle	0.00	1.000	Anantapur	4.09	Vepakunta	0.0	0.0	1.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
63042	49	Kanaganapalle	0.00	1.000	Anantapur	3.00	C N KOTA	0.0	0.0	1.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
63058	65	Parigi	0.00	1.000	Anantapur	11.51	Kaluvapalli	0.0	0.0	1.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
63060	67	Parigi	0.00	1.800	Anantapur	7.01	M Cherlopalle	0.0	0.0	1.800	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
63061	68	Peddapappur	0.00	3.300	Anantapur	43.99	J Kothapalli	0.0	0.0	3.300	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
63063	70	Ramagiri	0.00	1.000	Anantapur	11.00	Venkatapuram	0.0	0.0	1.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
63065	72	Ramagiri	0.00	2.000	Anantapur	4.55	-	0.0	0.0	2.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
63066	73	Ramagiri	0.00	1.000	Anantapur	21.99	PENUBOLU	0.0	0.0	1.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
63073	80	Tadimarri	0.00	1.800	Anantapur	13.01	Maddalacheruvu	0.0	0.0	2.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
84952	21959	Lepakshi	0.00	3.000	Anantapur	38.01	Upparapalli	0.0	0.0	3.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
84974	21981	Ramagiri	1.00	3.200	Anantapur	32.28	Kangalakunta	0.0	0.0	3.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
84976	21983	Raptadu	0.00	2.000	Anantapur	21.13	AYYAVARI PALLE	0.0	0.0	2.000	...	37	28	ANDHRA PRADESH	22	ANANTAPUR	274	Raptadu	37	HINDUPUR	2837
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
329784	266791	Samulamlan T.D.Block	218.18	2.000	Churachandpur	0.00	Khodang	0.0	0.0	13.830	...	2	14	MANIPUR	3	CHURACHANDPUR	58	Churachandpur	2	OUTER MANIPUR	1402
329785	266792	Samulamlan T.D.Block	0.00	0.000	Churachandpur	0.00	Khodang	0.0	0.0	13.830	...	2	14	MANIPUR	3	CHURACHANDPUR	58	Churachandpur	2	OUTER MANIPUR	1402
329786	266793	Samulamlan T.D.Block	218.18	2.000	Churachandpur	0.00	Leisen Tampak	0.0	0.0	13.830	...	2	14	MANIPUR	3	CHURACHANDPUR	58	Churachandpur	2	OUTER MANIPUR	1402
329787	266794	Samulamlan T.D.Block	0.00	0.000	Churachandpur	0.00	Leisen Tampak	0.0	0.0	13.830	...	2	14	MANIPUR	3	CHURACHANDPUR	58	Churachandpur	2	OUTER MANIPUR	1402
329788	266795	Samulamlan T.D.Block	223.96	0.000	Churachandpur	0.00	Dampi	0.0	0.0	15.760	...	2	14	MANIPUR	3	CHURACHANDPUR	58	Churachandpur	2	OUTER MANIPUR	1402
329789	266796	Samulamlan T.D.Block	218.18	2.000	Churachandpur	0.00	Maojang	0.0	0.0	13.830	...	2	14	MANIPUR	3	CHURACHANDPUR	58	Churachandpur	2	OUTER MANIPUR	1402
329790	266797	Samulamlan T.D.Block	218.18	2.000	Churachandpur	0.00	Tuiring Phaisen	0.0	0.0	13.830	...	2	14	MANIPUR	3	CHURACHANDPUR	58	Churachandpur	2	OUTER MANIPUR	1402
338604	275611	Samulamlan T.D.Block	58.19	0.000	Churachandpur	0.00	Haotak Khullen	0.0	0.0	8.000	...	2	14	MANIPUR	3	CHURACHANDPUR	58	Churachandpur	2	OUTER MANIPUR	1402
338605	275612	Samulamlan T.D.Block	0.00	0.000	Churachandpur	0.00	Haotak Phailen	0.0	0.0	13.830	...	2	14	MANIPUR	3	CHURACHANDPUR	58	Churachandpur	2	OUTER MANIPUR	1402