Name: Captial_Projects_Database_poly

Display Field: maprojid

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Spatial data at the polygon level can be joined to the tabular Capital Projects dataset using the FSM ID. A majority of the spatial data was made available on NYC Open Data by agency partners. Some geometries were created manually, while others relied on 'Fuzzy String Matching'. This process relied on a join to DCP's Facilities Database and DPR's Parks Properties to match project descriptions to physical locations.

Copyright Text: Department of City Planning (DCP), Office of Management and Budget (OMB), Department of Design and Construction (DDC), Economic Development Corporation (EDC), Department of Transportation (DOT), Department of Parks and Recreation (DPR)

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 913033.388156502
YMin: 119518.542180998
XMax: 1065869.85282417
YMax: 271313.790755261
Spatial Reference: 102718 (2263)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[246,250,212,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ccpversion (type: esriFieldTypeString, alias: ccpversion, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• maprojid (type: esriFieldTypeString, alias: maprojid, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• magenacro (type: esriFieldTypeString, alias: magenacro, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• magency (type: esriFieldTypeString, alias: magency, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• magenname (type: esriFieldTypeString, alias: magenname, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• descript (type: esriFieldTypeString, alias: descript, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• projectid (type: esriFieldTypeString, alias: projectid, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• mindate (type: esriFieldTypeString, alias: mindate, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• maxdate (type: esriFieldTypeString, alias: maxdate, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• typecat (type: esriFieldTypeString, alias: typecat, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• pcccnonex (type: esriFieldTypeDouble, alias: pcccnonex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pcccex (type: esriFieldTypeDouble, alias: pcccex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pccc (type: esriFieldTypeDouble, alias: pccc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pcnccstate (type: esriFieldTypeDouble, alias: pcnccstate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pcnccfed (type: esriFieldTypeDouble, alias: pcnccfed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pcnccother (type: esriFieldTypeDouble, alias: pcnccother, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pcncc (type: esriFieldTypeDouble, alias: pcncc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pctotal (type: esriFieldTypeDouble, alias: pctotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adccnonex (type: esriFieldTypeDouble, alias: adccnonex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adccex (type: esriFieldTypeDouble, alias: adccex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adcc (type: esriFieldTypeDouble, alias: adcc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adnccstate (type: esriFieldTypeDouble, alias: adnccstate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adnccfed (type: esriFieldTypeDouble, alias: adnccfed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adnccother (type: esriFieldTypeDouble, alias: adnccother, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adncc (type: esriFieldTypeDouble, alias: adncc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adtotal (type: esriFieldTypeDouble, alias: adtotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• alccnonex (type: esriFieldTypeDouble, alias: alccnonex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• alccex (type: esriFieldTypeDouble, alias: alccex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• alcc (type: esriFieldTypeDouble, alias: alcc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• alnccstate (type: esriFieldTypeDouble, alias: alnccstate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• alnccfed (type: esriFieldTypeDouble, alias: alnccfed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• alnccother (type: esriFieldTypeDouble, alias: alnccother, SQL Type: sqlTypeOther, nullable: true, editable: true)
• alncc (type: esriFieldTypeDouble, alias: alncc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• altotal (type: esriFieldTypeDouble, alias: altotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• coccnonex (type: esriFieldTypeDouble, alias: coccnonex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• coccex (type: esriFieldTypeDouble, alias: coccex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cocc (type: esriFieldTypeDouble, alias: cocc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• conccstate (type: esriFieldTypeDouble, alias: conccstate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• conccfed (type: esriFieldTypeDouble, alias: conccfed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• conccother (type: esriFieldTypeDouble, alias: conccother, SQL Type: sqlTypeOther, nullable: true, editable: true)
• concc (type: esriFieldTypeDouble, alias: concc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cototal (type: esriFieldTypeDouble, alias: cototal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spccnonex (type: esriFieldTypeDouble, alias: spccnonex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spccex (type: esriFieldTypeDouble, alias: spccex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spcc (type: esriFieldTypeDouble, alias: spcc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spnccstate (type: esriFieldTypeDouble, alias: spnccstate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spnccfed (type: esriFieldTypeDouble, alias: spnccfed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spnccother (type: esriFieldTypeDouble, alias: spnccother, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spncc (type: esriFieldTypeDouble, alias: spncc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sptotal (type: esriFieldTypeDouble, alias: sptotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sptotalcb (type: esriFieldTypeDouble, alias: sptotalcb, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Captial_Projects_Database_poly
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/9/2025 8:42:23 PM

Schema Last Edit Date: 12/9/2025 8:42:23 PM

Data Last Edit Date: 12/9/2025 8:42:23 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat