RHNA Draft Performance Measures - Categorized v3

Dataset describes jurisdictions according to 8 measures which will be used to gauge RHNA performance. Each measure has been categorized into two groups, for most the top 25 cities in a category versus the remainder.

The core metrics mapping directly to CA HCD objective metrics include: Percent of RHNA as lower income units for jurisdictions with the highest housing costs. Measure: Housing costs Share of homeowners living in units valued above $750,000. Threshold grouping: upper third vs rest Percent of RHNA as lower income units for jurisdictions with highest percent of single-family homes. Measure: Percent single family Threshold grouping: upper third vs rest Total unit allocations for jurisdictions with the most jobs. Measure: Total Jobs Threshold grouping: upper third vs rest Allocations of lower income units for jurisdictions with the most low-wage jobs. Measure: Low wage jobs Threshold grouping: upper third vs rest Percent of RHNA as lower income units for jurisdictions with the highest ratio of low-wage jobs to housing units affordable to low-wage workers. Measure: jobs-housing fit Threshold grouping: upper third vs rest Percent of RHNA as lower income units for low-income jurisdictions. Measure: median household income. Low income threshold: bottom third Percent of RHNA as lower income units for high-income jurisdiction. Measure: median household income. High income threshold: upper third Percent of RHNA as lower income units for jurisdictions with the most households in High Resource/Highest Resource tracts. Measure: Share households in HRAs Threshold grouping: upper third vs rest

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 \"bayareametro-gov/rhna-draft-performance-measures-categorized-v3-tdbx-ty2j\".\"rhna_draft_performance_measures_categorized_v3\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.