About this Dataset

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.
Organization: City of New York
Last updated: 2020-11-10T17:05:47.344889
Tags: concessions, parks, transactions

Tables

Table 1

@usgov.city_of_new_york_parks_concession_transactions.table_1

5.39 MB
206,235 rows
15 columns

CREATE TABLE table_1 (
  "transactionid" BIGINT,
  "relatedtransactionid" BIGINT,
  "propertyid" DOUBLE,
  "unitid" BIGINT,
  "personid" BIGINT,
  "contractcode" VARCHAR,
  "operatorlastname" VARCHAR,
  "totalamount" DOUBLE,
  "amountpaid" DOUBLE,
  "transactiontype" BIGINT,
  "transactionstatus" BIGINT,
  "transactionpostdate" VARCHAR,
  "transactiondate" VARCHAR,
  "transactiondesc" VARCHAR,
  "chargetype" DOUBLE
);