About this Dataset

Asset Management Parks System (AMPS) – Comments

This table all comments for all tables in AMPS. The record for each comment indicates which record and table the comment pertains to. Each record is a single comment. The ADD_CODE field can be joined to another table according to the value in ADD_ENTITY. For the User Guide, please follow this link For the Data Dictionary, please follow this link
Organization: City of New York
Last updated: 2021-08-07T17:18:33.569386
Tags: amps-plan-amps, comments, parks, work-orders

Tables

Table 1

@usgov.city_of_new_york_asset_management_parks_system_amps_comments.table_1

27.49 MB
848,885 rows
10 columns

CREATE TABLE table_1 (
  "add_entity" VARCHAR,
  "add_code" VARCHAR,
  "add_lang" VARCHAR,
  "add_line" BIGINT,
  "add_print" VARCHAR,
  "add_text" VARCHAR,
  "add_created" VARCHAR,
  "add_updated" VARCHAR,
  "add_updatecount" BIGINT,
  "add_sqlidentity" BIGINT
);