Guest User

Untitled

a guest
Oct 18th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.59 KB | None | 0 0
  1. counter = 1
  2. if(pw['status'] == 'OK'):
  3. sql = 'exec myDB.dbo.USP_GEOCODE ?, ?'
  4. values = (str(pw), row[0])
  5. cursor.execute(sql, (values))
  6. else:
  7. counter += 1
  8. print(counter)
  9.  
  10. {'results': [{'address_components': [{'long_name': 'Shahid Bhagat Singh Road',
  11. 'short_name': 'SBS Road',
  12. 'types': ['route']},
  13. {'long_name': 'Kala Ghoda',
  14. 'short_name': 'Kala Ghoda',
  15. 'types': ['political', 'sublocality', 'sublocality_level_2']},
  16. {'long_name': 'Fort',
  17. 'short_name': 'Fort',
  18. 'types': ['political', 'sublocality', 'sublocality_level_1']},
  19. {'long_name': 'Mumbai',
  20. 'short_name': 'Mumbai',
  21. 'types': ['locality', 'political']},
  22. {'long_name': 'Mumbai',
  23. 'short_name': 'Mumbai',
  24. 'types': ['administrative_area_level_2', 'political']},
  25. {'long_name': 'Maharashtra',
  26. 'short_name': 'MH',
  27. 'types': ['administrative_area_level_1', 'political']},
  28. {'long_name': 'India',
  29. 'short_name': 'IN',
  30. 'types': ['country', 'political']},
  31. {'long_name': '400001', 'short_name': '400001', 'types': ['postal_code']}],
  32. 'formatted_address': 'Shahid Bhagat Singh Rd, Kala Ghoda, Fort, Mumbai, Maharashtra 400001, India',
  33. 'geometry': {'bounds': {'northeast': {'lat': 18.9306018, 'lng': 72.835662},
  34. 'southwest': {'lat': 18.9301602, 'lng': 72.8351182}},
  35. 'location': {'lat': 18.9303522, 'lng': 72.83541559999999},
  36. 'location_type': 'GEOMETRIC_CENTER',
  37. 'viewport': {'northeast': {'lat': 18.9317299802915,
  38. 'lng': 72.83673908029151},
  39. 'southwest': {'lat': 18.9290320197085, 'lng': 72.83404111970849}}},
  40. 'place_id': 'ChIJvcdgwMTR5zsRQEpA9BnJgBY',
  41. 'types': ['route']},
  42. {'address_components': [{'long_name': 'Fort',
  43. 'short_name': 'Fort',
  44. 'types': ['political', 'sublocality', 'sublocality_level_1']},
  45. {'long_name': 'Mumbai',
  46. 'short_name': 'Mumbai',
  47. 'types': ['locality', 'political']},
  48. {'long_name': 'Mumbai',
  49. 'short_name': 'Mumbai',
  50. 'types': ['administrative_area_level_2', 'political']},
  51. {'long_name': 'Maharashtra',
  52. 'short_name': 'MH',
  53. 'types': ['administrative_area_level_1', 'political']},
  54. {'long_name': 'India',
  55. 'short_name': 'IN',
  56. 'types': ['country', 'political']}],
  57. 'formatted_address': 'Fort, Mumbai, Maharashtra, India',
  58. 'geometry': {'bounds': {'northeast': {'lat': 18.9490849, 'lng': 72.844617},
  59. 'southwest': {'lat': 18.92022, 'lng': 72.82804600000001}},
  60. 'location': {'lat': 18.9352599, 'lng': 72.8371511},
  61. 'location_type': 'APPROXIMATE',
  62. 'viewport': {'northeast': {'lat': 18.9490849, 'lng': 72.844617},
  63. 'southwest': {'lat': 18.92022, 'lng': 72.82804600000001}}},
  64. 'place_id': 'ChIJTRyL8MTR5zsRXqmzdxFVHvI',
  65. 'types': ['political', 'sublocality', 'sublocality_level_1']},
  66. {'address_components': [{'long_name': 'Mumbai',
  67. 'short_name': 'Mumbai',
  68. 'types': ['locality', 'political']},
  69. {'long_name': 'Mumbai',
  70. 'short_name': 'Mumbai',
  71. 'types': ['administrative_area_level_2', 'political']},
  72. {'long_name': 'Maharashtra',
  73. 'short_name': 'MH',
  74. 'types': ['administrative_area_level_1', 'political']},
  75. {'long_name': 'India',
  76. 'short_name': 'IN',
  77. 'types': ['country', 'political']}],
  78. 'formatted_address': 'Mumbai, Maharashtra, India',
  79. 'geometry': {'bounds': {'northeast': {'lat': 19.2716339, 'lng': 72.9864994},
  80. 'southwest': {'lat': 18.8928676, 'lng': 72.7758729}},
  81. 'location': {'lat': 19.0759837, 'lng': 72.8776559},
  82. 'location_type': 'APPROXIMATE',
  83. 'viewport': {'northeast': {'lat': 19.2716339, 'lng': 72.9864994},
  84. 'southwest': {'lat': 18.8928676, 'lng': 72.7758729}}},
  85. 'place_id': 'ChIJwe1EZjDG5zsRaYxkjY_tpF0',
  86. 'types': ['locality', 'political']},
  87. {'address_components': [{'long_name': '400001',
  88. 'short_name': '400001',
  89. 'types': ['postal_code']},
  90. {'long_name': 'Mumbai',
  91. 'short_name': 'Mumbai',
  92. 'types': ['locality', 'political']},
  93. {'long_name': 'Maharashtra',
  94. 'short_name': 'MH',
  95. 'types': ['administrative_area_level_1', 'political']},
  96. {'long_name': 'India',
  97. 'short_name': 'IN',
  98. 'types': ['country', 'political']}],
  99. 'formatted_address': 'Mumbai, Maharashtra 400001, India',
  100. 'geometry': {'bounds': {'northeast': {'lat': 18.9733086,
  101. 'lng': 72.94260009999999},
  102. 'southwest': {'lat': 18.9178839, 'lng': 72.8252902}},
  103. 'location': {'lat': 18.9385352, 'lng': 72.836334},
  104. 'location_type': 'APPROXIMATE',
  105. 'viewport': {'northeast': {'lat': 18.9496913, 'lng': 72.84690049999999},
  106. 'southwest': {'lat': 18.9178839, 'lng': 72.8252902}}},
  107. 'place_id': 'ChIJE5MNEtvR5zsRjMfa76ZglM0',
  108. 'types': ['postal_code']},
  109. {'address_components': [{'long_name': 'Mumbai',
  110. 'short_name': 'Mumbai',
  111. 'types': ['administrative_area_level_2', 'political']},
  112. {'long_name': 'Maharashtra',
  113. 'short_name': 'MH',
  114. 'types': ['administrative_area_level_1', 'political']},
  115. {'long_name': 'India',
  116. 'short_name': 'IN',
  117. 'types': ['country', 'political']}],
  118. 'formatted_address': 'Mumbai, Maharashtra, India',
  119. 'geometry': {'bounds': {'northeast': {'lat': 19.0585129, 'lng': 72.8869553},
  120. 'southwest': {'lat': 18.8923725, 'lng': 72.7905759}},
  121. 'location': {'lat': 19.0176169, 'lng': 72.8561288},
  122. 'location_type': 'APPROXIMATE',
  123. 'viewport': {'northeast': {'lat': 19.0585129, 'lng': 72.8869553},
  124. 'southwest': {'lat': 18.8923725, 'lng': 72.7905759}}},
  125. 'place_id': 'ChIJByoLeDvQ5zsRTiSNVFIfa6E',
  126. 'types': ['administrative_area_level_2', 'political']},
  127. {'address_components': [{'long_name': 'Mumbai Metropolitan Area',
  128. 'short_name': 'MMR',
  129. 'types': ['political']},
  130. {'long_name': 'Maharashtra',
  131. 'short_name': 'MH',
  132. 'types': ['administrative_area_level_1', 'political']},
  133. {'long_name': 'India',
  134. 'short_name': 'IN',
  135. 'types': ['country', 'political']}],
  136. 'formatted_address': 'Mumbai Metropolitan Area, Maharashtra',
  137. 'geometry': {'bounds': {'northeast': {'lat': 19.5920098, 'lng': 73.4755799},
  138. 'southwest': {'lat': 18.6465099, 'lng': 72.7166999}},
  139. 'location': {'lat': 19.1925506, 'lng': 73.0405277},
  140. 'location_type': 'APPROXIMATE',
  141. 'viewport': {'northeast': {'lat': 19.5920098, 'lng': 73.4755799},
  142. 'southwest': {'lat': 18.6465099, 'lng': 72.7166999}}},
  143. 'place_id': 'ChIJX9IMG5vq5zsRC2J9O0IiHzE',
  144. 'types': ['political']},
  145. {'address_components': [{'long_name': 'Maharashtra',
  146. 'short_name': 'MH',
  147. 'types': ['administrative_area_level_1', 'political']},
  148. {'long_name': 'India',
  149. 'short_name': 'IN',
  150. 'types': ['country', 'political']}],
  151. 'formatted_address': 'Maharashtra, India',
  152. 'geometry': {'bounds': {'northeast': {'lat': 22.028441, 'lng': 80.890924},
  153. 'southwest': {'lat': 15.6024121, 'lng': 72.659363}},
  154. 'location': {'lat': 19.7514798, 'lng': 75.7138884},
  155. 'location_type': 'APPROXIMATE',
  156. 'viewport': {'northeast': {'lat': 22.028441, 'lng': 80.890924},
  157. 'southwest': {'lat': 15.6024121, 'lng': 72.659363}}},
  158. 'place_id': 'ChIJ-dacnB7EzzsRtk_gS5IiLxs',
  159. 'types': ['administrative_area_level_1', 'political']},
  160. {'address_components': [{'long_name': 'India',
  161. 'short_name': 'IN',
  162. 'types': ['country', 'political']}],
  163. 'formatted_address': 'India',
  164. 'geometry': {'bounds': {'northeast': {'lat': 35.5087008,
  165. 'lng': 97.39535869999999},
  166. 'southwest': {'lat': 6.4626999, 'lng': 68.1097}},
  167. 'location': {'lat': 20.593684, 'lng': 78.96288},
  168. 'location_type': 'APPROXIMATE',
  169. 'viewport': {'northeast': {'lat': 35.5087008, 'lng': 97.39535869999999},
  170. 'southwest': {'lat': 6.4626999, 'lng': 68.1097}}},
  171. 'place_id': 'ChIJkbeSa_BfYzARphNChaFPjNc',
  172. 'types': ['country', 'political']}],
  173. 'status': 'OK'}
Add Comment
Please, Sign In to add comment