Transit Services Park and Rides Utilization

Park-and-Rides (PnR) are designated for daily transit use and free to use; parking for more than 24 hours is not permitted. There are 7 PnR’s within the City of Mesa. 4 are owned and maintained by the city; they are located at Gilbert Rd/McDowell, Power Rd/202, Superstition Springs Mall/60 and W. Juanita Ave/W. Jerome Ave. The other 3 PnR’s are owned and maintained by Valley Metro, and are located at Sycamore/Main St., Mesa Dr./Main St., and Gilbert Rd/Main St.

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 \"citydata-mesaaz-gov/transit-services-park-and-rides-utilization-aene-h56a\".\"transit_services_park_and_rides_utilization\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.