Name: Streetlights_Inventory

Display Field: PERSONNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 5000

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: -122.51379522499997
YMin: 37.651689943000065
XMax: -122.30086991999997
YMax: 37.88134993500006
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: AuditStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Fieldchecked
  Label: Fieldchecked
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 170, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Flagged
  Label: Flag For Review
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 127, 127, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: RMCReview
  Label: For RMC Review
  Description: N/A
  Symbol:
  
• Value: NoAction
  Label: No Action
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: OutOfScope
  Label: Out Of Scope
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [204, 204, 204, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Delete
  Label: Remove
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [115, 223, 255, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• OFFICE ( type: esriFieldTypeString, alias: Office, length: 8 )
• PERSONNAME ( type: esriFieldTypeString, alias: Person Name, length: 50 )
• ACCTNUM ( type: esriFieldTypeString, alias: Account Number, length: 10 )
• BADGENUM ( type: esriFieldTypeString, alias: Badge Number, length: 30 )
• FX_CODE ( type: esriFieldTypeString, alias: Fixture Code, length: 30 , Coded Values: [0: Painted pole] , [1: 1st light on multi-light pole] , [2: 2nd light on multi-light pole] , ...7 more... )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 2 , Coded Values: [A: Active] , [O: Ordered] , [R: Retired] )
• STATUSFLAG ( type: esriFieldTypeString, alias: STATUSFLAG, length: 6 )
• REC_DATE ( type: esriFieldTypeDate, alias: REC_DATE, length: 8 )
• RET_DATE ( type: esriFieldTypeDate, alias: RET_DATE, length: 8 )
• INS_DATE ( type: esriFieldTypeDate, alias: INS_DATE, length: 8 )
• REM_DATE ( type: esriFieldTypeDate, alias: REM_DATE, length: 8 )
• COP_DATE ( type: esriFieldTypeDate, alias: COP_DATE, length: 8 )
• DESC_ADDR ( type: esriFieldTypeString, alias: Descriptive Address, length: 80 )
• MAPNUMBER ( type: esriFieldTypeString, alias: Map Number, length: 50 )
• RATE_SCHED ( type: esriFieldTypeString, alias: Observed Rate Schedule, length: 8 , Coded Values: [LS1-A: LS1-A] , [LS1-C: LS1-C] , [LS1-E: LS1-E] , ...8 more... )
• ITEM_CODE ( type: esriFieldTypeString, alias: Observed Type Wattage, length: 30 , Coded Values: [S4H-50: 240V-High Pressure - 50W 3800L] , [S4H-70: 240V-High Pressure - 70W 5800L] , [S4H-100: 240V-High Pressure -100W 9500L] , ...368 more... )
• OP_SCHED ( type: esriFieldTypeDouble, alias: OP_SCHED )
• SERVICE ( type: esriFieldTypeString, alias: Service (Overhead/ Underground), length: 16 , Coded Values: [N: Overhead] , [Y: Underground] )
• FX_MAN ( type: esriFieldTypeString, alias: Observed Fixture Manufacturer, length: 30 , Coded Values: [UK: Unknown] , [GE: General Electric] , [HP: Holophane] , ...7 more... )
• POLE_TYPE ( type: esriFieldTypeString, alias: Observed Pole Material, length: 30 , Coded Values: [CENTER BORE WOOD: Center Bore Wood Pole] , [STANDARD WOOD: Standard Wood Pole] , [STEEL: Steel Pole] , ...8 more... )
• POLE_LGTH ( type: esriFieldTypeString, alias: Observed Pole Length, length: 30 , Coded Values: [16-19 FT: 16-19 FT] , [25-29 FT: 25-29 FT] , [40 FT: 40 FT] , ...7 more... )
• SUSPENSION ( type: esriFieldTypeString, alias: Observed Suspension, length: 30 , Coded Values: [POST TOP: Post Top] , [30 INCHES: 30 In Bracket or Arm] , [6 FT: 6 Ft Bracket or Arm] , ...7 more... )
• POLE_USE ( type: esriFieldTypeString, alias: Observed Pole Use, length: 30 , Coded Values: [CUST OWNED: Customer Owned] , [DISTRIBUTION: Distribution] , [NONE: None] , ...2 more... )
• SP_ID ( type: esriFieldTypeString, alias: SP_ID, length: 10 )
• SA_ID ( type: esriFieldTypeString, alias: SA_ID, length: 10 )
• PREM_ID ( type: esriFieldTypeString, alias: PREM_ID, length: 10 )
• TOT_CODE ( type: esriFieldTypeString, alias: TOT_CODE, length: 16 )
• TOT_TERR ( type: esriFieldTypeString, alias: TOT_TERR, length: 30 )
• INV_DATE ( type: esriFieldTypeDate, alias: Audit Date, length: 8 )
• INV_BY ( type: esriFieldTypeString, alias: Audited By, length: 30 )
• SPITEMHIST ( type: esriFieldTypeString, alias: SPITEMHIST, length: 10 )
• UNIQUESPID ( type: esriFieldTypeString, alias: UNIQUESPID, length: 50 )
• GIS_ID ( type: esriFieldTypeString, alias: GIS_ID, length: 12 )
• BLCH_DATE ( type: esriFieldTypeDate, alias: BLCH_DATE, length: 8 )
• LMCH_DATE ( type: esriFieldTypeDate, alias: LMCH_DATE, length: 8 )
• LINESHARE ( type: esriFieldTypeString, alias: LINESHARE, length: 16 )
• LITE_SIZE ( type: esriFieldTypeString, alias: LITE_SIZE, length: 16 )
• LITE_TYPE ( type: esriFieldTypeString, alias: LITE_TYPE, length: 16 )
• LUCH_DATE ( type: esriFieldTypeDate, alias: LUCH_DATE, length: 8 )
• PCCH_DATE ( type: esriFieldTypeDate, alias: PCCH_DATE, length: 8 )
• PCELL ( type: esriFieldTypeString, alias: PCELL, length: 16 )
• POCH_DATE ( type: esriFieldTypeDate, alias: POCH_DATE, length: 8 )
• PTCH_DATE ( type: esriFieldTypeDate, alias: PTCH_DATE, length: 8 )
• STRT_CH_DT ( type: esriFieldTypeDate, alias: STRT_CH_DT, length: 8 )
• LITESIZE ( type: esriFieldTypeString, alias: LITESIZE, length: 16 )
• LITETYPE ( type: esriFieldTypeString, alias: LITETYPE, length: 16 )
• HALFHRADJ ( type: esriFieldTypeString, alias: HALFHRADJ, length: 16 )
• MAIL_ADDR1 ( type: esriFieldTypeString, alias: MAIL_ADDR1, length: 80 )
• MAIL_ADDR2 ( type: esriFieldTypeString, alias: MAIL_ADDR2, length: 80 )
• MAIL_CITY ( type: esriFieldTypeString, alias: MAIL_CITY, length: 50 )
• MAILSTATE ( type: esriFieldTypeString, alias: MAILSTATE, length: 2 )
• MAIL_ZIP ( type: esriFieldTypeString, alias: MAIL_ZIP, length: 5 )
• NEWBADGE ( type: esriFieldTypeString, alias: NEWBADGE, length: 30 )
• FMETRICOM ( type: esriFieldTypeString, alias: FMETRICOM, length: 30 , Coded Values: [G1: G1] , [G1D: G1D] , [G2: G2] , ...1 more... )
• FREVENUE ( type: esriFieldTypeString, alias: FREVENUE, length: 30 , Coded Values: [SUSPECTED DIVERSION: SUSPECTED DIVERSION] )
• FAR1 ( type: esriFieldTypeString, alias: FAR1, length: 30 , Coded Values: [Tree Trimming Needed: Tree Trimming Needed] , [No Power: No Power] , [Bad Wiring: Bad Wiring/ Missing Wiring] , ...15 more... )
• FAR2 ( type: esriFieldTypeString, alias: FAR2, length: 30 , Coded Values: [DAY BURNER: DAY BURNER] , [CYCLING LIGHT: CYCLING LIGHT] , [FOUNDATION ONLY: FOUNDATION ONLY] , ...18 more... )
• FAR3 ( type: esriFieldTypeString, alias: FAR3, length: 30 , Coded Values: [DAY BURNER: DAY BURNER] , [CYCLING LIGHT: CYCLING LIGHT] , [FOUNDATION ONLY: FOUNDATION ONLY] , ...18 more... )
• FAROTHER ( type: esriFieldTypeString, alias: FAROTHER, length: 30 )
• MAINTNOTE ( type: esriFieldTypeString, alias: MAINTNOTE, length: 30 )
• FAPPL1 ( type: esriFieldTypeString, alias: FAPPL1, length: 50 , Coded Values: [BUS SHELTER: BUS SHELTER] , [CAMERA: CAMERA] , [IRRIGATION: IRRIGATION] , ...12 more... )
• FAPPL2 ( type: esriFieldTypeString, alias: FAPPL2, length: 50 , Coded Values: [BUS SHELTER: BUS SHELTER] , [CAMERA: CAMERA] , [IRRIGATION: IRRIGATION] , ...12 more... )
• FAPPL3 ( type: esriFieldTypeString, alias: FAPPL3, length: 50 , Coded Values: [BUS SHELTER: BUS SHELTER] , [CAMERA: CAMERA] , [IRRIGATION: IRRIGATION] , ...12 more... )
• FAPPL4 ( type: esriFieldTypeString, alias: FAPPL4, length: 50 , Coded Values: [BUS SHELTER: BUS SHELTER] , [CAMERA: CAMERA] , [IRRIGATION: IRRIGATION] , ...12 more... )
• FAPPL5 ( type: esriFieldTypeString, alias: FAPPL5, length: 50 , Coded Values: [BUS SHELTER: BUS SHELTER] , [CAMERA: CAMERA] , [IRRIGATION: IRRIGATION] , ...12 more... )
• METERED ( type: esriFieldTypeString, alias: METERED, length: 2 , Coded Values: [Y: Y] )
• PAINTPOLE ( type: esriFieldTypeString, alias: PAINTPOLE, length: 2 , Coded Values: [Y: Y] , [N: N] )
• TRNSACTION ( type: esriFieldTypeString, alias: TRNSACTION, length: 50 , Coded Values: [1: Add] , [2: Delete] , [3: Change] , ...7 more... )
• FAR4 ( type: esriFieldTypeString, alias: FAR4, length: 30 , Coded Values: [DAY BURNER: DAY BURNER] , [CYCLING LIGHT: CYCLING LIGHT] , [FOUNDATION ONLY: FOUNDATION ONLY] , ...18 more... )
• FAR5 ( type: esriFieldTypeString, alias: FAR5, length: 30 , Coded Values: [DAY BURNER: DAY BURNER] , [CYCLING LIGHT: CYCLING LIGHT] , [FOUNDATION ONLY: FOUNDATION ONLY] , ...18 more... )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• InstallStatus ( type: esriFieldTypeString, alias: Install Status, length: 50 , Coded Values: [ToBeConverted69: To Be Converted 69] , [OutOfScope: Out Of Scope] , [Converted: Converted] , ...10 more... )
• NewItemCode ( type: esriFieldTypeString, alias: New LED Wattage, length: 50 , Coded Values: [S-LC-53: 53 Watt LED] , [S-LC-60: 60 Watt LED] , [S-LC-69: 69 Watt LED] , ...1 more... )
• InstalledCCT ( type: esriFieldTypeString, alias: Installed Color Temperature, length: 10 , Coded Values: [3000K: 3000K] , [4000K: 4000K] )
• InstallerInitials ( type: esriFieldTypeString, alias: Installed By, length: 10 )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• CityNotes ( type: esriFieldTypeString, alias: City Notes, length: 250 )
• InstallerNotes ( type: esriFieldTypeString, alias: Installer Notes, length: 250 )
• LinkToGoogleMaps ( type: esriFieldTypeString, alias: Link To Google Maps, length: 250 )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y )
• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1 )
• 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 )
• InstallDatePacific ( type: esriFieldTypeDate, alias: InstallDatePacific, length: 8 )
• EvariNumber ( type: esriFieldTypeDouble, alias: Evari Number )
• PGEAuditNotes ( type: esriFieldTypeString, alias: PG&E Audit Notes, length: 250 )
• SmartMeterNumber ( type: esriFieldTypeDouble, alias: Smart Meter Number , Range: [1000000000, 10000000000] )
• SecondaryAddress ( type: esriFieldTypeString, alias: SecondaryAddress, length: 80 )
• PGEInstallNotes ( type: esriFieldTypeString, alias: PGEInstallNotes, length: 250 )
• AuditNotes ( type: esriFieldTypeString, alias: Audit Notes, length: 250 )
• AuditStatus ( type: esriFieldTypeString, alias: AuditStatus, length: 50 , Coded Values: [NoAction: No Action] , [Fieldchecked: Fieldchecked] , [Flagged: Flag For Review] , ...3 more... )
• ContractorAssignment ( type: esriFieldTypeString, alias: Contractor Assignment, length: 20 )
• Model ( type: esriFieldTypeString, alias: Observed Model, length: 50 , Coded Values: [Cobrahead: Cobrahead] , [DoubleCobrahead: Double Cobrahead] , [Acorn: Acorn] , ...7 more... )
• Shield ( type: esriFieldTypeString, alias: Shield, length: 50 , Coded Values: [Front Shield: Front Shield] , [Back Shield: Back Shield] , [Front and Back Shield: Front and Back Shield] , ...7 more... )
• District ( type: esriFieldTypeSmallInteger, alias: District )
• InspectionStatus ( type: esriFieldTypeString, alias: Inspection Status, length: 150 , Coded Values: [NotInspected: Not Inspected] , [InspectedWithoutIssue: Inspected Without Issue] , [Stray Voltage Found, Corrected, Inspected: Stray Voltage Found, Corrected, Inspected] , ...6 more... )
• StrayVoltage_Measurement ( type: esriFieldTypeString, alias: Stray Voltage Measurement, length: 250 )
• CCSF_Rate_Code ( type: esriFieldTypeString, alias: CCSF_Rate_Code, length: 50 , Coded Values: [HH: HH] , [S1: S1] , [S3: S3] , ...4 more... )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• CCSF_SL_Grouping ( type: esriFieldTypeString, alias: CCSF_SL_Grouping, length: 50 )
• Intersection ( type: esriFieldTypeString, alias: Intersection, length: 50 )
• City_Pole_Number ( type: esriFieldTypeString, alias: City_Pole_Number, length: 50 )
• City_Wattage ( type: esriFieldTypeString, alias: City_Wattage, length: 50 )
• SFPUC_Comments ( type: esriFieldTypeString, alias: SFPUC_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... )

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

  Iteminfo   Thumbnail   Metadata