Name: Streetlights_Install

Display Field: PERSONNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 8000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 528814.5288144964

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.3781957114013672E7
YMin: 4439444.293884277
XMax: -1.3531813015808105E7
YMax: 4780752.74407959
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Install_Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: ToBeConverted28
  Label: To Be Converted 28
  Description: N/A
  Symbol:
  
• Value: ToBeConverted36
  Label: To Be Converted 36
  Description: N/A
  Symbol:
  
• Value: ToBeConverted38
  Label: To Be Converted 38
  Description: N/A
  Symbol:
  
• Value: ToBeConverted39
  Label: To Be Converted 39
  Description: N/A
  Symbol:
  
• Value: ToBeConverted41
  Label: To Be Converted 41
  Description: N/A
  Symbol:
  
• Value: ToBeConverted53
  Label: To Be Converted 53
  Description: N/A
  Symbol:
  
• Value: ToBeConverted71
  Label: To Be Converted 71
  Description: N/A
  Symbol:
  
• Value: ToBeConverted72
  Label: To Be Converted 72
  Description: N/A
  Symbol:
  
• Value: ToBeConverted81
  Label: To Be Converted 81
  Description: N/A
  Symbol:
  
• Value: ToBeConverted88
  Label: To Be Converted 88
  Description: N/A
  Symbol:
  
• Value: ToBeConverted92
  Label: To Be Converted 92
  Description: N/A
  Symbol:
  
• Value: ToBeConverted113
  Label: To Be Converted 113
  Description: N/A
  Symbol:
  
• Value: ToBeConverted141
  Label: To Be Converted 141
  Description: N/A
  Symbol:
  
• Value: ToBeConverted209
  Label: To Be Converted 209
  Description: N/A
  Symbol:
  
• Value: Converted
  Label: Converted
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 255, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: ConvertedGroundWirePresent
  Label: Converted and Ground Wire Present
  Description: N/A
  Symbol:
  
• Value: ConvertedGroundWireCityIssue
  Label: Converted with Ground Wire Present and City Issue
  Description: N/A
  Symbol:
  
• Value: ConvertedInstIssue
  Label: Converted Installer Issue
  Description: N/A
  Symbol:
  
• Value: ConvertedPGEIssue
  Label: Converted PGE Issue
  Description: N/A
  Symbol:
  
• Value: ConvertedCityIssue
  Label: Converted City Issue
  Description: N/A
  Symbol:
  
• Value: Not Converted Installer Issue
  Label: Not Converted Installer Issue
  Description: N/A
  Symbol:
  
• Value: Not Converted PGE Issue
  Label: Not Converted PGE Issue
  Description: N/A
  Symbol:
  
• Value: NotConvertedCityIssue
  Label: Not Converted City Issue
  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: 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:

