Parks Concession Transactions

NYC Parks uses a Commercial Off-The-Shelf database for maintaining its concession-related data. In its raw form, the Parks data within the Yardi Voyager database has a convoluted structure, the majority of which is not being used by Parks to store any data. In an effort to make the data more user friendly, the multitude of tables used by the source database have been distilled into two that contain the essential information for a concessions database. One table (Parks Concessions) represents the concession asset – the place and thing which is being operated – and who holds the contract. The other (Parks Concession Transactions) represents transactions between those contract holders and NYC Parks. Parks Concessions is here https://data.cityofnewyork.us/City-Government/Parks-Concessions/53m8-jdtg and can be joined to Parks Concession Transactions using PersonID, PropertyID and UnitID.

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/parks-concession-transactions-vmkw-p55f\".\"parks_concession_transactions\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.