Asset Management Parks System (AMPS) – Transaction Details

ub9z-gccpCity Government31 columns

This table contains specific information about each part that is included in a transaction. Each record has information about one type of part in the transaction. A single transaction could have multiple lines (one for each type of part) in this table. The TRL_TRANS field can be joined to the Transactions table on TRA_CODE to know which parts were part the transaction. For the User Guide, please follow this link For the Data Dictionary, please follow this link

View on NYC Open Data

Quality

B89.3 / 100

From a 500-row sample across 31 columns.

completeness81/ 25% weight

consistency77/ 20% weight

accuracy93/ 20% weight

timeliness100/ 15% weight

usability100/ 20% weight

· Has geographic keys — joinable to other NYC datasets

Related datasets

Sample rows

trl_trans	trl_type	trl_line	trl_date	trl_event	trl_part	trl_bin	trl_store	trl_price	trl_qty	trl_created	trl_updated
388948	I	10	Mar 11 2013 9:35AM	708055	10221	01	B-01	0.203757	1.000000	Mar 12 2013 9:51AM	Mar 12 2013 9:51AM
179132	I

Columns

31 queryable · 31 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`trl_trans`	integer	—	0%	`899882773396741742`
`trl_type`	categorical	—	0%	`IRECVSTTK`of 6
`trl_line`	text	—	0%	`102030`
`trl_date`	text	—	0%	`May 26 2023 8:56AMMay 17 2019 10:40AMJun 7 2018 9:58AM`
`trl_event`	text

Query this from your own app

GET /api/datasets/ub9z-gccp
GET /api/datasets/ub9z-gccp/quality
GET /api/datasets/ub9z-gccp/related
GET /api/columns?dataset=ub9z-gccp