Name: Cabinets

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

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: -9812776.8569
YMin: 5128960.6707
XMax: -9812494.597
YMax: 5129331.2175
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"6b7965d3-3358-4a28-8457-289a4b5fab0c","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAdUlEQVRIie2VsQkAIQxFLRzAMisI2fEcMjukNRscEQxnlSbCFXmNYvE+/ubXcpm6L4g4IsVENCxA5QDwtNZC5MyszhViP1B5771EISLrtIBb1AzwyIpcsiKXrMglK/pRRcwcJp1zngG6nbqhe+YiOEb/+xDNC1d9Id/H/OQcAAAAAElFTkSuQmCC","contentType":"image/png","width":18,"height":18,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: false

Has Attachments: true

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: Cabinet ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• intersectionid (type: esriFieldTypeString, alias: Intersection ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• type (type: esriFieldTypeString, alias: Cabinet Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ATC: ATC], [Caltrans TEES: Caltrans TEES], [NEMA: NEMA], ... 3 more ...)
• controller (type: esriFieldTypeString, alias: Controller Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [TS 1: TS 1], [TS 2 Type 1: TS 2 Type 1], [TS 2 Type 2: TS 2 Type 2], ... 6 more ...)
• primaryuse (type: esriFieldTypeString, alias: Primary Use, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Sign: Sign], [Signal: Signal], [Streetlight: Streetlight], ... 3 more ...)
• manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• warrantydate (type: esriFieldTypeDate, alias: Warranty Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ups (type: esriFieldTypeString, alias: UPS Power Supply, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• mountmethod (type: esriFieldTypeString, alias: Mounting Method, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Ground: Ground], [Pole: Pole], [Wall: Wall], ... 2 more ...)
• locdesc (type: esriFieldTypeString, alias: Nearest Location, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• district (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• maintainedby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• collectedby (type: esriFieldTypeSmallInteger, alias: Collected By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• inspectdate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• condition (type: esriFieldTypeSmallInteger, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Very Good], [4: Good], [3: Fair], ... 3 more ...)
• maintenance (type: esriFieldTypeString, alias: Needs Maintenance, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• replacement (type: esriFieldTypeString, alias: Needs Replacement, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• retired (type: esriFieldTypeString, alias: Is Retired, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Cabinets
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ups: No
• ownedby: 0
• maintainedby: 0
• collectedby: 0
• maintenance: No
• replacement: No
• retired: No

Relationships:

• Signals (1) -- Related To: Signals (0)
• Streetlights (6) -- Related To: Streetlights (2)
• Maintenance (8) -- Related To: CabinetMaintenance (8)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/30/2024 11:35:52 AM

Schema Last Edit Date: 7/14/2025 11:13:06 PM

Data Last Edit Date: 7/22/2025 9:38:49 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat