bigfunctions > validate_address
validate_address¶
Signature
validate_address(address)
Description
Validate address
using Google Maps
Examples
1. Correct address
select bigfunctions.eu.validate_address('1 Avenue des Champs-Élysées, 75008 Paris, France')
select bigfunctions.us.validate_address('1 Avenue des Champs-Élysées, 75008 Paris, France')
select bigfunctions.europe_west1.validate_address('1 Avenue des Champs-Élysées, 75008 Paris, France')
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| validation_result |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {'result': {'verdict': {'inputGranularity': 'PREMISE',
'validationGranularity': 'PREMISE',
'geocodeGranularity': 'PREMISE',
'addressComplete': True},
'address': {'formattedAddress': '1 Avenue des Champs-Élysées, 75008 Paris, France',
...},
'geocode': {'location': {'latitude': 48.8698877, 'longitude': 2.3079341},
...,
'bounds': {'low': {'latitude': 48.8698877, 'longitude': 2.3079341},
'high': {'latitude': 48.8698877, 'longitude': 2.3079341}},
...}},
'responseId': ...}
|
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2. Address with inference
select bigfunctions.eu.validate_address('1 Avenue des Champs-Élysées, 75008 Paris, France')
select bigfunctions.us.validate_address('1 Avenue des Champs-Élysées, 75008 Paris, France')
select bigfunctions.europe_west1.validate_address('1 Avenue des Champs-Élysées, 75008 Paris, France')
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| validation_result |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {'result': {'verdict': {'inputGranularity': 'PREMISE',
'validationGranularity': 'PREMISE',
'geocodeGranularity': 'PREMISE',
'addressComplete': True,
'hasUnconfirmedComponents': True,
'hasInferredComponents': True},
'address': {
'formattedAddress': '1 Avenue des Champs-Élysées, 75008 Paris, France',
'addressComponents': [
{'componentName': {'text': '1', 'languageCode': 'fr'},
'componentType': 'street_number',
'confirmationLevel': 'CONFIRMED'},
{'componentName': {'text': 'rue des champs elysees', 'languageCode': 'fr'},
'componentType': 'route',
'confirmationLevel': 'UNCONFIRMED_BUT_PLAUSIBLE'},
...,]
'unconfirmedComponentTypes': ['route']}
'geocode': {'location': {'latitude': 48.8698877, 'longitude': 2.3079341},
...,
'bounds': {'low': {'latitude': 48.8698877, 'longitude': 2.3079341},
'high': {'latitude': 48.8698877, 'longitude': 2.3079341}},
...}},
'responseId': ...}
|
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
3. Route granularity
select bigfunctions.eu.validate_address('Avenue des Champs-Élysées, 75008 Paris, France')
select bigfunctions.us.validate_address('Avenue des Champs-Élysées, 75008 Paris, France')
select bigfunctions.europe_west1.validate_address('Avenue des Champs-Élysées, 75008 Paris, France')
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| validation_result |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {'result': {'verdict': {inputGranularity': 'ROUTE',
'validationGranularity': 'ROUTE',
'geocodeGranularity': 'ROUTE'},
'address': {
'formattedAddress': 'Avenue des Champs-Élysées, 75008 Paris, France',
'addressComponents': [
{'componentName': {'text': 'Avenue des Champs-Élysées',
'languageCode': 'fr'},
'componentType': 'route',
'confirmationLevel': 'CONFIRMED'},
...,]
'missingComponentTypes': ['street_number']}
'geocode': {'location': {'latitude': 48.8729602, 'longitude': 2.2978526},
...,
'bounds': {'low': {'latitude': 48.8655318, 'longitude': 2.2952047},
'high': {'latitude': 48.8748338, 'longitude': 2.3200376}},
...}},
'responseId': ...}
|
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+