Database Reference
In-Depth Information
postgis_cookbook=# SELECT
chp08.Geocode('161 Court Street,
Brooklyn, NY');
INFO: Geocoing the given address using
the google api
CONTEXT: PL/Python function "geocode2"
INFO: Geocoded 161 Court Street,
Brooklyn, NY 11201, USA for the address:
161 Court Street, Brooklyn, NY
CONTEXT: PL/Python function "geocode2"
INFO: Longitude is -73.9924659, Latitude
is 40.688665.
CONTEXT: PL/Python function "geocode2"
INFO: SELECT
ST_GeomFromText('POINT(-73.9924659
40.688665)', 4326)
CONTEXT: PL/Python function "geocode2"
geocode2
----------------------------------------------------0101000020E61000004BB9B18F847F52C02E73BA2C26584440
(1 row)
5. IfyoutestitbyspecifyingadifferentAPI,itshouldreturntheresultprocessed
for the given API. For example:
postgis_cookbook=# SELECT
chp08.Geocode('161 Court Street,
Brooklyn, NY', 'GeocoderDotUS');
INFO: Geocoing the given address using
the GeocoderDotUS apiCONTEXT: PL/Python
function "geocode2"
INFO: Geocoded 161 Court St, New York,
NY 11201 for the address: 161 Court
Street, Brooklyn, NY
CONTEXT: PL/Python function "geocode2"
INFO: Longitude is -73.992809, Latitude
is 40.688774.
CONTEXT: PL/Python function "geocode2"
INFO: SELECT
