Skip to content

Instantly share code, notes, and snippets.

View pj4533's full-sized avatar

PJ Gray pj4533

67 followers · 33 following
View GitHub Profile
@pj4533
pj4533 / no_op_cgimage.swift
Created July 1, 2023 14:03
An empty CGImage based on another CGImage
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
pj4533 / second_home_owners_lev.sql
Created April 13, 2019 13:40
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
pj4533 / second_home_owners.sql
Created April 13, 2019 13:31
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
pj4533 / tax_and_reg_join.sql
Created April 13, 2019 13:20
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
pj4533 / custom_address_field.sql
Created April 13, 2019 13:10
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
pj4533 / pambunt_query.sql
Created April 11, 2019 20:28
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
pj4533 / update_syntax.sql
Created April 11, 2019 20:27
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
pj4533 / voter_history_export.sql
Created April 11, 2019 20:24
SELECT
`state_boe_012219`.`COUNTYVRNUMBER`,
`state_boe_012219`.`VOTER_HISTORY`
FROM `state_boe_012219`
WHERE (`state_boe_012219`.`STATUS` = 'ACTIVE')
@pj4533
pj4533 / create_table.sql
Created April 8, 2019 17:04
Table structure for New York state Board of Elections data
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,
@pj4533
pj4533 / lldbjson
Created May 22, 2018 12:47
lldb JSON helpers
command regex jo 's/(.+)/po print(String(data: try! JSONSerialization.data(withJSONObject: %1, options: .prettyPrinted), encoding: .utf8 )!)/'
command regex jobj 's/(.+)/po [[NSString alloc] initWithData:[NSJSONSerialization dataWithJSONObject:%1 options:nil error:nil] encoding:nil]/'