chicago-stops.py

import csv
import simplegeo

OAUTH_TOKEN = ''
OAUTH_SECRET = ''
CSV_FILE = 'stops.txt'
LAYER = 'co.mager.transit.chicago'

client = simplegeo.Client(OAUTH_TOKEN, OAUTH_SECRET)

def insert(data):
    layer = LAYER
    id=data.pop("stop_id")
    lat=data.pop("stop_lat")
    lon=data.pop("stop_lon")
    name=data.pop("stop_name")
    # Grab more columns if you wish
    record = simplegeo.Record(layer,id,lat,lon,**data)
    print record
    client.add_record(record)

r = csv.DictReader(open(CSV_FILE, mode='U'))
for l in r:
    insert(l)