View In:   ArcGIS Online Map Viewer

Name: PublicWorksProjects

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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: 2462248.0139868557
YMin: 6807914.317710891
XMax: 2493304.631536752
YMax: 6868105.417094529
Spatial Reference: 102738  (2276)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: AC
  Label: Active Construction
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 2
• Value: C
  Label: Completed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 2
• Value: DP
  Label: Design Phase
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 115, 255]
  Width: 2
• Value: FP
  Label: Future Projects
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 169, 255]
  Width: 2
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Status

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Id ( type: esriFieldTypeInteger, alias: Id, editable: true, nullable: true, defaultValue: null, modelName: Id )
• ProjectName ( type: esriFieldTypeString, alias: ProjectName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectName )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [C: Completed] , [AC: Active Construction] , [DP: Design Phase] , ...1 more... )
• FundingSource ( type: esriFieldTypeString, alias: Funding Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FundingSource , Coded Values: [GF: General Fund] , [BF: Bond Fund] , [B: Bond] , ...1 more... )
• ProjectStartDate ( type: esriFieldTypeString, alias: Project Start Date, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ProjectStartDate )
• ContractDays ( type: esriFieldTypeString, alias: Contract Days, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ContractDays )
• CompletionDate ( type: esriFieldTypeString, alias: Completion Date, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CompletionDate )
• ContractAmount ( type: esriFieldTypeString, alias: Contract Amount, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ContractAmount )
• OnSchedule ( type: esriFieldTypeString, alias: On Schedule, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OnSchedule , Coded Values: [Yes: Yes] , [No: No] )
• ChangeOrders ( type: esriFieldTypeString, alias: Change Orders, editable: true, nullable: true, length: 200, defaultValue: null, modelName: ChangeOrders )
• Amendments ( type: esriFieldTypeString, alias: Amendments, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Amendments )
• Scope ( type: esriFieldTypeString, alias: Scope, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ScopeofProject )
• CurrentStatus ( type: esriFieldTypeString, alias: CurrentStatus, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CurrentStatus )
• UpcomingItems ( type: esriFieldTypeString, alias: Upcoming Items, editable: true, nullable: true, length: 100, defaultValue: null, modelName: UpcomingItems )
• Designer ( type: esriFieldTypeString, alias: Designer, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DesignerEngineerContractor )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectType , Coded Values: [Rehabilitation: Rehabilitation] , [Restoration: Restoration] , [Reconstruction: Reconstruction] )
• Engineer ( type: esriFieldTypeString, alias: Engineer, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Engineer )
• Contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Contractor )
• ProjectNum ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNum )
• Year ( type: esriFieldTypeString, alias: Year, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Year )
• LinearFoot ( type: esriFieldTypeDouble, alias: LinearFoot, editable: true, nullable: true, defaultValue: null, modelName: LinearFoot )
• ProjectType ( type: esriFieldTypeString, alias: ProjectType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectType , Coded Values: [CIP: CIP] , [AR: Asphalt Street Rehabilitation] , [SP: Sidewalk Program] , ...1 more... )
• EngineeringEstimatedCost ( type: esriFieldTypeDouble, alias: Engineering Estimated Cost, editable: true, nullable: true, defaultValue: null, modelName: EngineeringEstimatedCost )
• EngineeringActualCost ( type: esriFieldTypeDouble, alias: Engineering Actual Cost, editable: true, nullable: true, defaultValue: null, modelName: EngineeringActualCost )
• Year_Engineering ( type: esriFieldTypeSmallInteger, alias: Year_Engineering, editable: true, nullable: true, defaultValue: null, modelName: Year_Engineering )
• ConstructionEstimatedCost ( type: esriFieldTypeDouble, alias: Construction Estimated Cost, editable: true, nullable: true, defaultValue: null, modelName: ConstructionEstimatedCost )
• ConstructionActualCost ( type: esriFieldTypeDouble, alias: Construction Actual Cost, editable: true, nullable: true, defaultValue: null, modelName: ConstructionActualCost )
• Year_Construction ( type: esriFieldTypeSmallInteger, alias: Year_Construction, editable: true, nullable: true, defaultValue: null, modelName: Year_Construction )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
• TotalEstimatedCost ( type: esriFieldTypeDouble, alias: TotalEstimatedCost, editable: true, nullable: true, defaultValue: null, modelName: TotalEstimatedCost )

