Name: Joined_Funding_Table

Display Field: Year

Type: Table

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• Project_ID (type: esriFieldTypeInteger, alias: Project ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Year (type: esriFieldTypeString, alias: Year, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• Electric (type: esriFieldTypeInteger, alias: Electric, SQL Type: sqlTypeOther, nullable: true, editable: true)
• General (type: esriFieldTypeInteger, alias: General, SQL Type: sqlTypeOther, nullable: true, editable: true)
• General_B (type: esriFieldTypeInteger, alias: General B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• General_T (type: esriFieldTypeInteger, alias: General T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Stormwater (type: esriFieldTypeInteger, alias: Stormwater, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total (type: esriFieldTypeInteger, alias: Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Wastewater (type: esriFieldTypeInteger, alias: Wastewater, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Wastewater_I (type: esriFieldTypeInteger, alias: Wastewater I, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Water (type: esriFieldTypeInteger, alias: Water, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Water_I (type: esriFieldTypeInteger, alias: Water I, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParentGlobalID (type: esriFieldTypeGUID, alias: Parent Global ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• General_Text (type: esriFieldTypeString, alias: General_Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Water_Text (type: esriFieldTypeString, alias: Water_Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Wastewater_Text (type: esriFieldTypeString, alias: Wastewater_Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• General_T_Text (type: esriFieldTypeString, alias: General_T_Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Stormwater_Text (type: esriFieldTypeString, alias: Stormwater_Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Electric_Text (type: esriFieldTypeString, alias: Electric_Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Total_Text (type: esriFieldTypeString, alias: Total_Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Reclaimed (type: esriFieldTypeInteger, alias: Reclaimed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Reclaimed_Text (type: esriFieldTypeString, alias: Reclaimed (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pl_DepartmentOwner (type: esriFieldTypeString, alias: Department/Owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pl_Category (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AIRPORT: Airport], [ELECTRIC: Electric], [ENGINEERING: Engineering], ... 7 more ...)
• pl_FundingSource (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Multi: Multi], [General: General], [Stormwater: Stormwater], ... 5 more ...)
• pl_ProjectID (type: esriFieldTypeString, alias: Project ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ProjectID_Int (type: esriFieldTypeInteger, alias: Project ID (Int), SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_ProjectName (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• pl_ProjectDescription (type: esriFieldTypeString, alias: Project Description, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• pl_CompPlanGoals (type: esriFieldTypeString, alias: Comp Plan Goals, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pl_StrategicInitiatives (type: esriFieldTypeString, alias: Strategic Initiatives, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pl_Mandated (type: esriFieldTypeSmallInteger, alias: Mandated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_LifeCycle (type: esriFieldTypeSmallInteger, alias: Life Cycle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_ExternalProject (type: esriFieldTypeSmallInteger, alias: External Project, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_GrantApproved (type: esriFieldTypeSmallInteger, alias: Grant Approved, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_CouncilCMODirection (type: esriFieldTypeSmallInteger, alias: Council/CMO Direction, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_StrategicInitiative (type: esriFieldTypeSmallInteger, alias: Strategic Initiative, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_GrantFunding (type: esriFieldTypeSmallInteger, alias: Grant Funding, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_SVI (type: esriFieldTypeInteger, alias: Social Vulneability Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_ProjectUnderway (type: esriFieldTypeSmallInteger, alias: Project Underway, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_OperationalNecessity (type: esriFieldTypeSmallInteger, alias: Operational Necessity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_MasterPlannedProject (type: esriFieldTypeSmallInteger, alias: Master Planned Project, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_TotalRank (type: esriFieldTypeSmallInteger, alias: Total Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_YearsFunded (type: esriFieldTypeString, alias: Years Funded, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pl_FundingSources (type: esriFieldTypeString, alias: Funding Sources, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pl_ScaleOverride (type: esriFieldTypeString, alias: Scale Override, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• pl_ScaleFactor (type: esriFieldTypeInteger, alias: Scale Factor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_ExternalFunding (type: esriFieldTypeSmallInteger, alias: External Funding (Planning), SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_EstimatedProjectCost (type: esriFieldTypeInteger, alias: Estimated Project Cost (Planning), SQL Type: sqlTypeOther, nullable: true, editable: true)
• pl_Citywide (type: esriFieldTypeString, alias: Citywide (Planning), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pl_10YearCIP (type: esriFieldTypeString, alias: 10 Year CIP (Planning), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• last_edited_user_1774381512082 (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date_1774381512082 (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GlobalID_1774381512082 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user_1774381512082 (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date_1774381512082 (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeOther, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/24/2026 9:43:58 PM

Schema Last Edit Date: 3/23/2026 8:49:46 PM

Data Last Edit Date: 3/24/2026 6:00:23 PM

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