Open Data, meet Oakland.
If you're an Oakland based coder, developer, designer, journo, researcher and you want to help build the first Oakland OpenData portal then please join us next weekend (Feb 25th @10am). We are partnering with the alpha event of the Code for America Brigade for the first Code Across America day and will spend the day laying out the plans for this new resource for Oaktown.
We want your ideas, feedback, critique, concepts and creative spirit to help us make this work for everyone in Oakland. In mid/late March we will host a hack day in Oakland to do the dev work and get the site up and running, but the planning phase is just as important. We want to brainstorm with you on how we deal with the City/County split, which system we adopt- either the OpenDataPhily or the CKAN system, how it's hosted and who will contribute to maintaining it, branding and promotion and more. We don't want to do this in isolation so here's your chance to help make this happen and to make sure your voice is heard.
We're not about to reinvent the wheel, so we'll be Skyping in with some of the crew from Chattanooga who recently stood up the Phily platform in their town, we'll learn from their process and then work from there. We already have a huge data warehouse of Oakland and Alameda data and we will be publishing it aggressively to whatever site we launch. The city and county are both interested in this happening but have yet to take the lead, so we're doing a Phily and just doing it ourselves. With your help! So register now!
Keep in touch: follow @openoakland and @infoalameda for news and data releases!
Hashtag: #cfa2012 for the day's events.
We would like to applaud and spread the word about Alameda County's increased offerings for geospatial data. For anyone who looked before, you remember the single layer of parcel outlines. The new offerings include layers from supervisor districts to sanitation districts. This is a small step towards open data and we look forward to seeing the county continue along this course.
The layers are static and can be downloaded as zipped shapefiles.
Go to the site and start downloading: http://acgov.org/gis.htm
The FBI have just released their latest Uniform Crime Reports data for City and County crime reports (FBI site), so we have updated our Violent Crimes in Alameda County fact sheet for 2010. This brief report presents an overview of violent crimes in various cities in the county from 2001-2010. This fact sheet is an important tool for stakeholders seeking to implement effective violence prevention programs in their neighborhoods.
Some of the main highlights from the factsheet include:
Violent Crime Rate per 100,000 People from 2001 to 2010 in Alameda County

In 2005, the Alameda County Board of Supervisors adopted a violence prevention plan, A Lifetime Commitment to Violence Prevention: The Alameda County Blueprint. The Blueprint serves as the county's guide for supporting and sustaining violence prevention efforts, thereby creating safer communities. As part of the plan, the county launched the Alameda County Violence Prevention Initiative, which funded violence prevention projects in several target neighborhoods that focused on the youth and reentry populations. Urban Strategies Council has produced this fact sheet, Violent Crimes in Alameda County, which presents an overview of violent crimes in various cities in the county from 2000-2009. This fact sheet is an important tool for stakeholders seeking to implement effective violence prevention programs in their neighborhoods.
Some of the main highlights from the factsheet include:
Violent Crime Rate per 100,000 People from 2000 to 2009 in Alameda County

We're being bombarded with questions about the changes in population in Bay Area cities today. To help answer some of those questions we're releasing some data tables of the city level population changes -- in particular, the changes in population amongst different ethnicities. These tables are available to download in Excel format or as a PDF.
The following table lays out the changes in population counts - the number of people gained or lost in each city by ethnicity. The county gained 57,227 persons in the 10 years between 2000 and 2010, with a loss of 23,982 Black/African-American persons and an increase of 93,200 Asians. The city of Oakland lost 32,989 Blacks and gained 9,912 Whites, while Fremont lost 26,648 Whites and gained 33,167 Asians. Hayward saw an increase of 10,880 Hispanics.

