/**
* @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;
}
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++) {
$rec[$names[$c]] = $data[$c];
}
if (empty($rec['kivapin'])) {
print "ERROR: NO kivapin for line {$row} county id = " . $rec['apn'] . "\n";
$totals['input']['error']++;
continue;
}
$single_line_address = $address_converter->AddressLineStandardization($rec['address']);
$single_line_address .= ', KANSAS CITY, MO';
// We keep unit 'internal'
$normalized_address = $census->normalize_address($single_line_address);
// Strips off unit 'internal'
$address_in = array_merge(array('single_line_address' => $single_line_address), $normalized_address, $rec);
$city_address_id = $rec['kivapin'];
$county_address_id = $rec['apn'];
// We need to start out with an alias and address records
$address_id = 0;
if ($exisiting_address_alias_rec = $address_alias->find_by_single_line_address($single_line_address)) {
$totals['address_alias']['N/A']++;
$address_id = $exisiting_address_alias_rec['address_id'];
if ($exisiting_address_rec = $address->find_by_id($address_id)) {
if ($address_differences = $address->diff($exisiting_address_rec, $rec)) {
$address->update($address_id, $address_differences);
