Layer: Engineering Facilities Projects (ID: 11)

Name: Engineering Facilities Projects

Display Field: Project_Name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

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>Requesting_Dep</TD><TD>City Department Requesting Engineering Services. From RES form.</TD><TD>ESD</TD></TR><TR><TD>Project_Number</TD><TD>Engineering project number <- Means project has started design</TD><TD>447-23005</TD></TR><TR><TD>GPF_Number</TD><TD>State Road Identification Number. Located on As-Builts</TD><TD>GPF 5850</TD></TR><TR><TD>Project_Name</TD><TD>Official name of the project. From project initiation form</TD><TD>Road Improvements at FAIRPLAINS, GREENWOOD and OAKHILL CEMETERIES</TD></TR><TR><TD>Project_Type</TD><TD>Type of project being executed </TD><TD>Facilities/Parks</TD></TR><TR><TD>Project_Manager</TD><TD>Engineering staff assigned to oversee the project. From project initiation form</TD><TD>Dustin Kuzee</TD></TR><TR><TD>Project_Location</TD><TD>Location where the work is performed</TD><TD>726 MADISON AVE SE</TD></TR><TR><TD>Project_Status</TD><TD>Status of project</TD><TD>Design</TD></TR><TR><TD>Estimated_Cons_Start</TD><TD>Date project construction is anticipated to start. From Notice to proceed</TD><TD>5/15/2023</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>2/14/2022</TD></TR><TR><TD>Cons_Start</TD><TD>Date project construction officially starts</TD><TD>8/14/2023</TD></TR><TR><TD>SubstantialCompletion</TD><TD>From combined spec book</TD><TD>12/1/2023</TD></TR><TR><TD>Final_Completion</TD><TD>From combined spec book</TD><TD>6/10/2024</TD></TR><TR><TD>Closeout_Date</TD><TD>Date project is closed in our system. From “Administration”tab in MS Projects.</TD><TD>12/1/2025</TD></TR><TR><TD>Eng_Estimate</TD><TD>Estimated cost generated at design phase. From Engineer’s Estimate at the “Bid Documents”folder</TD><TD>$265,075</TD></TR><TR><TD>Funding_Source</TD><TD>City funding codes. From Agenda item</TD><TD>Parks Millage Fund= $662,000</TD></TR><TR><TD>Actual_Cost</TD><TD>Actual cost of the projects after closeout. From “Administration”tab in MS Projects.</TD><TD>$358,282.50</TD></TR><TR><TD>Fiscal_Year</TD><TD>Fiscal year that the capital project will be funded in. From Agenda item</TD><TD>2023</TD></TR><TR><TD>Contractor</TD><TD>Approved contractor to perform the work</TD><TD>Wyoming Excavators</TD></TR><TR><TD>PrelimDesign_Consultant</TD><TD>Approved consultants for professional services</TD><TD>Tetra Tech of Michigan PC</TD></TR><TR><TD>Design_Consultant</TD><TD>Approved consultants for professional services</TD><TD>Hubbell, Roth & Clark</TD></TR><TR><TD>Geotechnical_Consultant</TD><TD>Approved consultants for professional services</TD><TD>SME</TD></TR><TR><TD>MaterialTesting_Consultant</TD><TD>Approved consultants for professional services</TD><TD>MTC</TD></TR><TR><TD>CEI_Consultant</TD><TD>Approved consultants for professional services</TD><TD>Fishbeck, Thompson, Carr & Huber</TD></TR><TR><TD>AsBuilts_Date</TD><TD>Date set of drawings describing what was built is available.</TD><TD>7/18/2024</TD></TR><TR><TD>Notes</TD><TD>Space for other relevant project information</TD><TD></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>Total_Budget</TD><TD>Estimated overall financial allocation. From the RES</TD><TD>500000</TD></TR><TR><TD>Editor</TD><TD>Last GIS editor</TD><TD>mrojas</TD></TR><TR><TD>Last_Edit</TD><TD>Last GIS edit date</TD><TD>mm/dd/yyyy</TD></TR><TR><TD>Creator</TD><TD>GIS editor who created the asset in the data base</TD><TD>mrojas</TD></TR><TR><TD>Create_Date</TD><TD>Date when GIS editor created the asset in the data base</TD><TD>mm/dd/yyyy</TD></TR><TR><TD>Term_Contract</TD><TD>Indicator to remark if the project is a term contract</TD><TD>Yes</TD></TR><TR><TD>Not_To_ExceedCost</TD><TD>Maximum allowable cost or budget limit for a project. From the Agenda item</TD><TD>473430</TD></TR><TR><TD>RES_Date</TD><TD>The date when engineering services request was received</TD><TD>mm/dd/yyyy</TD></TR><TR><TD>SHAPE.STArea()</TD><TD>Area of the polygon, generated by the GIS system</TD><TD>2489556.866897</TD></TR><TR><TD>SHAPE.STLength()</TD><TD>Length of the line in feet, generated by the GIS system</TD><TD>7317.123982</TD></TR></TBODY></TABLE></DIV></DIV></DIV>

