Name: Park Lighting Assets

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

Supported Query Formats: JSON, geoJSON

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: 3136550.9386419654
YMin: 1734933.2405594736
XMax: 3169347.040372476
YMax: 1789579.7634840608
Spatial Reference: 102654  (2232)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Requires_Review
Field 2: Owner
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Light Pole,City of Thornton
  Label: Light Pole, City of Thornton
  Description:
  Symbol:
  
• Value: Not Reviewed,
  Label: Not Reviewed, Owner Missing
  Description:
  Symbol:
  
• Value: Not Reviewed,City of Thornton
  Label: Not Reviewed, City of Thornton
  Description:
  Symbol:
  
• Value: Not Reviewed,Private
  Label: Not Reviewed, Private
  Description:
  Symbol:
  
• Value: Not Reviewed,United Power
  Label: Not Reviewed, United Power
  Description:
  Symbol:
  
• Value: Not Reviewed,Xcel Energy
  Label: Not Reviewed, Xcel Energy
  Description:
  Symbol:
  
• Value: Reviewed - Has Issue(s),
  Label: Reviewed - Has Issue(s), Owner Missing
  Description:
  Symbol:
  
• Value: Reviewed - Has Issue(s),City of Thornton
  Label: Reviewed - Has Issue(s), City of Thornton
  Description:
  Symbol:
  
• Value: Reviewed - Has Issue(s),Private
  Label: Reviewed - Has Issue(s), Private
  Description:
  Symbol:
  
• Value: Reviewed - Has Issue(s),United Power
  Label: Reviewed - Has Issue(s), United Power
  Description:
  Symbol:
  
• Value: Reviewed - Has Issue(s),Xcel Energy
  Label: Reviewed - Has Issue(s), Xcel Energy
  Description:
  Symbol:
  
• Value: Reviewed - Issue(s) Resolved,
  Label: Reviewed - Issue(s) Resolved, Owner Missing
  Description:
  Symbol:
  
• Value: Reviewed - Issue(s) Resolved,City of Thornton
  Label: Reviewed - Issue(s) Resolved, City of Thornton
  Description:
  Symbol:
  
• Value: Reviewed - Issue(s) Resolved,Private
  Label: Reviewed - Issue(s) Resolved, Private
  Description:
  Symbol:
  
• Value: Reviewed - Issue(s) Resolved,Xcel Energy
  Label: Reviewed - Issue(s) Resolved, Xcel Energy
  Description:
  Symbol:
  
• Value: Reviewed - Issue(s) Resolved,United Power
  Label: Reviewed - Issue(s) Resolved, United Power
  Description:
  Symbol:
  
• Value: Reviewed - No Issue(s),
  Label: Reviewed - No Issue(s), Missing Owner
  Description:
  Symbol:
  
• Value: Reviewed - No Issue(s),City of Thornton
  Label: Reviewed - No Issue(s), City of Thornton
  Description:
  Symbol:
  
• Value: Reviewed - No Issue(s),Private
  Label: Reviewed - No Issue(s), Private
  Description:
  Symbol:
  
• Value: Reviewed - No Issue(s),Xcel Energy
  Label: Reviewed - No Issue(s), Xcel Energy
  Description:
  Symbol:
  
