freshyo/address_util/area-name-report.txt
2026-10-25 16:17:35 +05:30

568 lines
29 KiB
Text

==============================================================================
AREA / LOCALITY REPORT — vague-backfilled addresses
==============================================================================
Generated: 2026-10-25 13:01 IST
Source db: apps/backend/.wrangler/state/v3/d1/miniflare-D1DatabaseObject/da3a80bd8d2cc8f1f070a313ef55c1800da50af994fa89a51c67a6d3e1f919f2.sqlite
Rows: 416 (vague_backfilled_coords = 1, region 1)
Assigned: 352 (84.6%)
No area: 64
Areas 2+: 55
Areas 1: 38
Dropped: 3 area(s) whose addresses now have admin coords: GPY Colony, Mohamadia Colony, Premnagar
==============================================================================
REPEATED AREAS (2 or more addresses)
==============================================================================
count area
------------------------------------------------------------------------------
27 Shah Saheb Gutta
23 Marlu
20 Mothinagar
14 BK Reddy Colony
12 Habeebnagar
11 Bhageeratha Colony
11 Gol Masjid
11 Ramaiah Bowli
10 Yenugonda
9 Rajendranagar
9 Veerannapet
8 Old Palamoor
7 Lakshmi Nagar Colony
7 Noor Nagar
7 Srinivas Colony
7 TD Gutta
6 BC Colony
6 Hanumanpura
6 RB Palace
5 New Town
5 Shiva Shakti Nagar
4 Brundavan Colony
4 Metugadda
4 Padmavati Colony
4 Palasa Gutta
4 Tayyab Nagar
4 Teachers Colony
4 Venkateshwara Colony
3 Bandameedhi Pally
3 Bhavani Nagar Colony
3 Boyapalli Gate
3 Ganesh Nagar
3 Madina Masjid
3 Masoodnagar
3 Old Hospital Area
3 Palkonda
3 Sagara Colony
3 Vasavi Colony
3 Yedira
2 Alipur
2 Amistapur
2 BN Reddy Colony
2 Christianpally
2 Devuni Gutta
2 Employees Colony
2 Housing Board Colony
2 Kisan Nagar
2 Kurhinishetty Colony
2 Nalbowli
2 Police Line
2 Ravindra Nagar
2 SC Colony
2 Sriram Nagar
2 Tipu Sultan Chowk
2 Vigneshwara Colony
==============================================================================
NOTABLE SPELLING / TRANSLITERATION VARIANTS
==============================================================================
Same place written in more than one way in the address data:
Shah Saheb Gutta <- Shashabgutta, Shah Sahab Gutta, Shah Shab Gutta, Shab Gutta, Shasabgutta, S.S. Gutta, S Guyta
Mothinagar <- Motinagar, Mothi Nagar (incl. "FCD gown motinagar")
Habeebnagar <- Habeeb Nagar (spacing only)
Yenugonda <- Yanugonda, Yenukonda, Yengonda, Youngunda
Bhageeratha Colony <- Bhageritha, Bhagiratha, Bhageerata, Bhageratha
Ramaiah Bowli <- Ramiah Bowli, Ramaiya Bowli, Ramaiyah Bowli, Ramiya Boli, Rama Bouli
Veerannapet <- Veeranapet, Veernapet, Veerana Pet
Lakshmi Nagar Colony <- Laxmi Nagar, Laxminagar, Laxhmenager
Masoodnagar <- Masdoos Nagar, Masdusnagar, Masoosnagar
Tayyab Nagar <- Tayaabnagar
Kurhinishetty Colony <- Kuruhini Shetty Colony
Gol Masjid <- Goal Masjid, Golmasjid
Palasa Gutta <- Palsab Gutta
Tipu Sultan Chowk <- Tippu Sultan Chowk
Boyapalli Gate <- Boyapally, Boyepally
Palkonda <- Palakonda, Palkunda
BC Colony <- B.C. Colony
Kranti Nagar <- Kranti Nager
Srinivas Colony <- Srinivasa Colony, Srinivasa Coloney
Bhavani Nagar Colony <- Bhavaninagar Colony
Padmavati Colony <- Padmavathi, Padhmmavathi
Vigneshwara Colony <- Vigneswara Colony
Shiva Shakti Nagar <- Shiva Shakthi Nagar
Rajendranagar <- Rajendra Nagar
Noor Nagar <- Noori Nagar
Nalbowli <- Nailbowli
Old Palamoor <- Palamoor, Palamour
POSSIBLY DISTINCT — similar names, kept separate
BK Reddy Colony vs BN Reddy Colony <- different initials, not merged
Christianpally vs Christian Colony
New Gunj vs Gunj / Cheruvu Gunj
Pochamma Colony vs Pochamma temple (landmark only)
==============================================================================
AREA DETAIL + SPELLING VARIANTS
==============================================================================
Shah Saheb Gutta — 27 addresses
------------------------------------------------------------------------------
5x shashabgutta ids: 154, 392, 684, 834, 872
5x shah sahab gutta ids: 169, 182, 305, 383, 487
4x shah saheb gutta ids: 492, 785, 825, 912
3x shab gutta ids: 549, 594, 811
3x shashab gutta ids: 552, 593, 607
2x s s gutta ids: 141, 682
2x shah shab gutta ids: 245, 333
1x s guyta ids: 23
1x ss gutta ids: 116
1x shahab gutta ids: 755
Marlu — 23 addresses
------------------------------------------------------------------------------
23x marlu ids: 139, 142, 146, 162, 185, 228, 230, 235, 251, 254, 289, 302 ...
Mothinagar — 20 addresses
------------------------------------------------------------------------------
14x motinagar ids: 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15 ...
4x mothinagar ids: 22, 216, 278, 373
2x mothi nagar ids: 30, 178
BK Reddy Colony — 14 addresses
------------------------------------------------------------------------------
7x bk reddy colony ids: 52, 197, 248, 282, 321, 327, 635
5x b k reddy colony ids: 128, 288, 741, 766, 817
1x b k ready colony ids: 125
1x bk reddy ids: 446
Habeebnagar — 12 addresses
------------------------------------------------------------------------------
8x habeeb nagar ids: 42, 66, 73, 124, 135, 166, 347, 648
4x habeebnagar ids: 108, 150, 153, 874
Bhageeratha Colony — 11 addresses
------------------------------------------------------------------------------
6x bhageeratha ids: 151, 299, 381, 391, 589, 768
1x bhageerata ids: 45
1x bhageritha ids: 99
1x bhageerath ids: 225
1x bhagiratha ids: 587
1x bhageratha ids: 883
Gol Masjid — 11 addresses
------------------------------------------------------------------------------
6x gol masjid ids: 34, 93, 120, 463, 643, 909
3x goal masjid ids: 41, 55, 83
1x gaolnl masjid ids: 51
1x golmasjid ids: 119
Ramaiah Bowli — 11 addresses
------------------------------------------------------------------------------
7x ramaiah bowli ids: 98, 131, 171, 229, 262, 320, 518
1x ramaiyah bowli ids: 348
1x rama bouli ids: 426
1x ramaiahbowli ids: 508
1x ramiya boli ids: 830
Yenugonda — 10 addresses
------------------------------------------------------------------------------
6x yenugonda ids: 539, 626, 730, 816, 843, 897
2x yanugonda ids: 415, 491
1x youngunda ids: 204
1x yenukonda ids: 490
Rajendranagar — 9 addresses
------------------------------------------------------------------------------
5x rajendra nagar ids: 258, 269, 316, 511, 738
4x rajendranagar ids: 259, 260, 497, 638
Veerannapet — 9 addresses
------------------------------------------------------------------------------
4x veerannapet ids: 489, 620, 656, 783
2x veernapet ids: 57, 91
2x veeranapet ids: 425, 544
1x veerana pet ids: 111
Old Palamoor — 8 addresses
------------------------------------------------------------------------------
8x palamoor ids: 32, 155, 165, 291, 338, 351, 494, 692
Lakshmi Nagar Colony — 7 addresses
------------------------------------------------------------------------------
3x laxminagar ids: 273, 366, 390
2x lakshmi nagar ids: 659, 849
1x laxhmenager ids: 227
1x laxmi nagar ids: 368
Noor Nagar — 7 addresses
------------------------------------------------------------------------------
6x noor nagar ids: 1, 2, 3, 21, 25, 74
1x noori nagar ids: 137
Srinivas Colony — 7 addresses
------------------------------------------------------------------------------
3x srinivas colony ids: 84, 357, 877
3x srinivasa colony ids: 90, 613, 665
1x srinivasa coloney ids: 195
TD Gutta — 7 addresses
------------------------------------------------------------------------------
4x td gutta ids: 43, 261, 276, 485
3x t d gutta ids: 36, 101, 421
BC Colony — 6 addresses
------------------------------------------------------------------------------
4x b c colony ids: 451, 452, 453, 454
2x bc colony ids: 625, 698
Hanumanpura — 6 addresses
------------------------------------------------------------------------------
3x hanumanpura ids: 234, 524, 848
2x hanuman pura ids: 196, 520
1x hanmanpura ids: 870
RB Palace — 6 addresses
------------------------------------------------------------------------------
5x rb palace ids: 100, 103, 114, 188, 203
1x rb palce ids: 577
New Town — 5 addresses
------------------------------------------------------------------------------
3x newtown ids: 268, 287, 459
1x newton ids: 218
1x new town ids: 430
Shiva Shakti Nagar — 5 addresses
------------------------------------------------------------------------------
3x shiva shakti nagar ids: 106, 507, 753
2x shiva shakthi nagar ids: 164, 616
Brundavan Colony — 4 addresses
------------------------------------------------------------------------------
3x brundavan ids: 102, 324, 360
1x brundavanam ids: 186
Metugadda — 4 addresses
------------------------------------------------------------------------------
2x mettugadda ids: 440, 846
2x metugadda ids: 567, 717
Padmavati Colony — 4 addresses
------------------------------------------------------------------------------
2x padmavati ids: 112, 588
2x padmavathi ids: 864, 886
Palasa Gutta — 4 addresses
------------------------------------------------------------------------------
1x palsabgutta ids: 483
1x palsab guta ids: 591
1x palasa gutta ids: 857
1x palsab gutta ids: 882
Tayyab Nagar — 4 addresses
------------------------------------------------------------------------------
2x tayyab nagar ids: 173, 754
1x tayaabnagar ids: 530
1x tayyabnagar ids: 554
Teachers Colony — 4 addresses
------------------------------------------------------------------------------
3x teachers colony ids: 462, 722, 795
1x teacher s colony ids: 81
Venkateshwara Colony — 4 addresses
------------------------------------------------------------------------------
2x venkateshwara colony ids: 46, 482
2x venkateswara colony ids: 614, 756
Bandameedhi Pally — 3 addresses
------------------------------------------------------------------------------
1x bandameedipalli ids: 386
1x bandamidepally ids: 622
1x bandameedhi pally ids: 631
Bhavani Nagar Colony — 3 addresses
------------------------------------------------------------------------------
2x bhavani nagar ids: 95, 199
1x bhavaninagar ids: 550
Boyapalli Gate — 3 addresses
------------------------------------------------------------------------------
2x boyapally ids: 679, 784
1x boyapalli ids: 658
Ganesh Nagar — 3 addresses
------------------------------------------------------------------------------
3x ganesh nagar ids: 312, 411, 903
Madina Masjid — 3 addresses
------------------------------------------------------------------------------
3x madina masjid ids: 88, 89, 238
Masoodnagar — 3 addresses
------------------------------------------------------------------------------
1x masdusnagar ids: 274
1x masdoos nagar ids: 290
1x masoosnagar ids: 374
Old Hospital Area — 3 addresses
------------------------------------------------------------------------------
3x old hospital ids: 330, 331, 417
Palkonda — 3 addresses
------------------------------------------------------------------------------
1x palkunda ids: 211
1x palkonda ids: 323
1x palakonda ids: 818
Sagara Colony — 3 addresses
------------------------------------------------------------------------------
3x sagara colony ids: 35, 695, 871
Vasavi Colony — 3 addresses
------------------------------------------------------------------------------
2x vasavi ids: 183, 271
1x vasavidegree ids: 220
Yedira — 3 addresses
------------------------------------------------------------------------------
2x yedira ids: 688, 799
1x edira ids: 60
Alipur — 2 addresses
------------------------------------------------------------------------------
2x alipur ids: 504, 632
Amistapur — 2 addresses
------------------------------------------------------------------------------
1x amistapur ids: 534
1x amisthapur ids: 829
BN Reddy Colony — 2 addresses
------------------------------------------------------------------------------
1x bn reddy colony ids: 279
1x b n reddy colony ids: 379
Christianpally — 2 addresses
------------------------------------------------------------------------------
1x christianpally ids: 222
1x christian palli ids: 775
Devuni Gutta — 2 addresses
------------------------------------------------------------------------------
1x devunigutta ids: 359
1x tirumala devun gutta ids: 456
Employees Colony — 2 addresses
------------------------------------------------------------------------------
2x employees colony ids: 117, 121
Housing Board Colony — 2 addresses
------------------------------------------------------------------------------
2x housing board colony ids: 568, 670
Kisan Nagar — 2 addresses
------------------------------------------------------------------------------
2x kisan nagar ids: 345, 704
Kurhinishetty Colony — 2 addresses
------------------------------------------------------------------------------
1x kuruhini shetty ids: 619
1x kurhinishetty ids: 644
Nalbowli — 2 addresses
------------------------------------------------------------------------------
1x nailbowli ids: 179
1x nal bowli ids: 272
Police Line — 2 addresses
------------------------------------------------------------------------------
2x police line ids: 431, 432
Ravindra Nagar — 2 addresses
------------------------------------------------------------------------------
1x ravindra nagar ids: 303
1x ravindranagar ids: 745
SC Colony — 2 addresses
------------------------------------------------------------------------------
1x sc colony ids: 624
1x s c colony ids: 706
Sriram Nagar — 2 addresses
------------------------------------------------------------------------------
1x sri rama colony ids: 609
1x sriram nagar ids: 713
Tipu Sultan Chowk — 2 addresses
------------------------------------------------------------------------------
2x tipu sultan chowk ids: 236, 427
Vigneshwara Colony — 2 addresses
------------------------------------------------------------------------------
2x vigneshwara ids: 304, 649
==============================================================================
ADDRESSES THAT MENTION MORE THAN ONE AREA
==============================================================================
Grouped under the first (more specific) area; the others are listed too.
id grouped under also mentions
------------------------------------------------------------------------------
98 Ramaiah Bowli One Town
101 TD Gutta Nalbowli
139 Marlu Employees Colony
146 Marlu Employees Colony
222 Christianpally Bhavani Nagar Colony
271 Vasavi Colony Yenugonda
290 Masoodnagar Gol Masjid
304 Vigneshwara Colony Marlu
333 Shah Saheb Gutta Tipu Sultan Chowk
345 Kisan Nagar Old Hospital Area
366 Lakshmi Nagar Colony Venkateshwara Colony
451 BC Colony Yenugonda
452 BC Colony Yenugonda
453 BC Colony Yenugonda
454 BC Colony Yenugonda
550 Bhavani Nagar Colony Christianpally
554 Tayyab Nagar Ramaiah Bowli, RB Palace
578 Mythri Nagar Balaji Nagar
596 New Gunj Gunj
609 Sriram Nagar Yenugonda
625 BC Colony Amistapur
649 Vigneshwara Colony Marlu
655 Pochamma Colony Yenugonda
656 Veerannapet Madina Masjid
695 Sagara Colony Yenugonda
713 Sriram Nagar Yenugonda
761 Dhanalaxmi Colony Teachers Colony
858 Chaitanya Nagar Colony Yedira
887 Marlu Shah Saheb Gutta
==============================================================================
AREAS WITH EXACTLY ONE ADDRESS
==============================================================================
AZ Colony id 401 line2: Opp municipal park az colony ground floor
Ayodhyanagar Colony id 190 line2: Junaid ku maalum hai...
Balaji Nagar id 809 line2: (blank line2)
Chaitanya Nagar Colony id 858 line2: Chaitanya nagar colony yedira road
Chinndharpally id 714 line2: (blank line2)
Christian Colony id 807 line2: (blank line2)
Dhanalaxmi Colony id 761 line2: Beside anjaneya temple and behind oak ridge school
Divitipally id 538 line2: (blank line2)
Doddalonipally id 844 line2: Masjid arafath pillamari road
Jayashankar Colony id 385 line2: Near bypass road , near chowrasta
KTR Nagar id 253 line2: (blank line2)
Kamla Nehru Colony id 743 line2: Behind Avanthi hotel,kamla nehru colony
Khaleel Chowk id 461 line2: Khaleel chok
Kidwaipet id 673 line2: Old bustand
Kranti Nagar id 618 line2: (blank line2)
Madhuranagar Colony id 295 line2: (blank line2)
Madugu Nagar Colony id 600 line2: Madugu nagar colony opp Hanuman temple
Manikonda id 875 line2: Manikonda
Manyamkonda id 159 line2: (blank line2)
Maruthi Nagar id 708 line2: Maruthi Nagar road number 2
Mythri Nagar id 578 line2: House no 14-4-186-C
Nagireddy Colony id 575 line2: Road number 5
New Gate id 460 line2: Ali Masjid
New Gunj id 596 line2: New gunj
One Town id 172 line2: 1 town back side alis mart colony
Panchowrastha id 56 line2: Panchowrastha
Pasula Kistta Reddy Colony id 283 line2: (blank line2)
Pochamma Colony id 655 line2: (blank line2)
Pragathi Nagar id 309 line2: Near park
Raj Colony id 406 line2: Right second house
Sathyamanna Colony id 650 line2: (blank line2)
Siddarth Nagar id 769 line2: Back side eenadu office
Subhash Nagar id 782 line2: (blank line2)
Talab Katta id 44 line2: Talab katta
Veepurigeri id 780 line2: Near Hanuman temple
Veerabhadra Colony id 592 line2: Patha gate mahabubnagar
Vinayaka Nagar id 642 line2: Vinayaka nagar colony mahabubnagar bypass road str
Vivekananda Colony id 667 line2: Near ram reddy eye hospital
==============================================================================
NO AREA DETECTED (landmark / junk / city only)
==============================================================================
id 28 line2: H line1: Hh
id 29 line2: H line1: Hh
id 31 line2: 11 line1: 1-10
id 33 line2: (blank line2) line1: Yogi tiffin
id 37 line2: (blank line2) line1: Hjuu
id 39 line2: (blank line2) line1: near bharath talkies road,beside punjab bakery
id 40 line2: Address line 2 optional line1: Address line 1
id 53 line2: Opp golbanglaw beside royal cement n steel line1: House no 1-1-77/b/3
id 69 line2: Fz water plant patel masjid line1: 3-11-137/A/11Veernapet shareef calony
id 86 line2: (blank line2) line1: Balaji convention hall
id 87 line2: (blank line2) line1: rayeesa masjid trasfaram mbnr
id 94 line2: Near, Masjid e Mustafa line1: H.no 14-8-121
id 96 line2: (blank line2) line1: Opposite of Malabar gold and diamonds
id 126 line2: Opp rayeesa masjid line line1: H.no.5-7-30/L/10/C
id 138 line2: Pasula kistta reddy colony line1: 14_6_13/9/a2
id 147 line2: 1-10-87/3/A line1: 1-10-87/3/A
id 157 line2: Beside masjid e ibrahim back road line1: 14-6-14/6
id 184 line2: (blank line2) line1: 1-10-95/A/5 Behind Cosmic Sanitary Near Graveyard Main Gate
id 205 line2: (blank line2) line1: Near karishma kiranam
id 208 line2: Just opposite to dmart nallagandla line1: A 2004,aprna sarovar zenith near neo mall
id 210 line2: (blank line2) line1: Opposite pragna high school
id 214 line2: (blank line2) line1: C-71
id 215 line2: Near daksha high school line1: Malabargold beside lane
id 224 line2: 5-7-35/l/9 line1: Khaja kiranam
id 246 line2: Imran kiranam line1: Pochamma temple
id 249 line2: (blank line2) line1: Near Almas function hall
id 277 line2: Dargah line1: 5-64/c
id 285 line2: Mbnr line1: Mbnr
id 311 line2: H.no.1-10-19/3/6/a line1: Two taps
id 336 line2: (blank line2) line1: N
id 350 line2: (blank line2) line1: Neat o baby store
id 358 line2: (blank line2) line1: SVS medical collage pg boys hostel
id 363 line2: (blank line2) line1: Mahabubnagar
id 377 line2: (blank line2) line1: SVS staff quarters 303
id 382 line2: (blank line2) line1: Near fareed madarsa street no. 3
id 387 line2: Sofiya masjid line1: Devar katra raad
id 435 line2: Opp Hdfc bank Standard Electrical line1: 5-4-102 ,Taj-Un-Najm,
id 439 line2: Beside iron shop green gate 1st floor line1: 2-9-15 expert high school lane opposite transformer
id 465 line2: Near asif kiranam store line1: Basravi function hall
id 471 line2: Police headcoutar line1: Monappagutta chai duniya
id 477 line2: Grave yard line1: Behind Cosmic sanitary
id 488 line2: (blank line2) line1: Panchavati school
id 496 line2: Bsn Reddy apartment 1 flour line1: Goutam hospital opposite
id 525 line2: Ground floor line1: Near navodaya hospital
id 547 line2: (blank line2) line1: Mlm na 😜
id 564 line2: (blank line2) line1: Flat no 3007 3rd floor PBR Residency
id 573 line2: Near Nalanda Auto Stand line1: F.n.414,Metropolis Manatown Aprtment
id 602 line2: Shivalayam temple road line1: Near Fathima Vidyalayam school,
id 605 line2: (blank line2) line1: Near janatha garrage
id 640 line2: Old Central library line1: Old Central library
id 691 line2: Near svs near hospital and college line1: Sai ram mess
id 707 line2: (blank line2) line1: 14-11-8/5/2 near mi Eden plaza function hall
id 726 line2: Dk aruna downstreet line1: Bangaru mysamma temple opp street
id 735 line2: Meraj masjid gate opposite lane line1: Saddalgundu
id 744 line2: Opposite Gayatri appartment line1: Aleem trader's
id 788 line2: Near pista House bypass 🛣️ line1: PBR residency 3rd floor b block 3016
id 808 line2: Hanuman temple line1: Svdc college back side Hanuman temple
id 814 line2: Near srikrishna theatre mahabubnagar line1: Aleem traders opposite Gayatri appartment
id 820 line2: (blank line2) line1: Samreen chicken center
id 855 line2: Opposite Sarika township flat no.505 line1: Giridhari construction , green meridian county
id 856 line2: Opposite Sarika township line1: Giridhari construction green meridian apartment
id 859 line2: Akbar masjid road line1: Mg functional
id 862 line2: Near nalanda auto stand line1: Kakatiya techno school
id 898 line2: (blank line2) line1: Habeeb manzil
==============================================================================