Copyright Text: City of Grand Rapids - Engineering Department

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

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:

Outline:

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 )
Project_Number ( type: esriFieldTypeString, alias: Project_Number, length: 50 )
GPF_Number ( type: esriFieldTypeString, alias: GPF_Number, length: 50 )
Project_Name ( type: esriFieldTypeString, alias: Project_Name, length: 500 )
Project_Type ( type: esriFieldTypeString, alias: Project_Type, length: 100 )
Project_Manager ( type: esriFieldTypeString, alias: Project_Manager, length: 50 )
Estimated_Cons_Start ( type: esriFieldTypeString, alias: Estimated_Cons_Start, length: 50 )
Cons_Start ( type: esriFieldTypeString, alias: Cons_Start, length: 50 )
Cons_End ( type: esriFieldTypeString, alias: SubstantialCompletion, length: 50 )
Closeout_Date ( type: esriFieldTypeString, alias: Closeout_Date, length: 50 )
Eng_Estimate ( type: esriFieldTypeString, alias: Eng_Estimate, length: 50 )
Actual_Cost ( type: esriFieldTypeString, alias: Actual_Cost, length: 50 )
Funding_Source ( type: esriFieldTypeString, alias: Funding_Source, length: 500 )
ConsEngInsp_Consultant ( type: esriFieldTypeString, alias: ConsEngInsp_Consultant, length: 100 )
Contractor ( type: esriFieldTypeString, alias: Contractor, length: 50 )
Design_Consultant ( type: esriFieldTypeString, alias: Consultant, length: 50 )
Website_URL ( type: esriFieldTypeString, alias: Website_URL, length: 50 )
Notes ( type: esriFieldTypeString, alias: Notes, length: 100 )
Project_Location ( type: esriFieldTypeString, alias: Project_Location, length: 150 )
Design_Start ( type: esriFieldTypeString, alias: Design_Start, length: 50 )
Project_Status ( type: esriFieldTypeString, alias: Project_Status, length: 50 )
Fiscal_Year ( type: esriFieldTypeString, alias: Fiscal_Year, length: 50 )
Geotechnical_Consultant ( type: esriFieldTypeString, alias: Geotechnical_Consultant, length: 100 )
PreliminaryDesign_Consultant ( type: esriFieldTypeString, alias: PreliminaryDesign_Consultant, length: 100 )
Final_Completion ( type: esriFieldTypeDate, alias: Final_Completion, length: 8 )
MaterialTesting_Consultant ( type: esriFieldTypeString, alias: MaterialTesting_Consultant, length: 100 )
AsBuilts_Date ( type: esriFieldTypeDate, alias: AsBuilts_Date, length: 8 )
RequestingDepartment ( type: esriFieldTypeString, alias: RequestingDepartment, length: 100 )
SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
Total_Budget ( type: esriFieldTypeDouble, alias: Total Budget )
Editor ( type: esriFieldTypeString, alias: Editor, length: 25 )
Last_Edit ( type: esriFieldTypeDate, alias: Last Edit, length: 8 )
Creator ( type: esriFieldTypeString, alias: Creator, length: 25 )
Create_Date ( type: esriFieldTypeDate, alias: Create Date, length: 8 )
Term_Contract ( type: esriFieldTypeString, alias: Term_Contract, length: 3 , Coded Values: [Y: Yes] , [N: No] )
Not_To_ExceedCost ( type: esriFieldTypeDouble, alias: Not_To_ExceedCost )
RES_Date ( type: esriFieldTypeDate, alias: RES_Date, length: 8 )
SHAPE.STArea() ( type: esriFieldTypeDouble, alias: SHAPE.STArea() )
SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Supported Operations: Query Query Attachments Generate Renderer Return Updates

Iteminfo Thumbnail Metadata