• Install_Status ( type: esriFieldTypeString, alias: Install_Status, length: 50 , Coded Values: [ToBeConverted92: To Be Converted 92] , [OutOfScope: Out Of Scope] , [Converted: Converted] , ...21 more... )
• NewItemCode ( type: esriFieldTypeString, alias: NewItemCode, length: 50 , Coded Values: [S-LD-53: 53 Watt LED] , [S-LD-81: 81 Watt LED] , [S-LD-28: 28 Watt LED] , ...7 more... )
• Corrected_Badge_Number ( type: esriFieldTypeString, alias: Corrected_Badge_Number, length: 50 )
• Pole_Needs_Numbering ( type: esriFieldTypeString, alias: Pole Needs Numbering, length: 100 )
• Installed_By ( type: esriFieldTypeString, alias: Installed By, length: 50 )
• Install_Date ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• City_Notes ( type: esriFieldTypeString, alias: City_Notes, length: 250 )
• Installer_Notes ( type: esriFieldTypeString, alias: Installer_Notes, length: 250 )
• PGEInstallNotes ( type: esriFieldTypeString, alias: PGEInstallNotes, length: 250 )
• Turnkey_Candidate ( type: esriFieldTypeString, alias: Turnkey_Candidate, length: 50 )
• New_Fixture_Part_Number ( type: esriFieldTypeString, alias: New_Fixture_Part_Number, length: 250 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Audit_Status ( type: esriFieldTypeString, alias: Audit_Status, length: 50 , Coded Values: [Fieldchecked: Fieldchecked] , [Fieldchecked Added: Fieldchecked Added] , [No Light Here: No Light Here] , ...10 more... )
• Obs_Badge_Number ( type: esriFieldTypeString, alias: Obs_Badge_Number, length: 50 )
• Obs_Fixture_Model ( type: esriFieldTypeString, alias: Obs_Fixture_Model, length: 50 , Coded Values: [Cobrahead: Cobrahead] , [Double Cobrahead: Double Cobrahead] , [Barn Light: Barn Light] , ...15 more... )
• Obs_Item_Code ( type: esriFieldTypeString, alias: Obs_Item_Code, length: 50 , Coded Values: [S-H-35: High Pressure - 35W 2150L SL] , [S-H-50: High Pressure - 50W 3800L SL] , [S4H-50: 240V-High Pressure - 50W 3800L] , ...133 more... )
• Obs_Pole_Height ( type: esriFieldTypeString, alias: Obs_Pole_Height, length: 50 , Coded Values: [30-34 FT: 30-34 FT] , [25-29 FT: 25-29 FT] , [OVER 40 FT: OVER 40 FT] , ...7 more... )
• Obs_Pole_Material ( type: esriFieldTypeString, alias: Obs_Pole_Material, length: 50 , Coded Values: [GALVANIZED: Galvanized Pole] , [STANDARD WOOD: Standard Wood Pole] , [STEEL: Steel Pole] , ...8 more... )
• Obs_Mast_Arm_Type ( type: esriFieldTypeString, alias: Obs_Mast_Arm_Type, length: 50 , Coded Values: [8 FT: 8 FT] , [10 FT OR 12 FT: 10 FT OR 12 FT] , [6 FT: 6 FT] , ...7 more... )
• Obs_Pole_Use ( type: esriFieldTypeString, alias: Obs_Pole_Use, length: 50 , Coded Values: [CUST OWNED: Customer Owned] , [DISTRIBUTION: Distribution] , [NONE: None] , ...2 more... )
• Obs_Service ( type: esriFieldTypeString, alias: Obs_Service, length: 10 , Coded Values: [N: Overhead] , [Y: Underground] )
• Obs_Rate_Schedule ( type: esriFieldTypeString, alias: Obs_Rate_Schedule, length: 25 , Coded Values: [LS2-A: LS2-A] , [LS1-A: LS1-A] , [LS1-E: LS1-E] , ...6 more... )
• Obs_Painted_Pole ( type: esriFieldTypeString, alias: Obs_Painted_Pole, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Audit_Notes ( type: esriFieldTypeString, alias: Audit_Notes, length: 250 )
• MaintNote ( type: esriFieldTypeString, alias: MaintNote, length: 30 , Coded Values: [REGPC: REGPC] , [RED CAP: RED CAP] , [STREAMLINE: STREAMLINE] , ...17 more... )
• FAR1 ( type: esriFieldTypeString, alias: FAR1, length: 30 , Coded Values: [POLE NEEDS NUMBERING: POLE NEEDS NUMBERING] , [DAY BURNER: DAY BURNER] , [CYCLING LIGHT: CYCLING LIGHT] , ...19 more... )
• FAR2 ( type: esriFieldTypeString, alias: FAR2, length: 30 , Coded Values: [POLE NEEDS NUMBERING: POLE NEEDS NUMBERING] , [DAY BURNER: DAY BURNER] , [CYCLING LIGHT: CYCLING LIGHT] , ...19 more... )
• FAR3 ( type: esriFieldTypeString, alias: FAR3, length: 30 , Coded Values: [POLE NEEDS NUMBERING: POLE NEEDS NUMBERING] , [DAY BURNER: DAY BURNER] , [CYCLING LIGHT: CYCLING LIGHT] , ...19 more... )
• FAROther ( type: esriFieldTypeString, alias: FAROther, length: 30 )
• Fappliance ( type: esriFieldTypeString, alias: Fappliance, length: 25 , Coded Values: [TRAFFIC FLASHERS: TRAFFIC FLASHERS] , [TRAFFIC SIGNAL: TRAFFIC SIGNAL] , [BUS SHELTER: BUS SHELTER] , ...10 more... )
• FAppliance2 ( type: esriFieldTypeString, alias: FAppliance2, length: 25 , Coded Values: [TRAFFIC FLASHERS: TRAFFIC FLASHERS] , [TRAFFIC SIGNAL: TRAFFIC SIGNAL] , [BUS SHELTER: BUS SHELTER] , ...10 more... )
• FAppliance3 ( type: esriFieldTypeString, alias: FAppliance3, length: 25 , Coded Values: [TRAFFIC FLASHERS: TRAFFIC FLASHERS] , [TRAFFIC SIGNAL: TRAFFIC SIGNAL] , [BUS SHELTER: BUS SHELTER] , ...10 more... )
• FAppliance4 ( type: esriFieldTypeString, alias: FAppliance4, length: 255 , Coded Values: [TRAFFIC FLASHERS: TRAFFIC FLASHERS] , [TRAFFIC SIGNAL: TRAFFIC SIGNAL] , [BUS SHELTER: BUS SHELTER] , ...10 more... )
• FAppliance5 ( type: esriFieldTypeString, alias: FAppliance5, length: 5 )
• Final_Address ( type: esriFieldTypeString, alias: Final_Address, length: 150 )
• Obs_Map_Number ( type: esriFieldTypeString, alias: Obs_Map_Number, length: 50 )
• Transactn ( type: esriFieldTypeString, alias: Transaction, length: 10 )
• Evari_Number ( type: esriFieldTypeInteger, alias: Evari_Number )
• Audited_By ( type: esriFieldTypeString, alias: Audited_By, length: 25 )
• Audit_Date ( type: esriFieldTypeDate, alias: Audit_Date, length: 8 )
• QC_Notes ( type: esriFieldTypeString, alias: QC_Notes, length: 250 )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• PERSONNAME ( type: esriFieldTypeString, alias: PERSONNAME, length: 50 )
• BADGENUM ( type: esriFieldTypeString, alias: BADGENUM, length: 30 )
• FX_CODE ( type: esriFieldTypeString, alias: FX_CODE, length: 30 , Coded Values: [1: 1st Light on Pole] , [2: 2nd Light on Pole] , [3: 3rd Light on Pole] , ...7 more... )
• STATUSFLAG ( type: esriFieldTypeString, alias: STATUSFLAG, length: 6 )
• REC_DATE ( type: esriFieldTypeDate, alias: REC_DATE, length: 8 )
• INS_DATE ( type: esriFieldTypeDate, alias: INS_DATE, length: 8 )
• COP_DATE ( type: esriFieldTypeDate, alias: COP_DATE, length: 8 )
• SP_ID ( type: esriFieldTypeString, alias: SP_ID, length: 10 )
• GIS_ID ( type: esriFieldTypeString, alias: GIS_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 50 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 50 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Conversion_Zone ( type: esriFieldTypeString, alias: Conversion_Zone, length: 50 )
• CoSJ_FACILITYID ( type: esriFieldTypeInteger, alias: CoSJ_FACILITYID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Obs_Fixture_Clearance_Issue ( type: esriFieldTypeString, alias: Obs_Fixture_Clearance_Issue, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• Obs_Fixture_Height ( type: esriFieldTypeString, alias: Obs_Fixture_Height, length: 50 , Coded Values: [30-34 FT: 30-34 FT] , [25-29 FT: 25-29 FT] , [OVER 40 FT: OVER 40 FT] , ...7 more... )
• Obs_Mast_Arm_Direction ( type: esriFieldTypeSmallInteger, alias: Obs_Mast_Arm_Direction , Coded Values: [45: NE] , [90: E] , [135: SE] , ...6 more... )
• Link_To_Google_Maps ( type: esriFieldTypeString, alias: Link_To_Google_Maps, length: 250 )
• Link_To_Full_Photo ( type: esriFieldTypeString, alias: Link_To_Full_Photo, length: 250 )
• Install_Issue_1 ( type: esriFieldTypeString, alias: Install_Issue_1, length: 100 , Coded Values: [Corrected Badge Number: Corrected Badge Number] , [Loose arm: Loose arm] , [Pole Loose: Pole Loose] , ...26 more... )
• Install_Issue_2 ( type: esriFieldTypeString, alias: Install_Issue_2, length: 100 , Coded Values: [Corrected Badge Number: Corrected Badge Number] , [Loose arm: Loose arm] , [Pole Loose: Pole Loose] , ...26 more... )
• Install_Issue_3 ( type: esriFieldTypeString, alias: Install_Issue_3, length: 100 , Coded Values: [Corrected Badge Number: Corrected Badge Number] , [Loose arm: Loose arm] , [Pole Loose: Pole Loose] , ...26 more... )
• Install_Status_Yesterday ( type: esriFieldTypeString, alias: Install_Status_Yesterday, length: 50 )
• Install_Status_History ( type: esriFieldTypeString, alias: Install_Status_History, length: 250 )
• City_Resolved_Issue ( type: esriFieldTypeString, alias: City_Resolved_Issue, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Final_BADGENUM ( type: esriFieldTypeString, alias: Final_BADGENUM, length: 50 )
• Revisit_Status ( type: esriFieldTypeString, alias: Revisit_Status , length: 50 , Coded Values: [To Be Revisited: To Be Revisited] , [Revisit Complete: Revisit Complete] , [Unable to Revisit Light: Unable to Revisit Light] , ...2 more... )
• New_Wood_Pole_Present ( type: esriFieldTypeString, alias: New_Wood_Pole_Present , length: 50 , Coded Values: [New Wood Pole: New Wood Pole] , [Old Wood Pole: Old Wood Pole] , [Not Sure: Not Sure] , ...1 more... )
• Revisit_Notes ( type: esriFieldTypeString, alias: Revisit_Notes, length: 250 )
• Revisit_Date ( type: esriFieldTypeDate, alias: Revisit_Date, length: 8 )
• Revisited_By ( type: esriFieldTypeString, alias: Revisited_By, length: 50 )
• Link_NLH_WoodPole_Photo ( type: esriFieldTypeString, alias: Link_NLH_WoodPole_Photo, length: 150 )
• Badge_Change ( type: esriFieldTypeString, alias: Badge_Change, length: 50 , Coded Values: [Yes: Yes] , [No Number: No Number] , [Partial Match: Partial Match] )
• Lamp_Size_Change ( type: esriFieldTypeString, alias: Lamp_Size_Change, length: 50 , Coded Values: [True: True] , [False: False] )
• Item_Code_Disc_Desc ( type: esriFieldTypeString, alias: Item Code Discrepency Description, length: 150 )
• NN_Add_Confirm ( type: esriFieldTypeString, alias: NN_Add_Confirm, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Review_Status ( type: esriFieldTypeString, alias: Review_Status, length: 50 , Coded Values: [To Be Reviewed: To Be Reviewed] , [In Progress: In Progress] , [Reviewed: Reviewed] )
• City_Lamp_Type ( type: esriFieldTypeString, alias: City_Lamp_Type, length: 50 , Coded Values: [LED: LED] , [HPS: HPS] , [Induction: Induction] , ...2 more... )
• City_Badge ( type: esriFieldTypeString, alias: City_Badge, length: 50 )
• PGE_Response ( type: esriFieldTypeString, alias: PGE_Response, length: 250 )
• CityReviewStatusYest ( type: esriFieldTypeString, alias: CityReviewStatusyest, length: 50 )
• CityReviewStatusHist ( type: esriFieldTypeString, alias: CityReviewStatusHistory, length: 250 )
• City_Wattage ( type: esriFieldTypeInteger, alias: City_Wattage )
• Verify ( type: esriFieldTypeString, alias: Verify, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Verify_Date ( type: esriFieldTypeDate, alias: Verify Date, length: 8 )
• BRIO_Update_Needed ( type: esriFieldTypeString, alias: BRIO_Update_Needed, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• CoSJ_Accept_Resp ( type: esriFieldTypeString, alias: City of San Jose Accepts Financial Responsibility, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Exisiting_SA ( type: esriFieldTypeString, alias: Exisiting_SA, length: 20 )
• Zone_Status ( type: esriFieldTypeString, alias: Zone_Status, length: 50 )
• Add_COSJ_Confirmed ( type: esriFieldTypeString, alias: Add_COSJ_Confirmed, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Evari_Comments ( type: esriFieldTypeString, alias: Evari_Comments, length: 250 )
• Audit_Result ( type: esriFieldTypeString, alias: Audit_Result, length: 50 , Coded Values: [Fieldchecked: Fieldchecked] , [Fieldchecked Added: Fieldchecked Added] , [Light Not in Field: Light Not in Field] , ...8 more... )
• Abolish_SP ( type: esriFieldTypeString, alias: Abolish SP?, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Flagged: Flagged] )
• J6HF_Notes ( type: esriFieldTypeString, alias: J6HF_Notes, length: 500 )
• Combined_Update_Responsibility ( type: esriFieldTypeString, alias: CombinedBRIO Update Needed and City Accepted Responsibility, length: 50 )

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

  Iteminfo   Thumbnail   Metadata