/**
* @param $in_address
* @param $in_city
* @param $in_state
* @return string
*/
function normalize_address($in_address, $in_city, $in_state)
{
$address_converter = new Convissor\address\AddressStandardizationSolution();
$single_line_address = $address_converter->AddressLineStandardization($in_address);
$single_line_address .= ', ' . strtoupper($in_city) . ', ' . strtoupper($in_state);
// We keep unit 'internal'
return $single_line_address;
}
require '../../config/config.php';
require '../../vendor/Convissor/address/AddressStandardizationSolution.php';
$census = new \Code4KC\Address\Census();
$row = 0;
$out = array();
$names = array();
global $dbh;
$totals = array('input' => array('insert' => 0, 'update' => 0, 'N/A' => 0, 'error' => 0), 'address' => array('insert' => 0, 'update' => 0, 'N/A' => 0, 'error' => 0), 'address_alias' => array('insert' => 0, 'update' => 0, 'N/A' => 0, 'error' => 0), 'address_keys' => array('insert' => 0, 'update' => 0, 'N/A' => 0, 'error' => 0), 'city_address_attributes' => array('insert' => 0, 'update' => 0, 'N/A' => 0, 'error' => 0));
if (($handle = fopen("kcmo_addresses_kiva_nbrhd_06_18_2015.csv", "r")) !== FALSE) {
try {
$dbh = new PDO("pgsql:dbname={$DB_NAME}", $DB_USER, $DB_PASS);
} catch (PDOException $e) {
error_log($e->getMessage() . ' ' . __FILE__ . ' ' . __LINE__);
throw new Exception('Unable to connect to database');
}
$address_converter = new Convissor\address\AddressStandardizationSolution();
$address = new \Code4KC\Address\Address($dbh, true);
$address_alias = new \Code4KC\Address\AddressAlias($dbh, true);
$address_keys = new \Code4KC\Address\AddressKeys($dbh, true);
$city_address_attributes = new \Code4KC\Address\CityAddressAttributes($dbh, true);
while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {
$num = count($data);
$row++;
print "{$row}\n";
if ($row == 1) {
for ($c = 0; $c < $num; $c++) {
$names[$c] = $data[$c];
}
} else {
$rec = array();
for ($c = 0; $c < $num; $c++) {
