Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- counter = 1
- if(pw['status'] == 'OK'):
- sql = 'exec myDB.dbo.USP_GEOCODE ?, ?'
- values = (str(pw), row[0])
- cursor.execute(sql, (values))
- else:
- counter += 1
- print(counter)
- {'results': [{'address_components': [{'long_name': 'Shahid Bhagat Singh Road',
- 'short_name': 'SBS Road',
- 'types': ['route']},
- {'long_name': 'Kala Ghoda',
- 'short_name': 'Kala Ghoda',
- 'types': ['political', 'sublocality', 'sublocality_level_2']},
- {'long_name': 'Fort',
- 'short_name': 'Fort',
- 'types': ['political', 'sublocality', 'sublocality_level_1']},
- {'long_name': 'Mumbai',
- 'short_name': 'Mumbai',
- 'types': ['locality', 'political']},
- {'long_name': 'Mumbai',
- 'short_name': 'Mumbai',
- 'types': ['administrative_area_level_2', 'political']},
- {'long_name': 'Maharashtra',
- 'short_name': 'MH',
- 'types': ['administrative_area_level_1', 'political']},
- {'long_name': 'India',
- 'short_name': 'IN',
- 'types': ['country', 'political']},
- {'long_name': '400001', 'short_name': '400001', 'types': ['postal_code']}],
- 'formatted_address': 'Shahid Bhagat Singh Rd, Kala Ghoda, Fort, Mumbai, Maharashtra 400001, India',
- 'geometry': {'bounds': {'northeast': {'lat': 18.9306018, 'lng': 72.835662},
- 'southwest': {'lat': 18.9301602, 'lng': 72.8351182}},
- 'location': {'lat': 18.9303522, 'lng': 72.83541559999999},
- 'location_type': 'GEOMETRIC_CENTER',
- 'viewport': {'northeast': {'lat': 18.9317299802915,
- 'lng': 72.83673908029151},
- 'southwest': {'lat': 18.9290320197085, 'lng': 72.83404111970849}}},
- 'place_id': 'ChIJvcdgwMTR5zsRQEpA9BnJgBY',
- 'types': ['route']},
- {'address_components': [{'long_name': 'Fort',
- 'short_name': 'Fort',
- 'types': ['political', 'sublocality', 'sublocality_level_1']},
- {'long_name': 'Mumbai',
- 'short_name': 'Mumbai',
- 'types': ['locality', 'political']},
- {'long_name': 'Mumbai',
- 'short_name': 'Mumbai',
- 'types': ['administrative_area_level_2', 'political']},
- {'long_name': 'Maharashtra',
- 'short_name': 'MH',
- 'types': ['administrative_area_level_1', 'political']},
- {'long_name': 'India',
- 'short_name': 'IN',
- 'types': ['country', 'political']}],
- 'formatted_address': 'Fort, Mumbai, Maharashtra, India',
- 'geometry': {'bounds': {'northeast': {'lat': 18.9490849, 'lng': 72.844617},
- 'southwest': {'lat': 18.92022, 'lng': 72.82804600000001}},
- 'location': {'lat': 18.9352599, 'lng': 72.8371511},
- 'location_type': 'APPROXIMATE',
- 'viewport': {'northeast': {'lat': 18.9490849, 'lng': 72.844617},
- 'southwest': {'lat': 18.92022, 'lng': 72.82804600000001}}},
- 'place_id': 'ChIJTRyL8MTR5zsRXqmzdxFVHvI',
- 'types': ['political', 'sublocality', 'sublocality_level_1']},
- {'address_components': [{'long_name': 'Mumbai',
- 'short_name': 'Mumbai',
- 'types': ['locality', 'political']},
- {'long_name': 'Mumbai',
- 'short_name': 'Mumbai',
- 'types': ['administrative_area_level_2', 'political']},
- {'long_name': 'Maharashtra',
- 'short_name': 'MH',
- 'types': ['administrative_area_level_1', 'political']},
- {'long_name': 'India',
- 'short_name': 'IN',
- 'types': ['country', 'political']}],
- 'formatted_address': 'Mumbai, Maharashtra, India',
- 'geometry': {'bounds': {'northeast': {'lat': 19.2716339, 'lng': 72.9864994},
- 'southwest': {'lat': 18.8928676, 'lng': 72.7758729}},
- 'location': {'lat': 19.0759837, 'lng': 72.8776559},
- 'location_type': 'APPROXIMATE',
- 'viewport': {'northeast': {'lat': 19.2716339, 'lng': 72.9864994},
- 'southwest': {'lat': 18.8928676, 'lng': 72.7758729}}},
- 'place_id': 'ChIJwe1EZjDG5zsRaYxkjY_tpF0',
- 'types': ['locality', 'political']},
- {'address_components': [{'long_name': '400001',
- 'short_name': '400001',
- 'types': ['postal_code']},
- {'long_name': 'Mumbai',
- 'short_name': 'Mumbai',
- 'types': ['locality', 'political']},
- {'long_name': 'Maharashtra',
- 'short_name': 'MH',
- 'types': ['administrative_area_level_1', 'political']},
- {'long_name': 'India',
- 'short_name': 'IN',
- 'types': ['country', 'political']}],
- 'formatted_address': 'Mumbai, Maharashtra 400001, India',
- 'geometry': {'bounds': {'northeast': {'lat': 18.9733086,
- 'lng': 72.94260009999999},
- 'southwest': {'lat': 18.9178839, 'lng': 72.8252902}},
- 'location': {'lat': 18.9385352, 'lng': 72.836334},
- 'location_type': 'APPROXIMATE',
- 'viewport': {'northeast': {'lat': 18.9496913, 'lng': 72.84690049999999},
- 'southwest': {'lat': 18.9178839, 'lng': 72.8252902}}},
- 'place_id': 'ChIJE5MNEtvR5zsRjMfa76ZglM0',
- 'types': ['postal_code']},
- {'address_components': [{'long_name': 'Mumbai',
- 'short_name': 'Mumbai',
- 'types': ['administrative_area_level_2', 'political']},
- {'long_name': 'Maharashtra',
- 'short_name': 'MH',
- 'types': ['administrative_area_level_1', 'political']},
- {'long_name': 'India',
- 'short_name': 'IN',
- 'types': ['country', 'political']}],
- 'formatted_address': 'Mumbai, Maharashtra, India',
- 'geometry': {'bounds': {'northeast': {'lat': 19.0585129, 'lng': 72.8869553},
- 'southwest': {'lat': 18.8923725, 'lng': 72.7905759}},
- 'location': {'lat': 19.0176169, 'lng': 72.8561288},
- 'location_type': 'APPROXIMATE',
- 'viewport': {'northeast': {'lat': 19.0585129, 'lng': 72.8869553},
- 'southwest': {'lat': 18.8923725, 'lng': 72.7905759}}},
- 'place_id': 'ChIJByoLeDvQ5zsRTiSNVFIfa6E',
- 'types': ['administrative_area_level_2', 'political']},
- {'address_components': [{'long_name': 'Mumbai Metropolitan Area',
- 'short_name': 'MMR',
- 'types': ['political']},
- {'long_name': 'Maharashtra',
- 'short_name': 'MH',
- 'types': ['administrative_area_level_1', 'political']},
- {'long_name': 'India',
- 'short_name': 'IN',
- 'types': ['country', 'political']}],
- 'formatted_address': 'Mumbai Metropolitan Area, Maharashtra',
- 'geometry': {'bounds': {'northeast': {'lat': 19.5920098, 'lng': 73.4755799},
- 'southwest': {'lat': 18.6465099, 'lng': 72.7166999}},
- 'location': {'lat': 19.1925506, 'lng': 73.0405277},
- 'location_type': 'APPROXIMATE',
- 'viewport': {'northeast': {'lat': 19.5920098, 'lng': 73.4755799},
- 'southwest': {'lat': 18.6465099, 'lng': 72.7166999}}},
- 'place_id': 'ChIJX9IMG5vq5zsRC2J9O0IiHzE',
- 'types': ['political']},
- {'address_components': [{'long_name': 'Maharashtra',
- 'short_name': 'MH',
- 'types': ['administrative_area_level_1', 'political']},
- {'long_name': 'India',
- 'short_name': 'IN',
- 'types': ['country', 'political']}],
- 'formatted_address': 'Maharashtra, India',
- 'geometry': {'bounds': {'northeast': {'lat': 22.028441, 'lng': 80.890924},
- 'southwest': {'lat': 15.6024121, 'lng': 72.659363}},
- 'location': {'lat': 19.7514798, 'lng': 75.7138884},
- 'location_type': 'APPROXIMATE',
- 'viewport': {'northeast': {'lat': 22.028441, 'lng': 80.890924},
- 'southwest': {'lat': 15.6024121, 'lng': 72.659363}}},
- 'place_id': 'ChIJ-dacnB7EzzsRtk_gS5IiLxs',
- 'types': ['administrative_area_level_1', 'political']},
- {'address_components': [{'long_name': 'India',
- 'short_name': 'IN',
- 'types': ['country', 'political']}],
- 'formatted_address': 'India',
- 'geometry': {'bounds': {'northeast': {'lat': 35.5087008,
- 'lng': 97.39535869999999},
- 'southwest': {'lat': 6.4626999, 'lng': 68.1097}},
- 'location': {'lat': 20.593684, 'lng': 78.96288},
- 'location_type': 'APPROXIMATE',
- 'viewport': {'northeast': {'lat': 35.5087008, 'lng': 97.39535869999999},
- 'southwest': {'lat': 6.4626999, 'lng': 68.1097}}},
- 'place_id': 'ChIJkbeSa_BfYzARphNChaFPjNc',
- 'types': ['country', 'political']}],
- 'status': 'OK'}
Add Comment
Please, Sign In to add comment