pj4533

Look thru the whole code base for any files bigger than 300 lines. Refactor any file over 300 lines to be smaller. Consider separation of concerns and keep things organized and tidy.

DO NOT CHANGE ANY FUNCTIONALITY.

• For classes, separate into extensions, named and grouped appropriately.
• For views, split into subviews

Remember: only one object per file, so if some files have multiple objects thats an easy place to start.

pj4533

    func createBlackCGImage(basedOn originalImage: CGImage) -> CGImage? {
        let width = originalImage.width
        let height = originalImage.height
        let bitsPerComponent = originalImage.bitsPerComponent
        let bytesPerRow = originalImage.bytesPerRow
        let colorSpace = originalImage.colorSpace ?? CGColorSpace(name: CGColorSpace.sRGB)!
        let bitmapInfo = originalImage.bitmapInfo

        // Create an empty context with the same parameters as the original image
        guard let context = CGContext(data: nil,

pj4533

SELECT * FROM (
	SELECT 
		`dutchess_tax_roll`.`parcel_location_address`,
		`dutchess_tax_roll`.`primary_owner`,
		`dutchess_tax_roll`.`street_address`,
		`dutchess_tax_roll`.`loc_st_name`,
		`dutchess_tax_roll`.`city_state_zip_code`,
		levenshtein(`dutchess_tax_roll`.`parcel_location_address`, `dutchess_tax_roll`.`street_address`) as lev_distance
	FROM `state_boe_active_012219`
	RIGHT JOIN `dutchess_tax_roll` ON (

pj4533

SELECT 
	`dutchess_tax_roll`.`parcel_location_address`,
	`dutchess_tax_roll`.`primary_owner`,
	`dutchess_tax_roll`.`street_address`,
	`dutchess_tax_roll`.`loc_st_name`,
	`dutchess_tax_roll`.`city_state_zip_code`
FROM `state_boe_active_012219`
RIGHT JOIN `dutchess_tax_roll` ON (
	`dutchess_tax_roll`.`parcel_location_address` = `state_boe_active_012219`.`CUSTOM_STREET_ADDRESS`
)

pj4533

SELECT 
	`dutchess_tax_roll`.`parcel_location_address`,
	`dutchess_tax_roll`.`primary_owner`,
	`dutchess_tax_roll`.`street_address`,
	`dutchess_tax_roll`.`loc_st_name`,
	`dutchess_tax_roll`.`city_state_zip_code`
FROM `state_boe_active_012219`
RIGHT JOIN `dutchess_tax_roll` ON (
	`dutchess_tax_roll`.`parcel_location_address` = `state_boe_active_012219`.`CUSTOM_STREET_ADDRESS`
)

pj4533

UPDATE `state_boe_active_012219`
SET `state_boe_active_012219`.`CUSTOM_STREET_ADDRESS` = CONCAT(`state_boe_active_012219`.`RADDNUMBER`, ' ',`state_boe_active_012219`.`RSTREETNAME`)

pj4533

SELECT * from `state_boe_012219`
WHERE 
 (`state_boe_012219`.`CLEANED_VOTER_HISTORY` LIKE '%GE16%') AND
 (`state_boe_012219`.`CLEANED_VOTER_HISTORY` LIKE '%GE18%') AND
 (`state_boe_012219`.`CLEANED_VOTER_HISTORY` NOT LIKE '%GE17%')

pj4533

UPDATE `state_boe_012219` SET `state_boe_012219`.`CLEANED_VOTER_HISTORY` = 'GE18GE17GE16PP16GE12GE10GE08PP08GE06GE05GE04GE03GE02' WHERE `state_boe_012219`.`COUNTYVRNUMBER` = '918273';
UPDATE `state_boe_012219` SET `state_boe_012219`.`CLEANED_VOTER_HISTORY` = 'GE18GE03GE02' WHERE `state_boe_012219`.`COUNTYVRNUMBER` = '817623';

pj4533

SELECT 
 `state_boe_012219`.`COUNTYVRNUMBER`,
 `state_boe_012219`.`VOTER_HISTORY`
FROM `state_boe_012219` 
WHERE (`state_boe_012219`.`STATUS` = 'ACTIVE')

pj4533

CREATE TABLE `state_boe` (
  `LASTNAME` varchar(255) DEFAULT NULL,
  `FIRSTNAME` varchar(255) DEFAULT NULL,
  `MIDDLENAME` varchar(255) DEFAULT NULL,
  `NAMESUFFIX` varchar(255) DEFAULT NULL,
  `RADDNUMBER` varchar(255) DEFAULT NULL,
  `RHALFCODE` varchar(255) DEFAULT NULL,
  `RAPARTMENT` varchar(255) DEFAULT NULL,
  `RPREDIRECTION` varchar(255) DEFAULT NULL,
  `RSTREETNAME` varchar(255) DEFAULT NULL,