stevevance’s gists

stevevance / truckee_opacity.yaml

Created September 30, 2016 00:15

Futzing with opacity for Truckee transit

	import: https://mapzen.com/carto/zinc-style/zinc-style.yaml

	sources:
	mapzen:
	type: TopoJSON
	url: https://vector.mapzen.com/osm/all/{z}/{x}/{y}.topojson
	coverage:
	type: GeoJSON
	url: https://transit.land/api/v1/operators/o-9qfx-tahoeareametroaltransit.geojson
	#url: https://transit.land/api/v1/feeds/f-9qf-laketahoe~ca~us.geojson

stevevance / chicago_stadia.geojson

Created October 2, 2016 14:27

Stadiums in Chicagoland, per OpenStreetMap via Overpass Turbo

Sorry, something went wrong. Reload?

Sorry, we cannot display this file.

Sorry, this file is invalid so it cannot be displayed.

stevevance / Illinois Funds (with a capital F).txt

Created October 17, 2016 18:30

A list of Illinois Funds with a capital F derived from the FY17 enacted appropriations line item detail spreadsheet

	Abandoned Mined Lands Reclamation Council Federal Trust Fund 22
	Abandoned Residential Property Municipality Relief Fund 1
	Academic Quality Assurance Fund 1
	Access to Justice Fund 1
	Accessible Electronic Information Service Fund 1
	Adeline Jay Geo-Karis Illinois Beach Marina Fund 2
	Aeronautics Fund 2
	African-American HIV/AIDS Response Fund 1
	After-School Rescue Fund 1
	Aggregate Operations Regulatory Fund 4

stevevance / violations_stop_work_order.yaml

Last active October 25, 2016 04:12

Tangram scene to show Chicago building violations for "stop work order"

	#import: https://mapzen.com/carto/tron-style/tron-style.zip
	import: https://mapzen.com/carto/zinc-style-more-labels/zinc-style-more-labels.yaml

	sources:
	mapzen:
	type: TopoJSON
	url: https://vector.mapzen.com/osm/all/{z}/{x}/{y}.topojson

	stops:
	type: GeoJSON

stevevance / stop_work_orders_labels.yaml

Created October 25, 2016 05:00

Tangram scene file for stop work order violations - fixing labels

	#import: https://mapzen.com/carto/tron-style/tron-style.zip
	import: https://mapzen.com/carto/zinc-style/zinc-style.yaml

	sources:
	mapzen:
	type: TopoJSON
	url: https://vector.mapzen.com/osm/all/{z}/{x}/{y}.topojson

	stops:
	type: GeoJSON

stevevance / queries.sql

Last active December 9, 2016 04:56

Businesses and their activity codes in the user-609 block (within the block and within 100 feet of the block)

	select
	b.account_number,
	b.business_activity,
	b.doing_business_as_name as name,
	b.address,
	st_x(b.geom) as longitude,
	st_y(b.geom) as latitude
	from business_licenses b,
	users_boundaries u

stevevance / churches in Austin.csv

Last active December 13, 2016 19:50

Churches in the Austin community area of Chicago from OpenStreetMap

We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 19 columns, instead of 1 in line 9.

	osm_id,elevation,name,amenity,website,building,religion,old_name,addr:city,architect,addr:state,addr:street,denomination,addr:postcode,building:levels,addr:housenumber,addr:street:name,addr:street:type,addr:street:prefix
	node/354258672,187,Faith Restoration Miracle Church,place_of_worship,,,christian,,,,,,,,,,,,
	node/354259256,189,Fifteenth Church of Christ Scientist,place_of_worship,,,christian,,,,,,,,,,,,
	node/354270054,185,Way of Holiness Church of God in Christ,place_of_worship,,,christian,,,,,,,,,,,,
	node/354199559,189,Jordan River Missionary Baptist Church,place_of_worship,,,christian,,,,,,baptist,,,,,,
	node/354199635,188,Kingdom Missionary Baptist Church,place_of_worship,,,christian,,,,,,baptist,,,,,,
	node/354199815,188,Little Rock Missionary Baptist Church,place_of_worship,,,christian,,,,,,baptist,,,,,,
	node/354270756,184,West End Baptist Church,place_of_worship,,,christian,,,,,,baptist,,,,,,
	node/354201023,188,Bethel Green Missionary Baptist Church,place_of_worship,,,christian,,,,,,baptist,,,,,,
	node

stevevance / convert_smooth_parking.js

Last active December 11, 2016 00:08

Converts data from Smooth Parking grid map into GeoJSON (requires jQuery): https://smoothparking.com/?lat=40.741014&lng=-73.937044&zoom=15

	function convertSmoothParkingToGeoJSON() {
	url = "/json/data.json";
	$.getJSON(url, function(data) {

	geojson = {
	"type": "FeatureCollection",
	"features": []
	}
	items = [];

stevevance / large_lots_community_areas.tsv

Created January 19, 2017 02:23

List of 34 community areas with Large Lots in fall 2016 launch

	community	count
	AUBURN GRESHAM	37
	AUSTIN	101
	AVALON PARK	6
	BURNSIDE	13
	CALUMET HEIGHTS	5
	CHATHAM	47
	CHICAGO LAWN	12
	DOUGLAS	11
	EAST GARFIELD PARK	116

stevevance / schools_for_sale.md

Last active January 26, 2017 07:04

29 former Chicago Public School buildings for sale, bids due March 31, 2017

No.	PROPERTY	ADDRESS	PIN NOS.

Steven Vance stevevance