Geocodes an address string into a structured result containing the location geometry, a confidence score, and the scoring algorithm used. This function performs forward geocoding, converting a textual address or place name into geographic coordinates.
Signatures
ST_Geocode(location: String)
Parameters
The address or place name to geocode.
Return type
A struct containing:
location: The matched location string.geometry: The point geometry of the geocoded location.score: A confidence score for the match.score_algorithm: The algorithm used to compute the score.
Examples
SELECT ST_Geocode('1600 Pennsylvania Avenue NW, Washington, DC')
SELECT result.geometry, result.score
FROM (SELECT ST_Geocode('San Francisco, CA') AS result)
