View In:   ArcGIS Online Map Viewer

Name: Lightpole_Inventory

Display Field: POLE_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 44a90345231d4f75a5bf6cff1cc86c75

Copyright Text: Patrick Walker, GISP

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: 2468303.9531837255
YMin: 360115.73969338834
XMax: 2509967.1730067283
YMax: 381738.16199964285
Spatial Reference: 2930  (2930)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: POLE_DESIGN
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Double Arm
  Label: Double Arm
  Description: N/A
  Symbol:
  
• Value: Ornamental
  Label: Ornamental
  Description: N/A
  Symbol:
  
• Value: Single Arm
  Label: Single Arm
  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: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: POLE_DESIGN

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: "Object ID", editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• POLE_ID ( type: esriFieldTypeString, alias: Pole ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: POLE_ID )
• ASBUILT_PLAN ( type: esriFieldTypeString, alias: Asbuilt Plan, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ASBUILT_PLAN )
• PLAN_BIN ( type: esriFieldTypeString, alias: Plan Bin, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PLAN_BIN )
• LIGHTPOLE_OWNER ( type: esriFieldTypeString, alias: Lightpole Owner, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LIGHTPOLE_OWNER , Coded Values: [West Allis: West Allis] , [Wis DOT: Wis DOT] )
• 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 )
• ASSETWORKS_ID ( type: esriFieldTypeString, alias: ASSETWORKS_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ASSETWORKS_ID )
• CIRCUIT ( type: esriFieldTypeString, alias: Circuit, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CIRCUIT , Coded Values: [A3: A3] , [AA: AA] , [AB: AB] , ...164 more... )
• POLE_TYPE ( type: esriFieldTypeString, alias: Pole Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POLE_TYPE2 , Coded Values: [A1: A1] , [A2: A2] , [AB1: AB1] , ...16 more... )
• POLE_HEIGHT ( type: esriFieldTypeString, alias: Pole Height, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POLE_HEIGHT , Coded Values: [12: 12] , [13: 13] , [14: 14] , ...11 more... )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
• FIXTURE_CODE ( type: esriFieldTypeString, alias: Fixture Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FIXTURE_CODE , Coded Values: [AEL: AEL] , [ATBO : ATBO] , [BB: BB] , ...22 more... )
• LAMP_SIZE ( type: esriFieldTypeString, alias: Lamp Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LAMP_SIZE , Coded Values: [MS400: MS400] , [MH1500: MH1500] , [MH1000: MH1000] , ...23 more... )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDRESS )
• SIGN_CODE ( type: esriFieldTypeString, alias: Sign Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIGN_CODE , Coded Values: [Y: Y] , [N: N] )
• CIRCUIT_BRKNO ( type: esriFieldTypeString, alias: Circuit Breaker No, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CIRCUIT_BRKNO , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...26 more... )
• POLE_DESIGN ( type: esriFieldTypeString, alias: Pole Design, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POLE_DESIGN , Coded Values: [Single Arm: Single Arm] , [Double Arm: Double Arm] , [Ornamental: Ornamental] , ...3 more... )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOTES )
• EXTENSION ( type: esriFieldTypeString, alias: Extension, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EXTENSION )
• CIRCUIT_TYPE_SUBTYPE ( type: esriFieldTypeSmallInteger, alias: CIrcuit Type, editable: true, nullable: true, defaultValue: 0, modelName: CIRCUIT_TYPE_SUBTYPE , Coded Values: [0: High Voltage] , [1: Low Voltage] )
• Relamp ( type: esriFieldTypeString, alias: ReLamp Cycle, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Relamp , Coded Values: [A: A] , [B: B] , [C: C] , ...1 more... )
• Cellular ( type: esriFieldTypeString, alias: Cellular Owner, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Cellular , Coded Values: [ATT: AT&T] , [US Cellular: US Cellular] , [Verizon: Verizon] , ...3 more... )
• Cell_Permit ( type: esriFieldTypeString, alias: Cellular Permit, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Cell_Permit )
• Cell_InstallDate ( type: esriFieldTypeDate, alias: Cellular Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Cell_InstallDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: Double Arm
Name: Double Arm
Domains:
• LIGHTPOLE_OWNER:
  Inherited
• CIRCUIT:
  Inherited
• POLE_TYPE:
  Inherited
• POLE_HEIGHT:
  Inherited
• FIXTURE_CODE:
  Inherited
• LAMP_SIZE:
  Inherited
• SIGN_CODE:
  Inherited
• CIRCUIT_BRKNO:
  Inherited
• POLE_DESIGN:
  Inherited
• CIRCUIT_TYPE_SUBTYPE:
  Inherited
• Relamp:
  Inherited
• Cellular:
  Inherited
Templates:
• Name: Double Arm
  Description:
  Prototype:
  CIRCUIT_BRKNO: null
  EXTENSION: null
  Cell_InstallDate: null
  POLE_ID: null
  ASBUILT_PLAN: null
  PLAN_BIN: null
  LIGHTPOLE_OWNER: null
  Cell_Permit: null
  Cellular: null
  Relamp: null
  CIRCUIT_TYPE_SUBTYPE: 0
  ASSETWORKS_ID: null
  CIRCUIT: null
  POLE_TYPE: null
  POLE_HEIGHT: null
  INSTALL_DATE: null
  FIXTURE_CODE: null
  LAMP_SIZE: null
  ADDRESS: null
  SIGN_CODE: null
  POLE_DESIGN: Double Arm
  NOTES: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Ornamental
Name: Ornamental
Domains:
• LIGHTPOLE_OWNER:
  Inherited
• CIRCUIT:
  Inherited
• POLE_TYPE:
  Inherited
• POLE_HEIGHT:
  Inherited
• FIXTURE_CODE:
  Inherited
• LAMP_SIZE:
  Inherited
• SIGN_CODE:
  Inherited
• CIRCUIT_BRKNO:
  Inherited
• POLE_DESIGN:
  Inherited
• CIRCUIT_TYPE_SUBTYPE:
  Inherited
• Relamp:
  Inherited
• Cellular:
  Inherited
Templates:
• Name: Ornamental
  Description:
  Prototype:
  CIRCUIT_BRKNO: null
  EXTENSION: null
  Cell_InstallDate: null
  POLE_ID: null
  ASBUILT_PLAN: null
  PLAN_BIN: null
  LIGHTPOLE_OWNER: null
  Cell_Permit: null
  Cellular: null
  Relamp: null
  CIRCUIT_TYPE_SUBTYPE: 0
  ASSETWORKS_ID: null
  CIRCUIT: null
  POLE_TYPE: null
  POLE_HEIGHT: null
  INSTALL_DATE: null
  FIXTURE_CODE: null
  LAMP_SIZE: null
  ADDRESS: null
  SIGN_CODE: null
  POLE_DESIGN: Ornamental
  NOTES: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Single Arm
Name: Single Arm
Domains:
• LIGHTPOLE_OWNER:
  Inherited
• CIRCUIT:
  Inherited
• POLE_TYPE:
  Inherited
• POLE_HEIGHT:
  Inherited
• FIXTURE_CODE:
  Inherited
• LAMP_SIZE:
  Inherited
• SIGN_CODE:
  Inherited
• CIRCUIT_BRKNO:
  Inherited
• POLE_DESIGN:
  Inherited
• CIRCUIT_TYPE_SUBTYPE:
  Inherited
• Relamp:
  Inherited
• Cellular:
  Inherited
Templates:
• Name: Single Arm
  Description:
  Prototype:
  CIRCUIT_BRKNO: null
  EXTENSION: null
  Cell_InstallDate: null
  POLE_ID: null
  ASBUILT_PLAN: null
  PLAN_BIN: null
  LIGHTPOLE_OWNER: null
  Cell_Permit: null
  Cellular: null
  Relamp: null
  CIRCUIT_TYPE_SUBTYPE: 0
  ASSETWORKS_ID: null
  CIRCUIT: null
  POLE_TYPE: null
  POLE_HEIGHT: null
  INSTALL_DATE: null
  FIXTURE_CODE: null
  LAMP_SIZE: null
  ADDRESS: null
  SIGN_CODE: null
  POLE_DESIGN: Single Arm
  NOTES: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• GIS_CityUtilities.DBO.LightpoleMaint (0) -- Related To: Lightpole_Maint (16)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync

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   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata