Name: Flag on Traffic Pole

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

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

Copyright Text: City of Cupertino

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 6099440.17339455
YMin: 294725.482273787
XMax: 7596951.56739952
YMax: 1949329.62754454
Spatial Reference: 102643 (2227)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,171,43,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• AssetID (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LegacyID (type: esriFieldTypeString, alias: LegacyID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Active: Active], [Abandoned: Abandoned], [Proposed: Proposed], ... 4 more ...)
• OwnedBy (type: esriFieldTypeString, alias: OwnedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CalTrans: CalTrans], [California Water Service: California Water Service], [Cupertino Sanitary District: Cupertino Sanitary District], ... 16 more ...)
• MaintainedBy (type: esriFieldTypeString, alias: MaintainedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CalTrans: CalTrans], [California Water Service: California Water Service], [Cupertino Sanitary District: Cupertino Sanitary District], ... 16 more ...)
• PlanNumber (type: esriFieldTypeString, alias: PlanNumber, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• AsbuiltDate (type: esriFieldTypeDate, alias: AsbuiltDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• InstallDate (type: esriFieldTypeDate, alias: InstallDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PrimaryImage (type: esriFieldTypeString, alias: PrimaryImage, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CreateBy (type: esriFieldTypeString, alias: CreateBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ADAM: ADAM], [ADAMP: ADAMP], [ADRIAN: ADRIAN], ... 36 more ...)
• CreateDate (type: esriFieldTypeDate, alias: CreateDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• UpdateBy (type: esriFieldTypeString, alias: UpdateBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ADAM: ADAM], [ADAMP: ADAMP], [ADRIAN: ADRIAN], ... 36 more ...)
• UpdateDate (type: esriFieldTypeDate, alias: UpdateDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• DataSource (type: esriFieldTypeString, alias: DataSource, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BadgeNumber (type: esriFieldTypeString, alias: BadgeNumber, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• ServiceID (type: esriFieldTypeString, alias: ServiceID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PoleType (type: esriFieldTypeString, alias: PoleType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Taper 1 Bolt: Taper 1 Bolt], [Taper 2 Bolt: Taper 2 Bolt], [Taper 3 Bolt: Taper 3 Bolt], ... 9 more ...)
• PoleMaterial (type: esriFieldTypeString, alias: PoleMaterial, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Aluminium: Aluminium], [Concrete: Concrete], [Galvanized: Galvanized], ... 2 more ...)
• PoleHeight (type: esriFieldTypeSmallInteger, alias: PoleHeight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ArmLength (type: esriFieldTypeSmallInteger, alias: ArmLength, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: 3'], [6: 6'], [8: 8'], ... 13 more ...)
• LightFunction (type: esriFieldTypeString, alias: LightFunction, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Flood Light: Flood Light], [Park Light: Park Light], [Parking Lot Light: Parking Lot Light], ... 3 more ...)
• NumberofHeads (type: esriFieldTypeSmallInteger, alias: NumberOfLamps, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 1 more ...)
• LampType (type: esriFieldTypeString, alias: LampType, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [HPS: High Pressure Sodium], [LED: LED], [MH: Metal Halide], ... 2 more ...)
• Wattage (type: esriFieldTypeSmallInteger, alias: Wattage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Volts (type: esriFieldTypeSmallInteger, alias: Volts, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [120: 120V], [240: 240V], [277: 277V], ... 1 more ...)
• Base (type: esriFieldTypeString, alias: Base, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Anchor: Anchor], [Buried: Buried])
• Fixture (type: esriFieldTypeString, alias: Fixture, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Cobra: Cobra], [Ornamental: Ornamental], [Park Dome: Park Dome], ... 1 more ...)
• ControlType (type: esriFieldTypeString, alias: ControlType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PEC: Photo Electronic Control], [Time Clock: Time Clock])
• HasBeacon (type: esriFieldTypeString, alias: HasBeacon, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• IsFused (type: esriFieldTypeString, alias: IsFused, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• IsUnderground (type: esriFieldTypeString, alias: IsUnderground, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• IsMetered (type: esriFieldTypeString, alias: IsMetered, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• HasStencil (type: esriFieldTypeString, alias: HasStencil, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• HasSticker (type: esriFieldTypeString, alias: HasSticker, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• RateSchedule (type: esriFieldTypeString, alias: RateSchedule, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [LS1-A: LS1-A], [LS1-B: LS1-B], [LS1-C: LS1-C], ... 4 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• POINT_X (type: esriFieldTypeDouble, alias: POINT_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POINT_Y (type: esriFieldTypeDouble, alias: POINT_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NoVehicleHds (type: esriFieldTypeSmallInteger, alias: NoVehicleHds, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 8])
• NoPedHds (type: esriFieldTypeSmallInteger, alias: NoPedHds, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2])
• NoPedButtons (type: esriFieldTypeSmallInteger, alias: NoPedButtons, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2], ... 1 more ...)
• IsTrafficSignal (type: esriFieldTypeString, alias: IsTrafficSignal, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• hasHandPoleCover (type: esriFieldTypeString, alias: HandPoleCover, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• isStreetlight (type: esriFieldTypeString, alias: isStreetlight, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• SmallCellCarrier (type: esriFieldTypeString, alias: SmallCellCarrier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Verizon: Verizon], [ATT: ATT], [Crown Castle: Crown Castle], ... 1 more ...)
• hasFlagHolder (type: esriFieldTypeString, alias: hasFlagHolder, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• FlagHolderInstallDate (type: esriFieldTypeDate, alias: FlagHolderInstallDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• hasSafeRouteBanner (type: esriFieldTypeString, alias: hasSafeRouteBanner, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• SmallCellStatus (type: esriFieldTypeString, alias: SmallCellStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Active: Active], [Proposed: Proposed], [No Small Cell: No Small Cell], ... 2 more ...)

Templates:

Name: Flag on Traffic Pole
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Status: Active
• OwnedBy: Cupertino
• MaintainedBy: Cupertino
• UpdateBy: CURTIS
• isStreetlight: Y

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/31/2020 10:57:32 PM

Schema Last Edit Date: 8/31/2020 10:57:32 PM

Data Last Edit Date: 8/31/2020 10:57:32 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat