View In:   ArcGIS Online Map Viewer

Name: Streetlight Data for CLI Audit - Day

Display Field: fulcrum_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 30cc6ed19fc74514a3f718db5c9bff70

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.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: 3144123.373797705
YMin: 1623934.1590101384
XMax: 3210031.015799398
YMax: 1658244.8817656443
Spatial Reference: 103013  (6428)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: point_of_connection
Field 2: Audited
Field 3: GoingAway
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: <Null>,No,<Null>
  Label: <Null>,No,<Null>
  Description: N/A
  Symbol:
  
• Value: <Null>,Yes,<Null>
  Label: <Null>,Yes,<Null>
  Description: N/A
  Symbol:
  
• Value: <Null>,No,Yes
  Label: <Null>,No,Yes
  Description: N/A
  Symbol:
  
• Value: OH,No,<Null>
  Label: OH,No,<Null>
  Description: N/A
  Symbol:
  
• Value: OH,Yes,<Null>
  Label: OH,Yes,<Null>
  Description: N/A
  Symbol:
  
• Value: UG,No,<Null>
  Label: UG,No,<Null>
  Description: N/A
  Symbol:
  Style: esriSMSSquare
  Color: [115, 76, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: UG,Yes,<Null>
  Label: UG,Yes,<Null>
  Description: N/A
  Symbol:
  Style: esriSMSSquare
  Color: [255, 0, 0, 255]
  Size: 8.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: true
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: false
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: point_of_connection

Fields:

• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID_1 )
• fulcrum_id ( type: esriFieldTypeString, alias: fulcrum_id, editable: true, nullable: true, length: 2048, defaultValue: null, modelName: fulcrum_id )
• 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] , [Wood: Wood] , ...3 more... )
• PoleType ( type: esriFieldTypeString, alias: Pole Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PoleType , Coded Values: [Square: Square] , [Round Tapered: Round Tapered] , [Square Tapered: Square Tapered] , ...2 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"] , ...1 more... )
• PoleHeight ( type: esriFieldTypeString, alias: Pole Height, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PoleHeight , Coded Values: [5': 5'] , [10': 10'] , [15': 15'] , ...12 more... )
• Color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Color , Coded Values: [Black: Black] , [White: White] , [Gray: Gray] , ...4 more... )
• LuminaireType ( type: esriFieldTypeString, alias: Luminaire Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LuminaireType , Coded Values: [Shoebox: Shoebox] , [acorn: acorn] , [cobrahead: cobrahead] , ...5 more... )
• LampType ( type: esriFieldTypeString, alias: Lamp Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LampType , Coded Values: [MH: MH] , [CFL: CFL] , [LED: LED] , ...4 more... )
• Wattage ( type: esriFieldTypeString, alias: Wattage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Wattage , Coded Values: [70: 70] , [100: 100] , [150: 150] , ...5 more... )
• MountingType ( type: esriFieldTypeString, alias: Mounting Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MountingType , Coded Values: [Slip Fitter: Slip Fitter] , [Yoke: Yoke] , [Post Top: Post Top] , ...3 more... )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Condition , Coded Values: [Bad: Bad] , [Needs Replacement: Needs Replacement] , [Good: Good] )
• Controls ( type: esriFieldTypeString, alias: Controls, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Controls , Coded Values: [Individual PC: Individual PC] , [Central PC: Central PC] , [Timeclock: Timeclock] , ...1 more... )
• 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 )
• BaseType ( type: esriFieldTypeString, alias: Base Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BaseType , Coded Values: [Flush Concrete Caisson: Flush Concrete Caisson] , [Above Grade Concrete Caisson: Above Grade Concrete Caisson] , [Direct Burial: Direct Burial] , ...1 more... )
• MastArmLength ( type: esriFieldTypeString, alias: Mast Arm Length, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MastArmLength )
• WarrantyInformation ( type: esriFieldTypeString, alias: Warranty Information, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WarrantyInformation )
• 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] )
• Audited ( type: esriFieldTypeString, alias: Audited, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Audited , Coded Values: [Yes: Yes] , [No: No] )
• Audited_Night ( type: esriFieldTypeString, alias: Audited_Night, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Audited_Night , Coded Values: [Yes: Yes] , [No: No] )
• point_of_connection ( type: esriFieldTypeString, alias: point_of_connection, editable: true, nullable: true, length: 2048, defaultValue: null, modelName: point_of_connection )
• On_Off ( type: esriFieldTypeString, alias: On_Off, editable: true, nullable: true, length: 255, defaultValue: null, modelName: On_Off , 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] , ...3 more... )
• FixturesOut ( type: esriFieldTypeString, alias: FixturesOut, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FixturesOut , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...4 more... )
• FixtureDesignation ( type: esriFieldTypeString, alias: FixtureDesignation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FixtureDesignation , Coded Values: [A: A] , [B: B] , [C: C] , ...23 more... )
• 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: [On: On] , [Off: Off] )
• On_Off_Night ( type: esriFieldTypeString, alias: On_Off_Night, editable: true, nullable: true, length: 255, defaultValue: null, modelName: On_Off_Night , Coded Values: [On: On] , [Off: Off] )
• SurveyDate_Night ( type: esriFieldTypeDate, alias: SurveyDate_Night, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SurveyDate_Night )
• 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 )
• New ( type: esriFieldTypeString, alias: New, editable: true, nullable: true, length: 255, defaultValue: null, modelName: New , Coded Values: [Yes: Yes] , [No: No] )
• New1 ( type: esriFieldTypeString, alias: New1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: New1 , Coded Values: [Yes: Yes] , [No: No] , [Xcel: Xcel] )

