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: true
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: EWHO
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:
Label:
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [87, 145, 32, 255]
Width: 3
-
Value: Mill & Overlay - 1.5'' - COGR
Label: Mill & Overlay - 1.5'' - COGR
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [135, 56, 171, 255]
Width: 3
-
Value:
Label:
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [158, 33, 33, 255]
Width: 3
-
Value: Bridge Work
Label: Bridge Work
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [73, 135, 158, 255]
Width: 3
-
Value: Mill & Overlay - 1.5 - COGR
Label: Mill & Overlay - 1.5 - COGR
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [156, 51, 96, 255]
Width: 3
-
Value: Mill & Overlay - 1.5'' - COGR
Label: Mill & Overlay - 1.5'' - COGR
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [156, 122, 72, 255]
Width: 3
-
Value: Mill & Overlay - 3" Thick - COGR
Label: Mill & Overlay - 3" Thick - COGR
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [60, 86, 163, 255]
Width: 3
-
Value: Reconstruction
Label: Reconstruction
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [54, 158, 108, 255]
Width: 3
-
Value: Reconstruction - COGR
Label: Reconstruction - COGR
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [173, 173, 47, 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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: 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
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata