Name: Streetlights Audit

Display Field: Audit_Status

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 40.38262019200005
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Audit_Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Add
  Label: Add
  Description: N/A
  Symbol:
  
• Value: Audited
  Label: Audited
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 170, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Flagged For Review
  Label: Flagged For Review
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 190, 190, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: No Light Here
  Label: No Light Here
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 255, 197, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Out of Scope
  Label: Out of Scope
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [225, 225, 225, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: To Be Audited
  Label: To Be Audited
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 10.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: false
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: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Audit_Status ( type: esriFieldTypeString, alias: Audit_Status, length: 30 , Coded Values: [Audited: Audited] , [Add: Add] , [No Light Here: No Light Here] , ...9 more... )
• Obs_Pole_Number ( type: esriFieldTypeString, alias: Obs_Pole_Number, length: 50 )
• Obs_Pole_Material ( type: esriFieldTypeString, alias: Obs_Pole_Material, length: 25 , Coded Values: [Wood: Wood] , [Steel: Steel] , [Aluminum: Aluminum] , ...5 more... )
• Obs_Pole_Color ( type: esriFieldTypeString, alias: Obs_Pole_Color, length: 25 , Coded Values: [Unpainted: Unpainted] , [White: White] , [Blue: Blue] , ...5 more... )
• Obs_Pole_Condition ( type: esriFieldTypeString, alias: Obs_Pole_Condition, length: 25 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] )
• Obs_Pole_Height ( type: esriFieldTypeString, alias: Obs_Pole_Height, length: 25 , Coded Values: [10 - 15 Foot: 10 - 15 Foot] , [16 - 20 Foot: 16 - 20 Foot] , [21 - 25 Foot: 21 - 25 Foot] , ...6 more... )
• Obs_Fixture_Model ( type: esriFieldTypeString, alias: Obs_Fixture_Model, length: 50 , Coded Values: [Cobrahead: Cobrahead] , [Security: Security] , [4-Sided Colonial: 4-Sided Colonial] , ...24 more... )
• Obs_Fixture_Quantity ( type: esriFieldTypeSmallInteger, alias: Obs_Fixture_Quantity , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...6 more... )
• Obs_Lamp_Wattage ( type: esriFieldTypeString, alias: Obs_Lamp_Wattage, length: 25 , Coded Values: [50: 50] , [55: 55] , [70: 70] , ...26 more... )
• Obs_Lamp_Type ( type: esriFieldTypeString, alias: Obs_Lamp_Type, length: 25 , Coded Values: [HPS: HPS] , [LPS: LPS] , [LED: LED] , ...12 more... )
• Obs_Mast_Arm_Length ( type: esriFieldTypeString, alias: Obs_Mast_Arm_Length, length: 25 , Coded Values: [30 In: 30 In] , [4 Foot: 4 Foot] , [6 Foot: 6 Foot] , ...6 more... )
• Obs_Mast_Arm_Condition ( type: esriFieldTypeString, alias: Obs_Mast_Arm_Condition, length: 25 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] )
• Obs_Mast_Arm_Position ( type: esriFieldTypeSmallInteger, alias: Obs_Mast_Arm_Position , Coded Values: [0: 0] , [45: 45] )
• Obs_Mast_Arm_Direction ( type: esriFieldTypeSmallInteger, alias: Obs_Mast_Arm_Direction )
• Obs_Mast_Arm_Bend ( type: esriFieldTypeSmallInteger, alias: Obs_Mast_Arm_Bend , Coded Values: [-45: -45] , [0: 0] , [45: 45] )
• Obs_Power_Service ( type: esriFieldTypeString, alias: Obs_Power_Service, length: 25 , Coded Values: [Overhead: Overhead] , [Underground: Underground] , [Other: Other] )
• Obs_Lens_Type ( type: esriFieldTypeString, alias: Obs_Lens_Type, length: 50 , Coded Values: [Flat-Clear (Horizontal): Flat-Clear (Horizontal)] , [Sag-Prismatic (Horizontal): Sag-Prismatic (Horizontal)] , [Clear (Vertical): Clear (Vertical)] , ...4 more... )
• Obs_Tree_Trimming_Issue ( type: esriFieldTypeString, alias: Obs_Tree_Trimming_Issue, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Obs_Dayburner ( type: esriFieldTypeString, alias: Obs_Dayburner, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Audit_Notes ( type: esriFieldTypeString, alias: Audit_Notes, length: 250 )
• Road_Classification ( type: esriFieldTypeString, alias: Road_Classification, length: 50 , Coded Values: [Major: Major] , [Collector: Collector] , [Local: Local] , ...2 more... )
• Number_Of_Lanes ( type: esriFieldTypeSmallInteger, alias: Number_Of_Lanes )
• Total_Intersection_Fixtures ( type: esriFieldTypeSmallInteger, alias: Total_Intersection_Fixtures )
• Pole_Context ( type: esriFieldTypeString, alias: Pole_Context, length: 25 , Coded Values: [Mid Street: Mid Street] , [Intersection: Intersection] )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y )
• Link_To_Google_Maps ( type: esriFieldTypeString, alias: Link_To_Google_Maps, length: 250 )
• Peco_Match ( type: esriFieldTypeString, alias: Peco_Match, length: 25 , Coded Values: [Match: Match] , [No Match: No Match] )
• Evari_Number ( type: esriFieldTypeInteger, alias: Evari_Number )
• Install_Status ( type: esriFieldTypeString, alias: Install_Status, length: 40 , Coded Values: [To Be Converted: To Be Converted] , [Converted: Converted] , [Converted With Issue: Converted With Issue] , ...12 more... )
• Proposed_Fixture ( type: esriFieldTypeString, alias: Proposed_Fixture, length: 50 )
• Installer_Predefined_Notes_1 ( type: esriFieldTypeString, alias: Installer_Predefined_Notes_1, length: 50 , Coded Values: [No Issue - Flashed: No Issue - Flashed] , [No Power - Utility Power Issue: No Power - Utility Power Issue] , [No Power - Blown Fuse at Arrival: No Power - Blown Fuse at Arrival] , ...7 more... )
• Installer_Predefined_Notes_2 ( type: esriFieldTypeString, alias: Installer_Predefined_Notes_2, length: 50 , Coded Values: [No Issue - Flashed: No Issue - Flashed] , [No Power - Utility Power Issue: No Power - Utility Power Issue] , [No Power - Blown Fuse at Arrival: No Power - Blown Fuse at Arrival] , ...7 more... )
• Installer_Notes ( type: esriFieldTypeString, alias: Installer_Notes, length: 250 )
• QC_Status ( type: esriFieldTypeString, alias: QC_Status, length: 30 , Coded Values: [QC Pass: QC Pass] , [To Be QCd: To Be QCd] , [QC Fail: QC Fail] , ...1 more... )
• QC_Notes ( type: esriFieldTypeString, alias: QC_Notes, length: 250 )
• Audited_By ( type: esriFieldTypeString, alias: Audited_By, length: 25 )
• Audit_Date ( type: esriFieldTypeDate, alias: Audit_Date, length: 8 )
• Install_Status_History ( type: esriFieldTypeString, alias: Install_Status_History, length: 250 )
• Install_Status_Yesterday ( type: esriFieldTypeString, alias: Install_Status_Yesterday, length: 40 )
• QCd_By ( type: esriFieldTypeString, alias: QCd_By, length: 25 )
• QC_Date ( type: esriFieldTypeDate, alias: QC_Date, length: 8 )
• Audit_Status_History ( type: esriFieldTypeString, alias: Audit_Status_History, length: 250 )
• Audit_Status_Yesterday ( type: esriFieldTypeString, alias: Audit_Status_Yesterday, length: 30 )
• Installed_By ( type: esriFieldTypeString, alias: Installed_By, length: 25 )
• Install_Date ( type: esriFieldTypeDate, alias: Install_Date, length: 8 )
• Fixture_Type_Code ( type: esriFieldTypeString, alias: Fixture_Type_Code, length: 10 )
• Post_Audit_Fixture_Code ( type: esriFieldTypeString, alias: Post_Audit_Fixture_Code, length: 100 )
• PrelimDesign_Fixture_Code ( type: esriFieldTypeString, alias: PrelimDesign_Fixture_Code, length: 100 , Coded Values: [4SC-10L-LED-T2: 4SC-10L-LED-T2] , [4SC-10L-LED-T3: 4SC-10L-LED-T3] , [4SC-4L-LED-T2: 4SC-4L-LED-T2] , ...190 more... )
• PrelimDesign_Fixture_Type ( type: esriFieldTypeString, alias: PrelimDesign_Fixture_Type, length: 20 )
• PrelimDesign_Lumens ( type: esriFieldTypeString, alias: PrelimDesign_Lumens, length: 20 )
• PrelimDesign_Distribution ( type: esriFieldTypeString, alias: PrelimDesign_Distribution, length: 20 )
• PrelimDesign_CCT ( type: esriFieldTypeString, alias: PrelimDesign_CCT, length: 20 )
• FinalDesign_Fixture_Code ( type: esriFieldTypeString, alias: FinalDesign_Fixture_Code, length: 100 )
• FinalDesign_Fixture_Type ( type: esriFieldTypeString, alias: FinalDesign_Fixture_Type, length: 20 )
• FinalDesign_Lumens ( type: esriFieldTypeString, alias: FinalDesign_Lumens, length: 20 )
• FinalDesign_Distribution ( type: esriFieldTypeString, alias: FinalDesign_Distribution, length: 20 )
• FinalDesign_CCT ( type: esriFieldTypeString, alias: FinalDesign_CCT, length: 20 )
• Construction_Fixture_Code ( type: esriFieldTypeString, alias: Construction_Fixture_Code, length: 100 )
• Construction_Fixture_Type ( type: esriFieldTypeString, alias: Construction_Fixture_Type, length: 20 )
• Construction_Lumens ( type: esriFieldTypeString, alias: Construction_Lumens, length: 20 )
• Construction_Distribution ( type: esriFieldTypeString, alias: Construction_Distribution, length: 20 )
• Construction_CCT ( type: esriFieldTypeString, alias: Construction_CCT, length: 20 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Account ( type: esriFieldTypeString, alias: Account, length: 50 )
• Premise ( type: esriFieldTypeString, alias: Premise, length: 50 )
• Service_Point ( type: esriFieldTypeString, alias: Service_Point, length: 50 )
• Component_Type ( type: esriFieldTypeString, alias: Component_Type, length: 50 )
• Sequence ( type: esriFieldTypeString, alias: Sequence, length: 50 )
• Component_Details ( type: esriFieldTypeString, alias: Component_Details, length: 100 )
• QC_Status_Yesterday ( type: esriFieldTypeString, alias: QC_Status_Yesterday, length: 50 )
• QC_Status_History ( type: esriFieldTypeString, alias: QC_Status_History, length: 250 )
• Peco_Municipality ( type: esriFieldTypeString, alias: Peco_Municipality, length: 50 )
• Obs_Municipality ( type: esriFieldTypeString, alias: Obs_Municipality, length: 50 )
• Desktop_QC_Status ( type: esriFieldTypeString, alias: Desktop_QC_Status, length: 50 , Coded Values: [QC Pass: QC Pass] , [To Be QCd: To Be QCd] , [QC Fail: QC Fail] , ...1 more... )
• Desktop_QC_Notes ( type: esriFieldTypeString, alias: Desktop_QC_Notes, length: 250 )
• Halo_Override ( type: esriFieldTypeString, alias: Halo_Override, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Assumed_Wattage ( type: esriFieldTypeInteger, alias: Assumed_Wattage )
• Final_Wattage ( type: esriFieldTypeInteger, alias: Final_Wattage )
• Assumed_Type ( type: esriFieldTypeString, alias: Assumed_Type, length: 50 )
• Type_Identifier ( type: esriFieldTypeString, alias: Type_Identifier, length: 25 )
• Obs_Fixture_Mounting_Height ( type: esriFieldTypeString, alias: Obs_Fixture_Mounting_Height, length: 50 , Coded Values: [10 - 15 Foot: 10 - 15 Foot] , [16 - 20 Foot: 16 - 20 Foot] , [21 - 25 Foot: 21 - 25 Foot] , ...4 more... )
• Obs_Fixture_Color ( type: esriFieldTypeString, alias: Obs_Fixture_Color, length: 50 , Coded Values: [Unpainted: Unpainted] , [White: White] , [Blue: Blue] , ...5 more... )
• Evari_Office_Notes ( type: esriFieldTypeString, alias: Evari_Office_Notes, length: 100 )
• Road_Class_Municipality ( type: esriFieldTypeString, alias: Road_Class_Municipality, length: 50 , Coded Values: [Major: Major] , [Collector: Collector] , [Local: Local] , ...2 more... )
• PD_Override_Fixture_Code ( type: esriFieldTypeString, alias: PD_Override_Fixture_Code, length: 70 )
• Final_PD_Fixture_Code ( type: esriFieldTypeString, alias: Final_PD_Fixture_Code, length: 70 )
• Override_FD_Fixture_Code ( type: esriFieldTypeString, alias: Override_FD_Fixture_Code, length: 70 )
• Final_FD_Fixture_Code ( type: esriFieldTypeString, alias: Final_FD_Fixture_Code, length: 70 )
• CCT ( type: esriFieldTypeString, alias: CCT, length: 50 )
• Dimming ( type: esriFieldTypeString, alias: Dimming, length: 50 )
• Surge ( type: esriFieldTypeString, alias: Surge, length: 50 )
• Pin_Configuration ( type: esriFieldTypeString, alias: Pin_Configuration, length: 50 )
• Special_Color ( type: esriFieldTypeString, alias: Special_Color, length: 50 )
• Other_Materials ( type: esriFieldTypeString, alias: Other_Materials, length: 50 )
• Rewire_Issue ( type: esriFieldTypeString, alias: Rewire_Issue, length: 50 , Coded Values: [Rewire Required: Rewire Required] , [Rewire Completed: Rewire Completed] )
• PECO_Power_Issue ( type: esriFieldTypeString, alias: PECO_Power_Issue, length: 70 , Coded Values: [PECO Power Issue Identified (Overhead): PECO Power Issue Identified (Overhead)] , [PECO Power Issue Identified (Underground): PECO Power Issue Identified (Underground)] , [PECO Power Issue Resolved (Underground): PECO Power Issue Resolved (Underground)] , ...1 more... )
• Tree_Trimming_Issue ( type: esriFieldTypeString, alias: Tree_Trimming_Issue, length: 50 , Coded Values: [Tree Trimming Required: Tree Trimming Required] , [Tree Trimming Completed: Tree Trimming Completed] )
• Final_Fixture_Code ( type: esriFieldTypeString, alias: Final_Fixture_Code, length: 70 )
• KLS_Notes ( type: esriFieldTypeString, alias: KLS_Notes, length: 250 )
• SLC_Node_Number ( type: esriFieldTypeString, alias: SLC Node #, length: 10 )
• Address_Details ( type: esriFieldTypeString, alias: Address_Details, length: 250 )
• GPS_Coord ( type: esriFieldTypeString, alias: GPS_Coord, length: 20 )
• PECO_ACCT_Current ( type: esriFieldTypeString, alias: PECO_ACCT_Current, length: 50 )
• PECO_ACCT_Final ( type: esriFieldTypeString, alias: PECO_ACCT_Final, length: 50 )
• Photocell_Completed ( type: esriFieldTypeString, alias: Photocell_Completed, length: 50 , Coded Values: [Not Completed: Not Completed] , [Completed: Completed] )
• Verified ( type: esriFieldTypeString, alias: Verified, length: 50 , Coded Values: [Not Verified: Not Verified] , [Verified: Verified] , [Failed: Failed] , ...1 more... )
• Inspector_Notes ( type: esriFieldTypeString, alias: Inspector_Notes, length: 250 )
• Grounding_Status ( type: esriFieldTypeString, alias: Grounding_Status, length: 50 , Coded Values: [Ground Wires Exist, Too Short: Ground Wires Exist, Too Short] , [Ground Wires Already Connected: Ground Wires Already Connected] , [Ground Wires Connected: Ground Wires Connected] , ...2 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Link_To_Full ( type: esriFieldTypeString, alias: Link_To_Full, length: 150 )
• Link_To_Up ( type: esriFieldTypeString, alias: Link_To_Up, length: 150 )
• Link_To_Badge ( type: esriFieldTypeString, alias: Link_To_Badge, length: 150 )
• Link_To_Wattage ( type: esriFieldTypeString, alias: Link_To_Wattage, length: 150 )
• Round ( type: esriFieldTypeString, alias: Round, length: 10 )
• Manufacturer_Name_Part_Number ( type: esriFieldTypeString, alias: Manufacturer_Name_Part_Number, length: 250 )
• Source_Fixture_Model ( type: esriFieldTypeString, alias: Source_Fixture_Model, length: 50 , Coded Values: [Cobrahead: Cobrahead] , [Security: Security] , [4-Sided Colonial: 4-Sided Colonial] , ...24 more... )
• Source_OID ( type: esriFieldTypeInteger, alias: Source_OID )
• Photos_Reviewed ( type: esriFieldTypeString, alias: Photos_Reviewed, length: 250 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata