Fleet

This dataset provides data about the assets that are managed by the Division of Fleet Management. Assets fall into two categories: vehicle or equipment.

Fleet Management uses a point system that considers a variety of factors to determine which assets are recommended for replacement. An asset with 15 points or higher is recommended for replacement.

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 \"norfolk-gov/fleet-w26i-qme9\".\"fleet\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.