function geocodeaddress($sID, $geoaddress)
{
 
 
    $db = Database::connection();
 
    define("MAPS_HOST", "maps.googleapis.com");
 
    // Initialize delay in geocode speed
    $delay = 0;
    $base_url = "https://" . MAPS_HOST . "/maps/api/geocode/";
    $key = Config::get('app.hw.api_keys.google.maps');
 
    // Iterate through the rows, geocoding each address
    $geocode_pending = true;
 
    while ($geocode_pending) {
        $request_url = $base_url . "xml?address=" . urlencode($geoaddress) . "&sensor=false&key=" . urlencode($key);
        $xml = simplexml_load_file($request_url);
        $status = $xml->status;
 
        if (strcmp($status, "OK") == 0) {
 
            // Successful geocode
            $geocode_pending = false;
 
            // Format: Longitude, Latitude, Altitude
            $lat = $xml->result->geometry->location->lat;
            $lng = $xml->result->geometry->location->lng;
            $query = sprintf("UPDATE bthwstorelocation set latitude = %s, longitude = %s where `sID` = $sID LIMIT 1;",
                             $db->quote($lat),
                             $db->quote($lng));
            $update_result = $db->query($query);
 
 
        } elseif (strcmp($status, "620") == 0) {
 
            // sent geocodes too fast
            $delay += 100000;
        } else {
 
            // failure to geocode
            $geocode_pending = false;
            $geoerror = t('Address: ') . $geoaddress . t(' failed to geocode.');
            $geostatus = t('Status ') . $status;
 
            Log::addEntry('Error GeoCoding store! ' . $geoerror . ' ' . $geostatus . ' ' . h($request_url) . ' ' . json_encode($xml,
                                                                                                                               JSON_PRETTY_PRINT));
 
        }
        usleep($delay);
    }
}