Equal Access Accommodations

The equal access accommodations Indicator is measured by comparing the percent of public contact position (PCP) employees who speak Spanish to the percent of Spanish speakers who have limited English proficiency (LEP) citywide. The Equal Access to Services Ordinance includes a requirement for City departments to offer bilingual services based on citywide demographics. In FY2016-2017, the two languages required by the ordinance were Spanish and Chinese. We chose to measure Spanish-speaking PCP employees for this Indicator because Spanish speakers comprise a larger proportion of the population.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"oaklandca-gov/equal-access-accommodations-m4xj-firs\".\"equal_access_accommodations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.