Transportation Pavement Inventory

This feature class identifies all roadways and parking areas that are maintained by the City of Mesa. This includes streets, intersections, parking lots, paved alleys, unpaved alleys, and dirt roads. Data are stored as a line geometry type feature class in the City Enterprise Geodatabase. The projected coordinate system is NAD 1983 State Plane Arizona Central FIPS 0202 Feet.

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/transportation-pavement-inventory-2gx3-zdvf\".\"transportation_pavement_inventory\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.