I hereby claim:
- I am jeremybmerrill on github.
- I am jeremybmerrill (https://keybase.io/jeremybmerrill) on keybase.
- I have a public key whose fingerprint is 1B27 B244 205A C0B3 AAED 0F02 7780 C469 4F62 1BA0
To claim this, I am signing this object:
offense_id,occur_date,UC2 Literal,neighborhood,npu | |
110171050,01/14/2012,LARCENY-NON VEHICLE,Sweet Auburn,M | |
110181057,08/22/2011,LARCENY-NON VEHICLE,Glenrose Heights,Z | |
112032439,07/22/2011,AUTO THEFT,Downtown,M | |
112152334,08/03/2011,AUTO THEFT,Perkerson,X | |
113491709,12/07/2011,LARCENY-FROM VEHICLE,Hills Park,D | |
120010023,01/01/2012,AGG ASSAULT,The Villages at Carver,Y | |
120010069,12/31/2011,LARCENY-FROM VEHICLE,Old Fourth Ward,M | |
120010072,12/31/2011,LARCENY-FROM VEHICLE,English Avenue,L | |
120010086,01/01/2012,LARCENY-FROM VEHICLE,Morningside/Lenox Park,F |
<!DOCTYPE html> | |
<html> | |
<head> | |
<title>How To Cause Trouble With Events' isTrusted Attribute</title> | |
<meta charset="UTF-8"> | |
<script | |
src="http://code.jquery.com/jquery-2.2.4.min.js" | |
integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" | |
crossorigin="anonymous"></script> | |
</head> |
create table flight_segments as | |
SELECT hexid,start_time,end_time,callsign,point, | |
-- take a substring if the length reamining in the segment is greater than 5280 feet (1609.34 m) | |
-- otherwise take the remainder | |
ST_LineSubstring(geom, 1609.34*n/length, | |
CASE | |
WHEN 1609.34*(n+1) < length THEN 1609.34*(n+1)/length | |
ELSE 1 | |
END) as geom | |
FROM |
require 'sinatra' | |
require 'csv' | |
$csv_read_path = "my_thing.uncoded.csv" | |
$csv_write_path = "my_thing.coded.csv" | |
$data = CSV.read($csv_read_path, {:headers => true}) | |
def write_csv! | |
CSV.open($csv_write_path, 'wb') do |csv| |
#! /usr/bin/env ruby | |
require 'pdfshaver' | |
# brew install ghostscript imagemagick #yikes | |
# brew install tesseract --HEAD # needs >=3.04 | |
ARGV.each do |pdf| | |
puts pdf | |
pdf_basename = pdf.gsub(".pdf", '') |
# | |
# on mac, replace TABGOESHERE with a tab by typing Ctrl-V then the Tab key | |
# | |
mysql -u USERNAME --database=dbname --host=HOST --batch -e "select * from tablename" | | |
sed 's/TABGOESHERE/","/g'| sed 's/^/"/g' | sed 's/$/"/g' | sed 's/\n//g' > destination.csv | |
--- | |
cyber security: 384 | |
cyber threats: 87 | |
cyber attacks: 826 | |
cyber businesses: 1 | |
cyber protection: 1 | |
cyber espionage: 10 | |
cyber surveillance: 1 | |
cyber theft: 2 | |
cyber area: 1 |
#!/usr/bin/env ruby | |
# Tabula 0.9.6 for Windows fails: Unknown Error (206) - __UNKNOWN_CONSTANT__ | |
# for more discussion see https://github.com/tabulapdf/tabula/issues/203 | |
require 'open3' | |
revisions = ["3286e6ce0a2ee9eee617b0b1b23c3ada1effcbac", | |
"41307d4c0085a8b3bad2797549bf6b94a8a765c3", | |
"45404fa07fb3ddaf2280ec03b7d2f84e20396e88", #fails UNKNOWN_CONSTANT |
I hereby claim:
To claim this, I am signing this object: