2012 Code for Oakland Hackathon DATA Resources.
This year things are much simpler- and much better for you data junkies out there. We have just two primary places for all the data we know of:
The new Socrata based Alameda County Data Sharing platform: http://data.acgov.org
&
OpenOakland’s new data catalog built on CKAN: http://data.openoakland.org
Both are heavily in beta but both have a huge trove of powerful (and new) data to work with!
2011 Data Resources
Get your hands on data provided by the City of Oakland, Stamen Design, Urban Strategies Council, Alameda County, and more.
Please send links for additional data sets to [email protected]
Index:
- Official City of Oakland Data Downloads
- Oakland/Alameda County Data, Part 1: Streets, OpenStreetMap, crime reports, parcels, EBMUD meters, streams, elevations, Census 2010, Census 2000, historic imagery, APIs
- Oakland/Alameda County Data, Part 2: Administrative boundaries, other data
- Alameda County Data: Census, health, environment, education, local programs, government, parcels,
- Transportation: BART, Bay Area transit data, Google transit
- CA Dept. of Health: WIC food lists, water quality, AIDSinfo drugs, HIV testing
- UC Berkeley Geospatial Innovation Facility: Massive data grab bag
- More Oakland Political Data - Foreclosures, voting and political contributions.
Download Official Data from the City of Oakland Website
Data gathered by Nicole Neditch.
File Name | Description | Size | Format |
Assessor Parcel Data | AssessorData | 40,289 KB | MS Excel CSV |
CDBG Districts | CDBG Districts | 21 KB | Zipped File |
CIP Locations | Capital Improvements Locations | 37 KB | MS Excel CSV |
CIP Locations (not Single Address) | Capital Improvements Locations (not Single Address) | 42 KB | MS Excel CSV |
Council Districts | Council Districts | 119 KB | Zipped File |
CPRB Complaints | Citizens Complaints | 37 KB | MS Excel CSV |
CPRB Sustained Allegations | Sustained Allegations | 3 KB | MS Excel CSV |
Crime Watch Tabular Data | Sustained Allegations | 1,757,696 KB | MS Excel |
Drainage Inlets | PWA Drainage Inlets | 290 KB | MS Excel CSV |
Even Start | Even Start | 1 KB | MS Excel CSV |
Fleet Vehicles | PWA Fleet Vehicles | 289 KB | MS Excel |
Food Distribution Sites | Food Distribution Sites | 2 KB | MS Excel CSV |
Head Start Locations | Head Start | 1 KB | MS Excel CSV |
Library Branches | Library Branches | 2 KB | MS Excel CSV |
Oakland Parks | Parks | 7 KB | MS Excel CSV |
Oakland Opportunity Sites | C9 Oakland Opportunity Sites | 99 KB | Zipped File |
Pools | City Swimming Pools | 1 KB | MS Excel CSV |
Post Offices | Oakland Post Offices | 1 KB | MS Excel CSV |
RecyclingHotline | PWA Recycling Hotline | 303KB | MS Excel |
Sage Programs | Senior Programs | 238KB | MS Excel CSV |
Schools | Oakland Unified Schools | 12 KB | MS Excel CSV |
Service Request | PWA Service Request 2010 | 4,101 KB | MS Excel |
Senior Centers | Senior Centers | 1 KB | MS Excel CSV |
Stars Programs | Youth Programs | 363KB | MS Excel CSV |
Street lights | Street Lights | 851KB | MS Excel CSV |
Street Litter Containers | Street Litter Containers | 26KB | MS Excel CSV |
Traffic Signals | Traffic Signals | 13KB | MS Excel CSV |
Trees | Trees | 2,375KB | MS Excel CSV |
Oakland Data Sets, Part 1
Data gathered by Michal Migurski in preparation for Code For Oakland, June 4 2011 in Oakland, California.
Streets: all street centerlines.
- Shapefile (2.0M zipped, geographic)
- Shapefile (2.0M zipped, state plane III)
- GeoJSON (1.5M zipped)
- Text (778K zipped, no geography)
OpenStreetMap: all points, lines, and polygons for Alameda County.
- Shapefiles (11M zipped, geographic)
- Shapefiles (11M zipped, state plane III)
- GeoJSON (6.8M zipped)
Crime Reports: all crime reports from January 2010 through May 22 2011, via Oakland Crimespotting.
- Text (1.9M zipped)
Parcels: tax parcel footprints.
- Shapefile (24M zipped, geographic)
- Shapefile (25M zipped, state plane III)
- GeoJSON (14M zipped)
- Text (4.6M zipped, no geography)
EBMUD Meters: utility meter locations with addresses.
- Shapefile (6.8M zipped, geographic)
- Shapefile (6.8M zipped, state plane III)
- GeoJSON (6.7M zipped)
- Text (4.3M zipped, no geography)
Streams: centerlines of streams.
Elevations: Raster digital elevation models for Alameda County.
Census 2010:
Tracts:
Blocks:
Census 2000::
Tracts:
- Shapefile (56K zipped, geographic)
- Shapefile (64K zipped, state plane III)
- GeoJSON (37K zipped)
- Text (16K zipped, with population and housing counts)
Blocks:
- Text (395K zipped, with population and housing counts)
Historic Imagery:
- 1877 Map of Oakland and Alameda via Calisphere (72M zipped)
- 1912 Map of Oakland and vicinity via Calisphere (178M zipped)
Oakland Data Sets, Part 2
Data gathered by Steve Spiker and John Garvey, Urban Strategies Council) as part of Info Alameda Data Portal
Oakland Crime Reports API
Service Provider API (Reentry Focus)
Administrative Boundary Data Portal
- Oakland Redevelopment Areas
- Oakland Community Police Beats
- Oakland City Council Districts
- Urban Communities Collaborative
- TCE Building Healthy Communities Boundary
- Making Connections Inititative Boundary
- Promise Neighborhoods Boundary
Other Oakland Data Sets
- Age Groups in Oakland Over the Past Three Decades
- Oakland Crime Maps for the 4th Quarter of 2010 by Police Beat
- Oakland Crime Hot Spot Maps for the 4th Quarter of 2010
- Oakland Crime Summary for 2010
Additional Oakland data, gathered by Susan Mernit, Oakland Local.
Alameda County Data
Data gathered by Steve Spiker and John Garvey, Urban Strategies Council
Census Alameda County:
Health:
- Alameda County Pubic Health Department CCNI
- Alameda County Hospitals
- Alameda County Psychiatric Health Clinics
- Alameda County Health Clinics
Environment: Alameda County Toxic Hazard Sites
Education:
Local programs:
Government
Parcels: Alameda County GIS data, mostly parcels and housing (MM)
Transportation
BART API (SM)
Metropolitan Transportation Commission: Bay Area transit data, including transit routes and stops. (MM)
Google wiki: Transit data feed
Bike accident data, Bay Area counties: From the California Highway Patrol. Five years (Jan 2005-Dec 2009). Supplied by the Bay Citizen, which published this Bike Accident Tracker web app collection — and would love some help to make it (or some parts of it) mobile-friendly.
California Dept. of Public Health
UC Berkeley: Geospatial Innovation Facility
Data sets include:
- CDF-FRAP:California Census data
- NOAA-CCAP:2000 land cover data, coastal California counties. Resolution: 30 meters
- DataSF:San Fransisco data sets
- Association of Bay Area Governments
- Bay Area Automated Mapping Association (BAAMA)
- Bay Area Regional Database (BARD)
- City of Berkeley GIS
- San Francisco Estuary Institute (SFEI)
- Metropolitan Transportation Commission:Bay Area roads and transit
- San Francisco Ports:Wind data
- Bay Delta and Tributaries Database:Water quality data with GPS locationsUS Points of interest and business
More Oakland Political Data
Gathered by Skye Bender-deMoll
- Business listings (can filter for Oakland)http://www.factual.com/t/s4OOB4/US_POI_and_Business_Listings
- Scraped SEC filing data (and possible subsidiaries) of U.S. Publicly
traded companies with addresses in Oakland:
http://api.corpwatch.org/companies.json?raw_address=oakland&subdiv_code=CA - SF Chronicle feed of Oakland foreclosures:
http://www.sfgate.com/webdb/foreclosures/oakland/ - Some California state level political contributions related to Oakland:
http://www.followthemoney.org/database/search.phtml?searchbox=Oakland& - Candidate profiles and election results from last city election (mayors
race shown)
http://www.smartvoter.org/2010/11/02/ca/alm/race/020/