cityofnewyork-us/asset-management-parks-system-amps-assets-e25p-jzfy

  • amps
  • parks
  • plan-amps
  • work orders

Asset Management Parks System (AMPS) – Assets

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 <a href="https://docs.google.com/document/d/1UwyGGncb6oFMiOfgz73G-iM8Yea9ubz4931hPeBO9YQ/edit?usp=sharing">this link</a>

For the Data Dictionary, please follow <a href="https://docs.google.com/spreadsheets/d/1pDr-BUe4LS7DvATfbOnd8UrV6s77krJgzqdq_gVYWqc/edit?usp=sharing">this link </a>

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
OBJ_NOTUSEDobj_notusedobj_notusedText
OBJ_UDFCHAR05obj_udfchar05obj_udfchar05Text
OBJ_CATEGORYobj_categoryobj_categoryText
OBJ_POSITIONobj_positionobj_positionText
OBJ_GISOBJIDobj_gisobjidobj_gisobjidText
OBJ_UDFCHAR06obj_udfchar06obj_udfchar06Text
OBJ_MANUFACTMODELobj_manufactmodelobj_manufactmodelText
OBJ_STATUSobj_statusobj_statusText
OBJ_UDFCHAR02obj_udfchar02obj_udfchar02Text
OBJ_SERIALNOobj_serialnoobj_serialnoText
OBJ_VALUEobj_valueobj_valueText
OBJ_UPDATECOUNTobj_updatecountobj_updatecountText
OBJ_UPDATEDobj_updatedobj_updatedText
OBJ_WITHDRAWobj_withdrawobj_withdrawText
OBJ_DESCobj_descobj_descText
OBJ_PARENTobj_parentobj_parentText
OBJ_UDFCHAR01obj_udfchar01obj_udfchar01Text
OBJ_OBTYPEobj_obtypeobj_obtypeText
OBJ_SQLIDENTITYobj_sqlidentityobj_sqlidentityText
OBJ_CODEobj_codeobj_codeText
OBJ_RECORDobj_recordobj_recordText
OBJ_CLASSobj_classobj_classText
OBJ_MANUFACTobj_manufactobj_manufactText
OBJ_MRCobj_mrcobj_mrcText
OBJ_CREATEDobj_createdobj_createdText
OBJ_COMMISSobj_commissobj_commissText
OBJ_GISLAYERobj_gislayerobj_gislayerText
OBJ_XLOCATIONobj_xlocationobj_xlocationText
OBJ_YLOCATIONobj_ylocationobj_ylocationText

Upstream Metadata