Police Patrol Shift Bid Positions

Sworn officer positions assigned to street patrol and calls for service. Number does not include sworn Sergeants, Lieutenants and Commanders of districts. Position count is calculated in August for each given year.

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/police-patrol-shift-bid-positions-mdcd-rjsu\".\"police_patrol_shift_bid_positions\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.