Name: Engineering Capital Projects
Display Field: FileNum
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: <DIV STYLE="text-align:Left;"><DIV><DIV><TABLE><TBODY><TR><TD><P STYLE="text-align:Center;"><SPAN><SPAN>Engineering Construction Data Dictionary</SPAN></SPAN></P></TD><TD><P /></TD></TR><TR><TD><P STYLE="text-align:Center;font-weight:bold;"><SPAN><SPAN>Attribute Title</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;font-weight:bold;"><SPAN><SPAN>Description</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;font-weight:bold;"><SPAN><SPAN>Example</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>OBJECTID</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>System Generated Unique Identification </SPAN></SPAN><SPAN><SPAN>Number</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>209</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>FileNum</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Number assigned to project when the capital project list is generated</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>LP59-23</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>GlobalID</SPAN></SPAN></P></TD><TD><P><SPAN>Field used to confirm project was review during updates. Editor initials + OBJECTID</SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>MR209</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>CreationDa</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>System generated date when GIS data was created</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>3/2/2023</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>Creator</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>GIS editor who created the asset in the database</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>mrojas</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>EditDate</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>System generated date when GIS data was edited</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>3/2/2023</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>Editor</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>GIS editor who </SPAN></SPAN><SPAN><SPAN>modified the asset in the data base</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>mrojas</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>Location</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Project Limits</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>Robinson Road - Lake Drive to Plymouth Avenue</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>Contact</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Engineering staff assigned to </SPAN></SPAN><SPAN><SPAN>Capital Planning</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>Cindy Irving</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>Req_Amt</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Estimated cost approved by budget</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>52512</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>Citywide_F</SPAN></SPAN></P></TD><TD><P /></TD><TD><P /></TD></TR><TR><TD><P><SPAN><SPAN>Department</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Requesting Department</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>Engineering</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>Smart_Zone</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Is project located at a Smart Zone?</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>N</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>EWHO</SPAN></SPAN></P></TD><TD><P><SPAN>Field is being used to track treatment type</SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN>Reconstruction</SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>EWHEN</SPAN></SPAN></P></TD><TD><P><SPAN>Field is being used to track the construction Start date from Roadsoft</SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>7/1/2022</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>Project_Na</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Capital Project Name</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>Robinson Road - Lake Drive to Plymouth Avenue</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>NOF</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Is project located at a Neighborhoods of Focus? </SPAN></SPAN></P><P><SPAN><SPAN>1 -Yes / 0 - No</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>0</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>Ward</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>City Ward where project is located at</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>2</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>FY</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Fiscal year </SPAN></SPAN><SPAN><SPAN>when the capital project will be funded in</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>2023</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>CostPerFt</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Total cost per ft</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>51.635143</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>Length</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Length of the line in feet</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>494.938451</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>SHAPE_Length</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Length of the line in feet, generated by the GIS system</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;"><SPAN><SPAN>494.938451</SPAN></SPAN></P></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:
XMin: 1.273158094952178E7
YMin: 506778.2206310624
XMax: 1.2821843338349672E7
YMax: 559827.2380021093
Spatial Reference: 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]]
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Project_Type
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol: Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 3
Default Label:
UniqueValueInfos:
-
Value: Asphalt Overlay
Label: Asphalt Overlay
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [57, 160, 163, 255]
Width: 3
-
Value: Bike Lane
Label: Bike Lane
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [171, 36, 40, 255]
Width: 3
-
Value: Bridge Maintenance
Label: Bridge Maintenance
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [122, 35, 168, 255]
Width: 3
-
Value: Concrete / Brick Repair
Label: Concrete / Brick Repair
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [168, 168, 40, 255]
Width: 3
-
Value: CrackSeal
Label: Crack Seal
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [128, 64, 98, 255]
Width: 3
-
Value: Feasibility Study
Label: Feasibility Study
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [41, 163, 86, 255]
Width: 3
-
Value: Footing Drain Disconnect
Label: Footing Drain Disconnect
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [31, 72, 143, 255]
Width: 3
-
Value: Other
Label: Other
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [156, 111, 75, 255]
Width: 3
-
Value: Recon
Label: Reconstruction
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [80, 124, 166, 255]
Width: 3
-
Value: Repair Contract
Label: Repair Contract
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [110, 135, 55, 255]
Width: 3
-
Value: Replacement of Lead Service Lines
Label: Replacement of Lead Service Lines
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [153, 64, 152, 255]
Width: 3
-
Value: Replacement of Private Lead Lines
Label: Replacement of Private Lead Lines
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [176, 60, 87, 255]
Width: 3
-
Value: Rotomill / Resurface
Label: Rotomill / Resurface
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [33, 38, 133, 255]
Width: 3
-
Value: Sealcoat
Label: Sealcoat
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [50, 133, 100, 255]
Width: 3
-
Value: Sidewalk
Label: Sidewalk
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [107, 77, 171, 255]
Width: 3
-
Value: Sidewalk Systematics
Label: Sidewalk Systematics
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [176, 123, 39, 255]
Width: 3
-
Value: Street Lighting Improvement
Label: Street Lighting Improvement
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [69, 161, 43, 255]
Width: 3
-
Value: Street Scape Improvement
Label: Street Scape Improvement
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [143, 71, 57, 255]
Width: 3
-
Value: Traffic Signal Improvement
Label: Traffic Signal Improvement
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [171, 161, 85, 255]
Width: 3
-
Value: Trench Repairs
Label: Trench Repairs
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [161, 80, 37, 255]
Width: 3
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
HasZ: false
HasM: true
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
FileNum
(
type: esriFieldTypeString, alias: FileNum, length: 20
)
-
GlobalID
(
type: esriFieldTypeString, alias: GlobalID, length: 38
)
-
CreationDa
(
type: esriFieldTypeDate, alias: CreationDa, length: 8
)
-
Creator
(
type: esriFieldTypeString, alias: Creator, length: 128
)
-
EditDate
(
type: esriFieldTypeDate, alias: EditDate, length: 8
)
-
Editor
(
type: esriFieldTypeString, alias: Editor, length: 128
)
-
Location
(
type: esriFieldTypeString, alias: Location, length: 254
)
-
Contact
(
type: esriFieldTypeString, alias: Contact, length: 254
)
-
Req_Amt
(
type: esriFieldTypeDouble, alias: Req_Amt
)
-
Citywide_F
(
type: esriFieldTypeString, alias: Citywide_F, length: 254
)
-
Department
(
type: esriFieldTypeString, alias: Department, length: 254
)
-
Smart_Zone
(
type: esriFieldTypeString, alias: Smart_Zone, length: 254
)
-
EWHO
(
type: esriFieldTypeString, alias: EWHO, length: 254
)
-
EWHEN
(
type: esriFieldTypeDate, alias: EWHEN, length: 8
)
-
Project_Na
(
type: esriFieldTypeString, alias: Project_Na, length: 254
)
-
NOF
(
type: esriFieldTypeInteger, alias: NOF
)
-
Ward
(
type: esriFieldTypeInteger, alias: Ward
)
-
FY
(
type: esriFieldTypeInteger, alias: FY
)
-
CostPerFt
(
type: esriFieldTypeDouble, alias: CostPerFt
)
-
Length
(
type: esriFieldTypeDouble, alias: Length
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
-
Shape.STLength()
(
type: esriFieldTypeDouble, alias: Shape.STLength()
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata