Skip to content

Instantly share code, notes, and snippets.

View stevevance's full-sized avatar
🏠
Working from home

Steven Vance stevevance

🏠
Working from home
View GitHub Profile
@stevevance
stevevance / red_line_extension.geojson
Created March 5, 2021 03:05
Bike route for Old Fashioned Donuts and Red Line Extension
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@stevevance
stevevance / array_trim.sql
Last active March 8, 2025 23:43
Trim the string elements of an array in PostgreSQL (wrap this function around an array or another function that returns an array, like string_to_array).
CREATE OR REPLACE FUNCTION array_trim(text[])
RETURNS text[]
AS
$$
DECLARE
text ALIAS FOR $1;
retVal text[];
BEGIN
FOR I IN array_lower(text, 1)..array_upper(text, 1) LOOP
retVal[I] := trim(text[I]);
@stevevance
stevevance / property_classes.json
Created May 12, 2020 22:35
Property classes in Cook County
[
{
"id": "2-11,2-12,2-13,2-25,2-99,3-13,3-14,3-15,3-18,3-91,3-96,4-18,9-00,9-13,9-14,9-15,9-18,9-91,9-96,9-97",
"text": "Multi-family buildings: apartments & condos (residential)"
},
{
"id": "2-11,2-12,2-13,2-25,3-13,3-14,3-15,3-18,3-91,3-96,4-18,9-00,9-13,9-14,9-15,9-18,9-91,9-96,9-97",
"text": "Multi-family buildings: apartments, no condos (residential)"
},
{
@stevevance
stevevance / forestry_districts_021819.geojson
Created February 18, 2019 19:28
Chicago forestry districts as of 2/18/19
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@stevevance
stevevance / cdot_asphalt_districts_021819.geojson
Created February 18, 2019 19:26
CDOT asphalt districts as of 2/18/19
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@stevevance
stevevance / m_colleges_in_opportunity_zones_012319.geojson
Created January 29, 2019 17:11
Map of colleges and universities in Opportunity Zones
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@stevevance
stevevance / m_new_construction_since_2015_no_tents_mina_bloom_wicker_park.csv
Created January 24, 2019 02:30
Planned Developments and New Construction Permits in Wicker Park
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 5.
work_description,address,issue_date,_estimated_cost,alder
"FULL BUILDING PERMIT FOR NEW CONSTRUCTION OF 2-STORY WITH BASEMENT SINGLE FAMILY HOME, 599 S.F. 2-CAR DETACHED PRIVATE GARAGE, AND 5 FT HIGH ORNAMENTAL FENCE AT FRONT YARD AND 6 FT HIGH WOOD FENCE AT SIDE/REAR YARD. CURRENT USE: VACANT LOT/PROPOSED USE: SINGLE FAMILY RESIDENTIAL",2118 W Evergreen Ave,2016-05-02,700000,"2nd Ward, Alder Brian Hopkins"
ERECT NEW THREE STORY THREE UNITS MASONRY BUILDING WITH FULL BASEMENT. NEW THREE STORY STEEL REAR PORCH. NEW REAR 3RD FLR ROOF TOP DECK AND ACCESS ROOF PENTHOUSE AS PER PLANS. **CERTIFIED PLANS CORRECTIONS: CONDITIONAL PERMIT SUBJECT TO FIELD INSPECTIONS **,1349 N Leavitt St,2015-07-14,300000,"2nd Ward, Alder Brian Hopkins"
"SELF CERTIFICATION REVIEW: ERECT FRAME SINGLE FAMILY RESIDENCE (4A CONSTRUCTION) WITH ROOF TOP DECK, ATTACHED 2 CAR MASONRY GARAGE (3B CONSTRUCTION) WITH ROOF TOP DECK AS PER PLAN.",1624 W Pierce Ave,2016-11-29,333600,"2nd Ward, Alder Brian Hopkins"
"ERECT NEW 3 STORY, III-B, 2DU APAR
@stevevance
stevevance / bucktown.geojson
Created January 24, 2019 02:25
Planned Development and New Construction Permits in Bucktown
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@stevevance
stevevance / custom-logan-square-mb-boundary.geojson
Last active January 24, 2019 02:11
Planned Developments and New Construction permits in Logan Square
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@stevevance
stevevance / m_planned_developments_mina_bloom.csv
Last active January 21, 2019 22:00
Map of new construction and Planned Developments in seven wards: 1, 2, 26, 27, 31, 32, 35
zone_class alder pd_name
PD 1031 2nd Ward, Alder Brian Hopkins
PD 389 2nd Ward, Alder Brian Hopkins
PD 888 2nd Ward, Alder Brian Hopkins
PD 1291 2nd Ward, Alder Brian Hopkins
PD 1303 2nd Ward, Alder Brian Hopkins
PD 1398 2nd Ward, Alder Brian Hopkins
PD 227 2nd Ward, Alder Brian Hopkins
PD 1375 2nd Ward, Alder Brian Hopkins
PD 354 2nd Ward, Alder Brian Hopkins