View In:   ArcGIS Online Map Viewer

Name: Traf_Poles

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Point layer representing the city of Cupertino's lightposts

Service Item Id: ae72218467044810a10215a47e020e42

Copyright Text: City of Cupertino

Default Visibility: false

MaxRecordCount: 20000

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: 6099440.173394546
YMin: 1933078.4939567447
XMax: 6126508.416170493
YMax: 1949329.6275445372
Spatial Reference: 102643  (2227)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [133, 0, 11, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Notes )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LegacyID )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: Active, modelName: Status , Coded Values: [Active: Active] , [Abandoned: Abandoned] , [Proposed: Proposed] , ...4 more... )
• OwnedBy ( type: esriFieldTypeString, alias: OwnedBy, editable: true, nullable: true, length: 50, defaultValue: Cupertino, modelName: OwnedBy , Coded Values: [CalTrans: CalTrans] , [California Water Service: California Water Service] , [Cupertino Sanitary District: Cupertino Sanitary District] , ...16 more... )
• MaintainedBy ( type: esriFieldTypeString, alias: MaintainedBy, editable: true, nullable: true, length: 50, defaultValue: Cupertino, modelName: MaintainedBy , Coded Values: [CalTrans: CalTrans] , [California Water Service: California Water Service] , [Cupertino Sanitary District: Cupertino Sanitary District] , ...16 more... )
• PlanNumber ( type: esriFieldTypeString, alias: PlanNumber, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PlanNumber )
• AsbuiltDate ( type: esriFieldTypeDate, alias: AsbuiltDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AsbuiltDate )
• InstallDate ( type: esriFieldTypeDate, alias: Date Install, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• PrimaryImage ( type: esriFieldTypeString, alias: PrimaryImage, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PrimaryImage )
• DataSource ( type: esriFieldTypeString, alias: DataSource, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DataSource , Coded Values: [Approximated Historical Source: Approximated Historical Source] , [Cogo from Plans: Cogo from Plans] , [Digitized Landbase as Reference: Digitized Landbase as Reference] , ...9 more... )
• Rotation ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: Rotation )
• BadgeNumber ( type: esriFieldTypeString, alias: BadgeNumber, editable: true, nullable: true, length: 6, defaultValue: null, modelName: BadgeNumber )
• ServiceID ( type: esriFieldTypeString, alias: ServiceID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ServiceID )
• PoleType ( type: esriFieldTypeString, alias: PoleType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PoleType , Coded Values: [Taper 1 Bolt: Taper 1 Bolt] , [Taper 2 Bolt: Taper 2 Bolt] , [Taper 3 Bolt: Taper 3 Bolt] , ...10 more... )
• PoleMaterial ( type: esriFieldTypeString, alias: PoleMaterial, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PoleMaterial , Coded Values: [Aluminium: Aluminium] , [Concrete: Concrete] , [Galvanized: Galvanized] , ...2 more... )
• PoleHeight ( type: esriFieldTypeSmallInteger, alias: PoleHeight, editable: true, nullable: true, defaultValue: null, modelName: PoleHeight )
• ArmLength ( type: esriFieldTypeSmallInteger, alias: ArmLength, editable: true, nullable: true, defaultValue: null, modelName: ArmLength , Coded Values: [3: 3'] , [6: 6'] , [8: 8'] , ...13 more... )
• LightFunction ( type: esriFieldTypeString, alias: LightFunction, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LightFunction , Coded Values: [Flood Light: Flood Light] , [Park Light: Park Light] , [Parking Lot Light: Parking Lot Light] , ...3 more... )
• NumberofHeads ( type: esriFieldTypeSmallInteger, alias: NumberOfLamps, editable: true, nullable: true, defaultValue: null, modelName: NumberOfLamps , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• LampType ( type: esriFieldTypeString, alias: LampType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LampType , Coded Values: [HPS: High Pressure Sodium] , [LED: LED] , [MH: Metal Halide] , ...2 more... )
• Wattage ( type: esriFieldTypeSmallInteger, alias: Wattage, editable: true, nullable: true, defaultValue: null, modelName: Wattage )
• Volts ( type: esriFieldTypeSmallInteger, alias: Volts, editable: true, nullable: true, defaultValue: null, modelName: Volts , Coded Values: [120: 120V] , [240: 240V] , [277: 277V] , ...1 more... )
• Base ( type: esriFieldTypeString, alias: Base, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Base , Coded Values: [Anchor: Anchor] , [Buried: Buried] )
• Fixture ( type: esriFieldTypeString, alias: Fixture, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Fixture , Coded Values: [Cobra: Cobra] , [Ornamental: Ornamental] , [Park Dome: Park Dome] , ...1 more... )
• ControlType ( type: esriFieldTypeString, alias: ControlType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ControlType , Coded Values: [PEC: Photo Electronic Control] , [Time Clock: Time Clock] )
• HasBeacon ( type: esriFieldTypeString, alias: HasBeacon, editable: true, nullable: true, length: 4, defaultValue: null, modelName: HasBeacon , Coded Values: [Y: Yes] , [N: No] )
• IsFused ( type: esriFieldTypeString, alias: IsFused, editable: true, nullable: true, length: 3, defaultValue: null, modelName: IsFused , Coded Values: [Y: Yes] , [N: No] )
• IsUnderground ( type: esriFieldTypeString, alias: IsUnderground, editable: true, nullable: true, length: 4, defaultValue: null, modelName: IsUnderground , Coded Values: [Y: Yes] , [N: No] )
• IsMetered ( type: esriFieldTypeString, alias: IsMetered, editable: true, nullable: true, length: 4, defaultValue: null, modelName: IsMetered , Coded Values: [Y: Yes] , [N: No] )
• HasStencil ( type: esriFieldTypeString, alias: HasStencil, editable: true, nullable: true, length: 4, defaultValue: null, modelName: HasStencil , Coded Values: [Y: Yes] , [N: No] )
• HasSticker ( type: esriFieldTypeString, alias: HasSticker, editable: true, nullable: true, length: 4, defaultValue: null, modelName: HasSticker , Coded Values: [Y: Yes] , [N: No] )
• RateSchedule ( type: esriFieldTypeString, alias: RateSchedule, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RateSchedule , Coded Values: [LS1-A: LS1-A] , [LS1-B: LS1-B] , [LS1-C: LS1-C] , ...4 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X, editable: true, nullable: true, defaultValue: null, modelName: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y, editable: true, nullable: true, defaultValue: null, modelName: POINT_Y )
• NoVehicleHds ( type: esriFieldTypeSmallInteger, alias: NoVehicleHds, editable: true, nullable: true, defaultValue: null, modelName: NoVehicleHds , Range: [1, 8] )
• NoPedHds ( type: esriFieldTypeSmallInteger, alias: NoPedHds, editable: true, nullable: true, defaultValue: null, modelName: NoPedHds , Coded Values: [0: 0] , [1: 1] , [2: 2] )
• NoPedButtons ( type: esriFieldTypeSmallInteger, alias: NoPedButtons, editable: true, nullable: true, defaultValue: null, modelName: NoPedButtons , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...1 more... )
• IsTrafficSignal ( type: esriFieldTypeString, alias: IsTrafficSignal, editable: true, nullable: true, length: 3, defaultValue: null, modelName: IsTrafficSignal , Coded Values: [Y: Yes] , [N: No] )
• hasHandPoleCover ( type: esriFieldTypeString, alias: HandPoleCover, editable: true, nullable: true, length: 3, defaultValue: null, modelName: hasHandPoleCover , Coded Values: [Y: Yes] , [N: No] )
• isStreetlight ( type: esriFieldTypeString, alias: isStreetlight, editable: true, nullable: true, length: 3, defaultValue: Y, modelName: isStreetlight , Coded Values: [Y: Yes] , [N: No] )
• SmallCellCarrier ( type: esriFieldTypeString, alias: SmallCellCarrier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SmallCellCarrier , Coded Values: [Verizon: Verizon] , [ATT: ATT] , [Crown Castle: Crown Castle] , ...1 more... )
• hasFlagHolder ( type: esriFieldTypeString, alias: hasFlagHolder, editable: true, nullable: true, length: 3, defaultValue: null, modelName: hasFlagHolder , Coded Values: [Y: Yes] , [N: No] )
• FlagHolderInstallDate ( type: esriFieldTypeDate, alias: FlagHolderInstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FlagHolderInstallDate )
• hasSafeRouteBanner ( type: esriFieldTypeString, alias: hasSafeRouteBanner, editable: true, nullable: true, length: 3, defaultValue: null, modelName: hasSafeRouteBanner , Coded Values: [Y: Yes] , [N: No] )
• SmallCellStatus ( type: esriFieldTypeString, alias: SmallCellStatus, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SmallCellStatus , Coded Values: [Active: Active] , [Proposed: Proposed] , [No Small Cell: No Small Cell] , ...2 more... )
• FixtureInstallDate ( type: esriFieldTypeDate, alias: Date Fixture Install, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FixtureInstallDate )
• PoleInstallDate ( type: esriFieldTypeDate, alias: Date Pole Install, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PoleInstallDate )
• Lumens ( type: esriFieldTypeSmallInteger, alias: Lumens, editable: true, nullable: true, defaultValue: null, modelName: Lumens , Coded Values: [3000: 3L 3000 Lumen] , [5000: 5L 5000 Lumen] , [9000: 9L 9000 Lumen] , ...1 more... )
• PoleMountedEquipment ( type: esriFieldTypeString, alias: Pole Mounted Equipment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PoleMountedEquipment , Coded Values: [Transformer: Transformer] , [Other: Other] , [None: None] )

Templates:

• Name: Traf_Poles
  Description:
  Prototype:
  updateby: CURTIS
  OwnedBy: Cupertino
  hasHandPoleCover: null
  Status: Active
  Location: null
  Lumens: null
  Notes: null
  created_date: null
  last_edited_date: null
  AssetID: null
  LegacyID: null
  MaintainedBy: Cupertino
  PlanNumber: null
  AsbuiltDate: null
  InstallDate: null
  PrimaryImage: null
  DataSource: null
  Rotation: null
  BadgeNumber: null
  ServiceID: null
  PoleType: null
  PoleMaterial: null
  PoleHeight: null
  ArmLength: null
  LightFunction: null
  NumberofHeads: null
  LampType: null
  Wattage: null
  Volts: null
  Base: null
  Fixture: null
  ControlType: null
  HasBeacon: null
  IsFused: null
  IsUnderground: null
  IsMetered: null
  HasStencil: null
  HasSticker: null
  RateSchedule: null
  PoleMountedEquipment: null
  POINT_X: null
  POINT_Y: null
  NoVehicleHds: null
  NoPedHds: null
  NoPedButtons: null
  IsTrafficSignal: null
  isStreetlight: Y
  SmallCellCarrier: null
  hasFlagHolder: null
  FlagHolderInstallDate: null
  hasSafeRouteBanner: null
  SmallCellStatus: null
  FixtureInstallDate: null
  PoleInstallDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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