Name: Streetlights
Display Field: PP_Owner_Name
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount: 1000
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: -1.3835105925E7
YMin: 5364544.983800001
XMax: -1.3823365409699999E7
YMax: 5374330.667000003
Spatial Reference: 102100
(3857)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Truck_Number
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: N/A
UniqueValueInfos:
-
Value: Truck 1
Label: Truck 1
Description: N/A
Symbol:
Style: esriSMSCircle
Color: [77, 120, 189, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
-
Value: Truck 2
Label: Truck 2
Description: N/A
Symbol:
Style: esriSMSCircle
Color: [113, 230, 90, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
-
Value: Truck 3
Label: Truck 3
Description: N/A
Symbol:
Style: esriSMSCircle
Color: [240, 155, 98, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
-
Value: Truck 4
Label: Truck 4
Description: N/A
Symbol:
Style: esriSMSCircle
Color: [205, 80, 217, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
-
Value: Truck 5
Label: Truck 5
Description: N/A
Symbol:
Style: esriSMSCircle
Color: [79, 214, 201, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
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
)
-
SHAPE
(
type: esriFieldTypeGeometry, alias: SHAPE
)
-
Join_Count
(
type: esriFieldTypeInteger, alias: Join_Count
)
-
TARGET_FID
(
type: esriFieldTypeInteger, alias: TARGET_FID
)
-
Audit_Status
(
type: esriFieldTypeString, alias: Audit_Status
, length: 50
, Coded Values:
[Fieldchecked: Fieldchecked]
, [Fieldchecked Added: Fieldchecked Added]
, [No Light Here: No Light Here]
, ...5 more...
)
-
Pole_Has_Number
(
type: esriFieldTypeString, alias: Pole_Has_Number
, length: 5
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Obs_Utility_ID_Num
(
type: esriFieldTypeString, alias: Obs_Utility_ID_Num
, length: 50
)
-
Obs_City_ID_Num
(
type: esriFieldTypeString, alias: Obs_City_ID_Num
, length: 50
)
-
Obs_Fixture_Ownership
(
type: esriFieldTypeString, alias: Obs_Fixture_Ownership
, length: 50
, Coded Values:
[City of Coos Bay: City of Coos Bay]
, [PacifiCorp: PacifiCorp]
, [Private: Private]
, ...2 more...
)
-
Maintained_By
(
type: esriFieldTypeString, alias: Maintained_By
, length: 50
, Coded Values:
[City of Coos Bay: City of Coos Bay]
, [PacifiCorp: PacifiCorp]
, [Private: Private]
, ...2 more...
)
-
Obs_Pole_Condition
(
type: esriFieldTypeString, alias: Obs_Pole_Condition
, length: 50
, Coded Values:
[Excellent: Excellent]
, [Fair: Fair]
, [Recommend Evaluation: Recommend Evaluation]
)
-
Mast_Arm
(
type: esriFieldTypeString, alias: Mast_Arm
, length: 5
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Obs_Mast_Arm_Length
(
type: esriFieldTypeString, alias: Obs_Mast_Arm_Length
, length: 50
, Coded Values:
[Post Top: Post Top]
, [30 In: 30 In]
, [1 to 2 Ft: 1 to 2 Ft]
, ...9 more...
)
-
Obs_Mast_Arm_Style
(
type: esriFieldTypeString, alias: Obs_Mast_Arm_ Style
, length: 50
, Coded Values:
[Integral: Integral]
, [Mura Crook: Mura Crook]
, [Truss: Truss]
, ...5 more...
)
-
Obs_Mast_Arm_Angle
(
type: esriFieldTypeSmallInteger, alias: Obs_Mast_Arm_ Angle
, Coded Values:
[0: 0]
, [15: 15]
, [30: 30]
, ...22 more...
)
-
Obs_Light_Orientation
(
type: esriFieldTypeString, alias: Obs_Light_Orientation
, length: 50
, Coded Values:
[Over Street: Over Street]
, [Over Driveway: Over Driveway]
, [Over Parking Lot: Over Parking Lot]
, ...2 more...
)
-
Obs_Pole_Type
(
type: esriFieldTypeString, alias: Obs_Pole_Type
, length: 50
, Coded Values:
[Stand-Alone Street Light: Stand-Alone Street Light]
, [Signal Luminaire: Signal Luminaire]
, [Distribution: Distribution]
, ...3 more...
)
-
Obs_Pole_Material
(
type: esriFieldTypeString, alias: Obs_Pole_Material
, length: 50
, Coded Values:
[Aluminum: Aluminum]
, [Cast Aluminum: Cast Aluminum]
, [Steel: Steel]
, ...4 more...
)
-
Obs_Pole_Color
(
type: esriFieldTypeString, alias: Obs_Pole_Color
, length: 50
, Coded Values:
[Wood: Wood]
, [Metal: Metal]
, [Black Powder Coat: Black Powder Coat]
, ...4 more...
)
-
Obs_Support_Type
(
type: esriFieldTypeString, alias: Obs_Support_Type
, length: 50
, Coded Values:
[LP Metal: LP Metal]
, [LP Wood: LP Wood]
, [PPL Wood: PPL Wood]
, ...7 more...
)
-
Obs_Fixture_Near_Powerline
(
type: esriFieldTypeString, alias: Obs_Fixture_Near_Powerline
, length: 5
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Obs_Hand_Holes
(
type: esriFieldTypeString, alias: Obs_Hand_Holes
, length: 50
, Coded Values:
[Accessible: Accessible]
, [Obstructed: Obstructed]
, [None: None]
, ...1 more...
)
-
Obs_Power_Feed
(
type: esriFieldTypeString, alias: Obs_Power_Feed
, length: 50
, Coded Values:
[Overhead: Overhead]
, [Underground: Underground]
, [Needs Verification: Needs Verification]
, ...2 more...
)
-
Setback_From_Street
(
type: esriFieldTypeDouble, alias: Setback_From_Street
)
-
Road_Classification
(
type: esriFieldTypeString, alias: Road_Classification
, length: 50
, Coded Values:
[Collector: Collector]
, [Local: Local]
, [Private/Not On Road: Private/Not On Road]
, ...3 more...
)
-
Road_Width
(
type: esriFieldTypeDouble, alias: Road_Width
)
-
Number_Of_Lanes
(
type: esriFieldTypeSmallInteger, alias: Number_Of_Lanes
, Coded Values:
[1: 1]
, [2: 2]
, [3: 3]
, ...12 more...
)
-
Light_At_Intersection
(
type: esriFieldTypeString, alias: Light_At_Intersection
, length: 5
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Intersection_Corner
(
type: esriFieldTypeString, alias: Intersection_Corner
, length: 50
, Coded Values:
[NW: NW]
, [NE: NE]
, [SE: SE]
, ...2 more...
)
-
Obs_Fixture_Type
(
type: esriFieldTypeString, alias: Obs_Fixture_Type
, length: 50
, Coded Values:
[Cobra: Cobra]
, [Flood: Flood]
, [Pendant: Pendant]
, ...15 more...
)
-
Obs_Fixture_Wattage
(
type: esriFieldTypeString, alias: Obs_Fixture_Wattage
, length: 50
, Coded Values:
[50 Watt: 50 Watt]
, [55 Watt: 55 Watt]
, [70 Watt: 70 Watt]
, ...9 more...
)
-
Obs_Fixture_Voltage
(
type: esriFieldTypeString, alias: Obs_Fixture_Voltage
, length: 50
, Coded Values:
[120: 120]
, [208: 208]
, [240: 240]
, ...4 more...
)
-
Obs_Lamp_Type
(
type: esriFieldTypeString, alias: Obs_Lamp_Type
, length: 50
, Coded Values:
[HPS: HPS]
, [LED: LED]
, [MV: MV]
, ...5 more...
)
-
Obs_Fixture_Color
(
type: esriFieldTypeString, alias: Obs_Fixture_Color
, length: 50
, Coded Values:
[White: White]
, [Grey: Grey]
, [Black: Black]
, ...3 more...
)
-
Obs_Existing_Shield
(
type: esriFieldTypeString, alias: Obs_Existing_Shield
, length: 50
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Rate_Schedule
(
type: esriFieldTypeString, alias: Rate_Schedule
, length: 50
)
-
Audit_Date
(
type: esriFieldTypeDate, alias: Audit_Date
, length: 8
)
-
Audited_By
(
type: esriFieldTypeString, alias: Audited_By
, length: 50
)
-
Audit_Notes
(
type: esriFieldTypeString, alias: Audit_Notes
, length: 250
)
-
Latitude
(
type: esriFieldTypeDouble, alias: Latitude
)
-
Longitude
(
type: esriFieldTypeDouble, alias: Longitude
)
-
Nearest_Address
(
type: esriFieldTypeString, alias: Nearest_Address
, length: 150
)
-
Proposed_Solution
(
type: esriFieldTypeString, alias: Proposed_Solution
, length: 150
)
-
Proposed_Fixture_Type
(
type: esriFieldTypeString, alias: Proposed_Fixture_Type
, length: 50
)
-
Proposed_Controls_Type
(
type: esriFieldTypeString, alias: Proposed_Controls_Type
, length: 50
)
-
Proposed_Fixture_Color
(
type: esriFieldTypeString, alias: Proposed_Fixture_Color
, length: 50
)
-
Proposed_Voltage
(
type: esriFieldTypeString, alias: Proposed_Voltage
, length: 50
)
-
Proposed_Wattage
(
type: esriFieldTypeInteger, alias: Proposed_Wattage
)
-
Proposed_Lamp_Type
(
type: esriFieldTypeString, alias: Proposed_Lamp_Type
, length: 50
)
-
Fixtures_per_Pole
(
type: esriFieldTypeSmallInteger, alias: Fixtures_per_Pole
)
-
Proposed_Shield
(
type: esriFieldTypeString, alias: Proposed_Shield
, length: 50
)
-
Installed_By
(
type: esriFieldTypeString, alias: Installed_By
, length: 50
)
-
Install_Date
(
type: esriFieldTypeDate, alias: Install_Date
, length: 8
)
-
Install_Status
(
type: esriFieldTypeString, alias: Install_Status
, length: 50
, Coded Values:
[Converted: Converted]
, [Converted With Issue: Converted With Issue]
, [To Be Converted: To Be Converted]
, ...6 more...
)
-
Install_Notes
(
type: esriFieldTypeString, alias: Install_Notes
, length: 250
, Coded Values:
[1. No Issue - Flashed: 1. No Issue - Flashed]
, [2. No Power - Utility Power Issue: 2. No Power - Utility Power Issue]
, [3. No Power - Blown Fuse at Arrival: 3. No Power - Blown Fuse at Arrival]
, ...14 more...
)
-
Install_Voltage
(
type: esriFieldTypeString, alias: Install_Voltage
, length: 50
, Coded Values:
[120: 120]
, [208: 208]
, [240: 240]
, ...3 more...
)
-
Install_Existing_Lamp_Type
(
type: esriFieldTypeString, alias: Install_Existing_Lamp_Type
, length: 50
, Coded Values:
[HPS: HPS]
, [LED: LED]
, [MV: MV]
, ...7 more...
)
-
Install_Fixture_Model_Number
(
type: esriFieldTypeString, alias: Install_Fixture_Model_Number
, length: 150
, Coded Values:
[ATB0 10BLEDE70 MVOLT R2 3K P7 PCLL NL RFD283983: ATB0 10BLEDE70 MVOLT R2 3K P7 PCLL NL RFD283983]
, [ATB0 20BLEDE53 MVOLT R2 3K P7 PCLL NL RFD283984: ATB0 20BLEDE53 MVOLT R2 3K P7 PCLL NL RFD283984]
, [ATB0 20BLEDE10 MVOLT R3 3K P7 PCLL NL RFD283985: ATB0 20BLEDE10 MVOLT R3 3K P7 PCLL NL RFD283985]
, ...10 more...
)
-
Install_Fixture_Type
(
type: esriFieldTypeString, alias: Install_Fixture_Type
, length: 50
, Coded Values:
[25W LED ATB0 10BLEDE70 PPL C70W: 25W LED ATB0 10BLEDE70 PPL C70W]
, [36W LED ATB0 20BLEDE53 PPL C100W: 36W LED ATB0 20BLEDE53 PPL C100W]
, [71W LED ATB0 20BLEDE10 PPL C150W: 71W LED ATB0 20BLEDE10 PPL C150W]
, ...6 more...
)
-
Install_Lamp_Type
(
type: esriFieldTypeString, alias: Install_Lamp_Type
, length: 50
)
-
Install_Wattage
(
type: esriFieldTypeInteger, alias: Install_Wattage
)
-
Install_Fixture_Color
(
type: esriFieldTypeString, alias: Install_Fixture_Color
, length: 50
)
-
Install_Control_type
(
type: esriFieldTypeString, alias: Install_Control_Type, length: 50
, Coded Values:
[Photo Cell: Photo Cell]
, [Shorting Cap: Shorting Cap]
, [N/A: N/A]
)
-
Install_Shield
(
type: esriFieldTypeString, alias: Install_Shield
, length: 50
, Coded Values:
[Y: Yes]
, [N: No]
)
-
Install_Shield_Orientation
(
type: esriFieldTypeString, alias: Install_Shield_Orientation
, length: 50
, Coded Values:
[House Side: House Side]
, [Street Side: Street Side]
, [Other: Other]
)
-
Install_Fuse_Replaced
(
type: esriFieldTypeString, alias: Install_Fuse_Replaced
, length: 50
, Coded Values:
[Y: Yes]
, [N: No]
)
-
Install_Functionality
(
type: esriFieldTypeString, alias: Install_Functionality
, length: 50
, Coded Values:
[Works: Works]
, [Does Not Work: Does Not Work]
, [Could Not Test: Could Not Test]
)
-
Install_Status_History
(
type: esriFieldTypeString, alias: Install_Status_History
, length: 250
)
-
Install_Status_Yesterday
(
type: esriFieldTypeString, alias: Install_Status_Yesterday
, length: 50
)
-
Audit_Status_History
(
type: esriFieldTypeString, alias: Audit_Status_History, length: 250
)
-
Audit_Status_Yesterday
(
type: esriFieldTypeString, alias: Audit_Status_Yesterday, length: 50
)
-
QC_Status
(
type: esriFieldTypeString, alias: QC_Status, length: 50
)
-
QC_Status_History
(
type: esriFieldTypeString, alias: QC_Status_History, length: 250
)
-
QC_Status_Yesterday
(
type: esriFieldTypeString, alias: QC_Status_Yesterday, length: 50
)
-
Qcd_By
(
type: esriFieldTypeString, alias: Qcd_By, length: 50
)
-
QC_Date
(
type: esriFieldTypeDate, alias: QC_Date, length: 8
)
-
Inspection_By
(
type: esriFieldTypeString, alias: Inspection_By
, length: 50
)
-
Inspection_Date
(
type: esriFieldTypeDate, alias: Inspection_Date
, length: 8
)
-
Inspection_Status
(
type: esriFieldTypeString, alias: Inspection_Status
, length: 50
)
-
Inspection_Notes
(
type: esriFieldTypeString, alias: Inspection_Notes
, length: 250
)
-
City_Asset_ID
(
type: esriFieldTypeInteger, alias: City_Asset_ID
)
-
Obs_Fix_Mount_Height
(
type: esriFieldTypeString, alias: Obs_Fix_Mount_Height
, length: 50
, Coded Values:
[12 to 15 Ft: 12 to 15 Ft]
, [16 to 19 Ft: 16 to 19 Ft]
, [20 to 24 Ft: 20 to 24 Ft]
, ...8 more...
)
-
City_Pole_Number
(
type: esriFieldTypeString, alias: City_Pole_Number, length: 50
)
-
City_Pole_Owner
(
type: esriFieldTypeString, alias: City_Pole_Owner, length: 50
)
-
City_Pole_Type
(
type: esriFieldTypeString, alias: City_Pole_Type, length: 50
)
-
City_Num_of_Heads
(
type: esriFieldTypeString, alias: City_Num_of_Heads, length: 50
)
-
City_Head_Type
(
type: esriFieldTypeString, alias: City_Head_Type, length: 50
)
-
City_Light_Watt
(
type: esriFieldTypeString, alias: City_Light_Watt, length: 50
)
-
City_Notes
(
type: esriFieldTypeString, alias: City_Notes, length: 150
)
-
City_Manufacturer
(
type: esriFieldTypeString, alias: City_Manufacturer, length: 50
)
-
PP_Owner_Name
(
type: esriFieldTypeString, alias: PP_Owner_Name, length: 50
)
-
PP_Light_Type
(
type: esriFieldTypeString, alias: PP_Light_Type, length: 50
)
-
PP_Watt
(
type: esriFieldTypeString, alias: PP_Watt, length: 50
)
-
PP_Lumens
(
type: esriFieldTypeString, alias: PP_Lumens, length: 50
)
-
PP_Connection
(
type: esriFieldTypeString, alias: PP_Connection, length: 50
)
-
PP_Rate
(
type: esriFieldTypeString, alias: PP_Rate, length: 50
)
-
PP_X
(
type: esriFieldTypeDouble, alias: PP_X
)
-
PP_Y
(
type: esriFieldTypeDouble, alias: PP_Y
)
-
PP_Formatted_ID
(
type: esriFieldTypeString, alias: PP_Formatted_ID, length: 50
)
-
City_X
(
type: esriFieldTypeDouble, alias: City_X
)
-
City_Y
(
type: esriFieldTypeDouble, alias: City_Y
)
-
PP_Distribution
(
type: esriFieldTypeString, alias: PP_Distribution, length: 50
)
-
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
)
-
Evari_Number
(
type: esriFieldTypeDouble, alias: Evari_Number
)
-
Halo_Override
(
type: esriFieldTypeString, alias: Halo_Override, length: 50
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Photo_Errors
(
type: esriFieldTypeString, alias: Photo_Errors, length: 100
)
-
Setback_From_Street_Range
(
type: esriFieldTypeString, alias: Setback_From_Street_Range, length: 50
, Coded Values:
[0-5: 0-5]
, [6-10: 6-10]
, [10-15: 10-15]
, ...3 more...
)
-
Evari_Full_Photo
(
type: esriFieldTypeString, alias: Evari_Full_Photo, length: 500
)
-
Evari_Attachment_Photo
(
type: esriFieldTypeString, alias: Evari_Attachment_Photo, length: 500
)
-
Evari_PoleID_Photo
(
type: esriFieldTypeString, alias: Evari_PoleID_Photo, length: 500
)
-
Evari_Other_Photo
(
type: esriFieldTypeString, alias: Evari_Other_Photo, length: 500
)
-
Proposed_Fixture
(
type: esriFieldTypeString, alias: Proposed_Fixture, length: 250
, Coded Values:
[25W LED ATB0 10BLEDE70 PPL C70W: 25W LED ATB0 10BLEDE70 PPL C70W]
, [36W LED ATB0 20BLEDE53 PPL C100W: 36W LED ATB0 20BLEDE53 PPL C100W]
, [71W LED ATB0 20BLEDE10 PPL C150W: 71W LED ATB0 20BLEDE10 PPL C150W]
, ...6 more...
)
-
Proposed_Fixture_Model_Number
(
type: esriFieldTypeString, alias: Proposed_Fixture_Model_Number, length: 250
, Coded Values:
[ATB0 10BLEDE70 MVOLT R2 3K P7 PCLL NL RFD283983: ATB0 10BLEDE70 MVOLT R2 3K P7 PCLL NL RFD283983]
, [ATB0 20BLEDE53 MVOLT R2 3K P7 PCLL NL RFD283984: ATB0 20BLEDE53 MVOLT R2 3K P7 PCLL NL RFD283984]
, [ATB0 20BLEDE10 MVOLT R3 3K P7 PCLL NL RFD283985: ATB0 20BLEDE10 MVOLT R3 3K P7 PCLL NL RFD283985]
, ...10 more...
)
-
Install_Color_Temperature
(
type: esriFieldTypeString, alias: Install_Color_Temperature, length: 50
)
-
Installer
(
type: esriFieldTypeString, alias: Installer, length: 50
)
-
Proposed_Needs_New_Lens
(
type: esriFieldTypeString, alias: Proposed_Needs_New_Lens, length: 50
)
-
Install_Existing_Wattage
(
type: esriFieldTypeString, alias: Install_Existing_Wattage, length: 50
, Coded Values:
[5: 5]
, [10: 10]
, [15: 15]
, ...77 more...
)
-
Installed_New_Lens
(
type: esriFieldTypeString, alias: Installed_New_Lens, length: 50
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Install_Date_Manual
(
type: esriFieldTypeDate, alias: Install_Date_Manual, length: 8
)
-
Start_Date_For_Install
(
type: esriFieldTypeDate, alias: Start_Date_For_Install, length: 8
)
-
End_Date_For_Install
(
type: esriFieldTypeDate, alias: End_Date_For_Install, length: 8
)
-
Public_Status
(
type: esriFieldTypeString, alias: Public_Status, length: 50
, Coded Values:
[Not Scheduled: Not Scheduled]
, [Changed: Changed]
, [Other: Other]
, ...3 more...
)
-
Install_Fixtures_Per_Pole
(
type: esriFieldTypeSmallInteger, alias: Install_Fixtures_Per_Pole
)
-
Proposed_Color_Temperature
(
type: esriFieldTypeString, alias: Proposed_Color_Temperature, length: 50
)
-
PageName
(
type: esriFieldTypeString, alias: PageName, length: 255
)
-
PageNumber
(
type: esriFieldTypeInteger, alias: PageNumber
)
-
Grid_Number
(
type: esriFieldTypeString, alias: Grid_Number, length: 50
)
-
Truck_Number
(
type: esriFieldTypeString, alias: Truck_Number, length: 50
)
-
Date_To_Install
(
type: esriFieldTypeDate, alias: Date, length: 8
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata