Skip to content

Instantly share code, notes, and snippets.

Avatar
🏠
Working from home

Steven Vance stevevance

🏠
Working from home
View GitHub Profile
@stevevance
stevevance / array_trim.sql
Created May 17, 2020
Trim the elements of an array in PostgreSQL
View array_trim.sql
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
Property classes in Cook County
View property_classes.json
[
{
"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 Feb 18, 2019
Chicago forestry districts as of 2/18/19
View forestry_districts_021819.geojson
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 Feb 18, 2019
CDOT asphalt districts as of 2/18/19
View cdot_asphalt_districts_021819.geojson
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 Jan 29, 2019
Map of colleges and universities in Opportunity Zones
View m_colleges_in_opportunity_zones_012319.geojson
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 Jan 24, 2019
Planned Developments and New Construction Permits in Wicker Park
View m_new_construction_since_2015_no_tents_mina_bloom_wicker_park.csv
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 Jan 24, 2019
Planned Development and New Construction Permits in Bucktown
View bucktown.geojson
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 Jan 24, 2019
Planned Developments and New Construction permits in Logan Square
View custom-logan-square-mb-boundary.geojson
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 Jan 21, 2019
Map of new construction and Planned Developments in seven wards: 1, 2, 26, 27, 31, 32, 35
View m_planned_developments_mina_bloom.csv
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
@stevevance
stevevance / m_coach_houses_chicago_123018.geojson
Created Dec 30, 2018
Suspected coach houses in Chicago as of December 30, 2018
View m_coach_houses_chicago_123018.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
You can’t perform that action at this time.