public function run()
{
$fh = fopen(dirname(__FILE__) . '/zip_code_database_commercial.csv', 'r');
$count = 0;
while (($line = fgetcsv($fh)) !== false) {
if ($line[0] == 0 || $line[5] == 'PR' || $line[5] == 'VI') {
// Puerto Rico or Virgin Islands
continue;
}
$zip = new ZipCode(['zip' => $line[0], 'city' => $line[2], 'state' => $line[5], 'county' => $line[6], 'latitude' => $line[11], 'longitude' => $line[12]]);
$zip->save();
$count++;
if ($count % 1000 == 0) {
echo "Added " . $count . " zip codes (Most recent: " . $line[0] . ")\n";
}
}
}