| Demographics | Total | Percent | Year | Sources | Error |
| Total Population | 1,510,271 | 2010 | Census 2010 | ||
| Total Population | 1,443,744 | 2000 | Census 2000 | ||
| Males | 740,573 | 49.0% | 2010 | Census 2010 | |
| Females | 769,698 | 51.0% | 2010 | Census 2010 | |
| Population under 5 | 97,652 | 6.5% | 2010 | Census 2010 | |
| Population 0-17 | 340,621 | 22.6% | 2010 | Census 2010 | |
| Population 18-64 | 1,001,904 | 66.3% | 2010 | Census 2010 | |
| Population 65+ | 167,746 | 11.1% | 2010 | Census 2010 | |
| Population Density/sq. mi. | 2,048 | 2010 | Census 2010 | ||
| Median Family Income | 83,567 | 2009 | ACS 2009 | +/- 4,047 | |
| Median Household Income | 68,405 | 2009 | ACS 2009 | +/- 2,444 | |
| Per Capita Income | 26,680 | 1999 | Census 2000 | +/- 1,243 | |
| Households w/ Social Security Income | 33,370 | 21% | 2009 | ACS 2009 | +/- 1.5% |
| Households w/ Supplemental Income | 9,138 | 6% | 2009 | ACS 2009 | +/- 1% |
| Families in Poverty | 7.3% | 2009 | ACS 2009 | +/- .8 | |
| People in Poverty | 10.7% | 2009 | ACS 2009 | +/- .8 | |
| Children in Poverty | 13.8% | 2009 | ACS 2009 | +/- 1.8 |
| Race & Ethnicity1 | Count | Percent | Year | Sources |
| African American Population | 184,126 | 12.2 | 2010 | Census 2010 |
| Hispanic Population | 339,889 | 22.5 | 2010 | Census 2010 |
| Asian Population | 390,524 | 25.9 | 2010 | Census 2010 |
| White Alone Population | 514,559 | 34.1 | 2010 | Census 2010 |
| American Indian/Alaskan Native | 4,189 | 0.3 | 2010 | Census 2010 |
| Mixed Race Population | 60,862 | 5.6% | 2010 | Census 2010 |
| Native Hawaiian and Other Pacific Islander alone | 11,931 | 0.8% | 2010 | Census 2010 |
| Some Other Race alone | 4,191 | 0.3% | 2010 | Census 2010 |
| People with Disabilities (Aged 5+) | 248,558 | 2000 | Census 2000 | |
| Foreign Born People | 27.2% | 2000 | Census 2000 | |
| Language other than English spoken at home (age 5+) | 36.8% | 2000 | Census 2000 |
| Crime | Count | Rate per 100,000 | Year | Sources |
| UCR Part 1 Crimes2 | 66,663 | 4,470 | 2009 | FBI UCR 2009/ACS 2009 |
| Violent crime | 11,193 | 750 | 2009 | FBI UCR 2009 |
| Murder & non-negligent manslaughter | 138 | 9 | 2009 | FBI UCR 2009 |
| Forcible rape | 565 | 38 | 2009 | FBI UCR 2009 |
| Robbery | 5,139 | 345 | 2009 | FBI UCR 2009 |
| Aggravated assault | 5,351 | 359 | 2009 | FBI UCR 2009 |
| Property crime | 55,026 | 3,689 | 2009 | FBI UCR 2009 |
| Burglary | 11,598 | 778 | 2009 | FBI UCR 2009 |
| Larceny-theft | 30,936 | 2,074 | 2009 | FBI UCR 2009 |
| Motor vehicle theft | 12,492 | 838 | 2009 | FBI UCR 2009 |
| Arson | 444 | 30 | 2009 | FBI UCR 2009 |
| Reentry | Count | Percent | Year | Sources |
| Adult Probationers | 12,369 | 2010 | ACPD | |
| Juvenile Probationers | 1,985 | Dec. 2010 | ACPD | |
| Parolees (State) | 4,935 | Jan. 2011 | CDCR | |
| Parolees (Federal) | 980 | Aug. 2009 | CDCR |
| Employment | Count | Percent | Year | Sources | Error |
| Unemployed | 85,537 | 2009 | ACS 2009 | +/- 5,491 | |
| Labor Force | 806,058 | 2009 | ACS 2009 | +/- 7,051 | |
| Persons in Government Jobs | 103,131 | 2009 | ACS 2009 | +/- 5,081 | |
| Service Jobs | 107,147 | 2009 | ACS 2009 | +/- 5,756 | |
| Transportation, Comms & Utility Jobs | 37,184 | 2009 | ACS 2009 | +/- 3,503 | |
| Finance, Insurance & Real Estate Jobs | 47,274 | 2009 | ACS 2009 | +/- 3,772 | |
| Manufacturing Jobs | 78,693 | 2009 | ACS 2009 | +/- 5,237 | |
| Retail Trade Jobs | 68,917 | 2009 | ACS 2009 | +/- 5,514 | |
| Construction Jobs | 46,186 | 2009 | ACS 2009 | +/- 3,836 | |
| Wholesale Jobs | 23,567 | 2009 | ACS 2009 | +/- 2,995 |
| Housing | Count | Percent | Year | Sources | Error |
| Households | 545,138 | 2005-09 | ACS 5-Year Estimate | +/- 1,580 | |
| Housing Units | 582,549 | 2005-09 | ACS 5-Year Estimate | +/- 1,728 | |
| Vacant Housing Units | 37,411 | 6.4% | 2005-09 | ACS 5-Year Estimate | +/- 1,115 |
| Occupied Housing Units | 545,138 | 93.6% | 2005-09 | ACS 5-Year Estimate | +/- 1,580 |
| Owner-Occupied Units3 | 291,242 | 53.4% | 2005-09 | ACS 5-Year Estimate | |
| Renter-Occupied Units3 | 253,896 | 46.6% | 2005-09 | ACS 5-Year Estimate | |
| Persons per Household | 2.7 | 2005-09 | ACS 5-Year Estimate | +/-0.02 | |
| 1-Person Households3 | 28.3% | 2005-09 | ACS 5-Year Estimate | +/- 0.4 | |
| 2-Person Households3 | 29.7% | 2005-09 | ACS 5-Year Estimate | +/- 0.4 | |
| 3-Person Households3 | 16.8% | 2005-09 | ACS 5-Year Estimate | +/- 0.4 | |
| 4-Person+ Households3 | 25.2% | 2005-09 | ACS 5-Year Estimate | +/- 0.3 | |
| African American Homeowners3 | 14.9% | 2005-09 | ACS 5-Year Estimate | +/- 0.2 | |
| Hispanic Homeowners3 | 15.1% | 2005-09 | ACS 5-Year Estimate | +/- 0.3 | |
| Asian Homeowners3 | 21.1% | 2005-09 | ACS 5-Year Estimate | +/- 0.2 | |
| Caucasian Homeowners3 | 45.9% | 2005-09 | ACS 5-Year Estimate | +/- 0.3 | |
| Native American Homeowners3 | 0.6% | 2005-09 | ACS 5-Year Estimate | +/- 0.1 |
| Foreclosure | Count | Rate per 1,000 units | Year | Sources |
| # NOTs issued in 2010 | 7,127 | 2010 | First American CoreLogic | |
| # NOTs past 2006-2010 | 24,934 | 2006-2010 | First American CoreLogic | |
| # NODs issued in 2010 | 11,691 | 2010 | Foreclosure Radar | |
| # NODs from 2006-2010 | 53,301 | 2006-2010 | Foreclosure Radar | |
| REO Properties in Dec. 2010 | 4,624 | Dec. 2010 | First American CoreLogic | |
| 5-year NOD rate | 101.84 | 2006-2010 | Foreclosure Radar/US Census | |
| 5-year NOT rate | 47.64 | 2006-2010 | First American CoreLogic/US Census |
| Health | Count | Percent/ Rate per 1,000 | Year | Sources | Error |
| Insured Persons | 1,291,564 | 87.3% | CHIS | +/- 0.3% | |
| Uninsured Persons | 187,438 | 12.7% | CHIS | +/- 0.6% | |
| All Cause Mortality Rate (per 100,000) | 27,728 | 2006-2008 | ACPHD | ||
| Teen Births | 4,011 | 2006-2008 | ACPHD | ||
| Low Weight Birth Rate | 4,548 | 7.2% | 3-year avg | ACPHD | |
| PreTerm Birth Rate | 9.5% | 2005 | ACPHD |
| Education | Count | Percent | Year | Sources | Error |
| Persons age 25+ | 989,608 | 2005-09 | ACS 5-Year Estimate | ||
| Persons age 25+ without a high school degree | 7.6% | 2005-09 | ACS 5-Year Estimate | +/- 0.2% | |
| Persons age 25+ with a high school degree/equivalent | 82.4% | 2000 | Census 2000 | ||
| Persons age 25+ with a Bachelor's degree or higher | 34.9% | 2000 | Census 2000 | ||
| CST ELA Proficiency4 | 153,277 | 57.8% | 2009-2010 | CDE | |
| CST Math Proficiency5 | 150,944 | 24.5% | 2009-2010 | CDE | |
| Dropout Rate6 | 4,996 | 27% | 2008-2009 | CDE |
| ACS = American Community Survey | ||
| NCHS = National Center for Health Statistics | ||
| CDE = California Department of Education | ||
| HUD = Housing and Urban Development | ||
| OUSD = Oakland Unified School District | ||
| ACPHD = Alameda County Public Health Department | ||
| UCR = Uniform Crime Reports | ||
| Note: percentages are not displayed for estimate data. | ||
| 1 Census considers Hispanic/Latino an ethnicity, independent of race | ||
| 2 Used census 2009 figure of 1,491,482 for population | ||
| 3 Universe is occupied housing units | ||
| 4 English-Language Arts - Grades 2-11 | ||
| 5 Mathematics - Grades 2-7, & end-of-course | ||
| 6 Adjusted Grade 9-12 4-year Derived Dropout Rate | ||
City Government Websites
City of Alameda
City of Albany
City of Berkeley
City of Dublin
City of Emeryville
City of Fremont
City of Hayward
City of Livermore
City of Newark
City of Oakland
City of Piedmont
City of Pleasanton
City of San Leandro
City of Union City
Alameda County Government Agencies
Alameda County Government
Public Health Department
Community Assessment Planning & Education (CAPE)
Social Services
Health Care Services
Environmental Health
Probation Department
Sheriff's Office
Assessor's Office
Board of Supervisors
County Office of Education
Alameda County Library
Alameda County Resources
Alameda County Community Food Bank
The Volunteer Center
United Way of the Bay Area