About this Dataset

Asset Management Parks System (AMPS) – Assets

This table contains information about objects that work orders can be written to. Examples of objects types include pieces of equipment, buildings, parks, maintenance districts, and boroughs. Each record has specific information about that object. The primary key is OBJ_CODE. 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-07T16:54:05.431050
Tags: amps-plan-amps, parks, work-orders

Tables

Table 1

@usgov.city_of_new_york_asset_management_parks_system_amps_assets.table_1

6.14 MB
146,186 rows
29 columns

CREATE TABLE table_1 (
  "obj_obtype" VARCHAR,
  "obj_code" VARCHAR,
  "obj_desc" VARCHAR,
  "obj_class" VARCHAR,
  "obj_category" VARCHAR,
  "obj_position" VARCHAR,
  "obj_parent" VARCHAR,
  "obj_manufact" VARCHAR,
  "obj_mrc" VARCHAR,
  "obj_serialno" VARCHAR,
  "obj_status" VARCHAR,
  "obj_commiss" VARCHAR,
  "obj_withdraw" VARCHAR,
  "obj_record" VARCHAR,
  "obj_notused" VARCHAR,
  "obj_manufactmodel" VARCHAR,
  "obj_value" DOUBLE,
  "obj_updated" VARCHAR,
  "obj_updatecount" BIGINT,
  "obj_gisobjid" DOUBLE,
  "obj_sqlidentity" BIGINT,
  "obj_gislayer" VARCHAR,
  "obj_xlocation" DOUBLE,
  "obj_ylocation" DOUBLE,
  "obj_udfchar01" VARCHAR,
  "obj_udfchar02" VARCHAR,
  "obj_udfchar05" VARCHAR,
  "obj_udfchar06" VARCHAR,
  "obj_created" VARCHAR
);