{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 41, "name": "Projects 4+ years out", "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>

OBJECTID<\/SPAN><\/SPAN><\/P><\/TD>

System Generated Unique Identification <\/SPAN><\/SPAN>Number<\/SPAN><\/SPAN><\/P><\/TD>

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

SHAPE<\/SPAN><\/SPAN><\/P><\/TD>

ESRI geospatial data<\/SPAN><\/SPAN><\/P><\/TD>

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

Capital Project #<\/SPAN><\/SPAN><\/P><\/TD>

Number assigned to project when the capital project list is generated<\/SPAN><\/SPAN><\/P><\/TD>

LP59-23<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

GPF #<\/SPAN><\/SPAN><\/P><\/TD>

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

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

Project #<\/SPAN><\/SPAN><\/P><\/TD>

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

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

Project Name<\/SPAN><\/SPAN><\/P><\/TD>

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

Reconstruction of JACKSON STREET from Valley Avenue to Garfield Avenue<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Project Manager<\/SPAN><\/SPAN><\/P><\/TD>

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

Dan Siminski<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Project Type<\/SPAN><\/SPAN><\/P><\/TD>

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

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

Fiscal Year (Funded)<\/SPAN><\/SPAN><\/P><\/TD>

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

2019<\/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>

7/21/2018<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Construction Start Date<\/SPAN><\/SPAN><\/P><\/TD>

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

4/15/2019<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Estimated Construction Start Date<\/SPAN><\/SPAN><\/P><\/TD>

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

4/1/2019<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Substantial Completion<\/SPAN><\/SPAN><\/P><\/TD>

Date project is open to traffic. From Combined Spec Book or MDOT Proposal Book<\/SPAN><\/SPAN><\/P><\/TD>

6/25/2019<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Project Close Date<\/SPAN><\/SPAN><\/P><\/TD>

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

8/30/2019<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Created_Date<\/SPAN><\/SPAN><\/P><\/TD>

System generated date when GIS data was created<\/SPAN><\/SPAN><\/P><\/TD>

4/28/2018<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Edit_Date<\/SPAN><\/SPAN><\/P><\/TD>

System generated date when GIS data was edited<\/SPAN><\/SPAN><\/P><\/TD>

4/30/2018<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Capital Estimated Cost<\/SPAN><\/SPAN><\/P><\/TD>

Estimated cost approved by budget<\/SPAN><\/SPAN><\/P><\/TD>

$ 50,000.00<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Engineer Estimate<\/SPAN><\/SPAN><\/P><\/TD>

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

$ 54,000.00<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Actual Cost<\/SPAN><\/SPAN><\/P><\/TD>

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

$ 60,000.00<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Funding Source<\/SPAN><\/SPAN><\/P><\/TD>

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

Water System Fund= $30,510<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Created_By<\/SPAN><\/SPAN><\/P><\/TD>

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

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

Edit_By<\/SPAN><\/SPAN><\/P><\/TD>

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

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

SHAPE_Length<\/SPAN><\/SPAN><\/P><\/TD>

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

494.938451<\/SPAN><\/SPAN><\/P><\/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>

Year_Const<\/SPAN><\/SPAN><\/P><\/TD>

Year construction will take place<\/SPAN><\/SPAN><\/P><\/TD>

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

Proj_Status<\/SPAN><\/SPAN><\/P><\/TD>

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

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

Proj_Location<\/SPAN><\/SPAN><\/P><\/TD>

Project Limits<\/SPAN><\/SPAN><\/P><\/TD>

Jackson Street - Valley Avenue to Garfield Avenue<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Inspector<\/SPAN><\/SPAN><\/P><\/TD>

Engineering staff assigned to the inspection of the project.<\/SPAN><\/SPAN><\/P><\/TD>

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

Construction Project Manager<\/SPAN><\/SPAN><\/P><\/TD>

Engineering staff assigned to the project. From CEI award letter <\/SPAN><\/SPAN><\/P><\/TD>

John Broom<\/SPAN><\/SPAN><\/P><\/TD><\/TR>

Ward<\/SPAN><\/SPAN><\/P><\/TD>

City Ward where project is located at<\/SPAN><\/SPAN><\/P><\/TD>

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

Neighborhoods of Focus<\/SPAN><\/SPAN><\/P><\/TD>

Is project located at a Neighborhoods of Focus?<\/SPAN><\/SPAN><\/P><\/TD>

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

Has Green Infrastructure<\/SPAN><\/SPAN><\/P><\/TD>

Indicator to denote the installation of green infrastructure elements in a project<\/SPAN><\/SPAN><\/P><\/TD>

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

MDOT Project Number<\/SPAN><\/SPAN><\/P><\/TD>

Project number assigned by the Michigan Department of Transportation (MDOT)<\/SPAN><\/SPAN><\/P><\/TD>

216855<\/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>

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

OpenToTrafficDate<\/SPAN><\/SPAN><\/P><\/TD>

Date on which the street was opened for public use or traffic<\/SPAN><\/SPAN><\/P><\/TD>

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

FinalCompletionDate<\/SPAN><\/SPAN><\/P><\/TD>

Expected date when all project activities and deliverables are completed<\/SPAN><\/SPAN><\/P><\/TD>

mm/dd/yyyy<\/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><\/P><\/TD><\/TR><\/TBODY><\/TABLE><\/DIV><\/DIV><\/DIV>", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 2253, "latestWkid": 2253, "xyTolerance": 0.0032808398950131233, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -107138600, "falseY": -97193800, "xyUnits": 3048, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "City of Grand Rapids - Engineering Department", "parentLayer": { "id": 36, "name": "Vital Streets" }, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 0, 255 ], "width": 7 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 1.2753282000328073E7, "ymin": 495836.98425195395, "xmax": 1.2809286202099742E7, "ymax": 559766.5505249419, "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": 0.0032808398950131233, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.1313911151453365E8, "falseY": -1.0233955330890782E8, "xyUnits": 3.653674376263536E7, "falseZ": 0, "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": "Capital_Prj_No", "type": "esriFieldTypeString", "alias": "Capital Project #", "length": 25, "domain": null }, { "name": "GPF_No", "type": "esriFieldTypeString", "alias": "GPF #", "length": 15, "domain": null }, { "name": "Project_No", "type": "esriFieldTypeString", "alias": "Project #", "length": 15, "domain": null }, { "name": "Project_Name", "type": "esriFieldTypeString", "alias": "Project Name", "length": 100, "domain": null }, { "name": "Project_Manager", "type": "esriFieldTypeString", "alias": "Project Manager", "length": 50, "domain": null }, { "name": "Project_Type", "type": "esriFieldTypeString", "alias": "Project Type", "length": 100, "domain": { "type": "codedValue", "name": "WS1_engProjectType", "description": "Engineering Projects - Project Type", "codedValues": [ { "name": "Reconstruction", "code": "Recon" }, { "name": "Crack Seal", "code": "CrackSeal" }, { "name": "Asphalt Overlay", "code": "Asphalt Overlay" }, { "name": "Bike Lane", "code": "Bike Lane" }, { "name": "Bridge Maintenance", "code": "Bridge Maintenance" }, { "name": "Concrete / Brick Repair", "code": "Concrete / Brick Repair" }, { "name": "Rotomill / Resurface", "code": "Rotomill / Resurface" }, { "name": "Sealcoat", "code": "Sealcoat" }, { "name": "Sidewalk", "code": "Sidewalk" }, { "name": "Street Scape Improvement", "code": "Street Scape Improvement" }, { "name": "Street Lighting Improvement", "code": "Street Lighting Improvement" }, { "name": "Traffic Signal Improvement", "code": "Traffic Signal Improvement" }, { "name": "Feasibility Study", "code": "Feasibility Study" }, { "name": "Replacement of Private Lead Lines", "code": "Replacement of Private Lead Lines" }, { "name": "Replacement of Lead Service Lines", "code": "Replacement of Lead Service Lines" }, { "name": "Trench Repairs", "code": "Trench Repairs" }, { "name": "Repair Contract", "code": "Repair Contract" }, { "name": "Sidewalk Systematics", "code": "Sidewalk Systematics" }, { "name": "Footing Drain Disconnect", "code": "Footing Drain Disconnect" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Funding_Fiscal_Year", "type": "esriFieldTypeSmallInteger", "alias": "Fiscal Year (Funded)", "domain": null }, { "name": "Design_Start", "type": "esriFieldTypeDate", "alias": "Design_Start", "length": 8, "domain": null }, { "name": "Act_Const_Start", "type": "esriFieldTypeDate", "alias": "Construction Start Date", "length": 8, "domain": null }, { "name": "Est_Const_Start", "type": "esriFieldTypeDate", "alias": "Estimated Construction Start Date", "length": 8, "domain": null }, { "name": "Construction_End", "type": "esriFieldTypeDate", "alias": "Substantial Completion", "length": 8, "domain": null }, { "name": "Project_Close", "type": "esriFieldTypeDate", "alias": "Project Close Date", "length": 8, "domain": null }, { "name": "Created_Date", "type": "esriFieldTypeDate", "alias": "Created_Date", "length": 8, "domain": null }, { "name": "Edit_Date", "type": "esriFieldTypeDate", "alias": "Edit_Date", "length": 8, "domain": null }, { "name": "Capital_Est_Cost", "type": "esriFieldTypeDouble", "alias": "Capital Estimated Cost", "domain": null }, { "name": "Engineer_Est_Cost", "type": "esriFieldTypeDouble", "alias": "Engineer Estimate", "domain": null }, { "name": "Act_Cost", "type": "esriFieldTypeDouble", "alias": "Actual Cost", "domain": null }, { "name": "Funding_Source", "type": "esriFieldTypeString", "alias": "Funding_Source", "length": 500, "domain": null }, { "name": "Created_By", "type": "esriFieldTypeString", "alias": "Created_By", "length": 50, "domain": null }, { "name": "Edit_By", "type": "esriFieldTypeString", "alias": "Edit_By", "length": 50, "domain": null }, { "name": "Website_URL", "type": "esriFieldTypeString", "alias": "Website_URL", "length": 200, "domain": null }, { "name": "Year_Const", "type": "esriFieldTypeSmallInteger", "alias": "Year_Const", "domain": null }, { "name": "Proj_Status", "type": "esriFieldTypeString", "alias": "Proj_Status", "length": 50, "domain": { "type": "codedValue", "name": "WS1_ENG_ProjStatus", "description": "Applied to ENG_ProjStatus field in ENG_Projects lyr", "codedValues": [ { "name": "Projected", "code": "Projected" }, { "name": "Active - Design Phase", "code": "Active - Design Phase" }, { "name": "Active - Construction Phase", "code": "Active - Construction Phase" }, { "name": "Active - Project Closeout Phase", "code": "Active - Project Closeout Phase" }, { "name": "Completed", "code": "Completed" }, { "name": "Postponed", "code": "Postponed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Proj_Location", "type": "esriFieldTypeString", "alias": "Proj_Location", "length": 350, "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "Construction_Project_Manager", "type": "esriFieldTypeString", "alias": "Construction Project Manager", "length": 50, "domain": null }, { "name": "Ward", "type": "esriFieldTypeString", "alias": "Ward", "length": 50, "domain": null }, { "name": "Neighborhoods_of_Focus", "type": "esriFieldTypeString", "alias": "Neighborhoods of Focus", "length": 3, "domain": { "type": "codedValue", "name": "WS1_YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "Has_GI", "type": "esriFieldTypeString", "alias": "Has Green Infrastructure", "length": 3, "domain": { "type": "codedValue", "name": "WS1_YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MDOT_Project_No", "type": "esriFieldTypeString", "alias": "MDOT Project Number", "length": 50, "domain": null }, { "name": "Not_To_ExceedCost", "type": "esriFieldTypeDouble", "alias": "Not_To_ExceedCost", "domain": null }, { "name": "OpenToTrafficDate", "type": "esriFieldTypeDate", "alias": "OpenToTrafficDate", "length": 8, "domain": null }, { "name": "FinalCompletionDate", "type": "esriFieldTypeDate", "alias": "FinalCompletionDate", "length": 8, "domain": null }, { "name": "RES_Date", "type": "esriFieldTypeDate", "alias": "RES_Date", "length": 8, "domain": null }, { "name": "SHAPE_Length", "type": "esriFieldTypeDouble", "alias": "SHAPE_Length", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_SHAPE", "fields": "SHAPE", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "effectiveMinScale": 15000, "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 }