Name: cc_streetlights

Display Field: FieldBook_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 6426135.1571238
YMin: 1814234.14280573
XMax: 6449712.25996357
YMax: 1836712.54757729
Spatial Reference: 102645 (2229)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[82,0,163,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FieldBook_ID (type: esriFieldTypeString, alias: FIELD BOOK ID, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• Facility_Id (type: esriFieldTypeString, alias: FACILITY ID, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [IN-SERVICE: IN-SERVICE], [ABANDONED: ABANDONED], [KNOCKED DOWN: KNOCKED DOWN], ... 2 more ...)
• Type (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1-A: 1-A], [1-B: 1-B], [1-C: 1-C], ... 21 more ...)
• General_Mounting (type: esriFieldTypeString, alias: GENERAL MOUNTING, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true, Coded Values: [ACORN: ACORN], [COBRA: COBRA], [MANSARD: MANSARD], ... 1 more ...)
• Lamp_Type (type: esriFieldTypeString, alias: LAMP TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [LED: LED], [HPS: HPS], [INDUCTION: INDUCTION], ... 3 more ...)
• Fixture_Type (type: esriFieldTypeString, alias: FIXTURE TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Fixture_Height (type: esriFieldTypeDouble, alias: FIXTURE HEIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Height (type: esriFieldTypeDouble, alias: HEIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Manufacturer (type: esriFieldTypeString, alias: MANUFACTURER, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Pole_Material (type: esriFieldTypeString, alias: POLE MATERIAL, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [CONCRETE: CONCRETE], [STEEL: STEEL], [WOOD: WOOD], ... 2 more ...)
• Double_Arm (type: esriFieldTypeString, alias: DOUBLE ARM, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO])
• Voltage (type: esriFieldTypeString, alias: VOLTAGE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [H: H], [L: L], [OTHER: OTHER], ... 1 more ...)
• Real_Voltage (type: esriFieldTypeString, alias: REAL VOLTAGE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Wattage (type: esriFieldTypeString, alias: WATTAGE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Traffic_Signal (type: esriFieldTypeString, alias: TRAFFIC SIGNAL, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO])
• Lamp_Install_Date (type: esriFieldTypeDate, alias: LAMP INSTALL DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Streetlight_Install_Date (type: esriFieldTypeDate, alias: STREETLIGHT INSTALL DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Condition (type: esriFieldTypeString, alias: CONDITION, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• GPS_Date (type: esriFieldTypeDate, alias: GPS DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Road (type: esriFieldTypeString, alias: ROAD, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ARTERIAL: ARTERIAL], [RESIDENTIAL: RESIDENTIAL])
• Street_Location (type: esriFieldTypeString, alias: STREET LOCATION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Corner (type: esriFieldTypeString, alias: CORNER, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO])
• Photocell_Installed (type: esriFieldTypeString, alias: PHOTOCELL INSTALLED, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO])
• Photocell_Type (type: esriFieldTypeString, alias: PHOTOCELL TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Photocell_Install_By (type: esriFieldTypeString, alias: PHOTOCELL INSTALL BY, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• Photocell_Install_Date (type: esriFieldTypeDate, alias: PHOTOCELL INSTALL DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ServicePoint_ID (type: esriFieldTypeString, alias: SERVICE POINT ID, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• ServicePoint_Location (type: esriFieldTypeString, alias: SERVICE POINT LOCATION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ServiceCabinet_MeterNo (type: esriFieldTypeString, alias: SERVICE CABINET METER NO, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• Metered (type: esriFieldTypeString, alias: METERED, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [METERED: METERED], [UNMETERED: UNMETERED], [OTHER: OTHER], ... 1 more ...)
• SCE_RatePlan (type: esriFieldTypeString, alias: SCE RATE SCHEDULE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AL-2: AL-2], [LS-1: LS-1], [LS-2: LS-2], ... 4 more ...)
• SCE_Service_Account_No (type: esriFieldTypeString, alias: SCE SERVICE ACCOUNT NO, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• SCE_Service_Account_BP (type: esriFieldTypeString, alias: SCE SERVICE ACCOUNT BP, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• SCE_Customer_Account_No_A (type: esriFieldTypeString, alias: SCE CUSTOMER ACCOUNT NO A, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• SCE_Customer_Account_No_B (type: esriFieldTypeString, alias: SCE CUSTOMER ACCOUNT NO B, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• SCE_Rate (type: esriFieldTypeString, alias: SCE RATE, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• LADWP_Service (type: esriFieldTypeString, alias: LADWP SERVICE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO])
• Owner (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 65, nullable: true, editable: true, Coded Values: [CULVER CITY: CULVER CITY], [CITY OF LA: CITY OF LA], [CALTRANS: CALTRANS], ... 5 more ...)
• Maintained (type: esriFieldTypeString, alias: MAINTAINED, SQL Type: sqlTypeOther, length: 65, nullable: true, editable: true, Coded Values: [CULVER CITY: CULVER CITY], [CITY OF LA: CITY OF LA], [LA COUNTY: LA COUNTY], ... 1 more ...)
• Data_Source (type: esriFieldTypeString, alias: DATA SOURCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AERIAL PHOTO: AERIAL PHOTO], [CCTV: CCTV], [FIELD/SITE VISIT: FIELD/SITE VISIT], ... 4 more ...)
• Project_No (type: esriFieldTypeString, alias: PROJECT NO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Drawing_No (type: esriFieldTypeString, alias: DRAWING NO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Sheet_No (type: esriFieldTypeString, alias: SHEET NO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Sign_Date (type: esriFieldTypeDate, alias: SIGN DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ProjectTitle (type: esriFieldTypeString, alias: PROJECT TITLE, SQL Type: sqlTypeOther, length: 350, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 400, nullable: true, editable: true)
• DocLink1 (type: esriFieldTypeString, alias: DOCUMENT LINK 1, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• DocLink2 (type: esriFieldTypeString, alias: DOCUMENT LINK 2, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• DocLink3 (type: esriFieldTypeString, alias: DOCUMENT LINK 3, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• PhotoLink (type: esriFieldTypeString, alias: PHOTO LINK, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: LATITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: LONGITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Rotation (type: esriFieldTypeDouble, alias: ROTATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: CREATED USER, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: CREATED DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: LAST EDITED USER, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: LAST EDITED DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Reference_ID (type: esriFieldTypeString, alias: REFERENCE ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Small_Cell_Site (type: esriFieldTypeString, alias: Small Cell Site Vacancy Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Utility_Company (type: esriFieldTypeString, alias: Utility_Company, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CC_Permit_No (type: esriFieldTypeString, alias: CC_Permit_No, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Appl_Date (type: esriFieldTypeDate, alias: Application Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Name: cc_streetlights
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/7/2024 6:42:28 PM

Schema Last Edit Date: 2/7/2024 6:42:28 PM

Data Last Edit Date: 10/3/2019 1:54:42 PM

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