loop this over all CSVs in data/ folder
Edit: timestamps put on reports etc, so outputs of different runs can be compared.
import json
import os
# import time, datetime
import pandas as pd
from collections import OrderedDict
from math import sin, cos, sqrt, atan2, radians
import datetime
doneFolder = 'done/'
dataFolder = 'data/'
reportFolder = 'reports/'
reportFile = 'report_bulk_mapping'
timestamp = '{:%Y-%m-%d-%H%M}'.format(datetime.datetime.now())
timestamp
'2018-11-02-0826'
sanityDistance = 7
# in kms, the distance beyond which the stop has gone too far from its neighbors
dataFiles = [f for f in os.listdir(dataFolder) if f.lower().endswith('.csv') and os.path.isfile(os.path.join(dataFolder, f))]
doneFiles = [f for f in os.listdir(doneFolder) if f.lower().endswith('.csv') and os.path.isfile(os.path.join(doneFolder, f))]
dataFiles.sort()
doneFiles.sort()
print('doneFiles:',doneFiles,'\n\ndataFiles:',dataFiles,)
doneFiles: ['120M.csv', '18B.csv', '195J.csv', '19M.csv', '218D.csv', '219.csv', '225.csv', '227B.csv', '229.csv', '22T.csv', '242G.csv', '3JJ.csv'] dataFiles: ['1.csv', '10.csv', '100.csv', '100A.csv', '100C.csv', '100D_V.csv', '100G.csv', '100H.csv', '100J.csv', '100K.csv', '100L.csv', '100M.csv', '100N.csv', '100R.csv', '100T.csv', '100V.csv', '101B.csv', '101K.csv', '101R.csv', '101S.csv', '102.csv', '102A.csv', '102B_218L.csv', '102C.csv', '102CJ.csv', '102D.csv', '102F.csv', '102H.csv', '102K.csv', '102N.csv', '102P.csv', '102S.csv', '102W.csv', '103.csv', '104A.csv', '104G.csv', '104R.csv', '104S.csv', '104T.csv', '105.csv', '105M.csv', '105S.csv', '107.csv', '107B.csv', '107G.csv', '107H.csv', '107J.csv', '107K.csv', '107KV.csv', '107M.csv', '107P.csv', '107S.csv', '107T.csv', '107V.csv', '107VR.csv', '107V_P.csv', '108S.csv', '10A_7S.csv', '10B.csv', '10F.csv', '10H.csv', '10H_17H.csv', '10H_219.csv', '10H_224.csv', '10H_250C.csv', '10H_25I.csv', '10H_25S.csv', '10H_W.csv', '10KB.csv', '10KM.csv', '10K_J.csv', '10L.csv', '10N.csv', '10R.csv', '10U.csv', '10W.csv', '10Y.csv', '10YF.csv', '10Z.csv', '11.csv', '113A.csv', '113B.csv', '113C.csv', '113EL.csv', '113I_V.csv', '113K.csv', '113KJ.csv', '113KY.csv', '113K_J-2.csv', '113K_J.csv', '113K_L-1.csv', '113K_L.csv', '113M.csv', '113M_216.csv', '113M_288.csv', '113M_K.csv', '113M_W.csv', '113S.csv', '113Y.csv', '113_288.csv', '113f.csv', '114.csv', '115.csv', '115C.csv', '115M-1.csv', '115M-2.csv', '115M.csv', '115V.csv', '116.csv', '116N.csv', '116T.csv', '117.csv', '118.csv', '118D_W.csv', '118T.csv', '118W.csv', '119.csv', '12.csv', '120M.csv', '123.csv', '126M.csv', '126_300.csv', '126_300H.csv', '127.csv', '127F.csv', '127HJ.csv', '127J.csv', '127K.csv', '127KH.csv', '127K_S.csv', '127K_V.csv', '127LH.csv', '127LK.csv', '127N.csv', '127T.csv', '127VB.csv', '131.csv', '135.csv', '136.csv', '136B.csv', '136H.csv', '136L.csv', '136N.csv', '136S.csv', '137.csv', '139.csv', '14.csv', '141.csv', '142K.csv', '142S.csv', '143.csv', '143A.csv', '147.csv', '147W.csv', '14P.csv', '15.csv', '152.csv', '152G.csv', '153.csv', '156.csv', '156B.csv', '156H.csv', '156L.csv', '156LM.csv', '156L_216G.csv', '156V.csv', '156V_118W.csv', '156_204U.csv', '156_216.csv', '156_216G.csv', '156_216L.csv', '156_288H.csv', '156_299.csv', '158.csv', '158D_L.csv', '158F.csv', '158FB.csv', '158FV.csv', '158F_299.csv', '158J.csv', '158JA.csv', '158J_272G.csv', '158J_D.csv', '158L.csv', '158M.csv', '158N.csv', '158S.csv', '158V.csv', '158V_J.csv', '158_277D.csv', '158_299.csv', '15H.csv', '16A.csv', '16A_219.csv', '16A_226L.csv', '16A_47LI.csv', '16A_49M-1.csv', '16A_49M.csv', '16A_5K.csv', '16C.csv', '16M.csv', '16P.csv', '16R.csv', '16T.csv', '17.csv', '171.csv', '171C.csv', '171K.csv', '171M.csv', '176.csv', '178.csv', '178R.csv', '178V.csv', '17HN.csv', '17HN_47LI.csv', '17H_10HEC.csv', '17H_10W.csv', '17H_219.csv', '17H_47LI.csv', '18.csv', '183.csv', '183AJ.csv', '183B.csv', '185.csv', '185N.csv', '185S.csv', '186.csv', '186L.csv', '187.csv', '187D.csv', '187DM.csv', '187DV.csv', '187D_L-2.csv', '187D_L.csv', '187HJ.csv', '187J.csv', '187JL.csv', '187P.csv', '187_205F.csv', '187_224.csv', '188H.csv', '189M.csv', '189M_92A.csv', '189M_A.csv', '189R.csv', '18B.csv', '18C.csv', '18R.csv', '18V.csv', '18_219.csv', '18_30.csv', '190AG.csv', '190RK.csv', '195.csv', '195D.csv', '195E.csv', '195J.csv', '195W.csv', '198.csv', '19F.csv', '19F_A.csv', '19K.csv', '19M.csv', '19M_224.csv', '19_224.csv', '1B.csv', '1DS.csv', '1D_277D.csv', '1D_V.csv', '1J.csv', '1K.csv', '1P.csv', '1V.csv', '2.csv', '201.csv', '201G.csv', '201K.csv', '201M.csv', '202.csv', '202M.csv', '202T.csv', '203K.csv', '203N.csv', '204.csv', '204K.csv', '204N.csv', '204P.csv', '204S.csv', '205.csv', '205A.csv', '205B.csv', '205F.csv', '205K.csv', '205M.csv', '206.csv', '207.csv', '208.csv', '208C.csv', '208R.csv', '209.csv', '21.csv', '211.csv', '211A.csv', '211B.csv', '211C.csv', '211D.csv', '211E.csv', '211J.csv', '211K.csv', '211M.csv', '211P.csv', '211R.csv', '211S.csv', '211T.csv', '211U.csv', '216A.csv', '216D_L.csv', '216KL.csv', '216L.csv', '216L_W.csv', '216M.csv', '216MI.csv', '216U.csv', '217.csv', '217A.csv', '217C.csv', '217D.csv', '217D_A.csv', '217D_L.csv', '217M.csv', '217X.csv', '218.csv', '218C.csv', '218D.csv', '218D_L.csv', '218HG.csv', '218L.csv', '218L_V.csv', '218_19M.csv', '219.csv', '219_229.csv', '21B.csv', '21W.csv', '21W_107J.csv', '21W_2017J.csv', '21_107J.csv', '220V.csv', '222A.csv', '222L.csv', '222P.csv', '223A.csv', '223G.csv', '223J.csv', '223JG.csv', '223R.csv', '223S.csv', '224G.csv', '224H.csv', '224K.csv', '224S.csv', '224_113K.csv', '224_187D_V.csv', '224_205F.csv', '224_226.csv', '225.csv', '225A.csv', '225C.csv', '225D.csv', '225HP.csv', '225L_299.csv', '225L_V.csv', '225M.csv', '225S.csv', '226.csv', '226A.csv', '226C.csv', '226E.csv', '226L_229.csv', '226M.csv', '227.csv', '227B.csv', '228.csv', '229.csv', '229B.csv', '229D.csv', '229G.csv', '229M.csv', '229R.csv', '229T.csv', '229V.csv', '229X.csv', '22D.csv', '22K.csv', '22M.csv', '22S.csv', '22T.csv', '22_219L.csv', '23.csv', '230A.csv', '230D.csv', '230G.csv', '230N.csv', '230P.csv', '230V.csv', '230X.csv', '231.csv', '231B.csv', '233.csv', '234.csv', '235G.csv', '236.csv', '23B.csv', '24.csv', '241T.csv', '242.csv', '242A.csv', '242B.csv', '242G.csv', '245.csv', '245A.csv', '245J.csv', '24B.csv', '24E.csv', '250H.csv', '250P.csv', '250S.csv', '251.csv', '251A.csv', '251B.csv', '251J.csv', '251K.csv', '251L.csv', '251M.csv', '251N.csv', '251S.csv', '252.csv', '252D.csv', '252H.csv', '252N.csv', '253G.csv', '253H.csv', '253M.csv', '254.csv', '254M.csv', '25B.csv', '25J.csv', '25S.csv', '25S_90L.csv', '26.csv', '26D.csv', '26M.csv', '26N.csv', '272.csv', '272C.csv', '272K.csv', '272M.csv', '272S.csv', '277.csv', '277B.csv', '277D.csv', '277I.csv', '277K.csv', '277M.csv', '277N.csv', '277P.csv', '277U.csv', '277W.csv', '277Y.csv', '278.csv', '279.csv', '28.csv', '280.csv', '280B.csv', '280C.csv', '280E.csv', '280N.csv', '280R.csv', '280S.csv', '280T.csv', '281P.csv', '283.csv', '283A.csv', '283D.csv', '283K.csv', '283N.csv', '283P.csv', '283S.csv', '283T.csv', '284P.csv', '284S.csv', '287N.csv', '288A.csv', '288B.csv', '288C.csv', '288D.csv', '288H.csv', '288K.csv', '288N.csv', '288P.csv', '288R.csv', '288S.csv', '288X.csv', '288Y.csv', '288Z.csv', '289M.csv', '29.csv', '290A.csv', '290B.csv', '290F.csv', '290J.csv', '290K.csv', '290Q.csv', '290S.csv', '290T.csv', '292.csv', '293.csv', '293S.csv', '293T.csv', '298.csv', '299.csv', '299A.csv', '299C.csv', '299D.csv', '299H.csv', '299M.csv', '299P.csv', '299S.csv', '29B.csv', '29C.csv', '29H.csv', '29Q.csv', '29R.csv', '29R_272.csv', '29S.csv', '2C.csv', '2D.csv', '2F.csv', '2U.csv', '2V.csv', '2Z.csv', '3.csv', '30.csv', '300.csv', '300H.csv', '30A.csv', '30C.csv', '30M.csv', '30S.csv', '31.csv', '31A.csv', '31H.csv', '31L.csv', '31M.csv', '31P.csv', '31V.csv', '33S.csv', '35.csv', '36K.csv', '37.csv', '37B.csv', '37D.csv', '37E.csv', '37H.csv', '37N.csv', '37S.csv', '38.csv', '38A.csv', '38E.csv', '38EX.csv', '38S_47V.csv', '38X.csv', '3A.csv', '3B.csv', '3C.csv', '3D.csv', '3E.csv', '3G.csv', '3H.csv', '3HN.csv', '3JJ.csv', '3K.csv', '3KJ.csv', '3KN.csv', '3M.csv', '3N.csv', '3P.csv', '3R.csv', '3S.csv', '3SS.csv', '3Y.csv', '3Z.csv', '4.csv', '40.csv', '401.csv', '40D.csv', '40E.csv', '40N.csv', '40T.csv', '40V.csv', '41.csv', '41C.csv', '41K.csv', '41N.csv', '42.csv', '43.csv', '44L.csv', '44X.csv', '45.csv', '45A.csv', '45G.csv', '45HK.csv', '45J.csv', '46P.csv', '47C.csv', '47F.csv', '47K.csv', '47S.csv', '47Y_90D.csv', '47Y_90U.csv', '48.csv', '49.csv', '49A.csv', '49E.csv', '49J.csv', '49K.csv', '49L.csv', '49M.csv', '49M_250.csv', '49N.csv', '49P.csv', '49V.csv', '49WI.csv', '49_250M.csv', '4SY.csv', '5.csv', '508.csv', '51.csv', '56G.csv', '57S.csv', '589.csv', '5B.csv', '5BL.csv', '5C.csv', '5GP.csv', '5K.csv', '5K_16A.csv', '5K_92.csv', '5L.csv', '5M.csv', '5P.csv', '5R.csv', '5SD.csv', '5T.csv', '60.csv', '601.csv', '63B.csv', '63M.csv', '63S.csv', '649.csv', '65.csv', '65A.csv', '65M.csv', '65S.csv', '66G.csv', '67L.csv', '6B.csv', '6C.csv', '6H.csv', '6H_216G.csv', '6J.csv', '6K.csv', '6M.csv', '6S.csv', '6T.csv', '71A.csv', '72J.csv', '72L.csv', '73.csv', '74.csv', '75R.csv', '7C.csv', '7H.csv', '7I.csv', '7M.csv', '7V.csv', '7X.csv', '801.csv', '83J_230.csv', '83J_272G.csv', '83K.csv', '84.csv', '84S.csv', '85B.csv', '85H.csv', '86.csv', '861.csv', '86J.csv', '86K.csv', '86V.csv', '8C.csv', '8M.csv', '8R.csv', '9.csv', '90K.csv', '90L.csv', '90L_226.csv', '90L_300.csv', '90M.csv', '90R.csv', '90V.csv', '90d.csv', '92.csv', '92X.csv', '94H.csv', '94K.csv', '94L.csv', '94U.csv', '95.csv', '95A.csv', '95K.csv', '95KD.csv', '95M.csv', '95P.csv', '95R.csv', '96N.csv', '98.csv', '99.csv', '99M.csv', '9A.csv', '9C.csv', '9D.csv', '9F.csv', '9K.csv', '9K_272G.csv', '9K_283K.csv', '9M-1.csv', '9M.csv', '9Q.csv', '9R.csv', '9V.csv', '9X.csv', '9X_171M.csv', '9X_272G.csv', '9X_283D.csv', '9Y.csv', '9YF.csv', 'Sec-Airport.csv']
# for stops databank name matching
databankFolder = 'databank/'
configFile = 'config.json'
with open(configFile) as f:
configDict = json.load(f)
databank = configDict.get('databank', 'hydstopsGoogle3.csv')
print(databank)
dfBank = pd.read_csv(databankFolder+databank, dtype=str).fillna('')
stops-geolocated-combined-5sources.csv
# dfBank.sample(10)
for file in doneFiles:
try:
os.remove(dataFolder + file)
print('removing {}{}'.format(dataFolder,file))
except OSError:
pass
dataFiles = [ x for x in dataFiles if x not in doneFiles]
removing data/120M.csv removing data/18B.csv removing data/195J.csv removing data/19M.csv removing data/218D.csv removing data/219.csv removing data/225.csv removing data/227B.csv removing data/229.csv removing data/22T.csv removing data/242G.csv removing data/3JJ.csv
'#'*100
'####################################################################################################'
zapper = lambda x: ''.join(e.lower() for e in x if e.isalnum()).replace('busstop','')
#test it:
zapper('Metta Guda Bus Stop')
'mettaguda'
# imported from static gtfs manager
def lat_long_dist(lat1,lon1,lat2,lon2):
# function for calculating ground distance between two lat-long locations
R = 6373.0 # approximate radius of earth in km.
lat1 = radians( float(lat1) )
lon1 = radians( float(lon1) )
lat2 = radians( float(lat2) )
lon2 = radians( float(lon2) )
dlon = lon2 - lon1
dlat = lat2 - lat1
a = sin(dlat / 2)**2 + cos(lat1) * cos(lat2) * sin(dlon / 2)**2
c = 2 * atan2(sqrt(a), sqrt(1 - a))
distance = float(format( R * c , '.2f' )) #rounding. From https://stackoverflow.com/a/28142318/4355695
return distance
# test:
lat_long_dist(17.82149,78.331,17.34932,78.54818)
57.35
# brought in from fuzzymapper
def mapExactFunc(df,dfBank,\
matchColumns=['stop_name','stop_name'],
checkFilled = ['stop_lat','stop_lon'],
# copyColumns=['stop_lat','stop_lon','stop_id:source_stop_id','source','stop_name:source_stop_name','stop_desc'] ):
# copyColumns=['stop_lat','stop_lon','source','stop_name:source_stop_name','stop_desc'] ):
copyColumns=['source','stop_id:source_stop_id','stop_name:source_stop_name','stop_desc'] ):
'''
Function for bulk mapping from data bank if there are identical matches
plan:
- convert df to list-of-dicts (records)
- loop through each dict
- process record if it hasn't been mapped yet (lat, long empty)
- check if name is there in databank. take first match if multiple.
- copy over copyColumns, and use source:destination to rename the copied column
- return list of dicts
to do:
- sanity check: try next match if this one's lat longs are too far away.
'''
df['zapped'] = df[matchColumns[0] ].apply( zapper )
dfBank['zapped'] = dfBank[matchColumns[1] ].apply( zapper )
arr = df.to_dict(orient='records', into=OrderedDict)
# print('arr:',len(arr))
count = 0
foundList = []
for i,row in enumerate(arr):
# process only those rows that do NOT have lat,lon already mapped
if not (row.get('stop_lat',None) and row.get('stop_lon',None) ):
matches = dfBank[ dfBank['zapped'] == row['zapped'] ]
# print(matches.stop_name.tolist())
if len(matches):
row['stop_lat'] = matches.iloc[0]['stop_lat']
row['stop_lon'] = matches.iloc[0]['stop_lon']
# copying remaining metadata
for col in copyColumns:
# check if it's one column name identical in both tables, or a source:destination pair
if ':' in col:
source,destination = col.split(':')
row[destination] = matches.iloc[0][source]
else:
row[col] = matches.iloc[0][col] # take the first match only
count +=1
foundList.append(row[matchColumns[0]])
row.pop('zapped',None) # was going to get rid of this, but decided to keep it.
print('mapExactFunc: Databank matches found for {} names.'.format(count) )
#print(foundList)
return arr, count
a = b = 0
print(a,b)
0 0
def sanityCheck(data):
'''
Sanity Check : drop mapped points in a route that are too far from previous and next points
- do separately for the directions
- if stop is first in sequence, check distance to next two stops
- if stop is middle, check distance to preceding and next stop
- if stop is last in sequence, check distance to preceding two stops
- this first-last business is only for the stops that have been mapped
'''
previousDeleted = 0
count = 0
# first pass: getting the positions of the mapped stops
for direction in [0,1]:
mapped = [[],[]]
for i,row in enumerate(data):
if str(row['direction']) == str(direction):
if ( row.get('stop_lat','') != '' ) and ( row.get('stop_lon','') != '' ):
mapped[direction].append(i)
# print('direction: {}, mapped: {}'.format(direction,mapped[direction]))
if len(mapped[direction]) < 3:
# no point.. we can't do any GIS for a track with less than 3 points
continue
previousDeleted = 0
count = 0
for n,pos in enumerate(mapped[direction]):
lat = float(data[pos]['stop_lat'])
lon = float(data[pos]['stop_lon'])
'''
2.11.18: commenting this out and switching to a simpler strategy:
don't mess with stops that are the first or last ones in a chain. #leaveThemAlone
if n == 0 or ( previousDeleted>0 and n==1):
# if first, or net first, then compare with just the next point.
offset1 = 1
# offset2 = 2
dist2 = sanityDistance + 1 # take second distance as too far by default so it passes the AND
# 2.11.18: decision: let's not mess with the first and last mapped stops. Too much headache.
dist1 = dist2 = 0
elif n == len(mapped[direction])-1:
# if last, then compare with just the previous point
offset1 = -1 - previousDeleted
# example: if last 3 points were deleted, then the offset will be -4.
#So, skip points that have been deleted
dist2 = sanityDistance + 1 # take second distance as too far by default so it passes the AND
# 2.11.18: decision: let's not mess with the first and last mapped stops. Too much headache.
dist1 = dist2 = 0dist1 = dist2 = 0
else:
# normal : take a mapped stop before and one after
offset2 = 1
offset1 = -1 - previousDeleted
# 1 next 1 previous. But if the previous point has been deleted, take the one before it
lat2 = float( data[ mapped[direction][n+offset2] ]['stop_lat'])
lon2 = float( data[ mapped[direction][n+offset2] ]['stop_lon'])
dist2 = lat_long_dist(lat,lon,lat2,lon2)
# common to all cases: dist1
lat1 = float( data[ mapped[direction][n+offset1] ]['stop_lat'])
# print( n, offset2, data[ mapped[direction][n+offset2] ]['stop_lat'])
lon1 = float( data[ mapped[direction][n+offset1] ]['stop_lon'])
dist1 = lat_long_dist(lat,lon,lat1,lon1)
# print(data[pos]['direction'],data[pos]['stop_name'],offset1,dist1,offset2,dist2)
'''
# 2.11.18: changing to simpler way of doing sanity check only on stops that aren't the first or last ones.
if n != 0 and n < (len(mapped[direction])-1):
offset2 = 1
offset1 = -1 - previousDeleted
# 1 next 1 previous. But if the previous point has been deleted, take the one before it
lat1 = float( data[ mapped[direction][n+offset1] ]['stop_lat'])
lon1 = float( data[ mapped[direction][n+offset1] ]['stop_lon'])
dist1 = lat_long_dist(lat,lon,lat1,lon1)
lat2 = float( data[ mapped[direction][n+offset2] ]['stop_lat'])
lon2 = float( data[ mapped[direction][n+offset2] ]['stop_lon'])
dist2 = lat_long_dist(lat,lon,lat2,lon2)
else:
dist1 = dist2 = 0
# short-circuit in case its the first or last stop
if dist1 > sanityDistance and dist2 > sanityDistance:
print('sanityCheck: position {}:{} over {}km away from neighbors({},{})'\
.format(pos,data[pos]['stop_name'],sanityDistance,dist1,dist2))
data[pos]['stop_lat'] = ''
data[pos]['stop_lon'] = ''
# other fields
data[pos]['source'] = ''
data[pos]['source_stop_name'] = ''
data[pos]['stop_desc'] = ''
data[pos]['stop_id'] = ''
previousDeleted += 1
count += 1
else:
previousDeleted = 0
return data, count
URLbank = pd.DataFrame()
nonURLbank = pd.DataFrame()
for file in doneFiles:
doneDF = pd.read_csv(doneFolder + file, dtype=str).fillna('')
print('processing done route',file)
# to do: need to skip rows with blank lat-longs. By policy there shouldn't be any, but good to bug-proof
if 'stop_url' in doneDF.columns:
urlDF = doneDF[doneDF.stop_url != ''][['stop_url','direction','stop_lat','stop_lon']].drop_duplicates(['stop_url','direction']).copy().reset_index(drop=True)
URLbank = URLbank.append(urlDF, ignore_index=True)
nameDF = doneDF[doneDF.stop_url == ''][['stop_name','direction','stop_lat','stop_lon']].drop_duplicates(['stop_name','direction']).copy().reset_index(drop=True)
else:
nameDF = doneDF[['stop_name','direction','stop_lat','stop_lon']].drop_duplicates(['stop_name','direction']).copy().reset_index(drop=True)
nonURLbank = nonURLbank.append(nameDF, ignore_index=True)
nonURLbank['zapped'] = nonURLbank['stop_name'].apply(zapper)
nonURLbank = nonURLbank.drop_duplicates('stop_name').copy().reset_index(drop=True)
URLbank = URLbank.drop_duplicates('stop_url').copy().reset_index(drop=True)
print('URLbank: {} entries | nonURLbank: {} entries'.format(len(URLbank),len(nonURLbank)))
processing done route 120M.csv processing done route 18B.csv processing done route 195J.csv processing done route 19M.csv processing done route 218D.csv processing done route 219.csv processing done route 225.csv processing done route 227B.csv processing done route 229.csv processing done route 22T.csv processing done route 242G.csv processing done route 3JJ.csv URLbank: 248 entries | nonURLbank: 314 entries
# dev: saving out to CSV for inspection
URLbank.to_csv(reportFolder + 'URLbank' + timestamp + '.csv', index_label='sr')
nonURLbank.to_csv(reportFolder + 'nonURLbank' + timestamp + '.csv', index_label='sr')
# URLbank.sort_values('stop_url').head(10)
# nonURLbank.sort_values('stop_name').tail(10)
reportCollector = []
reportDF = pd.DataFrame()
filesCounter = 0
for file in dataFiles:
data = pd.read_csv(dataFolder + file, dtype=str).fillna('').to_dict(orient='records',into=OrderedDict)
# get it into dict format
filesCounter += 1
if filesCounter % 20 == 1: print('\n\n{} files processed.\n\n'.format(filesCounter-1))
reportRow = OrderedDict({ 'file':file, 'route': data[0]['route'], 'stops':len(data) })
reportDF.at[file, 'route'] = data[0]['route']
reportDF.at[file, 'stops'] = len(data)
urlCounter = 0
nameCounter = 0
for row in data:
if not (row.get('stop_lat',None) and row.get('stop_lon',None) ):
url = row.get('stop_url','')
if url != '':
matches = URLbank[ URLbank.stop_url == url ].copy().reset_index(drop=True)
if len(matches):
# one more level: try for direction match too
dirMatches = matches[ matches.direction == row.get('direction','0') ].copy().reset_index(drop=True)
if len(dirMatches):
row['stop_lat'] = dirMatches.iloc[0].stop_lat
row['stop_lon'] = dirMatches.iloc[0].stop_lon
else:
row['stop_lat'] = matches.iloc[0].stop_lat
row['stop_lon'] = matches.iloc[0].stop_lon
# print('Found match for',url, row['stop_lat'],row['stop_lon'] )
urlCounter += 1
else:
zappedName = zapper(row.get('stop_name',''))
matches = nonURLbank[ nonURLbank['zapped'] == zappedName ].copy().reset_index(drop=True)
if len(matches):
# one more level: try for direction match too
dirMatches = matches[ matches.direction == row.get('direction','0') ].copy().reset_index(drop=True)
if len(dirMatches):
# print('found a direction match!', row)
# print(dirMatches)
row['stop_lat'] = dirMatches.iloc[0].stop_lat
row['stop_lon'] = dirMatches.iloc[0].stop_lon
else:
row['stop_lat'] = matches.iloc[0].stop_lat
row['stop_lon'] = matches.iloc[0].stop_lon
# print('Found match for',row.get('stop_name',''), zappedName, row['stop_lat'],row['stop_lon'] )
nameCounter += 1
print('\nprocessed {}, {} url matches, {} name matches'.format(file,urlCounter,nameCounter))
reportRow['url_matches'] = urlCounter
reportRow['name_matches'] = nameCounter
reportDF.at[file, 'url_matches'] = urlCounter
reportDF.at[file, 'name_matches'] = nameCounter
# now we have the cross-mapped route in dict: data
#print(data[0])
#print(data[-1])
# mapping with large databank
df = pd.DataFrame(data.copy()).fillna('')
# print(df)
data2, dbMatchCount = mapExactFunc(df.copy(),dfBank)
reportRow['databank_matches'] = dbMatchCount
reportDF.at[file, 'databank_matches'] = dbMatchCount
# test:
# pd.DataFrame(data2.copy()).fillna('').to_csv(dataFolder+'presanity'+file,index=False)
# sanitycheck: un-map mapped stops that are too damn far
data3, stopsRemoved = sanityCheck(data2.copy())
reportRow['faraway_removed'] = stopsRemoved
reportDF.at[file, 'faraway_removed'] = stopsRemoved
# finally we're ready to save route back to CSV
pd.DataFrame(data3.copy()).fillna('').to_csv(dataFolder+file,index=False)
reportCollector.append(reportRow)
0 files processed. processed 1.csv, 3 url matches, 5 name matches mapExactFunc: Databank matches found for 23 names. sanityCheck: position 27:Bakaram over 7km away from neighbors(24.22,22.66) processed 10.csv, 25 url matches, 7 name matches mapExactFunc: Databank matches found for 19 names. sanityCheck: position 27:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 32:Allwyn Colony over 7km away from neighbors(10.61,9.9) processed 100.csv, 1 url matches, 1 name matches mapExactFunc: Databank matches found for 32 names. processed 100A.csv, 20 url matches, 6 name matches mapExactFunc: Databank matches found for 16 names. processed 100C.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 41:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 45:Raithu Bazar Bus Stop over 7km away from neighbors(19.9,20.33) processed 100D_V.csv, 11 url matches, 2 name matches mapExactFunc: Databank matches found for 29 names. sanityCheck: position 44:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 100G.csv, 22 url matches, 6 name matches mapExactFunc: Databank matches found for 29 names. sanityCheck: position 56:Bandlaguda X Road over 7km away from neighbors(18.69,19.77) processed 100H.csv, 20 url matches, 7 name matches mapExactFunc: Databank matches found for 8 names. processed 100J.csv, 20 url matches, 6 name matches mapExactFunc: Databank matches found for 26 names. processed 100K.csv, 20 url matches, 5 name matches mapExactFunc: Databank matches found for 6 names. processed 100L.csv, 20 url matches, 5 name matches mapExactFunc: Databank matches found for 8 names. processed 100M.csv, 19 url matches, 5 name matches mapExactFunc: Databank matches found for 7 names. processed 100N.csv, 17 url matches, 5 name matches mapExactFunc: Databank matches found for 25 names. sanityCheck: position 51:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 100R.csv, 17 url matches, 5 name matches mapExactFunc: Databank matches found for 17 names. processed 100T.csv, 19 url matches, 6 name matches mapExactFunc: Databank matches found for 10 names. processed 100V.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 23 names. sanityCheck: position 40:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 101B.csv, 20 url matches, 5 name matches mapExactFunc: Databank matches found for 27 names. sanityCheck: position 2:Shakti Nagar over 7km away from neighbors(16.66,16.03) sanityCheck: position 52:Shakti Nagar over 7km away from neighbors(16.03,16.66) processed 101K.csv, 18 url matches, 6 name matches mapExactFunc: Databank matches found for 6 names. processed 101R.csv, 24 url matches, 4 name matches mapExactFunc: Databank matches found for 32 names. sanityCheck: position 5:Shakti Nagar over 7km away from neighbors(16.66,16.03) sanityCheck: position 63:Shakti Nagar over 7km away from neighbors(16.03,16.66) processed 101S.csv, 22 url matches, 4 name matches mapExactFunc: Databank matches found for 16 names. 20 files processed. processed 102.csv, 8 url matches, 3 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 38:Bakaram over 7km away from neighbors(24.22,22.66) processed 102A.csv, 5 url matches, 2 name matches mapExactFunc: Databank matches found for 22 names. processed 102B_218L.csv, 89 url matches, 19 name matches mapExactFunc: Databank matches found for 37 names. processed 102C.csv, 9 url matches, 3 name matches mapExactFunc: Databank matches found for 51 names. sanityCheck: position 8:Bakaram over 7km away from neighbors(24.22,22.66) processed 102CJ.csv, 8 url matches, 0 name matches mapExactFunc: Databank matches found for 25 names. processed 102D.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 19 names. processed 102F.csv, 34 url matches, 13 name matches mapExactFunc: Databank matches found for 22 names. processed 102H.csv, 11 url matches, 4 name matches mapExactFunc: Databank matches found for 13 names. processed 102K.csv, 10 url matches, 3 name matches mapExactFunc: Databank matches found for 42 names. sanityCheck: position 7:Bakaram over 7km away from neighbors(24.22,22.66) processed 102N.csv, 5 url matches, 2 name matches mapExactFunc: Databank matches found for 24 names. sanityCheck: position 17:Bandlaguda over 7km away from neighbors(24.86,27.57) sanityCheck: position 29:Bandlaguda over 7km away from neighbors(27.57,24.54) processed 102P.csv, 7 url matches, 2 name matches mapExactFunc: Databank matches found for 44 names. processed 102S.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 48 names. sanityCheck: position 19:Bakaram over 7km away from neighbors(24.22,22.66) processed 102W.csv, 5 url matches, 0 name matches mapExactFunc: Databank matches found for 16 names. processed 103.csv, 7 url matches, 2 name matches mapExactFunc: Databank matches found for 46 names. processed 104A.csv, 7 url matches, 2 name matches mapExactFunc: Databank matches found for 41 names. processed 104G.csv, 5 url matches, 0 name matches mapExactFunc: Databank matches found for 38 names. processed 104R.csv, 7 url matches, 2 name matches mapExactFunc: Databank matches found for 33 names. processed 104S.csv, 11 url matches, 3 name matches mapExactFunc: Databank matches found for 54 names. sanityCheck: position 51:Bakaram over 7km away from neighbors(24.22,22.66) processed 104T.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 32 names. processed 105.csv, 5 url matches, 0 name matches mapExactFunc: Databank matches found for 7 names. 40 files processed. processed 105M.csv, 5 url matches, 0 name matches mapExactFunc: Databank matches found for 16 names. processed 105S.csv, 15 url matches, 4 name matches mapExactFunc: Databank matches found for 10 names. processed 107.csv, 8 url matches, 7 name matches mapExactFunc: Databank matches found for 46 names. sanityCheck: position 7:Bakaram over 7km away from neighbors(24.22,23.66) sanityCheck: position 55:Amberpet Bus Stop over 7km away from neighbors(43.86,43.33) processed 107B.csv, 27 url matches, 8 name matches mapExactFunc: Databank matches found for 46 names. sanityCheck: position 21:Bakaram over 7km away from neighbors(24.22,22.66) processed 107G.csv, 16 url matches, 5 name matches mapExactFunc: Databank matches found for 31 names. sanityCheck: position 40:Bakaram over 7km away from neighbors(24.22,22.66) processed 107H.csv, 15 url matches, 4 name matches mapExactFunc: Databank matches found for 34 names. sanityCheck: position 7:Bakaram over 7km away from neighbors(24.22,22.66) processed 107J.csv, 9 url matches, 6 name matches mapExactFunc: Databank matches found for 30 names. processed 107K.csv, 16 url matches, 5 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 43:Bakaram over 7km away from neighbors(24.22,22.66) processed 107KV.csv, 6 url matches, 4 name matches mapExactFunc: Databank matches found for 36 names. sanityCheck: position 5:Huda Colony over 7km away from neighbors(26.53,26.26) sanityCheck: position 15:Amberpet Bus Stop over 7km away from neighbors(43.86,43.33) sanityCheck: position 50:Amberpet Bus Stop over 7km away from neighbors(43.33,43.86) sanityCheck: position 60:Huda Colony over 7km away from neighbors(26.26,26.53) processed 107M.csv, 15 url matches, 4 name matches mapExactFunc: Databank matches found for 25 names. sanityCheck: position 37:Bakaram over 7km away from neighbors(24.22,22.66) processed 107P.csv, 15 url matches, 4 name matches mapExactFunc: Databank matches found for 27 names. sanityCheck: position 7:Bakaram over 7km away from neighbors(24.22,22.66) processed 107S.csv, 15 url matches, 4 name matches mapExactFunc: Databank matches found for 34 names. sanityCheck: position 7:Bakaram over 7km away from neighbors(24.22,22.66) processed 107T.csv, 14 url matches, 8 name matches mapExactFunc: Databank matches found for 34 names. sanityCheck: position 13:Amberpet Bus Stop over 7km away from neighbors(43.86,36.89) sanityCheck: position 26:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.19) processed 107V.csv, 8 url matches, 2 name matches mapExactFunc: Databank matches found for 39 names. sanityCheck: position 19:Amberpet Bus Stop over 7km away from neighbors(43.86,36.89) sanityCheck: position 68:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 107VR.csv, 8 url matches, 4 name matches mapExactFunc: Databank matches found for 40 names. sanityCheck: position 7:Bakaram over 7km away from neighbors(24.22,23.66) sanityCheck: position 54:Amberpet Bus Stop over 7km away from neighbors(43.86,43.33) processed 107V_P.csv, 6 url matches, 2 name matches mapExactFunc: Databank matches found for 44 names. sanityCheck: position 2:Huda Colony over 7km away from neighbors(26.53,26.26) sanityCheck: position 13:Amberpet Bus Stop over 7km away from neighbors(43.86,43.33) sanityCheck: position 56:Amberpet Bus Stop over 7km away from neighbors(43.33,43.86) sanityCheck: position 67:Huda Colony over 7km away from neighbors(26.26,26.53) processed 108S.csv, 13 url matches, 4 name matches mapExactFunc: Databank matches found for 18 names. processed 10A_7S.csv, 43 url matches, 13 name matches mapExactFunc: Databank matches found for 12 names. processed 10B.csv, 12 url matches, 12 name matches mapExactFunc: Databank matches found for 18 names. processed 10F.csv, 23 url matches, 10 name matches mapExactFunc: Databank matches found for 19 names. 60 files processed. processed 10H.csv, 12 url matches, 6 name matches mapExactFunc: Databank matches found for 51 names. sanityCheck: position 3:Minerva Bus Stop over 7km away from neighbors(13.64,12.35) sanityCheck: position 71:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) processed 10H_17H.csv, 47 url matches, 16 name matches mapExactFunc: Databank matches found for 56 names. sanityCheck: position 4:Minerva Bus Stop over 7km away from neighbors(13.64,12.35) sanityCheck: position 59:Upparguda X Road over 7km away from neighbors(28.06,28.71) sanityCheck: position 126:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) processed 10H_219.csv, 24 url matches, 16 name matches mapExactFunc: Databank matches found for 63 names. sanityCheck: position 24:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) sanityCheck: position 56:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 57:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) sanityCheck: position 74:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 75:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 91:Minerva Bus Stop over 7km away from neighbors(13.64,12.35) processed 10H_224.csv, 20 url matches, 8 name matches mapExactFunc: Databank matches found for 50 names. sanityCheck: position 26:Krishna Nagar over 7km away from neighbors(15.04,15.87) sanityCheck: position 42:Minerva over 7km away from neighbors(12.35,13.57) sanityCheck: position 73:Minerva over 7km away from neighbors(13.57,12.35) sanityCheck: position 89:Krishna Nagar over 7km away from neighbors(15.87,15.04) processed 10H_250C.csv, 27 url matches, 9 name matches mapExactFunc: Databank matches found for 88 names. sanityCheck: position 4:Minerva Bus Stop over 7km away from neighbors(13.64,12.35) sanityCheck: position 80:Charlapally over 7km away from neighbors(52.22,66.31) sanityCheck: position 83:Sai Nagar Colony over 7km away from neighbors(15.61,11.29) sanityCheck: position 86:Sai Nagar Colony over 7km away from neighbors(11.29,12.81) sanityCheck: position 148:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) processed 10H_25I.csv, 10 url matches, 10 name matches mapExactFunc: Databank matches found for 74 names. sanityCheck: position 44:Krishna Nagar over 7km away from neighbors(15.04,15.87) sanityCheck: position 60:Minerva over 7km away from neighbors(12.35,13.57) sanityCheck: position 71:Minerva over 7km away from neighbors(13.57,12.35) sanityCheck: position 87:Krishna Nagar over 7km away from neighbors(15.87,15.04) processed 10H_25S.csv, 24 url matches, 12 name matches mapExactFunc: Databank matches found for 74 names. sanityCheck: position 4:Minerva Bus Stop over 7km away from neighbors(13.64,12.35) sanityCheck: position 60:Golnaka Bus Stop over 7km away from neighbors(12.39,12.54) sanityCheck: position 120:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) processed 10H_W.csv, 12 url matches, 14 name matches mapExactFunc: Databank matches found for 54 names. sanityCheck: position 26:Krishna Nagar over 7km away from neighbors(15.04,15.87) sanityCheck: position 41:Minerva over 7km away from neighbors(12.35,13.64) sanityCheck: position 49:Indira Nagar over 7km away from neighbors(21.4,22.47) sanityCheck: position 60:Indira Nagar over 7km away from neighbors(22.47,21.4) sanityCheck: position 68:Minerva over 7km away from neighbors(13.64,12.35) sanityCheck: position 83:Krishna Nagar over 7km away from neighbors(15.87,15.04) processed 10KB.csv, 44 url matches, 16 name matches mapExactFunc: Databank matches found for 27 names. sanityCheck: position 51:Rajivgandhi Nagar over 7km away from neighbors(10.55,9.03) processed 10KM.csv, 30 url matches, 24 name matches mapExactFunc: Databank matches found for 24 names. processed 10K_J.csv, 24 url matches, 18 name matches mapExactFunc: Databank matches found for 28 names. sanityCheck: position 41:Venkateshwara Nagar over 7km away from neighbors(7.6,8.27) sanityCheck: position 45:Anjaiah Nagar over 7km away from neighbors(8.64,8.27) processed 10L.csv, 50 url matches, 18 name matches mapExactFunc: Databank matches found for 14 names. processed 10N.csv, 8 url matches, 3 name matches mapExactFunc: Databank matches found for 21 names. processed 10R.csv, 5 url matches, 3 name matches mapExactFunc: Databank matches found for 22 names. processed 10U.csv, 10 url matches, 8 name matches mapExactFunc: Databank matches found for 35 names. sanityCheck: position 34:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) processed 10W.csv, 12 url matches, 16 name matches mapExactFunc: Databank matches found for 52 names. sanityCheck: position 26:Krishna Nagar over 7km away from neighbors(15.04,15.87) sanityCheck: position 41:Minerva over 7km away from neighbors(12.35,13.64) sanityCheck: position 49:Indira Nagar over 7km away from neighbors(21.4,22.47) sanityCheck: position 60:Indira Nagar over 7km away from neighbors(22.47,21.4) sanityCheck: position 68:Minerva over 7km away from neighbors(13.64,12.35) sanityCheck: position 83:Krishna Nagar over 7km away from neighbors(15.87,15.04) processed 10Y.csv, 6 url matches, 3 name matches mapExactFunc: Databank matches found for 17 names. processed 10YF.csv, 12 url matches, 6 name matches mapExactFunc: Databank matches found for 28 names. processed 10Z.csv, 5 url matches, 2 name matches mapExactFunc: Databank matches found for 20 names. processed 11.csv, 6 url matches, 3 name matches mapExactFunc: Databank matches found for 28 names. sanityCheck: position 28:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) 80 files processed. processed 113A.csv, 16 url matches, 16 name matches mapExactFunc: Databank matches found for 48 names. sanityCheck: position 20:Gandhi Statue over 7km away from neighbors(24.66,41.36) sanityCheck: position 21:Amberpet over 7km away from neighbors(42.98,43.33) sanityCheck: position 82:Amberpet over 7km away from neighbors(43.33,41.36) sanityCheck: position 83:Gandhi Statue over 7km away from neighbors(23.69,24.66) processed 113B.csv, 10 url matches, 3 name matches mapExactFunc: Databank matches found for 19 names. processed 113C.csv, 20 url matches, 6 name matches mapExactFunc: Databank matches found for 37 names. sanityCheck: position 26:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 113EL.csv, 72 url matches, 17 name matches mapExactFunc: Databank matches found for 48 names. sanityCheck: position 66:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 113I_V.csv, 12 url matches, 12 name matches mapExactFunc: Databank matches found for 72 names. sanityCheck: position 12:Gandhi Statue over 7km away from neighbors(24.66,41.36) sanityCheck: position 13:Amberpet over 7km away from neighbors(42.98,43.33) sanityCheck: position 122:Amberpet over 7km away from neighbors(43.33,41.36) sanityCheck: position 123:Gandhi Statue over 7km away from neighbors(23.69,24.66) processed 113K.csv, 31 url matches, 13 name matches mapExactFunc: Databank matches found for 58 names. sanityCheck: position 1:RTC Colony over 7km away from neighbors(8.53,7.96) sanityCheck: position 4:Kamala Nagar over 7km away from neighbors(9.53,9.27) sanityCheck: position 98:Gandhi Statue over 7km away from neighbors(24.23,24.66) sanityCheck: position 117:Kamala Nagar over 7km away from neighbors(9.27,8.53) sanityCheck: position 118:RTC Colony over 7km away from neighbors(7.54,8.53) processed 113KJ.csv, 36 url matches, 24 name matches mapExactFunc: Databank matches found for 64 names. sanityCheck: position 10:Kamala Nagar over 7km away from neighbors(10.01,9.27) sanityCheck: position 29:Gandhi Statue over 7km away from neighbors(24.66,41.36) sanityCheck: position 30:Amberpet over 7km away from neighbors(42.98,43.33) sanityCheck: position 117:Amberpet over 7km away from neighbors(43.33,41.36) sanityCheck: position 118:Gandhi Statue over 7km away from neighbors(23.69,24.66) sanityCheck: position 137:Kamala Nagar over 7km away from neighbors(9.27,10.01) processed 113KY.csv, 14 url matches, 24 name matches mapExactFunc: Databank matches found for 92 names. sanityCheck: position 1:RTC Colony over 7km away from neighbors(8.53,8.53) sanityCheck: position 3:Kamala Nagar over 7km away from neighbors(10.48,9.27) sanityCheck: position 22:Gandhi Statue over 7km away from neighbors(24.66,41.36) sanityCheck: position 23:Amberpet over 7km away from neighbors(42.98,43.33) sanityCheck: position 51:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) sanityCheck: position 108:Krishna Nagar bus stop over 7km away from neighbors(15.87,15.04) sanityCheck: position 136:Amberpet over 7km away from neighbors(43.33,41.36) sanityCheck: position 137:Gandhi Statue over 7km away from neighbors(23.69,24.66) sanityCheck: position 156:Kamala Nagar over 7km away from neighbors(9.27,8.53) sanityCheck: position 158:RTC Colony over 7km away from neighbors(7.54,8.53) processed 113K_J-2.csv, 44 url matches, 14 name matches mapExactFunc: Databank matches found for 45 names. sanityCheck: position 104:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 113K_J.csv, 45 url matches, 15 name matches mapExactFunc: Databank matches found for 50 names. sanityCheck: position 2:RTC Colony over 7km away from neighbors(10.46,7.96) sanityCheck: position 3:Chengicherla X Road over 7km away from neighbors(10.36,9.53) sanityCheck: position 112:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 113K_L-1.csv, 32 url matches, 24 name matches mapExactFunc: Databank matches found for 66 names. sanityCheck: position 42:Gandhi Statue over 7km away from neighbors(24.23,24.66) sanityCheck: position 61:Kamala Nagar over 7km away from neighbors(9.27,10.01) sanityCheck: position 78:Kamala Nagar over 7km away from neighbors(10.01,9.27) sanityCheck: position 97:Gandhi Statue over 7km away from neighbors(24.66,24.23) processed 113K_L.csv, 71 url matches, 20 name matches mapExactFunc: Databank matches found for 45 names. sanityCheck: position 135:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 113M.csv, 10 url matches, 5 name matches mapExactFunc: Databank matches found for 44 names. sanityCheck: position 26:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 113M_216.csv, 13 url matches, 12 name matches mapExactFunc: Databank matches found for 98 names. sanityCheck: position 24:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 57:Gandhi Statue over 7km away from neighbors(24.23,24.66) sanityCheck: position 122:Dargah over 7km away from neighbors(15.28,15.6) processed 113M_288.csv, 4 url matches, 14 name matches mapExactFunc: Databank matches found for 76 names. sanityCheck: position 12:Gandhi Statue over 7km away from neighbors(24.66,41.36) sanityCheck: position 13:Amberpet over 7km away from neighbors(42.98,43.33) sanityCheck: position 46:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 49:Bandlaguda over 7km away from neighbors(28.92,30.51) sanityCheck: position 84:Bandlaguda over 7km away from neighbors(30.51,28.92) sanityCheck: position 87:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) sanityCheck: position 120:Amberpet over 7km away from neighbors(43.33,41.36) sanityCheck: position 121:Gandhi Statue over 7km away from neighbors(23.69,24.66) processed 113M_K.csv, 18 url matches, 10 name matches mapExactFunc: Databank matches found for 86 names. sanityCheck: position 12:Gandhi Statue over 7km away from neighbors(24.66,41.36) sanityCheck: position 13:Amberpet over 7km away from neighbors(42.98,43.33) sanityCheck: position 47:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 69:Chandra Nagar over 7km away from neighbors(29.8,30.39) sanityCheck: position 72:Chandra Nagar over 7km away from neighbors(30.39,29.8) sanityCheck: position 94:Dargah over 7km away from neighbors(15.6,15.28) sanityCheck: position 128:Amberpet over 7km away from neighbors(43.33,41.36) sanityCheck: position 129:Gandhi Statue over 7km away from neighbors(23.69,24.66) processed 113M_W.csv, 13 url matches, 18 name matches mapExactFunc: Databank matches found for 69 names. sanityCheck: position 47:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 77:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 109:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 113S.csv, 27 url matches, 8 name matches mapExactFunc: Databank matches found for 49 names. sanityCheck: position 47:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 52:Allwyn Colony over 7km away from neighbors(10.61,9.9) sanityCheck: position 88:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 113Y.csv, 14 url matches, 8 name matches mapExactFunc: Databank matches found for 41 names. sanityCheck: position 62:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 113_288.csv, 8 url matches, 16 name matches mapExactFunc: Databank matches found for 76 names. sanityCheck: position 18:Bandlaguda over 7km away from neighbors(30.51,28.92) sanityCheck: position 21:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) sanityCheck: position 54:Gandhi Statue Bus Stop over 7km away from neighbors(24.23,24.66) sanityCheck: position 87:Gandhi Statue Bus Stop over 7km away from neighbors(24.66,24.23) sanityCheck: position 120:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 123:Bandlaguda over 7km away from neighbors(28.92,30.51) 100 files processed. processed 113f.csv, 15 url matches, 9 name matches mapExactFunc: Databank matches found for 66 names. sanityCheck: position 45:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 114.csv, 5 url matches, 1 name matches mapExactFunc: Databank matches found for 9 names. processed 115.csv, 3 url matches, 3 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 10:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 115C.csv, 5 url matches, 0 name matches mapExactFunc: Databank matches found for 19 names. sanityCheck: position 23:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 115M-1.csv, 14 url matches, 12 name matches mapExactFunc: Databank matches found for 32 names. sanityCheck: position 21:Gandhi Statue Bus Stop over 7km away from neighbors(24.23,24.66) sanityCheck: position 50:Gandhi Statue Bus Stop over 7km away from neighbors(24.66,24.23) processed 115M-2.csv, 30 url matches, 8 name matches mapExactFunc: Databank matches found for 28 names. sanityCheck: position 4:Gandhi Statue Bus Stop over 7km away from neighbors(28.79,28.09) sanityCheck: position 79:Gandhi Statue Bus Stop over 7km away from neighbors(28.09,28.79) processed 115M.csv, 20 url matches, 7 name matches mapExactFunc: Databank matches found for 35 names. sanityCheck: position 27:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 115V.csv, 5 url matches, 0 name matches mapExactFunc: Databank matches found for 16 names. sanityCheck: position 21:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 116.csv, 3 url matches, 3 name matches mapExactFunc: Databank matches found for 23 names. sanityCheck: position 27:Dargah over 7km away from neighbors(15.98,15.29) processed 116N.csv, 10 url matches, 6 name matches mapExactFunc: Databank matches found for 29 names. sanityCheck: position 22:Dargah over 7km away from neighbors(15.28,15.94) sanityCheck: position 32:Dargah over 7km away from neighbors(15.34,15.29) processed 116T.csv, 7 url matches, 3 name matches mapExactFunc: Databank matches found for 22 names. sanityCheck: position 1:Sharada Nagar over 7km away from neighbors(16.19,15.77) processed 117.csv, 12 url matches, 7 name matches mapExactFunc: Databank matches found for 20 names. processed 118.csv, 13 url matches, 7 name matches mapExactFunc: Databank matches found for 4 names. processed 118D_W.csv, 41 url matches, 24 name matches mapExactFunc: Databank matches found for 29 names. sanityCheck: position 40:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 71:Dargah over 7km away from neighbors(15.34,15.29) processed 118T.csv, 13 url matches, 9 name matches mapExactFunc: Databank matches found for 17 names. sanityCheck: position 20:Sai Baba Temple over 7km away from neighbors(14.71,24.34) sanityCheck: position 21:Food World Bus Stop over 7km away from neighbors(11.34,26.41) sanityCheck: position 22:Sharada Nagar over 7km away from neighbors(16.94,16.19) sanityCheck: position 25:Sharada Nagar over 7km away from neighbors(16.19,16.75) processed 118W.csv, 27 url matches, 24 name matches mapExactFunc: Databank matches found for 29 names. sanityCheck: position 15:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 73:Dargah over 7km away from neighbors(15.28,15.6) processed 119.csv, 10 url matches, 12 name matches mapExactFunc: Databank matches found for 16 names. processed 12.csv, 13 url matches, 3 name matches mapExactFunc: Databank matches found for 69 names. sanityCheck: position 57:Minerva Bus Stop over 7km away from neighbors(13.64,12.35) processed 123.csv, 1 url matches, 3 name matches mapExactFunc: Databank matches found for 17 names. sanityCheck: position 10:OU Colony over 7km away from neighbors(25.26,30.01) sanityCheck: position 25:OU Colony Bus Stop over 7km away from neighbors(73.54,15.98) sanityCheck: position 26:Dargah over 7km away from neighbors(61.93,15.29) processed 126M.csv, 12 url matches, 6 name matches mapExactFunc: Databank matches found for 24 names. sanityCheck: position 8:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 37:Dargah over 7km away from neighbors(15.6,15.28) 120 files processed. processed 126_300.csv, 12 url matches, 8 name matches mapExactFunc: Databank matches found for 98 names. sanityCheck: position 25:Bandlaguda over 7km away from neighbors(28.15,27.57) sanityCheck: position 53:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 82:Dargah over 7km away from neighbors(15.6,15.28) sanityCheck: position 110:Bandlaguda over 7km away from neighbors(27.57,28.15) processed 126_300H.csv, 16 url matches, 12 name matches mapExactFunc: Databank matches found for 80 names. sanityCheck: position 17:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 43:Bandlaguda over 7km away from neighbors(27.57,28.15) sanityCheck: position 90:Bandlaguda over 7km away from neighbors(28.15,27.57) sanityCheck: position 116:Dargah over 7km away from neighbors(15.29,15.34) processed 127.csv, 31 url matches, 9 name matches mapExactFunc: Databank matches found for 36 names. processed 127F.csv, 16 url matches, 9 name matches mapExactFunc: Databank matches found for 13 names. processed 127HJ.csv, 40 url matches, 12 name matches mapExactFunc: Databank matches found for 68 names. processed 127J.csv, 28 url matches, 9 name matches mapExactFunc: Databank matches found for 10 names. processed 127K.csv, 19 url matches, 8 name matches mapExactFunc: Databank matches found for 48 names. sanityCheck: position 50:Minerva Bus Stop over 7km away from neighbors(13.64,12.35) processed 127KH.csv, 34 url matches, 8 name matches mapExactFunc: Databank matches found for 68 names. sanityCheck: position 61:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 76:Check Post Bus Stop over 7km away from neighbors(31.82,30.96) processed 127K_S.csv, 40 url matches, 6 name matches mapExactFunc: Databank matches found for 78 names. processed 127K_V.csv, 35 url matches, 10 name matches mapExactFunc: Databank matches found for 77 names. sanityCheck: position 83:Minerva Bus Stop over 7km away from neighbors(13.64,12.35) sanityCheck: position 145:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 127LH.csv, 38 url matches, 6 name matches mapExactFunc: Databank matches found for 50 names. processed 127LK.csv, 36 url matches, 6 name matches mapExactFunc: Databank matches found for 62 names. processed 127N.csv, 18 url matches, 6 name matches mapExactFunc: Databank matches found for 18 names. processed 127T.csv, 14 url matches, 2 name matches mapExactFunc: Databank matches found for 6 names. processed 127VB.csv, 25 url matches, 13 name matches mapExactFunc: Databank matches found for 45 names. processed 131.csv, 8 url matches, 3 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 35:Bakaram over 7km away from neighbors(24.22,22.66) processed 135.csv, 16 url matches, 10 name matches mapExactFunc: Databank matches found for 3 names. processed 136.csv, 0 url matches, 14 name matches mapExactFunc: Databank matches found for 20 names. sanityCheck: position 18:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.34) sanityCheck: position 23:Dairy Farm Bus Stop over 7km away from neighbors(15.34,14.44) processed 136B.csv, 2 url matches, 8 name matches mapExactFunc: Databank matches found for 27 names. sanityCheck: position 19:Dairy Farm Bus Stop over 7km away from neighbors(13.97,15.12) processed 136H.csv, 35 url matches, 13 name matches mapExactFunc: Databank matches found for 22 names. sanityCheck: position 67:Dairy Farm Bus Stop over 7km away from neighbors(13.97,15.34) sanityCheck: position 75:Upparguda X Road over 7km away from neighbors(28.06,28.71) 140 files processed. processed 136L.csv, 12 url matches, 17 name matches mapExactFunc: Databank matches found for 22 names. sanityCheck: position 53:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.34) processed 136N.csv, 2 url matches, 11 name matches mapExactFunc: Databank matches found for 35 names. sanityCheck: position 20:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.12) processed 136S.csv, 8 url matches, 9 name matches mapExactFunc: Databank matches found for 14 names. processed 137.csv, 7 url matches, 5 name matches mapExactFunc: Databank matches found for 36 names. processed 139.csv, 8 url matches, 6 name matches mapExactFunc: Databank matches found for 37 names. sanityCheck: position 7:Bakaram over 7km away from neighbors(24.22,22.66) processed 14.csv, 10 url matches, 1 name matches mapExactFunc: Databank matches found for 11 names. processed 141.csv, 7 url matches, 9 name matches mapExactFunc: Databank matches found for 43 names. sanityCheck: position 57:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 142K.csv, 15 url matches, 12 name matches mapExactFunc: Databank matches found for 13 names. processed 142S.csv, 16 url matches, 12 name matches mapExactFunc: Databank matches found for 12 names. processed 143.csv, 3 url matches, 1 name matches mapExactFunc: Databank matches found for 19 names. processed 143A.csv, 5 url matches, 1 name matches mapExactFunc: Databank matches found for 31 names. sanityCheck: position 39:Dargah over 7km away from neighbors(12.51,13.18) processed 147.csv, 16 url matches, 0 name matches mapExactFunc: Databank matches found for 70 names. sanityCheck: position 54:Minerva Bus Stop over 7km away from neighbors(12.35,13.57) sanityCheck: position 71:Minerva Bus Stop over 7km away from neighbors(13.57,12.35) processed 147W.csv, 16 url matches, 10 name matches mapExactFunc: Databank matches found for 72 names. sanityCheck: position 55:Minerva Bus Stop over 7km away from neighbors(12.35,13.78) sanityCheck: position 62:Indira Nagar over 7km away from neighbors(21.4,22.47) sanityCheck: position 73:Indira Nagar over 7km away from neighbors(22.47,21.4) sanityCheck: position 80:Minerva Bus Stop over 7km away from neighbors(13.78,12.35) processed 14P.csv, 14 url matches, 0 name matches mapExactFunc: Databank matches found for 14 names. sanityCheck: position 11:Shanti Nagar over 7km away from neighbors(17.91,17.19) sanityCheck: position 20:Shanti Nagar over 7km away from neighbors(17.19,17.91) processed 15.csv, 31 url matches, 4 name matches mapExactFunc: Databank matches found for 13 names. sanityCheck: position 14:Upparguda X Road over 7km away from neighbors(28.06,28.71) processed 152.csv, 22 url matches, 9 name matches mapExactFunc: Databank matches found for 2 names. processed 152G.csv, 22 url matches, 5 name matches mapExactFunc: Databank matches found for 5 names. processed 153.csv, 17 url matches, 6 name matches mapExactFunc: Databank matches found for 8 names. processed 156.csv, 18 url matches, 8 name matches mapExactFunc: Databank matches found for 18 names. processed 156B.csv, 20 url matches, 3 name matches mapExactFunc: Databank matches found for 39 names. sanityCheck: position 29:Dargah over 7km away from neighbors(12.51,13.18) sanityCheck: position 69:Check Post Bus Stop over 7km away from neighbors(27.96,31.82) 160 files processed. processed 156H.csv, 16 url matches, 4 name matches mapExactFunc: Databank matches found for 47 names. sanityCheck: position 21:Amberpet Bus Stop over 7km away from neighbors(43.86,43.08) sanityCheck: position 79:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 156L.csv, 39 url matches, 10 name matches mapExactFunc: Databank matches found for 18 names. processed 156LM.csv, 24 url matches, 8 name matches mapExactFunc: Databank matches found for 14 names. processed 156L_216G.csv, 50 url matches, 10 name matches mapExactFunc: Databank matches found for 40 names. sanityCheck: position 45:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 70:Dargah over 7km away from neighbors(15.6,15.28) processed 156V.csv, 32 url matches, 9 name matches mapExactFunc: Databank matches found for 28 names. sanityCheck: position 77:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 156V_118W.csv, 42 url matches, 20 name matches mapExactFunc: Databank matches found for 53 names. sanityCheck: position 54:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 82:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 129:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 156_204U.csv, 32 url matches, 9 name matches mapExactFunc: Databank matches found for 61 names. sanityCheck: position 2:Koheda X Road over 7km away from neighbors(10.01,9.78) sanityCheck: position 12:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 93:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 104:RTC Colony over 7km away from neighbors(9.72,10.48) sanityCheck: position 109:Check Post over 7km away from neighbors(36.71,37.78) processed 156_216.csv, 43 url matches, 13 name matches mapExactFunc: Databank matches found for 92 names. sanityCheck: position 1:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 59:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 109:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 156:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 167:RTC Colony over 7km away from neighbors(9.72,10.48) processed 156_216G.csv, 39 url matches, 13 name matches mapExactFunc: Databank matches found for 53 names. sanityCheck: position 1:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 59:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 83:Dargah over 7km away from neighbors(15.34,15.29) processed 156_216L.csv, 50 url matches, 8 name matches mapExactFunc: Databank matches found for 64 names. sanityCheck: position 44:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 95:Dargah over 7km away from neighbors(15.6,15.28) processed 156_288H.csv, 46 url matches, 10 name matches mapExactFunc: Databank matches found for 66 names. sanityCheck: position 1:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 58:Sairam Nagar Busstop over 7km away from neighbors(22.35,24.77) sanityCheck: position 61:Bandlaguda over 7km away from neighbors(28.92,30.51) sanityCheck: position 74:Himayath Nagar Bus Stop over 7km away from neighbors(18.07,21.56) sanityCheck: position 79:Himayath Nagar Bus Stop over 7km away from neighbors(21.56,18.07) sanityCheck: position 92:Bandlaguda over 7km away from neighbors(30.51,28.92) sanityCheck: position 95:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.35) sanityCheck: position 152:RTC Colony Bus Stop over 7km away from neighbors(9.5,10.53) processed 156_299.csv, 39 url matches, 8 name matches mapExactFunc: Databank matches found for 41 names. sanityCheck: position 1:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 90:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 101:RTC Colony over 7km away from neighbors(9.72,10.48) processed 158.csv, 58 url matches, 10 name matches mapExactFunc: Databank matches found for 28 names. sanityCheck: position 46:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 51:Allwyn Colony over 7km away from neighbors(10.61,9.82) processed 158D_L.csv, 62 url matches, 10 name matches mapExactFunc: Databank matches found for 4 names. sanityCheck: position 35:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 40:Allwyn Colony over 7km away from neighbors(10.61,9.82) processed 158F.csv, 44 url matches, 16 name matches mapExactFunc: Databank matches found for 14 names. processed 158FB.csv, 60 url matches, 12 name matches mapExactFunc: Databank matches found for 28 names. processed 158FV.csv, 48 url matches, 15 name matches mapExactFunc: Databank matches found for 30 names. sanityCheck: position 43:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 158F_299.csv, 54 url matches, 15 name matches mapExactFunc: Databank matches found for 43 names. sanityCheck: position 1:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 114:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 125:RTC Colony over 7km away from neighbors(9.72,10.48) processed 158J.csv, 58 url matches, 22 name matches mapExactFunc: Databank matches found for 28 names. processed 158JA.csv, 43 url matches, 27 name matches mapExactFunc: Databank matches found for 37 names. sanityCheck: position 20:Prashanth Nagar over 7km away from neighbors(12.69,13.05) sanityCheck: position 90:Prashanth Nagar over 7km away from neighbors(12.69,13.05) 180 files processed. processed 158J_272G.csv, 68 url matches, 24 name matches mapExactFunc: Databank matches found for 34 names. processed 158J_D.csv, 58 url matches, 22 name matches mapExactFunc: Databank matches found for 18 names. processed 158L.csv, 62 url matches, 10 name matches mapExactFunc: Databank matches found for 14 names. sanityCheck: position 43:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 48:Allwyn Colony over 7km away from neighbors(10.61,9.82) processed 158M.csv, 53 url matches, 14 name matches mapExactFunc: Databank matches found for 15 names. sanityCheck: position 2:Allwyn Colony over 7km away from neighbors(10.61,9.9) sanityCheck: position 90:Allwyn Colony over 7km away from neighbors(9.82,10.61) processed 158N.csv, 53 url matches, 14 name matches mapExactFunc: Databank matches found for 13 names. sanityCheck: position 40:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 45:Allwyn Colony over 7km away from neighbors(10.61,9.9) processed 158S.csv, 35 url matches, 10 name matches mapExactFunc: Databank matches found for 13 names. sanityCheck: position 32:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 37:Allwyn Colony over 7km away from neighbors(10.61,9.9) processed 158V.csv, 62 url matches, 10 name matches mapExactFunc: Databank matches found for 24 names. sanityCheck: position 51:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 56:Allwyn Colony over 7km away from neighbors(10.61,9.82) processed 158V_J.csv, 60 url matches, 25 name matches mapExactFunc: Databank matches found for 50 names. sanityCheck: position 101:Prashanth Nagar over 7km away from neighbors(12.69,13.05) sanityCheck: position 149:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 158_277D.csv, 54 url matches, 12 name matches mapExactFunc: Databank matches found for 60 names. sanityCheck: position 2:Allwyn Colony over 7km away from neighbors(10.61,9.9) sanityCheck: position 69:Ambedkar Statue over 7km away from neighbors(35.31,38.16) sanityCheck: position 72:Ambedkar Statue over 7km away from neighbors(38.7,35.31) sanityCheck: position 145:Allwyn Colony over 7km away from neighbors(9.82,10.61) processed 158_299.csv, 55 url matches, 12 name matches mapExactFunc: Databank matches found for 44 names. sanityCheck: position 1:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 62:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 67:Allwyn Colony over 7km away from neighbors(10.61,9.9) sanityCheck: position 111:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 122:RTC Colony over 7km away from neighbors(9.72,10.48) processed 15H.csv, 29 url matches, 3 name matches mapExactFunc: Databank matches found for 13 names. sanityCheck: position 40:Upparguda X Road over 7km away from neighbors(28.06,28.71) processed 16A.csv, 10 url matches, 0 name matches mapExactFunc: Databank matches found for 40 names. processed 16A_219.csv, 63 url matches, 22 name matches mapExactFunc: Databank matches found for 62 names. sanityCheck: position 8:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 9:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 134:Prashanth Nagar over 7km away from neighbors(12.69,14.17) sanityCheck: position 156:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 157:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) processed 16A_226L.csv, 64 url matches, 15 name matches mapExactFunc: Databank matches found for 48 names. sanityCheck: position 124:Prashanth Nagar over 7km away from neighbors(12.69,14.17) processed 16A_47LI.csv, 16 url matches, 21 name matches mapExactFunc: Databank matches found for 71 names. sanityCheck: position 17:Gandhi Nagar over 7km away from neighbors(18.33,17.65) processed 16A_49M-1.csv, 42 url matches, 6 name matches mapExactFunc: Databank matches found for 64 names. processed 16A_49M.csv, 47 url matches, 10 name matches mapExactFunc: Databank matches found for 51 names. processed 16A_5K.csv, 24 url matches, 7 name matches mapExactFunc: Databank matches found for 80 names. sanityCheck: position 6:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 132:Dargah over 7km away from neighbors(15.28,15.6) processed 16C.csv, 9 url matches, 1 name matches mapExactFunc: Databank matches found for 35 names. processed 16M.csv, 8 url matches, 1 name matches mapExactFunc: Databank matches found for 12 names. 200 files processed. processed 16P.csv, 4 url matches, 2 name matches mapExactFunc: Databank matches found for 16 names. processed 16R.csv, 11 url matches, 0 name matches mapExactFunc: Databank matches found for 37 names. sanityCheck: position 39:RTC Colony over 7km away from neighbors(8.22,7.34) sanityCheck: position 41:NMDC Bus Stop over 7km away from neighbors(12.58,11.97) processed 16T.csv, 6 url matches, 8 name matches mapExactFunc: Databank matches found for 47 names. sanityCheck: position 53:Dairy Farm Bus Stop over 7km away from neighbors(12.52,15.19) processed 17.csv, 40 url matches, 8 name matches mapExactFunc: Databank matches found for 4 names. sanityCheck: position 14:Upparguda X Road over 7km away from neighbors(28.06,28.71) processed 171.csv, 22 url matches, 6 name matches mapExactFunc: Databank matches found for 29 names. sanityCheck: position 4:Srinivas Nagar over 7km away from neighbors(14.76,12.04) sanityCheck: position 66:Srinivas Nagar over 7km away from neighbors(12.04,13.84) processed 171C.csv, 31 url matches, 16 name matches mapExactFunc: Databank matches found for 25 names. sanityCheck: position 15:Prashanth Nagar over 7km away from neighbors(12.1,13.05) processed 171K.csv, 32 url matches, 20 name matches mapExactFunc: Databank matches found for 27 names. sanityCheck: position 16:Prashanth Nagar over 7km away from neighbors(12.1,13.05) processed 171M.csv, 42 url matches, 22 name matches mapExactFunc: Databank matches found for 39 names. sanityCheck: position 4:Srinivas Nagar over 7km away from neighbors(14.76,12.04) sanityCheck: position 24:Prashanth Nagar over 7km away from neighbors(12.69,13.05) sanityCheck: position 117:Srinivas Nagar over 7km away from neighbors(12.04,13.84) processed 176.csv, 10 url matches, 3 name matches mapExactFunc: Databank matches found for 22 names. processed 178.csv, 0 url matches, 2 name matches mapExactFunc: Databank matches found for 16 names. sanityCheck: position 6:Bandlaguda over 7km away from neighbors(24.55,27.57) sanityCheck: position 17:Bandlaguda over 7km away from neighbors(27.57,24.82) processed 178R.csv, 0 url matches, 2 name matches mapExactFunc: Databank matches found for 24 names. sanityCheck: position 10:Bandlaguda over 7km away from neighbors(27.57,24.82) sanityCheck: position 24:Bandlaguda over 7km away from neighbors(24.55,27.57) processed 178V.csv, 0 url matches, 2 name matches mapExactFunc: Databank matches found for 17 names. sanityCheck: position 6:Bandlaguda over 7km away from neighbors(24.55,28.25) sanityCheck: position 15:Bandlaguda over 7km away from neighbors(27.57,24.82) processed 17HN.csv, 18 url matches, 8 name matches mapExactFunc: Databank matches found for 26 names. processed 17HN_47LI.csv, 28 url matches, 20 name matches mapExactFunc: Databank matches found for 74 names. sanityCheck: position 7:Indira Nagar over 7km away from neighbors(22.47,21.07) sanityCheck: position 138:Indira Nagar over 7km away from neighbors(21.07,22.47) processed 17H_10HEC.csv, 22 url matches, 32 name matches mapExactFunc: Databank matches found for 62 names. sanityCheck: position 54:Krishna Nagar over 7km away from neighbors(15.04,15.87) sanityCheck: position 70:Minerva over 7km away from neighbors(12.35,13.78) sanityCheck: position 76:Indira Nagar over 7km away from neighbors(21.4,22.47) sanityCheck: position 87:Indira Nagar over 7km away from neighbors(22.47,21.4) sanityCheck: position 93:Minerva over 7km away from neighbors(13.78,12.35) sanityCheck: position 109:Krishna Nagar over 7km away from neighbors(15.87,15.04) processed 17H_10W.csv, 44 url matches, 24 name matches mapExactFunc: Databank matches found for 68 names. sanityCheck: position 7:Indira Nagar over 7km away from neighbors(22.47,21.54) sanityCheck: position 13:Minerva Bus Stop over 7km away from neighbors(13.64,12.35) sanityCheck: position 156:Minerva Bus Stop over 7km away from neighbors(12.35,13.64) sanityCheck: position 162:Indira Nagar over 7km away from neighbors(21.54,22.47) processed 17H_219.csv, 91 url matches, 32 name matches mapExactFunc: Databank matches found for 36 names. sanityCheck: position 46:Prashanth Nagar over 7km away from neighbors(12.69,13.33) sanityCheck: position 70:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 71:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) sanityCheck: position 99:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 100:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 154:Upparguda X Road over 7km away from neighbors(28.06,28.71) processed 17H_47LI.csv, 37 url matches, 21 name matches mapExactFunc: Databank matches found for 65 names. processed 18.csv, 5 url matches, 7 name matches mapExactFunc: Databank matches found for 12 names. processed 183.csv, 30 url matches, 16 name matches mapExactFunc: Databank matches found for 18 names. sanityCheck: position 12:Prashanth Nagar over 7km away from neighbors(12.1,13.05) 220 files processed. processed 183AJ.csv, 22 url matches, 12 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 22:Prashanth Nagar over 7km away from neighbors(12.69,13.05) processed 183B.csv, 2 url matches, 4 name matches mapExactFunc: Databank matches found for 18 names. processed 185.csv, 29 url matches, 13 name matches mapExactFunc: Databank matches found for 4 names. processed 185N.csv, 42 url matches, 15 name matches mapExactFunc: Databank matches found for 9 names. processed 185S.csv, 41 url matches, 14 name matches mapExactFunc: Databank matches found for 9 names. processed 186.csv, 32 url matches, 16 name matches mapExactFunc: Databank matches found for 58 names. sanityCheck: position 55:Prashanth Nagar over 7km away from neighbors(12.69,13.33) sanityCheck: position 72:Prashanth Nagar over 7km away from neighbors(13.33,12.69) processed 186L.csv, 18 url matches, 14 name matches mapExactFunc: Databank matches found for 42 names. processed 187.csv, 51 url matches, 18 name matches mapExactFunc: Databank matches found for 7 names. sanityCheck: position 38:Road No 1 over 7km away from neighbors(8.98,9.14) processed 187D.csv, 59 url matches, 18 name matches mapExactFunc: Databank matches found for 4 names. processed 187DM.csv, 74 url matches, 14 name matches mapExactFunc: Databank matches found for 24 names. processed 187DV.csv, 74 url matches, 12 name matches mapExactFunc: Databank matches found for 30 names. sanityCheck: position 59:Road No 1 over 7km away from neighbors(8.98,9.14) sanityCheck: position 68:Road No 1 over 7km away from neighbors(9.14,8.98) processed 187D_L-2.csv, 80 url matches, 16 name matches mapExactFunc: Databank matches found for 22 names. processed 187D_L.csv, 63 url matches, 16 name matches mapExactFunc: Databank matches found for 14 names. processed 187HJ.csv, 80 url matches, 14 name matches mapExactFunc: Databank matches found for 32 names. sanityCheck: position 1:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 134:RTC Colony Bus Stop over 7km away from neighbors(9.5,10.53) processed 187J.csv, 53 url matches, 15 name matches mapExactFunc: Databank matches found for 4 names. processed 187JL.csv, 72 url matches, 18 name matches mapExactFunc: Databank matches found for 12 names. processed 187P.csv, 13 url matches, 3 name matches mapExactFunc: Databank matches found for 3 names. processed 187_205F.csv, 80 url matches, 16 name matches mapExactFunc: Databank matches found for 52 names. sanityCheck: position 6:Check Post over 7km away from neighbors(37.36,36.71) sanityCheck: position 11:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 146:RTC Colony Bus Stop over 7km away from neighbors(9.5,10.53) sanityCheck: position 151:Check Post over 7km away from neighbors(36.71,37.36) processed 187_224.csv, 40 url matches, 12 name matches mapExactFunc: Databank matches found for 60 names. sanityCheck: position 45:Junior College over 7km away from neighbors(24.44,27.73) sanityCheck: position 61:Check Post Bus Stop over 7km away from neighbors(30.96,31.45) sanityCheck: position 78:Check Post Bus Stop over 7km away from neighbors(31.45,30.96) sanityCheck: position 94:Junior College over 7km away from neighbors(27.73,24.44) processed 188H.csv, 2 url matches, 3 name matches mapExactFunc: Databank matches found for 24 names. sanityCheck: position 3:Laxmi Nagar over 7km away from neighbors(16.37,23.68) sanityCheck: position 10:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 23:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) sanityCheck: position 30:Maruthi Nagar over 7km away from neighbors(16.87,16.51) sanityCheck: position 32:Laxmi Nagar over 7km away from neighbors(16.37,15.88) 240 files processed. processed 189M.csv, 48 url matches, 14 name matches mapExactFunc: Databank matches found for 16 names. processed 189M_92A.csv, 42 url matches, 14 name matches mapExactFunc: Databank matches found for 48 names. sanityCheck: position 21:Prashanth Nagar over 7km away from neighbors(12.69,13.05) sanityCheck: position 50:Laxmi Nagar over 7km away from neighbors(15.88,17.95) sanityCheck: position 75:Laxmi Nagar over 7km away from neighbors(17.95,15.88) sanityCheck: position 104:Prashanth Nagar over 7km away from neighbors(13.05,12.69) processed 189M_A.csv, 46 url matches, 14 name matches mapExactFunc: Databank matches found for 44 names. sanityCheck: position 12:Maruthi Nagar over 7km away from neighbors(16.87,16.51) sanityCheck: position 109:Maruthi Nagar over 7km away from neighbors(16.51,16.87) processed 189R.csv, 54 url matches, 15 name matches mapExactFunc: Databank matches found for 27 names. sanityCheck: position 4:Prashanth Nagar over 7km away from neighbors(12.69,13.05) sanityCheck: position 39:Laxmi Nagar over 7km away from neighbors(16.37,17.95) sanityCheck: position 49:Dairy Farm over 7km away from neighbors(13.99,16.16) sanityCheck: position 61:Maruthi Nagar over 7km away from neighbors(16.87,16.51) processed 18C.csv, 10 url matches, 11 name matches mapExactFunc: Databank matches found for 37 names. sanityCheck: position 7:Kamala Nagar over 7km away from neighbors(9.53,9.27) sanityCheck: position 47:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 60:Kamala Nagar over 7km away from neighbors(9.27,9.53) processed 18R.csv, 9 url matches, 5 name matches mapExactFunc: Databank matches found for 15 names. processed 18V.csv, 9 url matches, 5 name matches mapExactFunc: Databank matches found for 14 names. sanityCheck: position 13:Church Bus Stop over 7km away from neighbors(27.06,26.77) sanityCheck: position 24:Church over 7km away from neighbors(26.34,26.05) processed 18_219.csv, 63 url matches, 18 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 41:Prashanth Nagar over 7km away from neighbors(12.69,14.17) sanityCheck: position 111:Junior College over 7km away from neighbors(26.56,27.73) processed 18_30.csv, 28 url matches, 10 name matches mapExactFunc: Databank matches found for 42 names. sanityCheck: position 7:Gandhi Nagar Bus Stop over 7km away from neighbors(24.51,23.91) sanityCheck: position 42:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 83:Gandhi Nagar Bus Stop over 7km away from neighbors(23.91,24.51) processed 190AG.csv, 19 url matches, 9 name matches mapExactFunc: Databank matches found for 24 names. processed 190RK.csv, 41 url matches, 12 name matches mapExactFunc: Databank matches found for 23 names. processed 195.csv, 28 url matches, 18 name matches mapExactFunc: Databank matches found for 8 names. processed 195D.csv, 26 url matches, 16 name matches mapExactFunc: Databank matches found for 12 names. processed 195E.csv, 50 url matches, 24 name matches mapExactFunc: Databank matches found for 4 names. processed 195W.csv, 18 url matches, 8 name matches mapExactFunc: Databank matches found for 32 names. sanityCheck: position 28:Rajivgandhi Nagar over 7km away from neighbors(9.03,10.55) sanityCheck: position 33:Rajivgandhi Nagar over 7km away from neighbors(10.55,9.03) processed 198.csv, 28 url matches, 26 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 20:Prashanth Nagar over 7km away from neighbors(12.69,13.33) processed 19F.csv, 47 url matches, 6 name matches mapExactFunc: Databank matches found for 4 names. processed 19F_A.csv, 46 url matches, 6 name matches mapExactFunc: Databank matches found for 30 names. sanityCheck: position 33:Laxmi Nagar over 7km away from neighbors(16.37,17.95) sanityCheck: position 59:Maruthi Nagar over 7km away from neighbors(16.87,16.51) processed 19K.csv, 67 url matches, 9 name matches mapExactFunc: Databank matches found for 0 names. processed 19M_224.csv, 84 url matches, 12 name matches mapExactFunc: Databank matches found for 2 names. 260 files processed. processed 19_224.csv, 80 url matches, 8 name matches mapExactFunc: Databank matches found for 4 names. processed 1B.csv, 5 url matches, 7 name matches mapExactFunc: Databank matches found for 32 names. sanityCheck: position 42:Bakaram over 7km away from neighbors(24.22,22.66) processed 1DS.csv, 10 url matches, 3 name matches mapExactFunc: Databank matches found for 30 names. sanityCheck: position 8:Bakaram over 7km away from neighbors(24.22,22.66) processed 1D_277D.csv, 14 url matches, 6 name matches mapExactFunc: Databank matches found for 67 names. sanityCheck: position 6:Bakaram over 7km away from neighbors(24.22,22.66) sanityCheck: position 53:Ambedkar Statue over 7km away from neighbors(35.31,38.16) sanityCheck: position 56:Ambedkar Statue over 7km away from neighbors(38.16,35.31) processed 1D_V.csv, 14 url matches, 5 name matches mapExactFunc: Databank matches found for 47 names. sanityCheck: position 51:Bakaram over 7km away from neighbors(24.22,22.66) sanityCheck: position 77:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 1J.csv, 4 url matches, 5 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 32:Bakaram over 7km away from neighbors(24.22,22.66) processed 1K.csv, 4 url matches, 4 name matches mapExactFunc: Databank matches found for 19 names. sanityCheck: position 25:Bakaram over 7km away from neighbors(24.22,22.66) processed 1P.csv, 4 url matches, 0 name matches mapExactFunc: Databank matches found for 30 names. processed 1V.csv, 14 url matches, 5 name matches mapExactFunc: Databank matches found for 43 names. sanityCheck: position 6:Bakaram over 7km away from neighbors(24.22,22.66) sanityCheck: position 32:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 2.csv, 7 url matches, 5 name matches mapExactFunc: Databank matches found for 22 names. sanityCheck: position 26:Bakaram over 7km away from neighbors(24.22,23.66) processed 201.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 32 names. sanityCheck: position 42:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 51:RTC Colony over 7km away from neighbors(9.19,10.48) processed 201G.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 12 names. processed 201K.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 44 names. sanityCheck: position 16:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 27:RTC Colony over 7km away from neighbors(9.72,10.48) sanityCheck: position 31:Vijay Puri Colony over 7km away from neighbors(11.06,9.86) sanityCheck: position 44:Vijay Nagar Colony over 7km away from neighbors(17.89,17.4) sanityCheck: position 46:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) processed 201M.csv, 12 url matches, 3 name matches mapExactFunc: Databank matches found for 23 names. sanityCheck: position 42:Bandlaguda X Road over 7km away from neighbors(18.69,19.77) processed 202.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 40 names. sanityCheck: position 15:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 202M.csv, 1 url matches, 1 name matches mapExactFunc: Databank matches found for 37 names. sanityCheck: position 6:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 35:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 44:RTC Colony over 7km away from neighbors(9.19,10.48) processed 202T.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 42 names. sanityCheck: position 49:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 203K.csv, 6 url matches, 2 name matches mapExactFunc: Databank matches found for 38 names. processed 203N.csv, 6 url matches, 2 name matches mapExactFunc: Databank matches found for 36 names. processed 204.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 46 names. sanityCheck: position 8:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 48:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 57:RTC Colony over 7km away from neighbors(9.19,10.48) 280 files processed. processed 204K.csv, 10 url matches, 2 name matches mapExactFunc: Databank matches found for 51 names. sanityCheck: position 1:Koheda X Road over 7km away from neighbors(7.96,9.78) sanityCheck: position 10:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 50:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 59:RTC Colony over 7km away from neighbors(9.19,10.48) sanityCheck: position 68:Koheda X Road over 7km away from neighbors(9.78,7.96) processed 204N.csv, 16 url matches, 4 name matches mapExactFunc: Databank matches found for 52 names. sanityCheck: position 5:Check Post over 7km away from neighbors(37.36,36.71) sanityCheck: position 10:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 71:RTC Colony Bus Stop over 7km away from neighbors(9.5,10.53) sanityCheck: position 76:Check Post over 7km away from neighbors(36.71,37.36) processed 204P.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 46 names. sanityCheck: position 7:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 54:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 65:RTC Colony over 7km away from neighbors(9.72,10.48) processed 204S.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 50 names. sanityCheck: position 15:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 24:RTC Colony over 7km away from neighbors(9.19,10.48) sanityCheck: position 38:Koheda X Road over 7km away from neighbors(10.01,9.78) sanityCheck: position 47:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) processed 205.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 65 names. sanityCheck: position 21:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 63:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 72:RTC Colony over 7km away from neighbors(9.19,10.48) processed 205A.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 60 names. sanityCheck: position 17:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 59:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 68:RTC Colony over 7km away from neighbors(9.19,10.48) processed 205B.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 49 names. sanityCheck: position 10:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 52:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 61:RTC Colony over 7km away from neighbors(9.19,10.48) processed 205F.csv, 28 url matches, 10 name matches mapExactFunc: Databank matches found for 63 names. sanityCheck: position 11:Koheda X Road over 7km away from neighbors(10.01,7.79) sanityCheck: position 19:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.19) sanityCheck: position 91:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 100:RTC Colony over 7km away from neighbors(9.19,10.48) sanityCheck: position 108:Koheda X Road over 7km away from neighbors(7.79,9.37) processed 205K.csv, 10 url matches, 2 name matches mapExactFunc: Databank matches found for 53 names. sanityCheck: position 12:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 50:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 59:RTC Colony over 7km away from neighbors(9.19,10.48) processed 205M.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 57 names. sanityCheck: position 17:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 59:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 68:RTC Colony over 7km away from neighbors(9.19,10.48) processed 206.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 59 names. sanityCheck: position 16:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 58:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 67:RTC Colony over 7km away from neighbors(9.19,10.48) processed 207.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 69 names. sanityCheck: position 10:Koheda X Road over 7km away from neighbors(11.41,9.78) sanityCheck: position 22:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 67:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 78:RTC Colony over 7km away from neighbors(9.72,10.48) processed 208.csv, 19 url matches, 4 name matches mapExactFunc: Databank matches found for 31 names. sanityCheck: position 20:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 28:RTC Colony over 7km away from neighbors(9.19,10.48) sanityCheck: position 31:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) processed 208C.csv, 11 url matches, 2 name matches mapExactFunc: Databank matches found for 44 names. sanityCheck: position 1:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 58:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 70:RTC Colony over 7km away from neighbors(9.19,10.48) processed 208R.csv, 20 url matches, 6 name matches mapExactFunc: Databank matches found for 39 names. sanityCheck: position 1:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 63:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 75:RTC Colony over 7km away from neighbors(9.19,10.48) processed 209.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 46 names. sanityCheck: position 10:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 48:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 56:RTC Colony over 7km away from neighbors(9.19,10.48) processed 21.csv, 20 url matches, 6 name matches mapExactFunc: Databank matches found for 4 names. processed 211.csv, 26 url matches, 14 name matches mapExactFunc: Databank matches found for 3 names. sanityCheck: position 18:water tank bus stop over 7km away from neighbors(14.47,14.43) sanityCheck: position 26:Water Tank over 7km away from neighbors(9.92,9.04) processed 211A.csv, 37 url matches, 21 name matches mapExactFunc: Databank matches found for 5 names. sanityCheck: position 20:water tank bus stop over 7km away from neighbors(14.47,14.43) sanityCheck: position 50:Water Tank over 7km away from neighbors(9.92,9.04) processed 211B.csv, 35 url matches, 17 name matches mapExactFunc: Databank matches found for 7 names. sanityCheck: position 61:water tank bus stop over 7km away from neighbors(14.47,7.07) sanityCheck: position 62:Water Tank over 7km away from neighbors(8.86,9.92) 300 files processed. processed 211C.csv, 32 url matches, 15 name matches mapExactFunc: Databank matches found for 3 names. sanityCheck: position 55:water tank bus stop over 7km away from neighbors(14.47,7.07) sanityCheck: position 56:Water Tank over 7km away from neighbors(8.86,9.92) processed 211D.csv, 37 url matches, 21 name matches mapExactFunc: Databank matches found for 11 names. sanityCheck: position 60:water tank bus stop over 7km away from neighbors(14.47,7.07) sanityCheck: position 61:Water Tank over 7km away from neighbors(8.86,9.92) processed 211E.csv, 25 url matches, 15 name matches mapExactFunc: Databank matches found for 1 names. sanityCheck: position 37:water tank bus stop over 7km away from neighbors(13.17,7.07) sanityCheck: position 38:Water Tank over 7km away from neighbors(8.47,9.92) processed 211J.csv, 34 url matches, 22 name matches mapExactFunc: Databank matches found for 11 names. sanityCheck: position 57:water tank bus stop over 7km away from neighbors(14.47,7.07) sanityCheck: position 58:Water Tank over 7km away from neighbors(8.86,9.92) processed 211K.csv, 53 url matches, 23 name matches mapExactFunc: Databank matches found for 14 names. sanityCheck: position 22:water tank bus stop over 7km away from neighbors(14.47,14.43) processed 211M.csv, 31 url matches, 7 name matches mapExactFunc: Databank matches found for 14 names. sanityCheck: position 24:Jawahar Nagar over 7km away from neighbors(15.73,19.08) sanityCheck: position 39:Jawahar Nagar over 7km away from neighbors(16.75,15.73) processed 211P.csv, 39 url matches, 15 name matches mapExactFunc: Databank matches found for 5 names. sanityCheck: position 55:water tank bus stop over 7km away from neighbors(14.47,7.07) sanityCheck: position 56:Water Tank over 7km away from neighbors(8.86,9.92) processed 211R.csv, 38 url matches, 23 name matches mapExactFunc: Databank matches found for 9 names. sanityCheck: position 19:water tank bus stop over 7km away from neighbors(14.47,14.43) sanityCheck: position 56:Water Tank over 7km away from neighbors(9.92,9.04) processed 211S.csv, 35 url matches, 19 name matches mapExactFunc: Databank matches found for 3 names. sanityCheck: position 54:water tank bus stop over 7km away from neighbors(14.47,7.07) sanityCheck: position 55:Water Tank over 7km away from neighbors(8.86,9.92) processed 211T.csv, 42 url matches, 22 name matches mapExactFunc: Databank matches found for 3 names. sanityCheck: position 20:water tank bus stop over 7km away from neighbors(14.47,14.43) sanityCheck: position 54:Water Tank over 7km away from neighbors(9.92,9.04) processed 211U.csv, 35 url matches, 17 name matches mapExactFunc: Databank matches found for 9 names. sanityCheck: position 20:water tank bus stop over 7km away from neighbors(14.47,14.43) sanityCheck: position 64:Water Tank over 7km away from neighbors(9.92,9.04) processed 216A.csv, 4 url matches, 11 name matches mapExactFunc: Databank matches found for 56 names. sanityCheck: position 7:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 8:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 29:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 47:Dargah over 7km away from neighbors(15.28,15.94) sanityCheck: position 68:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 69:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) processed 216D_L.csv, 39 url matches, 14 name matches mapExactFunc: Databank matches found for 55 names. sanityCheck: position 37:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 87:Dargah over 7km away from neighbors(15.34,15.29) processed 216KL.csv, 36 url matches, 10 name matches mapExactFunc: Databank matches found for 54 names. sanityCheck: position 30:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 81:Dargah over 7km away from neighbors(15.6,15.28) processed 216L.csv, 22 url matches, 10 name matches mapExactFunc: Databank matches found for 56 names. sanityCheck: position 23:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 74:Dargah over 7km away from neighbors(15.29,15.34) processed 216L_W.csv, 24 url matches, 16 name matches mapExactFunc: Databank matches found for 70 names. sanityCheck: position 61:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 86:Dargah over 7km away from neighbors(15.6,15.28) processed 216M.csv, 7 url matches, 5 name matches mapExactFunc: Databank matches found for 51 names. sanityCheck: position 24:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 44:Dargah over 7km away from neighbors(15.28,15.6) processed 216MI.csv, 4 url matches, 6 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 9:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 32:Dargah over 7km away from neighbors(15.6,15.28) processed 216U.csv, 12 url matches, 5 name matches mapExactFunc: Databank matches found for 35 names. sanityCheck: position 13:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 44:Dargah over 7km away from neighbors(15.28,16.0) processed 217.csv, 26 url matches, 19 name matches mapExactFunc: Databank matches found for 68 names. sanityCheck: position 8:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 9:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,17.29) sanityCheck: position 34:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 90:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 116:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 117:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) 320 files processed. processed 217A.csv, 24 url matches, 21 name matches mapExactFunc: Databank matches found for 72 names. sanityCheck: position 7:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 8:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 29:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 106:Dargah over 7km away from neighbors(15.28,15.94) sanityCheck: position 128:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 129:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) processed 217C.csv, 32 url matches, 16 name matches mapExactFunc: Databank matches found for 72 names. sanityCheck: position 33:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 58:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 59:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) sanityCheck: position 76:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 77:Jyothi Nagar over 7km away from neighbors(19.21,16.08) sanityCheck: position 102:Dargah over 7km away from neighbors(15.6,15.28) processed 217D.csv, 37 url matches, 27 name matches mapExactFunc: Databank matches found for 78 names. sanityCheck: position 14:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 15:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 40:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 116:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 142:Jyothi Nagar over 7km away from neighbors(17.53,17.65) sanityCheck: position 143:Ashok Nagar Bus Stop over 7km away from neighbors(28.64,30.02) processed 217D_A.csv, 37 url matches, 21 name matches mapExactFunc: Databank matches found for 76 names. sanityCheck: position 40:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 66:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 67:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) sanityCheck: position 83:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 84:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 108:Dargah over 7km away from neighbors(15.34,15.29) processed 217D_L.csv, 46 url matches, 12 name matches mapExactFunc: Databank matches found for 52 names. sanityCheck: position 38:Dargah over 7km away from neighbors(15.28,15.6) sanityCheck: position 87:Dargah over 7km away from neighbors(15.6,15.28) processed 217M.csv, 7 url matches, 7 name matches mapExactFunc: Databank matches found for 67 names. sanityCheck: position 4:St. Anns School Bus Stop over 7km away from neighbors(22.06,22.09) sanityCheck: position 26:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 65:Dargah over 7km away from neighbors(15.28,15.94) processed 217X.csv, 12 url matches, 15 name matches mapExactFunc: Databank matches found for 72 names. sanityCheck: position 25:Dargah over 7km away from neighbors(15.28,16.0) sanityCheck: position 64:St. Anns School Bus Stop over 7km away from neighbors(22.06,22.09) sanityCheck: position 86:Dargah over 7km away from neighbors(15.34,15.29) processed 218.csv, 81 url matches, 25 name matches mapExactFunc: Databank matches found for 16 names. sanityCheck: position 8:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 9:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 114:Jyothi Nagar over 7km away from neighbors(17.29,17.65) sanityCheck: position 115:Ashok Nagar Bus Stop over 7km away from neighbors(28.39,30.02) processed 218C.csv, 88 url matches, 20 name matches mapExactFunc: Databank matches found for 16 names. sanityCheck: position 60:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 61:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) processed 218D_L.csv, 54 url matches, 18 name matches mapExactFunc: Databank matches found for 50 names. sanityCheck: position 53:Prashanth Nagar over 7km away from neighbors(12.69,13.33) sanityCheck: position 90:Prashanth Nagar over 7km away from neighbors(13.33,12.69) processed 218HG.csv, 104 url matches, 28 name matches mapExactFunc: Databank matches found for 46 names. sanityCheck: position 77:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 78:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) sanityCheck: position 109:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 110:Jyothi Nagar over 7km away from neighbors(19.21,16.08) processed 218L.csv, 106 url matches, 16 name matches mapExactFunc: Databank matches found for 0 names. processed 218L_V.csv, 100 url matches, 21 name matches mapExactFunc: Databank matches found for 28 names. sanityCheck: position 68:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 218_19M.csv, 88 url matches, 16 name matches mapExactFunc: Databank matches found for 24 names. sanityCheck: position 50:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 51:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) sanityCheck: position 80:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 81:Jyothi Nagar over 7km away from neighbors(19.21,16.08) processed 219_229.csv, 80 url matches, 25 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 8:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 9:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 104:Prashanth Nagar over 7km away from neighbors(12.69,13.33) sanityCheck: position 128:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 129:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) processed 21B.csv, 21 url matches, 5 name matches mapExactFunc: Databank matches found for 4 names. processed 21W.csv, 21 url matches, 5 name matches mapExactFunc: Databank matches found for 5 names. processed 21W_107J.csv, 31 url matches, 10 name matches mapExactFunc: Databank matches found for 49 names. sanityCheck: position 29:Bakaram over 7km away from neighbors(24.22,23.66) sanityCheck: position 75:Amberpet Bus Stop over 7km away from neighbors(43.86,43.33) processed 21W_2017J.csv, 32 url matches, 10 name matches mapExactFunc: Databank matches found for 35 names. sanityCheck: position 29:Bakaram over 7km away from neighbors(24.22,23.66) sanityCheck: position 58:Amberpet Bus Stop over 7km away from neighbors(43.86,43.33) processed 21_107J.csv, 25 url matches, 8 name matches mapExactFunc: Databank matches found for 47 names. sanityCheck: position 27:Bakaram over 7km away from neighbors(24.22,23.66) sanityCheck: position 68:Amberpet Bus Stop over 7km away from neighbors(43.86,36.89) 340 files processed. processed 220V.csv, 5 url matches, 12 name matches mapExactFunc: Databank matches found for 30 names. sanityCheck: position 12:Hanuman Temple over 7km away from neighbors(16.38,18.19) sanityCheck: position 43:Hanuman Temple over 7km away from neighbors(18.19,15.31) processed 222A.csv, 52 url matches, 12 name matches mapExactFunc: Databank matches found for 48 names. sanityCheck: position 16:Minerva Bus Stop over 7km away from neighbors(13.64,12.35) sanityCheck: position 129:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 130:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) processed 222L.csv, 65 url matches, 11 name matches mapExactFunc: Databank matches found for 49 names. sanityCheck: position 98:Minerva Bus Stop over 7km away from neighbors(13.64,12.35) processed 222P.csv, 68 url matches, 14 name matches mapExactFunc: Databank matches found for 72 names. sanityCheck: position 86:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 87:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) sanityCheck: position 104:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 105:Jyothi Nagar over 7km away from neighbors(19.21,16.08) processed 223A.csv, 83 url matches, 28 name matches mapExactFunc: Databank matches found for 18 names. sanityCheck: position 7:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 8:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 124:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 125:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) processed 223G.csv, 26 url matches, 9 name matches mapExactFunc: Databank matches found for 45 names. sanityCheck: position 4:St. Anns School Bus Stop over 7km away from neighbors(22.06,22.09) processed 223J.csv, 31 url matches, 19 name matches mapExactFunc: Databank matches found for 30 names. sanityCheck: position 16:Prashanth Nagar over 7km away from neighbors(12.69,13.33) sanityCheck: position 35:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 36:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) sanityCheck: position 51:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 52:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) processed 223JG.csv, 38 url matches, 18 name matches mapExactFunc: Databank matches found for 42 names. sanityCheck: position 20:Prashanth Nagar over 7km away from neighbors(12.69,13.33) sanityCheck: position 44:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 45:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) sanityCheck: position 62:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 63:Jyothi Nagar over 7km away from neighbors(19.21,16.08) sanityCheck: position 87:Prashanth Nagar over 7km away from neighbors(13.33,12.69) processed 223R.csv, 70 url matches, 25 name matches mapExactFunc: Databank matches found for 18 names. sanityCheck: position 7:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 8:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 106:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 107:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) processed 223S.csv, 41 url matches, 17 name matches mapExactFunc: Databank matches found for 16 names. sanityCheck: position 2:Allwyn Colony over 7km away from neighbors(10.61,9.9) sanityCheck: position 47:St. Anns School Bus Stop over 7km away from neighbors(22.06,22.09) sanityCheck: position 73:Allwyn Colony over 7km away from neighbors(9.82,10.61) processed 224G.csv, 1 url matches, 0 name matches mapExactFunc: Databank matches found for 23 names. processed 224H.csv, 64 url matches, 20 name matches mapExactFunc: Databank matches found for 11 names. sanityCheck: position 51:HMT Colony over 7km away from neighbors(10.09,12.08) sanityCheck: position 57:HMT Colony over 7km away from neighbors(12.08,10.09) processed 224K.csv, 34 url matches, 7 name matches mapExactFunc: Databank matches found for 9 names. processed 224S.csv, 39 url matches, 14 name matches mapExactFunc: Databank matches found for 23 names. sanityCheck: position 19:Prashanth Nagar over 7km away from neighbors(12.69,13.33) sanityCheck: position 50:Ida over 7km away from neighbors(11.98,21.12) sanityCheck: position 52:Police Station over 7km away from neighbors(14.63,32.15) processed 224_113K.csv, 44 url matches, 26 name matches mapExactFunc: Databank matches found for 48 names. sanityCheck: position 16:Gandhi Statue over 7km away from neighbors(24.66,41.36) sanityCheck: position 17:Amberpet over 7km away from neighbors(42.98,43.33) sanityCheck: position 122:Amberpet over 7km away from neighbors(43.33,41.36) sanityCheck: position 123:Gandhi Statue over 7km away from neighbors(23.69,24.66) processed 224_187D_V.csv, 90 url matches, 14 name matches mapExactFunc: Databank matches found for 16 names. processed 224_205F.csv, 88 url matches, 16 name matches mapExactFunc: Databank matches found for 52 names. sanityCheck: position 6:Check Post over 7km away from neighbors(37.36,36.71) sanityCheck: position 11:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 154:RTC Colony Bus Stop over 7km away from neighbors(9.5,10.53) sanityCheck: position 159:Check Post over 7km away from neighbors(36.71,37.36) processed 224_226.csv, 47 url matches, 12 name matches mapExactFunc: Databank matches found for 13 names. sanityCheck: position 60:Prashanth Nagar over 7km away from neighbors(12.69,13.33) processed 225A.csv, 69 url matches, 26 name matches mapExactFunc: Databank matches found for 21 names. sanityCheck: position 7:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 8:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 111:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 112:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) processed 225C.csv, 20 url matches, 12 name matches mapExactFunc: Databank matches found for 30 names. sanityCheck: position 10:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 61:Dargah over 7km away from neighbors(15.29,15.34) 360 files processed. processed 225D.csv, 80 url matches, 31 name matches mapExactFunc: Databank matches found for 16 names. sanityCheck: position 9:St. Anns School Bus Stop over 7km away from neighbors(22.06,22.09) processed 225HP.csv, 70 url matches, 26 name matches mapExactFunc: Databank matches found for 22 names. sanityCheck: position 7:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 8:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 119:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 120:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) processed 225L_299.csv, 100 url matches, 23 name matches mapExactFunc: Databank matches found for 40 names. sanityCheck: position 2:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 161:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 171:RTC Colony over 7km away from neighbors(9.72,10.48) processed 225L_V.csv, 100 url matches, 23 name matches mapExactFunc: Databank matches found for 28 names. sanityCheck: position 69:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 225M.csv, 64 url matches, 17 name matches mapExactFunc: Databank matches found for 16 names. sanityCheck: position 54:St. Anns School Bus Stop over 7km away from neighbors(22.06,22.09) processed 225S.csv, 70 url matches, 27 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 9:St. Anns School Bus Stop over 7km away from neighbors(22.06,22.09) processed 226.csv, 58 url matches, 18 name matches mapExactFunc: Databank matches found for 20 names. sanityCheck: position 20:Prashanth Nagar over 7km away from neighbors(12.69,13.33) processed 226A.csv, 51 url matches, 22 name matches mapExactFunc: Databank matches found for 25 names. sanityCheck: position 7:Ashok Nagar Bus Stop over 7km away from neighbors(30.02,17.65) sanityCheck: position 8:Jyothi Nagar Bus Stop over 7km away from neighbors(19.21,16.08) sanityCheck: position 70:Prashanth Nagar over 7km away from neighbors(12.69,13.33) sanityCheck: position 94:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 95:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) processed 226C.csv, 43 url matches, 13 name matches mapExactFunc: Databank matches found for 18 names. sanityCheck: position 4:St. Anns School Bus Stop over 7km away from neighbors(22.06,22.09) sanityCheck: position 54:Prashanth Nagar over 7km away from neighbors(12.69,13.33) processed 226E.csv, 56 url matches, 23 name matches mapExactFunc: Databank matches found for 27 names. sanityCheck: position 9:St. Anns School Bus Stop over 7km away from neighbors(22.06,22.09) processed 226L_229.csv, 82 url matches, 18 name matches mapExactFunc: Databank matches found for 14 names. sanityCheck: position 97:Prashanth Nagar over 7km away from neighbors(12.69,13.33) processed 226M.csv, 48 url matches, 13 name matches mapExactFunc: Databank matches found for 20 names. sanityCheck: position 4:St. Anns School Bus Stop over 7km away from neighbors(22.06,22.09) sanityCheck: position 63:Prashanth Nagar over 7km away from neighbors(12.1,13.33) processed 227.csv, 26 url matches, 5 name matches mapExactFunc: Databank matches found for 26 names. processed 228.csv, 37 url matches, 3 name matches mapExactFunc: Databank matches found for 8 names. processed 229B.csv, 34 url matches, 9 name matches mapExactFunc: Databank matches found for 16 names. sanityCheck: position 24:Temple over 7km away from neighbors(20.31,17.24) processed 229D.csv, 47 url matches, 7 name matches mapExactFunc: Databank matches found for 23 names. processed 229G.csv, 44 url matches, 5 name matches mapExactFunc: Databank matches found for 10 names. processed 229M.csv, 43 url matches, 7 name matches mapExactFunc: Databank matches found for 23 names. processed 229R.csv, 41 url matches, 5 name matches mapExactFunc: Databank matches found for 11 names. processed 229T.csv, 6 url matches, 2 name matches mapExactFunc: Databank matches found for 6 names. 380 files processed. processed 229V.csv, 37 url matches, 7 name matches mapExactFunc: Databank matches found for 10 names. processed 229X.csv, 50 url matches, 10 name matches mapExactFunc: Databank matches found for 24 names. processed 22D.csv, 25 url matches, 10 name matches mapExactFunc: Databank matches found for 6 names. sanityCheck: position 44:water tank bus stop over 7km away from neighbors(13.17,14.94) processed 22K.csv, 26 url matches, 9 name matches mapExactFunc: Databank matches found for 4 names. sanityCheck: position 19:water tank bus stop over 7km away from neighbors(13.17,14.94) processed 22M.csv, 23 url matches, 8 name matches mapExactFunc: Databank matches found for 8 names. processed 22S.csv, 45 url matches, 12 name matches mapExactFunc: Databank matches found for 19 names. sanityCheck: position 42:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 47:Allwyn Colony over 7km away from neighbors(10.61,9.9) processed 22_219L.csv, 55 url matches, 18 name matches mapExactFunc: Databank matches found for 30 names. sanityCheck: position 3:Hanuman Temple over 7km away from neighbors(7.98,7.1) sanityCheck: position 5:water tank bus stop over 7km away from neighbors(14.43,13.53) sanityCheck: position 9:Golnaka Bus Stop over 7km away from neighbors(12.98,12.69) sanityCheck: position 31:Prashanth Nagar over 7km away from neighbors(12.69,13.33) sanityCheck: position 104:Water Tank over 7km away from neighbors(9.04,9.92) processed 23.csv, 12 url matches, 4 name matches mapExactFunc: Databank matches found for 3 names. sanityCheck: position 1:Teachers Colony Bus Stop over 7km away from neighbors(23.44,17.94) processed 230A.csv, 16 url matches, 9 name matches mapExactFunc: Databank matches found for 34 names. processed 230D.csv, 17 url matches, 8 name matches mapExactFunc: Databank matches found for 34 names. processed 230G.csv, 13 url matches, 8 name matches mapExactFunc: Databank matches found for 31 names. processed 230N.csv, 15 url matches, 7 name matches mapExactFunc: Databank matches found for 38 names. sanityCheck: position 9:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 64:Allwyn Colony over 7km away from neighbors(10.61,9.9) processed 230P.csv, 22 url matches, 8 name matches mapExactFunc: Databank matches found for 39 names. processed 230V.csv, 14 url matches, 8 name matches mapExactFunc: Databank matches found for 33 names. processed 230X.csv, 34 url matches, 18 name matches mapExactFunc: Databank matches found for 34 names. sanityCheck: position 20:Prashanth Nagar over 7km away from neighbors(12.1,13.05) processed 231.csv, 25 url matches, 9 name matches mapExactFunc: Databank matches found for 8 names. sanityCheck: position 15:Prashanth Nagar over 7km away from neighbors(12.69,14.17) processed 231B.csv, 25 url matches, 12 name matches mapExactFunc: Databank matches found for 22 names. sanityCheck: position 2:Rajivgandhi Nagar over 7km away from neighbors(10.55,9.03) sanityCheck: position 45:Prashanth Nagar over 7km away from neighbors(12.69,13.33) sanityCheck: position 59:Rajivgandhi Nagar over 7km away from neighbors(9.03,10.55) processed 233.csv, 2 url matches, 0 name matches mapExactFunc: Databank matches found for 8 names. processed 234.csv, 2 url matches, 0 name matches mapExactFunc: Databank matches found for 6 names. processed 235G.csv, 43 url matches, 8 name matches mapExactFunc: Databank matches found for 8 names. 400 files processed. processed 236.csv, 7 url matches, 9 name matches mapExactFunc: Databank matches found for 50 names. sanityCheck: position 20:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.12) processed 23B.csv, 19 url matches, 6 name matches mapExactFunc: Databank matches found for 4 names. processed 24.csv, 12 url matches, 5 name matches mapExactFunc: Databank matches found for 11 names. processed 241T.csv, 53 url matches, 11 name matches mapExactFunc: Databank matches found for 1 names. sanityCheck: position 54:Upparguda X Road over 7km away from neighbors(28.06,28.71) processed 242.csv, 61 url matches, 12 name matches mapExactFunc: Databank matches found for 3 names. sanityCheck: position 14:Upparguda X Road over 7km away from neighbors(28.06,28.71) processed 242A.csv, 59 url matches, 11 name matches mapExactFunc: Databank matches found for 2 names. sanityCheck: position 55:Upparguda X Road over 7km away from neighbors(28.06,28.71) processed 242B.csv, 67 url matches, 15 name matches mapExactFunc: Databank matches found for 4 names. sanityCheck: position 1:Chakripuram over 7km away from neighbors(11.09,10.08) sanityCheck: position 61:Upparguda X Road over 7km away from neighbors(28.06,28.71) sanityCheck: position 92:Chakripuram over 7km away from neighbors(10.39,11.09) processed 245.csv, 7 url matches, 8 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 54:ECIL X Road over 7km away from neighbors(10.42,11.4) processed 245A.csv, 7 url matches, 8 name matches mapExactFunc: Databank matches found for 34 names. sanityCheck: position 53:ECIL X Road over 7km away from neighbors(10.42,11.4) processed 245J.csv, 4 url matches, 5 name matches mapExactFunc: Databank matches found for 48 names. sanityCheck: position 7:Gandhi Statue over 7km away from neighbors(24.23,24.66) sanityCheck: position 31:ECIL X Road over 7km away from neighbors(10.42,11.4) processed 24B.csv, 19 url matches, 9 name matches mapExactFunc: Databank matches found for 27 names. processed 24E.csv, 15 url matches, 7 name matches mapExactFunc: Databank matches found for 26 names. processed 250H.csv, 9 url matches, 5 name matches mapExactFunc: Databank matches found for 24 names. processed 250P.csv, 15 url matches, 6 name matches mapExactFunc: Databank matches found for 27 names. processed 250S.csv, 5 url matches, 5 name matches mapExactFunc: Databank matches found for 32 names. processed 251.csv, 0 url matches, 1 name matches mapExactFunc: Databank matches found for 38 names. processed 251A.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 36 names. processed 251B.csv, 3 url matches, 2 name matches mapExactFunc: Databank matches found for 43 names. processed 251J.csv, 14 url matches, 6 name matches mapExactFunc: Databank matches found for 70 names. sanityCheck: position 71:Bakaram over 7km away from neighbors(24.22,22.66) processed 251K.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 36 names. 420 files processed. processed 251L.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 37 names. processed 251M.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 33 names. processed 251N.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 42 names. processed 251S.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 35 names. processed 252.csv, 11 url matches, 2 name matches mapExactFunc: Databank matches found for 51 names. processed 252D.csv, 10 url matches, 3 name matches mapExactFunc: Databank matches found for 41 names. processed 252H.csv, 2 url matches, 9 name matches mapExactFunc: Databank matches found for 37 names. sanityCheck: position 44:Dairy Farm Bus Stop over 7km away from neighbors(12.52,15.12) processed 252N.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 37 names. processed 253G.csv, 5 url matches, 0 name matches mapExactFunc: Databank matches found for 46 names. processed 253H.csv, 4 url matches, 0 name matches mapExactFunc: Databank matches found for 42 names. processed 253M.csv, 5 url matches, 0 name matches mapExactFunc: Databank matches found for 61 names. processed 254.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 45 names. processed 254M.csv, 4 url matches, 0 name matches mapExactFunc: Databank matches found for 38 names. processed 25B.csv, 19 url matches, 6 name matches mapExactFunc: Databank matches found for 20 names. processed 25J.csv, 20 url matches, 6 name matches mapExactFunc: Databank matches found for 18 names. processed 25S.csv, 24 url matches, 9 name matches mapExactFunc: Databank matches found for 19 names. processed 25S_90L.csv, 30 url matches, 14 name matches mapExactFunc: Databank matches found for 45 names. sanityCheck: position 89:Junior College over 7km away from neighbors(26.56,27.73) processed 26.csv, 13 url matches, 3 name matches mapExactFunc: Databank matches found for 17 names. processed 26D.csv, 12 url matches, 4 name matches mapExactFunc: Databank matches found for 17 names. processed 26M.csv, 9 url matches, 1 name matches mapExactFunc: Databank matches found for 20 names. 440 files processed. processed 26N.csv, 7 url matches, 2 name matches mapExactFunc: Databank matches found for 17 names. processed 272.csv, 16 url matches, 6 name matches mapExactFunc: Databank matches found for 44 names. processed 272C.csv, 34 url matches, 14 name matches mapExactFunc: Databank matches found for 40 names. sanityCheck: position 21:Prashanth Nagar over 7km away from neighbors(12.1,13.05) processed 272K.csv, 13 url matches, 8 name matches mapExactFunc: Databank matches found for 32 names. sanityCheck: position 22:Prashanth Nagar over 7km away from neighbors(12.1,13.05) processed 272M.csv, 12 url matches, 9 name matches mapExactFunc: Databank matches found for 32 names. processed 272S.csv, 14 url matches, 7 name matches mapExactFunc: Databank matches found for 31 names. processed 277.csv, 3 url matches, 2 name matches mapExactFunc: Databank matches found for 62 names. sanityCheck: position 1:Ambedkar Statue over 7km away from neighbors(38.7,35.31) sanityCheck: position 85:Ambedkar Statue over 7km away from neighbors(35.31,38.16) processed 277B.csv, 8 url matches, 2 name matches mapExactFunc: Databank matches found for 64 names. sanityCheck: position 1:Ambedkar Statue over 7km away from neighbors(38.7,35.31) sanityCheck: position 93:Ambedkar Statue over 7km away from neighbors(35.31,38.16) processed 277D.csv, 11 url matches, 3 name matches mapExactFunc: Databank matches found for 55 names. sanityCheck: position 40:Ambedkar Statue over 7km away from neighbors(35.31,38.16) sanityCheck: position 43:Ambedkar Statue over 7km away from neighbors(38.16,35.31) processed 277I.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 53 names. sanityCheck: position 1:Ambedkar Statue over 7km away from neighbors(38.16,35.31) sanityCheck: position 63:Ambedkar Statue over 7km away from neighbors(35.31,38.16) processed 277K.csv, 8 url matches, 2 name matches mapExactFunc: Databank matches found for 55 names. processed 277M.csv, 7 url matches, 2 name matches mapExactFunc: Databank matches found for 44 names. processed 277N.csv, 8 url matches, 2 name matches mapExactFunc: Databank matches found for 49 names. processed 277P.csv, 2 url matches, 0 name matches mapExactFunc: Databank matches found for 105 names. sanityCheck: position 6:Balaji Nagar over 7km away from neighbors(14.03,15.32) sanityCheck: position 10:Bustop over 7km away from neighbors(33.23,36.32) sanityCheck: position 27:Ibrahimpatnam Chowrasta over 7km away from neighbors(7.34,37.9) sanityCheck: position 28:Ambedkar Statue over 7km away from neighbors(38.23,35.31) sanityCheck: position 106:Ambedkar Statue over 7km away from neighbors(35.31,37.9) sanityCheck: position 126:Bustop over 7km away from neighbors(36.36,33.68) sanityCheck: position 131:Balaji Nagar over 7km away from neighbors(15.32,14.03) processed 277U.csv, 5 url matches, 0 name matches mapExactFunc: Databank matches found for 49 names. processed 277W.csv, 5 url matches, 0 name matches mapExactFunc: Databank matches found for 40 names. processed 277Y.csv, 8 url matches, 2 name matches mapExactFunc: Databank matches found for 12 names. processed 278.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 50 names. sanityCheck: position 1:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 47:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 56:RTC Colony Bus Stop over 7km away from neighbors(9.19,10.48) processed 279.csv, 6 url matches, 4 name matches mapExactFunc: Databank matches found for 65 names. sanityCheck: position 1:Ambedkar Statue over 7km away from neighbors(38.7,35.31) sanityCheck: position 55:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 94:Ambedkar Statue over 7km away from neighbors(35.31,38.16) processed 28.csv, 8 url matches, 5 name matches mapExactFunc: Databank matches found for 1 names. 460 files processed. processed 280.csv, 10 url matches, 9 name matches mapExactFunc: Databank matches found for 43 names. sanityCheck: position 12:Kamala Nagar over 7km away from neighbors(9.53,9.27) sanityCheck: position 48:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 61:Kamala Nagar over 7km away from neighbors(9.27,9.53) sanityCheck: position 71:ECIL X Road over 7km away from neighbors(10.42,11.4) processed 280B.csv, 10 url matches, 9 name matches mapExactFunc: Databank matches found for 47 names. sanityCheck: position 4:Kondapur over 7km away from neighbors(34.22,33.42) sanityCheck: position 20:Kamala Nagar over 7km away from neighbors(9.53,9.27) sanityCheck: position 56:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 69:Kamala Nagar over 7km away from neighbors(9.27,9.53) sanityCheck: position 79:ECIL X Road over 7km away from neighbors(10.42,11.4) sanityCheck: position 86:Kondapur over 7km away from neighbors(33.42,34.22) processed 280C.csv, 4 url matches, 16 name matches mapExactFunc: Databank matches found for 56 names. sanityCheck: position 64:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.12) sanityCheck: position 87:ECIL X Road over 7km away from neighbors(10.42,11.4) processed 280E.csv, 6 url matches, 7 name matches mapExactFunc: Databank matches found for 59 names. sanityCheck: position 2:Mandal Office over 7km away from neighbors(43.44,19.56) sanityCheck: position 3:Ghatkesar (Ambedkar Nagar) over 7km away from neighbors(27.5,25.03) sanityCheck: position 16:Kamala Nagar over 7km away from neighbors(9.53,9.27) sanityCheck: position 61:Gandhi Statue over 7km away from neighbors(24.23,24.66) sanityCheck: position 80:Kamala Nagar over 7km away from neighbors(9.27,10.01) sanityCheck: position 89:ECIL X Road over 7km away from neighbors(10.42,11.4) sanityCheck: position 93:Ghatkesar (Ambedkar Nagar) over 7km away from neighbors(25.03,19.56) sanityCheck: position 94:Mandal Office over 7km away from neighbors(40.97,43.44) processed 280N.csv, 15 url matches, 8 name matches mapExactFunc: Databank matches found for 47 names. sanityCheck: position 13:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 26:Kamala Nagar over 7km away from neighbors(9.27,9.53) sanityCheck: position 36:ECIL X Road over 7km away from neighbors(10.42,11.4) sanityCheck: position 40:Ghatkesar (Ambedkar Nagar) over 7km away from neighbors(25.03,19.56) sanityCheck: position 41:Mandal Office over 7km away from neighbors(40.97,43.44) sanityCheck: position 46:Mandal Office over 7km away from neighbors(43.44,19.56) sanityCheck: position 47:Ghatkesar (Ambedkar Nagar) over 7km away from neighbors(27.5,25.03) sanityCheck: position 60:Kamala Nagar over 7km away from neighbors(9.53,9.27) processed 280R.csv, 5 url matches, 6 name matches mapExactFunc: Databank matches found for 27 names. sanityCheck: position 32:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 280S.csv, 14 url matches, 10 name matches mapExactFunc: Databank matches found for 47 names. sanityCheck: position 13:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 26:Kamala Nagar over 7km away from neighbors(9.27,9.53) sanityCheck: position 36:ECIL X Road over 7km away from neighbors(10.42,11.4) sanityCheck: position 40:Ghatkesar (Ambedkar Nagar) over 7km away from neighbors(25.03,19.56) sanityCheck: position 41:Mandal Office over 7km away from neighbors(40.97,43.44) sanityCheck: position 46:Mandal Office over 7km away from neighbors(43.44,19.56) sanityCheck: position 47:Ghatkesar (Ambedkar Nagar) over 7km away from neighbors(27.5,25.03) sanityCheck: position 60:Kamala Nagar over 7km away from neighbors(9.53,9.27) processed 280T.csv, 5 url matches, 5 name matches mapExactFunc: Databank matches found for 40 names. sanityCheck: position 8:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 281P.csv, 46 url matches, 11 name matches mapExactFunc: Databank matches found for 20 names. sanityCheck: position 13:Upparguda X Road over 7km away from neighbors(28.06,28.71) processed 283.csv, 3 url matches, 5 name matches mapExactFunc: Databank matches found for 56 names. sanityCheck: position 6:Balaji Nagar over 7km away from neighbors(15.32,14.03) sanityCheck: position 13:Kamala Nagar over 7km away from neighbors(9.53,9.27) sanityCheck: position 54:Gandhi Statue over 7km away from neighbors(24.23,24.66) sanityCheck: position 73:Kamala Nagar over 7km away from neighbors(9.27,9.53) sanityCheck: position 80:Balaji Nagar over 7km away from neighbors(14.03,15.32) sanityCheck: position 84:Bustop over 7km away from neighbors(33.23,36.32) processed 283A.csv, 17 url matches, 11 name matches mapExactFunc: Databank matches found for 30 names. sanityCheck: position 60:Prashanth Nagar over 7km away from neighbors(12.69,13.05) processed 283D.csv, 40 url matches, 12 name matches mapExactFunc: Databank matches found for 44 names. sanityCheck: position 25:Allwyn Colony over 7km away from neighbors(10.61,9.9) sanityCheck: position 90:Allwyn Colony over 7km away from neighbors(9.82,10.61) processed 283K.csv, 5 url matches, 6 name matches mapExactFunc: Databank matches found for 50 names. sanityCheck: position 10:Gandhi Statue over 7km away from neighbors(24.23,24.66) sanityCheck: position 32:Balaji Nagar over 7km away from neighbors(14.03,15.32) sanityCheck: position 42:Balaji Nagar over 7km away from neighbors(15.32,14.03) processed 283N.csv, 43 url matches, 21 name matches mapExactFunc: Databank matches found for 50 names. sanityCheck: position 18:Prashanth Nagar over 7km away from neighbors(12.69,13.05) sanityCheck: position 83:Bakaram over 7km away from neighbors(24.22,22.66) processed 283P.csv, 5 url matches, 6 name matches mapExactFunc: Databank matches found for 50 names. sanityCheck: position 10:Gandhi Statue over 7km away from neighbors(24.23,24.66) sanityCheck: position 32:Balaji Nagar over 7km away from neighbors(14.03,15.32) sanityCheck: position 42:Balaji Nagar over 7km away from neighbors(15.32,14.03) processed 283S.csv, 14 url matches, 9 name matches mapExactFunc: Databank matches found for 34 names. processed 283T.csv, 4 url matches, 5 name matches mapExactFunc: Databank matches found for 29 names. sanityCheck: position 11:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 284P.csv, 4 url matches, 3 name matches mapExactFunc: Databank matches found for 27 names. sanityCheck: position 9:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 284S.csv, 4 url matches, 3 name matches mapExactFunc: Databank matches found for 36 names. sanityCheck: position 8:Bakaram over 7km away from neighbors(24.22,23.66) sanityCheck: position 18:Gandhi Statue over 7km away from neighbors(24.23,24.66) processed 287N.csv, 53 url matches, 20 name matches mapExactFunc: Databank matches found for 17 names. sanityCheck: position 2:Rajivgandhi Nagar over 7km away from neighbors(10.55,9.03) 480 files processed. processed 288A.csv, 2 url matches, 7 name matches mapExactFunc: Databank matches found for 29 names. sanityCheck: position 15:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) sanityCheck: position 36:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 38:Bandlaguda Bus Stop over 7km away from neighbors(18.46,19.34) processed 288B.csv, 2 url matches, 7 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 10:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 13:Bandlaguda Bus Stop over 7km away from neighbors(18.84,20.3) sanityCheck: position 47:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) processed 288C.csv, 2 url matches, 7 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 9:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 11:Bandlaguda Bus Stop over 7km away from neighbors(18.46,20.3) sanityCheck: position 23:Mile Stone over 7km away from neighbors(44.21,49.82) sanityCheck: position 26:Mile Stone over 7km away from neighbors(49.82,44.21) sanityCheck: position 40:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) processed 288D.csv, 2 url matches, 7 name matches mapExactFunc: Databank matches found for 32 names. sanityCheck: position 10:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 27:Himayath Nagar Bus Stop over 7km away from neighbors(18.07,20.15) sanityCheck: position 50:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) processed 288H.csv, 21 url matches, 17 name matches mapExactFunc: Databank matches found for 22 names. sanityCheck: position 4:Bandlaguda over 7km away from neighbors(30.51,28.4) sanityCheck: position 6:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) sanityCheck: position 61:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 63:Bandlaguda Bus Stop over 7km away from neighbors(18.46,20.3) processed 288K.csv, 20 url matches, 16 name matches mapExactFunc: Databank matches found for 35 names. sanityCheck: position 17:Bandlaguda over 7km away from neighbors(30.51,28.92) sanityCheck: position 20:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) sanityCheck: position 78:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 81:Bandlaguda over 7km away from neighbors(28.92,30.51) sanityCheck: position 95:Himayath Nagar Bus Stop over 7km away from neighbors(18.07,20.15) processed 288N.csv, 2 url matches, 7 name matches mapExactFunc: Databank matches found for 27 names. sanityCheck: position 12:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) sanityCheck: position 33:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) processed 288P.csv, 1 url matches, 7 name matches mapExactFunc: Databank matches found for 29 names. sanityCheck: position 17:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) sanityCheck: position 38:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 40:Bandlaguda Bus Stop over 7km away from neighbors(18.46,19.34) processed 288R.csv, 1 url matches, 7 name matches mapExactFunc: Databank matches found for 34 names. sanityCheck: position 10:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 12:Bandlaguda Bus Stop over 7km away from neighbors(18.46,19.34) sanityCheck: position 53:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) processed 288S.csv, 2 url matches, 7 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 9:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 11:Bandlaguda Bus Stop over 7km away from neighbors(18.46,19.34) sanityCheck: position 48:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) processed 288X.csv, 1 url matches, 7 name matches mapExactFunc: Databank matches found for 37 names. sanityCheck: position 9:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 11:Bandlaguda Bus Stop over 7km away from neighbors(18.46,20.3) sanityCheck: position 21:Himayath Nagar Bus Stop over 7km away from neighbors(18.07,21.56) sanityCheck: position 47:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) processed 288Y.csv, 2 url matches, 7 name matches mapExactFunc: Databank matches found for 31 names. sanityCheck: position 25:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) sanityCheck: position 48:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 51:Bandlaguda Bus Stop over 7km away from neighbors(18.84,19.34) processed 288Z.csv, 1 url matches, 7 name matches mapExactFunc: Databank matches found for 27 names. sanityCheck: position 12:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) sanityCheck: position 31:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 33:Bandlaguda Bus Stop over 7km away from neighbors(18.46,20.3) processed 289M.csv, 46 url matches, 11 name matches mapExactFunc: Databank matches found for 23 names. sanityCheck: position 16:Prashanth Nagar over 7km away from neighbors(12.1,13.05) processed 29.csv, 11 url matches, 5 name matches mapExactFunc: Databank matches found for 21 names. processed 290A.csv, 9 url matches, 5 name matches mapExactFunc: Databank matches found for 70 names. sanityCheck: position 23:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 32:RTC Colony over 7km away from neighbors(9.19,10.48) sanityCheck: position 67:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) processed 290B.csv, 9 url matches, 5 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 38:Bandlaguda X Road over 7km away from neighbors(18.69,19.77) processed 290F.csv, 10 url matches, 6 name matches mapExactFunc: Databank matches found for 64 names. sanityCheck: position 15:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 30:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 41:RTC Colony over 7km away from neighbors(9.72,10.48) sanityCheck: position 54:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) processed 290J.csv, 14 url matches, 7 name matches mapExactFunc: Databank matches found for 42 names. sanityCheck: position 1:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 62:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 70:RTC Colony over 7km away from neighbors(9.19,10.48) processed 290K.csv, 11 url matches, 5 name matches mapExactFunc: Databank matches found for 56 names. sanityCheck: position 1:Koheda X Road over 7km away from neighbors(7.96,9.78) sanityCheck: position 10:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 64:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 73:RTC Colony over 7km away from neighbors(9.19,10.48) 500 files processed. processed 290Q.csv, 11 url matches, 5 name matches mapExactFunc: Databank matches found for 48 names. sanityCheck: position 50:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 67:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 290S.csv, 11 url matches, 5 name matches mapExactFunc: Databank matches found for 64 names. sanityCheck: position 2:Koheda X Road over 7km away from neighbors(10.01,7.79) sanityCheck: position 60:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 78:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 96:Koheda X Road over 7km away from neighbors(7.79,9.37) processed 290T.csv, 6 url matches, 4 name matches mapExactFunc: Databank matches found for 48 names. sanityCheck: position 23:Check Post Bus Stop over 7km away from neighbors(30.96,31.45) sanityCheck: position 32:RTC Colony over 7km away from neighbors(9.19,10.48) sanityCheck: position 35:RTC Colony over 7km away from neighbors(10.48,9.19) sanityCheck: position 44:Check Post Bus Stop over 7km away from neighbors(31.45,30.96) processed 292.csv, 2 url matches, 7 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 9:Sairam Nagar Busstop over 7km away from neighbors(22.26,24.77) sanityCheck: position 12:Bandlaguda Bus Stop over 7km away from neighbors(18.84,19.08) sanityCheck: position 28:Venkateswara Colony Bus Stop over 7km away from neighbors(15.41,15.78) sanityCheck: position 32:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) processed 293.csv, 6 url matches, 1 name matches mapExactFunc: Databank matches found for 35 names. processed 293S.csv, 6 url matches, 0 name matches mapExactFunc: Databank matches found for 49 names. sanityCheck: position 28:Koheda X Road over 7km away from neighbors(7.79,9.37) sanityCheck: position 33:Koheda X Road over 7km away from neighbors(10.01,7.79) processed 293T.csv, 14 url matches, 4 name matches mapExactFunc: Databank matches found for 45 names. processed 298.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 21 names. sanityCheck: position 14:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 299.csv, 10 url matches, 2 name matches mapExactFunc: Databank matches found for 38 names. sanityCheck: position 21:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 40:Check Post Bus Stop over 7km away from neighbors(31.82,30.96) processed 299A.csv, 11 url matches, 2 name matches mapExactFunc: Databank matches found for 40 names. sanityCheck: position 23:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 299C.csv, 11 url matches, 2 name matches mapExactFunc: Databank matches found for 40 names. sanityCheck: position 55:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 299D.csv, 1 url matches, 1 name matches mapExactFunc: Databank matches found for 38 names. sanityCheck: position 1:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 37:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 51:RTC Colony over 7km away from neighbors(9.72,10.48) processed 299H.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 17:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 299M.csv, 34 url matches, 10 name matches mapExactFunc: Databank matches found for 40 names. sanityCheck: position 90:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 299P.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 62 names. sanityCheck: position 2:Koheda X Road over 7km away from neighbors(10.01,9.78) sanityCheck: position 14:RTC Colony Bus Stop over 7km away from neighbors(10.53,9.5) sanityCheck: position 61:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 72:RTC Colony over 7km away from neighbors(9.72,10.48) processed 299S.csv, 12 url matches, 2 name matches mapExactFunc: Databank matches found for 25 names. sanityCheck: position 44:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 48:Raithu Bazar Bus Stop over 7km away from neighbors(19.63,21.26) processed 29B.csv, 20 url matches, 6 name matches mapExactFunc: Databank matches found for 22 names. processed 29C.csv, 24 url matches, 14 name matches mapExactFunc: Databank matches found for 20 names. sanityCheck: position 47:Prashanth Nagar over 7km away from neighbors(12.69,13.05) processed 29H.csv, 13 url matches, 5 name matches mapExactFunc: Databank matches found for 25 names. processed 29Q.csv, 12 url matches, 3 name matches mapExactFunc: Databank matches found for 18 names. 520 files processed. processed 29R.csv, 21 url matches, 5 name matches mapExactFunc: Databank matches found for 27 names. processed 29R_272.csv, 20 url matches, 6 name matches mapExactFunc: Databank matches found for 24 names. processed 29S.csv, 8 url matches, 7 name matches mapExactFunc: Databank matches found for 25 names. processed 2C.csv, 4 url matches, 3 name matches mapExactFunc: Databank matches found for 53 names. sanityCheck: position 6:Bakaram over 7km away from neighbors(24.22,23.66) processed 2D.csv, 31 url matches, 12 name matches mapExactFunc: Databank matches found for 42 names. sanityCheck: position 54:water tank bus stop over 7km away from neighbors(14.47,14.94) sanityCheck: position 92:Bakaram over 7km away from neighbors(24.22,23.66) processed 2F.csv, 0 url matches, 6 name matches mapExactFunc: Databank matches found for 22 names. processed 2U.csv, 5 url matches, 3 name matches mapExactFunc: Databank matches found for 43 names. sanityCheck: position 41:Bakaram over 7km away from neighbors(24.22,23.66) processed 2V.csv, 8 url matches, 8 name matches mapExactFunc: Databank matches found for 20 names. processed 2Z.csv, 3 url matches, 6 name matches mapExactFunc: Databank matches found for 71 names. processed 3.csv, 43 url matches, 16 name matches mapExactFunc: Databank matches found for 38 names. sanityCheck: position 24:Dairy Farm Bus Stop over 7km away from neighbors(14.33,15.34) sanityCheck: position 31:Upparguda X Road over 7km away from neighbors(28.06,28.71) processed 30.csv, 22 url matches, 4 name matches mapExactFunc: Databank matches found for 31 names. sanityCheck: position 7:Gandhi Nagar Bus Stop over 7km away from neighbors(24.51,23.91) sanityCheck: position 56:Gandhi Nagar Bus Stop over 7km away from neighbors(23.91,24.51) processed 300.csv, 7 url matches, 9 name matches mapExactFunc: Databank matches found for 74 names. sanityCheck: position 8:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 35:Bandlaguda over 7km away from neighbors(28.15,27.57) sanityCheck: position 54:Maruthi Nagar over 7km away from neighbors(16.87,16.51) sanityCheck: position 61:Laxmi Nagar over 7km away from neighbors(16.37,17.95) sanityCheck: position 79:Bandlaguda over 7km away from neighbors(27.57,28.15) processed 300H.csv, 2 url matches, 2 name matches mapExactFunc: Databank matches found for 68 names. sanityCheck: position 22:Bandlaguda over 7km away from neighbors(27.57,28.15) sanityCheck: position 36:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 55:Check Post Bus Stop over 7km away from neighbors(31.82,30.96) sanityCheck: position 69:Bandlaguda over 7km away from neighbors(28.15,27.57) processed 30A.csv, 26 url matches, 9 name matches mapExactFunc: Databank matches found for 36 names. sanityCheck: position 12:Anjaiah Nagar over 7km away from neighbors(8.27,8.64) sanityCheck: position 20:Gandhi Nagar Bus Stop over 7km away from neighbors(24.51,23.91) sanityCheck: position 61:Gandhi Nagar Bus Stop over 7km away from neighbors(23.91,24.51) sanityCheck: position 67:Anjaiah Nagar over 7km away from neighbors(8.76,8.27) processed 30C.csv, 8 url matches, 6 name matches mapExactFunc: Databank matches found for 21 names. sanityCheck: position 19:Gandhi Nagar Bus Stop over 7km away from neighbors(23.91,24.51) sanityCheck: position 22:Gandhi Nagar Bus Stop over 7km away from neighbors(24.51,23.91) processed 30M.csv, 13 url matches, 5 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 7:Gandhi Nagar Bus Stop over 7km away from neighbors(24.51,23.91) sanityCheck: position 43:Gandhi Nagar Bus Stop over 7km away from neighbors(23.91,24.51) processed 30S.csv, 11 url matches, 4 name matches mapExactFunc: Databank matches found for 31 names. sanityCheck: position 9:Gandhi Nagar Bus Stop over 7km away from neighbors(24.51,23.91) sanityCheck: position 46:Gandhi Nagar Bus Stop over 7km away from neighbors(23.91,24.51) processed 31.csv, 14 url matches, 11 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 2:RTC Colony over 7km away from neighbors(8.22,7.34) sanityCheck: position 55:Dairy Farm Bus Stop over 7km away from neighbors(14.33,15.34) sanityCheck: position 63:Upparguda X Road over 7km away from neighbors(28.06,29.04) processed 31A.csv, 18 url matches, 8 name matches mapExactFunc: Databank matches found for 9 names. sanityCheck: position 34:Prashanth Nagar over 7km away from neighbors(12.69,13.33) processed 31H.csv, 22 url matches, 9 name matches mapExactFunc: Databank matches found for 12 names. sanityCheck: position 15:Prashanth Nagar over 7km away from neighbors(12.69,13.33) sanityCheck: position 23:Road No 1 over 7km away from neighbors(8.98,9.14) 540 files processed. processed 31L.csv, 21 url matches, 8 name matches mapExactFunc: Databank matches found for 14 names. sanityCheck: position 41:Prashanth Nagar over 7km away from neighbors(12.69,13.33) processed 31M.csv, 44 url matches, 13 name matches mapExactFunc: Databank matches found for 14 names. sanityCheck: position 51:Prashanth Nagar over 7km away from neighbors(12.69,13.33) processed 31P.csv, 39 url matches, 13 name matches mapExactFunc: Databank matches found for 21 names. sanityCheck: position 17:Prashanth Nagar over 7km away from neighbors(12.69,13.33) sanityCheck: position 38:Jyothi Nagar over 7km away from neighbors(16.08,17.65) sanityCheck: position 39:Ashok Nagar Bus Stop over 7km away from neighbors(27.86,30.02) sanityCheck: position 42:Ashok Nagar Bus Stop over 7km away from neighbors(30.05,17.65) sanityCheck: position 43:Jyothi Nagar Bus Stop over 7km away from neighbors(19.22,16.08) processed 31V.csv, 33 url matches, 7 name matches mapExactFunc: Databank matches found for 14 names. sanityCheck: position 15:Prashanth Nagar over 7km away from neighbors(12.1,13.33) processed 33S.csv, 24 url matches, 9 name matches mapExactFunc: Databank matches found for 18 names. sanityCheck: position 18:Prashanth Nagar over 7km away from neighbors(12.69,13.33) processed 35.csv, 19 url matches, 7 name matches mapExactFunc: Databank matches found for 70 names. sanityCheck: position 23:Allwyn Colony over 7km away from neighbors(10.61,9.9) sanityCheck: position 38:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) sanityCheck: position 91:Allwyn Colony over 7km away from neighbors(9.82,10.61) processed 36K.csv, 17 url matches, 8 name matches mapExactFunc: Databank matches found for 32 names. sanityCheck: position 38:Jyothi Nagar Bus Stop over 7km away from neighbors(11.58,12.42) processed 37.csv, 11 url matches, 4 name matches mapExactFunc: Databank matches found for 23 names. processed 37B.csv, 11 url matches, 9 name matches mapExactFunc: Databank matches found for 31 names. sanityCheck: position 7:Sri Ram Nagar Colony Bus Stop over 7km away from neighbors(31.63,31.44) sanityCheck: position 53:Sriram Nagar Colony over 7km away from neighbors(31.44,31.61) processed 37D.csv, 2 url matches, 7 name matches mapExactFunc: Databank matches found for 36 names. sanityCheck: position 19:Sriram Nagar Colony over 7km away from neighbors(31.44,31.61) sanityCheck: position 35:Sri Ram Nagar Colony Bus Stop over 7km away from neighbors(31.63,31.44) sanityCheck: position 48:Gandhi Nagar over 7km away from neighbors(20.13,17.65) processed 37E.csv, 3 url matches, 4 name matches mapExactFunc: Databank matches found for 16 names. processed 37H.csv, 3 url matches, 4 name matches mapExactFunc: Databank matches found for 15 names. processed 37N.csv, 8 url matches, 4 name matches mapExactFunc: Databank matches found for 37 names. processed 37S.csv, 2 url matches, 1 name matches mapExactFunc: Databank matches found for 20 names. processed 38.csv, 15 url matches, 4 name matches mapExactFunc: Databank matches found for 42 names. processed 38A.csv, 4 url matches, 1 name matches mapExactFunc: Databank matches found for 25 names. sanityCheck: position 2:Tirumala Nagar over 7km away from neighbors(7.34,12.58) sanityCheck: position 3:NMDC Bus Stop over 7km away from neighbors(9.03,11.97) sanityCheck: position 9:Gandhi Nagar over 7km away from neighbors(18.45,17.65) processed 38E.csv, 3 url matches, 0 name matches mapExactFunc: Databank matches found for 12 names. processed 38EX.csv, 3 url matches, 1 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 10:Jyothi Nagar Bus Stop over 7km away from neighbors(11.58,12.73) sanityCheck: position 17:Gandhi Nagar over 7km away from neighbors(18.45,17.65) processed 38S_47V.csv, 4 url matches, 4 name matches mapExactFunc: Databank matches found for 74 names. processed 38X.csv, 4 url matches, 1 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 7:Jyothi Nagar Bus Stop over 7km away from neighbors(13.13,11.58) sanityCheck: position 30:Jyothi Nagar Bus Stop over 7km away from neighbors(11.58,12.42) 560 files processed. processed 3A.csv, 6 url matches, 12 name matches mapExactFunc: Databank matches found for 26 names. processed 3B.csv, 2 url matches, 18 name matches mapExactFunc: Databank matches found for 34 names. sanityCheck: position 29:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.34) sanityCheck: position 40:Dairy Farm Bus Stop over 7km away from neighbors(15.34,14.44) processed 3C.csv, 28 url matches, 13 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 25:Dairy Farm Bus Stop over 7km away from neighbors(14.33,15.34) sanityCheck: position 33:Upparguda X Road over 7km away from neighbors(28.06,28.71) processed 3D.csv, 39 url matches, 12 name matches mapExactFunc: Databank matches found for 51 names. sanityCheck: position 25:Dairy Farm Bus Stop over 7km away from neighbors(14.33,15.34) sanityCheck: position 33:Upparguda X Road over 7km away from neighbors(28.06,28.71) processed 3E.csv, 20 url matches, 16 name matches mapExactFunc: Databank matches found for 67 names. sanityCheck: position 28:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.12) processed 3G.csv, 13 url matches, 12 name matches mapExactFunc: Databank matches found for 27 names. sanityCheck: position 25:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.34) processed 3H.csv, 31 url matches, 9 name matches mapExactFunc: Databank matches found for 31 names. sanityCheck: position 23:Dairy Farm Bus Stop over 7km away from neighbors(13.97,15.34) sanityCheck: position 31:Upparguda X Road over 7km away from neighbors(28.06,28.71) processed 3HN.csv, 26 url matches, 8 name matches mapExactFunc: Databank matches found for 61 names. sanityCheck: position 81:Dairy Farm Bus Stop over 7km away from neighbors(13.97,15.12) processed 3K.csv, 24 url matches, 18 name matches mapExactFunc: Databank matches found for 32 names. sanityCheck: position 22:Dairy Farm Bus Stop over 7km away from neighbors(14.33,15.34) sanityCheck: position 30:Upparguda X Road over 7km away from neighbors(28.06,28.71) sanityCheck: position 57:Upparguda X Road over 7km away from neighbors(28.71,28.06) sanityCheck: position 65:Dairy Farm Bus Stop over 7km away from neighbors(15.34,14.33) processed 3KJ.csv, 30 url matches, 13 name matches mapExactFunc: Databank matches found for 38 names. sanityCheck: position 31:Dairy Farm Bus Stop over 7km away from neighbors(14.33,15.34) sanityCheck: position 39:Upparguda X Road over 7km away from neighbors(28.06,28.71) processed 3KN.csv, 21 url matches, 11 name matches mapExactFunc: Databank matches found for 47 names. sanityCheck: position 74:Dairy Farm Bus Stop over 7km away from neighbors(14.33,15.34) sanityCheck: position 82:Upparguda X Road over 7km away from neighbors(28.06,29.04) sanityCheck: position 84:RTC Colony over 7km away from neighbors(7.33,8.22) processed 3M.csv, 14 url matches, 14 name matches mapExactFunc: Databank matches found for 38 names. sanityCheck: position 25:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.34) sanityCheck: position 33:Upparguda X Road over 7km away from neighbors(28.06,28.71) sanityCheck: position 35:RTC Colony over 7km away from neighbors(7.26,8.33) sanityCheck: position 45:Shafi Nagar over 7km away from neighbors(13.23,8.33) sanityCheck: position 46:RTC Colony over 7km away from neighbors(13.71,7.26) processed 3N.csv, 3 url matches, 13 name matches mapExactFunc: Databank matches found for 34 names. sanityCheck: position 25:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.12) processed 3P.csv, 26 url matches, 14 name matches mapExactFunc: Databank matches found for 32 names. processed 3R.csv, 4 url matches, 15 name matches mapExactFunc: Databank matches found for 31 names. sanityCheck: position 25:Dairy Farm Bus Stop over 7km away from neighbors(14.33,15.12) processed 3S.csv, 4 url matches, 9 name matches mapExactFunc: Databank matches found for 18 names. sanityCheck: position 34:Dairy Farm Bus Stop over 7km away from neighbors(14.44,13.76) processed 3SS.csv, 6 url matches, 12 name matches mapExactFunc: Databank matches found for 24 names. sanityCheck: position 20:Dairy Farm Bus Stop over 7km away from neighbors(14.44,13.76) sanityCheck: position 31:Dairy Farm Bus Stop over 7km away from neighbors(13.76,14.44) processed 3Y.csv, 27 url matches, 17 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 1:Sri Ram Nagar Colony Bus Stop over 7km away from neighbors(31.63,31.47) sanityCheck: position 72:Dairy Farm Bus Stop over 7km away from neighbors(12.52,15.34) sanityCheck: position 79:Upparguda X Road over 7km away from neighbors(27.62,28.74) sanityCheck: position 94:Sriram Nagar Colony over 7km away from neighbors(31.47,31.61) processed 3Z.csv, 13 url matches, 11 name matches mapExactFunc: Databank matches found for 64 names. sanityCheck: position 27:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.34) sanityCheck: position 35:Upparguda X Road over 7km away from neighbors(28.06,28.71) sanityCheck: position 37:RTC Colony over 7km away from neighbors(7.26,8.33) sanityCheck: position 60:Shafi Nagar over 7km away from neighbors(13.23,8.33) sanityCheck: position 61:RTC Colony over 7km away from neighbors(13.71,7.26) processed 4.csv, 28 url matches, 11 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 66:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.84) 580 files processed. processed 40.csv, 9 url matches, 4 name matches mapExactFunc: Databank matches found for 20 names. sanityCheck: position 11:Gandhi Nagar Bus Stop over 7km away from neighbors(15.29,17.96) sanityCheck: position 34:Hyderguda Bus Stop over 7km away from neighbors(11.46,7.34) sanityCheck: position 38:Gandhi Nagar over 7km away from neighbors(12.79,15.46) processed 401.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 24 names. processed 40D.csv, 16 url matches, 6 name matches mapExactFunc: Databank matches found for 28 names. processed 40E.csv, 6 url matches, 8 name matches mapExactFunc: Databank matches found for 25 names. sanityCheck: position 12:Hyderguda Bus Stop over 7km away from neighbors(11.46,7.23) processed 40N.csv, 5 url matches, 2 name matches mapExactFunc: Databank matches found for 21 names. processed 40T.csv, 6 url matches, 5 name matches mapExactFunc: Databank matches found for 29 names. sanityCheck: position 14:Ashok Nagar Bus Stop over 7km away from neighbors(17.96,15.63) sanityCheck: position 15:Jawahar Nagar Bus Stop over 7km away from neighbors(19.07,7.52) processed 40V.csv, 4 url matches, 4 name matches mapExactFunc: Databank matches found for 21 names. sanityCheck: position 9:Gandhi Nagar over 7km away from neighbors(13.27,15.29) sanityCheck: position 29:Gandhinagar over 7km away from neighbors(15.46,17.96) sanityCheck: position 30:Ashok Nagar Bus Stop over 7km away from neighbors(9.87,15.63) processed 41.csv, 25 url matches, 13 name matches mapExactFunc: Databank matches found for 38 names. sanityCheck: position 7:Gandhi Nagar Bus Stop over 7km away from neighbors(24.51,23.91) sanityCheck: position 79:Gandhi Nagar Bus Stop over 7km away from neighbors(23.91,24.51) processed 41C.csv, 36 url matches, 16 name matches mapExactFunc: Databank matches found for 20 names. sanityCheck: position 25:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 38:Gandhi Nagar Bus Stop over 7km away from neighbors(23.91,24.51) sanityCheck: position 41:Gandhi Nagar Bus Stop over 7km away from neighbors(24.51,23.91) sanityCheck: position 51:Prashanth Nagar over 7km away from neighbors(12.69,13.05) processed 41K.csv, 35 url matches, 12 name matches mapExactFunc: Databank matches found for 35 names. sanityCheck: position 28:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 41:Gandhi Nagar Bus Stop over 7km away from neighbors(23.91,24.51) sanityCheck: position 54:Gandhi Nagar Bus Stop over 7km away from neighbors(24.51,23.91) sanityCheck: position 67:Allwyn Colony over 7km away from neighbors(10.61,9.9) processed 41N.csv, 29 url matches, 8 name matches mapExactFunc: Databank matches found for 34 names. sanityCheck: position 19:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 31:Gandhi Nagar Bus Stop over 7km away from neighbors(23.91,24.51) sanityCheck: position 46:Gandhi Nagar Bus Stop over 7km away from neighbors(24.51,23.91) sanityCheck: position 57:Allwyn Colony over 7km away from neighbors(10.61,9.9) processed 42.csv, 6 url matches, 2 name matches mapExactFunc: Databank matches found for 24 names. sanityCheck: position 9:Gandhinagar over 7km away from neighbors(15.29,17.96) sanityCheck: position 10:Ashok Nagar Bus Stop over 7km away from neighbors(10.05,15.63) sanityCheck: position 30:Gandhi Nagar Bus Stop over 7km away from neighbors(13.62,15.29) processed 43.csv, 12 url matches, 5 name matches mapExactFunc: Databank matches found for 31 names. sanityCheck: position 2:Sri Ram Nagar Colony Bus Stop over 7km away from neighbors(31.63,31.44) sanityCheck: position 57:Sriram Nagar Colony over 7km away from neighbors(31.44,31.61) processed 44L.csv, 9 url matches, 0 name matches mapExactFunc: Databank matches found for 13 names. processed 44X.csv, 2 url matches, 0 name matches mapExactFunc: Databank matches found for 11 names. processed 45.csv, 10 url matches, 4 name matches mapExactFunc: Databank matches found for 32 names. sanityCheck: position 29:Bakaram over 7km away from neighbors(24.22,23.66) processed 45A.csv, 12 url matches, 6 name matches mapExactFunc: Databank matches found for 37 names. sanityCheck: position 65:Bakaram over 7km away from neighbors(24.22,22.66) processed 45G.csv, 17 url matches, 8 name matches mapExactFunc: Databank matches found for 55 names. sanityCheck: position 49:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) sanityCheck: position 101:Bakaram over 7km away from neighbors(24.22,23.66) processed 45HK.csv, 11 url matches, 6 name matches mapExactFunc: Databank matches found for 72 names. sanityCheck: position 62:Minerva Bus Stop over 7km away from neighbors(13.64,12.35) sanityCheck: position 105:Bakaram over 7km away from neighbors(24.22,22.66) processed 45J.csv, 4 url matches, 5 name matches mapExactFunc: Databank matches found for 48 names. 600 files processed. processed 46P.csv, 2 url matches, 0 name matches mapExactFunc: Databank matches found for 16 names. processed 47C.csv, 10 url matches, 3 name matches mapExactFunc: Databank matches found for 34 names. sanityCheck: position 56:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) processed 47F.csv, 8 url matches, 4 name matches mapExactFunc: Databank matches found for 34 names. sanityCheck: position 24:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) processed 47K.csv, 10 url matches, 4 name matches mapExactFunc: Databank matches found for 43 names. sanityCheck: position 20:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) sanityCheck: position 44:Minerva Bus Stop over 7km away from neighbors(13.64,12.35) processed 47S.csv, 9 url matches, 4 name matches mapExactFunc: Databank matches found for 41 names. sanityCheck: position 24:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) processed 47Y_90D.csv, 12 url matches, 9 name matches mapExactFunc: Databank matches found for 64 names. sanityCheck: position 41:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 112:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) processed 47Y_90U.csv, 13 url matches, 8 name matches mapExactFunc: Databank matches found for 43 names. sanityCheck: position 40:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 81:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) processed 48.csv, 14 url matches, 6 name matches mapExactFunc: Databank matches found for 46 names. sanityCheck: position 61:Yashoda Hospital over 7km away from neighbors(7.48,8.34) sanityCheck: position 78:Jyothi Nagar Bus Stop over 7km away from neighbors(11.58,12.42) processed 49.csv, 4 url matches, 4 name matches mapExactFunc: Databank matches found for 20 names. processed 49A.csv, 14 url matches, 4 name matches mapExactFunc: Databank matches found for 19 names. processed 49E.csv, 28 url matches, 5 name matches mapExactFunc: Databank matches found for 41 names. sanityCheck: position 38:Dargah over 7km away from neighbors(15.28,15.94) sanityCheck: position 52:Dargah over 7km away from neighbors(15.34,15.29) processed 49J.csv, 8 url matches, 3 name matches mapExactFunc: Databank matches found for 34 names. processed 49K.csv, 4 url matches, 6 name matches mapExactFunc: Databank matches found for 38 names. processed 49L.csv, 6 url matches, 3 name matches mapExactFunc: Databank matches found for 25 names. processed 49M.csv, 33 url matches, 10 name matches mapExactFunc: Databank matches found for 35 names. sanityCheck: position 41:Sairam Nagar Busstop over 7km away from neighbors(22.35,24.77) sanityCheck: position 54:Sairam Nagar Busstop over 7km away from neighbors(24.77,22.26) processed 49M_250.csv, 43 url matches, 11 name matches mapExactFunc: Databank matches found for 55 names. sanityCheck: position 1:Sharada Nagar over 7km away from neighbors(16.19,16.75) sanityCheck: position 61:Sai Nagar Colony over 7km away from neighbors(11.29,12.81) processed 49N.csv, 7 url matches, 3 name matches mapExactFunc: Databank matches found for 15 names. processed 49P.csv, 4 url matches, 8 name matches mapExactFunc: Databank matches found for 20 names. processed 49V.csv, 8 url matches, 6 name matches mapExactFunc: Databank matches found for 13 names. processed 49WI.csv, 29 url matches, 4 name matches mapExactFunc: Databank matches found for 14 names. 620 files processed. processed 49_250M.csv, 46 url matches, 15 name matches mapExactFunc: Databank matches found for 47 names. sanityCheck: position 66:Hanuman Temple over 7km away from neighbors(16.38,65.12) processed 4SY.csv, 0 url matches, 12 name matches mapExactFunc: Databank matches found for 46 names. processed 5.csv, 22 url matches, 7 name matches mapExactFunc: Databank matches found for 20 names. processed 508.csv, 7 url matches, 7 name matches mapExactFunc: Databank matches found for 15 names. processed 51.csv, 12 url matches, 6 name matches mapExactFunc: Databank matches found for 23 names. processed 56G.csv, 34 url matches, 10 name matches mapExactFunc: Databank matches found for 23 names. sanityCheck: position 33:Bandlaguda X Road over 7km away from neighbors(18.69,19.77) processed 57S.csv, 7 url matches, 3 name matches mapExactFunc: Databank matches found for 40 names. sanityCheck: position 53:Ashok Nagar over 7km away from neighbors(10.23,11.58) processed 589.csv, 64 url matches, 8 name matches mapExactFunc: Databank matches found for 24 names. sanityCheck: position 31:Water Tank Bus Stop over 7km away from neighbors(17.42,19.86) sanityCheck: position 39:Warehouse Bus Stop over 7km away from neighbors(12.04,13.29) sanityCheck: position 47:Tupran over 7km away from neighbors(11.36,14.24) sanityCheck: position 48:Chegunta over 7km away from neighbors(25.54,66.13) sanityCheck: position 49:Narsingi over 7km away from neighbors(41.63,81.66) sanityCheck: position 52:Narsingi over 7km away from neighbors(81.66,66.13) sanityCheck: position 53:Chegunta over 7km away from neighbors(16.5,14.24) sanityCheck: position 54:Tupran over 7km away from neighbors(30.7,11.36) sanityCheck: position 62:Warehouse Bus Stop over 7km away from neighbors(13.29,12.04) sanityCheck: position 70:Water Tank Bus Stop over 7km away from neighbors(19.86,17.42) processed 5B.csv, 15 url matches, 8 name matches mapExactFunc: Databank matches found for 24 names. processed 5BL.csv, 13 url matches, 9 name matches mapExactFunc: Databank matches found for 30 names. processed 5C.csv, 16 url matches, 5 name matches mapExactFunc: Databank matches found for 14 names. processed 5GP.csv, 16 url matches, 5 name matches mapExactFunc: Databank matches found for 34 names. sanityCheck: position 7:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 60:Dargah over 7km away from neighbors(15.28,15.94) sanityCheck: position 66:Indira Nagar over 7km away from neighbors(20.84,22.05) processed 5K.csv, 18 url matches, 1 name matches mapExactFunc: Databank matches found for 21 names. processed 5K_16A.csv, 23 url matches, 2 name matches mapExactFunc: Databank matches found for 55 names. processed 5K_92.csv, 17 url matches, 2 name matches mapExactFunc: Databank matches found for 45 names. sanityCheck: position 14:Maruthi Nagar over 7km away from neighbors(16.87,16.51) sanityCheck: position 67:Laxmi Nagar over 7km away from neighbors(16.37,17.95) sanityCheck: position 77:Dairy Farm over 7km away from neighbors(13.99,16.38) processed 5L.csv, 16 url matches, 7 name matches mapExactFunc: Databank matches found for 30 names. processed 5M.csv, 11 url matches, 0 name matches mapExactFunc: Databank matches found for 28 names. processed 5P.csv, 16 url matches, 5 name matches mapExactFunc: Databank matches found for 23 names. sanityCheck: position 6:Dargah over 7km away from neighbors(15.98,15.29) processed 5R.csv, 40 url matches, 16 name matches mapExactFunc: Databank matches found for 24 names. sanityCheck: position 3:Hanuman Temple (Tirumalgherry) over 7km away from neighbors(7.98,7.1) sanityCheck: position 92:water tank bus stop over 7km away from neighbors(13.17,7.07) sanityCheck: position 93:Water Tank over 7km away from neighbors(8.47,9.92) processed 5SD.csv, 11 url matches, 2 name matches mapExactFunc: Databank matches found for 24 names. 640 files processed. processed 5T.csv, 33 url matches, 12 name matches mapExactFunc: Databank matches found for 20 names. sanityCheck: position 1:Sharada Nagar over 7km away from neighbors(16.19,17.84) sanityCheck: position 79:Lakshminagar Bus Stop over 7km away from neighbors(7.1,17.84) sanityCheck: position 80:Sharada Nagar over 7km away from neighbors(24.76,16.19) processed 60.csv, 8 url matches, 0 name matches mapExactFunc: Databank matches found for 24 names. sanityCheck: position 15:Gandhi Nagar over 7km away from neighbors(18.45,17.3) sanityCheck: position 28:Gandhi Nagar over 7km away from neighbors(17.3,18.45) processed 601.csv, 14 url matches, 2 name matches mapExactFunc: Databank matches found for 78 names. sanityCheck: position 1:Ambedkar Statue over 7km away from neighbors(38.16,35.31) sanityCheck: position 81:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 119:Ambedkar Statue over 7km away from neighbors(35.31,38.16) processed 63B.csv, 14 url matches, 5 name matches mapExactFunc: Databank matches found for 13 names. processed 63M.csv, 14 url matches, 5 name matches mapExactFunc: Databank matches found for 13 names. processed 63S.csv, 10 url matches, 4 name matches mapExactFunc: Databank matches found for 17 names. processed 649.csv, 81 url matches, 12 name matches mapExactFunc: Databank matches found for 14 names. processed 65.csv, 13 url matches, 9 name matches mapExactFunc: Databank matches found for 16 names. processed 65A.csv, 9 url matches, 4 name matches mapExactFunc: Databank matches found for 17 names. processed 65M.csv, 14 url matches, 10 name matches mapExactFunc: Databank matches found for 13 names. processed 65S.csv, 14 url matches, 14 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 42:Dargah over 7km away from neighbors(15.98,15.29) processed 66G.csv, 14 url matches, 14 name matches mapExactFunc: Databank matches found for 27 names. processed 67L.csv, 0 url matches, 2 name matches mapExactFunc: Databank matches found for 14 names. processed 6B.csv, 11 url matches, 9 name matches mapExactFunc: Databank matches found for 40 names. sanityCheck: position 29:Hanuman Temple over 7km away from neighbors(16.38,18.19) sanityCheck: position 43:Hanuman Temple over 7km away from neighbors(18.19,15.31) processed 6C.csv, 10 url matches, 4 name matches mapExactFunc: Databank matches found for 47 names. sanityCheck: position 27:Dargah over 7km away from neighbors(15.28,15.94) sanityCheck: position 41:Dargah over 7km away from neighbors(15.34,15.29) processed 6H.csv, 24 url matches, 14 name matches mapExactFunc: Databank matches found for 53 names. sanityCheck: position 33:Dairy Farm Bus Stop over 7km away from neighbors(14.33,15.34) processed 6H_216G.csv, 24 url matches, 14 name matches mapExactFunc: Databank matches found for 71 names. sanityCheck: position 6:Dargah over 7km away from neighbors(15.34,15.29) sanityCheck: position 43:Dairy Farm Bus Stop over 7km away from neighbors(14.33,15.34) sanityCheck: position 125:Dargah over 7km away from neighbors(15.28,15.6) processed 6J.csv, 9 url matches, 3 name matches mapExactFunc: Databank matches found for 37 names. processed 6K.csv, 22 url matches, 9 name matches mapExactFunc: Databank matches found for 48 names. sanityCheck: position 29:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.12) processed 6M.csv, 16 url matches, 9 name matches mapExactFunc: Databank matches found for 30 names. sanityCheck: position 27:Dairy Farm Bus Stop over 7km away from neighbors(14.44,15.34) 660 files processed. processed 6S.csv, 12 url matches, 8 name matches mapExactFunc: Databank matches found for 37 names. processed 6T.csv, 10 url matches, 3 name matches mapExactFunc: Databank matches found for 19 names. processed 71A.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 38 names. sanityCheck: position 13:Gandhi Statue Bus Stop over 7km away from neighbors(24.23,24.66) sanityCheck: position 36:Gandhi Statue Bus Stop over 7km away from neighbors(24.66,24.23) processed 72J.csv, 8 url matches, 2 name matches mapExactFunc: Databank matches found for 28 names. processed 72L.csv, 10 url matches, 2 name matches mapExactFunc: Databank matches found for 24 names. processed 73.csv, 0 url matches, 2 name matches mapExactFunc: Databank matches found for 16 names. processed 74.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 26 names. processed 75R.csv, 0 url matches, 2 name matches mapExactFunc: Databank matches found for 18 names. processed 7C.csv, 12 url matches, 4 name matches mapExactFunc: Databank matches found for 32 names. processed 7H.csv, 51 url matches, 15 name matches mapExactFunc: Databank matches found for 8 names. processed 7I.csv, 4 url matches, 2 name matches mapExactFunc: Databank matches found for 28 names. processed 7M.csv, 10 url matches, 4 name matches mapExactFunc: Databank matches found for 28 names. processed 7V.csv, 16 url matches, 6 name matches mapExactFunc: Databank matches found for 28 names. processed 7X.csv, 8 url matches, 1 name matches mapExactFunc: Databank matches found for 7 names. processed 801.csv, 0 url matches, 2 name matches mapExactFunc: Databank matches found for 30 names. sanityCheck: position 3:HUDA Colony over 7km away from neighbors(21.13,16.25) sanityCheck: position 48:HUDA Colony over 7km away from neighbors(16.25,21.13) processed 83J_230.csv, 30 url matches, 21 name matches mapExactFunc: Databank matches found for 54 names. sanityCheck: position 66:7 Temples Bus Stop over 7km away from neighbors(12.98,14.31) sanityCheck: position 98:Prashanth Nagar over 7km away from neighbors(12.69,13.05) processed 83J_272G.csv, 30 url matches, 18 name matches mapExactFunc: Databank matches found for 52 names. sanityCheck: position 92:Prashanth Nagar over 7km away from neighbors(12.69,13.05) processed 83K.csv, 42 url matches, 11 name matches mapExactFunc: Databank matches found for 19 names. sanityCheck: position 41:Road No 1 over 7km away from neighbors(8.98,9.14) processed 84.csv, 44 url matches, 8 name matches mapExactFunc: Databank matches found for 20 names. sanityCheck: position 35:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 40:Allwyn Colony over 7km away from neighbors(10.61,9.82) processed 84S.csv, 46 url matches, 8 name matches mapExactFunc: Databank matches found for 16 names. sanityCheck: position 33:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 38:Allwyn Colony over 7km away from neighbors(10.61,9.82) 680 files processed. processed 85B.csv, 10 url matches, 2 name matches mapExactFunc: Databank matches found for 60 names. processed 85H.csv, 0 url matches, 0 name matches mapExactFunc: Databank matches found for 34 names. processed 86.csv, 6 url matches, 4 name matches mapExactFunc: Databank matches found for 24 names. processed 861.csv, 8 url matches, 0 name matches mapExactFunc: Databank matches found for 34 names. processed 86J.csv, 6 url matches, 2 name matches mapExactFunc: Databank matches found for 50 names. processed 86K.csv, 6 url matches, 0 name matches mapExactFunc: Databank matches found for 32 names. processed 86V.csv, 3 url matches, 2 name matches mapExactFunc: Databank matches found for 17 names. processed 8C.csv, 18 url matches, 2 name matches mapExactFunc: Databank matches found for 32 names. processed 8M.csv, 16 url matches, 2 name matches mapExactFunc: Databank matches found for 26 names. processed 8R.csv, 20 url matches, 16 name matches mapExactFunc: Databank matches found for 36 names. processed 9.csv, 32 url matches, 10 name matches mapExactFunc: Databank matches found for 32 names. sanityCheck: position 27:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 60:Allwyn Colony over 7km away from neighbors(10.61,9.82) processed 90K.csv, 9 url matches, 5 name matches mapExactFunc: Databank matches found for 48 names. processed 90L.csv, 13 url matches, 7 name matches mapExactFunc: Databank matches found for 27 names. sanityCheck: position 45:Junior College over 7km away from neighbors(26.56,27.73) processed 90L_226.csv, 65 url matches, 19 name matches mapExactFunc: Databank matches found for 43 names. sanityCheck: position 4:St. Anns School Bus Stop over 7km away from neighbors(22.06,22.09) sanityCheck: position 57:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 74:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) sanityCheck: position 128:Junior College over 7km away from neighbors(26.56,27.73) processed 90L_300.csv, 8 url matches, 6 name matches mapExactFunc: Databank matches found for 77 names. sanityCheck: position 3:Laxmi Nagar over 7km away from neighbors(16.37,17.95) sanityCheck: position 23:Bandlaguda over 7km away from neighbors(27.57,28.15) sanityCheck: position 70:Junior College over 7km away from neighbors(26.56,27.73) sanityCheck: position 99:Bandlaguda over 7km away from neighbors(28.15,27.57) sanityCheck: position 117:Maruthi Nagar over 7km away from neighbors(16.87,16.51) processed 90M.csv, 12 url matches, 4 name matches mapExactFunc: Databank matches found for 23 names. processed 90R.csv, 5 url matches, 5 name matches mapExactFunc: Databank matches found for 69 names. processed 90V.csv, 8 url matches, 4 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 21:Check Post Bus Stop over 7km away from neighbors(30.96,31.82) processed 90d.csv, 11 url matches, 5 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 42:Junior College over 7km away from neighbors(26.56,27.73) processed 92.csv, 2 url matches, 0 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 14:Maruthi Nagar over 7km away from neighbors(16.87,16.51) sanityCheck: position 21:Laxmi Nagar over 7km away from neighbors(16.37,17.95) 700 files processed. processed 92X.csv, 2 url matches, 1 name matches mapExactFunc: Databank matches found for 28 names. sanityCheck: position 13:Maruthi Nagar over 7km away from neighbors(16.87,16.51) sanityCheck: position 20:Laxmi Nagar over 7km away from neighbors(16.37,17.95) sanityCheck: position 30:Dairy Farm over 7km away from neighbors(13.99,16.16) processed 94H.csv, 4 url matches, 1 name matches mapExactFunc: Databank matches found for 53 names. processed 94K.csv, 0 url matches, 2 name matches mapExactFunc: Databank matches found for 40 names. processed 94L.csv, 8 url matches, 2 name matches mapExactFunc: Databank matches found for 46 names. processed 94U.csv, 0 url matches, 2 name matches mapExactFunc: Databank matches found for 22 names. processed 95.csv, 6 url matches, 6 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 43:Langar House over 7km away from neighbors(8.1,7.17) processed 95A.csv, 0 url matches, 2 name matches mapExactFunc: Databank matches found for 36 names. processed 95K.csv, 0 url matches, 2 name matches mapExactFunc: Databank matches found for 34 names. processed 95KD.csv, 0 url matches, 1 name matches mapExactFunc: Databank matches found for 14 names. sanityCheck: position 22:Dairy Farm over 7km away from neighbors(15.35,16.16) processed 95M.csv, 0 url matches, 2 name matches mapExactFunc: Databank matches found for 34 names. processed 95P.csv, 4 url matches, 2 name matches mapExactFunc: Databank matches found for 32 names. processed 95R.csv, 0 url matches, 2 name matches mapExactFunc: Databank matches found for 40 names. processed 96N.csv, 28 url matches, 2 name matches mapExactFunc: Databank matches found for 8 names. processed 98.csv, 27 url matches, 10 name matches mapExactFunc: Databank matches found for 6 names. processed 99.csv, 14 url matches, 4 name matches mapExactFunc: Databank matches found for 26 names. processed 99M.csv, 14 url matches, 4 name matches mapExactFunc: Databank matches found for 22 names. processed 9A.csv, 26 url matches, 12 name matches mapExactFunc: Databank matches found for 26 names. sanityCheck: position 7:Gandhi Nagar Bus Stop over 7km away from neighbors(24.51,23.91) sanityCheck: position 14:Prashanth Nagar over 7km away from neighbors(12.1,13.05) sanityCheck: position 61:Prashanth Nagar over 7km away from neighbors(13.05,12.1) sanityCheck: position 68:Gandhi Nagar Bus Stop over 7km away from neighbors(23.91,24.51) processed 9C.csv, 12 url matches, 6 name matches mapExactFunc: Databank matches found for 16 names. sanityCheck: position 2:Krishna Nagar bus stop over 7km away from neighbors(15.04,13.98) sanityCheck: position 35:Krishna Nagar bus stop over 7km away from neighbors(13.98,15.04) processed 9D.csv, 32 url matches, 8 name matches mapExactFunc: Databank matches found for 24 names. sanityCheck: position 20:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 51:Allwyn Colony over 7km away from neighbors(10.61,9.82) processed 9F.csv, 15 url matches, 6 name matches mapExactFunc: Databank matches found for 37 names. 720 files processed. processed 9K.csv, 41 url matches, 22 name matches mapExactFunc: Databank matches found for 33 names. sanityCheck: position 78:Prashanth Nagar over 7km away from neighbors(12.69,12.87) processed 9K_272G.csv, 32 url matches, 22 name matches mapExactFunc: Databank matches found for 41 names. sanityCheck: position 25:Prashanth Nagar over 7km away from neighbors(12.69,12.87) sanityCheck: position 83:Prashanth Nagar over 7km away from neighbors(12.69,12.87) processed 9K_283K.csv, 43 url matches, 21 name matches mapExactFunc: Databank matches found for 39 names. sanityCheck: position 86:Prashanth Nagar over 7km away from neighbors(12.69,12.87) processed 9M-1.csv, 35 url matches, 7 name matches mapExactFunc: Databank matches found for 38 names. sanityCheck: position 2:Allwyn Colony over 7km away from neighbors(10.61,9.9) sanityCheck: position 56:Sitaphalmandi over 7km away from neighbors(9.29,8.95) sanityCheck: position 93:Allwyn Colony over 7km away from neighbors(9.82,10.61) processed 9M.csv, 35 url matches, 7 name matches mapExactFunc: Databank matches found for 16 names. sanityCheck: position 33:Allwyn Colony over 7km away from neighbors(9.82,10.61) sanityCheck: position 38:Allwyn Colony over 7km away from neighbors(10.61,9.9) processed 9Q.csv, 42 url matches, 14 name matches mapExactFunc: Databank matches found for 32 names. processed 9R.csv, 30 url matches, 8 name matches mapExactFunc: Databank matches found for 14 names. processed 9V.csv, 14 url matches, 6 name matches mapExactFunc: Databank matches found for 14 names. sanityCheck: position 15:Krishna Nagar bus stop over 7km away from neighbors(15.04,15.87) sanityCheck: position 22:Krishna Nagar bus stop over 7km away from neighbors(15.87,15.04) processed 9X.csv, 39 url matches, 20 name matches mapExactFunc: Databank matches found for 35 names. sanityCheck: position 78:Prashanth Nagar over 7km away from neighbors(12.69,13.05) processed 9X_171M.csv, 39 url matches, 18 name matches mapExactFunc: Databank matches found for 37 names. sanityCheck: position 4:Srinivas Nagar over 7km away from neighbors(14.76,12.04) sanityCheck: position 22:Prashanth Nagar over 7km away from neighbors(12.69,13.05) sanityCheck: position 112:Srinivas Nagar over 7km away from neighbors(12.04,13.84) processed 9X_272G.csv, 39 url matches, 19 name matches mapExactFunc: Databank matches found for 42 names. sanityCheck: position 26:Prashanth Nagar over 7km away from neighbors(12.69,13.05) processed 9X_283D.csv, 39 url matches, 18 name matches mapExactFunc: Databank matches found for 40 names. sanityCheck: position 23:Prashanth Nagar over 7km away from neighbors(12.69,13.05) processed 9Y.csv, 22 url matches, 10 name matches mapExactFunc: Databank matches found for 8 names. processed 9YF.csv, 21 url matches, 6 name matches mapExactFunc: Databank matches found for 42 names. sanityCheck: position 41:Sitaphalmandi over 7km away from neighbors(8.4,8.95) processed Sec-Airport.csv, 3 url matches, 1 name matches mapExactFunc: Databank matches found for 2 names.
reportDF.index.name = 'file'
# important!
# reportDF = pd.DataFrame(reportCollector)
# reportDF
list(reportDF.columns)
['route', 'stops', 'url_matches', 'name_matches', 'databank_matches', 'faraway_removed']
''' Retiring the incremental business for now, instead incrementing done routes on full empty datasets.
# intervention : if cumulative report already exists, load it. else, make a new one.
if os.path.exists(reportFolder + reportFile + '.csv'):
cumulativeDF = pd.read_csv(reportFolder + reportFile+'.csv', index_col='file')
#reportDF = reportDF.fillna(0) + cumulativeDF[list(reportDF.columns)].fillna(0)
# shit can't do that.. route and stops columns shouldn't get added up!
for col in ['url_matches', 'name_matches', 'databank_matches', 'faraway_removed']:
reportDF[col] = (reportDF[col].fillna(0) + cumulativeDF[col].fillna(0)).fillna(0)
# question: what to do in case of routes that were there in prev report but have become done now?
# lets play it by the ear. choose a done route.
'''
" Retiring the incremental business for now, instead incrementing done routes on full empty datasets.\n\n# intervention : if cumulative report already exists, load it. else, make a new one.\nif os.path.exists(reportFolder + reportFile + '.csv'):\n cumulativeDF = pd.read_csv(reportFolder + reportFile+'.csv', index_col='file')\n #reportDF = reportDF.fillna(0) + cumulativeDF[list(reportDF.columns)].fillna(0)\n # shit can't do that.. route and stops columns shouldn't get added up!\n \n for col in ['url_matches', 'name_matches', 'databank_matches', 'faraway_removed']:\n reportDF[col] = (reportDF[col].fillna(0) + cumulativeDF[col].fillna(0)).fillna(0)\n \n # question: what to do in case of routes that were there in prev report but have become done now?\n # lets play it by the ear. choose a done route.\n"
# reportDF.fillna(0)
# cumulativeDF
# now proceed with the added-up report
# report stats
reportDF['unmapped'] = reportDF.stops - (reportDF.url_matches + reportDF.name_matches + reportDF.databank_matches) + reportDF.faraway_removed
reportDF['crossmapping_coverage'] = round(100 * (reportDF.url_matches + reportDF.name_matches) / reportDF.stops , 1)
reportDF['databank_coverage'] = round(100 * reportDF.databank_matches / reportDF.stops , 1)
reportDF['coverage'] = round(100 * (reportDF.stops - reportDF.unmapped) / reportDF.stops , 1)
# Note: 'unmapped' here means whatever's not been automatically mapped.
# this is assuming we're working on blank route CSV's
# in case some rows were already filled, they will also be counted as 'unmapped' here.
reportDF.tail(5)
route | stops | url_matches | name_matches | databank_matches | faraway_removed | unmapped | crossmapping_coverage | databank_coverage | coverage | |
---|---|---|---|---|---|---|---|---|---|---|
file | ||||||||||
9X_272G.csv | 9X/272G | 124.0 | 39.0 | 19.0 | 42.0 | 0.0 | 24.0 | 46.8 | 33.9 | 80.6 |
9X_283D.csv | 9X/283D | 118.0 | 39.0 | 18.0 | 40.0 | 0.0 | 21.0 | 48.3 | 33.9 | 82.2 |
9Y.csv | 9Y | 46.0 | 22.0 | 10.0 | 8.0 | 0.0 | 6.0 | 69.6 | 17.4 | 87.0 |
9YF.csv | 9YF | 81.0 | 21.0 | 6.0 | 42.0 | 1.0 | 13.0 | 33.3 | 51.9 | 84.0 |
Sec-Airport.csv | Secunderabad Bus Station – RGI Airport | 9.0 | 3.0 | 1.0 | 2.0 | 0.0 | 3.0 | 44.4 | 22.2 | 66.7 |
# saving a timestamped backup for comparing with future versions
reportDF.to_csv(reportFolder + reportFile + timestamp + '.csv')
reportDF.to_csv(reportFolder + reportFile + '.csv')
# next time this will be loaded as cumulativeDF
reportDF.shape
(735, 10)
see report-plot.ipynb
Standalone HTML plot: see report-plot.html
import matplotlib.pyplot as plt
import numpy as np
import mpld3
fig, ax = plt.subplots(subplot_kw=dict(facecolor='#EEEEEE'), figsize=(13,8))
N = 100
scatter = ax.scatter(reportDF.databank_coverage,
reportDF.crossmapping_coverage,
#c=np.random.random(size=len(reportDF)),
c = reportDF.coverage,
s=5 + reportDF.stops*6,
alpha=0.5,
cmap=plt.cm.jet,
edgecolors='black'
)
# visuals like axes, title
ax.grid(color='white', linestyle='solid')
ax.set_xlabel('% mapped from databank')
ax.set_ylabel('% cross-mapped from done routes')
ax.set_title("Hyd bus routes cross-mapping vs databank mapping", size=16)
# for tooltips. it is made as a "plugin" and then attached to the main figure
# preparing label html and css style
reportDF['labels'] = '<div class="hydcoverage"><b>' + reportDF.route.astype(str) + '</b>: ' + reportDF.stops.astype(str) + ' stops<br>'+ \
reportDF.crossmapping_coverage.astype(str) +'% crossmapped<br>'+ \
reportDF.databank_coverage.astype(str) + '% databank mapped<br>' + \
reportDF.coverage.astype(str) + '% mapped total, ' + \
reportDF.unmapped.astype(str) + ' remaining' + \
'</div>'
css = '.hydcoverage{ background:white; padding:2px; }'
# now implementing labels
tooltip = mpld3.plugins.PointHTMLTooltip(scatter, labels=reportDF.labels.tolist(),\
css=css, voffset=-90, hoffset=20)
mpld3.plugins.connect(fig, tooltip)
# finally, display plot
mpld3.display()
Size: number of stops.
Color: extent of mapping completion, blue(low) to red(high)
Vertical axis: Cross-mapping %.
Horizontal axis: Databank mapping %.
Ideally we want to move most routes towards top left of this plot as we keep mapping routes.
# save plot to standalone HTML file
mpld3.save_html(fig, reportFolder+'report-plot_'+timestamp+'.html')
df = reportDF.iloc[:,2:-1]
df
url_matches | name_matches | databank_matches | faraway_removed | unmapped | crossmapping_coverage | databank_coverage | coverage | |
---|---|---|---|---|---|---|---|---|
file | ||||||||
1.csv | 3.0 | 5.0 | 23.0 | 1.0 | 13.0 | 18.6 | 53.5 | 69.8 |
10.csv | 25.0 | 7.0 | 19.0 | 1.0 | 10.0 | 53.3 | 31.7 | 83.3 |
100.csv | 1.0 | 1.0 | 32.0 | 0.0 | 8.0 | 4.8 | 76.2 | 81.0 |
100A.csv | 20.0 | 6.0 | 16.0 | 0.0 | 2.0 | 59.1 | 36.4 | 95.5 |
100C.csv | 12.0 | 2.0 | 26.0 | 2.0 | 13.0 | 27.5 | 51.0 | 74.5 |
100D_V.csv | 11.0 | 2.0 | 29.0 | 1.0 | 12.0 | 24.5 | 54.7 | 77.4 |
100G.csv | 22.0 | 6.0 | 29.0 | 1.0 | 4.0 | 46.7 | 48.3 | 93.3 |
100H.csv | 20.0 | 7.0 | 8.0 | 0.0 | 8.0 | 62.8 | 18.6 | 81.4 |
100J.csv | 20.0 | 6.0 | 26.0 | 0.0 | 14.0 | 39.4 | 39.4 | 78.8 |
100K.csv | 20.0 | 5.0 | 6.0 | 0.0 | 2.0 | 75.8 | 18.2 | 93.9 |
100L.csv | 20.0 | 5.0 | 8.0 | 0.0 | 6.0 | 64.1 | 20.5 | 84.6 |
100M.csv | 19.0 | 5.0 | 7.0 | 0.0 | 4.0 | 68.6 | 20.0 | 88.6 |
100N.csv | 17.0 | 5.0 | 25.0 | 1.0 | 12.0 | 37.9 | 43.1 | 79.3 |
100R.csv | 17.0 | 5.0 | 17.0 | 0.0 | 5.0 | 50.0 | 38.6 | 88.6 |
100T.csv | 19.0 | 6.0 | 10.0 | 0.0 | 3.0 | 65.8 | 26.3 | 92.1 |
100V.csv | 12.0 | 2.0 | 23.0 | 1.0 | 11.0 | 29.8 | 48.9 | 76.6 |
101B.csv | 20.0 | 5.0 | 27.0 | 1.0 | 4.0 | 45.5 | 49.1 | 92.7 |
101K.csv | 18.0 | 6.0 | 6.0 | 0.0 | 1.0 | 77.4 | 19.4 | 96.8 |
101R.csv | 24.0 | 4.0 | 32.0 | 1.0 | 10.0 | 40.6 | 46.4 | 85.5 |
101S.csv | 22.0 | 4.0 | 16.0 | 0.0 | 2.0 | 59.1 | 36.4 | 95.5 |
102.csv | 8.0 | 3.0 | 33.0 | 1.0 | 21.0 | 17.2 | 51.6 | 67.2 |
102A.csv | 5.0 | 2.0 | 22.0 | 0.0 | 14.0 | 16.3 | 51.2 | 67.4 |
102B_218L.csv | 89.0 | 19.0 | 37.0 | 0.0 | 15.0 | 67.5 | 23.1 | 90.6 |
102C.csv | 9.0 | 3.0 | 51.0 | 0.0 | 20.0 | 14.5 | 61.4 | 75.9 |
102CJ.csv | 8.0 | 0.0 | 25.0 | 0.0 | 6.0 | 20.5 | 64.1 | 84.6 |
102D.csv | 0.0 | 0.0 | 19.0 | 0.0 | 6.0 | 0.0 | 76.0 | 76.0 |
102F.csv | 34.0 | 13.0 | 22.0 | 0.0 | 13.0 | 57.3 | 26.8 | 84.1 |
102H.csv | 11.0 | 4.0 | 13.0 | 0.0 | 9.0 | 40.5 | 35.1 | 75.7 |
102K.csv | 10.0 | 3.0 | 42.0 | 0.0 | 26.0 | 16.0 | 51.9 | 67.9 |
102N.csv | 5.0 | 2.0 | 24.0 | 1.0 | 16.0 | 15.2 | 52.2 | 65.2 |
... | ... | ... | ... | ... | ... | ... | ... | ... |
95.csv | 6.0 | 6.0 | 33.0 | 1.0 | 7.0 | 23.5 | 64.7 | 86.3 |
95A.csv | 0.0 | 2.0 | 36.0 | 0.0 | 16.0 | 3.7 | 66.7 | 70.4 |
95K.csv | 0.0 | 2.0 | 34.0 | 0.0 | 18.0 | 3.7 | 63.0 | 66.7 |
95KD.csv | 0.0 | 1.0 | 14.0 | 1.0 | 12.0 | 3.8 | 53.8 | 53.8 |
95M.csv | 0.0 | 2.0 | 34.0 | 0.0 | 16.0 | 3.8 | 65.4 | 69.2 |
95P.csv | 4.0 | 2.0 | 32.0 | 0.0 | 18.0 | 10.7 | 57.1 | 67.9 |
95R.csv | 0.0 | 2.0 | 40.0 | 0.0 | 16.0 | 3.4 | 69.0 | 72.4 |
96N.csv | 28.0 | 2.0 | 8.0 | 0.0 | 2.0 | 75.0 | 20.0 | 95.0 |
98.csv | 27.0 | 10.0 | 6.0 | 0.0 | 9.0 | 71.2 | 11.5 | 82.7 |
99.csv | 14.0 | 4.0 | 26.0 | 0.0 | 12.0 | 32.1 | 46.4 | 78.6 |
99M.csv | 14.0 | 4.0 | 22.0 | 0.0 | 20.0 | 30.0 | 36.7 | 66.7 |
9A.csv | 26.0 | 12.0 | 26.0 | 2.0 | 14.0 | 50.0 | 34.2 | 81.6 |
9C.csv | 12.0 | 6.0 | 16.0 | 1.0 | 5.0 | 47.4 | 42.1 | 86.8 |
9D.csv | 32.0 | 8.0 | 24.0 | 1.0 | 9.0 | 55.6 | 33.3 | 87.5 |
9F.csv | 15.0 | 6.0 | 37.0 | 0.0 | 11.0 | 30.4 | 53.6 | 84.1 |
9K.csv | 41.0 | 22.0 | 33.0 | 1.0 | 20.0 | 54.8 | 28.7 | 82.6 |
9K_272G.csv | 32.0 | 22.0 | 41.0 | 1.0 | 26.0 | 45.0 | 34.2 | 78.3 |
9K_283K.csv | 43.0 | 21.0 | 39.0 | 1.0 | 24.0 | 50.8 | 31.0 | 81.0 |
9M-1.csv | 35.0 | 7.0 | 38.0 | 2.0 | 18.0 | 43.8 | 39.6 | 81.2 |
9M.csv | 35.0 | 7.0 | 16.0 | 1.0 | 12.0 | 60.9 | 23.2 | 82.6 |
9Q.csv | 42.0 | 14.0 | 32.0 | 0.0 | 20.0 | 51.9 | 29.6 | 81.5 |
9R.csv | 30.0 | 8.0 | 14.0 | 0.0 | 14.0 | 57.6 | 21.2 | 78.8 |
9V.csv | 14.0 | 6.0 | 14.0 | 1.0 | 5.0 | 52.6 | 36.8 | 86.8 |
9X.csv | 39.0 | 20.0 | 35.0 | 1.0 | 19.0 | 52.7 | 31.2 | 83.0 |
9X_171M.csv | 39.0 | 18.0 | 37.0 | 1.0 | 24.0 | 48.7 | 31.6 | 79.5 |
9X_272G.csv | 39.0 | 19.0 | 42.0 | 0.0 | 24.0 | 46.8 | 33.9 | 80.6 |
9X_283D.csv | 39.0 | 18.0 | 40.0 | 0.0 | 21.0 | 48.3 | 33.9 | 82.2 |
9Y.csv | 22.0 | 10.0 | 8.0 | 0.0 | 6.0 | 69.6 | 17.4 | 87.0 |
9YF.csv | 21.0 | 6.0 | 42.0 | 1.0 | 13.0 | 33.3 | 51.9 | 84.0 |
Sec-Airport.csv | 3.0 | 1.0 | 2.0 | 0.0 | 3.0 | 44.4 | 22.2 | 66.7 |
735 rows × 8 columns
summaryDF = pd.DataFrame(data = [df.mean(),df.median(),\
df.min(), df.max(), df.std(), df.sum()], \
index=['average','median','min','max','std_deviation','sum'] )\
.transpose().apply(lambda x: round(x,2))
summaryDF
average | median | min | max | std_deviation | sum | |
---|---|---|---|---|---|---|
url_matches | 22.23 | 14.0 | 0.0 | 106.0 | 20.49 | 16340.0 |
name_matches | 8.45 | 7.0 | 0.0 | 32.0 | 6.55 | 6208.0 |
databank_matches | 32.87 | 31.0 | 0.0 | 105.0 | 18.76 | 24157.0 |
faraway_removed | 0.77 | 0.0 | 0.0 | 5.0 | 0.96 | 569.0 |
unmapped | 14.18 | 13.0 | 0.0 | 51.0 | 8.29 | 10419.0 |
crossmapping_coverage | 37.78 | 33.3 | 0.0 | 100.0 | 23.06 | 27771.1 |
databank_coverage | 44.18 | 46.9 | 0.0 | 87.8 | 18.46 | 32469.8 |
coverage | 81.00 | 81.2 | 50.0 | 100.0 | 8.42 | 59535.4 |
# blanking out sum numbers for the % coverage params where they don't apply:
summaryDF.at['coverage','sum'] = pd.np.nan
summaryDF.at['databank_coverage','sum'] = pd.np.nan
summaryDF.at['crossmapping_coverage','sum'] = pd.np.nan
summaryDF
average | median | min | max | std_deviation | sum | |
---|---|---|---|---|---|---|
url_matches | 22.23 | 14.0 | 0.0 | 106.0 | 20.49 | 16340.0 |
name_matches | 8.45 | 7.0 | 0.0 | 32.0 | 6.55 | 6208.0 |
databank_matches | 32.87 | 31.0 | 0.0 | 105.0 | 18.76 | 24157.0 |
faraway_removed | 0.77 | 0.0 | 0.0 | 5.0 | 0.96 | 569.0 |
unmapped | 14.18 | 13.0 | 0.0 | 51.0 | 8.29 | 10419.0 |
crossmapping_coverage | 37.78 | 33.3 | 0.0 | 100.0 | 23.06 | NaN |
databank_coverage | 44.18 | 46.9 | 0.0 | 87.8 | 18.46 | NaN |
coverage | 81.00 | 81.2 | 50.0 | 100.0 | 8.42 | NaN |
summaryDF.to_csv(reportFolder + 'report_bulkmapping_summary' + timestamp + '.csv', index_label='parameter')