Physical Fitness

Physical fitness is measured by whether OUSD students are in the “Healthy Fitness Zone” in all six fitness areas captured by the Physical Fitness Test. The test is administered to students in grades 5, 7, and 9, and it measures abdominal strength, aerobic capacity, body composition, flexibility, trunk extensor strength, and upper body strength. Students are assessed based on whether they meet standards in each of these areas and are categorized as “Healthy Fitness Zone,” “Needs Improvement,” or “Needs Improvement - Health Risk”.

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/physical-fitness-x8wh-yfzv\".\"physical_fitness\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.