$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++) {
$rec[$names[$c]] = $data[$c];
}
if (empty($rec['kivapin'])) {
}
} else {
$ret = array('code' => 404, 'status' => 'error', 'message' => 'City ID was not valid..', 'data' => array());
}
$app->response->setStatus($ret['code']);
echo json_encode($ret);
});
$app->get('/address-attributes-city-id/V0/:id/', function ($id) use($app) {
list($city_id, $x) = explode("?", $id);
$in_city = strtoupper($app->request()->params('city'));
$in_state = strtoupper($app->request()->params('state'));
$city_id = intval($city_id);
if ($city_id) {
if (city_state_valid($in_city, $in_state)) {
if ($dbh = connect_to_address_database()) {
$address_keys = new \Code4KC\Address\AddressKeys($dbh, true);
if ($exisiting_address_alias_rec = $address_keys->find_by_city_address_id($city_id)) {
$address_id = $exisiting_address_alias_rec['address_id'];
$ret = get_address_attributes($dbh, $address_id);
} else {
$ret = array('code' => 404, 'status' => 'error', 'message' => 'Address not found', 'data' => array());
}
} else {
$ret = array('code' => 404, 'status' => 'error', 'message' => 'State or City was not valid.', 'data' => array());
}
} else {
$ret = array('code' => 500, 'status' => 'failed', 'message' => 'Unable to connect to database.', 'data' => array());
}
} else {
$ret = array('code' => 404, 'status' => 'error', 'message' => 'City ID was not valid..', 'data' => array());
}
$start_time = time();
$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_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_06152015_Parcel_PTs_Zoning.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 = new \Code4KC\Address\Address($dbh, true);
$address_keys = new \Code4KC\Address\AddressKeys($dbh, true);
$city_address_attributes = new \Code4KC\Address\CityAddressAttributes($dbh, true);
$names = array('id', 'longitude', 'latitude', 'land_use_code', 'classification', 'land_use', 'sub_class');
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$num = count($data);
$row++;
print "{$row}\n";
if ($row == 1) {
} else {
$rec = array();
for ($c = 0; $c < $num; $c++) {
$rec[$names[$c]] = $data[$c];
}
$city_address_id = $rec['id'];
if (empty($city_address_id)) {
print "EROOR: empty city id on line {$row}\n";