Street Centerline

Existing centerlines of streets within the Mesa planning area (won’t include recorded or permitted centerlines). Foundation for spatial-based priorities such as traffic counts/flow counts, traffic speeds, economic development, emergency response, etc. Data represents streets from the City’s inception and is continually updated as changes or additions are made.

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/street-centerline-9uib-89q3\".\"street_centerline\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.