Skip to content

Instantly share code, notes, and snippets.

@erichurst
erichurst / US Zip Codes from 2013 Government Data
Created December 9, 2013 23:00
All US zip codes with their corresponding latitude and longitude coordinates. Comma delimited for your database goodness. Source: http://www.census.gov/geo/maps-data/data/gazetteer.html
This file has been truncated, but you can view the full file.
ZIP,LAT,LNG
00601,18.180555, -66.749961
00602,18.361945, -67.175597
00603,18.455183, -67.119887
00606,18.158345, -66.932911
00610,18.295366, -67.125135
00612,18.402253, -66.711397
00616,18.420412, -66.671979
00617,18.445147, -66.559696
@jgn
jgn / rozenshtein.sql
Created January 15, 2013 23:51
Sample schema from Rozenshtein, The Essence of SQL (and see The SQL Cookbook)
drop table if exists student;
create table student (
sno integer,
sname varchar(10),
age integer
);
drop table if exists courses;
create table courses (
cno varchar(5),