City Owned and Leased Property (COLP)
City Owned and Leased Properties (COLP) is published by the Department of City Planning (DCP) as required by chapter 204 of the City Charter. It includes the location and current use of all City-owned and leased properties. COLP is produced from an extract of the Integrated Property Information System (IPIS), a real estate database maintained by the Department of Citywide Administrative Services (DCAS). Except where indicated, the data provided is from IPIS. Questions or feedback on errors within the City Owned and Leased Properties can be directed to DCAS Land Use Planning at (212) 386-0622 or [email protected]. All previously released versions of this data are available on the DCP Website: BYTES of the BIG APPLE. Current version: 20260430
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
- Every 6 months
- Actually updates about every
- —
- Publisher last updated the data
- May 18, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- May 18, 2026, 11:52 AM
- Rows in our copy
- 17,298
- Rows at the source
- 17,298
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
The publisher has not provided a data dictionary.
1 of 29 columns carry a concept; 29 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 |
|---|---|---|---|---|---|---|---|---|
street_name | STREET NAME | Name of the street | Not bound | Text | street_name | text | — | |
house_number | HOUSE NUMBER | House number | Not bound | Text | house_number | text | — | |
excatdesc | EXPANDED CATEGORY DESCRIPTION | Descriptions for the expanded category values. See EXPANDCAT for the domain values. | Not bound | Text | excatdesc | text | — | |
expanded_category_code | EXPANDED CATEGORY CODE | This categorization classifies records into broad groups based on use. Valid values are 1 - 9. | Not bound | Number | expanded_category_code | numeric | — | |
agency | AGENCY | Abbreviation for agency or entity using the lot. See appendix A for a list of abbreviations with their full name. | Not bound | Text | agency | text | — | |
leased_properties | LEASED PROPERTIES | A value of "L" indicates that the agency's use of the property is authorized through a lease. For questions about the lease or ownership status of specific lots, please contact DCAS at (212) 386-0622 or [email protected]. | Not bound | Text | leased_properties | text | — | |
longitude |
Download
This file was produced on Aug 25, 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/fn4k-qyk2
- Version
- Content hash:
842d3c2d462151c581f42d2aebfaa636ce6586a33d159b8b78e071bb57b3f22b - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- May 18, 2026, 11:52 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 24, 2026, 8:16 AM | full_replace | success | 17,298 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.68 |