Dana Bauer danabauer

RedSnake is a meeting where Rubyists and Pythonistas get together to throw down some hard tech and inspire each other to level up. Ultimately we aim to accomplish the following:

To be the premier technical event for hardcore programmers in Philadelphia
To inspire and provide an environment of learning to those who are new to programming
To introduce Philadelphia’s top companies to Philadelphia’s top programmers
To raise national recognition for Philadelphia’s tech community and attract top talent to the city

The format is 2 hours of alternating 10 minute lightning talks. It’s intense, technical, and mind blowing.

##Grant proposal to annual cover meetup.com fees for PhillyPUG

Grant Proposal: $144 (Tom, is this correct?) to cover the cost of the Philadelphia Python user group’s (PhillyPUG) meetup.com subscription for on year: May 2014 through May 2015.

Grant Objective: Fund the use of meetup.com for organizing and managing the PhillyPUG for a 12 month period. meetup.com helps to increase the visibility of the user group, as well as boost attendance through automated reminders, RSVP functionality, and other tools. It also makes organizing and promoting the group easier, as well as providing a platform to garner sponsorships and thank sponsors publicly.

Grant Size: $144 (check this) total, which is the cost of 12 months to organize a group on meetup.com.

Grant Beneficiaries: PhillyPUG has over 1,000 members on meetup.com. We have had monthly meetings since 2009 and have an average attendance of 40-60 Python programmers. meetup.com

30 days (October 27 - November 28)

Ramping down sponsorship tasks

Make an announcement to the team that I'll be transitioning to other projects
Extract (from database) a list of our 2014 sponsorships
Create visualizations of our 2014 sponsorship activity
Prepare report and/or presentation for Jesse to present to SLT
Write a blog post about the sponsorship programs
Create a team-based model (with wiki pages as guides) for sponsoring events and handling OSS sponsorship requests
Work with Everett on Django app for sponsorship data management

	"""
	!/usr/bin/env python
	csv2pgsql.py
	by Erik Osheim and Dana Bauer
	June 2011

	"""

	import csv
	import os

	"""
	pyodbc_sqlserver.py
	November 30, 2011
	Dana Bauer
	script converts time data from Cicero_Stage from Month Date, Year to Date Month Year (international form)
	"""

	import pyodbc
	import time
	import sys

	# This is counting distinct facilities with a capacity less than 10, grouped by star level

	SELECT star_level, count(DISTINCT facility_name) FROM ocdelphl
	where capacity < 10
	group by star_level

	#!/bin/bash
	#
	# Install Postgres 9.1, PostGIS and create PostGIS template on a clean Ubuntu 11.10 Oneiric Ocelot box
	# http://wildfish.com

	# add the ubuntu gis ppa
	sudo apt-get -y install python-software-properties
	sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable
	sudo apt-get update

	# Use the 'user' credentials
	source ~/credentials/user

	# List the type of volumes available to your tenant
	cinder type-list

	# Create a new volume with the type SATA specified
	cinder create 1 --display-name MyFirstVolume --volume-type SATA

	# Boot an instance to attach volume to

	env vars for the nova CLI:
	export OS_AUTH_URL=https://identity.api.rackspacecloud.com/v2.0/
	export OS_REGION_NAME=IAD
	export OS_TENANT_NAME=$RACKSPACE_TENANT
	export OS_TENANT_ID=$RACKSPACE_TENANT
	export OS_USERNAME=$RACKSPACE_USERNAME
	export OS_PASSWORD=$RACKSPACE_PASSWORD*

	*RACKSPACE_PASSWORD is your password, not API KEY.

	find US zip codes
	value.match(/.(\d{5})./)[0]