Skip to content
Branch: master
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
costofliving
crimeData
publicSalariesBayArea
ridership
traffic data
FY2013_BART_Budget.pdf
README.md
actransit-compensation_all.csv
bart-comp-all.csv
bart-raises-prices.csv
bart_station_key.csv
bart_stations.csv
bart_stations.json
bayarea-zips.geo.json
bayareaTOPO-simple.json
bayareaTOPO.json
case-shiller-large.csv
case-shiller-small.csv
comp-data-cleaning-notes.txt
countypopulations.csv
financials-simple.csv
financials-simple.xlsb
financials.xlsb
job_families.csv
job_families_all_scrubbed.csv
monthlyinflation.csv
stationcodes.csv
top10cities.csv

README.md

Data files

Salary data notes:

BART Salaries were scraped from http://www.mercurynews.com/salaries/bay-area and are composed of several sections:

Name: employee's name
Title: Job Title
Family: Job family (as categorized by BART's website)
Base: base salary for calendar year
OT: over time pay
Other: Lump sump payouts for vacation, sick leave and comp time, bonuses and other taxable cash payments
MDV: Employer contributions to medical, dental and vision plans
ER: Employer contribution to pension
EE: Employee contribution to pension paid by the employer
DC: Employer contribution to deferred compensation (eg. 401(k) or 403(b) plans)
Misc: Other non-cash costs of employment
TCOE: Total cost of ownership
Source: MNP is "Management, No Police" and NM is "non-management"
Job Family: Higher level categorization of job titles (see notes)
Union: Union representation for each employee

BART Data

Highway Data

AC Transit

MUNI Data

Surrounding Data

CA MTC http://dataportal.mtc.ca.gov/spatial-library.aspx
GIS data (maps, census) http://www.mtc.ca.gov/maps_and_data/GIS/data.htm (shp files converted to geojson and topojson)
Bay Area TOPOJSON: https://github.com/enjalot/bart/blob/master/data/bayareaTOPO.json US Atlas https://github.com/mbostock/us-atlas
Bay Area census http://www.bayareacensus.ca.gov/historical/historical.htm (countypopulations.csv top10cities.csv)
U.S. monthly inflation http://www.usinflationcalculator.com/inflation/historical-inflation-rates/ (stored in monthlyinflation.csv)
Family Budget data: https://groups.google.com/forum/#!topic/bart-hackers/5rZCtiwQaVI BLS U.S. Historical Wage Data, 2001 - 2013 (Current Dollar) ftp://ftp.bls.gov/pub/suppl/eci.echistrynaics.txt
FRED (economic data) http://research.stlouisfed.org/fred2/
Cost of Living:

Municiple tax shelters http://groups.yahoo.com/group/BATN/message/42479
Median income at BART stations http://dangrover.github.io/sf-transit-inequality https://github.com/dangrover/sf-transit-inequality

I'd be interested in looking at the property values surrounding BART stations with the Trulia API http://developer.trulia.com/

California State Data Center http://www.dof.ca.gov/research/demographic/state_census_data_center/census_2010/view.php

Longitudinal Employer-Household Dynamics (LEHD) public-use data products
http://lehd.did.census.gov/

Beyond the Shutdown: U.S. Government Data on ArcGIS Online
http://blogs.esri.com/esri/arcgis/2013/10/04/beyond-shutdown-us-government-data-on-arcgis-online/

CensusReporter http://censusreporter.tumblr.com/

Detailed State Files for California (2013)
block groups: http://openstreetmap.us/~migurski/TIGER-Areas/tl_2013_06_bg.zip
places: http://openstreetmap.us/~migurski/TIGER-Areas/tl_2013_06_place.zip
blocks: http://openstreetmap.us/~migurski/TIGER-Areas/tl_2013_06_tabblock.zip
tracts: http://openstreetmap.us/~migurski/TIGER-Areas/tl_2013_06_tract.zip

Census Transportation Planning Package (CTPP2000)
http://www.mtc.ca.gov/maps_and_data/datamart/census/ctpp2000/

US CTPP using ACS 2006-2010 (5-Year Summary)
http://www.fhwa.dot.gov/planning/census_issues/ctpp/data_products/acsdataprod.cfm

Additional Data for San Francisco data.sfgov.org

BART Districts in San Francisco (Zipped Shapefile Format) https://data.sfgov.org/download/mnn6-ac5f/ZIP

Stop locations for all of public transit routes that serve San Francisco. Records indicate stop location and name, the associated
https://data.sfgov.org/download/s593-yv8k/SHAPEFILE

Incidents derived from SFPD Crime Incident Reporting system. Previous month. Updated daily
https://data.sfgov.org/Public-Safety/SFPD-Incidents-Previous-Three-Months/tmnf-yvry

Industry Classification via BLS:
Transportation and Warehousing: NAICS 48-49
The transit and ground passenger transportation subsector (NAICS 485) consists of these industry groups:

  • Urban Transit Systems: NAICS 4851
  • Interurban and Rural Bus Transportation: NAICS 4852
  • Taxi and Limousine Service: NAICS 4853
  • School and Employee Bus Transportation: NAICS 4854
  • Charter Bus Industry: NAICS 4855
  • Other Transit and Ground Passenger Transportation: NAICS 4859
You can’t perform that action at this time.