Skip to content

Instantly share code, notes, and snippets.

View markchadwick's full-sized avatar

Mark Chadwick markchadwick

  • Vistar Media
  • Philadelphia
View GitHub Profile
@markchadwick
markchadwick / geo-header.sql
Created December 12, 2014 03:22
Populate a postgres table for 2010 sf1 geo headers based on a scratch table containing each row of geo file as a string
INSERT INTO "GEO_HEADER_SF1" ("FILEID", "STUSAB", "SUMLEV", "GEOCOMP", "CHARITER", "CIFSN", "LOGRECNO", "REGION", "DIVISION", "STATE", "COUNTY", "COUNTYCC", "COUNTYSC", "COUSUB", "COUSUBCC", "COUSUBSC", "PLACE", "PLACECC", "PLACESC", "TRACT", "BLKGRP", "BLOCK", "IUC", "CONCIT", "CONCITCC", "CONCITSC", "AIANHH", "AIANHHFP", "AIANHHCC", "AIHHTLI", "AITSCE", "AITS", "AITSCC", "TTRACT", "TBLKGRP", "ANRC", "ANRCCC", "CBSA", "CBSASC", "METDIV", "CSA", "NECTA", "NECTASC", "NECTADIV", "CNECTA", "CBSAPCI", "NECTAPCI", "UA", "UASC", "UATYPE", "UR", "CD", "SLDU", "SLDL", "VTD", "VTDI", "RESERVE2", "ZCTA5", "SUBMCD", "SUBMCDCC", "SDELEM", "SDSEC", "SDUNI", "AREALAND", "AREAWATR", "NAME", "FUNCSTAT", "GCUNI", "POP100", "HU100", "INTPTLAT", "INTPTLON", "LSADC", "PARTFLAG", "RESERVE3", "UGA", "STATENS", "COUNTYNS", "COUSUBNS", "PLACENS", "CONCITNS", "AIANHHNS", "AITSNS", "ANRCNS", "SUBMCDNS", "CD113", "CD114", "CD115", "SLDU2", "SLDU3", "SLDU4", "SLDL2", "SLDL3", "SLDL4", "AIANHHSC", "CSASC", "CNECTASC", "MEMI", "NMEMI", "P
#!/bin/bash
ex=0
while [ $ex -eq 0 ]; do
gom test ./net/ --v
ex=$?
sleep 0.1
done
probably_the_most_descriptive_name_in_the_word = 'data'
for segment in response.get(probably_the_most_descriptive_name_in_the_word, []):
Object.defineProperty process.env, 'TZ',
get: 'EST'
set: throw Error('Nice work, asshole')
import pycurl
import sys
import time
from cStringIO import StringIO
def fetch(requets, concurrent=5):
multi = pycurl.CurlMulti()
>>> from datetime import datetime
>>> import time
>>> d = datetime.utcfromtimestamp(1343793600)
>>> time.mktime(d.timetuple())
1343808000.0
>>> time.mktime(d.utctimetuple())
1343811600.0
>>>
package main
import (
"fmt"
)
func whatsMyName() (string, error) {
return "", nil
}
package main
import (
"fmt"
)
func main() {
c := make(chan int)
close(c)
// Unmarshal decodes the first document found within the in byte slice
// and assigns decoded values into the object pointed by out.
//
// Maps, pointers to structs and ints, etc, may all be used as out values.
// If an internal pointer within a struct is not initialized, goyaml
// will initialize it if necessary for unmarshalling the provided data,
// but the struct provided as out must not be a nil pointer.
//
// The type of the decoded values and the type of out will be considered,
// and Unmarshal() will do the best possible job to unmarshal values
import os
import errno
import json
from base64 import urlsafe_b64encode
from flask import Flask
from flask import Response
from flask import abort
from flask import request
from flask import session