Name: Light Poles

Display Field: requires_review

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Point feature locations in Thornton, Colorado for inventory of streetlight location, physical appearance and condition as well as information regarding quantity and type of light fixtures attached to each pole.

Copyright Text: Data collected under contract by: APTIM 1780 Hughes Landing Blvd. Suite 1000 The Woodlands, TX 77380 www.APTIM.com

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Extent:

XMin: -1.1690291469878793E7
YMin: 4843443.590063262
XMax: -1.167559018936173E7
YMax: 4866038.043844599
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:
  
• Value: City
  Label: City
  Description: N/A
  Symbol:
  
• Value: Private
  Label: Private
  Description: N/A
  Symbol:
  
• Value: United Power
  Label: United Power
  Description: N/A
  Symbol:
  
• Value: Unknown
  Label: Unknown
  Description: N/A
  Symbol:
  
• Value: Xcel Energy
  Label: Xcel Energy
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false
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 )
• 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: [City: City] , [Private: Private] , [CDOT: CDOT] , ...3 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] , [Brown: Brown] , [Gray: Gray] , ...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] , ...10 more... )
• mast_arm_type_1 ( type: esriFieldTypeString, alias: Mast Arm Type 1, length: 50 , Coded Values: [Single: Single] , [Double: Double] , [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: [Street: Street] , [Pathway/Sidewalk: Pathway/Sidewalk] , [Private: Private] , ...2 more... )
• fixture_type_1 ( type: esriFieldTypeString, alias: Fixture Type 1, length: 50 , Coded Values: [Cobra Head: Cobra Head] , [Curvilinear: Curvilinear] , [Shoebox: Shoebox] , ...22 more... )
• lamp_type_1 ( type: esriFieldTypeString, alias: Lamp Type 1, length: 50 , Coded Values: [LED: LED] , [Induction: Induction] , [Linear Flourescent: Linear Flourescent] , ...7 more... )
• lamp_watt_1 ( type: esriFieldTypeSmallInteger, alias: Lamp Wattage 1 , Coded Values: [0: Unknown] , [28: 28] , [45: 45] , ...24 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] , ...24 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] , ...24 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_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, length: 50 )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m) )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m) )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude )
• ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP )
• ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP )
• ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type )
• ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age )
• ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, length: 8 )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m) )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m) )
• ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeInteger, alias: Averaged Positions )
• ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m) )
• 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 )
• neighborhood_year ( type: esriFieldTypeString, alias: Neighborhood Year, length: 4 )
• UniqueID ( type: esriFieldTypeString, alias: UniqueID, length: 255 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• GIS_ID ( type: esriFieldTypeInteger, alias: GIS ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Supported Operations:   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata