Name: Street Lights Audit Review

Display Field: AuditStatus

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.16902670932E7
YMin: 4843513.2082
XMax: -1.16756449461E7
YMax: 4866015.8483000025
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: owner
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: CDOT
  Label: CDOT
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [104, 204, 201, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: City
  Label: City
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [232, 96, 247, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Private
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [62, 76, 148, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: United Power
  Label: United Power
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [57, 135, 51, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Xcel Energy
  Label: Xcel Energy
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [232, 186, 153, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial Black
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0

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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AuditStatus ( type: esriFieldTypeString, alias: Audit Status, length: 255 , Coded Values: [Pending: Pending] , [Pending - Tag Verification Required: Pending - Tag Verification Required] , [Audited: Audited] , ...7 more... )
• XYData ( type: esriFieldTypeString, alias: XY Verification, length: 255 , Coded Values: [1: OK] , [2: Pole XY Adjusted] , [3: No Pole at XY] )
• requires_review ( type: esriFieldTypeString, alias: Review Status, length: 255 , Coded Values: [Light Pole: Light Pole] , [Requires QAQC: Requires QAQC] , [QAQC Complete: QAQC Complete] )
• ward ( type: esriFieldTypeString, alias: Ward, length: 255 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• owner ( type: esriFieldTypeString, alias: Owner, length: 255 , Coded Values: [Xcel Energy: Xcel Energy] , [United Power: United Power] , [City: City] , ...5 more... )
• street_type ( type: esriFieldTypeString, alias: Street Type, length: 255 , Coded Values: [Arterial: Arterial] , [Collector: Collector] , [Local: Local] , ...9 more... )
• pole_placement ( type: esriFieldTypeString, alias: Pole Placement, length: 255 , Coded Values: [Behind sidewalk: Behind sidewalk] , [In front of sidewalk: In front of sidewalk] , [In sidewalk: In sidewalk] , ...2 more... )
• trenching ( type: esriFieldTypeString, alias: Trenching, length: 255 , Coded Values: [Softscape: Softscape] , [Hardscape: Hardscape] )
• light_use ( type: esriFieldTypeString, alias: Light Use, length: 255 , Coded Values: [Streetlight: Streetlight] , [Pedestrian Light: Pedestrian Light] , [Parking Lot Light: Parking Lot Light] , ...3 more... )
• pole_type ( type: esriFieldTypeString, alias: Pole Mount Type, length: 255 , Coded Values: [Standard: Standard] , [Decorative: Decorative] , [Traffic Signal Mounted: Traffic Signal Mounted] , ...5 more... )
• pole_material ( type: esriFieldTypeString, alias: Pole Material, length: 255 , Coded Values: [Aluminum: Aluminum] , [Fiberglass: Fiberglass] , [Concrete: Concrete] , ...3 more... )
• pole_color ( type: esriFieldTypeString, alias: Pole Color, length: 255 , Coded Values: [Black: Black] , [Gray: Gray] , [Brown: Brown] , ...6 more... )
• pole_height ( type: esriFieldTypeString, alias: Pole Height, length: 50 , Coded Values: [10: 10 ft] , [15: 15 ft] , [20: 20 ft] , ...10 more... )
• pole_foundation ( type: esriFieldTypeString, alias: Pole Foundation, length: 255 , Coded Values: [Concrete - Near Grade: Concrete - Near Grade] , [Concrete - Below Grade: Concrete - Below Grade] , [Concrete - Raised Foundation: Concrete - Raised Foundation] , ...4 more... )
• pole_base ( type: esriFieldTypeString, alias: Pole Base, length: 255 , Coded Values: [Decorative: Decorative] , [Breakaway Transformer Base: Breakaway Transformer Base] , [Base Cover: Base Cover] , ...1 more... )
• pole_condition ( type: esriFieldTypeString, alias: Pole Condition, length: 255 , Coded Values: [Fair: Fair] , [Moderate: Moderate] , [Poor: Poor] , ...2 more... )
• mast_arms ( type: esriFieldTypeSmallInteger, alias: No. of Mast Arms , Range: [0, 6] )
• number_fixtures ( type: esriFieldTypeSmallInteger, alias: Number of Fixtures , Range: [1, 10] )
• power_source ( type: esriFieldTypeString, alias: Power Source to Light, length: 50 , Coded Values: [Underground: Underground] , [Overhead: Overhead] , [Underpass: Underpass] )
• light_series_number ( type: esriFieldTypeString, alias: Lighting Series Number, length: 50 )
• pole_tag_no ( type: esriFieldTypeString, alias: Pole Tag No., length: 50 )
• install_year ( type: esriFieldTypeSmallInteger, alias: Year Installed )
• wire_material ( type: esriFieldTypeString, alias: Wire Material, length: 50 , Coded Values: [Aluminum: Aluminum] , [Copper: Copper] , [Unknown: Unknown] )
• conduit_material ( type: esriFieldTypeString, alias: Conduit Material, length: 50 , Coded Values: [Metal: Metal] , [PVC: PVC] , [Unknown: Unknown] )
• line_damage ( type: esriFieldTypeString, alias: Damage to Line, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• utility_elec_dist ( type: esriFieldTypeString, alias: Utility Electric Distribution, length: 50 , Coded Values: [Primary Power Pole: Mounted on Primary Power Pole] , [Secondary Power: Fed from Secondary Power] )
• splice_box ( type: esriFieldTypeString, alias: Splice Box, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• flashing_light ( type: esriFieldTypeString, alias: Flashing Light, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• speed_sign ( type: esriFieldTypeString, alias: Speed Sign, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• power_receptacle ( type: esriFieldTypeString, alias: Power Receptacle, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• camera ( type: esriFieldTypeString, alias: Camera, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• antenna ( type: esriFieldTypeString, alias: Antenna, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• traffic_control ( type: esriFieldTypeString, alias: Traffic Control, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• small_cell ( type: esriFieldTypeString, alias: Small Cell, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• siren ( type: esriFieldTypeString, alias: Siren, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• solar_panel ( type: esriFieldTypeString, alias: Solar Panel, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• other_attachments ( type: esriFieldTypeString, alias: Other Attachments, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• general_notes ( type: esriFieldTypeString, alias: General Notes, length: 750 )
• fixture_condition_1 ( type: esriFieldTypeString, alias: Fixture Condition 1, length: 50 , Coded Values: [Good: Good] , [Dirty: Dirty] , [Day Burner: Day Burner] , ...3 more... )
• fixture_mount_ht_1 ( type: esriFieldTypeString, alias: Fixture Mount Height 1, length: 50 , Coded Values: [10: 10 ft] , [15: 15 ft] , [20: 20 ft] , ...11 more... )
• mast_arm_type_1 ( type: esriFieldTypeString, alias: Mast Arm Type 1, length: 50 , Coded Values: [Post Top: Post Top] , [Single: Single] , [Decorative: Decorative] , ...2 more... )
• mast_arm_length_1 ( type: esriFieldTypeString, alias: Mast Arm Length 1, length: 50 , Coded Values: [1: 1"] , [3: 3"] , [8: 8"] , ...8 more... )
• fixture_direction_1 ( type: esriFieldTypeString, alias: Fixture Direction 1, length: 50 , Coded Values: [Nondirectional: Nondirectional] , [Street: Street] , [Parking Lot: Parking Lot] , ...2 more... )
• fixture_type_1 ( type: esriFieldTypeString, alias: Fixture Type 1, length: 50 , Coded Values: [Cobra Head: Cobra Head] , [Contemporary 1: Contemporary 1] , [Traditional 1: Traditional 1] , ...22 more... )
• lamp_type_1 ( type: esriFieldTypeString, alias: Lamp Type 1, length: 50 , Coded Values: [High Pressure Sodium: High Pressure Sodium] , [LED: LED] , [Incandescent: Incandescent] , ...7 more... )
• lamp_watt_1 ( type: esriFieldTypeSmallInteger, alias: Lamp Wattage 1 , Coded Values: [100: 100] , [0: Unknown] , [250: 250] , ...41 more... )
• photoelectric_cell_1 ( type: esriFieldTypeString, alias: Photoelectric Cell 1, length: 50 , Coded Values: [Yes on Luminaire: Yes on Luminaire] , [Yes on LCC: Yes on LCC] , [Yes on Pole: Yes on Pole] , ...1 more... )
• photocell_pin_count_1 ( type: esriFieldTypeString, alias: Photocell Pin Count 1, length: 50 , Coded Values: [3-Pin: 3-Pin] , [5-Pin: 5-Pin] , [7-Pin: 7-Pin] , ...2 more... )
• fixture_condition_2 ( type: esriFieldTypeString, alias: Fixture Condition 2, length: 50 , Coded Values: [Good: Good] , [Dirty: Dirty] , [Day Burner: Day Burner] , ...3 more... )
• fixture_mount_ht_2 ( type: esriFieldTypeString, alias: Fixture Mount Height 2, length: 50 , Coded Values: [10: 10 ft] , [15: 15 ft] , [20: 20 ft] , ...10 more... )
• mast_arm_type_2 ( type: esriFieldTypeString, alias: Mast Arm Type 2, length: 50 , Coded Values: [Single: Single] , [Double: Double] , [Decorative: Decorative] , ...2 more... )
• mast_arm_length_2 ( type: esriFieldTypeString, alias: Mast Arm Length 2, length: 50 , Coded Values: [1: 1"] , [3: 3"] , [8: 8"] , ...8 more... )
• fixture_direction_2 ( type: esriFieldTypeString, alias: Fixture Direction 2, length: 50 , Coded Values: [Street: Street] , [Pathway/Sidewalk: Pathway/Sidewalk] , [Private: Private] , ...2 more... )
• fixture_type_2 ( type: esriFieldTypeString, alias: Fixture Type 2, length: 50 , Coded Values: [Cobra Head: Cobra Head] , [Curvilinear: Curvilinear] , [Shoebox: Shoebox] , ...22 more... )
• lamp_type_2 ( type: esriFieldTypeString, alias: Lamp Type 2, length: 50 , Coded Values: [LED: LED] , [Induction: Induction] , [Linear Flourescent: Linear Flourescent] , ...7 more... )
• lamp_watt_2 ( type: esriFieldTypeSmallInteger, alias: Lamp Wattage 2 , Coded Values: [0: Unknown] , [28: 28] , [45: 45] , ...26 more... )
• photoelectric_cell_2 ( type: esriFieldTypeString, alias: Photoelectric Cell 2, length: 50 , Coded Values: [Yes on Luminaire: Yes on Luminaire] , [Yes on LCC: Yes on LCC] , [Yes on Pole: Yes on Pole] , ...1 more... )
• photocell_pin_count_2 ( type: esriFieldTypeString, alias: Photocell Pin Count 2, length: 50 , Coded Values: [3-Pin: 3-Pin] , [5-Pin: 5-Pin] , [7-Pin: 7-Pin] , ...2 more... )
• fixture_condition_3 ( type: esriFieldTypeString, alias: Fixture Condition 3, length: 50 , Coded Values: [Good: Good] , [Dirty: Dirty] , [Day Burner: Day Burner] , ...3 more... )
• fixture_mount_ht_3 ( type: esriFieldTypeString, alias: Fixture Mount Height 3, length: 50 , Coded Values: [10: 10 ft] , [15: 15 ft] , [20: 20 ft] , ...10 more... )
• mast_arm_type_3 ( type: esriFieldTypeString, alias: Mast Arm Type 3, length: 50 , Coded Values: [Single: Single] , [Double: Double] , [Decorative: Decorative] , ...2 more... )
• mast_arm_length_3 ( type: esriFieldTypeString, alias: Mast Arm Length 3, length: 50 , Coded Values: [1: 1"] , [3: 3"] , [8: 8"] , ...8 more... )
• fixture_direction_3 ( type: esriFieldTypeString, alias: Fixture Direction 3, length: 50 , Coded Values: [Street: Street] , [Pathway/Sidewalk: Pathway/Sidewalk] , [Private: Private] , ...2 more... )
• fixture_type_3 ( type: esriFieldTypeString, alias: Fixture Type 3, length: 50 , Coded Values: [Cobra Head: Cobra Head] , [Curvilinear: Curvilinear] , [Shoebox: Shoebox] , ...22 more... )
• lamp_type_3 ( type: esriFieldTypeString, alias: Lamp Type 3, length: 50 , Coded Values: [LED: LED] , [Induction: Induction] , [Linear Flourescent: Linear Flourescent] , ...7 more... )
• lamp_watt_3 ( type: esriFieldTypeSmallInteger, alias: Lamp Wattage 3 , Coded Values: [0: Unknown] , [28: 28] , [45: 45] , ...25 more... )
• photoelectric_cell_3 ( type: esriFieldTypeString, alias: Photoelectric Cell 3, length: 50 , Coded Values: [Yes on Luminaire: Yes on Luminaire] , [Yes on LCC: Yes on LCC] , [Yes on Pole: Yes on Pole] , ...1 more... )
• photocell_pin_count_3 ( type: esriFieldTypeString, alias: Photocell Pin Count 3, length: 50 , Coded Values: [3-Pin: 3-Pin] , [5-Pin: 5-Pin] , [7-Pin: 7-Pin] , ...2 more... )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• neighborhood_year ( type: esriFieldTypeString, alias: Neighborhood Year, length: 4 )
• GIS_ID ( type: esriFieldTypeInteger, alias: GIS ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SurvComs ( type: esriFieldTypeString, alias: Survey Comments, length: 255 )
• SurvDate ( type: esriFieldTypeDate, alias: Survey Date, length: 8 )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 128 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 128 )
• PoleUse ( type: esriFieldTypeString, alias: Pole Usage, length: 256 , Coded Values: [Distribution: Distribution] , [Lighting: Lighting] , [Communication: Communication] , ...1 more... )
• RTENum ( type: esriFieldTypeInteger, alias: RTE ID )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

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

  Iteminfo   Thumbnail   Metadata