View In:   ArcGIS Online Map Viewer

Name: Street Lights: Phase 5

Display Field: TechName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

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: 1242448.147337824
YMin: 526520.3563318998
XMax: 1258631.2143810838
YMax: 536914.0701244771
Spatial Reference: 2893  (2893)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ConversionStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: New
  Label: New
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 112, 255, 255]
  Size: 7.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Remove
  Label: Remove
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [169, 0, 230, 255]
  Size: 7.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Not started
  Label: Not started
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 0, 255]
  Size: 7.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Pending
  Label: Pending
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 7.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Complete
  Label: Complete
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 255, 197, 255]
  Size: 7.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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: ConversionStatus

Fields:

• Light_Wattage ( type: esriFieldTypeSmallInteger, alias: Light_Wattage, editable: true, nullable: true, defaultValue: null, modelName: Light_Wattage )
• Lamp_Type ( type: esriFieldTypeString, alias: Lamp_Type, editable: true, nullable: true, length: 84, defaultValue: null, modelName: Lamp_Type , Coded Values: [High Pressure Sodium: High Pressure Sodium] , [LED: LED] , [Mercury Vapor: Mercury Vapor] )
• Light_Fixture ( type: esriFieldTypeString, alias: Light_Fixture, editable: true, nullable: true, length: 84, defaultValue: null, modelName: Light_Fixture , Coded Values: [ARM: ARM] , [Atlanta: Atlanta] , [Cobra: Cobra] , ...8 more... )
• Pole_Type ( type: esriFieldTypeString, alias: Pole_Type, editable: true, nullable: true, length: 84, defaultValue: null, modelName: Pole_Type , Coded Values: [Aluminum: Aluminum] , [Black Fiberglass: Black Fiberglass] , [Decorative: Decorative] , ...12 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 120, defaultValue: null, modelName: Manufacturer )
• ConversionStatus ( type: esriFieldTypeString, alias: Conversion Status, editable: true, nullable: false, length: 50, defaultValue: Not started, modelName: ConversionStatus , Coded Values: [Complete: Complete] , [Pending: Pending] , [Not started: Not started] , ...2 more... )
• City_Pole_Number ( type: esriFieldTypeSmallInteger, alias: City_Pole_Number, editable: true, nullable: true, defaultValue: null, modelName: City_Pole_Number )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• IsFixtureInstalled ( type: esriFieldTypeString, alias: Fixture installed?, editable: true, nullable: false, length: 3, defaultValue: Yes, modelName: IsFixtureInstalled , Coded Values: [Yes: Yes] , [No: No] )
• IsPoleTagMissing ( type: esriFieldTypeString, alias: Pole tag missing?, editable: true, nullable: false, length: 3, defaultValue: No, modelName: IsPoleTagMissing , Coded Values: [Yes: Yes] , [No: No] )
• IsPoleTagCorrect ( type: esriFieldTypeString, alias: Pole tag correct?, editable: true, nullable: false, length: 3, defaultValue: Yes, modelName: IsPoleTagCorrect , Coded Values: [Yes: Yes] , [No: No] )
• IsAccessCoverMissing ( type: esriFieldTypeString, alias: Access cover missing?, editable: true, nullable: false, length: 3, defaultValue: No, modelName: IsAccessCoverMissing , Coded Values: [Yes: Yes] , [No: No] )
• HasVoltage ( type: esriFieldTypeString, alias: Has voltage?, editable: true, nullable: false, length: 3, defaultValue: Yes, modelName: HasVoltage , Coded Values: [Yes: Yes] , [No: No] )
• PoleNeedsPainting ( type: esriFieldTypeString, alias: Pole needs painting?, editable: true, nullable: false, length: 3, defaultValue: No, modelName: PoleNeedsPainting , Coded Values: [Yes: Yes] , [No: No] )
• IsPoleDamaged ( type: esriFieldTypeString, alias: Pole damaged?, editable: true, nullable: false, length: 3, defaultValue: No, modelName: IsPoleDamaged , Coded Values: [Yes: Yes] , [No: No] )
• PoleHasAccessToWire ( type: esriFieldTypeString, alias: Pole has access to wire?, editable: true, nullable: false, length: 3, defaultValue: Yes, modelName: PoleHasAccessToWire , Coded Values: [Yes: Yes] , [No: No] )
• PoleHasOtherIssues ( type: esriFieldTypeString, alias: Pole has other issues?, editable: true, nullable: false, length: 3, defaultValue: No, modelName: PoleHasOtherIssues , Coded Values: [Yes: Yes] , [No: No] )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments )
• TechID ( type: esriFieldTypeSmallInteger, alias: Tech ID, editable: true, nullable: true, defaultValue: null, modelName: TechID , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...5 more... )
• TechName ( type: esriFieldTypeString, alias: TechName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TechName , Coded Values: [Alex Rivera: Alex Rivera] , [George Barksdale: George Barksdale] , [Jairo Jacinto: Jairo Jacinto] , ...6 more... )
• 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 )
• Street_Pole_ID ( type: esriFieldTypeInteger, alias: Street_Pole_ID, editable: true, nullable: true, defaultValue: null, modelName: Street_Pole_ID )
• Street ( type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 48, defaultValue: null, modelName: Street )
• Limits ( type: esriFieldTypeString, alias: LIMITS, editable: true, nullable: true, length: 84, defaultValue: null, modelName: Limits )
• Location ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location )
• ConversionDate ( type: esriFieldTypeDate, alias: ConversionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ConversionDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: New
Name: New
Domains:
• Lamp_Type:
  Inherited
• Light_Fixture:
  Inherited
• Pole_Type:
  Inherited
• ConversionStatus:
  Inherited
• IsFixtureInstalled:
  Inherited
• IsPoleTagMissing:
  Inherited
• IsPoleTagCorrect:
  Inherited
• IsAccessCoverMissing:
  Inherited
• HasVoltage:
  Inherited
• PoleNeedsPainting:
  Inherited
• IsPoleDamaged:
  Inherited
• PoleHasAccessToWire:
  Inherited
• PoleHasOtherIssues:
  Inherited
• TechID:
  Inherited
• TechName:
  Inherited
Templates:
• Name: New
  Description:
  Prototype:
  ConversionDate: null
  Light_Wattage: null
  Lamp_Type: null
  Light_Fixture: null
  Pole_Type: null
  Manufacturer: null
  ConversionStatus: New
  City_Pole_Number: null
  Location: null
  IsFixtureInstalled: Yes
  IsPoleTagMissing: No
  IsPoleTagCorrect: Yes
  IsAccessCoverMissing: No
  HasVoltage: Yes
  PoleNeedsPainting: No
  IsPoleDamaged: No
  PoleHasAccessToWire: Yes
  PoleHasOtherIssues: No
  Comments: null
  TechID: null
  TechName: null
  Limits: null
  Street: null
  Street_Pole_ID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Remove
Name: Remove
Domains:
• Lamp_Type:
  Inherited
• Light_Fixture:
  Inherited
• Pole_Type:
  Inherited
• ConversionStatus:
  Inherited
• IsFixtureInstalled:
  Inherited
• IsPoleTagMissing:
  Inherited
• IsPoleTagCorrect:
  Inherited
• IsAccessCoverMissing:
  Inherited
• HasVoltage:
  Inherited
• PoleNeedsPainting:
  Inherited
• IsPoleDamaged:
  Inherited
• PoleHasAccessToWire:
  Inherited
• PoleHasOtherIssues:
  Inherited
• TechID:
  Inherited
• TechName:
  Inherited
Templates:
• Name: Remove
  Description:
  Prototype:
  ConversionDate: null
  Light_Wattage: null
  Lamp_Type: null
  Light_Fixture: null
  Pole_Type: null
  Manufacturer: null
  ConversionStatus: Remove
  City_Pole_Number: null
  Location: null
  IsFixtureInstalled: Yes
  IsPoleTagMissing: No
  IsPoleTagCorrect: Yes
  IsAccessCoverMissing: No
  HasVoltage: Yes
  PoleNeedsPainting: No
  IsPoleDamaged: No
  PoleHasAccessToWire: Yes
  PoleHasOtherIssues: No
  Comments: null
  TechID: null
  TechName: null
  Limits: null
  Street: null
  Street_Pole_ID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Not started
Name: Not started
Domains:
• Lamp_Type:
  Inherited
• Light_Fixture:
  Inherited
• Pole_Type:
  Inherited
• ConversionStatus:
  Inherited
• IsFixtureInstalled:
  Inherited
• IsPoleTagMissing:
  Inherited
• IsPoleTagCorrect:
  Inherited
• IsAccessCoverMissing:
  Inherited
• HasVoltage:
  Inherited
• PoleNeedsPainting:
  Inherited
• IsPoleDamaged:
  Inherited
• PoleHasAccessToWire:
  Inherited
• PoleHasOtherIssues:
  Inherited
• TechID:
  Inherited
• TechName:
  Inherited
Templates:
• Name: Not started
  Description:
  Prototype:
  City_Pole_Number: null
  PoleNeedsPainting: No
  IsPoleTagCorrect: Yes
  IsFixtureInstalled: Yes
  PoleHasAccessToWire: Yes
  IsAccessCoverMissing: No
  IsPoleDamaged: No
  Manufacturer: null
  HasVoltage: Yes
  IsPoleTagMissing: No
  ConversionDate: null
  Light_Wattage: null
  Lamp_Type: null
  Light_Fixture: null
  Pole_Type: null
  ConversionStatus: Not started
  PoleHasOtherIssues: No
  Comments: null
  TechID: null
  TechName: null
  Location: null
  Limits: null
  Street: null
  Street_Pole_ID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Pending
Name: Pending
Domains:
• Lamp_Type:
  Inherited
• Light_Fixture:
  Inherited
• Pole_Type:
  Inherited
• ConversionStatus:
  Inherited
• IsFixtureInstalled:
  Inherited
• IsPoleTagMissing:
  Inherited
• IsPoleTagCorrect:
  Inherited
• IsAccessCoverMissing:
  Inherited
• HasVoltage:
  Inherited
• PoleNeedsPainting:
  Inherited
• IsPoleDamaged:
  Inherited
• PoleHasAccessToWire:
  Inherited
• PoleHasOtherIssues:
  Inherited
• TechID:
  Inherited
• TechName:
  Inherited
Templates:
• Name: Pending
  Description:
  Prototype:
  City_Pole_Number: null
  PoleNeedsPainting: No
  IsPoleTagCorrect: Yes
  IsFixtureInstalled: Yes
  PoleHasAccessToWire: Yes
  IsAccessCoverMissing: No
  IsPoleDamaged: No
  Manufacturer: null
  HasVoltage: Yes
  IsPoleTagMissing: No
  ConversionDate: null
  Light_Wattage: null
  Lamp_Type: null
  Light_Fixture: null
  Pole_Type: null
  ConversionStatus: Pending
  PoleHasOtherIssues: No
  Comments: null
  TechID: null
  TechName: null
  Location: null
  Limits: null
  Street: null
  Street_Pole_ID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Complete
Name: Complete
Domains:
• Lamp_Type:
  Inherited
• Light_Fixture:
  Inherited
• Pole_Type:
  Inherited
• ConversionStatus:
  Inherited
• IsFixtureInstalled:
  Inherited
• IsPoleTagMissing:
  Inherited
• IsPoleTagCorrect:
  Inherited
• IsAccessCoverMissing:
  Inherited
• HasVoltage:
  Inherited
• PoleNeedsPainting:
  Inherited
• IsPoleDamaged:
  Inherited
• PoleHasAccessToWire:
  Inherited
• PoleHasOtherIssues:
  Inherited
• TechID:
  Inherited
• TechName:
  Inherited
Templates:
• Name: Complete
  Description:
  Prototype:
  City_Pole_Number: null
  PoleNeedsPainting: No
  IsPoleTagCorrect: Yes
  IsFixtureInstalled: Yes
  PoleHasAccessToWire: Yes
  IsAccessCoverMissing: No
  IsPoleDamaged: No
  Manufacturer: null
  HasVoltage: Yes
  IsPoleTagMissing: No
  ConversionDate: null
  Light_Wattage: null
  Lamp_Type: null
  Light_Fixture: null
  Pole_Type: null
  ConversionStatus: Complete
  PoleHasOtherIssues: No
  Comments: null
  TechID: null
  TechName: null
  Location: null
  Limits: null
  Street: null
  Street_Pole_ID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

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