View In:   ArcGIS Online Map Viewer

Name: Street Lights

Display Field: TechName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 03924a646de34eedaf703450309ca017

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 565436.1490000002
YMin: 928236.7707500011
XMax: 612924.8275000006
YMax: 1019359.7040000036
Spatial Reference: 2868  (2868)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SYMBOLROTA ( type: esriFieldTypeDouble, alias: SYMBOLROTA, editable: true, nullable: true, defaultValue: null, modelName: SYMBOLROTA )
• LUMEN ( type: esriFieldTypeInteger, alias: LUMEN, editable: true, nullable: true, defaultValue: null, modelName: LUMEN )
• VOLTAGE ( type: esriFieldTypeString, alias: VOLTAGE, editable: true, nullable: true, length: 7, defaultValue: null, modelName: VOLTAGE , Coded Values: [120: 120V] , [240: 240V] , [120/240: 120V/240V] , ...4 more... )
• MANUFACTUR ( type: esriFieldTypeString, alias: MANUFACTUR, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MANUFACTUR )
• FIXTUREHEI ( type: esriFieldTypeDouble, alias: FIXTUREHEI, editable: true, nullable: true, defaultValue: null, modelName: FIXTUREHEI )
• MOUNTINGHE ( type: esriFieldTypeDouble, alias: MOUNTINGHE, editable: true, nullable: true, defaultValue: null, modelName: MOUNTINGHE )
• APSNUMBER ( type: esriFieldTypeString, alias: APSNUMBER, editable: true, nullable: true, length: 9, defaultValue: null, modelName: APSNUMBER )
• owner ( type: esriFieldTypeString, alias: owner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: owner )
• UNITID ( type: esriFieldTypeString, alias: UNITID, editable: true, nullable: true, length: 16, defaultValue: null, modelName: UNITID )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY, editable: true, nullable: true, defaultValue: null, modelName: COMPKEY )
• COMPTYPE ( type: esriFieldTypeInteger, alias: COMPTYPE, editable: true, nullable: true, defaultValue: null, modelName: COMPTYPE )
• X_Coord ( type: esriFieldTypeDouble, alias: X_Coord, editable: true, nullable: true, defaultValue: null, modelName: X_Coord )
• Y_Coord ( type: esriFieldTypeDouble, alias: Y_Coord, editable: true, nullable: true, defaultValue: null, modelName: Y_Coord )
• PoleDesc ( type: esriFieldTypeString, alias: PoleDesc, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PoleDesc )
• MapNumber ( type: esriFieldTypeString, alias: MapNumber, editable: true, nullable: true, length: 14, defaultValue: null, modelName: MapNumber )
• Acct_Num ( type: esriFieldTypeDouble, alias: Acct_Num, editable: true, nullable: true, defaultValue: null, modelName: Acct_Num )
• SlidIDFromAPS ( type: esriFieldTypeString, alias: SlidIDFromAPS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SlidIDFromAPS )
• AddrQual ( type: esriFieldTypeString, alias: AddrQual, editable: true, nullable: true, length: 254, defaultValue: null, modelName: AddrQual )
• UnitType ( type: esriFieldTypeString, alias: UnitType, editable: true, nullable: true, length: 6, defaultValue: null, modelName: UnitType )
• TechName ( type: esriFieldTypeString, alias: TechName, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TechName , Coded Values: [BryanE: Bryan Eaton] , [SeanC: Sean Coniglio] , [RandyB: Randy Braden] , ...5 more... )
• ActionDate ( type: esriFieldTypeDate, alias: ActionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ActionDate )
• ActionType ( type: esriFieldTypeSmallInteger, alias: ActionType, editable: true, nullable: true, defaultValue: null, modelName: ActionType , Coded Values: [1: Add (New Asset)] , [2: Expire (Asset Removed)] , [3: Edit (Attribute Update)] , ...1 more... )
• ServiceRequest ( type: esriFieldTypeString, alias: ServiceRequest, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ServiceRequest )
• ProjectNo ( type: esriFieldTypeString, alias: ProjectNo, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ProjectNo )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyDate )
• ServiceStatus ( type: esriFieldTypeString, alias: ServiceStatus, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ServiceStatus , Coded Values: [APS: APS] , [SRP: SRP] , [SOL: Solar] )
• Acct_Num_Hansen ( type: esriFieldTypeString, alias: Acct_Num_Hansen, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Acct_Num_Hansen )
• Wattage ( type: esriFieldTypeInteger, alias: Wattage, editable: true, nullable: true, defaultValue: null, modelName: Wattage , Coded Values: [31: 31W] , [35: 35W] , [37: 37W] , ...35 more... )
• JBox ( type: esriFieldTypeString, alias: JBox, editable: true, nullable: true, length: 1, defaultValue: null, modelName: JBox , Coded Values: [Y: Yes] , [N: No] )
• HeadType ( type: esriFieldTypeString, alias: HeadType, editable: true, nullable: true, length: 16, defaultValue: null, modelName: HeadType , Coded Values: [AMER ELEC: American Electric] , [COOPER: Cooper] , [DIALIGHT: Dialight] , ...11 more... )
• INSTDATE ( type: esriFieldTypeDate, alias: INSTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTDATE )
• BILLCODE ( type: esriFieldTypeString, alias: BILLCODE, editable: true, nullable: true, length: 13, defaultValue: null, modelName: BILLCODE )
• ACCTYPE ( type: esriFieldTypeString, alias: ACCTYPE, editable: true, nullable: true, length: 9, defaultValue: null, modelName: ACCTYPE )
• POLEMATL ( type: esriFieldTypeString, alias: POLEMATL, editable: true, nullable: true, length: 10, defaultValue: null, modelName: POLEMATL )
• CABLTYPE ( type: esriFieldTypeString, alias: CABLTYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CABLTYPE )
• CABLOWN ( type: esriFieldTypeString, alias: CABLOWN, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CABLOWN )
• ADDRKEY ( type: esriFieldTypeInteger, alias: ADDRKEY, editable: true, nullable: true, defaultValue: null, modelName: ADDRKEY )
• GPS ( type: esriFieldTypeString, alias: GPS, editable: true, nullable: true, length: 3, defaultValue: null, modelName: GPS )
• PLACEMENT ( type: esriFieldTypeString, alias: PLACEMENT, editable: true, nullable: true, length: 24, defaultValue: null, modelName: PLACEMENT )
• PoleID2 ( type: esriFieldTypeString, alias: PoleID2, editable: true, nullable: true, length: 16, defaultValue: null, modelName: PoleID2 )
• OrthoHeigh ( type: esriFieldTypeDouble, alias: OrthoHeigh, editable: true, nullable: true, defaultValue: null, modelName: OrthoHeigh )
• FeatStat ( type: esriFieldTypeString, alias: FeatStat, editable: true, nullable: true, length: 3, defaultValue: null, modelName: FeatStat )
• MoveAction ( type: esriFieldTypeString, alias: MoveAction, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MoveAction )
• SEGKEY ( type: esriFieldTypeInteger, alias: SEGKEY, editable: true, nullable: true, defaultValue: null, modelName: SEGKEY )
• Lt_Compkey ( type: esriFieldTypeInteger, alias: Lt_Compkey, editable: true, nullable: true, defaultValue: null, modelName: Lt_Compkey )
• Lt_UnitID ( type: esriFieldTypeString, alias: Lt_UnitID, editable: true, nullable: true, length: 16, defaultValue: null, modelName: Lt_UnitID )
• Lt_Area ( type: esriFieldTypeSmallInteger, alias: Lt_Area, editable: true, nullable: true, defaultValue: null, modelName: Lt_Area )
• RESFLAG ( type: esriFieldTypeString, alias: RESFLAG, editable: true, nullable: true, length: 1, defaultValue: null, modelName: RESFLAG )
• SERVNO ( type: esriFieldTypeDouble, alias: SERVNO, editable: true, nullable: true, defaultValue: null, modelName: SERVNO )
• ServADDDTTM ( type: esriFieldTypeDate, alias: ServADDDTTM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ServADDDTTM )
• WONO ( type: esriFieldTypeString, alias: WONO, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WONO )
• WO_COMPBY ( type: esriFieldTypeString, alias: WO_COMPBY, editable: true, nullable: true, length: 12, defaultValue: null, modelName: WO_COMPBY )
• WO_COMPDTTM ( type: esriFieldTypeDate, alias: WO_COMPDTTM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WO_COMPDTTM )
• WO_ACTKEY ( type: esriFieldTypeInteger, alias: WO_ACTKEY, editable: true, nullable: true, defaultValue: null, modelName: WO_ACTKEY )
• ServRESDUEDTTM ( type: esriFieldTypeDate, alias: ServRESDUEDTTM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ServRESDUEDTTM )
• HISTKEY ( type: esriFieldTypeInteger, alias: HISTKEY, editable: true, nullable: true, defaultValue: null, modelName: HISTKEY )
• WO_PROB ( type: esriFieldTypeString, alias: WO_PROB, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WO_PROB )
• ArchTechName ( type: esriFieldTypeString, alias: ArchTechName, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ArchTechName )
• ArchActionDate ( type: esriFieldTypeDate, alias: ArchActionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ArchActionDate )
• ArchActionType ( type: esriFieldTypeSmallInteger, alias: ArchActionType, editable: true, nullable: true, defaultValue: null, modelName: ArchActionType )
• ServPRI ( type: esriFieldTypeString, alias: ServPRI, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ServPRI )
• USGAREAKEY ( type: esriFieldTypeInteger, alias: USGAREAKEY, editable: true, nullable: true, defaultValue: null, modelName: USGAREAKEY )
• APS_BillPoleNo ( type: esriFieldTypeString, alias: APS_BillPoleNo, editable: true, nullable: true, length: 16, defaultValue: null, modelName: APS_BillPoleNo )
• POLETYPE ( type: esriFieldTypeString, alias: POLETYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: POLETYPE )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Comments )
• StreetType ( type: esriFieldTypeString, alias: StreetType, editable: true, nullable: true, length: 6, defaultValue: null, modelName: StreetType )
• Lt_Area_Text ( type: esriFieldTypeString, alias: Lt_Area_Text, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Lt_Area_Text )
• FOUNDATION ( type: esriFieldTypeString, alias: FOUNDATION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FOUNDATION , Coded Values: [DIRECTBURY: Direct Bury] , [FOUNDATION: Foundation] )
• ArmType ( type: esriFieldTypeString, alias: ArmType, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ArmType , Coded Values: [1X4: 1 X 4] , [1.5X6: 1.5 X 6] , [2X0: 2 X 0] , ...15 more... )
• SolarPanel ( type: esriFieldTypeString, alias: SolarPanel, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SolarPanel , Coded Values: [Y: Yes] , [N: No] )
• SolarBatType ( type: esriFieldTypeString, alias: SolarBatType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SolarBatType , Coded Values: [AGM: AGM] , [LFP: LFP] , [GEL: Sealed GEL] )
• SolarBatQnty ( type: esriFieldTypeSmallInteger, alias: SolarBatQnty, editable: true, nullable: true, defaultValue: null, modelName: SolarBatQnty , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...5 more... )
• Cell_Carrier ( type: esriFieldTypeString, alias: Cell_Carrier, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Cell_Carrier )
• Cell_Permit ( type: esriFieldTypeString, alias: Cell_Permit, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Cell_Permit )
• Cell_PermitDate ( type: esriFieldTypeDate, alias: Cell_PermitDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Cell_PermitDate )
• Cell_PermitStatus ( type: esriFieldTypeString, alias: Cell_PermitStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Cell_PermitStatus , Coded Values: [Pending: Permit Pending] , [Approved: Permit Approved] , [Installed: Antenna Installed] )
• SUBDIVISION ( type: esriFieldTypeString, alias: SUBDIVISION, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Cell_DocLink )
• ServPROB ( type: esriFieldTypeInteger, alias: ServPROB, editable: true, nullable: true, defaultValue: null, modelName: ServPROB )
• SITEKEY ( type: esriFieldTypeInteger, alias: SITEKEY, editable: true, nullable: true, defaultValue: null, modelName: SITEKEY )
• LED_Lumen ( type: esriFieldTypeString, alias: LED_Lumen, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LED_Lumen , Coded Values: [4000-D3: 4000-D3 (Residential Street Subdivision)] , [4700-A3: 4700-A3 (Residential Street Subdivision)] , [6000-B3: 6000-B3 (Residential Street Subdivision)] , ...21 more... )
• LED_INSTDATE ( type: esriFieldTypeDate, alias: LED_INSTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LED_INSTDATE )
• PD_Camera ( type: esriFieldTypeString, alias: PD_Camera, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PD_Camera , Coded Values: [Y: Yes] , [N: No] )
• HeadType2 ( type: esriFieldTypeString, alias: HeadType2, editable: true, nullable: true, length: 16, defaultValue: null, modelName: HeadType2 , Coded Values: [AMER ELEC: American Electric] , [COOPER: Cooper] , [DIALIGHT: Dialight] , ...11 more... )
• Wattage2 ( type: esriFieldTypeInteger, alias: Wattage2, editable: true, nullable: true, defaultValue: null, modelName: Wattage2 , Coded Values: [31: 31W] , [35: 35W] , [37: 37W] , ...35 more... )
• LED_Lumen2 ( type: esriFieldTypeString, alias: LED_Lumen2, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LED_Lumen2 , Coded Values: [4000-D3: 4000-D3 (Residential Street Subdivision)] , [4700-A3: 4700-A3 (Residential Street Subdivision)] , [6000-B3: 6000-B3 (Residential Street Subdivision)] , ...21 more... )
• LED_INSTDATE2 ( type: esriFieldTypeDate, alias: LED_INSTDATE2, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LED_INSTDATE2 )
• IMEI ( type: esriFieldTypeString, alias: IMEI, editable: true, nullable: true, length: 5, defaultValue: null, modelName: IMEI )
• WarrantyStatus ( type: esriFieldTypeString, alias: WarrantyStatus, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WarrantyStatus )
• HANSENADDDATE ( type: esriFieldTypeDate, alias: HANSENADDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: HANSENADDDATE )
• ModifiedDate ( type: esriFieldTypeDate, alias: ModifiedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ModifiedDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Shield ( type: esriFieldTypeString, alias: Shield, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Shield , Coded Values: [Y: Yes] , [N: No] )
• BirdSpikes ( type: esriFieldTypeString, alias: Bird Spikes, editable: true, nullable: true, length: 1, defaultValue: null, modelName: BirdSpikes , Coded Values: [Y: Yes] , [N: No] )

Templates:

• Name: Street Lights
  Description:
  Prototype:
  Shield: null
  SYMBOLROTA: null
  LUMEN: null
  VOLTAGE: null
  MANUFACTUR: null
  FIXTUREHEI: null
  MOUNTINGHE: null
  APSNUMBER: null
  owner: null
  UNITID: null
  COMPKEY: null
  COMPTYPE: null
  X_Coord: null
  Y_Coord: null
  PoleDesc: null
  MapNumber: null
  Acct_Num: null
  SlidIDFromAPS: null
  AddrQual: null
  UnitType: null
  TechName: null
  ActionDate: null
  ActionType: null
  ServiceRequest: null
  ProjectNo: null
  WarrantyDate: null
  ServiceStatus: null
  Acct_Num_Hansen: null
  Wattage: null
  JBox: null
  HeadType: null
  INSTDATE: null
  BILLCODE: null
  ACCTYPE: null
  POLEMATL: null
  CABLTYPE: null
  CABLOWN: null
  ADDRKEY: null
  GPS: null
  PLACEMENT: null
  PoleID2: null
  OrthoHeigh: null
  FeatStat: null
  MoveAction: null
  SEGKEY: null
  Lt_Compkey: null
  Lt_UnitID: null
  Lt_Area: null
  RESFLAG: null
  SERVNO: null
  ServADDDTTM: null
  WONO: null
  WO_COMPBY: null
  WO_COMPDTTM: null
  WO_ACTKEY: null
  ServRESDUEDTTM: null
  HISTKEY: null
  WO_PROB: null
  ArchTechName: null
  ArchActionDate: null
  ArchActionType: null
  ServPRI: null
  USGAREAKEY: null
  APS_BillPoleNo: null
  POLETYPE: null
  Comments: null
  StreetType: null
  Lt_Area_Text: null
  FOUNDATION: null
  ArmType: null
  SolarPanel: null
  SolarBatType: null
  SolarBatQnty: null
  Cell_Carrier: null
  Cell_Permit: null
  Cell_PermitDate: null
  Cell_PermitStatus: null
  SUBDIVISION: null
  ServPROB: null
  SITEKEY: null
  LED_Lumen: null
  LED_INSTDATE: null
  PD_Camera: null
  HeadType2: null
  Wattage2: null
  LED_Lumen2: null
  LED_INSTDATE2: null
  IMEI: null
  WarrantyStatus: null
  HANSENADDDATE: null
  ModifiedDate: null
  BirdSpikes: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata