Forest Gregg fgregg

	name	address
	foo	bar

A = ADD - review of assessment
E = EXEMPT - review of exempt status of parcel, because owned by tax exempt private entity
G = GOVERNMENT - review of exempt status of parcel, because owned by a government
P = PRE-FILE give data - a review of assessment where complainant has pre-filed evidence
T = TWO TOWNSHIPS - the property straddles two townships
C = C OF C - certificate of correction, the tax assessor has made an error and is requesting an adjustment to the assessement
X = PRORATED PIN - a property that the complainant did not include in their filing, but which the BOR believes is relevant to its judgement
U = UNDERVAL - a third party complains that a property owner is paying too little taxes

Query:

select 
  max(pin::bigint) as example, 
  count(*) num_properties, 
  ROUND(current_total/current_market_value::numeric, 2::int) as assessment_level 
from taxes 
where 
 current_market_value !=0

#FG's list

Things I haven't read, but would like to

Tools for Conviviality
Some things about information systems within corporations, maybe something about Toyota and Walmart
Some things about modern public relations
Some things about the Rand Corporation
Some things about Herman Kahn and early Hudson Institute
http://www.culturemachine.net/index.php/cm/article/view/511/526

	# This software is a modified version of the bisect module found
	# https://github.com/choderalab/thresholds/blob/master/thresholds/bisect.py
	#
	# MIT License

	# Copyright (c) 2018 Chodera lab // Memorial Sloan Kettering Cancer
	# Center

	# Permission is hereby granted, free of charge, to any person
	# obtaining a copy of this software and associated documentation files

	sudo openconnect --servercert 8c4a5addfc002902f117e35c3145d6545be6d5d6 ccvendorvpn.cookcountyil.gov --dump-http-traffic
	POST https://ccvendorvpn.cookcountyil.gov/
	Attempting to connect to server 162.217.185.248:443
	Connected to 162.217.185.248:443
	SSL negotiation with ccvendorvpn.cookcountyil.gov
	Server certificate verify failed: unable to get local issuer certificate
	Connected to HTTPS on ccvendorvpn.cookcountyil.gov
	> POST / HTTP/1.1
	> Host: ccvendorvpn.cookcountyil.gov
	> User-Agent: Open AnyConnect VPN Agent v7.08

	O 2017-6854 Amendment of Municipal Code 9-115-150, 9-114-265 - Transportation network driver fingerprint/photo requirements and fare rates higher than regular rates
	O 2017-6485 Amendment of Municipal Code Chapter 5-12 by modifying various sections of Residential Landlord and Tenants Ordinance concerning landlord access to dwelling unit, building security, and tenant immigration status
	O 2017-225 Amendment of Municipal Code Chapter 10-36 by adding new Section 10-36-215 concerning ground handling service contracts
	O 2016-5666 Creation of Public School Revitalization Grant for distribution of tax increment financing (TIF) Surplus Funds to financially distressed school districts
	O 2017-1018 Amendment of Municipal Code Chapter 2-173 regarding Welcoming City Ordinance
	O 2017-3200 Amendment of Municipal Code Chapter 4-4 by adding new Section 4-4-340 requiring licensed establishments to allow non-patrons to use public toilet facilities for emergency purposes
	O 2017-3289 Amendment of Munic

	O 2017-6854
	Or 2016-673
	O 2017-6485
	R 2017-734
	O 2017-225
	R 2017-726
	O 2016-5666
	O 2017-1018
	R 2016-908
	Or 2017-365

	#!/usr/bin/env python
	# -- coding: utf-8 --

	import os
	import csv
	import tempfile
	import time
	import logging
	import optparse
	import itertools

	Buildings,https://data.cityofchicago.org/resource/ucsz-xe6d.json?$select=date_trunc_y(date_received)%20as%20year,COUNT(*)&$group=year&$order=year
	Revenue,https://data.cityofchicago.org/resource/zrv6-shhf.json?$select=date_trunc_y(date_received)%20as%20year,COUNT(*)&$group=year&$order=year
	311,https://data.cityofchicago.org/resource/j2p9-gdf5.json?$select=date_trunc_y(date_received)%20as%20year,COUNT(*)&$group=year&$order=year
	Transportation,https://data.cityofchicago.org/resource/u9qt-tv7d.json?$select=date_trunc_y(date_received)%20as%20year,COUNT(*)&$group=year&$order=year
	Law,https://data.cityofchicago.org/resource/44bx-ncpi.json?$select=date_trunc_y(date_received)%20as%20year,COUNT(*)&$group=year&$order=year