Types:

ID: null
Name: <Null>,No,<Null>
Domains:
• PoleMaterial:
  Inherited
• PoleType:
  Inherited
• PoleDiameter:
  Inherited
• PoleHeight:
  Inherited
• Color:
  Inherited
• LuminaireType:
  Inherited
• LampType:
  Inherited
• Wattage:
  Inherited
• MountingType:
  Inherited
• Condition:
  Inherited
• Controls:
  Inherited
• BaseType:
  Inherited
• NearOverheadPowerlines:
  Inherited
• HandHoleAccess:
  Inherited
• Audited:
  Inherited
• Audited_Night:
  Inherited
• On_Off:
  Inherited
• Fixtures:
  Inherited
• FixturesOut:
  Inherited
• FixtureDesignation:
  Inherited
• GoingAway:
  Inherited
• On_Off_Day:
  Inherited
• On_Off_Night:
  Inherited
• New:
  Inherited
• New1:
  Inherited
Templates:
• Name: <Null>,No,<Null>
  Description:
  Prototype:
  Audited_Night: null
  HandHoleAccess: null
  FixtureDesignation: null
  New: null
  fulcrum_id: 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
  WarrantyInformation: null
  LEDRetrofitDate: null
  NearOverheadPowerlines: null
  Audited: No
  point_of_connection: <Null>
  On_Off: null
  Fixtures: null
  FixturesOut: null
  GoingAway: <Null>
  On_Off_Day: null
  On_Off_Night: null
  SurveyDate_Night: null
  New1: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: <Null>,Yes,<Null>
  Description:
  Prototype:
  Audited_Night: null
  HandHoleAccess: null
  FixtureDesignation: null
  New: null
  fulcrum_id: 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
  WarrantyInformation: null
  LEDRetrofitDate: null
  NearOverheadPowerlines: null
  Audited: Yes
  point_of_connection: <Null>
  On_Off: null
  Fixtures: null
  FixturesOut: null
  GoingAway: <Null>
  On_Off_Day: null
  On_Off_Night: null
  SurveyDate_Night: null
  New1: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: <Null>,No,Yes
  Description:
  Prototype:
  Audited_Night: null
  HandHoleAccess: null
  FixtureDesignation: null
  New: null
  fulcrum_id: 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
  WarrantyInformation: null
  LEDRetrofitDate: null
  NearOverheadPowerlines: null
  Audited: No
  point_of_connection: <Null>
  On_Off: null
  Fixtures: null
  FixturesOut: null
  GoingAway: Yes
  On_Off_Day: null
  On_Off_Night: null
  SurveyDate_Night: null
  New1: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: OH
