fgregg

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

fgregg

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

fgregg

 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

fgregg

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

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

fgregg

fgregg

• 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

fgregg

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 

fgregg

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

fgregg

#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

fgregg

pums <- read.csv("small_pums.csv")

pums$ESR <- factor(pums$ESR,
                   labels=c("civilian employed, at work",
                            "civilian employed, with a job but not at work",
                            "unemployed",
                            "armed forces, at work",
                            "not in labor force"))

pums$college <- factor(pums$SCHL > 17, labels=c("no college", "some college"))