• Value: Reviewed - No Issue(s),United Power
  Label: Reviewed - No Issue(s), United Power
  Description:
  Symbol:
  
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

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: [Not Reviewed: Not Reviewed] , [Reviewed - Has Issue(s): Reviewed - Has Issue(s)] , [Reviewed - No Issue(s): Reviewed - No Issue(s)] , ...2 more... )
• Ward ( type: esriFieldTypeString, alias: Ward, length: 255 )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 255 , Coded Values: [City of Thornton: City of Thornton] , [Private: Private] , [United Power: United Power] , ...1 more... )
• Street_Type ( type: esriFieldTypeString, alias: Street Type, length: 255 , Coded Values: [Arterial: Arterial] , [Athletic Field: Athletic Field] , [Collector: Collector] , ...6 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] , ...1 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: [Underpass Light: Underpass Light] , [Streetlight: Streetlight] , [Pedestrian Light: Pedestrian Light] , ...2 more... )
• Pole_Type ( type: esriFieldTypeString, alias: Pole Mount Type, length: 255 , Coded Values: [Wall Mount: Wall Mount] , [Utility Distribution: Utility Distribution] , [Traffic Signal Mounted: Traffic Signal Mounted] , ...3 more... )
• Pole_Material ( type: esriFieldTypeString, alias: Pole Material, length: 255 , Coded Values: [Aluminum: Aluminum] , [Concrete: Concrete] , [Fiberglass: Fiberglass] , ...3 more... )
• Pole_Color ( type: esriFieldTypeString, alias: Pole Color, length: 255 )
• Pole_Height ( type: esriFieldTypeString, alias: Pole Height, length: 50 )
• Pole_Foundation ( type: esriFieldTypeString, alias: Pole Foundation, length: 255 , Coded Values: [Concete - Below Grade: Concete - Below Grade] , [Concrete - Near Grade: Concrete - Near Grade] , [Concrete - Raised Foundation: Concrete - Raised Foundation] , ...2 more... )
• Pole_Base ( type: esriFieldTypeString, alias: Pole Base, length: 255 )
• Pole_Condition ( type: esriFieldTypeString, alias: Pole Condition, length: 255 , Coded Values: [High Priority: High Priority] , [Moderate: Moderate] , [Fair: Fair] , ...2 more... )
• Mast_Arms ( type: esriFieldTypeSmallInteger, alias: No. of Mast Arms )
• Number_Fixtures ( type: esriFieldTypeSmallInteger, alias: Number of Fixtures )
• Power_Source ( type: esriFieldTypeString, alias: Power Source to Light, length: 50 )
• 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 )
• Conduit_Material ( type: esriFieldTypeString, alias: Conduit Material, length: 50 )
• Line_Damage ( type: esriFieldTypeString, alias: Damage to Line, length: 50 )
• Utility_Elec_Dist ( type: esriFieldTypeString, alias: Utility Electric Distribution, length: 50 )
• Splice_Box ( type: esriFieldTypeString, alias: Splice Box, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Flashing_Light ( type: esriFieldTypeString, alias: Flashing Light, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Speed_Sign ( type: esriFieldTypeString, alias: Speed Sign, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Power_Receptacle ( type: esriFieldTypeString, alias: Power Receptacle, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Camera ( type: esriFieldTypeString, alias: Camera, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Antenna ( type: esriFieldTypeString, alias: Antenna, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Traffic_Control ( type: esriFieldTypeString, alias: Traffic Control, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Small_Cell ( type: esriFieldTypeString, alias: Small Cell, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Siren ( type: esriFieldTypeString, alias: Siren, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Solar_Panel ( type: esriFieldTypeString, alias: Solar Panel, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Other_Attachments ( type: esriFieldTypeString, alias: Other Attachments, length: 50 , Coded Values: [Y: Yes] , [N: 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] , [Broken: Broken] , [Day Burner: Day Burner] , ...3 more... )
• Fixture_Mount_Ht_1 ( type: esriFieldTypeString, alias: Fixture Mount Height 1, length: 50 )
• Mast_Arm_Type_1 ( type: esriFieldTypeString, alias: Mast Arm Type 1, length: 50 )
• Mast_Arm_Length_1 ( type: esriFieldTypeString, alias: Mast Arm Length 1, length: 50 )
• Fixture_Direction_1 ( type: esriFieldTypeString, alias: Fixture Direction 1, length: 50 )
• Fixture_Type_1 ( type: esriFieldTypeString, alias: Fixture Type 1, length: 50 )
• Lamp_Type_1 ( type: esriFieldTypeString, alias: Lamp Type 1, length: 50 , Coded Values: [High Pressure Sodium: High Pressure Sodium] , [Incandescent: Incandescent] , [LED: LED] , ...1 more... )
• Lamp_Watt_1 ( type: esriFieldTypeSmallInteger, alias: Lamp Wattage 1 )
• Photoelectric_Cell_1 ( type: esriFieldTypeString, alias: Photoelectric Cell 1, length: 50 )
• Photocell_Pin_Count_1 ( type: esriFieldTypeString, alias: Photocell Pin Count 1, length: 50 )
• Fixture_Condition_2 ( type: esriFieldTypeString, alias: Fixture Condition 2, length: 50 , Coded Values: [Good: Good] , [Broken: Broken] , [Day Burner: Day Burner] , ...3 more... )
• Fixture_Mount_ht_2 ( type: esriFieldTypeString, alias: Fixture Mount Height 2, length: 50 )
• Mast_Arm_Type_2 ( type: esriFieldTypeString, alias: Mast Arm Type 2, length: 50 )
• Mast_Arm_Length_2 ( type: esriFieldTypeString, alias: Mast Arm Length 2, length: 50 )
• Fixture_Direction_2 ( type: esriFieldTypeString, alias: Fixture Direction 2, length: 50 )
• Fixture_Type_2 ( type: esriFieldTypeString, alias: Fixture Type 2, length: 50 )
• Lamp_Type_2 ( type: esriFieldTypeString, alias: Lamp Type 2, length: 50 , Coded Values: [High Pressure Sodium: High Pressure Sodium] , [Incandescent: Incandescent] , [LED: LED] , ...1 more... )
• Lamp_Watt_2 ( type: esriFieldTypeSmallInteger, alias: Lamp Wattage 2 )
• Photoelectric_Cell_2 ( type: esriFieldTypeString, alias: Photoelectric Cell 2, length: 50 )
• Photocell_Pin_Count_2 ( type: esriFieldTypeString, alias: Photocell Pin Count 2, length: 50 )
• Fixture_Condition_3 ( type: esriFieldTypeString, alias: Fixture Condition 3, length: 50 , Coded Values: [Good: Good] , [Broken: Broken] , [Day Burner: Day Burner] , ...3 more... )
• Fixture_Mount_Ht_3 ( type: esriFieldTypeString, alias: Fixture Mount Height 3, length: 50 )
• Mast_Arm_Type_3 ( type: esriFieldTypeString, alias: Mast Arm Type 3, length: 50 )
• Mast_Arm_Length_3 ( type: esriFieldTypeString, alias: Mast Arm Length 3, length: 50 )
• Fixture_Direction_3 ( type: esriFieldTypeString, alias: Fixture Direction 3, length: 50 )
• Fixture_Type_3 ( type: esriFieldTypeString, alias: Fixture Type 3, length: 50 )
• Lamp_Type_3 ( type: esriFieldTypeString, alias: Lamp Type 3, length: 50 , Coded Values: [High Pressure Sodium: High Pressure Sodium] , [Incandescent: Incandescent] , [LED: LED] , ...1 more... )
• Lamp_Watt_3 ( type: esriFieldTypeSmallInteger, alias: Lamp Wattage 3 )
• Photoelectric_Cell_3 ( type: esriFieldTypeString, alias: Photoelectric Cell 3, length: 50 )
• Photocell_Pin_Count_3 ( type: esriFieldTypeString, alias: Photocell Pin Count 3, length: 50 )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude )
• 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 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )

Relationships:

• ParkLightingIssues (0) -- Related To: Issues (1)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata