{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 11, "name": "Engineering Facilities Projects", "type": "Feature Layer", "description": "

Engineering Construction Data Dictionary<\/SPAN><\/SPAN><\/P><\/TD>

<\/TD><\/TR>

Attribute Title<\/SPAN><\/SPAN><\/P><\/TD>

Description<\/SPAN><\/SPAN><\/P><\/TD>

Example<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Requesting_Dep<\/SPAN><\/SPAN><\/P><\/TD>

City Department Requesting Engineering Services. From RES form.<\/SPAN><\/SPAN><\/P><\/TD>

ESD<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Project_Number<\/SPAN><\/SPAN><\/P><\/TD>

Engineering project number <- Means project has started design<\/SPAN><\/SPAN><\/P><\/TD>

447-23005<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

GPF_Number<\/SPAN><\/SPAN><\/P><\/TD>

State Road Identification Number. Located on As-Builts<\/SPAN><\/SPAN><\/P><\/TD>

GPF 5850<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Project_Name<\/SPAN><\/SPAN><\/P><\/TD>

Official name of the project. From project initiation form<\/SPAN><\/SPAN><\/P><\/TD>

Road Improvements at FAIRPLAINS, GREENWOOD and OAKHILL CEMETERIES<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Project_Type<\/SPAN><\/SPAN><\/P><\/TD>

Type of project being executed <\/SPAN><\/SPAN><\/P><\/TD>

Facilities/Parks<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Project_Manager<\/SPAN><\/SPAN><\/P><\/TD>

Engineering staff assigned to oversee the project. From project initiation form<\/SPAN><\/SPAN><\/P><\/TD>

Dustin Kuzee<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Project_Location<\/SPAN><\/SPAN><\/P><\/TD>

Location where the work is performed<\/SPAN><\/SPAN><\/P><\/TD>

726 MADISON AVE SE<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Project_Status<\/SPAN><\/SPAN><\/P><\/TD>

Status of project<\/SPAN><\/SPAN><\/P><\/TD>

Design<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Estimated_Cons_Start<\/SPAN><\/SPAN><\/P><\/TD>

Date project construction is anticipated to start. From Notice to proceed<\/SPAN><\/SPAN><\/P><\/TD>

5/15/2023<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Design_Start<\/SPAN><\/SPAN><\/P><\/TD>

Date engineering started design work. From Design Award letter or Project Detail Report for City designed projects<\/SPAN><\/SPAN><\/P><\/TD>

2/14/2022<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Cons_Start<\/SPAN><\/SPAN><\/P><\/TD>

Date project construction officially starts<\/SPAN><\/SPAN><\/P><\/TD>

8/14/2023<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

SubstantialCompletion<\/SPAN><\/SPAN><\/P><\/TD>

From combined spec book<\/SPAN><\/SPAN><\/P><\/TD>

12/1/2023<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Final_Completion<\/SPAN><\/SPAN><\/P><\/TD>

From combined spec book<\/SPAN><\/SPAN><\/P><\/TD>

6/10/2024<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Closeout_Date<\/SPAN><\/SPAN><\/P><\/TD>

Date project is closed in our system. From \u201cAdministration\u201dtab in MS Projects.<\/SPAN><\/SPAN><\/P><\/TD>

12/1/2025<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Eng_Estimate<\/SPAN><\/SPAN><\/P><\/TD>

Estimated cost generated at design phase. From Engineer\u2019s Estimate at the \u201cBid Documents\u201dfolder<\/SPAN><\/SPAN><\/P><\/TD>

$265,075<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Funding_Source<\/SPAN><\/SPAN><\/P><\/TD>

City funding codes. From Agenda item<\/SPAN><\/SPAN><\/P><\/TD>

Parks Millage Fund= $662,000<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Actual_Cost<\/SPAN><\/SPAN><\/P><\/TD>

Actual cost of the projects after closeout. From \u201cAdministration\u201dtab in MS Projects.<\/SPAN><\/SPAN><\/P><\/TD>

$358,282.50<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Fiscal_Year<\/SPAN><\/SPAN><\/P><\/TD>

Fiscal year that the capital project will be funded in. From Agenda item<\/SPAN><\/SPAN><\/P><\/TD>

2023<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Contractor<\/SPAN><\/SPAN><\/P><\/TD>

Approved contractor to perform the work<\/SPAN><\/SPAN><\/P><\/TD>

Wyoming Excavators<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

PrelimDesign_Consultant<\/SPAN><\/SPAN><\/P><\/TD>

Approved consultants for professional services<\/SPAN><\/SPAN><\/P><\/TD>

Tetra Tech of Michigan PC<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Design_Consultant<\/SPAN><\/SPAN><\/P><\/TD>

Approved consultants for professional services<\/SPAN><\/SPAN><\/P><\/TD>

Hubbell, Roth & Clark<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Geotechnical_Consultant<\/SPAN><\/SPAN><\/P><\/TD>

Approved consultants for professional services<\/SPAN><\/SPAN><\/P><\/TD>

SME<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

MaterialTesting_Consultant<\/SPAN><\/SPAN><\/P><\/TD>

Approved consultants for professional services<\/SPAN><\/SPAN><\/P><\/TD>

MTC<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

CEI_Consultant<\/SPAN><\/SPAN><\/P><\/TD>

Approved consultants for professional services<\/SPAN><\/SPAN><\/P><\/TD>

Fishbeck, Thompson, Carr & Huber<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

AsBuilts_Date<\/SPAN><\/SPAN><\/P><\/TD>

Date set of drawings describing what was built is available.<\/SPAN><\/SPAN><\/P><\/TD>

7/18/2024<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Notes<\/SPAN><\/SPAN><\/P><\/TD>

Space for other relevant project information<\/SPAN><\/SPAN><\/P><\/TD>

<\/TD><\/TR>

Website_URL<\/SPAN><\/SPAN><\/P><\/TD>

Address of project on the Web<\/SPAN><\/SPAN><\/P><\/TD>

https://www.grandrapidsmi.gov/Residents/Road-Construction/Jackson-Valley-to-Garfield-and-Lane-to-Jackson-Place<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Total_Budget<\/SPAN><\/SPAN><\/P><\/TD>

Estimated overall financial allocation. From the RES<\/SPAN><\/SPAN><\/P><\/TD>

500000<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Editor<\/SPAN><\/SPAN><\/P><\/TD>

Last GIS editor<\/SPAN><\/SPAN><\/P><\/TD>

mrojas<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Last_Edit<\/SPAN><\/SPAN><\/P><\/TD>

Last GIS edit date<\/SPAN><\/SPAN><\/P><\/TD>

mm/dd/yyyy<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Creator<\/SPAN><\/SPAN><\/P><\/TD>

GIS editor who created the asset in the data base<\/SPAN><\/SPAN><\/P><\/TD>

mrojas<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Create_Date<\/SPAN><\/SPAN><\/P><\/TD>

Date when GIS editor created the asset in the data base<\/SPAN><\/SPAN><\/P><\/TD>

mm/dd/yyyy<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Term_Contract<\/SPAN><\/SPAN><\/P><\/TD>

Indicator to remark if the project is a term contract<\/SPAN><\/SPAN><\/P><\/TD>

Yes<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Not_To_ExceedCost<\/SPAN><\/SPAN><\/P><\/TD>

Maximum allowable cost or budget limit for a project. From the Agenda item<\/SPAN><\/SPAN><\/P><\/TD>

473430<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

RES_Date<\/SPAN><\/SPAN><\/P><\/TD>

The date when engineering services request was received<\/SPAN><\/SPAN><\/P><\/TD>

mm/dd/yyyy<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

SHAPE.STArea()<\/SPAN><\/SPAN><\/P><\/TD>

Area of the polygon, generated by the GIS system<\/SPAN><\/SPAN><\/P><\/TD>

2489556.866897<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

SHAPE.STLength()<\/SPAN><\/SPAN><\/P><\/TD>

Length of the line in feet, generated by the GIS system<\/SPAN><\/SPAN><\/P><\/TD>

7317.123982<\/SPAN><\/SPAN><\/P><\/TD><\/TR><\/TBODY><\/TABLE><\/DIV><\/DIV><\/DIV>", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkt": "PROJCS[\"NAD_1983_StatePlane_Michigan_South_FIPS_2113_IntlFeet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Lambert_Conformal_Conic\"],PARAMETER[\"False_Easting\",13123359.58005249],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",-84.36666666666666],PARAMETER[\"Standard_Parallel_1\",42.1],PARAMETER[\"Standard_Parallel_2\",43.66666666666666],PARAMETER[\"Latitude_Of_Origin\",41.5],UNIT[\"Foot\",0.3048]]", "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 2, "falseX": -4.503599627370495E11, "falseY": -4.503599627370495E11, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "City of Grand Rapids - Engineering Department", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 0, 132, 168, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSNull", "color": [ 110, 110, 110, 255 ], "width": 0 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 1.2626700068481445E7, "ymin": 495832.9208984375, "xmax": 1.2805899834106445E7, "ymax": 564655.2503051758, "spatialReference": { "wkt": "PROJCS[\"NAD_1983_StatePlane_Michigan_South_FIPS_2113_IntlFeet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Lambert_Conformal_Conic\"],PARAMETER[\"False_Easting\",13123359.58005249],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",-84.36666666666666],PARAMETER[\"Standard_Parallel_1\",42.1],PARAMETER[\"Standard_Parallel_2\",43.66666666666666],PARAMETER[\"Latitude_Of_Origin\",41.5],UNIT[\"Foot\",0.3048]]", "xyTolerance": 6.561679790026247E-4, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -107138600, "falseY": -97193800, "xyUnits": 3048, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Project_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Project_Number", "type": "esriFieldTypeString", "alias": "Project_Number", "length": 50, "domain": null }, { "name": "GPF_Number", "type": "esriFieldTypeString", "alias": "GPF_Number", "length": 50, "domain": null }, { "name": "Project_Name", "type": "esriFieldTypeString", "alias": "Project_Name", "length": 500, "domain": null }, { "name": "Project_Type", "type": "esriFieldTypeString", "alias": "Project_Type", "length": 100, "domain": null }, { "name": "Project_Manager", "type": "esriFieldTypeString", "alias": "Project_Manager", "length": 50, "domain": null }, { "name": "Estimated_Cons_Start", "type": "esriFieldTypeString", "alias": "Estimated_Cons_Start", "length": 50, "domain": null }, { "name": "Cons_Start", "type": "esriFieldTypeString", "alias": "Cons_Start", "length": 50, "domain": null }, { "name": "Cons_End", "type": "esriFieldTypeString", "alias": "SubstantialCompletion", "length": 50, "domain": null }, { "name": "Closeout_Date", "type": "esriFieldTypeString", "alias": "Closeout_Date", "length": 50, "domain": null }, { "name": "Eng_Estimate", "type": "esriFieldTypeString", "alias": "Eng_Estimate", "length": 50, "domain": null }, { "name": "Actual_Cost", "type": "esriFieldTypeString", "alias": "Actual_Cost", "length": 50, "domain": null }, { "name": "Funding_Source", "type": "esriFieldTypeString", "alias": "Funding_Source", "length": 500, "domain": null }, { "name": "ConsEngInsp_Consultant", "type": "esriFieldTypeString", "alias": "ConsEngInsp_Consultant", "length": 100, "domain": null }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 50, "domain": null }, { "name": "Design_Consultant", "type": "esriFieldTypeString", "alias": "Consultant", "length": 50, "domain": null }, { "name": "Website_URL", "type": "esriFieldTypeString", "alias": "Website_URL", "length": 50, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 100, "domain": null }, { "name": "Project_Location", "type": "esriFieldTypeString", "alias": "Project_Location", "length": 150, "domain": null }, { "name": "Design_Start", "type": "esriFieldTypeString", "alias": "Design_Start", "length": 50, "domain": null }, { "name": "Project_Status", "type": "esriFieldTypeString", "alias": "Project_Status", "length": 50, "domain": null }, { "name": "Fiscal_Year", "type": "esriFieldTypeString", "alias": "Fiscal_Year", "length": 50, "domain": null }, { "name": "Geotechnical_Consultant", "type": "esriFieldTypeString", "alias": "Geotechnical_Consultant", "length": 100, "domain": null }, { "name": "PreliminaryDesign_Consultant", "type": "esriFieldTypeString", "alias": "PreliminaryDesign_Consultant", "length": 100, "domain": null }, { "name": "Final_Completion", "type": "esriFieldTypeDate", "alias": "Final_Completion", "length": 8, "domain": null }, { "name": "MaterialTesting_Consultant", "type": "esriFieldTypeString", "alias": "MaterialTesting_Consultant", "length": 100, "domain": null }, { "name": "AsBuilts_Date", "type": "esriFieldTypeDate", "alias": "AsBuilts_Date", "length": 8, "domain": null }, { "name": "RequestingDepartment", "type": "esriFieldTypeString", "alias": "RequestingDepartment", "length": 100, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "Total_Budget", "type": "esriFieldTypeDouble", "alias": "Total Budget", "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 25, "domain": null }, { "name": "Last_Edit", "type": "esriFieldTypeDate", "alias": "Last Edit", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 25, "domain": null }, { "name": "Create_Date", "type": "esriFieldTypeDate", "alias": "Create Date", "length": 8, "domain": null }, { "name": "Term_Contract", "type": "esriFieldTypeString", "alias": "Term_Contract", "length": 3, "domain": { "type": "codedValue", "name": "WS4_Yes_No", "description": "Simple Yes No Field", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Not_To_ExceedCost", "type": "esriFieldTypeDouble", "alias": "Not_To_ExceedCost", "domain": null }, { "name": "RES_Date", "type": "esriFieldTypeDate", "alias": "RES_Date", "length": 8, "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R836_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S576_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }