View In:   ArcGIS Online Map Viewer

Name: City Owned Streetlights

Display Field: SurveyDate

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 70eab399b6f041b8a981dfbd76cc03b7

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000.0

Max Scale: 0.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: 3144225.7041323036
YMin: 1631477.2748996466
XMax: 3209991.6946472973
YMax: 1658122.227843225
Spatial Reference: 103013  (6428)  LatestVCSWkid(0)

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• SurveyDate ( type: esriFieldTypeDate, alias: Survey Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SurveyDate )
• PoleMaterial ( type: esriFieldTypeString, alias: Pole Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PoleMaterial , Coded Values: [ALUMINUM: ALUMINUM] , [FIBERGLASS: FIBERGLASS] , [STEEL: STEEL] , ...2 more... )
• PoleType ( type: esriFieldTypeString, alias: Pole Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PoleType , Coded Values: [ROUND: ROUND] , [ROUNDTAPERED: ROUND TAPERED] , [OTHER: OTHER] , ...1 more... )
• PoleDiameter ( type: esriFieldTypeString, alias: Pole Diameter, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PoleDiameter , Coded Values: [4: 4"] , [5: 5"] , [6: 6"] , ...2 more... )
• PoleHeight ( type: esriFieldTypeString, alias: Pole Height, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PoleHeight , Coded Values: [15: 15'] , [20: 20'] , [25: 25'] , ...4 more... )
• Color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Color , Coded Values: [Black: Black] , [Bronze: Bronze] , [Gray: Gray] , ...1 more... )
• LuminaireType ( type: esriFieldTypeString, alias: Luminaire Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LuminaireType , Coded Values: [Acorn: Acorn] , [Area: Area] , [Cobrahead: Cobrahead] , ...4 more... )
• LampType ( type: esriFieldTypeString, alias: Lamp Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LampType , Coded Values: [HPS: HPS] , [Induction: Induction] , [LED: LED] , ...1 more... )
• Wattage ( type: esriFieldTypeString, alias: Wattage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Wattage , Coded Values: [70: 70 watts] , [100: 100 watts] , [150: 150 watts] , ...4 more... )
• MountingType ( type: esriFieldTypeString, alias: Mounting Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MountingType , Coded Values: [Direct: Direct] , [MastArm: Mast Arm] , [PostTop: Post Top] , ...4 more... )
• Condition ( type: esriFieldTypeString, alias: Pole Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Condition , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• Controls ( type: esriFieldTypeString, alias: Controls, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Controls )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• DiagonalBoltPattern ( type: esriFieldTypeString, alias: Diagonal Bolt Pattern, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DiagonalBoltPattern , Coded Values: [6x6: 6"x6"] , [7.5x7.5: 7.5"x7.5"] , [8.5x8.5: 8.5"x8.5"] , ...3 more... )
• BaseType ( type: esriFieldTypeString, alias: Base Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BaseType )
• MastArmLength ( type: esriFieldTypeString, alias: Mast Arm Length, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MastArmLength , Coded Values: [2: 2'] , [3: 3'] , [4: 4'] , ...6 more... )
• LEDRetrofitDate ( type: esriFieldTypeDate, alias: LED Retrofit Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LEDRetrofitDate )
• NearOverheadPowerlines ( type: esriFieldTypeString, alias: Near Overhead Powerlines, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NearOverheadPowerlines , Coded Values: [Yes: Yes] , [No: No] )
• HandHoleAccess ( type: esriFieldTypeString, alias: Hand Hole Access, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HandHoleAccess , Coded Values: [Yes: Yes] , [No: No] )
• Fixtures ( type: esriFieldTypeString, alias: Fixtures, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Fixtures , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
• FixtureDesignation ( type: esriFieldTypeString, alias: FixtureDesignation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FixtureDesignation )
• GoingAway ( type: esriFieldTypeString, alias: GoingAway, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GoingAway , Coded Values: [Yes: Yes] , [No: No] )
• On_Off_Day ( type: esriFieldTypeString, alias: On_Off_Day, editable: true, nullable: true, length: 255, defaultValue: null, modelName: On_Off_Day , Coded Values: [Yes: Yes] , [No: No] )
• On_Off_Night ( type: esriFieldTypeString, alias: On_Off_Night, editable: true, nullable: true, length: 255, defaultValue: null, modelName: On_Off_Night , Coded Values: [Yes: Yes] , [No: No] )
• SurveyDate_Night ( type: esriFieldTypeDate, alias: SurveyDate_Night, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SurveyDate_Night )
• 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 )
• New ( type: esriFieldTypeString, alias: New, editable: true, nullable: true, length: 255, defaultValue: null, modelName: New )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITY ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACILITYID )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATION )
• PROVIDER ( type: esriFieldTypeString, alias: POWER PROVIDER, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PROVIDER , Coded Values: [XCEL: XCEL] , [CORE: CORE] , [OTHER: OTHER] )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALL DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• RETIREDATE ( type: esriFieldTypeDate, alias: RETIRED DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RETIREDATE )
• NODEINSTALL ( type: esriFieldTypeDate, alias: NODE INSTALL, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NODEINSTALL )
• PLACINSTALL ( type: esriFieldTypeDate, alias: PLACCARD INSTALL, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLACINSTALL )
• PLACCARDID ( type: esriFieldTypeString, alias: PLACCARD ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PLACCARDID )
• FUSEINSTALL ( type: esriFieldTypeDate, alias: FUSE INSTALL, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FUSEINSTALL )
• FUSELOCATION ( type: esriFieldTypeString, alias: FUSE LOCATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FUSELOCATION , Coded Values: [TOP: TOP] , [BOTTOM: BOTTOM] , [OTHER: OTHER (SEE NOTES)] , ...1 more... )
• WIRENEEDED ( type: esriFieldTypeString, alias: POWER/WIRING NEEDED, editable: true, nullable: true, length: 25, defaultValue: No, modelName: WIRENEEDED , Coded Values: [Yes: Yes] , [No: No] )
• WIREREPAIR ( type: esriFieldTypeString, alias: WIRE REPAIR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WIREREPAIR , Coded Values: [0-5: 0-5] , [5-10: 5-10] , [10-20: 10-20] , ...4 more... )
• TREETRIM ( type: esriFieldTypeString, alias: TREE TRIM NEEDED, editable: true, nullable: true, length: 25, defaultValue: No, modelName: TREETRIM , Coded Values: [Yes: Yes] , [No: No] )
• HANDHOLECOVER ( type: esriFieldTypeString, alias: HANDHOLE COVER MISSING, editable: true, nullable: true, length: 25, defaultValue: No, modelName: HANDHOLECOVER , Coded Values: [Yes: Yes] , [No: No] )
• INSTALLNOTES ( type: esriFieldTypeString, alias: INSTALL NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: INSTALLNOTES )
• FUSEPART ( type: esriFieldTypeString, alias: FUSE PART CODE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FUSEPART , Coded Values: [65U-BAF20: 65U Holder & BAF20 Fuse] , [65U-BAF30: 65U Holder & BAF30 Fuse] , [OTHER: OTHER] )
• CONTROLNODEPART ( type: esriFieldTypeString, alias: CONTROL NODE PART CODE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CONTROLNODEPART , Coded Values: [UBC-40: UBC-40-0-01-NA-01-2-TR] , [UBC-30: UBC-30-0-02-GL-01-1-GY] , [OTHER: OTHER] )
• LEDFIXTUREPART ( type: esriFieldTypeString, alias: LED FIXTURE PART CODE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LEDFIXTUREPART , Coded Values: [A: 247CL P154 MVOLT 30K R2 BK SCC PR7] , [B: 245L P154 MVOLT 30K R2 RNP GY PR7 SA] , [I: ACC P306 MVOLT ZT R2 2B 3K GY MP P7 NBR] , ...10 more... )
• STRTLGHTINSTALLSTAT ( type: esriFieldTypeString, alias: STREETLIGHT INSTALL STATUS, editable: true, nullable: true, length: 50, defaultValue: PENDING, modelName: STRTLGHTINSTALLSTAT , Coded Values: [COMPLETE: COMPLETE] , [ONHOLD: ON HOLD] , [INPROGRESS: IN PROGRESS] , ...2 more... )
• ASSIGNEDTO ( type: esriFieldTypeString, alias: ASSIGNED TO, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ASSIGNEDTO , Coded Values: [MM: Matt McQueen] , [AA: AlexAikoriegie] , [MR: Matt Redente] , ...3 more... )
• FUSEQC ( type: esriFieldTypeString, alias: FUSE QC, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FUSEQC , Coded Values: [YES: YES] , [NO: NO] , [NEEDSINSPECTION: NEEDS INSPECTION] )
• NODESN ( type: esriFieldTypeString, alias: NODE SERIAL #, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NODESN )
• ADDEDAFTERPURCHASE ( type: esriFieldTypeString, alias: ADDED AFTER INVENTORY, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ADDEDAFTERPURCHASE , Coded Values: [Yes: Yes] , [No: No] )

Templates:

• Name: City Owned Streetlights
  Description:
  Prototype:
  NODESN: null
  ADDEDAFTERPURCHASE: null
  SurveyDate: null
  PoleMaterial: null
  PoleType: null
  PoleDiameter: null
  PoleHeight: null
  Color: null
  LuminaireType: null
  LampType: null
  Wattage: null
  MountingType: null
  Condition: null
  Controls: null
  Notes: null
  DiagonalBoltPattern: null
  BaseType: null
  MastArmLength: null
  LEDRetrofitDate: null
  NearOverheadPowerlines: null
  HandHoleAccess: null
  Fixtures: null
  FixtureDesignation: null
  GoingAway: null
  On_Off_Day: null
  On_Off_Night: null
  SurveyDate_Night: null
  FUSEQC: null
  ASSIGNEDTO: null
  STRTLGHTINSTALLSTAT: PENDING
  LEDFIXTUREPART: null
  New: null
  FACILITYID: null
  LOCATION: null
  PROVIDER: null
  INSTALLDATE: null
  RETIREDATE: null
  NODEINSTALL: null
  PLACINSTALL: null
  PLACCARDID: null
  FUSEINSTALL: null
  FUSELOCATION: null
  WIRENEEDED: No
  WIREREPAIR: null
  TREETRIM: No
  HANDHOLECOVER: No
  INSTALLNOTES: null
  FUSEPART: null
  CONTROLNODEPART: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports OidReservation: true

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

Supports Coordinates Quantization: true

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