Layer: Projects 4+ years out (ID: 41)

Parent Layer: Vital Streets

Name: Projects 4+ years out

Display Field: Project_Name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><TABLE><TBODY><TR><TD>Engineering Construction Data Dictionary</TD><TD></TD></TR><TR><TD>Attribute Title</TD><TD>Description</TD><TD>Example</TD></TR><TR><TD>OBJECTID</TD><TD>System Generated Unique Identification Number</TD><TD>486</TD></TR><TR><TD>SHAPE</TD><TD>ESRI geospatial data</TD><TD>Polyline</TD></TR><TR><TD>Capital Project #</TD><TD>Number assigned to project when the capital project list is generated</TD><TD>LP59-23</TD></TR><TR><TD>GPF #</TD><TD>State Road Identification Number. Located on As-Builts</TD><TD>5860</TD></TR><TR><TD>Project #</TD><TD>Engineering project number <- Means project has started design</TD><TD>447-18001</TD></TR><TR><TD>Project Name</TD><TD>Official name of the project. From project initiation form</TD><TD>Reconstruction of JACKSON STREET from Valley Avenue to Garfield Avenue</TD></TR><TR><TD>Project Manager</TD><TD>Engineering staff assigned to the design of the project. From project initiation form</TD><TD>Dan Siminski</TD></TR><TR><TD>Project Type</TD><TD>Type of project being executed </TD><TD>Reconstruction</TD></TR><TR><TD>Fiscal Year (Funded)</TD><TD>Fiscal year that the capital project will be funded in. From Agenda item</TD><TD>2019</TD></TR><TR><TD>Design_Start</TD><TD>Date engineering started design work. From Design Award letter or Project Detail Report for City designed projects</TD><TD>7/21/2018</TD></TR><TR><TD>Construction Start Date</TD><TD>Date project construction officially starts</TD><TD>4/15/2019</TD></TR><TR><TD>Estimated Construction Start Date</TD><TD>Date project construction is anticipated to start. From Notice to proceed</TD><TD>4/1/2019</TD></TR><TR><TD>Substantial Completion</TD><TD>Date project is open to traffic. From Combined Spec Book or MDOT Proposal Book</TD><TD>6/25/2019</TD></TR><TR><TD>Project Close Date</TD><TD>Date project is closed in our system. From “Administration” tab in MS Projects.</TD><TD>8/30/2019</TD></TR><TR><TD>Created_Date</TD><TD>System generated date when GIS data was created</TD><TD>4/28/2018</TD></TR><TR><TD>Edit_Date</TD><TD>System generated date when GIS data was edited</TD><TD>4/30/2018</TD></TR><TR><TD>Capital Estimated Cost</TD><TD>Estimated cost approved by budget</TD><TD>$ 50,000.00</TD></TR><TR><TD>Engineer Estimate</TD><TD>Estimated cost generated at design phase. From Engineer’s Estimate at the “Bid Documents” folder</TD><TD>$ 54,000.00</TD></TR><TR><TD>Actual Cost</TD><TD>Actual cost of the projects after closeout. From “Administration” tab in MS Projects.</TD><TD>$ 60,000.00</TD></TR><TR><TD>Funding Source</TD><TD>City funding codes. From Agenda item </TD><TD>Water System Fund= $30,510</TD></TR><TR><TD>Created_By</TD><TD>GIS editor who created the asset in the data base</TD><TD>joeverman</TD></TR><TR><TD>Edit_By</TD><TD>Last GIS editor</TD><TD>joeverman</TD></TR><TR><TD>SHAPE_Length</TD><TD>Length of the line in feet, generated by the GIS system</TD><TD>494.938451</TD></TR><TR><TD>Website_URL</TD><TD>Address of project on the Web</TD><TD>https://www.grandrapidsmi.gov/Residents/Road-Construction/Jackson-Valley-to-Garfield-and-Lane-to-Jackson-Place</TD></TR><TR><TD>Year_Const</TD><TD>Year construction will take place</TD><TD>2023</TD></TR><TR><TD>Proj_Status</TD><TD>Status of project</TD><TD>Design</TD></TR><TR><TD>Proj_Location</TD><TD>Project Limits</TD><TD>Jackson Street - Valley Avenue to Garfield Avenue</TD></TR><TR><TD>Inspector</TD><TD>Engineering staff assigned to the inspection of the project.</TD><TD>Dustin Besteman</TD></TR><TR><TD>Construction Project Manager</TD><TD>Engineering staff assigned to the project. From CEI award letter </TD><TD>John Broom</TD></TR><TR><TD>Ward</TD><TD>City Ward where project is located at</TD><TD>2</TD></TR><TR><TD>Neighborhoods of Focus</TD><TD>Is project located at a Neighborhoods of Focus?</TD><TD>Yes</TD></TR><TR><TD>Has Green Infrastructure</TD><TD>Indicator to denote the installation of green infrastructure elements in a project</TD><TD>Yes</TD></TR><TR><TD>MDOT Project Number</TD><TD>Project number assigned by the Michigan Department of Transportation (MDOT)</TD><TD>216855</TD></TR><TR><TD>Not_To_ExceedCost</TD><TD>Maximum allowable cost or budget limit for a project. From the Agenda item</TD><TD>832210</TD></TR><TR><TD>OpenToTrafficDate</TD><TD>Date on which the street was opened for public use or traffic</TD><TD>mm/dd/yyyy</TD></TR><TR><TD>FinalCompletionDate</TD><TD>Expected date when all project activities and deliverables are completed</TD><TD>mm/dd/yyyy</TD></TR><TR><TD>RES_Date</TD><TD>The date when engineering services request was received</TD><TD>mm/dd/yyyy</TD></TR></TBODY></TABLE></DIV></DIV></DIV>