Types:

ID: AC
Name: Active Construction
Domains:
• Status:
  Inherited
• FundingSource:
  Inherited
• OnSchedule:
  Inherited
• Type:
  Inherited
• ProjectType:
  Inherited
Templates:
• Name: AC
  Description:
  Prototype:
  Year_Construction: null
  TotalEstimatedCost: null
  Id: null
  ProjectName: null
  Status: AC
  FundingSource: null
  ProjectStartDate: null
  ContractDays: null
  CompletionDate: null
  ContractAmount: null
  OnSchedule: null
  ChangeOrders: null
  Amendments: null
  Scope: null
  CurrentStatus: null
  UpcomingItems: null
  Designer: null
  Type: null
  Engineer: null
  Contractor: null
  ProjectNum: null
  Year: null
  LinearFoot: null
  ProjectType: null
  EngineeringEstimatedCost: null
  EngineeringActualCost: null
  Year_Engineering: null
  ConstructionEstimatedCost: null
  ConstructionActualCost: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: C
Name: Completed
Domains:
• Status:
  Inherited
• FundingSource:
  Inherited
• OnSchedule:
  Inherited
• Type:
  Inherited
• ProjectType:
  Inherited
Templates:
• Name: C
  Description:
  Prototype:
  Year_Construction: null
  TotalEstimatedCost: null
  Id: null
  ProjectName: null
  Status: C
  FundingSource: null
  ProjectStartDate: null
  ContractDays: null
  CompletionDate: null
  ContractAmount: null
  OnSchedule: null
  ChangeOrders: null
  Amendments: null
  Scope: null
  CurrentStatus: null
  UpcomingItems: null
  Designer: null
  Type: null
  Engineer: null
  Contractor: null
  ProjectNum: null
  Year: null
  LinearFoot: null
  ProjectType: null
  EngineeringEstimatedCost: null
  EngineeringActualCost: null
  Year_Engineering: null
  ConstructionEstimatedCost: null
  ConstructionActualCost: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: DP
Name: Design Phase
Domains:
• Status:
  Inherited
• FundingSource:
  Inherited
• OnSchedule:
  Inherited
• Type:
  Inherited
• ProjectType:
  Inherited
Templates:
• Name: DP
  Description:
  Prototype:
  Year_Construction: null
  TotalEstimatedCost: null
  Id: null
  ProjectName: null
  Status: DP
  FundingSource: null
  ProjectStartDate: null
  ContractDays: null
  CompletionDate: null
  ContractAmount: null
  OnSchedule: null
  ChangeOrders: null
  Amendments: null
  Scope: null
  CurrentStatus: null
  UpcomingItems: null
  Designer: null
  Type: null
  Engineer: null
  Contractor: null
  ProjectNum: null
  Year: null
  LinearFoot: null
  ProjectType: null
  EngineeringEstimatedCost: null
  EngineeringActualCost: null
  Year_Engineering: null
  ConstructionEstimatedCost: null
  ConstructionActualCost: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: FP
Name: Future Projects
Domains:
• Status:
  Inherited
• FundingSource:
  Inherited
• OnSchedule:
  Inherited
• Type:
  Inherited
• ProjectType:
  Inherited
Templates:
• Name: FP
  Description:
  Prototype:
  Year_Construction: null
  TotalEstimatedCost: null
  Id: null
  ProjectName: null
  Status: FP
  FundingSource: null
  ProjectStartDate: null
  ContractDays: null
  CompletionDate: null
  ContractAmount: null
  OnSchedule: null
  ChangeOrders: null
  Amendments: null
  Scope: null
  CurrentStatus: null
  UpcomingItems: null
  Designer: null
  Type: null
  Engineer: null
  Contractor: null
  ProjectNum: null
  Year: null
  LinearFoot: null
  ProjectType: null
  EngineeringEstimatedCost: null
  EngineeringActualCost: null
  Year_Engineering: null
  ConstructionEstimatedCost: null
  ConstructionActualCost: 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

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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