bigfunctions > reverse_geocode

reverse_geocode

Signature

reverse_geocode(latitude, longitude)

Description

Get address details at latitude, longitude using Google Maps

Examples

EUUSeurope-west1

select bigfunctions.eu.reverse_geocode(48.86988770000001, 2.3079341)

select bigfunctions.us.reverse_geocode(48.86988770000001, 2.3079341)

select bigfunctions.europe_west1.reverse_geocode(48.86988770000001, 2.3079341)

+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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"]
}
 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+