Skip to content

Instantly share code, notes, and snippets.

Wayne Burkett wayneburkett

  • New York City
Block or report user

Report or block wayneburkett

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View nyctrees
# get a pared-down database of the trees in NYC
# the downloaded CSV is ~210M
# the generated DB is ~22M
mkdir trees && \
curl -L https://data.cityofnewyork.us/api/views/uvpi-gqnh/rows.csv?accessType=DOWNLOAD -o trees/trees.csv && \
ogr2ogr -f SQLite trees.db trees/trees.csv -nln trees -dialect sqlite \
-sql "SELECT tree_id AS id, \
ROUND(latitude, 6) lat, \
ROUND(longitude, 6) lon \
FROM trees"
View git.alias.about.sh
alias.about !describe() { msg="$1"; git config branch."$(git rev-parse --abbrev-ref HEAD)".description ${msg:+"$msg"}; }; describe
@wayneburkett
wayneburkett / generate.bash
Last active Mar 27, 2019
St. Louis properties owned by Paul McKee's Northside Regeneration LLC
View generate.bash
# see this gist for instructions to generate the database of parcels this was created from
# https://gist.github.com/wayneburkett/9fc130e1e2f1f6105a6fa2c0e74c2e3c
ogr2ogr -f GeoJSON northside.geojson prcl.shp -t_srs EPSG:4326 -select handle -where "ownername LIKE 'NORTHSIDE REGEN%'"
View 5thward.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View absentee.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View vacants.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@wayneburkett
wayneburkett / stlparcels
Last active Jan 1, 2019
Get a SQLite database of St. Louis parcel data
View stlparcels
# download the shapefiles and parcel data, merge it all together, and dump it into a database
mkdir tmp && \
curl -L https://www.stlouis-mo.gov/data/upload/data-files/prcl_shape.zip -o tmp/prcl.zip && \
cd tmp && \
unzip prcl.zip && \
curl -LO https://www.stlouis-mo.gov/data/upload/data-files/par.zip && \
unzip par.zip && \
mv par.dbf prcl.dbf && \
ogr2ogr -f SQLite prcl_raw.db prcl.shp -t_srs EPSG:4326
@wayneburkett
wayneburkett / markasread.user.js
Last active Apr 20, 2018
Mark previously-read Hacker News comments
View markasread.user.js
// MarkAsRead
// v0.1
// Copyright (c) 2008, Wayne Burkett
// Released under the GPL license
// http://www.gnu.org/copyleft/gpl.html
// ==UserScript==
// @name MarkAsRead
// @namespace http://dionidium.com/projects/greasemonkey/
// @description Mark previously-read Hacker News comments
@wayneburkett
wayneburkett / xcode_sdk_link.sh
Created Jun 12, 2014
Link SDKs in one version of XCode to another (when more than one version of XCode is installed)
View xcode_sdk_link.sh
@wayneburkett
wayneburkett / hnsort.user.js
Last active Sep 26, 2015
Sort the Hacker News front page
View hnsort.user.js
// hnsort
// v0.3
// Copyright (c) 2009, Wayne Burkett
// Released under the GPL license
// http://www.gnu.org/copyleft/gpl.html
// ==UserScript==
// @name hnsort
// @namespace http://wayneburkett.com
// @description Sort articles on the Hacker News homepage
You can’t perform that action at this time.