toolness

"""
    This script can be used to create a sqlite database
    that contains metadata about all your Gmail messages.

    You will want to modify IMAP_PASSWORD and IMAP_USERNAME below.

    See CREATE_TABLE_SQL for the schema of the database.
"""

import sys

toolness

# This Python script downloads the map sources for the
# original id Quake levels and does a few things to make
# them easier to load in TrenchBroom:
#
# * It adds comments to the top of each map to let
#   TrenchBroom know that the map is a Quake map, and
#   that it uses the Standard map format. (Without
#   these comments, TrenchBroom will ask the user, and
#   choosing the default response will raise a very
#   confusing error.)

toolness

# The Ken Burns Jazz album MP3s from Amazon have separate track and disc
# number metadata, but many MP3 players don't look at the disc number,
# which makes it hard to play the album's tracks in order.
#
# This script goes through all the MP3's of the album and removes the
# disc number and rewrites the track number to be based on all the
# tracks in the album, rather than all the tracks on a particular disc.
#
# This script could theoretically be used on any other multi-disc MP3
# album, but I've only tried it on the Ken Burns Jazz MP3 album in

toolness

CREATE FUNCTION pg_temp.address(hpd_contacts) RETURNS TEXT AS 
$$
    SELECT
        CASE WHEN $1.businessstreetname IS NULL THEN
            ''::text
        ELSE
            COALESCE($1.businesshousenumber, '') || ' ' ||
            $1.businessstreetname ||
            CASE WHEN $1.businessapartment IS NULL THEN
                ''

toolness

//@ts-check

// This file can be dropped into the root of a project created
// via CRA w/ typescript support, e.g.:
//
//   yarn create react-app cra-babel-fun --typescript
//
// It's just a proof-of-concept that shows how we can load
// the app's babel config and add a Babel plugin that executes
// before everything else.

toolness

from pathlib import Path
from urllib.request import urlopen
from zipfile import ZipFile
from io import BytesIO
import os
import sys

assert 'win' in sys.platform, "We must be running on Windows."

MY_DIR = Path(__file__).parent.resolve()

toolness

'''
    This script makes it easy to create scaffolding for a new
    NYC-DB dataset based on an input CSV file. Just copy it
    into the `/src` directory of your NYC-DB repository,
    open a terminal and run e.g.:

        python create_dataset.py my_data.csv

    This will create all the data files and Python code needed
    for a new dataset called 'my_data' (or whatever you named

toolness

[package]
name = "wasm_hello"
version = "0.1.0"
authors = ["Atul Varma <varmaa@gmail.com>"]
edition = "2018"

[lib]
crate-type = ["cdylib"]

[dependencies]

toolness

I started with this Dockerfile:

FROM python:2.7

RUN pip install bzr

# Um, the following line might not actually do anything useful,
# possibly because we just installed bzr via pip instead of apt-get.
RUN apt-get update && apt-get --assume-yes install bzr-fastimport

toolness

NYC-DB schema

This documentation was automatically generated by a Python script.

Note that unless otherwise specified, all columns are nullable.

• The dob_violations dataset
  • The dob_violations table
• The pluto_18v1 dataset
  • The pluto_18v1 table
• The pluto_17v1 dataset