About this Dataset

Parks Concessions

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 Concession Transactions is here https://data.cityofnewyork.us/City-Government/Parks-Concession-Transactions/vmkw-p55f and can be joined to Parks Concessions using PersonID, PropertyID and UnitID.
Organization: City of New York
Last updated: 2020-11-10T17:00:45.117387
Tags: concessions, parks

Tables

Table 1

@usgov.city_of_new_york_parks_concessions.table_1

915.92 kB
4,357 rows
59 columns

CREATE TABLE table_1 (
  "propertyid" BIGINT,
  "contractcode" VARCHAR,
  "addressline1" VARCHAR,
  "addressline2" VARCHAR,
  "addressline3" VARCHAR,
  "concessioncity" VARCHAR,
  "concessionstate" VARCHAR,
  "concessionzipcode" VARCHAR,
  "concessionextraaddressinfo" VARCHAR,
  "latepercentage" BIGINT,
  "endoffiscalyear" BIGINT,
  "unitid" BIGINT,
  "januaryminfee" DOUBLE,
  "februaryminfee" DOUBLE,
  "marchminfee" DOUBLE,
  "aprilminfee" DOUBLE,
  "mayminfee" DOUBLE,
  "juneminfee" DOUBLE,
  "julyminfee" DOUBLE,
  "augustminfee" DOUBLE,
  "septemberminfee" DOUBLE,
  "octoberminfee" DOUBLE,
  "novemberminfee" DOUBLE,
  "decemberminfee" DOUBLE,
  "concessiontypeid" VARCHAR,
  "unittype" VARCHAR,
  "personid" BIGINT,
  "operatorlastname" VARCHAR,
  "operatorfirstname" VARCHAR,
  "operatorstatus" BIGINT,
  "permitorlicensestartdate" VARCHAR,
  "permitorlicensefee" DOUBLE,
  "dueday" BIGINT,
  "moveindate" VARCHAR,
  "permitorlicenseenddate" VARCHAR,
  "lategracedays" DOUBLE,
  "overagemonth" BIGINT,
  "annualminimumfees1" VARCHAR,
  "annualminimumfees2" VARCHAR,
  "annualminimumfees3" VARCHAR,
  "annualminimumfees4" VARCHAR,
  "annualminimumfees5" VARCHAR,
  "percentduedate" VARCHAR,
  "securitydepositreq" VARCHAR,
  "permitnumber" VARCHAR,
  "grossreceiptdate" VARCHAR,
  "origcontracexpdate" VARCHAR,
  "percentagefeereq" VARCHAR,
  "percentagefeedate" VARCHAR,
  "letterofcreditinfo1" VARCHAR,
  "letterofcreditinfo2" VARCHAR,
  "addlocationinfo1" VARCHAR,
  "addlocationinfo2" VARCHAR,
  "capitalworkreq" VARCHAR,
  "contractstatus" VARCHAR,
  "contractsigndate" VARCHAR,
  "contractenddate" VARCHAR,
  "geometrytype" VARCHAR,
  "shape" VARCHAR
);