View In:   ArcGIS Online Map Viewer

Name: Streetlight Maintenance Tasks

Display Field: Activity

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 6dd5cb231d6743a1b473b8e55f14d09c

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 4622324.434309

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: 3659863.0434262156
YMin: 511176.6936417222
XMax: 3784990.957211882
YMax: 606390.3342508078
Spatial Reference: 102682  (3452)

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: Planned
  Label: Planned
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 115, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [169, 0, 230, 255] Width: 0
• Value: In Progress
  Label: In Progress
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 168, 132, 255] Width: 0
• Value: Completed
  Label: Completed
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [230, 152, 0, 255] Width: 0
• Value: Canceled
  Label: Canceled
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [204, 204, 204, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 0, 0, 255] Width: 0
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

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 )
• Activity ( type: esriFieldTypeString, alias: Activity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Activity )
• ActualStopDate ( type: esriFieldTypeDate, alias: ActualStopDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ActualStopDate )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status )
• BlockNumber ( type: esriFieldTypeString, alias: BlockNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BlockNumber )
• CompletionNotes ( type: esriFieldTypeString, alias: CompletionNotes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CompletionNotes )
• ContractorsNotes ( type: esriFieldTypeString, alias: ContractorsNotes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ContractorsNotes )
• CouncilDistrict ( type: esriFieldTypeString, alias: CouncilDistrict, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CouncilDistrict )
• Department ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Department )
• EquipmentCost ( type: esriFieldTypeDouble, alias: EquipmentCost, editable: true, nullable: true, defaultValue: null, modelName: EquipmentCost )
• InvestigationNeeded ( type: esriFieldTypeSmallInteger, alias: InvestigationNeeded, editable: true, nullable: true, defaultValue: null, modelName: InvestigationNeeded )
• Inaccessible ( type: esriFieldTypeSmallInteger, alias: Inaccessible, editable: true, nullable: true, defaultValue: null, modelName: Inaccessible )
• LaborCost ( type: esriFieldTypeDouble, alias: LaborCost, editable: true, nullable: true, defaultValue: null, modelName: LaborCost )
• LaborHours ( type: esriFieldTypeDouble, alias: LaborHours, editable: true, nullable: true, defaultValue: null, modelName: LaborHours )
• MaintenanceZone ( type: esriFieldTypeString, alias: MaintenanceZone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaintenanceZone )
• MaterialCost ( type: esriFieldTypeDouble, alias: MaterialCost, editable: true, nullable: true, defaultValue: null, modelName: MaterialCost )
• MaterialNotes ( type: esriFieldTypeString, alias: MaterialNotes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MaterialNotes )
• NoWorkedNeededatLocation ( type: esriFieldTypeSmallInteger, alias: NoWorkedNeededatLocation, editable: true, nullable: true, defaultValue: null, modelName: NoWorkedNeededatLocation )
• PreviousTaskContractorNotes ( type: esriFieldTypeString, alias: PreviousTaskContractorNotes, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PreviousTaskContractorNotes )
• Request ( type: esriFieldTypeString, alias: Request, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Request )
• Street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 300, defaultValue: null, modelName: Street )
• StreetLightID ( type: esriFieldTypeString, alias: StreetLightID, editable: true, nullable: true, length: 254, defaultValue: null, modelName: StreetLightID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• TaskID ( type: esriFieldTypeString, alias: TaskID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TaskID )
• GISID ( type: esriFieldTypeString, alias: GIS ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: GISID )

Types:

ID: Planned
Name: Planned
Domains:
Templates:
• Name: Planned
  Description:
  Prototype:
  TaskID: null
  GISID: null
  Activity: null
  ActualStopDate: null
  Status: Planned
  BlockNumber: null
  CompletionNotes: null
  ContractorsNotes: null
  CouncilDistrict: null
  Department: null
  EquipmentCost: null
  InvestigationNeeded: null
  Inaccessible: null
  LaborCost: null
  LaborHours: null
  MaintenanceZone: null
  MaterialCost: null
  MaterialNotes: null
  NoWorkedNeededatLocation: null
  PreviousTaskContractorNotes: null
  Request: null
  Street: null
  StreetLightID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: In Progress
Name: In Progress
Domains:
Templates:
• Name: In Progress
  Description:
  Prototype:
  TaskID: null
  GISID: null
  Activity: null
  ActualStopDate: null
  Status: In Progress
  BlockNumber: null
  CompletionNotes: null
  ContractorsNotes: null
  CouncilDistrict: null
  Department: null
  EquipmentCost: null
  InvestigationNeeded: null
  Inaccessible: null
  LaborCost: null
  LaborHours: null
  MaintenanceZone: null
  MaterialCost: null
  MaterialNotes: null
  NoWorkedNeededatLocation: null
  PreviousTaskContractorNotes: null
  Request: null
  Street: null
  StreetLightID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Completed
Name: Completed
Domains:
Templates:
• Name: Completed
  Description:
  Prototype:
  TaskID: null
  GISID: null
  Activity: null
  ActualStopDate: null
  Status: Completed
  BlockNumber: null
  CompletionNotes: null
  ContractorsNotes: null
  CouncilDistrict: null
  Department: null
  EquipmentCost: null
  InvestigationNeeded: null
  Inaccessible: null
  LaborCost: null
  LaborHours: null
  MaintenanceZone: null
  MaterialCost: null
  MaterialNotes: null
  NoWorkedNeededatLocation: null
  PreviousTaskContractorNotes: null
  Request: null
  Street: null
  StreetLightID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Canceled
Name: Canceled
Domains:
Templates:
• Name: Canceled
  Description:
  Prototype:
  TaskID: null
  GISID: null
  Activity: null
  ActualStopDate: null
  Status: Canceled
  BlockNumber: null
  CompletionNotes: null
  ContractorsNotes: null
  CouncilDistrict: null
  Department: null
  EquipmentCost: null
  InvestigationNeeded: null
  Inaccessible: null
  LaborCost: null
  LaborHours: null
  MaintenanceZone: null
  MaterialCost: null
  MaterialNotes: null
  NoWorkedNeededatLocation: null
  PreviousTaskContractorNotes: null
  Request: null
  Street: null
  StreetLightID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata