Parent Layer: Engineering Projects

Name: Current Projects

Display Field: Project_Name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Engineering Construction Data DictionaryAttribute TitleDescriptionExampleOBJECTIDSystem Generated Unique Identification 486SHAPEESRI geospatial dataPolylineCapitlal Project #number assigned to project when the caplital project list is generatedLP59-23GPF #State Road Identification Number17598Project #Engineering project number <- Means project has started design447-18001Project NameOfficial name of the projectRosewood Avenue - Boston Street to N. EndProject ManagerEngineering staff assigned to the projectjhayesProject TypeType of project being completed Crack SealFiscal Year (Funded)Fiscal year that the capital project will be funded in2019Design_StartDate engineering started design wotk7/21/2018Construction Start DateDate project construction officially starts4/15/2019Estimated Construction Start DateDate project construction is anticpiated to start (populated at start of design)4/1/2019Construction End DateDate project is open to traffic6/25/2019Project Close DateDate project is closed in our system8/30/2019Created_DateDate GIS data was generated4/28/2018Edit_DateDate last edit was performed4/30/2018Capital Estimated CostEstimated cost approved by budget$ 50,000.00 Engineer EstimateEstimated cost generated a design phase$ 54,000.00 Actual CostActual cost of the projects$ 60,000.00 Funding SourceCity funding codes SSTF, Vital StreetsCreated_ByGIS editor who created the asset in the data basejoevermanEdit_ByLast GIS editorjoevermanSHAPE_LengthLength of the line in feet, generated by the GIS system494.938451

Copyright Text: City of Grand Rapids - Engineering

Default Visibility: true

MaxRecordCount: 1000

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.2752702775918633E7
YMin: 495830.9540682435
XMax: 1.2821122633202106E7
YMax: 560484.705052495
Spatial Reference: 2253  (2253)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [38, 115, 0, 255]
Width: 7
Label: N/A
Description: N/A
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: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Capital_Prj_No ( type: esriFieldTypeString, alias: Capitlal Project #, length: 25 )
• GPF_No ( type: esriFieldTypeString, alias: GPF #, length: 15 )
• Project_No ( type: esriFieldTypeString, alias: Project #, length: 15 )
• Project_Name ( type: esriFieldTypeString, alias: Project Name, length: 100 )
• Project_Manager ( type: esriFieldTypeString, alias: Project Manager, length: 50 )
• Project_Type ( type: esriFieldTypeString, alias: Project Type, length: 100 , Coded Values: [Recon: Reconstruction] , [CrackSeal: Crack Seal] , [Asphalt Overlay: Asphalt Overlay] , ...17 more... )
• Funding_Fiscal_Year ( type: esriFieldTypeSmallInteger, alias: Fiscal Year (Funded) )
• Design_Start ( type: esriFieldTypeDate, alias: Design_Start, length: 8 )
• Act_Const_Start ( type: esriFieldTypeDate, alias: Construction Start Date, length: 8 )
• Est_Const_Start ( type: esriFieldTypeDate, alias: Estimated Construction Start Date, length: 8 )
• Construction_End ( type: esriFieldTypeDate, alias: Construction End Date, length: 8 )
• Project_Close ( type: esriFieldTypeDate, alias: Project Close Date, length: 8 )
• Created_Date ( type: esriFieldTypeDate, alias: Created_Date, length: 8 )
• Edit_Date ( type: esriFieldTypeDate, alias: Edit_Date, length: 8 )
• Capital_Est_Cost ( type: esriFieldTypeDouble, alias: Capital Estimated Cost )
• Engineer_Est_Cost ( type: esriFieldTypeDouble, alias: Engineer Estimate )
• Act_Cost ( type: esriFieldTypeDouble, alias: Actual Cost )
• Funding_Source ( type: esriFieldTypeString, alias: Funding_Source, length: 500 )
• Created_By ( type: esriFieldTypeString, alias: Created_By, length: 50 )
• Edit_By ( type: esriFieldTypeString, alias: Edit_By, length: 50 )
• Website_URL ( type: esriFieldTypeString, alias: Website_URL, length: 200 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• Year_Const ( type: esriFieldTypeSmallInteger, alias: Year_Const )
• Proj_Status ( type: esriFieldTypeString, alias: Proj_Status, length: 50 , Coded Values: [Projected: Projected] , [Active - Design Phase: Active - Design Phase] , [Active - Construction Phase: Active - Construction Phase] , ...3 more... )
• Proj_Location ( type: esriFieldTypeString, alias: Proj_Location, length: 350 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• Construction_Project_Manager ( type: esriFieldTypeString, alias: Construction Project Manager, length: 50 )
• Ward ( type: esriFieldTypeString, alias: Ward, length: 50 )
• Neighborhoods_of_Focus ( type: esriFieldTypeString, alias: Neighborhoods of Focus, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Has_GI ( type: esriFieldTypeString, alias: Has Green Infrastructure, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• MDOT_Project_No ( type: esriFieldTypeString, alias: MDOT Project Number, length: 50 )
• Not_To_ExceedCost ( type: esriFieldTypeDouble, alias: Not_To_ExceedCost )
• OpenToTrafficDate ( type: esriFieldTypeDate, alias: OpenToTrafficDate, length: 8 )
• FinalCompletionDate ( type: esriFieldTypeDate, alias: FinalCompletionDate, length: 8 )
• RES_Date ( type: esriFieldTypeDate, alias: RES_Date, length: 8 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata