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"; } } }