View In:   ArcGIS Online Map Viewer

Name: Engineering Street 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: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1.275270277591863E7
YMin: 495830.9540682346
XMax: 1.2821122633202108E7
YMax: 560484.7050524956
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:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 168, 132, 255]
Width: 2
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: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

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

Templates:

• Name: Engineering Street Projects
  Description:
  Prototype:
  FinalCompletionDate: null
  RES_Date: null
  Capital_Prj_No: null
  GPF_No: null
  Project_No: null
  Project_Name: null
  Project_Manager: null
  Project_Type: null
  Funding_Fiscal_Year: null
  Design_Start: null
  Act_Const_Start: null
  Est_Const_Start: null
  Construction_End: null
  Project_Close: null
  Not_To_ExceedCost: null
  MDOT_Project_No: null
  Capital_Est_Cost: null
  Engineer_Est_Cost: null
  Act_Cost: null
  Funding_Source: null
  Has_GI: null
  Neighborhoods_of_Focus: null
  Website_URL: null
  Year_Const: null
  Proj_Status: null
  Proj_Location: null
  OpenToTrafficDate: null
  Inspector: null
  Construction_Project_Manager: null
  Ward: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: Created_Date
• Creator Field: Created_By
• Edit Date Field: Edit_Date
• Editor Field: Edit_By

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata