RHNA Draft Performance Measures - Categorized v2

Dataset describes jurisdictions according to 8 measures which will be used to gauge RHNA performance. Each measure has been categorized into discrete buckets, for use in summarizing the jurisdiction-specific RHNA allocation.

The core metrics mapping directly to CA HCD objective metrics include:

Measure 1a: Lower Income RHNA in High Cost Areas

Measure 1b: Lower Income RHNA in Single-Family Home Areas

Measure 2a: Household Growth in Job Centers

Measure 3a: Lower Income RHNA in Jobs-Housing Fit Imbalanced Areas

Measure 4a: Lower Income RHNA in Areas with High Share of Low-Income Households

Measure 4b: Lower Income RHNA in Areas with High Share of High-Income Households

Measure 5a: Lower Income RHNA in High Opportunity Areas

Measure 5b: Household Growth in High Divergence Score Areas with High-Income Households

Measure 6b: Household Growth in High Hazard Risk Areas

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-v2-chur-7ghs\".\"rhna_draft_performance_measures_categorized_v2\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.