Name: OH,No,<Null>
Domains:
• PoleMaterial:
  Inherited
• PoleType:
  Inherited
• PoleDiameter:
  Inherited
• PoleHeight:
  Inherited
• Color:
  Inherited
• LuminaireType:
  Inherited
• LampType:
  Inherited
• Wattage:
  Inherited
• MountingType:
  Inherited
• Condition:
  Inherited
• Controls:
  Inherited
• BaseType:
  Inherited
• NearOverheadPowerlines:
  Inherited
• HandHoleAccess:
  Inherited
• Audited:
  Inherited
• Audited_Night:
  Inherited
• On_Off:
  Inherited
• Fixtures:
  Inherited
• FixturesOut:
  Inherited
• FixtureDesignation:
  Inherited
• GoingAway:
  Inherited
• On_Off_Day:
  Inherited
• On_Off_Night:
  Inherited
• New:
  Inherited
• New1:
  Inherited
Templates:
• Name: OH,No,<Null>
  Description:
  Prototype:
  Audited_Night: null
  HandHoleAccess: null
  FixtureDesignation: null
  New: null
  fulcrum_id: 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
  WarrantyInformation: null
  LEDRetrofitDate: null
  NearOverheadPowerlines: null
  Audited: No
  point_of_connection: OH
  On_Off: null
  Fixtures: null
  FixturesOut: null
  GoingAway: <Null>
  On_Off_Day: null
  On_Off_Night: null
  SurveyDate_Night: null
  New1: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: OH,Yes,<Null>
  Description:
  Prototype:
  Audited_Night: null
  HandHoleAccess: null
  FixtureDesignation: null
  New: null
  fulcrum_id: 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
  WarrantyInformation: null
  LEDRetrofitDate: null
  NearOverheadPowerlines: null
  Audited: Yes
  point_of_connection: OH
  On_Off: null
  Fixtures: null
  FixturesOut: null
  GoingAway: <Null>
  On_Off_Day: null
  On_Off_Night: null
  SurveyDate_Night: null
  New1: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: UG
Name: UG,No,<Null>
Domains:
• PoleMaterial:
  Inherited
• PoleType:
  Inherited
• PoleDiameter:
  Inherited
• PoleHeight:
  Inherited
• Color:
  Inherited
• LuminaireType:
  Inherited
• LampType:
  Inherited
• Wattage:
  Inherited
• MountingType:
  Inherited
• Condition:
  Inherited
• Controls:
  Inherited
• BaseType:
  Inherited
• NearOverheadPowerlines:
  Inherited
• HandHoleAccess:
  Inherited
• Audited:
  Inherited
• Audited_Night:
  Inherited
• On_Off:
  Inherited
• Fixtures:
  Inherited
• FixturesOut:
  Inherited
• FixtureDesignation:
  Inherited
• GoingAway:
  Inherited
• On_Off_Day:
  Inherited
• On_Off_Night:
  Inherited
• New:
  Inherited
• New1:
  Inherited
Templates:
• Name: UG,No,<Null>
  Description:
  Prototype:
  Audited_Night: null
  HandHoleAccess: null
  FixtureDesignation: null
  New: null
  fulcrum_id: 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
  WarrantyInformation: null
  LEDRetrofitDate: null
  NearOverheadPowerlines: null
  Audited: No
  point_of_connection: UG
  On_Off: null
  Fixtures: null
  FixturesOut: null
  GoingAway: <Null>
  On_Off_Day: null
  On_Off_Night: null
  SurveyDate_Night: null
  New1: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: UG,Yes,<Null>
  Description:
  Prototype:
  Audited_Night: null
  HandHoleAccess: null
  FixtureDesignation: null
  New: null
  fulcrum_id: 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
  WarrantyInformation: null
  LEDRetrofitDate: null
  NearOverheadPowerlines: null
  Audited: Yes
  point_of_connection: UG
  On_Off: null
  Fixtures: null
  FixturesOut: null
  GoingAway: <Null>
  On_Off_Day: null
  On_Off_Night: null
  SurveyDate_Night: null
  New1: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: 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: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata