Skip to content

Instantly share code, notes, and snippets.


Mark Headd mheadd

View GitHub Profile
mheadd / Dockerfile
Created Mar 9, 2021
Dockerfile to run Drupal 7
View Dockerfile
FROM php:5.5-apache
RUN a2enmod rewrite
# install the PHP extensions we need
RUN apt-get update && apt-get install -y libpng12-dev libjpeg-dev libpq-dev \
&& rm -rf /var/lib/apt/lists/* \
&& docker-php-ext-configure gd --with-png-dir=/usr --with-jpeg-dir=/usr \
&& docker-php-ext-install zip \
&& docker-php-ext-install gd mbstring pdo pdo_mysql pdo_pgsql
mheadd /
Last active May 3, 2020
Get usage stats for a application
# A simple script to get a GUID for an applications. Note - assumes you have jq installed.
# The GUID for the app you want to check
if [[ ! $(which jq) ]]; then
echo "Error: You must have the jq utility installed to run this script." >&2
mheadd /
Last active Apr 9, 2021
Accessing PostGIS on a PostgreSQL database

Using an SSH tunnel to remotely administer a RDS let's you interact with your apps and bound services via SSH.

The cf-service-connect plugin lets you connect to your bound services, and is often your beset choice for interacting with services in But what if cf-service-connect doesn't work for you (e.g., if you are using a newer version of the cf CLI?

SSH tunneling to the rescue!


mheadd / 1-Dockerfile
Last active Feb 11, 2020
A set of files that can be used to set up a MS SQL Server instance and populate a table with test data
View 1-Dockerfile
# Install base image
FROM microsoft/mssql-server-linux
# Copy over the SQL file to set up the database
COPY setup.sql /
# Copy over the file with sample data.
# This data is from
COPY data.csv /
mheadd /
Last active Nov 27, 2019
Fetch closed issues from a Github repo
## The name of the Github account user or org
## The name of the repo
## Append the file with listd of issues
curl -s "$OWNER/$REPO/issues?page=1&per_page=100&state=closed" \

Keybase proof

I hereby claim:

  • I am mheadd on github.
  • I am mheadd ( on keybase.
  • I have a public key ASDf5v_IBXcBfsgDRP1fwqY16evvJMtC_SLI6H_bMN1VpAo

To claim this, I am signing this object:

mheadd /
Last active Jul 21, 2017
A simple script to pull down businesses by license type and display in a searchable HTML table.
# License number (e.g., 3381).
# The name of the file to populate with records.
echo "pri_contact_last_name, pri_contact_first_name, pri_contact_company_name, pri_contact_address1, pri_contact_city, pri_contact_state, pri_contact_zip, license_number, license_type_name, license_type_code" > $FILE_NAME
mheadd /
Last active Aug 23, 2016
Steps to import Philly311 data into an SQLite DB to enable SQL queries

Here are some steps to bring the bulk Philly311 CSV file into a local SQLite database to enable SQL queries.

Tools you'll use

  • sqlite3 (installed by default on OS X - try typing in ~$ which sqlite3 at a command prompt).
  • csvsql (follow installation instructions here if not already installed).
  • SQLite Manager for Firefox.


mheadd / philly-311-stats.csv
Last active Aug 23, 2016
Counts for service name and service code from Philly 311 data
View philly-311-stats.csv
Service Code Service Name # of Requests
SR-IR01 Information Request 674869
SR-LI21 Maintenance Residential or Commercial 40001
SR-ST03 Rubbish/Recyclable Material Collection 31159
Directory Assistance 25545
SR-ST02 Illegal Dumping 24401
SR-PD01 Abandoned Vehicle 22109
SR-ST01 Street Defect 22005
SR-CL01 Graffiti Removal 17160
SR-ST18 Salting 14282