Open Parking and Camera Violations

The Open Parking and Camera Violations dataset was initially loaded with all violations contained in the mainframe database as of May 2016. Subsequent new violation issuance and updates to existing violations are applied to this data set on the following schedule:

New or open violations will be updated weekly (Sunday).

Violations satisfied by having been paid, dismissed via hearing, statutorily expired, or had other changes to its status, will be updated daily (Tuesday through Sunday).

Violations that have been written-off because they have statutorily expired and are no longer valid are indicated with blank financials.

Summons images will not be available during scheduled downtime on Sundays from 5:00 am to 10:00 am.

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 \"cityofnewyork-us/open-parking-and-camera-violations-nc67-uf89\".\"open_parking_and_camera_violations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.