Asset Management Parks System (AMPS) – Transaction Details
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
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Fresh
- Says it updates
- As needed
- Actually updates about every
- 7 days
- Publisher last updated the data
- Oct 5, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 5, 2026, 5:27 AM
- Rows in our copy
- 2,294,667
- Rows at the source
- 2,294,667
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
0 of 31 columns carry a concept; 0 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
trl_act | TRL_ACT | The publisher describes this column nowhere. | Not bound | Text | trl_act | text | — | |
trl_bin | TRL_BIN | The publisher describes this column nowhere. | Not bound | Text | trl_bin | text | — | |
par_updatecount | PAR_UPDATECOUNT | The publisher describes this column nowhere. | Not bound | Text | par_updatecount | text | — | |
par_laststatusupdate | PAR_LASTSTATUSUPDATE | The publisher describes this column nowhere. | Not bound | Text | par_laststatusupdate | text | — | |
trl_req | TRL_REQ | The publisher describes this column nowhere. | Not bound | Text | trl_req | text | — | |
trl_type | TRL_TYPE | The publisher describes this column nowhere. | Not bound | Text |
Download
This file was produced on Oct 5, 2026, 10:04 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/ub9z-gccp
- Version
- Content hash:
1cd056f563bc9d53001ce90d6942e0c3e580f55ee30802794b4d41b4ced27333 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 5, 2026, 5:27 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 5, 2026, 9:02 AM | full_replace | success | 2,294,667 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 28, 2026, 9:30 AM | full_replace | success | 2,292,473 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 21, 2026, 9:22 AM | full_replace | success | 2,291,232 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.82 |
| Sep 14, 2026, 9:15 AM | full_replace | success | 2,290,091 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Sep 7, 2026, 9:00 AM | full_replace | success | 2,288,582 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Sep 3, 2026, 9:59 PM | full_replace | success | 2,287,962 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 31, 2026, 9:18 AM | full_replace | success | 2,285,932 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 29, 2026, 3:00 AM | full_replace | success | 2,285,003 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |