geocode¶

Signature

geocode(address)

Description

Get address details from Google Maps

Examples

EUUSeurope-west1

select bigfunctions.eu.geocode('1 rue des champs elysees, Paris')

select bigfunctions.us.geocode('1 rue des champs elysees, Paris')

select bigfunctions.europe_west1.geocode('1 rue des champs elysees, Paris')

+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| address_details                                                                                                                                                                                                                                                                                                                                                 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {
    "address_components": [...],
    "formatted_address": "1 Av. des Champs-Élysées, 75008 Paris, France",
    "geometry": {
        "location": {
            "lat": 48.86988770000001,
            "lng": 2.3079341
        },
        ...
    },
    "place_id": "ChIJ6499V8Rv5kcR5f9dbz3OeBI",
    "plus_code": {...},
    "types": ["street_address"]
}
 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+