Name: FiveYearPlanFY23FY27

Display Field: STREET

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: Lane width for Majors & Minors is 10'. Lane feet derived from equation: WIDTH divided by 10 x LENGTH. Number of lanes for Alleys is 1 as decided by City Engineer for future reporting (as of May 22, 2023)

Copyright Text: Public Works GIS, Engineering Bureau, IMS

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -13160564.5938297
YMin: 3995471.41881559
XMax: -13142966.3478712
YMax: 4012788.27542885
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[165,47,36,255],"width":1}},"scaleSymbols":true,"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)
• STREET (type: esriFieldTypeString, alias: STREET, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• FROM_ (type: esriFieldTypeString, alias: FROM_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• TO_ (type: esriFieldTypeString, alias: TO_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• GISID (type: esriFieldTypeDouble, alias: GISID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NETWORK (type: esriFieldTypeString, alias: NETWORK, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COMPLETED_ (type: esriFieldTypeDate, alias: COMPLETED_, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WORK_TYPE (type: esriFieldTypeString, alias: WORK_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MORAT_END (type: esriFieldTypeSmallInteger, alias: MORAT_END, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pvmt_Type (type: esriFieldTypeString, alias: Pvmt_Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GISID_T (type: esriFieldTypeString, alias: GISID_T, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• PCI_2014 (type: esriFieldTypeSmallInteger, alias: PCI_2014, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCI_2017 (type: esriFieldTypeDouble, alias: PCI_2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REHAB_TYPE (type: esriFieldTypeString, alias: REHAB_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LENGTH_FT (type: esriFieldTypeInteger, alias: LENGTH_FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WIDTH_FT (type: esriFieldTypeInteger, alias: WIDTH_FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AREA_SF (type: esriFieldTypeInteger, alias: AREA_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNIT_COST (type: esriFieldTypeDouble, alias: UNIT_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IIP (type: esriFieldTypeString, alias: IIP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CD (type: esriFieldTypeSmallInteger, alias: CD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_AREA_yd2 (type: esriFieldTypeDouble, alias: TOTAL_AREA_yd2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SURVEY_DATE (type: esriFieldTypeDate, alias: SURVEY_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SuperSegGroup (type: esriFieldTypeInteger, alias: SuperSegGroup, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FY_Program (type: esriFieldTypeString, alias: FY_Program, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MODIFIED_DATE (type: esriFieldTypeDate, alias: MODIFIED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PW_COMMENT (type: esriFieldTypeString, alias: PW_COMMENT, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FY19_CIP (type: esriFieldTypeString, alias: FY19_CIP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PCI_2018 (type: esriFieldTypeDouble, alias: PCI_2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FY21_CIP (type: esriFieldTypeString, alias: FY21_CIP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PCI_2018_RANK (type: esriFieldTypeString, alias: PCI_2018_RANK, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• FY22_CIP (type: esriFieldTypeString, alias: FY22_CIP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CurrentPCI_2021 (type: esriFieldTypeDouble, alias: CurrentPCI_2021, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CurrentPCI_2021_Rank (type: esriFieldTypeString, alias: CurrentPCI_2021_Rank, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SuperSegPCI_2021 (type: esriFieldTypeDouble, alias: SuperSegPCI_2021, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SuperSegStrength_2021 (type: esriFieldTypeString, alias: SuperSegStrength_2021, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FY21StaticImage (type: esriFieldTypeString, alias: FY21StaticImage, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FY21ScrollableImage (type: esriFieldTypeString, alias: FY21ScrollableImage, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CD_2011 (type: esriFieldTypeSmallInteger, alias: CD_2011, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IIP_2 (type: esriFieldTypeString, alias: IIP_2, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• FY23_CIP (type: esriFieldTypeString, alias: FY23_CIP, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• MISC1 (type: esriFieldTypeString, alias: MISC1, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• MISC2 (type: esriFieldTypeString, alias: MISC2, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• MISC3 (type: esriFieldTypeString, alias: MISC3, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• MISC_NO (type: esriFieldTypeSingle, alias: MISC_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Year_of_First_Rehab (type: esriFieldTypeInteger, alias: Year_of_First_Rehab, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Rehab_Activity_Code (type: esriFieldTypeString, alias: Rehab_Activity_Code, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Rehab_Activity (type: esriFieldTypeString, alias: Rehab_Activity, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Segment_Total_Cost (type: esriFieldTypeInteger, alias: Segment_Total_Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F5_Year_Post_Rehab_PCI (type: esriFieldTypeInteger, alias: F5_Year_Post_Rehab_PCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RehabCode_Int (type: esriFieldTypeInteger, alias: RehabCode_Int, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LANES (type: esriFieldTypeDouble, alias: LANES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LANE_MI (type: esriFieldTypeDouble, alias: LANE_MI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: true)
• WSP (type: esriFieldTypeString, alias: WSP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Loc_name (type: esriFieldTypeString, alias: Loc_name, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• USER_City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Project_Title (type: esriFieldTypeString, alias: Project_Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Project_Location (type: esriFieldTypeString, alias: Project_Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Zipcode (type: esriFieldTypeString, alias: Zipcode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Location_Type (type: esriFieldTypeString, alias: Location_Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Total_Measure_A_Funding_in (type: esriFieldTypeDouble, alias: Total_Measure_A_Funding_in_Plan, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Total_Additional_Funding_i (type: esriFieldTypeDouble, alias: Total_Additional_Funding_in_Pla, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Total_Infrastructure_Inves (type: esriFieldTypeDouble, alias: Total_Infrastructure_Investment, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Currently_Budgeted_Measure (type: esriFieldTypeDouble, alias: Currently_Budgeted_Measure_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Additional_Funding_Receive (type: esriFieldTypeDouble, alias: Additional_Funding_Received___S, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Project_Scope___Informatio (type: esriFieldTypeString, alias: Project_Scope___Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Council_District (type: esriFieldTypeDouble, alias: Council_District, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Current_Stage_of_Project (type: esriFieldTypeString, alias: Current_Stage_of_Project, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Estimated_Completion_Date (type: esriFieldTypeString, alias: Estimated_Completion_Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Estimated_Construction_Dat (type: esriFieldTypeString, alias: Estimated_Construction_Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Thematic_Category (type: esriFieldTypeString, alias: Thematic_Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Additional_Funding_ID (type: esriFieldTypeString, alias: Additional_Funding_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Category (type: esriFieldTypeInteger, alias: Category, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: FiveYearPlanFY23FY27
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/12/2025 12:14:49 AM

Schema Last Edit Date: 7/12/2025 12:14:49 AM

Data Last Edit Date: 7/12/2025 12:14:49 AM

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