Copyright Text: City of Grand Rapids - Engineering Department

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Effective Min Scale: 15000

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
Capital_Prj_No ( type: esriFieldTypeString, alias: Capital Project #, length: 25 )
GPF_No ( type: esriFieldTypeString, alias: GPF #, length: 15 )
Project_No ( type: esriFieldTypeString, alias: Project #, length: 15 )
Project_Name ( type: esriFieldTypeString, alias: Project Name, length: 100 )
Project_Manager ( type: esriFieldTypeString, alias: Project Manager, length: 50 )
Project_Type ( type: esriFieldTypeString, alias: Project Type, length: 100 , Coded Values: [Recon: Reconstruction] , [CrackSeal: Crack Seal] , [Asphalt Overlay: Asphalt Overlay] , ...17 more... )
Funding_Fiscal_Year ( type: esriFieldTypeSmallInteger, alias: Fiscal Year (Funded) )
Design_Start ( type: esriFieldTypeDate, alias: Design_Start, length: 8 )
Act_Const_Start ( type: esriFieldTypeDate, alias: Construction Start Date, length: 8 )
Est_Const_Start ( type: esriFieldTypeDate, alias: Estimated Construction Start Date, length: 8 )
Construction_End ( type: esriFieldTypeDate, alias: Substantial Completion, length: 8 )
Project_Close ( type: esriFieldTypeDate, alias: Project Close Date, length: 8 )
Created_Date ( type: esriFieldTypeDate, alias: Created_Date, length: 8 )
Edit_Date ( type: esriFieldTypeDate, alias: Edit_Date, length: 8 )
Capital_Est_Cost ( type: esriFieldTypeDouble, alias: Capital Estimated Cost )
Engineer_Est_Cost ( type: esriFieldTypeDouble, alias: Engineer Estimate )
Act_Cost ( type: esriFieldTypeDouble, alias: Actual Cost )
Funding_Source ( type: esriFieldTypeString, alias: Funding_Source, length: 500 )
Created_By ( type: esriFieldTypeString, alias: Created_By, length: 50 )
Edit_By ( type: esriFieldTypeString, alias: Edit_By, length: 50 )
Website_URL ( type: esriFieldTypeString, alias: Website_URL, length: 200 )
Year_Const ( type: esriFieldTypeSmallInteger, alias: Year_Const )
Proj_Status ( type: esriFieldTypeString, alias: Proj_Status, length: 50 , Coded Values: [Projected: Projected] , [Active - Design Phase: Active - Design Phase] , [Active - Construction Phase: Active - Construction Phase] , ...3 more... )
Proj_Location ( type: esriFieldTypeString, alias: Proj_Location, length: 350 )
Inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
Construction_Project_Manager ( type: esriFieldTypeString, alias: Construction Project Manager, length: 50 )
Ward ( type: esriFieldTypeString, alias: Ward, length: 50 )
Neighborhoods_of_Focus ( type: esriFieldTypeString, alias: Neighborhoods of Focus, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
Has_GI ( type: esriFieldTypeString, alias: Has Green Infrastructure, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
MDOT_Project_No ( type: esriFieldTypeString, alias: MDOT Project Number, length: 50 )
Not_To_ExceedCost ( type: esriFieldTypeDouble, alias: Not_To_ExceedCost )
OpenToTrafficDate ( type: esriFieldTypeDate, alias: OpenToTrafficDate, length: 8 )
FinalCompletionDate ( type: esriFieldTypeDate, alias: FinalCompletionDate, length: 8 )
RES_Date ( type: esriFieldTypeDate, alias: RES_Date, length: 8 )
SHAPE_Length ( type: esriFieldTypeDouble, alias: SHAPE_Length )

Supported Operations: Query Query Attachments Generate Renderer Return Updates

Iteminfo Thumbnail Metadata